since their's INTs in the database, you can leave off the double quotes..
On Tue, Mar 18, 2008 at 12:08 PM, Greg Morphis <[EMAIL PROTECTED]> 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..
>
>
>
>
> 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:301516
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
