hi greg, just noticed that you said you were using a mysql-connector-java-3.1.12.
i dont know if it makes any difference but i am using dreamweaver and have setup a mysql connection through it. Queries work fine but not the stored procedures. Do you think it may have something to do with the dreamweaver connection? how did you set up your connection, maybe i can try it that way? I have gone to the cf administrator and it is showing the database as a datasource so assume it has been setup fine though. thanks again greg, appreciate the help > >On 11/28/06, Richard White <[EMAIL PROTECTED]> wrote: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

