asp to create mysql table with user input

[suseli]

Hi i have a mysql database named "dbgallery".

Is there anyway that i can create a html form where user can enter the name of the table and click submit to create the table with that name in the dbgallery database.

 

[philhege]

Assuming that your database connection account has DDL privileges, you can construct a CREATE TABLE statement, using the user's input as the table name. As always, be sure to use CFQUERYPARAM in your statement construction.

Look up CREATE TABLE in your DB's docs for the syntax.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[philhege]

YEESH. Forget the CFQUERYPARAM piece (I have ColdFusion on the brain). The intent is to make sure that you avoid SQL statement injection.

Happy New Year!

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[suseli]

Im quite newbie in asp,

Will be very grateful if u can post the scripts here please.

 

[philhege]

You construct and call a CREATE TABLE statement the same way that you would issue a SELECT statement.

See

http://dev.mysql.com/doc/refman/5.0/en/create-table.html

for the syntax.

Better still, create a MySQL stored procedure that accepts the user table name as a parameter. Call the stored procedure in your ASP code.

For an example of how to use ASP to create a table, go to

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=8

Also, see

http://www.4guysfromrolla.com

and

http://www.15seconds.com

for more ASP examples.

Good luck!

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.