Ask a Question related to ASP Database, Design and Development.
-
Marshal #1
Is there anything like an 'exists table' method I can use?
I need to run a querry from an asp page only if a certain
table exists in the data base. Is there any kind of
method that can look at the database (Access) and tell me
whether or not a certain table exists before running the
querry?
Thanks
Marshal Guest
-
Table exists?
Hi, can anyone tell me, how to find out if a table in an MS Access DB exists? Also, I'd like to find out, if certain columns exits if a table... -
Check if table exists
ON.KG wrote: One thing to consider: you are making a trip to the database to determine if a table exists. If it exists, you are then making... -
method name exists, property value exists, calling method fails
I have a class object I am calling in another class: class Stuff { var $myObj; function Stuff($myObj) { $this->myObj = $myObj; } -
Testing if a mysql table exists
Is there a simple way to test if a mysql table exists? JUST One line ! -
Table Exists
I am wanting to check the existance of a table in my informix db before I query it, since if I query a table that does not exist, it'll blow up on... -
Ray at #2 Re: Is there anything like an 'exists table' method I can use?
You could execute a query like so:
sSQL = "SELECT COUNT([name]) FROM [MSysObjects] WHERE [Name]='"
YourTableName & "' AND [Type]=1"
bTableExists = oYourADOConnection.Execute(sSQL).Fields.Item(0).Va lue > 0
This is untested.
Ray at work
"Marshal" <marshalwdr@hotmail.com> wrote in message
news:1ba0201c38829$5edb8fb0$a601280a@phx.gbl...> I need to run a querry from an asp page only if a certain
> table exists in the data base. Is there any kind of
> method that can look at the database (Access) and tell me
> whether or not a certain table exists before running the
> querry?
>
> Thanks
Ray at Guest
-
Aaron Bertrand - MVP #3 Re: Is there anything like an 'exists table' method I can use?
Another alternative is to use ADOX: [url]http://www.aspfaq.com/2350[/url]
"Marshal" <marshalwdr@hotmail.com> wrote in message
news:1ba0201c38829$5edb8fb0$a601280a@phx.gbl...> I need to run a querry from an asp page only if a certain
> table exists in the data base. Is there any kind of
> method that can look at the database (Access) and tell me
> whether or not a certain table exists before running the
> querry?
>
> Thanks
Aaron Bertrand - MVP Guest
-
Marshal #4 Re: Is there anything like an 'exists table' method I can use?
Thanks Ray...works like a charm. :)
Marshal
[Name]='">-----Original Message-----
>You could execute a query like so:
>
>sSQL = "SELECT COUNT([name]) FROM [MSysObjects] WHERE(sSQL).Fields.Item(0).Value > 0>YourTableName & "' AND [Type]=1"
>bTableExists = oYourADOConnection.Executecertain>
>This is untested.
>
>Ray at work
>
>"Marshal" <marshalwdr@hotmail.com> wrote in message
>news:1ba0201c38829$5edb8fb0$a601280a@phx.gbl...>> I need to run a querry from an asp page only if ame>> table exists in the data base. Is there any kind of
>> method that can look at the database (Access) and tellthe>> whether or not a certain table exists before running>>> querry?
>>
>> Thanks
>
>.
>Marshal Guest
-
Marshal #5 Re: Is there anything like an 'exists table' method I can use?
Thanks for the help...much appreciated. :)
[url]http://www.aspfaq.com/2350[/url]>-----Original Message-----
>Another alternative is to use ADOX:certain>
>
>
>
>"Marshal" <marshalwdr@hotmail.com> wrote in message
>news:1ba0201c38829$5edb8fb0$a601280a@phx.gbl...>> I need to run a querry from an asp page only if ame>> table exists in the data base. Is there any kind of
>> method that can look at the database (Access) and tellthe>> whether or not a certain table exists before running>>> querry?
>>
>> Thanks
>
>.
>Marshal Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
