Re: Re: Didn't mention if you'd tried . . .

I believe this

WHERE year = '2002',
AND month = '3',
AND day = '16',
AND time_start = '1:00 PM',
AND time_end = '12:00 PM',
AND title = 'Faciltiative Leadership Training',
[download]

should read

WHERE 
    year = '2002'
AND 
    month = '3'
AND 
    day = '16'
AND 
    time_start = '1:00 PM'
AND 
    time_end = '12:00 PM'
AND 
    title = 'Faciltiative Leadership Training'
[download]

As in there should be no commas in between the AND clauses.

Think of a where like an if statement and it becomes obvious

  if (year == '2002' && month == '3' && day = '16'
      && $time_start eq '1:00 PM' && $time_end eq '12:00 PM'
      && $title  eq 'Faciltiative Leadership Training') {
  #yada-yada-yada
 }
[download]

is correct but

  if (year == '2002', && month == '3', && day = '16',
      && $time_start eq '1:00 PM', && $time_end eq '12:00 PM',
      && $title  eq 'Faciltiative Leadership Training') {
  #yada-yada-yada
 }
[download]

is not...

:-)

Yves / DeMerphq
---
Writing a good benchmark isnt as easy as it might look.

Comment on Re: Re: Didn't mention if you'd tried . . . Select or Download Code

Replies are listed 'Best First'.
Re: Re: Re: Didn't mention if you'd tried . . . by jerrygarciuh (Curate) on Apr 15, 2002 at 13:38 UTC
I agree, I added the commas last night in response to other's suggestions. They are out now and error continues. Thx jg _____________________________________________________ Think a race on a horse on a ball with a fish! TG	[reply] [d/l]
Re: Re: Re: Re: Didn't mention if you'd tried . . . by demerphq (Chancellor) on Apr 15, 2002 at 14:34 UTC
For the record, we now know that jerrygarciuh in fact omitted a comma, and once it was removed his troubles were resolved... Yves / DeMerphq --- Writing a good benchmark isnt as easy as it might look.	[reply]