Update to Dreamweaver CS3? Stored Procedures?

Report · Jan 10, 2008

I haven't been keeping up on this but a while back I had a problem with
Stored Procedures in CS3. CS3 had a problem with my stored procedures
and if I tried to use the recordsets created by a command (SP) the
recordset wouldn't show up and all I would get was a "!" in the bindings
window. If I wanted to bind data, Dreamweaver wouldn't recognize the SP.

I've been forced to hop back and forth between 8.02 and CS3 if I need to
work with any of my pages with SPs on them.

Has this been fixed? If not, is there any plan to fix it?

This is especially true since MX collection was shot down in it's prime
and resurrected as Toolbox.

Report · Jan 11, 2008

Art wrote:
>
>
> I haven't been keeping up on this but a while back I had a problem with
> Stored Procedures in CS3. CS3 had a problem with my stored procedures
> and if I tried to use the recordsets created by a command (SP) the
> recordset wouldn't show up and all I would get was a "!" in the bindings
> window. If I wanted to bind data, Dreamweaver wouldn't recognize the SP.
>
> I've been forced to hop back and forth between 8.02 and CS3 if I need to
> work with any of my pages with SPs on them.
>
> Has this been fixed? If not, is there any plan to fix it?
>
> This is especially true since MX collection was shot down in it's prime
> and resurrected as Toolbox.

Still not fixed, the last response from Adobe was it may get fixed in a
future program.

The workaround is to use a recordset instead, then select the stored
procedure from the list at the bottom. There is a small bug here too,
where it only lets you enter one parameter. If you save the recordset
and open it up again it allows you to continue adding as many parameters
as you like.

Steve

Report · Jan 14, 2008

OK, thanks.

Report · Mar 05, 2008

I use WebAssist and it seems that I can't use part of Webassist until
this whole "Command" thing is resolved. What a pain.

I've tried creating a recordset using the recordset window but because I
need to change the cursor type, it disappears. I'm trying to figure out
a way so that I don't have to change the "Cursor" type (below).

commmname.ActiveConnection.CursorLocation = 3 ' adUseClient

With all the problems with Dev Tools and this, most of my usual tools
went away when I "upgraded" to CS3. Why did I upgrade, I know there's a
reason.

Report · Mar 06, 2008

Art wrote:
> I use WebAssist and it seems that I can't use part of Webassist until
> this whole "Command" thing is resolved. What a pain.
>
> I've tried creating a recordset using the recordset window but because I
> need to change the cursor type, it disappears. I'm trying to figure out
> a way so that I don't have to change the "Cursor" type (below).
>
> commmname.ActiveConnection.CursorLocation = 3 ' adUseClient
>
> With all the problems with Dev Tools and this, most of my usual tools
> went away when I "upgraded" to CS3. Why did I upgrade, I know there's a
> reason.

I have seen your posts on the WebAssist forums, and I wish a fix was
imminent, I really do.

Why do you need to use the cursor type? Is there a way to avoid it?

Maybe you could go back to the previous version where this wasn't a problem?

Steve

Report · Mar 06, 2008

You use Webassist too? I'm not sure why but when I add a product to
the cart, if I use the new stored procedures, I get an error. I can't
remember the error now but when I add the line to where it sets the
command, it fixes that error. However, the recordset is no longer
visible to Dreamweaver.

When I figured out how to avoid the error, I sort of dropped my search
for a better solution. However, now it's become a problem again because
I can't accomplish what I want. There probably is a solution but it's
avoiding me at the moment. I've thought about going back to the previous
version but that creates problems too.

This whole problem is just so schizophrenic.

Do you use the same username on Webassist?
>
> Why do you need to use the cursor type? Is there a way to avoid it?
>
> Maybe you could go back to the previous version where this wasn't a
> problem?
>
> Steve

Report · Mar 06, 2008

Rowset position cannot be restarted.

is the error I get when I remove the offending line...

Report · Mar 06, 2008

Art wrote:
> Rowset position cannot be restarted.
>
> is the error I get when I remove the offending line...

Is this when you have an item on your page and you add it to your cart,
or when you add your cart contents to your database?

Steve

Report · Mar 06, 2008

Dooza wrote:
> Art wrote:
>> Rowset position cannot be restarted.
>>
>> is the error I get when I remove the offending line...
>
> Is this when you have an item on your page and you add it to your cart,
> or when you add your cart contents to your database?
>
> Steve

I just looked at my code and I too have the additional line for the
cursor type, and I am using stored procedures too.

My recordset looked like it would open, no exclamation mark, but as soon
as I tried Dreamweaver crashed on me.

I am guessing that I added the line after I was happy with the layout of
the page...its been a while since I made mine.

Steve

Report · Mar 10, 2008

I've been digging into my page and reapplying the stored procedures and
for some reason, it now works without any manual addition. I can't say
whether it's an Adobe or Webassist that fixed it. The other day, when I
applied the DB Search, I think that's what I was working on, it might
have been just editing the ecart but I got a message that said something
like " cursor wrong type ...applied to page" When I uploaded it on the
test server, it suddenly worked fine without the edit. Problem solve but
I'm not sure who solved it or when.

However, I did find out from Webassist, after submitting a support
ticket, that DB Search does NOT support stored procedures. I've had to
revert back to using a standard recordset instead. Not a big deal.

There was also a bug in it and they told me that for complex queries,
where you have more than one table with the same column name, DB Search
isn't able resolve which table to use. A manual edit was needed.
However, every time you click into the DB Search and edit search
criteria, it reverts back. So, instead of having "tablename.ID", it
reverts back to "ID" So every time you edit it, you have to manually add
the tablename. Also not a big deal but they have logged it for correction.

>
> I am guessing that I added the line after I was happy with the layout of
> the page...its been a while since I made mine.
>
> Steve

Report · Mar 10, 2008

Dooza,

By the way, are you a Programmer or Designer first?

I come at this from a Designers point of view so much of this is very
difficult.

I do OK, it just takes so much more time and effort to accomplish stuff.

I rely heavily on the "tools" to help me out but I keep getting requests
for functionality that the tools don't quite do. Add the compatibility
issues and I have a big headache at the end of the week. I keep plugging
on though.

Anyways, see you around.

Report · Mar 10, 2008

Dooza, by the way, what is your username over on the webassist board?

Report · Mar 10, 2008

Art wrote:
> I've been digging into my page and reapplying the stored procedures and
> for some reason, it now works without any manual addition. I can't say
> whether it's an Adobe or Webassist that fixed it. The other day, when I
> applied the DB Search, I think that's what I was working on, it might
> have been just editing the ecart but I got a message that said something
> like " cursor wrong type ...applied to page" When I uploaded it on the
> test server, it suddenly worked fine without the edit. Problem solve but
> I'm not sure who solved it or when.

Its working, so thats all good!

> However, I did find out from Webassist, after submitting a support
> ticket, that DB Search does NOT support stored procedures. I've had to
> revert back to using a standard recordset instead. Not a big deal.
>
> There was also a bug in it and they told me that for complex queries,
> where you have more than one table with the same column name, DB Search
> isn't able resolve which table to use. A manual edit was needed.
> However, every time you click into the DB Search and edit search
> criteria, it reverts back. So, instead of having "tablename.ID", it
> reverts back to "ID" So every time you edit it, you have to manually add
> the tablename. Also not a big deal but they have logged it for correction.

I am going to be trying to create an advanced text search using stored
procedures, but first I need to see what a recordset based one looks
like, and then try to use that code directly in a stored procedure. My
current stored procedure is huge, it allows for 4 levels of filters, any
of which can be null, and the text search. This will all be implemented
in v2 of my project, but thats not scheduled to start for a while.

Once I do have the advanced text search cracked, I will post an example
here for you.

Steve

Report · Mar 10, 2008

Art wrote:
> Dooza,
>
> By the way, are you a Programmer or Designer first?
>
> I come at this from a Designers point of view so much of this is very
> difficult.
>
> I do OK, it just takes so much more time and effort to accomplish stuff.
>
> I rely heavily on the "tools" to help me out but I keep getting requests
> for functionality that the tools don't quite do. Add the compatibility
> issues and I have a big headache at the end of the week. I keep plugging
> on though.
>
> Anyways, see you around.

Thats a good question, I guess I started as a designer, a pretty poor
one at that, I always found creating the initial look the hardest part
of the project, once that was formed the pages just come together.

That all changed when I went on an introduction to Ultradev 2 day course
back in 2001, that opened my eyes and from then on I started to learn a
hell of a lot.

Now I like to call myself a developer :)

I do rely on the tools a fair bit, but sometimes they are just the foot
in door, its takes more to get all the way thru the door. Breaking
things and learning how to fix them is my way of learning.

When I do visit Web Assist forums I mostly just read them (I can't seem
to post or reply using NNTP), but when I do I use my real name, Steve Hoare.

Steve

Report · Mar 10, 2008

> Steve

Sounds like we're somewhat in the same situation. Sounds like you have
programmers to fall back on...WISH I HAD THAT. When I worked for a
newspaper, I had a good programmer to work with. Man that was nice. Now
I'm at the mercy of people here. Helpful, yet, understandably cursory.

I remember Ultradev too. Never dug too deep into it... It's lifespan was
so short (being bought by Dreamweaver) I never really used it much. I
was doing more ASP hand programming at the time and that made more sense
to me. When Dreamweaver implemented the database interface...I was very
happy. Suddenly, all that ASP handcoding I learned went away. I've been
looking over my 3 very thick ASP books from those "Ancient Times" (5
years ago?) and I'm in awe of the change that's taken place since then.

Are you up early as I am or are you in some "far off land?" Midwest USA
here. Wisconsin to be more precise.

Report · Mar 10, 2008

> Once I do have the advanced text search cracked, I will post an example
> here for you.
>
> Steve

Thanks Steve,

I've thought about doing that. It seems like it should be possible, I
just have so little time at work to invest in it. Most of the "extra"
stuff I do/learn is on my own time. I will watch for your "hack."

If you need to email me, just take the "nospam_" (both of them) out of
the email address.

Report · Mar 10, 2008

Art wrote:
>
>> Steve
>
> Sounds like we're somewhat in the same situation. Sounds like you have
> programmers to fall back on...WISH I HAD THAT. When I worked for a
> newspaper, I had a good programmer to work with. Man that was nice. Now
> I'm at the mercy of people here. Helpful, yet, understandably cursory.

I don't have any programmers at all, I wouldn't be doing what I am today
without the Dreamweaver community to fall back on for help.

> I remember Ultradev too. Never dug too deep into it... It's lifespan was
> so short (being bought by Dreamweaver) I never really used it much. I
> was doing more ASP hand programming at the time and that made more sense
> to me. When Dreamweaver implemented the database interface...I was very
> happy. Suddenly, all that ASP handcoding I learned went away. I've been
> looking over my 3 very thick ASP books from those "Ancient Times" (5
> years ago?) and I'm in awe of the change that's taken place since then.

I dabbled in ASP for a bit before my Dreamweaver days, my ASP in 21 days
helped me for a long time. Its still essential that I understand what
these pesky extensions are doing, or trying to do, as I haven't really
found one that behaves 100%.

> Are you up early as I am or are you in some "far off land?" Midwest USA
> here. Wisconsin to be more precise.

I am in a far of land, some may say its your ancestry home land ;)

Steve

Report · Mar 10, 2008

By the way, you mentioned that you couldn't get into the NNTP version of
WebAssist? If you use Thunderbird and your reader, you have to go to
options and force it to request Username and Password. It will then
connect to the webassist.com newsgroup. Use your regular
username/password that you use on the site. Or, should I say use your
email/password.

Not sure if this was your problem but thought I'd mention it. Newsgroups
are so much more easier to deal with.

Report · Mar 10, 2008

Art wrote:
> By the way, you mentioned that you couldn't get into the NNTP version of
> WebAssist? If you use Thunderbird and your reader, you have to go to
> options and force it to request Username and Password. It will then
> connect to the webassist.com newsgroup. Use your regular
> username/password that you use on the site. Or, should I say use your
> email/password.
>
> Not sure if this was your problem but thought I'd mention it. Newsgroups
> are so much more easier to deal with.

I am using Thunderbird, and have forced it to request username and
password, but it only ever asks for my password. I have my email address
set correctly in the server properties, but I still can't post.

I hate the forums at Web Assist, well the design, its not easy to use,
and I always forget to login before trying to post or reply, its so
frustrating.

Steve

Report · Mar 10, 2008

Dooza wrote:
> Art wrote:
>> By the way, you mentioned that you couldn't get into the NNTP version
>> of WebAssist? If you use Thunderbird and your reader, you have to go
>> to options and force it to request Username and Password. It will then
>> connect to the webassist.com newsgroup. Use your regular
>> username/password that you use on the site. Or, should I say use your
>> email/password.
>>
>> Not sure if this was your problem but thought I'd mention it.
>> Newsgroups are so much more easier to deal with.
>
> I am using Thunderbird, and have forced it to request username and
> password, but it only ever asks for my password. I have my email address
> set correctly in the server properties, but I still can't post.
>
> I hate the forums at Web Assist, well the design, its not easy to use,
> and I always forget to login before trying to post or reply, its so
> frustrating.
>
> Steve

Who would have thought that Account Name is actually your username! Got
it working now :)

Steve

Report · Mar 10, 2008

I know, that forum is awful. For being a company that is selling to a
fairly sophisticated community of Web Designers/programmers, you would
think they'd work a bit harder at impressing us.

Glad you got the Newsgroup working.