Using MySQL-4.0.15
For whatever reason I cannot use the following query in Cold Fusion or
Inside the control center for MYSQL or from the command line mysql.
Here is my query:
SELECT * FROM dbwebmaster d2
WHERE (menuid <> 0 AND website='CMS_INFORMATION' AND parentref = 4 AND
haschildren =1) AND (EXISTS(SELECT * FROM dbwebmaster d3 WHERE parentref =
d2.menuid))
HERE is the ERROR Message:
Syntax error or access violation: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near 'EXISTS(SELECT * FROM dbwebmaster d3 WHE
What's wrong with this query?? I've been using EXISTS for some time now
but not with MySQL.
Any help would greatly be appreciated.
Mitchell S. McKenzie
Assistant Programmer Analyst
Learning Environment & Internet Services
University of Nebraska Medical Center
Phone: 402-559-9306
Cell Phone: 402-708-1493
University of Nebraska Medical Center E-mail Confidentiality Disclaimer :
The information in this e-mail is privileged and confidential, intended
only for the use of the addressee(s) above.
Any unauthorized use or disclosure of this information is prohibited.
If you have received this e-mail by mistake please delete it and
immediately contact the sender.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
