> Have you tried cf_sql_numeric ?
Actually it was on the string, which is a CHAR(8).... I changed it to
CF_SQL_CHAR, and it still didn't work... then I used LJustify() to pad
the value to 8 characters (it was only 6)...
so now THIS works:
WHERE
prfid = <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER"
VALUE="#Arguments.PROFILEID#">
AND creator = <CFQUERYPARAM CFSQLTYPE="CF_SQL_CHAR"
VALUE="#LJustify(UCASE(authRetVal.USERID),8)#">
I didn't consider this because neither Oracle NOR DB2 require that you
tack on the extra spaces when doing a regular query.. so
CREATOR='ADSRJR' works fine, even though the value of CREATOR is
actually 'ADSRJR ' in the database.
Learn something new every day.
- Rick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
