Elliot, Glad to hear that this worked for you. One question for you is "DUAL" a real table with no records or a Oracle special statement?
Thank Daniel > insert into ER_Test > ( iID, vchText) > select 1, 'test 1' FROM DUAL > union all > select 2, 'test 2' FROM DUAL > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]