ASP and SQL

[Anon]

Hi all - im trying to create a table in access db using asp (vbscript). Below is what im trying to do, T1 is inputted by the user, so its stored as T1. I want to create a table called UserTable in UML.db with one heading of T1. Is the below code right, as im having errors with it??

If (X1 = 1) Then
SQLCREATE = " CREATE TABLE UserTable (" & T1 & " Char(20)); "
set conn = server.createobject("ADODB.Connection")
conn.open "UML"
set crte=conn.execute(SQLCREATE)
end if

Many Thanks.

[Anon]

uh - this is a PHP site - not ASP

try http://www.asp101.com/index.asp

[brandonschnell]

lol.

hmmmm.

if (($X1 == 1) && (isset($T1))
{
$sql = "CREATE TABLE UserTable ($T1 Char(20))";

mysql_db_query("UML", $sql);
}

now isn't that easier to read than vbscript?

[kparker]

SHHHHHHH! You're giving away our competitive advantage!!!! :-)

[mithril]

Somehow I doubt it's a big secret anymore that PHP rocks and ASP licks🙂

A buddy of mine gave me a brief description of the code he used to connect ASP to MS SQL Server (not too info though since it's a "corporate secret"). Took him 75 lines of code to execute 3 queries. How wasteful!! To be fair though, probably half of those lines were the SQL query strings, but still......