> > I am passing this to:
> > <cfloop list="#Form.songTitle#" index="item"> <cfquery
> > name="current_week" datasource="#dsdata#" username="myname"
> > password="mypwd">
> > INSERT INTO current_week (song_title)
> > VALUES ('#item#')
> > </cfquery>
> > </cfloop>
>
> I'm not seeing where to shoe-horn the week_of value into the
> above loop, there may be 5 or 6 song_title(s) just not seeing
> the syntax for it..
Is "week_of" a field in the current_week table? If so, you can add it to
that INSERT statement. If it's a field in another table, and you want to
update the value, put another query outside your CFLOOP to do this.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272298
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
