I am running the MySQL 4.0.18 on the production Red Hat server, and 4.1.1a-alpha on my development XP box.
Both are running CF MX 6.1.
My SQL string is :
SELECT fieldid, value, clientID, crmfields.type, crmfields.english FROM crm LEFT JOIN crmfields ON (crm.fieldid = crmfields.id) WHERE crmfields.type != "fileField" AND crm.clientid IN (SELECT crm.clientid FROM crm WHERE crm.value LIKE '%f%')
works fine on my dev box, but not on the production server. it throws a syntax error.
I am assuming that there is a difference somewhere..? Can anyone tell me how i can change my String so that it will work on bot servers. I don't really want to upgrade the production box to the alpha. yet...
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
