SQL SELECT and Return values

Report · May 13, 2006

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.

Report · May 13, 2006

Are you passing any parameters to the proc? Or there could be a problem with
your code.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · May 16, 2006

I read your note with a great degree of sympathy but no solutions. I was having the same trouble with access tables after 4 years of trouble free connections. It may not be relevant but the solutions for my problem was a Server software SP release. Details are:
Following the avalanche of hints and tips I am pleased to report that there is a problem with Dreamweaver MX and MX2004 when connecting to Access databases running on Windows Server 2003 SP1. Whilst it is covered in the knowledge base I note that others in the forum are having similar difficulties with Sequel connections and unable to retrieve failures.
There is a "fix" - SP2DBFix1.0.2.mxp - for my problem and I cannot be alone in experiencing this.
And just in case anyone from Adobe is reading this, you should have written to all your registered and paid up members informing us of this problem when WS2003 SP1 was released!
Hope this helps.

Report · May 13, 2006

Yes, I'm passing 2 paramaters. The code with parameters is fine in Query
Analyser and returns the Return Values.

"Julian Roberts" <nospam@charon.co.uk> wrote in message
news:e44ngp$qlc$1@forums.macromedia.com...
> Are you passing any parameters to the proc? Or there could be a problem
> with your code.
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>

Report · May 13, 2006

All the evidence points to a flaw in the code in the ASP page.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · May 13, 2006

The ASP code is all DW generated.

"Julian Roberts" <nospam@charon.co.uk> wrote in message
news:e453mv$au7$1@forums.macromedia.com...
> All the evidence points to a flaw in the code in the ASP page.
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>

Report · May 13, 2006

My suggestion is that you might want to post the code on this forum.
Somebody might be able to spot what the problem is.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004