Search results for query: *

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

wrap UserID in []... [UserID] -L

Can you please erphrase your question and tell your requirements... Are you looking for something like...getting the users information from ActiveDirectory or LDAP Server... Not sure of your question... -L

Then why dont you sort the records before sending them to excel sheet... I mean do the sort in the query itself and then display on the excel sheet... -L

I meant this sql = "SELECT a.ProductID as prodid, b.ProductName as prodname FROM tblProducts a INNER JOIN tblSupports b on a.ProductID=b.ProductID WHERE a.ShortName='"&rsFind("ProductName")&"' " set rsFind = objConn.Execute(sql) Do While Not rsFind.EOF sql1 = "UPDATE tblSupports...

Try something like this... sql = "SELECT a.ProductID, b.ProductName FROM tblProducts a INNER JOIN tblSupports b on a.ProductID=b.ProductID WHERE a.ShortName='"&rsFind("ProductName")&"' " set rsFind = objConn.Execute(sql) Do While Not rsFind.EOF sql1 = "UPDATE tblSupports SET...