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  Send bobbart an ICQ Message
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  Send bobbart an ICQ Message
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  Send bobbart an ICQ Message
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.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07