All,
I am trying to get my Perl CGI to access an MS Access DB (for testing purposes only),
I am getting inconsistent responses from my system. I cannot insert a table
consistently. I have generated a form that defaults all form values to "1". This is
inserted into the database without error. When I insert titles of books with spaces
it returns an error. I have ordered the DBI book by O'Reilly, but I am in need of
some more immediate help if possible.
Is my problem with MS Access, or is there formatting to be done to the fields. I am
using CGI.pm as well to process all the returned values, does this cause any undesired
changes to the values? Could the comma between the author's last and first name be
causing the error? My insert statement looks approximately like this:
$SQL = "INSERT INTO books VALUES ($TITLE, $AUTHOR, etc)";
$STH = $DBH->do($SQL) or die "$!";
Thanks for any information,
Randy Peterman
Alt-N Technologies
www.altn.com
Helping the World Communicate.
