RE: Spaces in Data Fields

Well I see two differences.

My DBI version is 1.45 and the DBD::mysql version is 2.9004

Don't upgrade till I find out if this is me or the modules?

Lucky me the United States of America doesn't have it's own zip code. While
Australia would exist Botany Bay would not.

Regards,
Pete
----
Peter P. Benac, CCNA
Celtic Spirit Networking
Providing Network and Systems Project Management and Installation and Web
Hosting.
Phone: 919-618-2557
Web: http://www.emacolet.com
Need quick reliable Systems or Network Management advice visit
http://www.nmsusers.org

To have principles...
             First have courage.. With principles comes integrity!!!




-----Original Message-----
From: Logan, David (SST - Adelaide) [mailto:[email protected]] 
Sent: Tuesday, November 09, 2004 2:28 AM
To: Peter P. Benac
Cc: [email protected]
Subject: RE: Spaces in Data Fields


Hi Peter,

porkribs ~ $ perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
  Platform:
    osname=solaris, osvers=2.8, archname=sun4-solaris
    uname='sunos porkribs 5.8 generic_108528-11 sun4u sparc sunw,ultra-30 '
    config_args=''
    hint=previous, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Built under solaris
  Compiled at Sep  1 2003 21:06:42
  @INC:
    /usr/local/lib/perl5/5.8.0/sun4-solaris
    /usr/local/lib/perl5/5.8.0
    /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris
    /usr/local/lib/perl5/site_perl/5.8.0
    /usr/local/lib/perl5/site_perl

DBI (1.42) - Database independent interface for Perl
DBD::mysql (2.9003) - MySQL driver for the Perl5 Database Interface
(DBI)

I suppose this also means that "United States of America" doesn't exist
either 8-) Australia is definitely there!

Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax


-----Original Message-----
From: Peter P. Benac [mailto:[email protected]] 
Sent: Tuesday, 9 November 2004 5:35 PM
To: Logan, David (SST - Adelaide)
Cc: [email protected]
Subject: RE: Spaces in Data Fields

David,

     You are not being overly simplistic, but I think you are missing my
problem.  

     The do statement returns a count of 0.  If I do a search for records on
that field using data that does not contain a space it works.

     For that matter the prepare/execute returns a "no record found" error
long before I hit the fetchrow.

     I am glad yours works, because that means mine should. The problem is
it does not!!!  It does not matter if I use a Fetchrow or a fetchrow_array
there is nothing there to fetch.  Are you using the same version of Perl and
the DBI, DBD bundles I am using?  As I said both systems where recently
updated from CPAN last week. I don't seem to recall this issue before, but
recent changes to the programming has required Zip Code verification and
it's tough to verify a Zip Code on Myrtle Beach when Perl/MySQL says Myrtle
Beach doesn't exist. For that matter either does San Francisco, Los Angeles,
New York, Palm Beach or any other two word city.

Regards,
Pete
----
Peter P. Benac, CCNA
Celtic Spirit Networking
Providing Network and Systems Project Management and Installation and Web
Hosting.
Phone: 919-618-2557
Web: http://www.emacolet.com
Need quick reliable Systems or Network Management advice visit
http://www.nmsusers.org

To have principles...
             First have courage.. With principles comes integrity!!!


much snippage


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]