Problems with Stored procedures

[Guest]

Hi all,
Not sure if anyone else is having the same problems as me, but whenever I try to use a command that returns a recordset from a stored procedure I run into problems. I can create the command successfully, but whenever I drag a binding onto the page Dreamweaver crashes.

The stored procedure that I am using accepts 4 input parameters. This is the SQL in the SP:

SELECT dbo.tblManufacturer.web_manufacturer, dbo.tblProducts.itm_item, dbo.tblProducts.itm_desc, dbo.tblProducts.itm_wdesc, dbo.tblProducts.itm_wnotes,
dbo.tblProducts.itm_price, dbo.tblProducts.itm_wpicture, dbo.tblProducts.itm_unitweight, dbo.tblProducts.itm_unitvolume, dbo.tblProducts.Stock,
dbo.tblCategory.CategoryName, dbo.tblSubCat1.SubCat1Name, dbo.tblSubCat2.SubCat2Name
FROM dbo.tblProducts LEFT OUTER JOIN
dbo.tblSubCat2 ON dbo.tblProducts.SubCat2ID = dbo.tblSubCat2.SubCat2ID LEFT OUTER JOIN
dbo.tblSubCat1 ON dbo.tblProducts.SubCat1ID = dbo.tblSubCat1.SubCat1ID LEFT OUTER JOIN
dbo.tblCategory ON dbo.tblProducts.CategoryID = dbo.tblCategory.CatID LEFT OUTER JOIN
dbo.tblManufacturer ON dbo.tblProducts.itm_manufacturer = dbo.tblManufacturer.web_manid
WHERE (@SubCat2ID IS NULL OR dbo.tblProducts.SubCat2ID = @SubCat2ID) AND
(@SubCat1ID IS NULL OR dbo.tblProducts.SubCat1ID = @SubCat1ID) AND
(@CatID IS NULL OR dbo.tblProducts.CategoryID = @CatID) AND
(@ManID IS NULL OR dbo.tblManufacturer.web_manid = @ManID)
ORDER BY dbo.tblCategory.CategoryName, dbo.tblSubCat1.SubCat1Name, dbo.tblSubCat2.SubCat2Name, dbo.tblProducts.itm_item

I have tried to use this directly in Dreamweaver, replacing the @ variables with proper ones in the SQL panel, but I get and this error: Invalid column name 'MSubCat2ID'.

Since I am using WebAssists eCart extension I need the Recordset to work well within Dreamweaver. Does anyone know what I should do to get this to work in Dreamweaver? I would love to get the command to work as I prefer using Stored Procedures, but if I have to build the SQL within Dreamweaver then I will do that.

Cheers,

Steve

[Guest]

hi there,

when you get back a record set: try to use the server beahvior "record set" and not "command" (also when you use a sp)

Hope that helps
Sebastian

[Guest]

How do I pass values to the stored procedure when using a normal recordset? The command method shows you which values are needed which is always nice. But if there is a way around this so that I can still use my stored procedures I will be a happy man.

[Guest]

Just trying to work out how to do this myself, and can add the first variable to be passed, but once I have created it the + and - buttons are greyed out, along with the Edit button. What am I doing wrong? I have been using Recordsets and Commands in Dreamweaver for years, its only CS3 that seems to be having "issues".

[Guest]

Right, I have it working at last.

When creating a Recordset to pass values to a store procedure I still get the + and - greyed out, but if I close the recordset and go back into it, it allows me to continue editing and creating more values.

Recordset page navigation appears to be working as well, and I can drag bindings onto the page. Its a shame that Adobe did not come back to me with a solution, maybe they are busy trying to make CS3 a little bit better 😉

[Bartus2005]

I have the same problem with command ! I think it is a Dreamweaver CS3 error. "Commands" doesn't work at all whenever I select the recordset tic or not. It is only when You use ASP Server technology. In ASPX is OK.
It is very harmfull for me to work with that error. Please help me !!!.

ABOBE ! - Solve the problem !!!

[Guest]

For me the same problem. Workaround: Just add the recordset without any parameters. Then modifiy the record set by doubleclicking on it in the server behavior window. Now you can add any parameters.

But this works only with recordset - with the command an other bug is coming up (i will open an extra thread.

Any help from you Adobe Support Guys (and Girls ,O) around?
regards
Sebastian

[Guest]

At last other people with the same error, I am so glad that I am not alone. Last week I opened a case with Adobe Support, but have had no reply from them yet.

Steve

[Bartus2005]

I am looking forward to read an extra thread about it. Please let me know when appears.

[Guest]

I have finally had confirmation from Adobe that this problem is a bug and that their most senior techies are aware of it and will be producing a fix for it at some point.

[Lee Redhead]

Hello,

Just wondering if there is any news on this yet, I have just purchased the upgrade to CS3 (had too as new computer is running Vista) and needless to say this is proving quite a pain having Dreamweaver crash when trying to do something which I have to do a lot of.

Lee

[Guest]

Hi Lee,
The last they told me was that it might be fixed in the next version, so I wouldn't hold your breathe that it will be any time soon.

The only solution is to use a Stored Procedure in Recordset instead of a command. Works nicely for me, and haven't had a crash in a long time.

Steve

[brianmisty]

I had this same problem about 6 months ago (actually on 7/6/2007) and opened a case with Adobe with a very detailed explanation of the problem. They forwarded the issue to "their engineers' and sent me back a detailed questionnaire regarding the problem. They said that it sounded like a bug in DW CS3 and that they would try to get a fix. Anyway, I never heard from them again, and then my case was closed. I put a lot of effort into helping them identify the problem and then was ignored. Seeing now that others have also had them same problem for 6 months or longer, and I am just amazed at Adobe's apathy. It's not like CS4 was or is around the next corner... they are making us wait for possibly a year or more what probably amounts to a simply fix.

[Lee Redhead]

Well I have been using DW8 for the past month in the hope that a fix may come. Just wondering where I would stand on a refund, thinking that since paid £180 for a piece of software which in esscence does not work properly.

I would love to use CS3 but I can't, I know I can code everthing by hand but it is often quicker to just click the button and to be fair that it should do that. I mean I have been using Dreamweaver since v6, never wanted to go elsewhere as it does what I want and I like how it works but this has annoyed me somewhat.

I have considered contacting support but I really don't want to shell out money to basically get told yes there is a problem or simply ignored.

Anybody know what Adobes refund policy is for programs that do not work properly?

Lee