Dreamweaver - SQL, MySQL, Access, Text File

Author

SQL, MySQL, Access, Text File - Setup

pond scraper

2005-09-29, 6:18 pm

Can anyone give me or help me find a step by step resource, to help me learn
what is needed to write to and retrieve information using MySQL, SQL, Access
and a text file using DW and C#'s ASP.Net.

An example:
Creating a dynamic text box in DW for a user to input some text. Taking that
text and storing it in the above databases and text file and then retrieving it
from the same storage sources.

I would appreciate your input.

Thank You.

Jon Parkhurst

2005-09-29, 6:18 pm

do you know html?

thanks,

Jon

"pond scraper" <webforumsuser@macromedia.com> wrote in message
news:dhh32s$ojn$1@forums.macromedia.com...
> Can anyone give me or help me find a step by step resource, to help me
> learn
> what is needed to write to and retrieve information using MySQL, SQL,
> Access
> and a text file using DW and C#'s ASP.Net.
>
> An example:
> Creating a dynamic text box in DW for a user to input some text. Taking
> that
> text and storing it in the above databases and text file and then
> retrieving it
> from the same storage sources.
>
> I would appreciate your input.
>
> Thank You.
>

Charles Newbury

2005-09-30, 6:20 pm

On 2005-09-29 12:00:28 -0400, "pond scraper"
<webforumsuser@macromedia.com> said:

> Can anyone give me or help me find a step by step resource, to help me
> learn what is needed to write to and retrieve information using MySQL,
> SQL, Access and a text file using DW and C#'s ASP.Net.
>
> An example:
> Creating a dynamic text box in DW for a user to input some text.
> Taking that text and storing it in the above databases and text file
> and then retrieving it from the same storage sources.
>
> I would appreciate your input.
>
> Thank You.

You ask a valid question and I wish I could help you, but I'm in the
same boat. For many of us there's a disconnect in our knowledge of how
this is done. I've been able to design some acceptable websites. I've
also been able to design some neat database applications via 4D that
work great on a local, stand alone basis. I've also been able to
install PHP and MySQLAdmin on my local machine, but connecting these to
a DW site, the methods and process involved, the different
terminologies, etc., have resulted in nothing but confusion on my part.
It seems that the entire platoon of ducks have to be in a row before
anything really works...you local machine, its applications and
configurations, the host's OS, their applications and configurations.
All it takes is for one duck to fly south and nothing you do works.

I envy those developers that have threaded the maze, brow-beaten their
ducks and can successfully integrate their websites and databases. For
me, it was a major accomplishment to finally figure out how to get a
form's contents emailed to where it needed to go! I imagine that some
day, some vital piece will fall into place for me...the fog will clear
and I'll be able to say, "Oh, crap! That's all there is to it?"

It's too bad that some of those "who know" all about this
website-database interface process get tired of answering "dumb"
questions and resort to the "go read the book" response. Sometimes
reading the book just confuses things even more!
--
Charles Newbury

To reply, eliminate the negative.

Jon Parkhurst

2005-09-30, 6:20 pm

There seems to be a difference between your knowledge and the posters. The
poster seems to have grabbed a few catch-phrases from the last strategic
objectives meeting and gone off to build a website. (I could be wrong
poster, and if I am please say so).

Charles-

You are somewhat correct. It does take "lining up your ducks" but that's
why we get paid the big bucks, b/c it's attention to detail and stuff most
don't care to bother with.

Now, I have ....crap forgotten the name of my PHP package. ;o) The admin
interface is called MyPHPAdmin. [insert readme file says only "PHPDEV4.2.3
or PHP4.a.bit / whatever"]

For me to connect to a remote database, I must go to:

c:\phpdev\phpmyadmin\config.inc.php and edit my SQL servers to include the
server at my host. Once I have done this, I am then able to browse through
my remote database on my local machine (ie, from //localhost/).

If you need some more help getting started, please let me know either here
or you can email me for IM.

"Charles Newbury" <newburcjneg@epix.net> wrote in message
news:dhjg0n$bhc$1@forums.macromedia.com...
> On 2005-09-29 12:00:28 -0400, "pond scraper"
> <webforumsuser@macromedia.com> said:
>
>
> You ask a valid question and I wish I could help you, but I'm in the same
> boat. For many of us there's a disconnect in our knowledge of how this is
> done. I've been able to design some acceptable websites. I've also been
> able to design some neat database applications via 4D that work great on a
> local, stand alone basis. I've also been able to install PHP and
> MySQLAdmin on my local machine, but connecting these to a DW site, the
> methods and process involved, the different terminologies, etc., have
> resulted in nothing but confusion on my part. It seems that the entire
> platoon of ducks have to be in a row before anything really works...you
> local machine, its applications and configurations, the host's OS, their
> applications and configurations. All it takes is for one duck to fly south
> and nothing you do works.
>
> I envy those developers that have threaded the maze, brow-beaten their
> ducks and can successfully integrate their websites and databases. For me,
> it was a major accomplishment to finally figure out how to get a form's
> contents emailed to where it needed to go! I imagine that some day, some
> vital piece will fall into place for me...the fog will clear and I'll be
> able to say, "Oh, crap! That's all there is to it?"
>
> It's too bad that some of those "who know" all about this website-database
> interface process get tired of answering "dumb" questions and resort to
> the "go read the book" response. Sometimes reading the book just confuses
> things even more!
> --
> Charles Newbury
>
> To reply, eliminate the negative.
>

Lionstone

2005-09-30, 6:21 pm

Yeah, I don't think anyone wants to touch a question where the poster thinks
that writing to Access, SQL Server, MySQL, AND a text file is a good idea.
:)
How many data sources to you need?

As for the connections, there is a "lightbulb threshhold" where everything
will click and make sense. Until then, ask as many dumb questions as you
want. Never stops anybody else. ;)

"Jon Parkhurst" <crash@bcdcdigital.com> wrote in message
news:dhji79$h5u$1@forums.macromedia.com...
> There seems to be a difference between your knowledge and the posters.
> The poster seems to have grabbed a few catch-phrases from the last
> strategic objectives meeting and gone off to build a website. (I could be
> wrong poster, and if I am please say so).
>
> Charles-
>
> You are somewhat correct. It does take "lining up your ducks" but that's
> why we get paid the big bucks, b/c it's attention to detail and stuff most
> don't care to bother with.
>
> Now, I have ....crap forgotten the name of my PHP package. ;o) The admin
> interface is called MyPHPAdmin. [insert readme file says only
> "PHPDEV4.2.3 or PHP4.a.bit / whatever"]
>
> For me to connect to a remote database, I must go to:
>
> c:\phpdev\phpmyadmin\config.inc.php and edit my SQL servers to include the
> server at my host. Once I have done this, I am then able to browse
> through my remote database on my local machine (ie, from //localhost/).
>
> If you need some more help getting started, please let me know either here
> or you can email me for IM.
>
>
>
> "Charles Newbury" <newburcjneg@epix.net> wrote in message
> news:dhjg0n$bhc$1@forums.macromedia.com...
>
>