Searching for all records but integer field is causing problems

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Searching for all records but integer field is causing problems
Date: 2002-03-25 19:24:12
Message-ID: 000801c1d432$a5ae4740$3200a8c0@jecinc.on.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

How do I do a select query for all records?

SELECT * FROM phpgw_categories WHERE cat_name = ? AND cat_owner = ? AND
cat_appname = 'notes'

cat_name = '*' works but cat_owner = '*' gives me an atoi error.

I was hoping to reuse the code segment of SQL that gets called repeatedly
for slightly different purposes but I can't get this to work

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jason Earl 2002-03-25 21:37:08 Re: Searching for all records but integer field is causing
Previous Message Henshall, Stuart - WCP 2002-03-25 15:14:56 Re: rules over multiple tables