> > Okay..this is interesting. The statement (and a couple punctuation > variations with/without quotes/semicolon, etc): > <cfoutput>insert into Student_Status (Student_ID,Status_ID) > values(#lastID#,#i#);</cfoutput> > > outputs this: insert into Student_Status (Student_ID,Status_ID) values( > and stops there with this error: > > Complex object types cannot be converted to simple values.
Could you post the GetLastId() method? My bet is that it is not returning what you expect it to... (i.e. a string or a number) Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:301522 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
