MySQL Forums
Forum List  »  Stored Procedures

Store Procedures ASP 3.0
Posted by: Dante Robles
Date: December 26, 2005 02:18AM

Hi Everyone

Sorry for my bad english , I have some Store procedures this Work Fine from Shell Cliente (Mysql) but i´m try to use with Active Server Pages and MyODBC 3.51.12 as a Follow

<%
Set db=Server.createobject("adodb.connection")
Db.open Application("conexion")

Db.execute ("CALL del_contacto(6);")

Db.close
Set db=nothing
%>

But do not work any sugestion ?

The Store Procedure is simple just DELETE Record from a table with a one parameter

CREATE PROCEDURE `del_contacto`(IN id1 INT(10))
BEGIN
DELETE FROM contacto WHERE id=id1;
END

I´m Using the follow version of MySQL

MySQL Server 5.0.17 For Windows
MyODBC 3.51.12 For windows
Active Server Pages 3.0

Thanks for everithing

Dante

Options: ReplyQuote


Subject
Views
Written By
Posted
Store Procedures ASP 3.0
2504
December 26, 2005 02:18AM
1461
December 26, 2005 04:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.