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]