I have spent the several days and nights trying to find a tutorial on how 
to create a table in SQL Server in an existing DB using ASP.

I have "Professional Active Server Pages 3.0" and "Beginning Active Server 
Pages 3.0" and "ASP 3.0 Programmer's Reference". One would think that 
after spending all that money on books and all this time trying to learn 
what I need to know, that I would now know how to create a table on the 
fly using only ASP.

I can't believe this! Then, I remember that there's help at WROX online 
and I find an article about creating tables etc etc on the fly and it says 
I need to pay 5 bucks to view the PDF !! This is crazy.

Forgive me but you must be able to imagine my frustration.
I believe that I have done everything I can to learn ASP.
I have searched endlessly at MS, several ASP resource sites, and finally 
ended up here only to be insulted by a charge for something that should be 
in at least one of these books!

Sigh. I still don't feel better after this rant but at least someone might 
take pity on this frustrated but motivated individual who wants to learn 
ASP. I don't know what else to do. (besides purchase that PDF... right).

I'm ready to jump off a bridge.

Don't jump off the bridge just yet, but instead consider this:
-Why don't the ASP books show me how to make a javascript popup window?
-The HTML in the ASP books is not crossbrowser compatible, why!!!!!!?!

Just like javascript, SQL isn't a part of ASP - SQL is a language on its
own, used to communicate with databases.

The ASP books you mention have surely given you examples of executing SQL in
ASP, just like they've showed you how to output HTML code (response.write).
They don't teach you JavaScript, HTML, SQL etc. in detail - they teach you
ASP!  The SQL you learn from the books is necessary in order to understand
how to execute a query through the command object, for example.

If you want to buy another Wrox book, you can take a look at the "Beginning
SQL", or you could download the free SQL BOL here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

A good place to look when you're searching for things at the internet is the
search engine google - consider this search:
http://www.google.com/search?q=create+table+in+sql+tutorial

-Kim



> -----Original Message-----
> From: JS Build [mailto:jsbuild@p...]
> Sent: 10. august 2002 14:45
> To: ASP Databases
> Subject: [asp_databases] Why do none of the three ASP Wrox books have
> anything about creating tables using ASP?
>
>
> I have spent the several days and nights trying to find a tutorial on how
> to create a table in SQL Server in an existing DB using ASP.
>
> I have "Professional Active Server Pages 3.0" and "Beginning
> Active Server
> Pages 3.0" and "ASP 3.0 Programmer's Reference". One would think that
> after spending all that money on books and all this time trying to learn
> what I need to know, that I would now know how to create a table on the
> fly using only ASP.
>
> I can't believe this! Then, I remember that there's help at WROX online
> and I find an article about creating tables etc etc on the fly
> and it says
> I need to pay 5 bucks to view the PDF !! This is crazy.
>
> Forgive me but you must be able to imagine my frustration.
> I believe that I have done everything I can to learn ASP.
> I have searched endlessly at MS, several ASP resource sites, and finally
> ended up here only to be insulted by a charge for something that
> should be
> in at least one of these books!
>
> Sigh. I still don't feel better after this rant but at least
> someone might
> take pity on this frustrated but motivated individual who wants to learn
> ASP. I don't know what else to do. (besides purchase that PDF... right).
>
> I'm ready to jump off a bridge.

Thank you Kim.
I won't jump off the bridge. Promise.

dont purchase something unnecessarily unless u know for sure that it is
going to help you. for creating a basic table here is the following code

<%
dim conn
set conn = server.CreateObject("adodb.connection")
conn.Open ("dsn=urdsnname")

dim rs
set rs = server.CreateObject("adodb.recordset")
dim sql
sql = ("create table tblname")
rs.Open sql, conn, 3, 3
Response.Write "tblname table created"
%>

here i have used a dsn connection, you can replace it by dsn less if u wish
so !
if u want to have some fields in the table let me know, i shall send u the
code.

hope this helps
chetan
----- Original Message -----
From: "JS Build" <jsbuild@p...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, August 10, 2002 2:45 PM
Subject: [asp_databases] Why do none of the three ASP Wrox books have
anything about creating tables using ASP?


> I have spent the several days and nights trying to find a tutorial on how
> to create a table in SQL Server in an existing DB using ASP.
>
> I have "Professional Active Server Pages 3.0" and "Beginning Active Server
> Pages 3.0" and "ASP 3.0 Programmer's Reference". One would think that
> after spending all that money on books and all this time trying to learn
> what I need to know, that I would now know how to create a table on the
> fly using only ASP.
>
> I can't believe this! Then, I remember that there's help at WROX online
> and I find an article about creating tables etc etc on the fly and it says
> I need to pay 5 bucks to view the PDF !! This is crazy.
>
> Forgive me but you must be able to imagine my frustration.
> I believe that I have done everything I can to learn ASP.
> I have searched endlessly at MS, several ASP resource sites, and finally
> ended up here only to be insulted by a charge for something that should be
> in at least one of these books!
>
> Sigh. I still don't feel better after this rant but at least someone might
> take pity on this frustrated but motivated individual who wants to learn
> ASP. I don't know what else to do. (besides purchase that PDF... right).
>
> I'm ready to jump off a bridge.
>

What Kim is saying is WROX does teach how to execute a SQL command in ASP.  It does not teach SQL.  If
you know the SQL, then you know how to execute the command from ASP.  If you do not know the SQL, then you need to learn it from a
book on SQL.  It is that simple.


Subject: RE: Why do none of the three ASP Wrox books have anything about creating tables using ASP?
From: "Kim Iwan Hansen" <kimiwan@k...>
Date: Sat, 10 Aug 2002 16:55:51 +0200
X-Message-Number: 3

Don't jump off the bridge just yet, but instead consider this:
-Why don't the ASP books show me how to make a javascript popup window?
-The HTML in the ASP books is not crossbrowser compatible, why!!!!!!?!

Just like javascript, SQL isn't a part of ASP - SQL is a language on its
own, used to communicate with databases.

The ASP books you mention have surely given you examples of executing SQL in
ASP, just like they've showed you how to output HTML code (response.write).
They don't teach you JavaScript, HTML, SQL etc. in detail - they teach you
ASP!  The SQL you learn from the books is necessary in order to understand
how to execute a query through the command object, for example.

If you want to buy another Wrox book, you can take a look at the "Beginning
SQL", or you could download the free SQL BOL here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

A good place to look when you're searching for things at the internet is the
search engine google - consider this search:
http://www.google.com/search?q=create+table+in+sql+tutorial

-Kim

Hi, JS;

Have you considered creating a script and then setting up your database 
that way?

Ie a sample script might be: 

SAMPLEDB.SQL
create table1
(
    field1 varchar(255),

);

Hi, JS;

Have you considered creating a script and then setting up your database 
that way?

Ie a sample script might be: 

SAMPLEDB.SQL
create table1
(
    field1 varchar(255)
    ,field2 int
    ,primary key (field1)
);

And open it, much like you would in SQLPlus, or through MySQL, or the db 
you mentioned earlier. 

My own database setup isn't through ASP, I script it and then run the 
script in SQLPlus.

HTH,
Sandra