Creating Table with Random Number

spinal007 · #1 Jun 1st, 2006, 06:54

This was sent to me as a private message, thought more people could help if it was here.

On behalf of cnn777:

Quote:

Hi -
I am new at ASP but have some good PHP experience.
I wrote a program in PHP that I need converted into ASP
Basically, I need some ASP code that will create tables in an SQL database called "test"
Everytime I access the ASP, the page needs to generate a random number, then use that random number as the table name.

This is the database structure:
Database: Test
Table 1: myrandomtable 39483438734
Table 2: myrandomtable 40584504584
Table 3: myrandomtable 93473497397
etc.
I tried this in ASP:
<%
dim thisrandomnumber
thisrandomnumber= rnd
strSQL = "CREATE TABLE" & " " & thisrandomnumber & " " &
"(" PK_id INTEGER PRIMARY KEY etc.
I keep getting errors - no idea why
I response.write the value and it looks like a random number
The SQL or ASP Parse error says:
'3498734' error
Help

spinal007 · #2 Jun 1st, 2006, 06:57

I think you need to be a bit clearer for us to help you.

1. At which point of the code exactly does the error happen?
2. What is the exact error message you're getting?
3. MSSQL or MySql?

Things you should do, first of all...

Since you're dynamically generating the SQL code, have you tried displaying it on the page?
This way you can see if the code you're trying to execute is what it should be. Look for missing brackets, quotes, etc...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Number one	unitedcraig	Search Engine Optimization (SEO)	21	Apr 18th, 2008 19:29
[SOLVED] Help Creating New .SQL Table (Beginner)	Aaron1988	Databases	16	Nov 4th, 2007 17:17
Creating a scroll bar within a table	Diablo	Web Page Design	5	Mar 12th, 2007 16:10
Need to align width of Float table with the table below	Vertabase	Web Page Design	4	Mar 8th, 2006 21:21
random number generation	djme	PHP Forum	2	Dec 28th, 2005 05:15

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
Creating Table with Random Number