This is a multi-part message in MIME format.
------=_NextPart_000_0164_01C0345B.AEE2C7A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Re: SESSION Vars to FORM vars
CFINSERT uses the FORM Scope. It would be substantially easier to use a
standard CFQUERY with an INSERT statement to accomplish this task.
DC
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 14:41
To: CF-Talk
Subject: Re: SESSION Vars to FORM vars
On 10/12/00, Joshua Miller penned:
>Any way to take a whole set of variables and store them in the FORM scope
>without a CFSET for each variable?
>I need to output all the session variables to a database using cfinsert
and
>I believe they have to be converted to FORM.scope before you can do this
...
>or is that wrong?
>
>eg: <cfset FORM.foo=#SESSION.foo#>
cfinsert inserts from a query. You could build a dynamic query with
QueryNew, QueryAddRow, QuerySetCell
Seems like it would be easier to build a regular insert and just
insert the session variable values. Am I missing something?
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--------------------------------------------------------------------------
----
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.
------=_NextPart_000_0164_01C0345B.AEE2C7A0
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><TITLE>Re: SESSION Vars to FORM vars</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR></HEAD>
<BODY>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D158064914-12102000>CFINSERT uses the FORM Scope. It would =
be=20
substantially easier to use a standard CFQUERY with an INSERT statement =
to=20
accomplish this task.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D158064914-12102000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D158064914-12102000>DC</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Bud=20
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Thursday, October =
12, 2000=20
14:41<BR><B>To:</B> CF-Talk<BR><B>Subject:</B> Re: SESSION Vars to =
FORM=20
vars<BR><BR></DIV></FONT>
<P><FONT size=3D2>On 10/12/00, Joshua Miller penned:</FONT> <BR><FONT=20
size=3D2>>Any way to take a whole set of variables and store them =
in the FORM=20
scope</FONT> <BR><FONT size=3D2>>without a CFSET for each =
variable?</FONT>=20
<BR><FONT size=3D2>>I need to output all the session variables to a =
database=20
using cfinsert and</FONT> <BR><FONT size=3D2>>I believe they have =
to be=20
converted to FORM.scope before you can do this ...</FONT> <BR><FONT=20
size=3D2>>or is that wrong?</FONT> <BR><FONT size=3D2>></FONT> =
<BR><FONT=20
size=3D2>>eg: <cfset FORM.foo=3D#SESSION.foo#></FONT> </P>
<P><FONT size=3D2>cfinsert inserts from a query. You could build a =
dynamic query=20
with </FONT><BR><FONT size=3D2>QueryNew, QueryAddRow, =
QuerySetCell</FONT> </P>
<P><FONT size=3D2>Seems like it would be easier to build a regular =
insert and=20
just </FONT><BR><FONT size=3D2>insert the session variable values. Am =
I missing=20
something?</FONT> <BR><FONT size=3D2>-- </FONT></P>
<P><FONT size=3D2>Bud Schneehagen - Tropical Web Creations</FONT> </P>
<P><FONT size=3D2>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/</FONT> =
<BR><FONT=20
size=3D2>ColdFusion Solutions / eCommerce Development</FONT> <BR><FONT =
size=3D2>[EMAIL PROTECTED]</FONT> <BR><FONT size=3D2><A=20
href=3D"http://www.twcreations.com/"=20
target=3D_blank>http://www.twcreations.com/</A></FONT> <BR><FONT=20
size=3D2>954.721.3452</FONT> <BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/[email protected]/"=20
=
target=3D_blank>http://www.mail-archive.com/[email protected]/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0164_01C0345B.AEE2C7A0--
------------------------------------------------------------------------------
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.
