> It doesn't error if you don't use cfqueryparam? Works just fine if I don't use cfqueryparam.
> If x=1, what is the ":1" that comes out in the error msg, any idea? The ":1" is a numeric user id. At this point all I'm doing is looping over a valuelist of user ids. > 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. ______________________________________________________________________ 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=coldfusiona 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

