Pascal
> -----Original Message-----
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: 29 July 2004 16:33
> To: CF-Talk
> Subject: Problems with CFQUERYPARAM
>
> Rick Root wrote:
>
> > I'm having a problem with an update query in a web service in which
the
> > update doesn't seem to be performed.... I've output the SQL (by
> > returning it) and the SQL is correct and works when run within
SQL*Plus.
> >
> > I'm 100% positive that it's RUNNING the code and I can't figure out
why
> > it's not running.
>
> Okay, now we're on topic... after a little more debugging, I've found
> that my query works correctly if I do *NOT* use <CFQUERYPARAM> in the
> where clause.
>
> So this updates one record:
>
> WHERE
> prfid = #Arguments.PROFILEID#
> AND creator = '#UCASE(authRetVal.USERID)#'
>
> While this does NOT update any records:
>
> WHERE
> prfid = <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER"
> VALUE="#Arguments.PROFILEID#">
> AND creator = <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR"
> VALUE="#UCASE(authRetVal.USERID)#">
>
> I guess we can chalk this up to another reason I find using
CFQUERYPARAM
> to be difficult.
>
> This simply doesn't make any sense. It doesn't throw an error, so the
> data types must be okay... prfid is defined as NUMBER(38) in Oracle...
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
