> > Next I'd ask an Oracle guy exactly what a ORA-01480 is. > > From technet.oracle.com: > ORA-01480 trailing null missing from STR bind value > Cause: A bind variable of type 5 (null-terminated string) > does not contain the terminating null in its buffer. > Action: Terminate the string with a null character.
Are you sure there's nothing in the variable except the actual value? You might wrap the value with Trim: <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#Trim(myvar)#"> Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
