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!

  • Congratulations gkittelson 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: *

  1. markosimic

    very long queries

    Do you use msSQL server 7? i had the same problem mwith mssql 7 and, to be more misterious, it did not happen always, but just in some cases. Anyway, what I did was that I have replaced "between" with "greater-then and less-then" logic (R_Batch_Test_V.tDate BETWEEN...
  2. markosimic

    ADO Recordset and Stored Procedure

    When define an implicit recordset object by set adRS = adcmd.execute server will always create forward/read-only cursor To define dyamic cursor you need to create an so-called explicit recordset object set rs = Server.CreateObject("adodb.recordset") rs.cursortype = 3 (dynamic cursor)...

Part and Inventory Search

Back
Top