Ricq Pattay wrote: >My query is this: >============================================= ><cfquery datasource="my_dsn" name="get_users"> >select * from vcross_user >where user_id = <CFQUERYPARAM VALUE="#x#" CFSQLTYPE="CF_SQL_NUMERIC"> ></cfquery> >============================================= > >The error I receive is this: >============================================= >Error Diagnostic Information >Oracle Error Code = 1480 > >ORA-01480: trailing null missing from STR bind value > >SQL = "select * from vcross_user where user_id = :1" > >Query Parameter Value(s) - > >Parameter #1 = 10 >============================================= > >Why? CF Server 5.0 on NT, Oracle 8i > wild stab, dbtype is not set in the cfquery *MAYBE*
______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
