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.
