RE: Some troubles with my Query

ot;3" or a "5". ~Brad -Original Message- From: Scott Kuo [mailto:[EMAIL PROTECTED] Sent: Friday, December 21, 2007 4:33 PM To: CF-Talk Subject: Re: Some troubles with my Query Hmm what do you think would be a good solution to filtering out extra rows. It basically to

Re: Some troubles with my Query

Hmm what do you think would be a good solution to filtering out extra rows. It basically to find rows with numbers like 2 or 3 or 5 in the months column. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic re

RE: Some troubles with my Query

Friday, December 21, 2007 4:11 PM To: CF-Talk Subject: Re: Some troubles with my Query SELECT contractinfo.* , Buildings.* , Freqtype.* , matypes.* , groups.* , servicetypes.* FROM contractinfo Left Join Buildings on contractinfo.buildingcon = buildings.bid) Left Join Groups on Buildings.g

Re: Some troubles with my Query

SELECT contractinfo.* , Buildings.* , Freqtype.* , matypes.* , groups.* , servicetypes.* FROM contractinfo Left Join Buildings on contractinfo.buildingcon = buildings.bid) Left Join Groups on Buildings.group1 = groups.GID) Left Join matypes on contractinfo.matype = matypes.matkey) Left join

RE: Some troubles with my Query

> "Element MONTHS is undefined in CONTRACTINFO" in my query. > > So basically at the WHERE part it complaining about: > (#Listfind(contractinfo.months, form.Monthselect, "/")# > 0) > > contractinfo.months are a text list that outputs like: > 1/2/3/4/5 etc form.monthselect is a value from a from

Some troubles with my Query

Hi, I am not sure why I am getting a "Element MONTHS is undefined in CONTRACTINFO" in my query. So basically at the WHERE part it complaining about: (#Listfind(contractinfo.months, form.Monthselect, "/")# > 0) contractinfo.months are a text list that outputs like: 1/2/3/4/5 etc form.monthselect