I have this:
<cfset lastID="#getLastID()#">
inside of the function immediately before the loop and indeed a cfdump
returns the correct/expected value. I have also tried "<cfset VAR...>
Greg Morphis wrote:
> Is this inside a cffunction? If not change
> <cfset var lastID="#getLastID()#">
> to
> <cfset lastID="#getLastID()#">
>
> and can you post the code for getLastID() ??
>
> It might be there..
>
>
> Thanks
>
> On Tue, Mar 18, 2008 at 12:34 PM, pauld581 <[EMAIL PROTECTED]> wrote:
>
>> 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:301526
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
