Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Lothario
  • Order by date
  1. Lothario

    Saving query text to SQL table

    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
  2. Lothario

    SQL can this statement work

    ...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... SELECT * from qry1 UNION SELECT *...
  3. Lothario

    How to set a default button in asp

    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
  4. Lothario

    SQL can this statement work

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

    basic syntax help

    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
  6. Lothario

    basic syntax help

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

    Closing The Browser

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

    tab stops for controls on asp page!!

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

    tab stops for controls on asp page!!

    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
  10. Lothario

    URGENT: INSERT Statement errors.....

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

    URGENT: INSERT Statement errors.....

    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
  12. Lothario

    URGENT: INSERT Statement errors.....

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

    Eliminating Page footer and header

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

    active directory

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

    URGENT: INSERT Statement errors.....

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

    URGENT: INSERT Statement errors.....

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

    Find Clients Current User with ASP

    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
  18. Lothario

    Re:Displaying recordset in excel -date sort failing

    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
  19. Lothario

    ERROR...

    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...
  20. Lothario

    ERROR...

    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...

Part and Inventory Search

Back
Top