[Tutor] Help with a SQL Statement

Khalid Al-Ghamdi emailkgnow at gmail.com
Sun Nov 18 12:21:50 CET 2012


Hi All,

The SQL statement below doesn't return anything.. and I don't know why...
I've used the parans but still no luck. Any Suggestions?

    cur.execute("""select badge, name, stage, tc, major, package, subject,
course, sb_as from records where
                   sb_as = 0 and (subject like 'Workshop&' or subject like
'Basic%' or subject like 'Introduction%') and
                   (major not like 'Customer%' or major not like
'Warehouse%') order by tc""")

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20121118/6a4cebac/attachment.html>


More information about the Tutor mailing list