Re: SQL annoyance

2004-01-04 Thread R. Joseph Newton
dan wrote: > Hi there, quick and annoying SQL problem, was debating about whether to post > it here or DBI, I figured DBI was for DBI related issues, and this is just a > plain SQL problem. So it should really be posted on an RDBMS list. > Excuse me if I'm wrong though, but thought I'd ask > any

Re: SQL annoyance

2004-01-04 Thread Rob Dixon
Dan wrote: > > Hi there, quick and annoying SQL problem, was debating about whether to post > it here or DBI, I figured DBI was for DBI related issues, and this is just a > plain SQL problem. Excuse me if I'm wrong though, but thought I'd ask > anyway. > > I have an SQL statement as follows, > >

Re: SQL annoyance

2004-01-04 Thread Philipp Traeder
Hi Dan, On Sun, 2004-01-04 at 03:34, dan wrote: > I have an SQL statement as follows, > SELECT * FROM memodata WHERE to=1 AND readdate=sent ORDER BY id ASC > which fails giving an error on the to=1 part. > I've tried doing that statement without the 'to=1 AND' part, and it works > fine returning a

SQL annoyance

2004-01-04 Thread dan
Hi there, quick and annoying SQL problem, was debating about whether to post it here or DBI, I figured DBI was for DBI related issues, and this is just a plain SQL problem. Excuse me if I'm wrong though, but thought I'd ask anyway. I have an SQL statement as follows, SELECT * FROM memodata WHERE to