Gregg,
I realize you figured out the solution, but I would still advise that you refrain from
using CFINSERT as a matter of habit. Your SQL skills will improve dramatically when
you start using CFQUERY (and further still with stored procedures).
---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 1:41 PM
> To: [EMAIL PROTECTED]
> Subject: beginner question
>
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0107_01BFE68F.100F1940
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi, this should be an easy one. I am trying to insert information into =
> two tables with one form, but I can't seem to get it to work. This is =
> what I am trying to use:
>
> <CFINSERT DATASOURCE=3D"vhc" tablename=3D"members, memberlist"
>
> >
>
> But, it won't recognize a the second table. Can this be done? If so how? =
> Thanks alot.
>
>
> Gregg Kachel
> Webmaster
> www.houseboatmagazine.com
> www.houseboat.net
> www.pdbworld.com/
>
>
> ------=_NextPart_000_0107_01BFE68F.100F1940
> 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><FONT face=3DArial size=3D2>Hi, this should be an easy one. I am =
> trying to=20
> insert information into two tables with one form, but I can't seem to =
> get it to=20
> work. This is what I am trying to use:</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2><CFINSERT DATASOURCE=3D"vhc" =
> tablename=3D"members,=20
> memberlist"</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>But, it won't recognize a the second =
> table. Can=20
> this be done? If so how? Thanks alot.</FONT></DIV>
> <DIV> </DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Gregg Kachel<BR>Webmaster<BR><A=20
> href=3D"http://www.houseboatmagazine.com">www.houseboatmagazine.com</A><B=
> R><A=20
> href=3D"http://www.houseboat.net">www.houseboat.net</A><BR><A=20
> href=3D"http://www.pdbworld.com/">www.pdbworld.com/</A><BR></FONT></DIV><=
> /BODY></HTML>
>
> ------=_NextPart_000_0107_01BFE68F.100F1940--
>
> ------------------------------------------------------------------
> ------------
> 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.
