Matthew,
I use the ADO driver with Access but use insert and delete SQL statements. I haven't
had any problems doing so and the code is more portable as well. Here's a quick
example of an insert:
# Prepare the statement for execution
$sth = $dbh->prepare("
INSERT INTO PAGES (Page_ID, Template_ID, Body, Title, Meta_Keywords,
Meta_Description)
VALUES ('$FILE', $qtemplate, $qbody, $qpage_title, $qkeywords, $qdescription)
") or die "Can't prepare statement: $dbh->errstr\n";
# Check if statement prepared correctly
die "ERROR: Cannot prepare statement: $DBI::errstr\n" unless (defined $sth);
# Execute statement at database level
$sth->execute or die $sth->errstr;
# Clean up before exiting
$sth->finish; # release the statement handle resources
-Jim
Matthew Tedder wrote:
> Could someone potentiall help me.. I'm getting a message saying that this
>operation is not supported. It appears to be on the ->AddNew(); method. How can I
>insert and update data in Access databases in my question. What syntax can be used?
>I've already got reading solved.
> =================================================
>
> $rs->AddNew();
> $rs->Fields('User')->{Value} = "Bubba";
> $rs->Update();
