Re: tried to install bookmarks asp page from http://www.perlmonth.com/features/apacheasp/apacheasp.html?issue=6 but get errors - dbd::csv

[Joshua Chamas <jo...@chamas.com>]

> WRFan wrote:
> 
> Hi,
> 
> I tried to install the apache asp bookmarks page from http://www.perlmonth.com/features/apacheasp/apacheasp.html?issue=6 on my apache server,
> 
> but when I start index.asp I get this error:
> 
> Errors Output
> 
>   1. errors compiling global.asa: DBD::CSV::db do failed: Cannot open .\bookmarks: No such file or directory at
>      C:/Programme/Server/Perl/lib/DBD/File.pm line 473. DBD::File::Statement::open_table('DBD::CSV::Statement=HASH(0x11f6f8c)',
>      'DBI::st=HASH(0x5392c28)', 'bookmarks', 0, 0) called at C:/Programme/Server/Perl/lib/DBD/CSV.pm line 130
>      DBD::CSV::Statement::open_table('DBD::CSV::Statement=HASH(0x11f6f8c)', 'DBI::st=HA... see compile error for rest
> 

The global.asa is supposed to create the bookmarks CSV database when it 
gets compiled into a /tmp/asp_apps_bookmarks/bookmarks with this line:

bookmark_id,username,title,url

It seems to me that this code should create the bookmarks table, but maybe
it doesn't?  I haven't looked at the bookmarks app for quite a while ...

unless(eval { $Db->do("select bookmark_id,username,title,url from bookmarks") }) {
    eval { $Db->do("drop table bookmarks"); };
    $Db->do(<<CREATE) || die("can't create table $DBI::errstr");
    create table bookmarks (
                            bookmark_id varchar(15),
                            username varchar(30),
                            title varchar(60),
                            url varchar(120)
                           )
CREATE
  ;
}

Good luck!

Josh

_________________________________________________________________
Joshua Chamas                           Chamas Enterprises Inc.
NodeWorks Founder                       Huntington Beach, CA  USA 
http://www.nodeworks.com                1-714-625-4051

---------------------------------------------------------------------
To unsubscribe, e-mail: asp-unsubscribe@perl.apache.org
For additional commands, e-mail: asp-help@perl.apache.org