In creating a complex query I wanted to first put all the where clause into a string. Then when its done put it in the query.
simple example. <cfSet sWhere = "where office = '90'"> <cfQuery ...> Select * from MyTable #sWhere# </cfQuery> The query bombs and in the debug code it shows two sets of quotes around 90. office = ''90'' What am I doing wrong? -- Cheers Glenn Shukster (Logic Fundamentals Inc.) Thornhill, Ont. Canada Phone:(905)771-6458 Fax:(905)771-6819 www.logicfundamentals.com President of TDUG www.tdug.com - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Glenn Shukster <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
