field names (I can't remember if Access supports this fully or at all
tho' - but I think it should, it's a very basic part of SQL).
Once you have that you should be able to leverage the "ArrayToList()"
and "ListQualify()" to format the Array properly.
Jim Davis
-----Original Message-----
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 11:07 PM
To: CF-Talk
Subject: How to an Array or List directly to a DB record?
V 4.51
MS Access
For the sake of reducing the volume of code -- can you, and if you can,
how
do you enter, via CFQUERY, an Array or List directly to a DB record?
Something like the following
<CFQUERY NAME="myTask" DATASOURCE="myDS">
INSERT INTO mytable (Field1, Field2, Field3, Field4, etc ) <!--- Can
you
also avoid naming the fields? --->
VALUES ('#Data#') <!--- "Data" is either an Array or a List --->
</CFQUERY>
Thanks,
Nick
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
