HI I get the following error when i add the session field to my insert
statement. The session field on the form is populated by a query. The user
selects a session from the list and fills out and submits the form. The error
below is returned on submit. -thks -- jim

Syntax error in INSERT INTO statement.

The error occurred in C:\DesignSystems\pgs\register_insert.cfm: line 16

15 :
16 : <cfinsert datasource="designSystems"
tablename="crabEaglePointTrainingRegistration" formfields="full_name, email,
phone, county, session">
17 :
18 :
--

SQL insert into crabEaglePointTrainingRegistration
(full_name,email,phone,county,session) values ( (param 1) , (param 2) , (param
3) , (param 4) , (param 5) )
DATASOURCE designSystems
VENDORERRORCODE 3092
SQLSTATE &nbsp;




<!--- query to populate form field or register form--->

<cfquery name="qsession" datasource="designSystems">
SELECT *
FROM trainingRegistration
WHERE startdate >=Date()
ORDER BY startdate
</cfquery>

<!---session field code in form--->

<select name="session" id="session" title="session">


<option selected="selected">Select a session</option><cfoutput
query="qsession">
<option value="#session#">#session#</option></cfoutput>
</select>

<!---action page code--->

<cfinsert datasource="designSystems" tablename="trainingRegistration"
formfields="full_name, email, phone, county, session">

<cfoutput>
<p>Thank for registering for the #session#</p> </cfoutput>

Your session variable is probably conflicting with the session scope. Try renaming the session variable from your form to something else, like mySession.

changed the session field to mysession in database, form, and action page. Now the form page gives me a variable my session is undefined?

Can you post the form & db code again?

Also, do you get the error when initially viewing the form or after you submit it?

Thanks for your help.
I forgot to change the field name in the table that populated the session list to mysession.

Jim