On Wed, 1 Dec 2004, Rhino wrote:
> > I'm using mysql 4.1.7 and perl 5.8.1 on OS X 10.3
It also wouldn't hurt you to upgrade past all the minor updates of your
other components. That means 4.1.7 (check), 5.8.6, and 10.3.6. I'm sure
Perl had a lot of bug fixes or improvements after 5.8.1, especi
- Original Message -
From: "angie ahl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, December 01, 2004 9:26 AM
Subject: Unicode (utf8) and MySQL (with Perl)
> Hi List.
>
> Please excuse the cross posting but I&#
Hi List.
Please excuse the cross posting but I've been scouring the archives
and no joy as yet.
I'm trying to get Perl and MySQL using utf8 happily and I've followed
several tutorials but am not getting the same results.
I've got a load of utf8 characters like so (perl):
my %uni = (
heb
At 12:58 13/11/2002 +0200, Octavian Rasnita wrote:
Hi,
Hi all,
I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under
Windows 2000) but after installing Perl 5.8, ppm can't find this module
anymore.
I had the same issue, then I removed Perl and re-installed the
below early
Did you remember to allow backwards compatibility in @INC
for perl 5.6.1?
~K Black
-Original Message-
From: Octavian Rasnita [mailto:orasnita@;home.ro]
Sent: Wednesday, November 13, 2002 2:58 AM
To: MySQL List
Subject: Using MySQL with Perl 5.8?
Hi all,
I was able to install the
Hi all,
I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under
Windows 2000) but after installing Perl 5.8, ppm can't find this module
anymore.
I could find only the module DBD::mysqlPP for pure Perl.
I don't understand what pure perl means but I've seen that this module
acce
Here's an example:
-
#! /usr/bin/perl
use Mysql;
$dbh = Mysql->connect("localhost", "verycooldatabase", "", "");
$query = "select this from that";
$sth = $dbh->query($query);
// returns one row at the time in array @arr
while(@arr = $sth->fetchrow) {
foreach $data (@arr)
print(
How do I query a database with Perl - retrieve a item and then have that
as a var to use in another insert statement
Currently I have :
Use DBI
I define: my vars : host,db,username,password etc
I create my db object etc
I used the script to do a insert to my db and it worked fine - but I
can
hallo!
With reference to Dawn H on 04.07 00:36:
> The error log says,
>
> Can't call method "do: on an undefined value. . .
>
> But the EXACT SAME code works on another script I'm running. I don't see any
> reason for it to suddenly have a problem. What does this error message MEAN?
>
> Co
The only reason why that might happen (assuming it is working somewhere else),
the object isn't return. So connect() constructor couldn't return the object.
To read the error message from DBI, you'll have to read $DBI::errstr:
my $dbh = DBI->connect(dsn, login, password) or die $DBI::errstr;
The error log says,
Can't call method "do: on an undefined value. . .
But the EXACT SAME code works on another script I'm running. I don't see any
reason for it to suddenly have a problem. What does this error message MEAN?
Code Snippet--
# Form was okay; get image type and cont
so has the unique ability that you can go back and forth in the
browser all you want (no back button woes).
- Original Message -
From: "Pete Kuczynski" <[EMAIL PROTECTED]>
To: "MySQL Email List" <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 8:32 AM
Subject:
I overcame this by adding to my php script, something that goves the
user the results, summerised, of what they added to the database, thus
when hitting refresh, it just refreshes the results of what the php
script returned, not what they submitted.
My php script is below.
Pete
");
OTOH, if you use mod_perl, *all* scripts are cached. That way you can have
a single script per function, which makes each smaller and simpler to debug.
Paul Wilson
iiNet Ltd
> Cindy, read my reply to this. You are mistaken. There is actually a way
> to make a single script do all kinds of d
Cindy, read my reply to this. You are mistaken. There is actually a way
to make a single script do all kinds of different operations. I have
single scripts that show a list of records, add a new record, update a
record, and delete a record, all in the same script. This is more
efficient to
You need to have your script operate in different modes. You do this by
passing an argument when you call your script to tell the script what it is
supposed to do. So in this case, if the script is called with out any
arguments, it will display the form, as follows:
http://www.sample.com/sam
> When a person submits a form that inserts a record into the database, if
> they then refresh the page that comes up after the submit, the record will
> be submitted a second time. I suppose this is due to the fact that the
> subroutine that is called with the submit contains both the write to
>
"Dawn H" writes:
>I've written a couple of scripts and have a thing that I haven't quite
>figured out. If anyone can shed light on this, I'd appreciate it.
>
>When a person submits a form that inserts a record into the database, if
>they then refresh the page that comes up after the submit,
I've written a couple of scripts and have a thing that I haven't quite
figured out. If anyone can shed light on this, I'd appreciate it.
When a person submits a form that inserts a record into the database, if
they then refresh the page that comes up after the submit, the record will
be submitted
19 matches
Mail list logo
