Grant, thanks for the reply. The "TOP X" syntax is actually something
supported exclusively by MS-Access and will return a maximum of 'X' records
based on the "ORDER BY" directive. I tried changing my SQL statement to:
"SELECT Date, Title, Body FROM News ORDER BY Date DESC" based on your
recommendation, but $rs->Fields( 'Date' )->{Value}; still returns a null
value. Very weird stuff.
At 09:26 PM 01/18/01 +1300, Grant McLean wrote:
>From: David Chase [mailto:[EMAIL PROTECTED]]
> > I can retrieve a number of fields from an Access-97 database
> > without issue, but one field (Date) is always returned as
> > undefined.
>...
> > $sql = "SELECT TOP 10 Date, Title, Body FROM News ORDER BY Date DESC";
>...
> > $newsdate = $rs->Fields( 'Date' )->{Value};
>
>By my reading of the SQL, you query is not asking for a field
>called 'Date'. Perhaps you should try:
>
> $newsdate = $rs->Fields( 'TOP 10 Date' )->{Value};
>
>Regards
>Grant
-----------------------------------------------------
David Chase
coupland @ home.com
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activeperl
