Recent content by Lothario

Try this: if request.form("query")>"" then queryname=Replace(request.form("queryname"),"'","''") queryvalue=Replace(request.form("queryvalue"),"'","''") objConn.execute("insert into rptQueries (queryname,queryvalue) values('" & queryname & "','" & queryvalue & "')") end if -L

Then try this... create two queries.. qry1 SELECT SEELCT ID, Title, Featured, DateandTime FROM myTable WHERE Featured ='Y' ORDER BY DateandTime DESC qry2 SELECT SEELCT ID, Title, Featured, DateandTime FROM myTable WHERE Featured ='N' ORDER BY DateandTime DESC Then do a union query...

ASP is a server side script...if you something like default button or user click events you need to use client side scripts...like Javascript or VBScript -L

Try this: SEELCT ID, Title, Featured, DateandTime FROM myTable ORDER BY Featured DESC, DateandTime DESC -L

You want your query look like this... INSERT INTO Meta_Data(Source,Contact) VALUES ('value1', 'value2') " where your value1="&frmSource&" so in query it should be a single quote and when u r getting your form varibale it shud be a double quote... -L

This should do it... sqlStatement = " INSERT INTO Meta_Data(Source,Contact) VALUES ('"&frmSource&"', '"&frmContact&"') " -L

You can use Javascript's self.close() to close the browser window... -L

Not a problem.. Glad i could of help. -L

Did you mean how to set the tab order?? for example if you have two fields on the form ...they can order 1 and 2 respectively using the tabindex property...something like shown below... <input type="text" name="state" size="23" tabindex="1"> <select size="1" name="zipcode" tabindex="2"> -L

I am glad i could be of help... -L

Wrap the fields with SERVER.HTMLENCODE where ever you have some special characters... for example.. 'What is your Pet Name?' if that field name is blah then....do '"&Server.htmlencode("blah")&"' -L

what is this '' 'helllllooooowor', are we mising a comma...between these two fields... -L

take a look at this thread... thread333-987253 -L

try this: http://www.serverwatch.com/tutorials/article.php/1482281 -L

even wrap the Password as [Password] because they are key words.. -L