A few questions about creating using asp

[Jeff]

First, how can I get asp to create a table in en existing DB that is an
atuonumber. Meaning.. If say table 56 exists alrady, I want it to create 58
as the name. Along with this, I need to copy the fields from table temp,
into the above DB. Can this be done?

Thanks
Jeff

 

[dlbjr]

Yes, But why?

 

[Jeff]

I am writing a tournement script, for bracket style tourney's. There will be
different hosts that will create and admin their own tourneys. SO each
tourney, I want to create it's own table, and the number I am refering to,
will be that tourney id. all hyperlinks in the folder that gets created,
will pass a variable of the toutney id. This way, there can be more than 1
tourney running at the same time.
does this make sense??
I have the tourney scripts written, and i run my own tourneys. The next
phase is to make it where others can run tourneys.
Jeff

 

[dlbjr]

It would be far more efficient with a tournament table assigning ID's to each tournament.
Can I see the table and field layout?

dlbjr
Pleading sagacious indoctrination!

 

[Jeff Cochran]

First, how can I get asp to create a table in en existing DB that is an
atuonumber. Meaning.. If say table 56 exists alrady, I want it to create 58
as the name. Along with this, I need to copy the fields from table temp,
into the above DB. Can this be done?

Man, you're *still* going at this database format?

If you insist, why not keep a table that is the next number to be
used? Each time you create a table, run a query to increment the
number.

Jeff

 

[Jeff]

Yes Jeff... that is want I am trying to do. I want to create the next table
in succesion. The same for the folder, so the folder and table number would
be the same. I have made some changes in the DB, but am doing it this way,
because there could be up to 30 or 40 tourneys running at the same time.
That is why I want each to have their own table in the DB.
Jeff

 

[Jeff Cochran]

Yes Jeff... that is want I am trying to do. I want to create the next table
in succesion. The same for the folder, so the folder and table number would
be the same. I have made some changes in the DB, but am doing it this way,
because there could be up to 30 or 40 tourneys running at the same time.
That is why I want each to have their own table in the DB.

The most controllable way is to keep track of the number you're using.
Creat a table with a single column and a single row. Call it
tblNextTorneyNumber or the like. Increment it each time you create a
tournament table/folder/whatever.

Jeff

 

[Jeff]

The most controllable way is to keep track of the number you're using.

Creat a table with a single column and a single row. Call it
tblNextTorneyNumber or the like. Increment it each time you create a
tournament table/folder/whatever.

Jeff

ok. i sortof have something like that. I have a table that all the tourney
info goes into, and it had an auto ID. it holds the info like, time date
course... that stuff.
So my question is this then, since I already have the tourney ID there, how
do I pull that number with asp, and make the folder.
I have decided to do what you all said before, and keep all the tourneys in
one table, so when someone signes up, the tourney ID they signed up for goes
into a field. by doing it wrong before, i realized you all were right.

the DB has 2 tables. one is called admin(the tourney info itself) and the
other is called rounds(contestants info and their bracket info)

the reason i want the new folder to be created, is so folks can see where
they are, and sign up for the correct tourney. this is hard to explain, i
hope i am making myself clear, and haven't confused you more.
Jeff
..