Good source for learning - SQL Stored Proceedures using Dreamweaver

Report · Jun 07, 2006

I am looking for a good source for learning how to integrate Stored
Proceedures using Dreamweaver?

Is there a book or something online?

Thanks

Report · Jun 07, 2006

To call and execute Stored Procedures using Dreamweaver is very
straightforward and simple. Please forgive me if I sound a little harsh but
do you fully understand what Stored Procedures are and how to create them?

Pat.

"lee" <lfairban_nospam@amep.com> wrote in message
news:e67e6r$f0i$1@forums.macromedia.com...
>I am looking for a good source for learning how to integrate Stored
>Proceedures using Dreamweaver?
>
> Is there a book or something online?
>
>
> Thanks
>

Report · Jun 08, 2006

Sorry if I am harsh. It's always easy when you know how to do it.

The Dreamweaver interface is not as straight forward and "easy" as you
suggest. Although I understand the Dreamweaver / SP interface, implementing
it and getting results are NOT as obvious as you suggest.

However, you recognized that my question implied that I don't know how,
exactly, SP works. That's why I posted the question in the first place. I
don't understand SP.

I included the reference to Dreamweaver in my post because I don't want
something that just deals with SP and then abandons me to figure out how to
implement it in DW.

Perhaps there is a good resource for SPs and another that deals with DW and
SPs. I'm open for suggestions.

Thanks

Report · Jun 08, 2006

Hi Lee,

It can be very frustrating when you want to know how to do something but
cannot get the information you need. We've all been there many times.

Have a look at this:

http://www.webthang.co.uk/tuts/tuts_dmx/gh_adv_asp/gh_adv_asp1.asp

It looks like the type of tutorial you are after. You will probably get more
useful information from other parts of the website as well.

Good Luck,

Pat.

"lee" <lfairban_nospam@amep.com> wrote in message
news:e699b3$p62$1@forums.macromedia.com...
> Sorry if I am harsh. It's always easy when you know how to do it.
>
> The Dreamweaver interface is not as straight forward and "easy" as you
> suggest. Although I understand the Dreamweaver / SP interface,
> implementing it and getting results are NOT as obvious as you suggest.
>
> However, you recognized that my question implied that I don't know how,
> exactly, SP works. That's why I posted the question in the first place. I
> don't understand SP.
>
> I included the reference to Dreamweaver in my post because I don't want
> something that just deals with SP and then abandons me to figure out how
> to implement it in DW.
>
> Perhaps there is a good resource for SPs and another that deals with DW
> and SPs. I'm open for suggestions.
>
> Thanks
>
>
>

Report · Jun 08, 2006

Thanks Pat...I only looked at it briefly but it looks like what I needed.

The biggest problem that I have is that I don't have enough time to look
into some of this stuff...

Over the years, I've gotten to a certain level of proficiency in certain
things, I can do quite a bit but there always seems to be yet another
technology to master as the Old Ways go away.

To be honest, I really just want to be an artist with some programming
skills but the nature of this position demands that I "learn It all."

Meanwhile, all those other skills have to be put asside...I really should
master flash...I really should work on my illustration skills...I really
should master CSS. I really should master...I don't know, name it. And if I
really wanted to abandon my ...LIFE...I could, perhaps, figure it all out.

What is so tiring is that my skill set is stretched SO f-ing thin that I can
never, possibly catch up. The only cure is time but often even that goes
against me.

Anyways, thanks for the link. I'll probably be back later with questions.

Thanks Pat.

If anyone else finds a good source, let me know.

Report · Jun 08, 2006

Hi,

Just thought I would add a comment. Just started develping ASP.NET on dreamweaver. Use VS2005 for more complex sites but Dreamweaver suits for most of the basic sites. Finding it ok but lacking is a variety of areas. re: stored procedures. I much prefer to take as much .net code off a page as I can & prefer the database to take care of the more complex statements. The great benefit of SP's . If you havn't got time to learn " which I would advise against SP have some great performance advantages" there are applicaions out there that will generate the procedures for you. Not sure if they are good for complex statements but for basic they are a great time saver"

Just get a good book on Stored Procedures or SQL as it is very easy to call stored procedures in VS 2005 & Dreamweaver. Any book could run you through the process of calling them in a chapter if that.... Spend you time on the SQL side as the rest will fall into place very soon...

http://www.freevbcode.com/ShowCode.asp?ID=3412
http://www.softplatz.com/Soft/Business/Databases-Tools/EazySQL.html

Report · Jun 08, 2006

Hey Lee,

You find yourself in that position, I find myself in that position, every
damn developer/programer in the world find themselves in that position. It
may be on different levels, but everyones in the same boat.

Here is my suggestion. Take the existing knowledge you have, pick a
technology that is a bit more futureproof (if the one you have is getting
outdated) and one that isn't too far removed from the one you know and put
it all into that one area.

Databases are really important if you want to be a decent web developer. If
you're serious and want to be good then devote time to a particular database
and get to know it well. I would suggest SQL Server. You don't have to be
DBA standard but get as much knowledge on it as you can. Never underestimate
your required knowledge of databases.

Set yourself goals. Say to yourself "In 6 months I want to be a proficient
developer in this language" and go for it. Don't get side-tracked into
something else just keep focused on one area and get good at it. Yes, that
language will become outdated in time but you will be all the more ready to
take on the next because of your past experiences.

I try to look at it like this; It is better to a master of one technology
and know enough to get by in others than a Jack of all technologies but a
master of none.

Pat.

"lee" <lfairban_nospam@amep.com> wrote in message
news:e69i41$7h3$1@forums.macromedia.com...
> Thanks Pat...I only looked at it briefly but it looks like what I needed.
>
> The biggest problem that I have is that I don't have enough time to look
> into some of this stuff...
>
> Over the years, I've gotten to a certain level of proficiency in certain
> things, I can do quite a bit but there always seems to be yet another
> technology to master as the Old Ways go away.
>
> To be honest, I really just want to be an artist with some programming
> skills but the nature of this position demands that I "learn It all."
>
> Meanwhile, all those other skills have to be put asside...I really should
> master flash...I really should work on my illustration skills...I really
> should master CSS. I really should master...I don't know, name it. And if
> I really wanted to abandon my ...LIFE...I could, perhaps, figure it all
> out.
>
> What is so tiring is that my skill set is stretched SO f-ing thin that I
> can never, possibly catch up. The only cure is time but often even that
> goes against me.
>
> Anyways, thanks for the link. I'll probably be back later with questions.
>
> Thanks Pat.
>
> If anyone else finds a good source, let me know.
>
>