Re: [Tutor] Help with a SQL Statement

On 18/11/12 11:29, Khalid Al-Ghamdi wrote: 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? I'll restructure it to how I think you want it... cur.execute(""" select badge, name, stage, tc, major, package

Re: [Tutor] Help with a SQL Statement

On Nov 18, 2012 11:30 AM, "Khalid Al-Ghamdi" wrote: > > 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 wrote: >> >> Hi All, >> >> The

Re: [Tutor] Help with a SQL Statement

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 wrote: > Hi All, > > The SQL statement below doesn't return anything.. and I don't know why.

[Tutor] Help with a SQL Statement

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 'Wo