I've created the stored procedure in the Enterprise Manager on our Dev Server.
Its the same code that's used on our live site so I know it works. However,
Coldfusion returns an error that says the stored procedure cannot be found.
Another thing : is that when I go to run the stored procedure again ( see code
below ), it tells me that it cannot find it in the system catalog. ( whatever
that means ). But it DOES appear in the stored procedure list.
Checked permissions and they seem fine as well.
Code at top of the stored procedure...
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Get_Adverts' AND uid =
user_id('myuid') AND type = 'P') DROP PROCEDURE Get_Adverts
GO
..... remaining code in here
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209393
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
