is there anyway to be able to just select some text in a textarea then click a button and get it to put the html bold tags round the selected test??
i.e. (before button click)
Hello there
(after button click)
<b>Hello there</b>
does that make sense??
Milkstr
Last Activity: Oct 31 '07, 07:25 AM
Joined: Sep 25 '06
Location:
-
Thanks for the reply, not quite what i was after, am wanting an exmple of a message box like the one used on this forum for posting threads, where the user selects some text within the textarea then click a button to apply the tag, after an exmple of how to do this in html...Leave a comment:
-
How to format text in textarea?
i'm looking to write a textarea that formatted text can be created in, similair to the text area used in here to post new threads, i then am going to store the text in a sql data base. can anyone show me a simple way of when an area of text is highlited then i click the bold icon it wraps the selected text in a bold tag?? I know its prob simple, but an example would be good! thanks -
Post Form Information Without Clicking Submit??
I have a page with a form, a couple of hidden fields and a submit button, the information in the hidden fields i want to submit automatically without clicking the submit button, is there a way of simulating the button been clicked???
Its becuse i dont want the user to alter any thing on the page but it to be submitted automatically
<input type="submit" name="Submit" value="Submit" />... -
Thanks for you explaination, very usefull, i am indeed using SQL 2000, i i guest i'm a little stuck. I thought what i was doing was quite straight forward but it apppears not to be!
I've tried using a sub query but didn't have much joy.
Can you suggest anything else that will get me going?? i'm only wrting a simple forum. (i dont have to use the table function, this was only a suggestion to me, if there is a better way for the fuction...Leave a comment:
-
Calling Function From Stored Procdure ???
I'm a total novice with SQL, so please bare with me.
I'm trying to write a simple forum for my web site, i've done it before using Access but struggling to use the same idea with SQL. In acces i had one table for all the post and replies, i then had several querys that filtered off just the main topics and the number of replies for each thread. I did this by using multiple queries joined together, i've now found out that in SQL you cant call... -
Thanks, the functions works, but still struggling to get the stored procdure to work
CREATE PROCEDURE Forum2 AS
SELECT forum.ForumID, forum.ID, forum.partID, Countofusers.Co untOfID,forum.s ubject, forum.author, forum.message, forum.responder , forum.dtdate, forum.ipaddress , forum.PicID
FROM (forum LEFT JOIN Countofusers() as countOfUsers ON forum.ID = Countofusers.Pa rtID)
i get "Invalid...Leave a comment:
-
Can anyone help??? PleaseLeave a comment:
-
Sorry to be a pain, but i'm still getting an error
Error -2147217900
Incorrect syntax near the keyword 'WHERE'.
I'm using 1and1 as my provider and its MS SQL 2000 server, when i go to the user defined functions is prompts me with this
CREATE FUNCTION [Function Name]
RETURNS (return_type_sp ec) AS
BEGIN
(FUNCTION BODY)
END
Can You Help Please!Leave a comment:
-
thanks for that, i'm getting an error, it just says
Incorrect syntax near 'RETURNS'.
do i then write a function call in my store procdure to call this???
FROM (forum LEFT JOIN Countofusers ON forum.ID = Countofusers.Pa rtID) INNER JOIN NumberPosts ON forum.author = NumberPosts.aut hor;
this is the line i need to use it withLeave a comment:
-
Stored Procdures
is it possible in MS SQL to write a stored procdure that uses the FROM statment to get imformation from an existing stored procdure, at the moment i get invaild object as it seem to only like the FROM statment to be a table. I have made sure all the names i'm using are unique. I did a test in access (novis at SQL) an the sql statment it shows just has the query name no reference to wheather it was a table or query, please help, an example would be... -
Stored Procdures MS SQL
Can anyone help, i'm just starting out with MS SQL on a new web page and i'm having problems writing a stored procdure, its for a simple forum on a web page.
I have a table with the main forum information, i then have a stored procdure
"SELECT Count(forum.ID) AS CountOfID, forum.partID
FROM forum
GROUP BY forum.partID
HAVING (((forum.partID )<>0));"
this is to work out which... -
SQL Connection with Dreamweaver
I'm a complete novice with SQL, i'm currently using Access and Dreamweaver to create my seb site, but i want to switch my database to SQL for increase speed. I'm at a complete blank at the moment on how to connect to my service providers MS SQL server (1 and 1 hosting) I have imported my access database to the SQL database on the web hosting, but i cent seem to connect dreamweaver to it using the connection string provided. With access i have a copy... -
Thanks for your help there!!! I just can't quite get it to work, i get an error from the standard Module, on the line "myRs.MoveFirst " it errors there saying "no current record" any ideas what it could be? i've used all the same names as you in your example??Leave a comment:
-
Multiple | FixtureID | GameDate | Odds | ResultHomeAwayD raw |
5 | 1 | 24/03/2007 | 140 | Home
10 | 1 | 24/03/2007 | 140 | Home
10 | 7 | 24/03/2007 | 130 | Home
70 | 5 | 24/03/2007 | ...Leave a comment:
-
Multiple | FixtureID | GameDate | Odds | ResultHomeAwayD raw | Win
5 | 1 24/03/2007 140 Home 0
10 1 24/03/2007 140 Home 0
10 7 24/03/2007 130 Home 0
70 1 24/03/2007 140 Home 1
70 5 24/03/2007 200 Home 0
70 6 24/03/2007 120 Home 0
This is the list of the current query, where the "multiple" colum = 70 for example i want the 140 * 200 * 120 displayed.....i .e. where the "Multiple"...Leave a comment:
-
Thanks for the speedy reply, but not quite what i was after, the fields i want the product of are on seperate records, so in the query there could just be for example 2 records filtered off, or there could be 5 filtered off and i want the product of the field regardless of how many potential records there is, hope that makes sense. Any Ides???Leave a comment:
-
How do i calculate the Product of several fields???
Hi
I have a query off a database that works fins and displays a list of 4 numbers in the query in seperate fields, however i only want 1 field to be displayed and that wants to be the PRODUCT of the other 4 i.e. field1 * field2 * field3 * field4.....at some point this could need to be more numbers. Excel has an easy function "=PRODUCT" is there away of doing this in Acess????? -
Passing Dynamic Text using Query String???
is it possible to pass dynamic text through the query string command??
I know you can just pass a variale through a link
eg.
www.text1.com/text1.asp?usern ame="Mike"
but i want to use the dynamic text from a repaeting region something like
www.text1.com/text1.asp?<%=(t empDB.fields.it em("username"). value%>
this works kind of it shows the name in the next page, but... -
Can a hiddenField's name be a Variable?
I have a repeating region with a hiddenfield on each line, i want to start a counter in my reapeating reagion so that the hiddenfield becomes unique on each line. So that is the reapeating region goe to say 10 records i actually have 10 hiddenfields with unique names.
I thought i could just set a variable at the start of the loop that increments on each time, but i'm unsure what the syntax should be
the name of the hiddenfield is "hiddenfiel d",...
No activity results to display
Leave a comment: