<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> -Joe On Tue, 11 Jan 2005 15:21:59 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote: > >>she said she might want up to three images per item > > > >Yep, but aren't clients notorious for saying "Wait, I meant five!"? > > > > > Yes indeed! I'm going to turn this into an array, then insert it. Might need > some help looping it into the table. :) > > I've only practiced with simple arrays, never really had a use for them until > now. > > Thanks, > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189981 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
