Re: Pre-populate select box causing query error

["Elfboy007" <webforumsuser@xxxxxxxxxxxxxx>]

OK, gotcha now (I was using cfdump earlier to do something similar).  The 
output is:
 SELECT 
sitedata.Ammonia,sitedata.Nitrate,sitedata.OrthoPhos,sitedata.DO_Str,sitedata.pH
_Str,sitedata.Temp_StrDO,sitedata.Turbidity,sitedata.Temp,sitedata.pH_Lab,siteda
ta.DO_Lab, site.coordinates_n, site.coordinates_w, sitedata.monitordate, 
site.name, site.siteid FROM site INNER JOIN sitedata ON site.siteid = 
sitedata.siteid WHERE sitedata.SITEID IS NOT NULL AND sitedata.SITEID in (CR04) 
ORDER BY sitedata.monitordate, sitedata.siteid

 Nothing jumps out at me.  Any ideas?