For those not familiar (I wasn't), Sprite provides an SQL interface to databases with an arbitrary text delimiter. Seemingly much like DBD::RAM. First, DBD::RAM is solidly two years more recent, uses the excellent DBI interface, and has a much greater user following (which can answer your questions more easily). So, take a look at DBD::RAM if you're doing something large.
I tried looking at the sample script you're using, but the URL is invalid. I'm sort of flying blind with your question, then, since you haven't told us what error you're receiving. It sounds like your scripts aren't able to find the module you're looking for, which would likely make it an install problem. In that case, how did you install the module? Many modules won't work straight out if you just download them and copy .pm's into a lib directory; you actually need to run the installer. Oftentimes this will be handled automatically for you by CPAN.pm: install -MCPAN -e 'install SomeModule'. If CPAN doesn't know about the module, you can try downloading the .tar.gz yourself, unpacking, and following the install directions. A side not which shouldn't be breaking your script: you should be using use instead of require in modern scripts; it lets the compiler check on the module before runtime to make sure everything is in order. Also, in your shebang line pass the -w parameter to the perl interpreter to enable the warnings pragma; that may give you valuable insight into what's going on. I'm not sure I answered your question, but feel free to come back with error messages, more specific quesitons, etc. for more help. P.S. Whoa! Just reread your question: what do mean by "I don't have access to Perl5.003"? You do have a perl interpreter, right? No module or script will work without Perl installed. Using an earlier version than that is extremely dangerous with CGI scripts as the interpreters have known security flaws. Have a good heart-to-heart with your administrator if that's the case. | [reply]
[d/l]
[select] |
Sprite's pretty ancient. If you want SQL with a "serverless" server,
I'd suggest using DBI with DBD::RAM or DBD::CSV.
The SQL is far more complete, and you'll even be happy when you get a live
person to whom you can submit bug reports!
-- Randal L. Schwartz, Perl hacker | [reply] |
I have Perl5.003 but I don't have access to it to add stuff. I can't install Sprite itself because I can't use Makefile.PLs which makes it difficult for me to install most modules.
But there is supposed to be a Sprite call(which is what I'm having problems with) that you can use with Sprite.pm if you can't install Sprite as is.
The URL should work for the sample file.
As far as I can tell the Perl we're using is a very stripped version with no added on libraries or modules.
The error I'm getting is "syntax error in file db_phone.pl at line 3, next 2 tokens "use lib"" | [reply] |
You might think you've got access to Perl 5.003, but
it looks very much like you're running your program using
some version of Perl 4 - that 'next 2 tokens "use lib"'
is a bit of a giveaway.
Try running perl -v to see which version is actually on
your path.
--
<http://www.dave.org.uk>
European Perl Conference - Sept 22/24 2000, ICA, London
<http://www.yapc.org/Europe/>
| [reply] |
| [reply] |
why can't you use "Makefile.PLs" ?? You can define a
prefix of where to install the files under.. just install
that somewhere you have access to (create your own perl
libs directory structure) and then just add it to your
include path with the -I command line option....
--
bliz
| [reply] |