Hi, mysql 4.018 script ColdFusion MX
I've got the rather miserable job of porting a MsAccess ODBC SQL application to Mysql. Most seems to work OK, but some of the queries fail ; Mysql seems to be "stricter ". Even though I solved the following problem myself, I'd like to know what debugging strategy people use to solve problems when they get the dreaded "Error in Mysql look in the manual" The following for instance SELECT tbl_invoice.SubProjectID, * FROM tbl_subproject AS sp INNER JOIN tbl_projectstatus AS ps ON sp.ProjectStatus = ps.ProjectStatus LEFT JOIN tbl_invoice ON sp.SubProjectID = tbl_invoice.SubProjectID WHERE (tbl_invoice.SubProjectID Is Null) AND (sp.ProjectID=1) AND (sp.Deleted=0) AND (ps.Invoice=1) ORDER BY sp.OrderBy DESC required the more specific sp.* rather than * (which access had tolerated) SELECT tbl_invoice.SubProjectID,>>>>sp. *<<<< FROM tbl_subproject AS sp INNER JOIN tbl_projectstatus AS ps ON sp.ProjectStatus = ps.ProjectStatus LEFT JOIN tbl_invoice ON sp.SubProjectID = tbl_invoice.SubProjectID WHERE (tbl_invoice.SubProjectID Is Null) AND (sp.ProjectID=1) AND (sp.Deleted=0) AND (ps.Invoice=1) ORDER BY sp.OrderBy DESC zzapper (vim, cygwin, wiki & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
