Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Content Display editor and mysql		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bobbart
Junior Member

USA
163 Posts
Posted - 16 August 2002 :  19:45:09  Show Profile
error '80004005'


/contentdisplay_editor.asp, line 147

Thats the error I get.

<%'########### Check Whether the Table Exists in the Database ######
TableExists = False
line 147 --> set rsCheckDB = my_Conn.OpenSchema(adSchemaTables)
do while not rsCheckDB.eof
if rsCheckDB("table_name") = "FORUM_DC_TEMPLATES" then
TableExists = True
Response.Write "Table Exists: " & rsCheckDB("table_name")
end if
rsCheckDB.movenext
loop
if TableExists then

GauravBhabu
Advanced Member

4288 Posts
Posted - 16 August 2002 :  21:26:22  Show Profile
MySql does not support adSchemaTables. It uses Show Tables instead. More information is available here:

http://www.mysql.com/doc/en/SHOW_DATABASE_INFO.html
Edited by - GauravBhabu on 16 August 2002 21:26:53
Go to Top of Page

bobbart
Junior Member

USA
163 Posts
Posted - 16 August 2002 :  21:57:12  Show Profile
quote:
Originally posted by GauravBhabu

MySql does not support adSchemaTables. It uses Show Tables instead. More information is available here:

http://www.mysql.com/doc/en/SHOW_DATABASE_INFO.html


Umm could you help me fix this? I am new with mysql.
Go to Top of Page

GauravBhabu
Advanced Member

4288 Posts
Posted - 16 August 2002 :  22:11:24  Show Profile
quote:
Originally posted by bobbart
Umm could you help me fix this? I am new with mysql.


You are still one Step ahead of me. But I will try to find how to use the Show Tables Method.
CSS and HTML4.01 Compilant Snitz Forum . ForumSquare . Rakesh Jain

It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.

Prayer Of Forgiveness
"I forgive all living beings. May all living beings forgive me!
I cherish the friendliness towards all and harbour enmity towards none." -- Aavashyaka Sutra(Translated)
Go to Top of Page

bobbart
Junior Member

USA
163 Posts
Posted - 19 August 2002 :  09:56:46  Show Profile
Can someone help me with this please?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07