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 strongm 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: nix4
  • Order by date
  1. nix4

    SQL IN Command and Comma Delminated Lists

    I cannot pre-define a string for itemlist since thats exactly what Im searching for ...its a dynamic query. let me show you the undoctored version. <cfquery name=&quot;getspecials&quot; datasource=&quot;warehouse&quot; dbtype=&quot;ODBC&quot;> SELECT * FROM specials WHERE '#itemloop.ID#' IN...
  2. nix4

    SQL IN Command and Comma Delminated Lists

    I have a SQL Query in Cold Fusion: <cfquery name=&quot;getspecials&quot; datasource=&quot;warehouse&quot; dbtype=&quot;ODBC&quot;> SELECT * FROM specials WHERE 88 IN (Itemlist) AND TYPE = &quot;PM&quot; </cfquery> Itemlist is a field of Specials that contains a comma seperated list ie...

Part and Inventory Search

Back
Top