Actually you have an EXTRA comma in yout INSERT line:
You have an extra comma after the emailaddress and before the ).
insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress, )
Should be:
insert into memberlist(firstname,lastname, boat, boatyear, address, city,
phone, state, zip, emailaddress )
----- Original Message -----
From: "gregg Kachel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 06, 2000 11:18 AM
Subject: still not working
: Hi, thanks for all of your help. I'm still struggling with the connecting
: the two tables. I did as Mark suggested and checked for required fields,
the
: only one I have is the primary keys wich are autonumbered (memberid for
: memberlist, id for members) I linked the tables together with memberID but
: that doesn't seem to help. Also as Nick suggested I took out the ''s from
: my number fields, and put the inserts in correct order. So far this is
what
: i have:
: <cfquery
: Datasource="vhc">
:
: insert into memberlist(firstname,lastname, boat, boatyear, address, city,
: phone, state, zip, emailaddress, )
: values( '#firstname#', '#lastname#', '#boat#', #boatyear#, '#address#',
: '#city#', '#phone#' '#state#',#zip#, #emailaddress#')
: </cfquery>
:
: <cfquery
: Datasource="vhc">
: insert into members(firstname,lastname, username, password, emailaddress)
: values( '#firstname#', '#lastname#', '#username#', '#password#',
: '#emailaddress#')
: </cfquery>
:
: The error is:
: ODBC Error Code = 37000 (Syntax error or access violation)
:
:
: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
: statement.
:
:
:
: The error occurred while processing an element with a general identifier
of
: (CFQUERY), occupying document position (2:1) to (3:17).
:
:
: Date/Time: 07/06/00 09:26:49
: Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
: Remote Address: 192.168.0.55
: HTTP Referer: http://www.houseboatmagazine.com/admin/vhc/newaddprofile.cfm
: Template: D:\Inetpub\wwwroot\CFDOCS\a
: Web\houseboat\admin\vhc\newaddprofile2.cfm
:
: Thanks again, I'm getting very frustrating, I know this should be fairly
: easy and straight forward.
:
: Gregg
:
: --------------------------------------------------------------------------
----
: Archives: http://www.mail-archive.com/[email protected]/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
