[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.inetserver.asp.db

michael kors bags nx105

Katadedajab

12/27/2013 1:14:00 PM

<a href=http://www.martinet-finewines.com/mk5.html><b&... kors outlet</b></a>Of course a little as though your on the internet and site but bear in mind your family should to learn more about take a multi function be on the lookout at going to be the spelling everywhere in the several for instance your posts. Several for example them are rife allowing you to have spelling issues and I to find aspect ach and every troublesome to educate yourself regarding inform the reality then again I¡¯ll definitely can be bought again again.<a href=http://www.martinet-finewines.com/mk5.html><b&... kors handbags</b></a>
<a href=http://www.martinet-finewines.com/mk5.html><b&... kors outlet</b></a>I believe that going to be the same way,if you find that it be the case the same man we're talking?Thankful also his comment and views, always allowing an individual wisdom and, moreover,to have great understanding<a href=http://www.partyservicedallas.com/mk19.html><b&... kors handbags</b></a>
<a href=http://www.martinet-finewines.com/mk5.html><b&... kors outlet</b></a>Hope this condition tend to be solved as part of your hospital. So simple and fast for more information regarding schedulae an appoitment with,going to be the doctor is not at all possible to learn each patient's condition. Hope a number of us can be able to get a good deal more benefiting.<a href=http://www.thewizardofart.com/mkstore.html><b&... kors factory outlet</b></a>
<a href=http://www.partyservicedallas.com/mk19.html><b&... kors outlet</b></a>Very is fantastic article!I was searching as well as for an all in one in line with the insert on but take heart and get started I schedulae an appoitment with I am don now.Manny Thanks too this basically!<a href=http://www.martinet-finewines.com/mk5.html><... michael kors handbags</b></a>
10 Answers

CSharp Agentman

9/21/2007 6:05:00 PM

0

You should be getting the return value back, however there must be something
else wrong in your code, are you getting any exceptions??
Also Note: that, your SP will always return "Will Delete this measure" ,
"3"
No matter what. You are not assigning anything to @cnt

you need to

set @cnt = (SELECT COUNT(MeasureID)
FROM Measure
WHERE SiteProjectID = @SiteProjectID
AND MeasureID = @MeasureID
AND ApprovedDt IS NULL
)


"Madison" <Madison@discussions.microsoft.com> wrote in message
news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
> Thank you for your reply.
>
> The stored procedure, I posted just the testing to see if I can get any
> result back from SQL Server which it's working find. I do not want to put
> a
> lot of coding and cannot tell which part is not working.
>
> Here is the stored procedure that I will use it
>
> ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
>
> @SiteProjectID Int,
> @MeasureID Int,
> @mess VarChar(255) OUTPUT,
> @ret Int OUTPUT
>
> AS
>
> BEGIN
>
> -- SET NOCOUNT ON added to prevent extra result sets from
> -- interfering with SELECT statements.
> SET NOCOUNT ON;
>
> DECLARE @cnt int
>
> SELECT COUNT(MeasureID)
> FROM Measure
> WHERE SiteProjectID = @SiteProjectID
> AND MeasureID = @MeasureID
> AND ApprovedDt IS NULL
>
> IF @cnt = 0
> BEGIN
> SET @mess = 'Measure has been approved...'
> SET @ret = 1
> RETURN
> END
>
> ELSE
> BEGIN
> SELECT COUNT(MeasureID)
> FROM Measure
> WHERE SiteProjectID = @SiteProjectID
> AND MeasureID = @MeasureID
> AND ImplementedDt IS NULL
> IF @cnt = 0
> BEGIN
> SET @mess = 'Measure has been implemented...'
> SET @ret = 2
> RETURN
> END
>
> ELSE
> BEGIN
> -- My DELETE statement will go here
> SET @mess = 'Will Delete this measure'
> SET @ret = 3
> RETURN
> END
> END
>
> END
>
>
> 'ireturn = e.Command.Parameters("@ret").Value is commented out. Because
> it
> will do nothing if the first one did not work.
>
> I have try both to remove Null or have Null, It still not working.
>
> Any ideas. Thanks.
>
>
> "OZI" wrote:
>
> 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>
> why InputOutput when it is only Output
> remove = null
>
> Is the sp you are showing the actual sp you are using.
>


CSharp Agentman

9/21/2007 6:12:00 PM

0

Also how can you be sure that your datasource is executing your stored
procedure at all
Have you done any debugging in your code.


"Madison" <Madison@discussions.microsoft.com> wrote in message
news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
> Thank you for your reply.
>
> The stored procedure, I posted just the testing to see if I can get any
> result back from SQL Server which it's working find. I do not want to put
> a
> lot of coding and cannot tell which part is not working.
>
> Here is the stored procedure that I will use it
>
> ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
>
> @SiteProjectID Int,
> @MeasureID Int,
> @mess VarChar(255) OUTPUT,
> @ret Int OUTPUT
>
> AS
>
> BEGIN
>
> -- SET NOCOUNT ON added to prevent extra result sets from
> -- interfering with SELECT statements.
> SET NOCOUNT ON;
>
> DECLARE @cnt int
>
> SELECT COUNT(MeasureID)
> FROM Measure
> WHERE SiteProjectID = @SiteProjectID
> AND MeasureID = @MeasureID
> AND ApprovedDt IS NULL
>
> IF @cnt = 0
> BEGIN
> SET @mess = 'Measure has been approved...'
> SET @ret = 1
> RETURN
> END
>
> ELSE
> BEGIN
> SELECT COUNT(MeasureID)
> FROM Measure
> WHERE SiteProjectID = @SiteProjectID
> AND MeasureID = @MeasureID
> AND ImplementedDt IS NULL
> IF @cnt = 0
> BEGIN
> SET @mess = 'Measure has been implemented...'
> SET @ret = 2
> RETURN
> END
>
> ELSE
> BEGIN
> -- My DELETE statement will go here
> SET @mess = 'Will Delete this measure'
> SET @ret = 3
> RETURN
> END
> END
>
> END
>
>
> 'ireturn = e.Command.Parameters("@ret").Value is commented out. Because
> it
> will do nothing if the first one did not work.
>
> I have try both to remove Null or have Null, It still not working.
>
> Any ideas. Thanks.
>
>
> "OZI" wrote:
>
> 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>
> why InputOutput when it is only Output
> remove = null
>
> Is the sp you are showing the actual sp you are using.
>


Madison

9/21/2007 7:24:00 PM

0

Hi OZI,
Thank you for you reply. I forgot to set @cnt = my select when I post the
code. I still did not get any things back. I did not get any Exceptions from
the system. When I go
to debug mode I see that I get in Protected Sub SqlDataSource1_Deleted(ByVal
sender As Object, ByVal e As
system.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
SqlDataSource1.Deleted and e.Command.Parameters("@mess").Value has value with
system.DBNull
But with e.Command.Parameters("@mess") in debug has Direction = Input
I do not know what is going wrong. Or this is the bug???
Please help, thanks.

"OZI" wrote:

> Also how can you be sure that your datasource is executing your stored
> procedure at all
> Have you done any debugging in your code.
>
>
> "Madison" <Madison@discussions.microsoft.com> wrote in message
> news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
> > Thank you for your reply.
> >
> > The stored procedure, I posted just the testing to see if I can get any
> > result back from SQL Server which it's working find. I do not want to put
> > a
> > lot of coding and cannot tell which part is not working.
> >
> > Here is the stored procedure that I will use it
> >
> > ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
> >
> > @SiteProjectID Int,
> > @MeasureID Int,
> > @mess VarChar(255) OUTPUT,
> > @ret Int OUTPUT
> >
> > AS
> >
> > BEGIN
> >
> > -- SET NOCOUNT ON added to prevent extra result sets from
> > -- interfering with SELECT statements.
> > SET NOCOUNT ON;
> >
> > DECLARE @cnt int
> >
> > SELECT COUNT(MeasureID)
> > FROM Measure
> > WHERE SiteProjectID = @SiteProjectID
> > AND MeasureID = @MeasureID
> > AND ApprovedDt IS NULL
> >
> > IF @cnt = 0
> > BEGIN
> > SET @mess = 'Measure has been approved...'
> > SET @ret = 1
> > RETURN
> > END
> >
> > ELSE
> > BEGIN
> > SELECT COUNT(MeasureID)
> > FROM Measure
> > WHERE SiteProjectID = @SiteProjectID
> > AND MeasureID = @MeasureID
> > AND ImplementedDt IS NULL
> > IF @cnt = 0
> > BEGIN
> > SET @mess = 'Measure has been implemented...'
> > SET @ret = 2
> > RETURN
> > END
> >
> > ELSE
> > BEGIN
> > -- My DELETE statement will go here
> > SET @mess = 'Will Delete this measure'
> > SET @ret = 3
> > RETURN
> > END
> > END
> >
> > END
> >
> >
> > 'ireturn = e.Command.Parameters("@ret").Value is commented out. Because
> > it
> > will do nothing if the first one did not work.
> >
> > I have try both to remove Null or have Null, It still not working.
> >
> > Any ideas. Thanks.
> >
> >
> > "OZI" wrote:
> >
> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
> >
> > why InputOutput when it is only Output
> > remove = null
> >
> > Is the sp you are showing the actual sp you are using.
> >
>
>
>

CSharp Agentman

9/21/2007 8:29:00 PM

0

You might be running the wrong file or pointing to the wrong database.
start stripping your page down to the bare minimum to find this bug.
It is impossible to figure this one out when we don't have full code and the
same environment.

Also you can possibly debug and step into your stored procedure.

or you can create a temp table in SQL and in your SP add an insert to the
temp table to make sure your sp is executing. check if the insert worked.

of possibly your SqlDataSource is being Initialized before you get your data
from your Parameters.

good luck


"Madison" <Madison@discussions.microsoft.com> wrote in message
news:5E3DC256-999B-4C34-911C-B1FEB5E64629@microsoft.com...
> Hi OZI,
> Thank you for you reply. I forgot to set @cnt = my select when I post the
> code. I still did not get any things back. I did not get any Exceptions
> from
> the system. When I go
> to debug mode I see that I get in Protected Sub
> SqlDataSource1_Deleted(ByVal
> sender As Object, ByVal e As
> system.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
> SqlDataSource1.Deleted and e.Command.Parameters("@mess").Value has value
> with
> system.DBNull
> But with e.Command.Parameters("@mess") in debug has Direction = Input
> I do not know what is going wrong. Or this is the bug???
> Please help, thanks.
>
> "OZI" wrote:
>
>> Also how can you be sure that your datasource is executing your stored
>> procedure at all
>> Have you done any debugging in your code.
>>
>>
>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>> news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
>> > Thank you for your reply.
>> >
>> > The stored procedure, I posted just the testing to see if I can get any
>> > result back from SQL Server which it's working find. I do not want to
>> > put
>> > a
>> > lot of coding and cannot tell which part is not working.
>> >
>> > Here is the stored procedure that I will use it
>> >
>> > ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
>> >
>> > @SiteProjectID Int,
>> > @MeasureID Int,
>> > @mess VarChar(255) OUTPUT,
>> > @ret Int OUTPUT
>> >
>> > AS
>> >
>> > BEGIN
>> >
>> > -- SET NOCOUNT ON added to prevent extra result sets from
>> > -- interfering with SELECT statements.
>> > SET NOCOUNT ON;
>> >
>> > DECLARE @cnt int
>> >
>> > SELECT COUNT(MeasureID)
>> > FROM Measure
>> > WHERE SiteProjectID = @SiteProjectID
>> > AND MeasureID = @MeasureID
>> > AND ApprovedDt IS NULL
>> >
>> > IF @cnt = 0
>> > BEGIN
>> > SET @mess = 'Measure has been approved...'
>> > SET @ret = 1
>> > RETURN
>> > END
>> >
>> > ELSE
>> > BEGIN
>> > SELECT COUNT(MeasureID)
>> > FROM Measure
>> > WHERE SiteProjectID = @SiteProjectID
>> > AND MeasureID = @MeasureID
>> > AND ImplementedDt IS NULL
>> > IF @cnt = 0
>> > BEGIN
>> > SET @mess = 'Measure has been implemented...'
>> > SET @ret = 2
>> > RETURN
>> > END
>> >
>> > ELSE
>> > BEGIN
>> > -- My DELETE statement will go here
>> > SET @mess = 'Will Delete this measure'
>> > SET @ret = 3
>> > RETURN
>> > END
>> > END
>> >
>> > END
>> >
>> >
>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>> > Because
>> > it
>> > will do nothing if the first one did not work.
>> >
>> > I have try both to remove Null or have Null, It still not working.
>> >
>> > Any ideas. Thanks.
>> >
>> >
>> > "OZI" wrote:
>> >
>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>> >
>> > why InputOutput when it is only Output
>> > remove = null
>> >
>> > Is the sp you are showing the actual sp you are using.
>> >
>>
>>
>>


Madison

9/21/2007 8:46:00 PM

0

Hi OZI,
Thank you very much.
I will try to debug and step into the stored procedure. If it is not working
I will go back to the old way by not using SqlDataSource. I though I could
use new technology in framework2 to make coding faster but instead I spent
almost 2 days try it. I knew that if I use connectionstring everything will
work fine.

Thank you again for your help.

"OZI" wrote:

> You might be running the wrong file or pointing to the wrong database.
> start stripping your page down to the bare minimum to find this bug.
> It is impossible to figure this one out when we don't have full code and the
> same environment.
>
> Also you can possibly debug and step into your stored procedure.
>
> or you can create a temp table in SQL and in your SP add an insert to the
> temp table to make sure your sp is executing. check if the insert worked.
>
> of possibly your SqlDataSource is being Initialized before you get your data
> from your Parameters.
>
> good luck
>
>
> "Madison" <Madison@discussions.microsoft.com> wrote in message
> news:5E3DC256-999B-4C34-911C-B1FEB5E64629@microsoft.com...
> > Hi OZI,
> > Thank you for you reply. I forgot to set @cnt = my select when I post the
> > code. I still did not get any things back. I did not get any Exceptions
> > from
> > the system. When I go
> > to debug mode I see that I get in Protected Sub
> > SqlDataSource1_Deleted(ByVal
> > sender As Object, ByVal e As
> > system.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
> > SqlDataSource1.Deleted and e.Command.Parameters("@mess").Value has value
> > with
> > system.DBNull
> > But with e.Command.Parameters("@mess") in debug has Direction = Input
> > I do not know what is going wrong. Or this is the bug???
> > Please help, thanks.
> >
> > "OZI" wrote:
> >
> >> Also how can you be sure that your datasource is executing your stored
> >> procedure at all
> >> Have you done any debugging in your code.
> >>
> >>
> >> "Madison" <Madison@discussions.microsoft.com> wrote in message
> >> news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
> >> > Thank you for your reply.
> >> >
> >> > The stored procedure, I posted just the testing to see if I can get any
> >> > result back from SQL Server which it's working find. I do not want to
> >> > put
> >> > a
> >> > lot of coding and cannot tell which part is not working.
> >> >
> >> > Here is the stored procedure that I will use it
> >> >
> >> > ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
> >> >
> >> > @SiteProjectID Int,
> >> > @MeasureID Int,
> >> > @mess VarChar(255) OUTPUT,
> >> > @ret Int OUTPUT
> >> >
> >> > AS
> >> >
> >> > BEGIN
> >> >
> >> > -- SET NOCOUNT ON added to prevent extra result sets from
> >> > -- interfering with SELECT statements.
> >> > SET NOCOUNT ON;
> >> >
> >> > DECLARE @cnt int
> >> >
> >> > SELECT COUNT(MeasureID)
> >> > FROM Measure
> >> > WHERE SiteProjectID = @SiteProjectID
> >> > AND MeasureID = @MeasureID
> >> > AND ApprovedDt IS NULL
> >> >
> >> > IF @cnt = 0
> >> > BEGIN
> >> > SET @mess = 'Measure has been approved...'
> >> > SET @ret = 1
> >> > RETURN
> >> > END
> >> >
> >> > ELSE
> >> > BEGIN
> >> > SELECT COUNT(MeasureID)
> >> > FROM Measure
> >> > WHERE SiteProjectID = @SiteProjectID
> >> > AND MeasureID = @MeasureID
> >> > AND ImplementedDt IS NULL
> >> > IF @cnt = 0
> >> > BEGIN
> >> > SET @mess = 'Measure has been implemented...'
> >> > SET @ret = 2
> >> > RETURN
> >> > END
> >> >
> >> > ELSE
> >> > BEGIN
> >> > -- My DELETE statement will go here
> >> > SET @mess = 'Will Delete this measure'
> >> > SET @ret = 3
> >> > RETURN
> >> > END
> >> > END
> >> >
> >> > END
> >> >
> >> >
> >> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
> >> > Because
> >> > it
> >> > will do nothing if the first one did not work.
> >> >
> >> > I have try both to remove Null or have Null, It still not working.
> >> >
> >> > Any ideas. Thanks.
> >> >
> >> >
> >> > "OZI" wrote:
> >> >
> >> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
> >> >
> >> > why InputOutput when it is only Output
> >> > remove = null
> >> >
> >> > Is the sp you are showing the actual sp you are using.
> >> >
> >>
> >>
> >>
>
>
>

CSharp Agentman

9/21/2007 9:00:00 PM

0

I know what you are saying it is frustrating,

Have you seen this link... some few people and few tricks, claiming that it
works.

http://forums.asp.net/p/990266/16...

http://www.thescripts.com/forum/thread3...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=199680&am...

http://geekswithblogs.net/chrishan/archive/2005/07/16/...



"Madison" <Madison@discussions.microsoft.com> wrote in message
news:825897D1-6E5A-48EB-A078-32489C401044@microsoft.com...
> Hi OZI,
> Thank you very much.
> I will try to debug and step into the stored procedure. If it is not
> working
> I will go back to the old way by not using SqlDataSource. I though I could
> use new technology in framework2 to make coding faster but instead I spent
> almost 2 days try it. I knew that if I use connectionstring everything
> will
> work fine.
>
> Thank you again for your help.
>
> "OZI" wrote:
>
>> You might be running the wrong file or pointing to the wrong database.
>> start stripping your page down to the bare minimum to find this bug.
>> It is impossible to figure this one out when we don't have full code and
>> the
>> same environment.
>>
>> Also you can possibly debug and step into your stored procedure.
>>
>> or you can create a temp table in SQL and in your SP add an insert to the
>> temp table to make sure your sp is executing. check if the insert
>> worked.
>>
>> of possibly your SqlDataSource is being Initialized before you get your
>> data
>> from your Parameters.
>>
>> good luck
>>
>>
>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>> news:5E3DC256-999B-4C34-911C-B1FEB5E64629@microsoft.com...
>> > Hi OZI,
>> > Thank you for you reply. I forgot to set @cnt = my select when I post
>> > the
>> > code. I still did not get any things back. I did not get any Exceptions
>> > from
>> > the system. When I go
>> > to debug mode I see that I get in Protected Sub
>> > SqlDataSource1_Deleted(ByVal
>> > sender As Object, ByVal e As
>> > system.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
>> > SqlDataSource1.Deleted and e.Command.Parameters("@mess").Value has
>> > value
>> > with
>> > system.DBNull
>> > But with e.Command.Parameters("@mess") in debug has Direction = Input
>> > I do not know what is going wrong. Or this is the bug???
>> > Please help, thanks.
>> >
>> > "OZI" wrote:
>> >
>> >> Also how can you be sure that your datasource is executing your stored
>> >> procedure at all
>> >> Have you done any debugging in your code.
>> >>
>> >>
>> >> "Madison" <Madison@discussions.microsoft.com> wrote in message
>> >> news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
>> >> > Thank you for your reply.
>> >> >
>> >> > The stored procedure, I posted just the testing to see if I can get
>> >> > any
>> >> > result back from SQL Server which it's working find. I do not want
>> >> > to
>> >> > put
>> >> > a
>> >> > lot of coding and cannot tell which part is not working.
>> >> >
>> >> > Here is the stored procedure that I will use it
>> >> >
>> >> > ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
>> >> >
>> >> > @SiteProjectID Int,
>> >> > @MeasureID Int,
>> >> > @mess VarChar(255) OUTPUT,
>> >> > @ret Int OUTPUT
>> >> >
>> >> > AS
>> >> >
>> >> > BEGIN
>> >> >
>> >> > -- SET NOCOUNT ON added to prevent extra result sets from
>> >> > -- interfering with SELECT statements.
>> >> > SET NOCOUNT ON;
>> >> >
>> >> > DECLARE @cnt int
>> >> >
>> >> > SELECT COUNT(MeasureID)
>> >> > FROM Measure
>> >> > WHERE SiteProjectID = @SiteProjectID
>> >> > AND MeasureID = @MeasureID
>> >> > AND ApprovedDt IS NULL
>> >> >
>> >> > IF @cnt = 0
>> >> > BEGIN
>> >> > SET @mess = 'Measure has been approved...'
>> >> > SET @ret = 1
>> >> > RETURN
>> >> > END
>> >> >
>> >> > ELSE
>> >> > BEGIN
>> >> > SELECT COUNT(MeasureID)
>> >> > FROM Measure
>> >> > WHERE SiteProjectID = @SiteProjectID
>> >> > AND MeasureID = @MeasureID
>> >> > AND ImplementedDt IS NULL
>> >> > IF @cnt = 0
>> >> > BEGIN
>> >> > SET @mess = 'Measure has been implemented...'
>> >> > SET @ret = 2
>> >> > RETURN
>> >> > END
>> >> >
>> >> > ELSE
>> >> > BEGIN
>> >> > -- My DELETE statement will go here
>> >> > SET @mess = 'Will Delete this measure'
>> >> > SET @ret = 3
>> >> > RETURN
>> >> > END
>> >> > END
>> >> >
>> >> > END
>> >> >
>> >> >
>> >> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>> >> > Because
>> >> > it
>> >> > will do nothing if the first one did not work.
>> >> >
>> >> > I have try both to remove Null or have Null, It still not working.
>> >> >
>> >> > Any ideas. Thanks.
>> >> >
>> >> >
>> >> > "OZI" wrote:
>> >> >
>> >> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>> >> >
>> >> > why InputOutput when it is only Output
>> >> > remove = null
>> >> >
>> >> > Is the sp you are showing the actual sp you are using.
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>


William Vaughn

9/21/2007 10:50:00 PM

0

Ah, huh? When a SP creates a temp table, it's dropped when the SP ends.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"OZI" <sql_agentman@hotmail.com> wrote in message
news:eXOUn4I$HHA.5160@TK2MSFTNGP05.phx.gbl...
> You might be running the wrong file or pointing to the wrong database.
> start stripping your page down to the bare minimum to find this bug.
> It is impossible to figure this one out when we don't have full code and
> the same environment.
>
> Also you can possibly debug and step into your stored procedure.
>
> or you can create a temp table in SQL and in your SP add an insert to the
> temp table to make sure your sp is executing. check if the insert worked.
>
> of possibly your SqlDataSource is being Initialized before you get your
> data from your Parameters.
>
> good luck
>
>
> "Madison" <Madison@discussions.microsoft.com> wrote in message
> news:5E3DC256-999B-4C34-911C-B1FEB5E64629@microsoft.com...
>> Hi OZI,
>> Thank you for you reply. I forgot to set @cnt = my select when I post the
>> code. I still did not get any things back. I did not get any Exceptions
>> from
>> the system. When I go
>> to debug mode I see that I get in Protected Sub
>> SqlDataSource1_Deleted(ByVal
>> sender As Object, ByVal e As
>> system.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
>> SqlDataSource1.Deleted and e.Command.Parameters("@mess").Value has value
>> with
>> system.DBNull
>> But with e.Command.Parameters("@mess") in debug has Direction = Input
>> I do not know what is going wrong. Or this is the bug???
>> Please help, thanks.
>>
>> "OZI" wrote:
>>
>>> Also how can you be sure that your datasource is executing your stored
>>> procedure at all
>>> Have you done any debugging in your code.
>>>
>>>
>>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>>> news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
>>> > Thank you for your reply.
>>> >
>>> > The stored procedure, I posted just the testing to see if I can get
>>> > any
>>> > result back from SQL Server which it's working find. I do not want to
>>> > put
>>> > a
>>> > lot of coding and cannot tell which part is not working.
>>> >
>>> > Here is the stored procedure that I will use it
>>> >
>>> > ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
>>> >
>>> > @SiteProjectID Int,
>>> > @MeasureID Int,
>>> > @mess VarChar(255) OUTPUT,
>>> > @ret Int OUTPUT
>>> >
>>> > AS
>>> >
>>> > BEGIN
>>> >
>>> > -- SET NOCOUNT ON added to prevent extra result sets from
>>> > -- interfering with SELECT statements.
>>> > SET NOCOUNT ON;
>>> >
>>> > DECLARE @cnt int
>>> >
>>> > SELECT COUNT(MeasureID)
>>> > FROM Measure
>>> > WHERE SiteProjectID = @SiteProjectID
>>> > AND MeasureID = @MeasureID
>>> > AND ApprovedDt IS NULL
>>> >
>>> > IF @cnt = 0
>>> > BEGIN
>>> > SET @mess = 'Measure has been approved...'
>>> > SET @ret = 1
>>> > RETURN
>>> > END
>>> >
>>> > ELSE
>>> > BEGIN
>>> > SELECT COUNT(MeasureID)
>>> > FROM Measure
>>> > WHERE SiteProjectID = @SiteProjectID
>>> > AND MeasureID = @MeasureID
>>> > AND ImplementedDt IS NULL
>>> > IF @cnt = 0
>>> > BEGIN
>>> > SET @mess = 'Measure has been implemented...'
>>> > SET @ret = 2
>>> > RETURN
>>> > END
>>> >
>>> > ELSE
>>> > BEGIN
>>> > -- My DELETE statement will go here
>>> > SET @mess = 'Will Delete this measure'
>>> > SET @ret = 3
>>> > RETURN
>>> > END
>>> > END
>>> >
>>> > END
>>> >
>>> >
>>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>>> > Because
>>> > it
>>> > will do nothing if the first one did not work.
>>> >
>>> > I have try both to remove Null or have Null, It still not working.
>>> >
>>> > Any ideas. Thanks.
>>> >
>>> >
>>> > "OZI" wrote:
>>> >
>>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>>> >
>>> > why InputOutput when it is only Output
>>> > remove = null
>>> >
>>> > Is the sp you are showing the actual sp you are using.
>>> >
>>>
>>>
>>>
>
>

CSharp Agentman

9/21/2007 10:57:00 PM

0

sorry, I did not mean a temp table, Just a real table for temporary use.


"William Vaughn" <billvaNoSPAM@betav.com> wrote in message
news:%23oa5IHK$HHA.484@TK2MSFTNGP06.phx.gbl...
> Ah, huh? When a SP creates a temp table, it's dropped when the SP ends.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "OZI" <sql_agentman@hotmail.com> wrote in message
> news:eXOUn4I$HHA.5160@TK2MSFTNGP05.phx.gbl...
>> You might be running the wrong file or pointing to the wrong database.
>> start stripping your page down to the bare minimum to find this bug.
>> It is impossible to figure this one out when we don't have full code and
>> the same environment.
>>
>> Also you can possibly debug and step into your stored procedure.
>>
>> or you can create a temp table in SQL and in your SP add an insert to the
>> temp table to make sure your sp is executing. check if the insert
>> worked.
>>
>> of possibly your SqlDataSource is being Initialized before you get your
>> data from your Parameters.
>>
>> good luck
>>
>>
>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>> news:5E3DC256-999B-4C34-911C-B1FEB5E64629@microsoft.com...
>>> Hi OZI,
>>> Thank you for you reply. I forgot to set @cnt = my select when I post
>>> the
>>> code. I still did not get any things back. I did not get any Exceptions
>>> from
>>> the system. When I go
>>> to debug mode I see that I get in Protected Sub
>>> SqlDataSource1_Deleted(ByVal
>>> sender As Object, ByVal e As
>>> system.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
>>> SqlDataSource1.Deleted and e.Command.Parameters("@mess").Value has value
>>> with
>>> system.DBNull
>>> But with e.Command.Parameters("@mess") in debug has Direction = Input
>>> I do not know what is going wrong. Or this is the bug???
>>> Please help, thanks.
>>>
>>> "OZI" wrote:
>>>
>>>> Also how can you be sure that your datasource is executing your stored
>>>> procedure at all
>>>> Have you done any debugging in your code.
>>>>
>>>>
>>>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>>>> news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
>>>> > Thank you for your reply.
>>>> >
>>>> > The stored procedure, I posted just the testing to see if I can get
>>>> > any
>>>> > result back from SQL Server which it's working find. I do not want to
>>>> > put
>>>> > a
>>>> > lot of coding and cannot tell which part is not working.
>>>> >
>>>> > Here is the stored procedure that I will use it
>>>> >
>>>> > ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
>>>> >
>>>> > @SiteProjectID Int,
>>>> > @MeasureID Int,
>>>> > @mess VarChar(255) OUTPUT,
>>>> > @ret Int OUTPUT
>>>> >
>>>> > AS
>>>> >
>>>> > BEGIN
>>>> >
>>>> > -- SET NOCOUNT ON added to prevent extra result sets from
>>>> > -- interfering with SELECT statements.
>>>> > SET NOCOUNT ON;
>>>> >
>>>> > DECLARE @cnt int
>>>> >
>>>> > SELECT COUNT(MeasureID)
>>>> > FROM Measure
>>>> > WHERE SiteProjectID = @SiteProjectID
>>>> > AND MeasureID = @MeasureID
>>>> > AND ApprovedDt IS NULL
>>>> >
>>>> > IF @cnt = 0
>>>> > BEGIN
>>>> > SET @mess = 'Measure has been approved...'
>>>> > SET @ret = 1
>>>> > RETURN
>>>> > END
>>>> >
>>>> > ELSE
>>>> > BEGIN
>>>> > SELECT COUNT(MeasureID)
>>>> > FROM Measure
>>>> > WHERE SiteProjectID = @SiteProjectID
>>>> > AND MeasureID = @MeasureID
>>>> > AND ImplementedDt IS NULL
>>>> > IF @cnt = 0
>>>> > BEGIN
>>>> > SET @mess = 'Measure has been implemented...'
>>>> > SET @ret = 2
>>>> > RETURN
>>>> > END
>>>> >
>>>> > ELSE
>>>> > BEGIN
>>>> > -- My DELETE statement will go here
>>>> > SET @mess = 'Will Delete this measure'
>>>> > SET @ret = 3
>>>> > RETURN
>>>> > END
>>>> > END
>>>> >
>>>> > END
>>>> >
>>>> >
>>>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>>>> > Because
>>>> > it
>>>> > will do nothing if the first one did not work.
>>>> >
>>>> > I have try both to remove Null or have Null, It still not working.
>>>> >
>>>> > Any ideas. Thanks.
>>>> >
>>>> >
>>>> > "OZI" wrote:
>>>> >
>>>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>>>> >
>>>> > why InputOutput when it is only Output
>>>> > remove = null
>>>> >
>>>> > Is the sp you are showing the actual sp you are using.
>>>> >
>>>>
>>>>
>>>>
>>
>>
>


William Vaughn

9/22/2007 2:51:00 AM

0

A better solution might be to turn on the Profiler to see what's getting
sent to SQL Server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"OZI" <sql_agentman@hotmail.com> wrote in message
news:elOCILK$HHA.3716@TK2MSFTNGP03.phx.gbl...
> sorry, I did not mean a temp table, Just a real table for temporary use.
>
>
> "William Vaughn" <billvaNoSPAM@betav.com> wrote in message
> news:%23oa5IHK$HHA.484@TK2MSFTNGP06.phx.gbl...
>> Ah, huh? When a SP creates a temp table, it's dropped when the SP ends.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant, Dad, Grandpa
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com
>> www.betav.com/blog/billva
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "OZI" <sql_agentman@hotmail.com> wrote in message
>> news:eXOUn4I$HHA.5160@TK2MSFTNGP05.phx.gbl...
>>> You might be running the wrong file or pointing to the wrong database.
>>> start stripping your page down to the bare minimum to find this bug.
>>> It is impossible to figure this one out when we don't have full code and
>>> the same environment.
>>>
>>> Also you can possibly debug and step into your stored procedure.
>>>
>>> or you can create a temp table in SQL and in your SP add an insert to
>>> the temp table to make sure your sp is executing. check if the insert
>>> worked.
>>>
>>> of possibly your SqlDataSource is being Initialized before you get your
>>> data from your Parameters.
>>>
>>> good luck
>>>
>>>
>>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>>> news:5E3DC256-999B-4C34-911C-B1FEB5E64629@microsoft.com...
>>>> Hi OZI,
>>>> Thank you for you reply. I forgot to set @cnt = my select when I post
>>>> the
>>>> code. I still did not get any things back. I did not get any Exceptions
>>>> from
>>>> the system. When I go
>>>> to debug mode I see that I get in Protected Sub
>>>> SqlDataSource1_Deleted(ByVal
>>>> sender As Object, ByVal e As
>>>> system.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
>>>> SqlDataSource1.Deleted and e.Command.Parameters("@mess").Value has
>>>> value with
>>>> system.DBNull
>>>> But with e.Command.Parameters("@mess") in debug has Direction = Input
>>>> I do not know what is going wrong. Or this is the bug???
>>>> Please help, thanks.
>>>>
>>>> "OZI" wrote:
>>>>
>>>>> Also how can you be sure that your datasource is executing your stored
>>>>> procedure at all
>>>>> Have you done any debugging in your code.
>>>>>
>>>>>
>>>>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>>>>> news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
>>>>> > Thank you for your reply.
>>>>> >
>>>>> > The stored procedure, I posted just the testing to see if I can get
>>>>> > any
>>>>> > result back from SQL Server which it's working find. I do not want
>>>>> > to put
>>>>> > a
>>>>> > lot of coding and cannot tell which part is not working.
>>>>> >
>>>>> > Here is the stored procedure that I will use it
>>>>> >
>>>>> > ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
>>>>> >
>>>>> > @SiteProjectID Int,
>>>>> > @MeasureID Int,
>>>>> > @mess VarChar(255) OUTPUT,
>>>>> > @ret Int OUTPUT
>>>>> >
>>>>> > AS
>>>>> >
>>>>> > BEGIN
>>>>> >
>>>>> > -- SET NOCOUNT ON added to prevent extra result sets from
>>>>> > -- interfering with SELECT statements.
>>>>> > SET NOCOUNT ON;
>>>>> >
>>>>> > DECLARE @cnt int
>>>>> >
>>>>> > SELECT COUNT(MeasureID)
>>>>> > FROM Measure
>>>>> > WHERE SiteProjectID = @SiteProjectID
>>>>> > AND MeasureID = @MeasureID
>>>>> > AND ApprovedDt IS NULL
>>>>> >
>>>>> > IF @cnt = 0
>>>>> > BEGIN
>>>>> > SET @mess = 'Measure has been approved...'
>>>>> > SET @ret = 1
>>>>> > RETURN
>>>>> > END
>>>>> >
>>>>> > ELSE
>>>>> > BEGIN
>>>>> > SELECT COUNT(MeasureID)
>>>>> > FROM Measure
>>>>> > WHERE SiteProjectID = @SiteProjectID
>>>>> > AND MeasureID = @MeasureID
>>>>> > AND ImplementedDt IS NULL
>>>>> > IF @cnt = 0
>>>>> > BEGIN
>>>>> > SET @mess = 'Measure has been implemented...'
>>>>> > SET @ret = 2
>>>>> > RETURN
>>>>> > END
>>>>> >
>>>>> > ELSE
>>>>> > BEGIN
>>>>> > -- My DELETE statement will go here
>>>>> > SET @mess = 'Will Delete this measure'
>>>>> > SET @ret = 3
>>>>> > RETURN
>>>>> > END
>>>>> > END
>>>>> >
>>>>> > END
>>>>> >
>>>>> >
>>>>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>>>>> > Because
>>>>> > it
>>>>> > will do nothing if the first one did not work.
>>>>> >
>>>>> > I have try both to remove Null or have Null, It still not working.
>>>>> >
>>>>> > Any ideas. Thanks.
>>>>> >
>>>>> >
>>>>> > "OZI" wrote:
>>>>> >
>>>>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>>>>> >
>>>>> > why InputOutput when it is only Output
>>>>> > remove = null
>>>>> >
>>>>> > Is the sp you are showing the actual sp you are using.
>>>>> >
>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>
>

CSharp Agentman

9/22/2007 6:09:00 PM

0

a preivous post with links indicate a bug in the framework and some work
around people used and claimed to work.
However I did not test the work around myself at all.



"William Vaughn" <billvaNoSPAM@betav.com> wrote in message
news:%232TiZNM$HHA.5840@TK2MSFTNGP03.phx.gbl...
>A better solution might be to turn on the Profiler to see what's getting
>sent to SQL Server.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "OZI" <sql_agentman@hotmail.com> wrote in message
> news:elOCILK$HHA.3716@TK2MSFTNGP03.phx.gbl...
>> sorry, I did not mean a temp table, Just a real table for temporary use.
>>
>>
>> "William Vaughn" <billvaNoSPAM@betav.com> wrote in message
>> news:%23oa5IHK$HHA.484@TK2MSFTNGP06.phx.gbl...
>>> Ah, huh? When a SP creates a temp table, it's dropped when the SP ends.
>>>
>>> --
>>> ____________________________________
>>> William (Bill) Vaughn
>>> Author, Mentor, Consultant, Dad, Grandpa
>>> Microsoft MVP
>>> INETA Speaker
>>> www.betav.com
>>> www.betav.com/blog/billva
>>> Please reply only to the newsgroup so that others can benefit.
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>> __________________________________
>>> Visit www.hitchhikerguides.net to get more information on my latest
>>> book:
>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>>> -----------------------------------------------------------------------------------------------------------------------
>>>
>>> "OZI" <sql_agentman@hotmail.com> wrote in message
>>> news:eXOUn4I$HHA.5160@TK2MSFTNGP05.phx.gbl...
>>>> You might be running the wrong file or pointing to the wrong database.
>>>> start stripping your page down to the bare minimum to find this bug.
>>>> It is impossible to figure this one out when we don't have full code
>>>> and the same environment.
>>>>
>>>> Also you can possibly debug and step into your stored procedure.
>>>>
>>>> or you can create a temp table in SQL and in your SP add an insert to
>>>> the temp table to make sure your sp is executing. check if the insert
>>>> worked.
>>>>
>>>> of possibly your SqlDataSource is being Initialized before you get your
>>>> data from your Parameters.
>>>>
>>>> good luck
>>>>
>>>>
>>>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>>>> news:5E3DC256-999B-4C34-911C-B1FEB5E64629@microsoft.com...
>>>>> Hi OZI,
>>>>> Thank you for you reply. I forgot to set @cnt = my select when I post
>>>>> the
>>>>> code. I still did not get any things back. I did not get any
>>>>> Exceptions from
>>>>> the system. When I go
>>>>> to debug mode I see that I get in Protected Sub
>>>>> SqlDataSource1_Deleted(ByVal
>>>>> sender As Object, ByVal e As
>>>>> system.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
>>>>> SqlDataSource1.Deleted and e.Command.Parameters("@mess").Value has
>>>>> value with
>>>>> system.DBNull
>>>>> But with e.Command.Parameters("@mess") in debug has Direction = Input
>>>>> I do not know what is going wrong. Or this is the bug???
>>>>> Please help, thanks.
>>>>>
>>>>> "OZI" wrote:
>>>>>
>>>>>> Also how can you be sure that your datasource is executing your
>>>>>> stored
>>>>>> procedure at all
>>>>>> Have you done any debugging in your code.
>>>>>>
>>>>>>
>>>>>> "Madison" <Madison@discussions.microsoft.com> wrote in message
>>>>>> news:77F2718D-9A87-486D-B671-69655A2AF891@microsoft.com...
>>>>>> > Thank you for your reply.
>>>>>> >
>>>>>> > The stored procedure, I posted just the testing to see if I can get
>>>>>> > any
>>>>>> > result back from SQL Server which it's working find. I do not want
>>>>>> > to put
>>>>>> > a
>>>>>> > lot of coding and cannot tell which part is not working.
>>>>>> >
>>>>>> > Here is the stored procedure that I will use it
>>>>>> >
>>>>>> > ALTER PROCEDURE [dbo].[p_siteproject_delete_measure]
>>>>>> >
>>>>>> > @SiteProjectID Int,
>>>>>> > @MeasureID Int,
>>>>>> > @mess VarChar(255) OUTPUT,
>>>>>> > @ret Int OUTPUT
>>>>>> >
>>>>>> > AS
>>>>>> >
>>>>>> > BEGIN
>>>>>> >
>>>>>> > -- SET NOCOUNT ON added to prevent extra result sets from
>>>>>> > -- interfering with SELECT statements.
>>>>>> > SET NOCOUNT ON;
>>>>>> >
>>>>>> > DECLARE @cnt int
>>>>>> >
>>>>>> > SELECT COUNT(MeasureID)
>>>>>> > FROM Measure
>>>>>> > WHERE SiteProjectID = @SiteProjectID
>>>>>> > AND MeasureID = @MeasureID
>>>>>> > AND ApprovedDt IS NULL
>>>>>> >
>>>>>> > IF @cnt = 0
>>>>>> > BEGIN
>>>>>> > SET @mess = 'Measure has been approved...'
>>>>>> > SET @ret = 1
>>>>>> > RETURN
>>>>>> > END
>>>>>> >
>>>>>> > ELSE
>>>>>> > BEGIN
>>>>>> > SELECT COUNT(MeasureID)
>>>>>> > FROM Measure
>>>>>> > WHERE SiteProjectID = @SiteProjectID
>>>>>> > AND MeasureID = @MeasureID
>>>>>> > AND ImplementedDt IS NULL
>>>>>> > IF @cnt = 0
>>>>>> > BEGIN
>>>>>> > SET @mess = 'Measure has been implemented...'
>>>>>> > SET @ret = 2
>>>>>> > RETURN
>>>>>> > END
>>>>>> >
>>>>>> > ELSE
>>>>>> > BEGIN
>>>>>> > -- My DELETE statement will go here
>>>>>> > SET @mess = 'Will Delete this measure'
>>>>>> > SET @ret = 3
>>>>>> > RETURN
>>>>>> > END
>>>>>> > END
>>>>>> >
>>>>>> > END
>>>>>> >
>>>>>> >
>>>>>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>>>>>> > Because
>>>>>> > it
>>>>>> > will do nothing if the first one did not work.
>>>>>> >
>>>>>> > I have try both to remove Null or have Null, It still not working.
>>>>>> >
>>>>>> > Any ideas. Thanks.
>>>>>> >
>>>>>> >
>>>>>> > "OZI" wrote:
>>>>>> >
>>>>>> > 'ireturn = e.Command.Parameters("@ret").Value is commented out.
>>>>>> >
>>>>>> > why InputOutput when it is only Output
>>>>>> > remove = null
>>>>>> >
>>>>>> > Is the sp you are showing the actual sp you are using.
>>>>>> >
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>>>
>>
>>
>