Re: mysql NULl value in perl problem

2002-12-05 Thread Matthew Baranowski
PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 2:59 PM Subject: mysql NULl value in perl problem > Hi guys, > > Running into a frustrating problem. When I have a empty table in mysql > database, i tried run a select statement in my perl script and > supp

Re: mysql NULl value in perl problem

2002-12-05 Thread Qunfeng Dong
Isn't NULL value in MySQL stored as '\N'? If so, you can check that in your perl script. Qunfeng --- David Wu <[EMAIL PROTECTED]> wrote: > Hi guys, > > Running into a frustrating problem. When I have a > empty table in mysql > database, i tried run a select statement in my perl > script and

Re: mysql NULl value in perl problem

2002-12-05 Thread Paul DuBois
At 14:59 -0800 12/5/02, David Wu wrote: Hi guys, Running into a frustrating problem. When I have a empty table in mysql database, i tried run a select statement in my perl script and supposing get a NULl return value. Is the NULL returned from mysql is described as string in perl or as undef i

mysql NULl value in perl problem

2002-12-05 Thread David Wu
Hi guys, Running into a frustrating problem. When I have a empty table in mysql database, i tried run a select statement in my perl script and supposing get a NULl return value. Is the NULL returned from mysql is described as string in perl or as undef in perl?.. As there is no the word NULL i

mysqlhotcopy / perl problem

2002-07-08 Thread Scott Lahteine
>Description: The mysqlhotcopy script fails with recent versions of perl. >How-To-Repeat: Invoke mysqlhotcopy with perl 5.6.1. (I'm on a NetBSD box.) The script fails, complaining it can't create the target directory. >Fix: In the section of the script that create

Re: Perl problem

2002-01-01 Thread David J Jackson
e statement. > > > > Placed At : > > > John Mayson <[EMAIL PROTECTED]> on 01/01/2002 08:24:50 AM > > Please respond to [EMAIL PROTECTED] > > To: MySQL List <[EMAIL PROTECTED]>, Central Florida Gee

Re: (WOT) Re: Perl problem

2002-01-01 Thread David J Jackson
Here's what I use: use DBI; use diagnostics; use strict; my ($dbh,$sth); my ($dbname)="pickle"; my ($login)="picklesql"; my ($password) ="pi56fb"; my (@ary); # $dbh = DBI->connect("DBI:mysql:$dbname",$login,$password) or die "Can't connect to $dbh: $dbh->errstr\n"; $sth = $dbh->prepare("SE

Re: Perl problem

2002-01-01 Thread Durga_Prasad
John Mayson <[EMAIL PROTECTED]> on 01/01/2002 08:24:50 AM Please respond to [EMAIL PROTECTED] To: MySQL List <[EMAIL PROTECTED]>, Central Florida Geeks <[EMAIL PROTECTED]> cc:(bcc: Durga Prasad/Satyam) Subject: Perl problem I've decided to graduate to the

(WOT) Re: Perl problem

2001-12-31 Thread Colin Faber
>From the DBI manual: $dbh = DBI->connect($data_source, $username, $auth, \%attr); You're not telling DBI what the DSN is (Data source name) John Mayson wrote: > > I've decided to graduate to the next step and access my mySQL databases with Perl. I > am attempting this on a Win2000 ma

Perl problem

2001-12-31 Thread John Mayson
I've decided to graduate to the next step and access my mySQL databases with Perl. I am attempting this on a Win2000 machine. Here's my code... #!C:/perl/bin/perl.exe -w use strict; use CGI qw(:standard); use DBI; my $dbh = DBI->connect('Radio', 'root', ''); I get this error message... Can

RE: Perl Problem!

2001-12-24 Thread Matthew Smith
#x27;, $wert, '$kunde') ^^^ ^ maybe $reader and $wert were not quoted strings M -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED]] Sent: 24 December 2001 15:58 To: MySQL Subject: Re: Perl Problem! > Hi! > > I have a proplem us

Re: Perl Problem!

2001-12-24 Thread Amer Neely
> Hi! > > I have a proplem using my perl code to write some data into my mysql > database. When running in consolemode anything works fine, but when > executed by the wwwserver the scripts is processed without errors, > except the data is not written into the database! Any idea how to fixit? > Th

RE: Perl Problem!

2001-12-23 Thread Almar van Pel
using some breaks that print the output to a file or to the screen, so that you can see what is happening. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Sascha Kettner [mailto:[EMAIL PROTECTED]] Verzonden: zondag, december 23, 2001 18.29 Aan: [EMAIL PROTECTED] Onderwerp: Perl Problem

Perl Problem!

2001-12-23 Thread Sascha Kettner
Hi! I have a proplem using my perl code to write some data into my mysql database. When running in consolemode anything works fine, but when executed by the wwwserver the scripts is processed without errors, except the data is not written into the database! Any idea how to fixit? Thanks in advanc