EZDB

[Ryan]

Hello,
I am using ezperl's ezdb 3.0, and am hoping anyone with some
experience can help me out. ezperl's website does not offer any help
and the forum on that website is not working, and hasn't been for
sometime now, and email's go unanswered.

The problem I am having is when ezdb returns a search result with more
than 20 entries it will display just the first 20, then put a
hyperlink at the bottom of the page to view the next page. The format
of the hyperlink is:

http://www.foobar.com/cgi-bin/ezdb....rieve&session_id&page-range&keyword&%%%%db=20......

now when anyone clicks this link that is not using netscape 6, it
works as expected. If they are using netscape 6 then they get this
error:

25db no such field name in database.

in the address bar of the browser the url reads:

http://www.foobar.com/cgi-bin/ezdb....rieve&session_id&page-range&keyword&%%%%db=20......

so you can see where it is getting the: 25db no such field name in
database. So it appears that netscape somehow is posting formated
urls to the cgi script, and it is mis interprting the data.

I have found that all the information after keyword is unneccesary,
because the info it is passing the script is already contained in the
config files for the database, so it's redundent realy.

I don't want to go into the script and modify it to drop the last part
of the URL if I can avoid it. Has anyone had any problem of this
sort? Am I cutting my own throat by using EZDB? It does seem like
support for ezdb has gone out the window. Any help would be
appreciated.

Thanks
Ryan

 

[James Willmore]

On 22 Aug 2003 07:47:40 -0700

I don't want to go into the script and modify it to drop the last
part of the URL if I can avoid it. Has anyone had any problem of
this sort? Am I cutting my own throat by using EZDB? It does seem
like support for ezdb has gone out the window. Any help would be
appreciated.

IMHO, you may want to use the flury of other databases or database
type formats available.
But, again, that's my opinion.

For small databases, with one key, you could use a DBM solution.
For large databases, you could use one of the many open source RDBMS's
avaliable (ie MySQL, PostgreSQL, etc.)
You can even us a CVS flat file solution, but performance is not very
good.

All of these have the appropriate modules to aid in design. (ie there
is the DBD:g module, used in conjuction with the DBI module, to
access a PostgreSQL database -or- the DBD::CSV module, used with the
DBI module, to access a CSV flat file datasource).

Again, these are just suggestions.

Jim

 

[Ryan]

IMHO, you may want to use the flury of other databases or database
type formats available.
But, again, that's my opinion.

For small databases, with one key, you could use a DBM solution.
For large databases, you could use one of the many open source RDBMS's
avaliable (ie MySQL, PostgreSQL, etc.)
You can even us a CVS flat file solution, but performance is not very
good.

All of these have the appropriate modules to aid in design. (ie there
is the DBD:g module, used in conjuction with the DBI module, to
access a PostgreSQL database -or- the DBD::CSV module, used with the
DBI module, to access a CSV flat file datasource).

Again, these are just suggestions.

Jim

Thanks for the input. The database is a CSV file anyhow, and I am
going to eventually write my own CGI script and retire the ezdb
program. I am fairly new to perl, but my shell background has sped up
the learning process. I have not had any experience writing CGI, so I
decided to tackle other problems, and use some freeware to help speed
things up. EZDB is not bad, and this is the first real problem I've
had with it. It's really geared towards more complicated things,
including relationals. Anyway, I just thought it was wierd that the
problem only arises w/ netscape six. Not even my old netscape 4 does
this. But that is the only commonality that I see between the
different times this problem has come up (which is ony two, so it is
still very possible that netscape is not the culprit). Thanks again
for the input, now I know where to start when I begin rewriting the
search program.

Ryan