HELP - can not drop table

[Snorkerz]

Can anyone help, I'm trying to change some code on an asp page, this
line:

mySQL="drop table snorkTable"

does not seem to close the table. Net time the page is refreshed I'm
told that Table 'snorkTable' already exists.

I suspect my syntax is wrong - can anyone help?

Thanx

Dave

[Aggro]

Snorkerz wrote:

does not seem to close the table. Net time the page is refreshed I'm
told that Table 'snorkTable' already exists.

"drop table tablename" will destroy the table, not close it. I don't
know anything about ASP, but the syntax is correct, assuming you have a
database selected.

Do you have any particular reason why you want to destroy the table
every time page loads? Isn't it enough if you just remove all rows from
it? "delete from tablename".

[Snorkerz]

Aggro <sp**********@yahoo.com> wrote in message news:<f7***********@read3.inet.fi>...

Snorkerz wrote:

does not seem to close the table. Net time the page is refreshed I'm
told that Table 'snorkTable' already exists.

"drop table tablename" will destroy the table, not close it. I don't
know anything about ASP, but the syntax is correct, assuming you have a
database selected.

Do you have any particular reason why you want to destroy the table
every time page loads? Isn't it enough if you just remove all rows from
it? "delete from tablename".

I'm going with 'Drop Table' because that's what the original
programers script required. But it doesn't seem to actually do it, as
I said in the OP, the page says "Table 'snorkTable' already exists".

I could post the whole asp page if it would help?

The table snorkTable is created earlier in the page to hold details of
some random settings and I've changed the name throughout the script
to ensure it doesn't clash with any other tables that might be opened
by other scripts.

[Aggro]

Snorkerz wrote:

I could post the whole asp page if it would help?

Like I said, I don't know ASP. I just know that the delete syntax is
correct, so I don't think seeing the asp code would help. Unless someone
else knows something about it. Propably they know better in some
asp-related newsgroup.

But perhaps this helps:
http://groups.google.com/groups?selm...stk8%404ax.com