SQL Error Question - won't insert record 1

[wilcoHead]

Below is my form, following is the action page then the error.

I have checked my spelling etc. Can anyone find the problem?

Thanks,

---------------------------------------------------------
<FORM ACTION="pickdays.cfm" METHOD="post" NAME="add">
<TABLE BORDER="0" CELLSPACING="3" CELLPADDING="3" ALIGN="center" STYLE="border-bottom: 1px solid Gray;">
<TR>
<TD>
<CFOUTPUT><INPUT TYPE="hidden" NAME="TeeTimeDaysID" VALUE="#GetDay.TeeTimeDaysID#"></CFOUTPUT>

<INPUT TYPE="hidden" NAME="TeeTimeDropID" VALUE="51">
1:06
</TD>
<TD>
<SELECT NAME="MemberIDOne" STYLE="border: 1px solid Gray;">
<Option VALUE="" SELECTED="selected"></Option>
<Option VALUE="X">X</Option>
<CFOUTPUT QUERY="GetMember">
<Option VALUE="#MemberID#">#MemberLastName#</Option>
</CFOUTPUT>
</SELECT>
</TD>

<TD>
<SELECT NAME="MemberIDTwo" STYLE="border: 1px solid Gray;">
<Option VALUE="" SELECTED="selected"></Option>
<Option VALUE="X">X</Option>
<CFOUTPUT QUERY="GetMember">
<Option VALUE="#MemberID#">#MemberLastName#</Option>
</CFOUTPUT>
</SELECT>
</TD>

<TD>
<SELECT NAME="MemberIDThree" STYLE="border: 1px solid Gray;">
<Option VALUE="" SELECTED="selected"></Option>
<Option VALUE="X">X</Option>
<CFOUTPUT QUERY="GetMember">
<Option VALUE="#MemberID#">#MemberLastName#</Option>
</CFOUTPUT>
</SELECT>
</TD>

<TD>
<SELECT NAME="MemberIDFour" STYLE="border: 1px solid Gray;">
<Option VALUE="" SELECTED="selected"></Option>
<Option VALUE="X">X</Option>
<CFOUTPUT QUERY="GetMember">
<Option VALUE="#MemberID#">#MemberLastName#</Option>
</CFOUTPUT>
</SELECT>
</TD>
</TR>
</TABLE>
<BR>
<DIV ALIGN="center"><INPUT TYPE="submit" NAME="add" VALUE="add" STYLE="border: 1px solid Black;">&nbsp;&nbsp;<INPUT TYPE="reset" NAME="Reset" VALUE="Reset" STYLE="border: 1px solid Black;"></DIV>
</FORM>

------------------------------------------------------------------------
ACTION PAGE
------------------------------------------------------------------------
<CFQUERY NAME="AddDay" DATASOURCE="RochesterCCDB" DBTYPE="ODBC">
INSERT INTO TeeTimeChart
(TeeTimeDaysID)

VALUES (#FORM.TeeTimeDaysID#)
</CFQUERY>

<CFQUERY NAME="GetTeeTimeChart" DBTYPE="ODBC" DATASOURCE="RochesterCCDB">
SELECT TeeTimeDaysID,
TeeTimeChartID

FROM TeeTimeChart

WHERE TeeTimeDaysID = #FORM.TeeTimeDaysID#
</CFQUERY>


<CFQUERY NAME="AddTimeDetail" DATASOURCE="RochesterCCDB" DBTYPE="ODBC">
INSERT INTO TeeTimeChartDetail
(TeeTimeChartID,
MemberIDOne,
MemberIDTwo,
MemberIDThree,
MemberIDFour,
TeeTimeDropID)

VALUES (#GetTeeTimeChart.TeeTimeChartID#,
#FORM.MemberIDOne#,
#FORM.MemberIDTwo#,
#FORM.MemberIDThree#,
#FORM.MemberIDFour#,
#FORM.TeeTimeDropID#)
</CFQUERY>
-------------------------------------------------------------------------
ERROR
-------------------------------------------------------------------------
PickDays.cfm: line 35

33 : #FORM.MemberIDThree#,
34 : #FORM.MemberIDFour#,
35 : #FORM.TeeTimeDropID#)
36 : </CFQUERY>
37 : </CFIF>



--------------------------------------------------------------------------------

SQL INSERT INTO TeeTimeChartDetail (TeeTimeChartID, MemberIDOne, MemberIDTwo, MemberIDThree, MemberIDFour, TeeTimeDropID) VALUES (6, X, 1, 2, 3, 51)
DATASOURCE RochesterCCDB
VENDORERRORCODE -3010
SQLSTATE 07002

Thanks for your input;
WilcoHEAD

 

[r937]

here's your problem -- VALUES (6, X, 1, 2, 3, 51)

without quotes, X is considered a column name

even with quotes, you might have trouble inserting a string into a numeric column

r937.com | rudy.ca

 

[wilcoHead]

ahhh yes. Thanks!

-Eric

Thanks for your input;
WilcoHEAD