Re: single row query rteturn more than one row

2001-03-16 Thread Ronald J Kimball
On Thu, Mar 15, 2001 at 04:12:15PM -0500, Dan Hoover wrote: You could also.. sql=select up_time from uptime where startdate = (select distinct startdate from uptime where hostname = 'twister'

single row query rteturn more than one row

2001-03-15 Thread Xiaoxia Dong
i got following message when i run sql statement as sql sql=select up_time from uptime where startdate = (select GREATEST(startdate) from uptime where hostname = 'twister') DBD::Oracle::st execute failed:

Re: single row query rteturn more than one row

2001-03-15 Thread gordon . dewis
15, 2001 14:44 To: [EMAIL PROTECTED] Subject: single row query rteturn more than one row i got following message when i run sql statement as sql sql=select up_time from uptime where startdate = (select GREATEST(startdate) from uptime where

Re: single row query rteturn more than one row

2001-03-15 Thread Ronald J Kimball
On Thu, Mar 15, 2001 at 02:43:45PM -0500, Xiaoxia Dong wrote: i got following message when i run sql statement as sql sql=select up_time from uptime where startdate = (select GREATEST(startdate) from uptime where

Re: single row query rteturn more than one row

2001-03-15 Thread Michael A. Chase
PROTECTED] Sent: Thursday, March 15, 2001 11:43 AM Subject: single row query rteturn more than one row i got following message when i run sql statement as sql sql=select up_time from uptime where startdate = (select GREATEST(startdate) from up

Re: single row query rteturn more than one row

2001-03-15 Thread Michael A. Chase
day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Dan Hoover" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 1:12 PM Subject: RE: single row query rteturn more than one row You could also.. sql=select up_ti