Hi, I found one typo in 'Workshop&' which should be 'Workshop%' but it
still gives results containing majors with 'Customer%' and 'Warehouse%' in
them...
On Sun, Nov 18, 2012 at 2:21 PM, Khalid Al-Ghamdi <emailkg...@gmail.com>wrote:
> 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
>
>
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
