> <cfquery datasource="#siteowner#"> INSERT INTO InventoryData
> (SellerID, Crate, Weight, Size, Content) VALUES (#cookie.BoothSeller#,
> '#evaluate("FORM.CRATE" & i)#', '#evaluate("FORM.W" & i)#','#evaluate
> ("FORM.SZ" & i)#','#evaluate("FORM.D" & i)#')
> </cfquery>
>
>
>
> AH! I bet the evalutes are causing the single quotes to break the SQL
Yep, that would be my bet (even though I wouldn't have expected it).
You're very welcome.
Incidentally, you don't really need evaluate for that. I would recommend
using array-notation instead:
#form["d" & i]#
I'm reasonably certain that works on the form scope way way back, at
least 5, probably earlier.
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 503.236.3691
http://onTap.riaforge.org/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297961
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
