Gregg,
As others have pointed out, you're missing some commas and you've got an extra comma.
The best way to test queries is to do it directly in the database itself. If you're
using Access, use the query builder within Access to create and test queries. If it's
Microsoft's SQL, use iSQL/w.
Then copy and paste the queries over to a CFQUERY and make sure that there's no end of
statement ";".
By doing this, you'll be able to isolate your SQL coding errors from your CF coding
errors. Your life will become suddenly more peaceful. ;)
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: gregg Kachel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 06, 2000 8:18 AM
> To: [EMAIL PROTECTED]
> 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
