Paul..
try this...
wrap the query in <cfoutput>'s like
<cfoutput>
insert into Student_Status (Student_ID,Status_ID)
values ("#lastID#", "#i#")
</cfoutput>Take the output and run it in Access and see if you get the same error message.. On Tue, Mar 18, 2008 at 12:03 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > Also considering you said "I have also tried not using the > > CFqueryparam thing at all but that > doesn't work" > I don't think it's a cast issue... I think it's something else > > > On Tue, Mar 18, 2008 at 11:54 AM, Dominic Watson > <[EMAIL PROTECTED]> wrote: > > Hi Paul, what error message are you seeing? > > > > 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:301514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
