I mentioned PreserveSingleQuotes()... if he was building the list and had single quotes! Was just trying to give him the options.. so he can understand what are the solutions and for what cases.!
Joe -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 21, 2002 3:54 PM To: CF-Talk Subject: RE: whats wrong with this query? > You need to use ListQualify('#Form.Pac#') or > PreserveSingleQuotes('#Form.Pac#') WHERE PACX IN (#listqualify(form.pac)#) ... In this case PreserveSingleQuotes() wouldn't likely work because I suspect there aren't single quotes in the form.pac variable to begin with... Isaac www.turnkey.to 954-776-0046 > Joe > -----Original Message----- > From: Freddy [mailto:[EMAIL PROTECTED]] > Sent: Sunday, July 21, 2002 1:12 PM > To: CF-Talk > Subject: whats wrong with this query? > I am wondering what I am doing wrong with this query to an > access > database. When I select only one option it works ...if I > select multiple > options it returns nothing. > <CFQUERY NAME="GetEvents1" DATASOURCE="#sid#"> > SELECT * > FROM calendarevents c > WHERE (StartMonth = #URL.CurrentMonth#) AND (StartYear = > #URL.CurrentYear#) > <cfif form.pac is not ""> > AND (PAC1 in ('#FORM.PAC#') OR PAC2 in ('#FORM.PAC#' ) OR > PAC3 in > ('#FORM.PAC#') OR PAC4 in ('#FORM.PAC#') OR PAC5 in > ('#FORM.PAC#') OR > PAC6 in ('#FORM.PAC#')) > </cfif> > ORDER BY StartMonth, StartDay ASC > </CFQUERY> > Thanks in advance, > Frederic > __________________________________________________________ > ____________ > Get the mailserver that powers this list at > http://www.coolfusion.com > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: > http://www.mail-archive.com/[email protected]/ > Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
