Re: [Tutor] formatting sql Was: Some help Please

2012-02-15 Thread James Reynolds
On Wed, Feb 15, 2012 at 1:30 PM, Alan Gauld wrote: > On 15/02/12 18:03, James Reynolds wrote: > > >In you table the acc_id is 'mn0001' >> >In your sql Acc_ID = 'MN0001' >> >Why the difference in case? >> >> Normally, sql doesn't care about case with respect to table names. I >> believ

Re: [Tutor] formatting sql Was: Some help Please

2012-02-15 Thread Alan Gauld
On 15/02/12 18:03, James Reynolds wrote: >In you table the acc_id is 'mn0001' >In your sql Acc_ID = 'MN0001' >Why the difference in case? Normally, sql doesn't care about case with respect to table names. I believe in certain implementations they are always lower case, even if you p

Re: [Tutor] formatting sql Was: Some help Please

2012-02-15 Thread James Reynolds
On Wed, Feb 15, 2012 at 12:13 PM, bob gailer wrote: > Welcome to python help. We are a few volunteers who donate time to assist. > > To assist you better: > 1 - provide a meaningful subject line - such as "formatting sql" > 2 - tell us what OS and Python version you are using. > 3 - what is your

[Tutor] formatting sql Was: Some help Please

2012-02-15 Thread bob gailer
Welcome to python help. We are a few volunteers who donate time to assist. To assist you better: 1 - provide a meaningful subject line - such as "formatting sql" 2 - tell us what OS and Python version you are using. 3 - what is your prior Python experience? On 2/15/2012 9:17 AM, JOSEPH MARTIN M