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 pass an upper.
The issue is not the table (or even column name) its the value within
it. Comparing 'mn0001' to 'MN0001' will fail.
--
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
