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 Ricq Pattay [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities "To err is human, to forgive canine." ______________________________________________________________________ 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
