Web Wiz Support and Community Forums : MySQL error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 08:57:44 +0000 Mon, 13 Feb 2006 15:41:07 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18075 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MySQL error : I have also been using the mySQL...]]> https://forums.webwiz.net/mysql-error_topic18075_post99377.html#99377 Author: WebWiz-Bruce
Subject: 18075
Posted: 13 February 2006 at 3:41pm

I have also been using the mySQL version as the main bases of my development for the next beta version, then testing later in Access and SQL Server.

This means that in beta 2, the mySQL version will be allot more stable as most of the bugs and issues are now fixed.
]]> Mon, 13 Feb 2006 15:41:07 +0000 https://forums.webwiz.net/mysql-error_topic18075_post99377.html#99377 <![CDATA[MySQL error : The problem was in that page...]]> https://forums.webwiz.net/mysql-error_topic18075_post99376.html#99376 Author: WebWiz-Bruce
Subject: 18075
Posted: 13 February 2006 at 3:38pm

The problem was in that page I had omitted the code to check for mySQL, so it was defaulting to 'True' used for the Access version.

VbScript's defaults are:-
True = -1
False = 0

This means that for mySQL used in Web Wiz Forums, because 'True' and 'False' are usualy set in the vbScript and the myODBC driver is often used for ADO Inserts, that Web Wiz Forums mySQL version actualy uses -1 for 'True'


Edited by -boRg- - 13 February 2006 at 3:38pm]]> Mon, 13 Feb 2006 15:38:03 +0000 https://forums.webwiz.net/mysql-error_topic18075_post99376.html#99376 <![CDATA[MySQL error : In MySQL could not be used boolean...]]> https://forums.webwiz.net/mysql-error_topic18075_post99368.html#99368 Author: RAVALON
Subject: 18075
Posted: 13 February 2006 at 3:00pm

In MySQL could not be used boolean fields as Access....you have to use 1 or 0 value
 
 
]]> Mon, 13 Feb 2006 15:00:04 +0000 https://forums.webwiz.net/mysql-error_topic18075_post99368.html#99368 <![CDATA[MySQL error : There is a problem with the query...]]> https://forums.webwiz.net/mysql-error_topic18075_post97934.html#97934 Author: WebWiz-Bruce
Subject: 18075
Posted: 23 January 2006 at 2:26pm

There is a problem with the query on that page when using the mySQL version.

I am working on fixing this for the next beta release which will have much more testing done for the mySQL version.
]]> Mon, 23 Jan 2006 14:26:02 +0000 https://forums.webwiz.net/mysql-error_topic18075_post97934.html#97934 <![CDATA[MySQL error : I got a MySQL error yesterday...]]> https://forums.webwiz.net/mysql-error_topic18075_post97866.html#97866 Author: Pulver
Subject: 18075
Posted: 22 January 2006 at 9:25am

I got a MySQL error yesterday - but looking at the error I see that my host uses the 4.0.24 version of MySQL.

So I guess thats the problem...

Posting the error anyway - got this when I was trying to send a PM:

Quote Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.24-standard]Unknown column 'True' in 'where clause'

/forum/pm_new_message.asp, line 191

]]> Sun, 22 Jan 2006 09:25:57 +0000 https://forums.webwiz.net/mysql-error_topic18075_post97866.html#97866