I tried it and I get this error: DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned: SQL0204N "ADMINISTRATOR.TBLDONE" is an undefined name. SQLSTATE=42704 SQL0204N "ADMINISTRATOR.TBLDONE " is an undefined name. the table does exist and is under the schema ADMINISTRATOR. Bruce On 5/4/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > > Drop the parenthesis around the select statement. > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2837 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
