Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.

2003-12-06 Thread Daniel Kasak
Duke, Brian wrote: 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`

RE: MySql40, MSAccess2003, MyODBC3.51, and white spaces.

2003-12-06 Thread Duke, Brian
is 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

Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.

2003-12-06 Thread Daniel Kasak
Duke, Brian wrote: I have a question about spaces in fieldnames. locally running Access03 and using MyODBC3.51 to populate a MySQL40 database. The Database name and table names are ok. It's the field names I am having trouble with. The tables are huge and there are 26 tables. The ODBC process comp