[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    Re: Empty result
From:       Schalk <schalk () volume4 ! com>
Date:       2005-09-14 16:50:21
Message-ID: 432854CD.5090606 () volume4 ! com
[Download RAW message or body]

Andrew

Changing my code to:
while(rs.next()) {        
        out.println(rs.getString("lb_date"));
        }

Did the trick, thanks!

Andrew Houghton wrote:

> rs.next() ?
>
> On Sep 14, 2005, at 9:26 AM, Schalk Neethling wrote:
>
>> Alan
>>
>> Yes it does produce 1 row.
>>
>> Alan Williamson wrote:
>>
>>
>>>> I am executing the following query:
>>>> SELECT MAX(last_edited) AS edited_date FROM ab_leader_board
>>>>
>>>>
>>>
>>> Schalk, have you ran this query directly at the mysql console?
>>>
>>> Does it yield a result there?
>>>
>>>
>>>
>>
>> --  Kind Regards
>> Schalk Neethling
>> Web Developer.Designer.Programmer.President
>> Volume4.Business.Solution.Developers
>> emotionalize.conceptualize.visualize.realize
>> Landlines
>> Tel: +27125468436
>> Fax: +27125468436
>> Web
>> email:schalk@volume4.com
>> Global: www.volume4.com
>> Messenger
>> Yahoo!: v_olume4
>> AOL: v0lume4
>> MSN: volume4_@hotmail.com
>>
>> We support OpenSource
>> Get Firefox!- The browser reloaded - http://www.mozilla.org/ 
>> products/firefox/
>> The information transmitted is intended solely for the individual  or 
>> entity to which it is addressed and may contain confidential and/ or 
>> privileged material. Any review, retransmission, dissemination  or 
>> other use of or taking action in reliance upon this information  by 
>> persons or entities other than the intended recipient is  prohibited. 
>> If you have received this email in error, please  contact the sender 
>> and please delete all traces of this material  from all devices.
>>
>>
>>
>> -- 
>> MySQL Java Mailing List
>> For list archives: http://lists.mysql.com/java
>> To unsubscribe:    http://lists.mysql.com/java?unsub=aah@roarmouse.org
>>
>>
>
>
>

-- 
Kind Regards
Schalk Neethling
Web Developer.Designer.Programmer.President
Volume4.Business.Solution.Developers



-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=mysql-java@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic