I agree with that. the LERG does not get generated by us. I push it immediately to Mysql every week. so you are recommending:
$query="SELECT LERG_6.SWITCH, `LERG_6.SHA INDICATOR` FROM LERG_6 WHERE `LERG_6.SHA INDICATOR` = 00;" (the backticks are around `LERG_6.SHA INDICATOR`) is this correct? -----Original Message----- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Saturday, December 06, 2003 2:46 PM To: Duke, Brian; [EMAIL PROTECTED] Subject: Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces. >can someone help me either fix my ODBC load or help me correctly syntax my php query >line? > > Try using backticks: `field with spaces` And try migrating away from Access, or you'll be increasingly more sorry as your project increases in size. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
