Gregg,
Please share the exact error message with us. I am speculating that you're not
entering data into every field of the table when you do the INSERT and that there are
fields in the table which require data.
If this is the case, you can solve the problem by changing the field attributes of the
cells in question to allow null values.
---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: Wednesday, July 05, 2000 3:51 PM
> To: [EMAIL PROTECTED]
> Subject: sigh, still not working
>
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_018F_01BFE6A1.41E1BF60
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi again, still can't get the sql statement to work to add information =
> to the two tables. I now get a syntax error or access violation. I think =
> the syntax is right, not sure what the access violation would be? Thanks =
> again
> =20
> =20
> <cfquery
> Datasource=3D"vhc">
> insert into members(firstname,lastname, username, password, =
> emailaddress)
> values=3D( '#firstname#', '#lastname#', '#username#', '#password#', =
> '#emailaddress#')
> </cfquery>
> <cfquery
> Datasource=3D"vhc">
> Datasource=3D"vhc">
> insert into memberlist(firstname,lastname, boat, year, city, state, zip, =
> emailaddress, phone)
> values=3D( '#firstname#', '#lastname#', '#boat#', '#boatyear#', =
> '#address#', '#city#', '#state#', #emailaddress#', '#phone#' )
> </cfquery>
>
> Gregg Kachel
>
> ------=_NextPart_000_018F_01BFE6A1.41E1BF60
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV>
> <DIV><FONT face=3DArial size=3D2>
> <DIV><FONT face=3DArial size=3D2>Hi again, still can't get the sql =
> statement to work=20
> to add information to the two tables. I now get a syntax error or access =
>
> violation. I think the syntax is right, not sure what the access =
> violation would=20
> be? Thanks again</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial =
> size=3D2><cfquery<BR>Datasource=3D"vhc"><BR>insert into=20
> members(firstname,lastname, username, password, =
> emailaddress)<BR>values=3D(=20
> '#firstname#', '#lastname#', '#username#', '#password#',=20
> '#emailaddress#')<BR></cfquery><BR><cfquery<BR>Datasource=3D"vhc=
> "><BR>Datasource=3D"vhc"><BR>insert=20
> into memberlist(firstname,lastname, boat, year, city, state, zip, =
> emailaddress,=20
> phone)<BR>values=3D( '#firstname#', '#lastname#', '#boat#', =
> '#boatyear#',=20
> '#address#', '#city#', '#state#', #emailaddress#', '#phone#'=20
> )<BR></cfquery></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Gregg=20
> Kachel</FONT></DIV></FONT></DIV></DIV></BODY></HTML>
>
> ------=_NextPart_000_018F_01BFE6A1.41E1BF60--
>
> ------------------------------------------------------------------
> ------------
> 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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
