><cfset ImageArray = arrayNew(1) /> ><cfset ImageArray[1] = "someGif.gif" /> ><cfset ImageArray[2] = "someJpg.jpg" /> > ><cfloop from="1" to="#arrayLen(ImageArray)#" index="i"> ><cfquery datasource="#dsn#"> >INSERT INTO images (filename) >VALUES (<cfqueryparam cfsqltype="cf_sql_varchar" value="#ImageArray[i]#">) ></cfquery> ></cfloop>
I've decided to create a makeimageprimary field in the table. It'll be a y- n value. How would I loop through a 2d array insert into the table? I'm going to give this a shot shortly. Thanks so much Joe! Will let you know how it comes out. Will > > >On Tue, 11 Jan 2005 15:21:59 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189987 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54