-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tuesday 22 July 2003 00:04, [EMAIL PROTECTED] wrote: > You are right above the max date query and I really appreciate your > help, but the subselect query its other question. I try the subselect > query with the 4.0.12-max win32 with the --new option in the command > line to start the server, according to the manual this should enable the > subselect feature, but it doesn’t, so I try with the 4.1 alpha win32 > version with the same error: > > RROR 1064: 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............ and so on.... > > any ideas why I cant use the subselect feature? I missing something > about the conf?? maybe my.ini??
I still haven't seen the query that has the error. Subselect does work in 4.1. If you'll post the query that has the error (and the the entire error message, the "near" is significant <g>) we'll be glad to help. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQE/HQxTjeziQOokQnARAp0xAJwOqpaWhSlXPNrpAz2bkRCfjFF2hQCeKB2C ZrZn9QuI3MPDbXcqY0RDFeI= =25tB -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
