better late than never..
i'd just like to recommend some more hash-friendly routines for these
kind of operations. i know that they are relativly tricial to code, but
would make it all seem more natural for the beginners, methinks.
something like
$dbh-hash_do(INSERT INTO table (?) VALUES (?),
Paul DuBois wrote:
At 21:17 -0600 3/16/03, Moritz von Schweinitz wrote:
hi, all.
i always thought that the (one of the) whole purpose of the
prepare/execute/fetch trinity was to let the db-server do all the
things a db-server's supposed to do, and then return a row at a time
(some cache
hi there (again)
i was just wondering whether there's any ppm of dbd-mysql flying around
for perl 5.8 somewhere for the rest of us stuck on win32 machines w/o a
compiler.
i'd really like to updadate to 5.8, but i just can't live without mysql
(and Tk, for that matter).
the ppm that ilya's
okay, i installed both the DBI and dbd-mysql ppds from ilya's PPM
repository, but now all i get is:
_
Can't load 'C:/Perl/site/lib/auto/DBD/mysql/mysql.dll' for module
DBD::mysql: load_file:The specified module could not be found at
C:/Perl/lib/DynaLoader.pm line 206.
_
which i don't
hi there,
somehow i can't get $sth-{ParamValues} working using DBD::mysql (i
guess it should support that feature, or?).
anyhow, the docs say:
-
ParamValues (hash ref, read-only)
Returns a reference to a hash containing the values currently bound
to placeholders.
hi there,
does dbd::mysql support the $sth-{ParamValues} ?
i'm trying to get this working using v2.0400 (from activestate's ppm),
and all i get is undefs (even though $sth-{'NUM_OF_PARAMS'} returns the
expected number of placeholders.
is activestate's ppm out of date, or does the current
Tim Bunce wrote:
On Tue, Nov 26, 2002 at 03:54:56PM -0600, Moritz von Schweinitz wrote:
Hi there,
this is kinda OT, since i fear it's more of a mysql than dbi issue, but
here goes...
the thing is that i have this long-running perlTk app. if i forcefully
bring my database-servre down (simply
Hi there,
this is kinda OT, since i fear it's more of a mysql than dbi issue, but
here goes...
the thing is that i have this long-running perlTk app. if i forcefully
bring my database-servre down (simply brutaly switching it off - my
system has to be able to handle really painful stuff like
Greetings,
Does anyone have any experience/recommendations regarding the following:
I'm doing this app that displays information from a (mysql) database via
CGI. this program prints little change this value icons next to the
values.
right now, all users log in with ther login/password, the
good morning, everybody.
does anybody have any experience with connecting to this BASIS
DataServer thingy?
I have a server here running BASIS visualPro/5 with that dataserver
(even though nobody seems to know what exactly the dataserver's supposed
to be good for, since they're doing it all
just wondering: is it good practice to answer OT mails with a this is
is OT - go away!...but the answer is (thus encouraging further OT
posts) or simply with an this is OT! (thus discouraging newbies [who
are most likely the authors of OT-postings] to use the whole
just a general suggestion, since you seem to be starting with the DBI:
_do_ use placeholders (check the fine manual about those). they make
everybody's life easier and safer, and are really not complicated at
all.
if you would've been using placeholders, you'd be tackling more
interesting
pardon my ignorance on the matter, but wouldn't a pure-perl DBI make it
easier (possible?) to compile scripts using the dbi to stand-alone
executables? even though it would be nice if every maychine had perl
installed, but the possibility of _easily_ deploying stand-alone
programs for all those
I think this one popped up here before, but didn't get a response:
I updated my mysql, and since then DBD::mysql always tells me that it
can't connect through the socket /var/lib/mysql/mysql.sock
i work around that with a fs-link to /tmp/mysql.sock , but that can't
really be a solution. is
AFAIK the mysqladmin tool doesn't really do anything else than alter the
predefined database called mysql that's in charge of all the
configuraton of the other databases - why not simply alter that DB with
the DBI? i think the mysql docs describe the db-structure in more
detail...
just my two
Is it possible to print the same kind of messages that
you would get
running SQL (MySQL) from the command prompt, with a browser?
in case you are refering to error-messages,
use CGI::Carp qw(fatalsToBrowser);
is incredibly useful.
M.
Say I want to describe a table:
my
i would of course never dare to doubt the fine-ness of the manual, and
am pressing for a nobel prize for literature for it, BUT:
is there really no resource-friendly, fastsimple way to find out how
many rows a query could return, without weeding thru all the rows - i
somehow doubt that websites
, i guess (insertrow_hashref ?).
shouldn't be too hard to code, but if it's already out there, that'd be
cool
anybody?
M.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 5:33 PM
To: Moritz von Schweinitz; [EMAIL PROTECTED
i asked the same thing a while ago - Tim was so kinf to point me to
ftp://not.tdlc.com/pub/
(the docs in the .pm are way more useful than anything else i saw
anywhere on the 'net)
still: is anyone actually using that module? where's the catch? if it
does all it seems to be able to do, there
Obsolete my ass.
i was of course referring to b-trieve as a company, and not to b-tree
data structures in general.
M.
good morning y'all!
does anybody know how to make a script look like a directory?
i.e.: i want a url like this:
www.whereever.com/i_am_a_script/i_am_an_argument
or is there a way to make filesystem-links to remote URLs?
(i don't have root on that particular machine, but i might be able to
sorry!
wrong list. please ignore.
M.
oh, yea - i forgot: i simply do() a little file at the beginning of my
cgi-stuff, and that one connects to the db (and dumps out headers, etc),
so i can change any setting there at the push of a button (and i can
tell apache to ignore that init-file for security's sake). that works
just fine -
[more of a html/security/perl
thing].
Moritz von Schweinitz
[EMAIL PROTECTED]
can't help on the first one, but for the second question try:
http://search.cpan.org/search?mode=modulequery=excel
(the spreadsheet-modules work very well, but lack multilpe table
support)
M.
-Original Message-
From: perl is [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06,
SELECT * FROM table ORDER BY updated DESC LIMIT 3;
or simply $sth-fetchrow_whatever as you need.
(or didn't i get the question?)
M.
-Original Message-
From: Tomasi, Chuck [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 11:32 AM
To: [EMAIL PROTECTED]
Subject: Select
Hi!
i was just wondering what happened to DBD::Multiplex, since nobody out
here seems to know whether its being continued, already finished,
almost done, ready when it's ready, etc. , and there seems to be a
definite demand for it
Cheers, and thanks for all the fish (and DBI),
M.
27 matches
Mail list logo