Re: Date list using SQL IN operator

Ok, I figured out I should use ListQualify on the list to add the single quotes and preservesinglequotes within the query to preserve the quotes for revised code of: cfoutput query=checkForEmp21Overlap cfset overlapRecordCount=

Re: Adding elements to a structure

Thanks, Pascal.Your assumption was correct, and works great! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

QofQ syntax

I'm trying to do a query of queries like so: 68: cfquery name=getData dbtype=query 69: SELECT * from myQuery 70: WHERE myStart BETWEEN 71: (cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#DateAdd('D',iCount-1,startDate)# and 72: cfqueryparam

QofQ syntax

I'm trying to do a query of queries like so: 68: cfquery name=getData dbtype=query 69: SELECT * from myQuery 70: WHERE myStart BETWEEN 71: (cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#DateAdd('D',iCount-1,startDate)# and 72: cfqueryparam

QofQ syntax

I'm trying to do a query of queries like so: 68: cfquery name=getData dbtype=query 69: SELECT * from myQuery 70: WHERE myStart BETWEEN 71: (cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#DateAdd('D',iCount-1,startDate)# and 72: cfqueryparam