Searching for all records but integer field is causing problems

Поиск
Список
Период
Сортировка
От Brian Johnson
Тема Searching for all records but integer field is causing problems
Дата
Msg-id 000801c1d432$a5ae4740$3200a8c0@jecinc.on.ca
обсуждение исходный текст
Ответы Re: Searching for all records but integer field is causing  (Jason Earl <jason.earl@simplot.com>)
Список 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


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Henshall, Stuart - WCP"
Дата:
Сообщение: Re: rules over multiple tables
Следующее
От: Jason Earl
Дата:
Сообщение: Re: Searching for all records but integer field is causing