> 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 ______________________________________________________________________ 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
