It looks as though you are missing a single quote around the #emailaddress#
and a comma after #phone #. Try this for the first query.
<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>
James McCullough
-----Original Message-----
From: Pavan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 5:31 PM
To: [EMAIL PROTECTED]
Subject: Re: still not working
Try to use cfinsert and use #form.firstname#......try to insert in all
columns...in the table
Pavan Kumar Puli
WebMaster/IT Manager
ABC Interactive
http://www.abcinteractive.com.au:
----- Original Message -----
From: gregg Kachel <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 07, 2000 1:18 AM
Subject
> 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.
------------------------------------------------------------------------------
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.
