Question
SQL Insert issues
I have a simple insert that is not working what so ever.
Here is my code:
<form action="emails.cfm" method="post" >
<input name="emailAddress" type="text" id="email_address" />
<input name="firstName" type="text" id="firstname" />
<input name="lastName" type="text" id="lastname" />
<input name="addEmail" type="submit" id="addEmail" value="Add Email">
</form>
emails.cfm code:
<cfquery name="addEmail" datasource="karavel">
Insert Into Emails (email_address,firstname,lastname)
Values('#Trim(FORM.emailAddress)#', '#Trim(FORM.firstName)#', '#Trim(FORM.lastName)#',)
</cfquery>
I keep getting an error saying that there is a syntax error in my insert into statement. Any ideas?
error msg:
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
The error occurred in C:\Websites\177371xx6\upgrade\emails.cfm: line 3
1 : <cfquery name="addEmail" datasource="karavel">
2 : Insert Into Emails (email_address,firstname,lastname)
3 : Values(#Trim(FORM.emailAddress)#, #Trim(FORM.firstName)#, #Trim(FORM.lastName)#,)
4 : </cfquery>
SQLSTATE 42000
SQL Insert Into Emails (email_address,firstname,lastname) Values(hh, hh, hh,)
VENDORERRORCODE -3502
DATASOURCE karavel
Resources:
Here is my code:
<form action="emails.cfm" method="post" >
<input name="emailAddress" type="text" id="email_address" />
<input name="firstName" type="text" id="firstname" />
<input name="lastName" type="text" id="lastname" />
<input name="addEmail" type="submit" id="addEmail" value="Add Email">
</form>
emails.cfm code:
<cfquery name="addEmail" datasource="karavel">
Insert Into Emails (email_address,firstname,lastname)
Values('#Trim(FORM.emailAddress)#', '#Trim(FORM.firstName)#', '#Trim(FORM.lastName)#',)
</cfquery>
I keep getting an error saying that there is a syntax error in my insert into statement. Any ideas?
error msg:
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
The error occurred in C:\Websites\177371xx6\upgrade\emails.cfm: line 3
1 : <cfquery name="addEmail" datasource="karavel">
2 : Insert Into Emails (email_address,firstname,lastname)
3 : Values(#Trim(FORM.emailAddress)#, #Trim(FORM.firstName)#, #Trim(FORM.lastName)#,)
4 : </cfquery>
SQLSTATE 42000
SQL Insert Into Emails (email_address,firstname,lastname) Values(hh, hh, hh,)
VENDORERRORCODE -3502
DATASOURCE karavel
Resources:
