Greg, Check your fields on the second insert. You are passing #address#
into City, #City# into State and #state# into Zip... are these correct?
Also, is BoatYear a Text field? if it's not, remove the ' 's that are
around the #boatyear# variable.
Hope this helps a little
> From: "gregg Kachel" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 5 Jul 2000 16:51:25 -0600
> 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?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
