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.
The cfdumps are still correct. The insert statement with values(117,2)
works in Access.
Any ideas on what is happening with those vars?
Paul
Greg Morphis wrote:
> 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..
>
>
> O
> n 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:301521
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
