RE: [PHP-DB] time field query problems.

2002-07-30 Thread Steve Bradwell
: Re: [PHP-DB] time field query problems. Steve, > For some reason the below statement is not working. Can anyone tell me why? > > Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE < now() > AND ORDER_NO = '5' AND EDIT_LOCK > 0; > > -EDIT_

Re: [PHP-DB] time field query problems.

2002-07-29 Thread DL Neil
Steve, > For some reason the below statement is not working. Can anyone tell me why? > > Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE < now() > AND ORDER_NO = '5' AND EDIT_LOCK > 0; > > -EDIT_LOCK is a MySQL (ver 3.23.49-max) time field, allows nulls, default is > NULL. >

Re: time field query problems.

2002-07-29 Thread Benjamin Pflugmann
Hi. On Mon 2002-07-29 at 14:41:30 -0400, [EMAIL PROTECTED] wrote: > Sorry to repost but I typed in the wrong sql statement in my previous post. Ah. Okay. > For some reason the below statement is not working. Can anyone tell me why? > > Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL

time field query problems.

2002-07-29 Thread Steve Bradwell
Sorry to repost but I typed in the wrong sql statement in my previous post. For some reason the below statement is not working. Can anyone tell me why? Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE < now() AND ORDER_NO = '5' AND EDIT_LOCK > 0; -EDIT_LOCK is a MySQL (ver 3