MySQL Forums
Forum List  »  Stored Procedures

Stored Procedure
Posted by: Bryan Batts
Date: November 08, 2015 08:28AM

Hello All,

I'm having trouble with the below stored proc.

delimiter //

drop procedure if exists sp_BlogsGet_DateTime//
create procedure sp_BlogsGet_DateTime
(
SBlogDate varchar(19),
EBlogDate varchar(19)
)
begin
select * from Blogs where (PublishDate > @SBlogDate and PublishDate < @EBlogDate);
end//

When I call it from my asp.net application is returns no records. However, If i copy the exact same query and run it as a command text, it get the desired results.

Any ideas?

Thanks in advance for you help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored Procedure
2409
November 08, 2015 08:28AM
795
November 08, 2015 08:35AM
786
November 08, 2015 12:48PM
680
November 08, 2015 04:45PM


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.