>I suppose it's really a mssql question of trapping the generated message(s) >and putting them in a var which can be returned to CF. >How to do it though? There may be better alternatives but two possibilities are - capture the warnings using java/jdbc as Dinner suggested - create a stored procedure that uses xp_cmdshell and sqlcmd/osql (sql 2005/2000) to capture the messages and return them to cfstoredproc
Then parse the output messages Janet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
