|Mime-Version: 1.0
|Content-Disposition: inline
|User-Agent: Mutt/1.3.20i
|Date: Thu, 23 Aug 2001 13:16:01 -0600
|From: Roberto Mello <[EMAIL PROTECTED]>
|Subject: Re: [AOLSERVER] No-rows in PostgreSQL selection
|To: [EMAIL PROTECTED]
|
| Hi Keith,
|
|On Thu, Aug 23, 2001 at 10:44:23AM -0600, Keith paskett wrote:
|>
|> It works fine if there are rows returned.
|> I would have expected the 'ns_db select' to be ok but get 0 back from the
|> first call to 'ns_db getrow'
|>
|> I would like to return an empty list if there are now rows matching the
|> query.
|>
|> Any suggestion/code snippets? Surely the OpenACS team has dealt with this.
|
| What version of the PostgreSQL driver do you have? If you are using
|the one that comes with AOLserver, scrape that and grab the one from
|openacs.org.
| I just tested your code here on my machine and I don't see the
|problem. I get an empty list.
OK it was failing because of my bad SLQ query. Some better error messages
(ala Oracle driver) would sure be nice for people like me.
|
| -Roberto
|--
|+------------| Roberto Mello - http://www.brasileiro.net |------------+
|Computer Science, Utah State University - http://www.usu.edu
|USU Free Software & GNU/Linux Club - http://fslc.usu.edu
|Space Dynamics Lab, Developer - http://www.sdl.usu.edu
|OpenACS - _Your_ free web toolkit - http://openacs.org
|I'm sorry -- my karma ran over your dogma.
------
Keith Paskett [EMAIL PROTECTED]
Space Dynamics Laboratory PGP or GPG encrypted mail preferred
1695 North Research Parkway 435-797-4195
Logan, Utah 84341
