Looks like it's not dereferencing $rs->Fields('mydate')->Value pointing to a
scalar.  I am not familiar with ADO, but have you tried this

print ${$rs->Fields('mydate')->Value};

Ilya Sterin

-----Original Message-----
From: Matthew Tedder [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:20 AM
To: [EMAIL PROTECTED]
Subject: Date/Time's with ADO


Question:  How can I read in and use Microsoft Access Date/Time values
using ADO?

my $mydate = $rs->Fields('mydate')->Value;

It gives the following: Win32::OLE::Variant=SCALAR(0x2109fcc)
when I try to print what was read.

Also... How do I append a row?  The O'reilly Perl DBI book doesn't go
into this in any level of detail at all.  Here's what I tried:

$rs->AddNew();
$rs->Fields('User')->Value = 'Fred';
$rs->Update();

It gives me the following error on the line where I try to assign 'Fred'
to the column:  Can't modify non lvalue subroutine call

Any answers from someone in the know would be greatly appreciated.

--Matthew

Reply via email to