Re: single row query rteturn more than one row

[gordon . dewis]

try:
select up_time from uptime where
             startdate in (select GREATEST(startdate)
                                  from uptime where
                                  hostname = 'twister')

-----Original Message-----
From: Xiaoxia Dong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 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
                                  hostname = 'twister')
DBD::Oracle::st execute failed: ORA-01427: single-row subquery returns
more than one row (DBD ERROR: OCIStmtExecute) at upget.pl line 35.

ORA-01427: single-row subquery returns more than one row (DBD ERROR:
OCIStmtExecute)

i only have one row under hostname 'twister' in the table and it runs
fine under oracle sql>.


dong