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:301523
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
