Update to Dreamweaver CS3? Stored Procedures?

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.

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

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

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.

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

> 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.

> 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.

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

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

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