What is SQL and ASP?

And more to the point, how do I use them? Daft questions I know, but I think
I'm on the right track after some previous daft questions I've already asked
here! I want to build a database of information and use this on a website so
the viewer can look up various items, sort the database by differing fields and
basically find stuff in it. I need a baby step guide to how the heck I should
go about it!!! Anybody know where to get this, or can they help me out?
Cheers.

And more to the point, how do I use them?

SQL = standard query language
a variety of databases use it...MS SQL, PostgreSQL, MySQL, etc.

It's a database.

ASP = active server pages. You can write code (usually in VBscript) on a
page and the server will process it before sending it to the end-user. You
can, for instance, use ASP to query your SQL database to retrieve data and
then format it into HTML.

How do you use them? Google for thousands of tutorials, or head to the
bookstore and pick up a few books.

If you are brand new to it all, I'd jump right into ASP.net though and skip
ASP.

Note that ASP/MS SQL are microsoft technologies. Alternatively you can
consider PHP/MySQL on the open-source side.

-Darrel

First of all make sure your web site host supports PHP and mysql, thats what to
do first. if they don't then find a new host!
Let us presume they do. in host cpanel see how many databases you have been
given. some only give one. then create it. name it.. username.. password..
then build.
ASP is a programing language, like PHP is.
http://www.microsoft.com/uk/visualstudio/trial/aspnet/default.aspx?id=0A0P9
Good luck nutter412

First of all make sure your web site host supports PHP and mysql, thats
what to
do first. if they don't then find a new host!

That's a rather narrow opinion, don't you think?

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"*dreamer" <webforumsuser (AT) macromedia (DOT) com> wrote

First of all make sure your web site host supports PHP and mysql, thats
what to
do first. if they don't then find a new host!
Let us presume they do. in host cpanel see how many databases you have
been
given. some only give one. then create it. name it.. username..
password..
then build.
ASP is a programing language, like PHP is.
http://www.microsoft.com/uk/visualstudio/trial/aspnet/default.aspx?id=0A0P9
Good luck nutter412

First of all make sure your web site host supports PHP and mysql, thats
what to
do first. if they don't then find a new host!

That'd be pretty useless if one is writing ASP.

For ASP, you need to ensure the ISP is running IIS (or a 3rd party ASP
interpreter).

-Darrel

A good place to start would be with "Dreamweaver MX: The Complete Reference"
http://www.amazon.com/exec/obidos/tg/detail/-/0072195142/lhhsalumni-20/104-4854978-0516728

"nutter412" <webforumsuser (AT) macromedia (DOT) com> wrote

And more to the point, how do I use them? Daft questions I know, but I
think
I'm on the right track after some previous daft questions I've already
asked
here! I want to build a database of information and use this on a website
so
the viewer can look up various items, sort the database by differing
fields and
basically find stuff in it. I need a baby step guide to how the heck I
should
go about it!!! Anybody know where to get this, or can they help me out?
Cheers.

On 15 Sep 2004 in macromedia.dreamweaver, nutter412 wrote:

And more to the point, how do I use them? Daft questions I know,
but I think I'm on the right track after some previous daft
questions I've already asked here! I want to build a database of
information and use this on a website so the viewer can look up
various items, sort the database by differing fields and basically
find stuff in it. I need a baby step guide to how the heck I should
go about it!!! Anybody know where to get this, or can they help me
out?

http://en.wikipedia.org/wiki/SQL
http://en.wikipedia.org/wiki/Active_Server_Pages

But the obvious first question is: does your host offer ASP?

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/email.php

I thought SQL = structured query language.

Acronym soup. Everyone's favorite mode of communication.

Very great book http://safari.peachpit.com/?XmlId=0-321-16680-9. I'm also a
beginner to ASP and Dreamweaver.

--
/Tine

"nutter412" <webforumsuser (AT) macromedia (DOT) com> skrev i en meddelelse
news:ci9imc$6d6$1 (AT) forums (DOT) macromedia.com...

And more to the point, how do I use them? Daft questions I know, but I
think
I'm on the right track after some previous daft questions I've already
asked
here! I want to build a database of information and use this on a website
so
the viewer can look up various items, sort the database by differing
fields and
basically find stuff in it. I need a baby step guide to how the heck I
should
go about it!!! Anybody know where to get this, or can they help me out?
Cheers.

On 15 Sep 2004 in macromedia.dreamweaver, cmbergin wrote:

I thought SQL = structured query language.

http://www.hyperdictionary.com/dictionary/SQL

According to Allen G. Taylor, SQL does _not_ stand for "Structured
Query Language". That, like "SEQUEL" (and its pronunciation
/see'kw*l/), was just another unofficial name for a precursor of
SQL. However, the IBM SQL Reference manual for DB2 and Craig
Mullins's "DB2 Developer's Guide" say SQL _does_ stand for
"Structured Query Language".

Take yer pick.

Acronym soup. Everyone's favorite mode of communication.

I especially like ETLAs.

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/email.php