Select box causing query error?

Referring to this thread http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56335#305025 I wanted to pass a variable to a dynamic select box, so I changed this: <option value="'#SITEID#'" selected=#sid#> to <option value="#SITEID#"<cfif SITEID EQ sid> selected="selected"</cfif>> and now get "Error Executing Database Query...... Too few parameters.  Expected 1." The query: SELECT <CFLOOP list="#form.parameters#" index="i">sitedata.#i#,</CFLOOP>   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   <CFIF form.siteid gt "">AND sitedata.SITEID in (#PreserveSingleQuotes(form.siteid)#)</CFIF>   <CFIF startdate gt "" AND enddate gt "">AND sitedata.monitordate >= #startdate# and sitedata.monitordate <= #enddate#</CFIF>   <CFIF startdate gt "" AND enddate is "">AND sitedata.monitordate >= #startdate#</CFIF>   ORDER BY sitedata.monitordate, sitedata.siteid I admit I'm not a CF or SQL expert!  I'm guessing it has something to do with the cfloop.  Hoping this is something simple I've overlooked... TIA

Referring to this thread http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56335#305025 I wanted to pass a variable to a dynamic select box, so I changed this: <option value="'#SITEID#'" selected=#sid#> to <option value="#SITEID#"<cfif SITEID EQ sid> selected="selected"</cfif>> and now get "Error Executing Database Query...... Too few parameters.  Expected 1." The query: SELECT <CFLOOP list="#form.parameters#" index="i">sitedata.#i#,</CFLOOP>   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   <CFIF form.siteid gt "">AND sitedata.SITEID in (#PreserveSingleQuotes(form.siteid)#)</CFIF>   <CFIF startdate gt "" AND enddate gt "">AND sitedata.monitordate >= #startdate# and sitedata.monitordate <= #enddate#</CFIF>   <CFIF startdate gt "" AND enddate is "">AND sitedata.monitordate >= #startdate#</CFIF>   ORDER BY sitedata.monitordate, sitedata.siteid I admit I'm not a CF or SQL expert!  I'm guessing it has something to do with the cfloop.  Hoping this is something simple I've overlooked... TIA