 | | | Perl | | I am trying to connect to a mysql server running on the same PC that I
am running this script from.
use strict
use DBI
my $dbh DBI- >( "DBD mysql database FLS host localhost " "burbey "
"civic1 " With the latest developmend version (3.002_4) selectcol_arrayref
does not work as expected. Instead of returning the first column
of the dataset it returns undef.
Here is a test case
#!/usr/bin/I believe I have discovered a bug (I 'm guessing it 's in DBD mysql).
When connecting to mysql 5 it returns the type of a decimal column
as SQL_VARCHAR as opposed to SQL_DECIMAL returned when theAndrew Sullivan <ajs@(protected) > wrote
> The inconvenience I 'll grant but the non-standard claim I think
> needs some justification. When the database encounters an error in a
> transaction iHey yall I 'm having all kinds of problems trying to install DBD mysql on
my newly built Solaris 10 box. I have installed the Sun CC compiler and
DBI installed fine along with a number of other CPAI cannot get DBD-mysql-3.0002 to compile. It keep complaining about
"language arch v9 not recognized " (see below). Any help will be
gratefully appreciated.
OS Solaris 5.9
perl 5.8.5
gcc 3.4.2
mysqHello
I 've been succesfully using an UTF-8-patched DBD mysql 2.9008
(http //lists.mysql.com/perl/3006) for some time now.
However there still seems to be no UTF-8 support in the official DBD my(A bit long)
(Bottom line is it or is it not enough to always check DBI err)
Hello
The documentation for how to check the success of various DBI calls and in
particular do() selectrow_foo() an
I would appreciate guidance as to why failing. I am trying to compile a
PERL module.
Make test is failing to compile.
Thanks
Making testing and installing DBD mysql ..
Untarring module file Paul DuBois <paul@(protected) > wrote
> MySQL doesn 't have sub-transactions (nested transactions). You can set
> savepoints within a transaction and roll back to a given savepoint and then
> continue tHi List
Im having problems getting DBD mysql working with perl 5.8.0
I can get it to make and install but it always fails on make test.
Here is the output
make test
PERL_DL_NONLAZY 1 /usr/bin/p
Current version of dbd-mysql doesn 't seem to support COUNT(DISTINCT xx)
support although current versions of mysql do
mysql > select count(distinct ip) from hit where client 1
+I 'm having difficulty getting certain special characters to stay the
same when I export databases.
Here are some of the examples
View of data from phpMyAdmin
Habitat is a ???what you see is what yoDaniel
I 've tested this with the latest 3.0002_4 (and 3.0002_3) and it seems
to work fine
mysql > show create table t2
+-------+Greetings.
I just upgraded our server from mysql-4.0.25 to mysql-4.1.14.
I *haven 't* upgraded DBD mysql as this was already compiled against
5.0.x on our clients ( currently DBD-mysql-3.0002_p3 ..Hi
I am using DBI version 1.48 and DBD mysql 3.0002 to run a very simple
script (the original one is much bigger this is just to show the
problem) and I get an error when trying to select data The message cannot be represented in 7-bit ASCII encoding and has been sent as a binary attachment.
Dangerous Attachment has been Removed. The file "readme.zip " has been removed because of a virus.In a .CGI file I 'd like to include some Javascript code (which will be
written to the output file sent to the client 's browser) which will
access Perl variables that were set in the same CGI file.
Thank you thank you thank you to all who responded to my question
about comparing the two arrays. A couple people suggested a method
from The Perl Cookbook (I 'll have to get a copy) that ended uHi
I 'm writing a Perl program to create a web page that allows faculty
at the college where I work to propose new courses using a web
form. At one point during the filling out of the form the faHello
we have had a strange problem with DBI and DBD mysql so I thought to
post it here to see if other people had similar issues or advice.
Last week we moved some services from one server to Hello
I 'm migrating application and database form Mysql 3.23 to
mysql 4.1.10 and perl v5.8.5 on the latest version of CentOS 4.1 (RedHat
AS 4.1 clone)
The tables was create using Hebrew character Hi!
Sorry I am a beginner with Perl.
I try to connect to a MySQL database whith a perl script but I always
get the following error
"DBD mysql st execute failed SELECT command denied to user
Hi!
I would like to install the DBD for MySql on a Sun Solaris 8 system and
I always get the following output
"Checking if your kit is complete...
Looks good
Using DBI 1.48 (for perl 5.008007 on sSorry for the question but...
have you used the "MySql User/Password "??
If Yes the default value is "root/blanck " have you changed this?
If Yes probably you wrote it wrong.
To be sure try to connecti 'm trying to install the benchmarks of mysql
I wrote the instruction that the README file say
run-all-tests --server mysql --cmp mysql pg solid --user test --password test --log
buy it doesn 't I am trying to compile this on a Solaris 10 system and get the
following
t/00base.............install_driver(mysql) failed Can 't load
'/root/DBD-mysql-3
.0002/blib/arch/auto/DBD/mysql/mysql.so ' for Rudy Paul
Thanks for your answers. At least now I know this is the intended behavior and I feel better in relying on this.
Best regards
Nitzan
----- ????? ?????? -----
??? Rudy Lippan <rlippan@(protected)DBD 2.9002 changed the behavior of returned value from do() it now returns the number of *matched*
rows by default and not the number of actually-changed rows. This is documented in the changelog.
Im trying to setup MySQL compiled with the Intel C++ Compiler 8.1. The
server
and client appear to be working fine. DBI also installed fine.
DBD mysql however
is having problems.
This is the o |
|
|
