Question
SQL SELECT and Return values
I have a simple SELECT statement in a Stored Proc that
queries 2 tables in
SQL Server 2000 using a join. My problem is I want to return values based on
the outcome of the query eg. if a row is returned then return 1, or return 2
if no rows are found. I have tried various ways to implement this and they
always work fine in Query Analyser but in Dreamweaver MX2004 either return
no return values ( or at least they are not displayed on my page ) or the
return values are inconsistent. I am using a DW Command.
I know this is DW and not my code as Query Analyser produces the correct
values every time. Can anyone tell me what code I can use that is DW
friendly please.
Thanks.
SQL Server 2000 using a join. My problem is I want to return values based on
the outcome of the query eg. if a row is returned then return 1, or return 2
if no rows are found. I have tried various ways to implement this and they
always work fine in Query Analyser but in Dreamweaver MX2004 either return
no return values ( or at least they are not displayed on my page ) or the
return values are inconsistent. I am using a DW Command.
I know this is DW and not my code as Query Analyser produces the correct
values every time. Can anyone tell me what code I can use that is DW
friendly please.
Thanks.
AdChoices