headers
Ruprecht Helms | 1 Aug 2006 11:24
Picon
Favicon

Updatescript that uses variables


Hi,

how can I create a updatescript hat do SQL-Updates with values that are
stored in variables.

For example

1. Do a SELECT-Command and write 2 fieldentry into a variable
2. calculate the values and write the new value into a new variable
3. Do a UPDATE-Command and use the variable with the new value.

Regards,
Ruprecht
Permalink | Reply | 0 comments |
headers
zhihua li | 4 Aug 2006 23:27
Picon
Favicon

install DBD::mysql, can't execute mysql_config

Hi all

recently i've been trying to install DBD::mysql. as the first step, i 
downloaded the binary file of mysql for linux from mysql.com.  i followed 
the instructions unpacking the files into a directory /usr/mysql. then i 
proceeded to install DBD::mysql.  however, the makefile kept saying that it 
couldn't find mysql_config. actually i found the file at /usr/mysql/bin, 
and added the full path to the PATH enviroment parameter. but still the 
make file process alwayse failed, saying it couldn't find and execute 
mysql_config.  what's more, when i went to the directory /usr/mysql/bin and 
typed mysql_config, the shell said there's no such command, even if the 
file is right there.

could anyone give me a clue about this?

thanks a lot!

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 1 comment |
headers
Dave Howorth | 7 Aug 2006 10:04
Picon
Picon

Re: install DBD::mysql, can't execute mysql_config

zhihua li wrote:
> recently i've been trying to install DBD::mysql. as the first step, i 
> downloaded the binary file of mysql for linux from mysql.com.  i 
> followed the instructions unpacking the files into a directory 
> /usr/mysql.

Most distributions have prepackaged modules for one or more versions of 
mysql. You may find it more convenient to use those.

> then i proceeded to install DBD::mysql.  however, the 
> makefile kept saying that it couldn't find mysql_config. actually i 
> found the file at /usr/mysql/bin, and added the full path to the PATH 
> enviroment parameter. but still the make file process alwayse failed, 
> saying it couldn't find and execute mysql_config.  what's more, when i 
> went to the directory /usr/mysql/bin and typed mysql_config, the shell 
> said there's no such command, even if the file is right there.

I think you need to go back to basics to figure out why the script isn't 
being found. Which user are you running as? Which user is the installer 
running as? What are the permissions on /usr/mysql/bin and 
/usr/mysql/bin/mysql_config?  At the point where you try to run the 
script, print the contents of $PATH. Does it actually have usr/mysql/bin 
in it? Does it actually have '.' in it? Once you have all that 
information, you can figure out why the script isn't being found.

Cheers, Dave

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
(Continue reading)

Permalink | Reply | 0 comments |
headers
Krishnakishore R Challa | 7 Aug 2006 18:06
Favicon

Problem with new Version of DBD-mysql on Activeperl 5.8x

Hi, 
I bought a new desktop and I installed ActivePerl 5.8.8.817, DBI 1.51, 
and DBD-mysql 3.0006_1. 
I install the DBI and DBD-mysql from http://theoryx5.uwinnipeg.ca/ppms. 
I have a perl program which has multiple sql statements accessing my 
database in Mysql 5.0. 
When the program hits the second sql statement I am getting an unknown 
error. The error message comes from Windows(XP Home), not from within 
the perl program. And the error doesn't say anything except that Perl 
program found an error. 
In my laptop I have WindowsXP-Home + ActivePerl 5.8.8.817 + DBI 1.50 
(older version) + DBD-mysql 3.0006 (older version) + Mysql 5.0 and I 
don't get this error. 
As a work around I can't anymore get the DBI 1.50 and DBD-mysql 3.0006 
(older versions) installed for ActivePerl 5.8 from 
http://theoryx5.uwinnipeg.ca/ppmpackages. 
I searched the google groups and did not find any post related to this 
error. I thought it has to be my desktop.. So, I removed the perl and 
other modules and reinstalled them in my laptop.. and now I am getting 
the same error in laptop also. 
I posted the above message in groups.google.com - perl.cpan.testers, and
then I saw the document of DBD-mysql and got this email id.
I do not know what is causing this error, DBI or DBD-mysql. But since
they were the only new ones in my computer, I am guessing it is one of
them.
I will also be posting this message to the helpline of DBI.
Please help me. 
Thanks in advance, 
Kishore.
(Continue reading)

Permalink | Reply | 3 comments |
headers
zhihua li | 8 Aug 2006 19:10
Picon
Favicon

mysql_config resolved, now libmysqlclient incompatible

Hi netters,

Thanks a lot for all your helpful suggestions to my previous poster on the 
problem of finding and executing the mysql_config file.  Now I've resolved 
the problem by correctly setting the $PATH envrioment. Thank you very much!

But now another problem arised. While Makefile passed smoothly, when I ran 
make, an error message alwayse poped out: 

/usr/lib64/gcc/x86_64-suse-linux/4.0.2/../../../../x86_64-suse-linux/bin/ld: 
skipping incompatible /home/zhli/mysql/lib/libmysqlclient.a when searching 
for -lmysqlclient
/usr/lib64/gcc/x86_64-suse-linux/4.0.2/../../../../x86_64-suse-linux/bin/ld: 
cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1

I followed the DBD::mysql installation instructions to copy the 
libmysqlclient.a into another directory and run Makefile.PL with a swich 
--libs="-L/<my directory>", but the error message is still there.

could anyone give me further help? Thanks in advance!

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Mike Blezien | 9 Aug 2006 17:19

Access MDF data

Hello,

is there a Perl module available to obtain data from Access .mdf files ?

thx's

Mike(mickalo)Blezien

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org
Permalink | Reply | 2 comments |
headers
Ruprecht Helms | 9 Aug 2006 17:32
Picon
Favicon

Re: Access MDF data


Hi,
> 
> is there a Perl module available to obtain data from Access .mdf files ?
> 
this suffix for Access does not exist. I think you mean .mdb.

If there is nothing native module for Access (I don't know if one exist)
you can try to fetch the datas via odbc-connection.

Regards,
Ruprecht

-
-----------------------------------------------------------------------------
Ruprecht Helms IT-Service & Softwareentwicklung
             let worktools be individual

Web: http://www.rheyn.de
Permalink | Reply | 1 comment |
headers
Mike Blezien | 9 Aug 2006 17:36

Re: Access MDF data

Right it's mdf ... my mistake.

thx's for the info

Mike
----- Original Message ----- 
From: "Ruprecht Helms" <rhelms <at> mymail.ch>
To: "Mike Blezien" <mickalo <at> frontiernet.net>
Cc: "Perl MySQL" <perl <at> lists.mysql.com>
Sent: Wednesday, August 09, 2006 10:32 AM
Subject: Re: Access MDF data

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Hi,
>> 
>> is there a Perl module available to obtain data from Access .mdf files ?
>> 
> this suffix for Access does not exist. I think you mean .mdb.
> 
> If there is nothing native module for Access (I don't know if one exist)
> you can try to fetch the datas via odbc-connection.
> 
> Regards,
> Ruprecht
> 
> -
> -----------------------------------------------------------------------------
> Ruprecht Helms IT-Service & Softwareentwicklung
(Continue reading)

Permalink | Reply | 0 comments |
headers
Sam Smith | 10 Aug 2006 22:39

segfault errors on using numbers in execute statements


The below fragment of code either segfaults or gives the
following error when run on OpenBSD 4.0-beta:
 	FREE ERROR BIND!FREE ERROR FBIND!

__START__
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
my $dsn = 'DBI:mysql:glocaliser:localhost'; # DSN connection string
my $db_username= 'perl';              # database username
my $db_password= 'perl';         # database password
our $dbh= DBI->connect($dsn, $db_username, $db_password);

my $v= 8;
my $q= $dbh->prepare("select * from interests where tag=?")
$q->execute($v);
__END__

having the last line read $q->execute("$v") is a workaround.

A core of the more general case is:

(gdb) target core perl.core
Core was generated by `perl'.
Program terminated with signal 11, Segmentation fault.
bReading symbols from /usr/lib/libperl.so.10.1...tdone.
Loaded symbols for /usr/lib/libperl.so.10.1
Reading symbols from /usr/lib/libm.so.2.3...
(Continue reading)

Permalink | Reply | 1 comment |
headers
Randy Kobes | 11 Aug 2006 04:11
Picon
Favicon

Re: Problem with new Version of DBD-mysql on Activeperl 5.8x

On Mon, 7 Aug 2006, Krishnakishore R Challa wrote:

> Hi,
> I bought a new desktop and I installed ActivePerl 5.8.8.817, DBI 1.51,
> and DBD-mysql 3.0006_1.
> I install the DBI and DBD-mysql from http://theoryx5.uwinnipeg.ca/ppms.
> I have a perl program which has multiple sql statements accessing my
> database in Mysql 5.0.
> When the program hits the second sql statement I am getting an unknown
> error. The error message comes from Windows(XP Home), not from within
> the perl program. And the error doesn't say anything except that Perl
> program found an error.
> In my laptop I have WindowsXP-Home + ActivePerl 5.8.8.817 + DBI 1.50
> (older version) + DBD-mysql 3.0006 (older version) + Mysql 5.0 and I
> don't get this error.
> As a work around I can't anymore get the DBI 1.50 and DBD-mysql 3.0006
> (older versions) installed for ActivePerl 5.8 from
> http://theoryx5.uwinnipeg.ca/ppmpackages.
> I searched the google groups and did not find any post related to this
> error. I thought it has to be my desktop.. So, I removed the perl and
> other modules and reinstalled them in my laptop.. and now I am getting
> the same error in laptop also.
> I posted the above message in groups.google.com - perl.cpan.testers, and
> then I saw the document of DBD-mysql and got this email id.
> I do not know what is causing this error, DBI or DBD-mysql. But since
> they were the only new ones in my computer, I am guessing it is one of
> them.
> I will also be posting this message to the helpline of DBI.
> Please help me.
> Thanks in advance,
(Continue reading)

Permalink | Reply | 2 comments |

Gmane