Question
Pre-populate 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 value to a dynamic select box (in a url), so I changed this:
<option value="'#SITEID#'" selected=#sid#>
to this:
<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
I wanted to pass a value to a dynamic select box (in a url), so I changed this:
<option value="'#SITEID#'" selected=#sid#>
to this:
<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
