RE: Number formatting using DBI/ODBC with SQL Server

Jeff Urlwin Tue, 23 Jul 2002 13:45:20 -0700

Jim,

Something DEFINITELY happenend when you untarred the file.  The tests
*should* be defined and the extra files from "mytest" should not be copied.
It looks like you untarred without the "use folder names" option of Winzip
(guessing here, but...).  Definitely look at that!


The create table part was my problem.  However...try this one (at the end of
my text)

I changed the create table to "bigint" and it works for me here with
SQLServer 2000.  Note that when I tried to create with "bigint" of width of
8, the driver told me I couldn't do it.  So, I'm wondering if Enterprise
manager is "fudging things" for you.

My latest is attached as inttest.pl (if it gets clipped off, let me know).
IT should now run on SQLServer.

Also, try running coltest.pl (attached also) *before* running the other
script, save the output and send it to me...coltest.pl will work with SQL
Server (not tested anywhere else at this point) and will show the columns of
table FOO (assume you only have one table foo <G>).

Regards,

Jeff


> -----Original Message-----
> From: Jim Clark [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 23, 2002 3:28 PM
> To: Jeff Urlwin
> Cc: Gary Gauthier; [EMAIL PROTECTED]
> Subject: Re: Number formatting using DBI/ODBC with SQL Server
>
>
> Jeff,
>
> I had some problems getting the script to work with ActiveState's current
> DBD:ODBC installation so I fetched and installed the latest
> 0.45_5 release off
> CPAN and continued to recieve the same errors on the drop and create table
> statements. I attached the output I recieved during the nmake
> process and with
> the connect string updated accordingly.
>
> To get this to work, I creating the table manually in Enterprise
> Manager using
> type bigint of length 8 for the longint field as it appeared to
> be the closest
> match to a type long. I then commented the create table and the
> drop table lines
> out, the script ran ok and the output I recieved is attached at
> the very bottom.
> All records in foo appear as expected in Enterprise Manager (i.e.
> the first
> record has id="0" and logint="4" and not "4.00")
>
> Thanks again for your help.
>
> -Jim
>
> C:\Download\Perl\DBD-ODBC-0.45_5>perl Makefile.pl
>
> Configuring DBD::ODBC ...
>
> >>>     Remember to actually *READ* the README file!
>         And re-read it if you have any problems.
>
> Using DBI 1.21 installed in C:/Perl/site/lib/auto/DBI
>
> Using DBI 1.21 installed in C:/Perl/site/lib/auto/DBI
> Writing Makefile for DBD::ODBC
>
> The DBD::ODBC tests will use these values for the database connection:
>     DBI_DSN=dbi:ODBC:MyDSN           e.g. dbi:ODBC:demo
>     DBI_USER=sa
>     DBI_PASS=MyPasswd
>
> C:\Download\Perl\DBD-ODBC-0.45_5>nmake
>
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
>
> cp randombind.pl blib\lib\DBD\randombind.pl
> cp testmulti.pl blib\lib\DBD\testmulti.pl
> cp joetest.pl blib\lib\DBD\joetest.pl
> cp ODBCTEST.pm blib\lib\DBD\ODBCTEST.pm
> cp contest.pl blib\lib\DBD\contest.pl
> cp timetest.pl blib\lib\DBD\timetest.pl
> cp longbin.pl blib\lib\DBD\longbin.pl
> cp testkeys.pl blib\lib\DBD\testkeys.pl
> cp testundef.pl blib\lib\DBD\testundef.pl
> cp listtabs.pl blib\lib\DBD\listtabs.pl
> cp testdatasources.pl blib\lib\DBD\testdatasources.pl
> cp testfunc.pl blib\lib\DBD\testfunc.pl
> cp moreresults.pl blib\lib\DBD\moreresults.pl
> cp testigparams.pl blib\lib\DBD\testigparams.pl
> cp testerrhandler.pl blib\lib\DBD\testerrhandler.pl
> cp testinout.pl blib\lib\DBD\testinout.pl
> cp testver.pl blib\lib\DBD\testver.pl
> cp testspmulti.pl blib\lib\DBD\testspmulti.pl
> cp testgetinfo.pl blib\lib\DBD\testgetinfo.pl
> cp ODBC.pm blib\lib\DBD\ODBC.pm
> cp testconn.pl blib\lib\DBD\testconn.pl
>         C:\Perl\bin\perl.exe -p -e "s/~DRIVER~/ODBC/g" <
> C:/Perl/site/lib/auto/D
>
> BI/Driver.xst > ODBC.xsi
>         C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib
> C:\Perl\lib\ExtUtils/xs
>
> ubpp  -typemap C:\Perl\lib\ExtUtils\typemap ODBC.xs > ODBC.xsc &&
> C:\Perl\bin\pe
>
> rl.exe -IC:\Perl\lib -IC:\Perl\lib -MExtUtils::Command -e mv
> ODBC.xsc ODBC.c
>         cl -c -IC:/Perl/site/lib/auto/DBI -nologo -O1 -MD
> -DNDEBUG -DWIN32 -D_CO
>
> NSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT
> -DPERL_IMPLICIT_SYS
> -DPERL_MSVCRT_READFIX -O1 -MD -DNDEBUG    -DVERSION=\"0.45_5\"
> -DXS_VERSION=\"0
>
> .45_5\"  -IC:\Perl\lib\CORE  ODBC.c
> ODBC.c
> ODBC.xs(176) : warning C4761: integral size mismatch in argument;
> conversion sup
>
> plied
>         cl -c -IC:/Perl/site/lib/auto/DBI -nologo -O1 -MD
> -DNDEBUG -DWIN32 -D_CO
>
> NSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT
> -DPERL_IMPLICIT_SYS
> -DPERL_MSVCRT_READFIX -O1 -MD -DNDEBUG    -DVERSION=\"0.45_5\"
> -DXS_VERSION=\"0
>
> .45_5\"  -IC:\Perl\lib\CORE  dbdimp.c
> dbdimp.c
> dbdimp.c(588) : warning C4133: 'function' : incompatible types -
> from 'struct _P
>
> erlIO *' to 'struct _iobuf *'
> dbdimp.c(1183) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(1201) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(1215) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(1328) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(1367) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(2051) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(2211) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(2364) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(2983) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(2983) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(2986) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3046) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3046) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3046) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3046) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3080) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3080) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3080) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3120) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3120) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3120) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3120) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3120) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3120) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3160) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3160) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3160) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3160) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3160) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3160) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3185) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3222) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3295) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> dbdimp.c(3295) : warning C4761: integral size mismatch in
> argument; conversion
> supplied
> "Running Mkbootstrap for DBD::ODBC ()"
>         C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib
> -MExtUtils::Command -e
> chmod 644 ODBC.bs
>         C:\Perl\bin\perl.exe "-IC:\Perl\lib" "-IC:\Perl\lib"
> -MExtUtils::Mksymli
>
> sts  -e "Mksymlists('NAME' => 'DBD::ODBC', 'DLBASE' => 'ODBC',
> 'DL_FUNCS' => {
> }, 'FUNCLIST' => [], 'IMPORTS' => {  }, 'DL_VARS' => []);"
>         link -out:blib\arch\auto\DBD\ODBC\ODBC.dll -dll -nologo
> -nodefaultlib -r
>
> elease  -libpath:"C:/Perl\lib\CORE"  -machine:x86 ODBC.obj
> dbdimp.obj   C:\Perl
>
> \lib\CORE\perl56.lib "C:\Program Files\Microsoft Visual
> Studio\VC98\lib\ODBC32.L
>
> IB" "C:\Program Files\Microsoft Visual
> Studio\VC98\lib\oldnames.lib" "C:\Program
>
>  Files\Microsoft Visual Studio\VC98\lib\kernel32.lib" "C:\Program
> Files\Microsof
>
> t Visual Studio\VC98\lib\user32.lib" "C:\Program Files\Microsoft
> Visual Studio\V
>
> C98\lib\gdi32.lib" "C:\Program Files\Microsoft Visual
> Studio\VC98\lib\winspool.l
>
> ib" "C:\Program Files\Microsoft Visual
> Studio\VC98\lib\comdlg32.lib" "C:\Program
>
>  Files\Microsoft Visual Studio\VC98\lib\advapi32.lib" "C:\Program
> Files\Microsof
>
> t Visual Studio\VC98\lib\shell32.lib" "C:\Program Files\Microsoft
> Visual Studio\
>
> VC98\lib\ole32.lib" "C:\Program Files\Microsoft Visual
> Studio\VC98\lib\oleaut32.
>
> lib" "C:\Program Files\Microsoft Visual
> Studio\VC98\lib\netapi32.lib" "C:\Progra
>
> m Files\Microsoft Visual Studio\VC98\lib\uuid.lib" "C:\Program
> Files\Microsoft V
>
> isual Studio\VC98\lib\wsock32.lib" "C:\Program Files\Microsoft
> Visual Studio\VC9
>
> 8\lib\mpr.lib" "C:\Program Files\Microsoft Visual
> Studio\VC98\lib\winmm.lib" "C:
>
> \Program Files\Microsoft Visual Studio\VC98\lib\version.lib"
> "C:\Program Files\M
>
> icrosoft Visual Studio\VC98\lib\odbc32.lib" "C:\Program
> Files\Microsoft Visual S
>
> tudio\VC98\lib\odbccp32.lib" "C:\Program Files\Microsoft Visual
> Studio\VC98\lib\
>
> msvcrt.lib" -def:ODBC.def
>    Creating library blib\arch\auto\DBD\ODBC\ODBC.lib and object
> blib\arch\auto\D
>
> BD\ODBC\ODBC.exp
>         C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib
> -MExtUtils::Command -e
> chmod 755 blib\arch\auto\DBD\ODBC\ODBC.dll
>         C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib
> -MExtUtils::Command -e
> cp ODBC.bs blib\arch\auto\DBD\ODBC\ODBC.bs
>         C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib
> -MExtUtils::Command -e
> chmod 644 blib\arch\auto\DBD\ODBC\ODBC.bs
>
> C:\Download\Perl\DBD-ODBC-0.45_5>nmake test
>
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
>
> 'No tests defined for DBD::ODBC extension.'
>
> C:\Download\Perl\DBD-ODBC-0.45_5>nmake test TEST_VERBOSE=1
>
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
>
> 'No tests defined for DBD::ODBC extension.'
>
> C:\Download\Perl\DBD-ODBC-0.45_5>nmake install
>
> Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
>
> Skipping C:\Perl\site\lib\auto\DBD\ODBC\ODBC.bs (unchanged)
> Installing C:\Perl\site\lib\auto\DBD\ODBC\ODBC.dll
> Installing C:\Perl\site\lib\auto\DBD\ODBC\ODBC.exp
> Installing C:\Perl\site\lib\auto\DBD\ODBC\ODBC.lib
> Installing C:\Perl\site\lib\DBD\contest.pl
> Installing C:\Perl\site\lib\DBD\joetest.pl
> Installing C:\Perl\site\lib\DBD\listtabs.pl
> Installing C:\Perl\site\lib\DBD\longbin.pl
> Installing C:\Perl\site\lib\DBD\moreresults.pl
> Installing C:\Perl\site\lib\DBD\ODBC.pm
> Installing C:\Perl\site\lib\DBD\ODBCTEST.pm
> Installing C:\Perl\site\lib\DBD\randombind.pl
> Installing C:\Perl\site\lib\DBD\testconn.pl
> Installing C:\Perl\site\lib\DBD\testdatasources.pl
> Installing C:\Perl\site\lib\DBD\testerrhandler.pl
> Installing C:\Perl\site\lib\DBD\testfunc.pl
> Installing C:\Perl\site\lib\DBD\testgetinfo.pl
> Installing C:\Perl\site\lib\DBD\testigparams.pl
> Installing C:\Perl\site\lib\DBD\testinout.pl
> Installing C:\Perl\site\lib\DBD\testkeys.pl
> Installing C:\Perl\site\lib\DBD\testmulti.pl
> Installing C:\Perl\site\lib\DBD\testspmulti.pl
> Installing C:\Perl\site\lib\DBD\testundef.pl
> Installing C:\Perl\site\lib\DBD\testver.pl
> Installing C:\Perl\site\lib\DBD\timetest.pl
> Writing C:\Perl\site\lib\auto\DBD\ODBC\.packlist
> Appending installation info to C:\Perl\lib/perllocal.pod
>
> C:\Download\Perl\DBD-ODBC-0.45_5>d:
>
> D:\Webroot\cgi-bin\tempdir>perl int_test.pl
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Cannot
> drop the table 'foo', because it does not exist in the system catalog.
> (SQL-42S02)(DBD: Execute immediate failed err=-1) at int_test.pl line 18.
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Line 1:
> Incorrect syntax near 'integer'. (SQL-42000)(DBD: Execute immediate failed
> err=-1) at int_test.pl line 22.
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Line 1:
> Incorrect syntax near 'integer'. (SQL-42000)(DBD: Execute immediate failed
> err=-1) at int_test.pl line 22.
>
> D:\Webroot\cgi-bin\tempdir>
>
> ...and here's your script that I named int_test.pl with the connect string
> updated.
>
> #!perl -w
>
> use strict;
> use DBI qw(:sql_types);
>
> # Database info
> my $user   = 'sa';
> my $pass   = 'MyPasswd';
> my $dsn    = 'dbi:ODBC:MyDSN';
>
> #my $dbh=DBI->connect() or die "Can't connect";
> my $dbh = DBI->connect("$dsn", "$user", "$pass") or die "Database
> connection not
> made: $DBI::errstr";
>
> $dbh->{RaiseError} = 1;
> $dbh->{LongReadLen} = 800;
>
> #eval {
> #   $dbh->do("drop table foo");
> #};
>
> my $dbname = $dbh->get_info(17); # sql_dbms_name
> #$dbh->do("Create table foo (id integer not null primary key, longint long
> integer)");
>
> my $sth = $dbh->prepare("INSERT INTO FOO (ID, longint) values (?, ?)");
> my $sth2 = $dbh->prepare("select id, longint from foo where id = ?");
>
> my @numbers = (
>         4,
>         4,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         12,
>         12,
>         12,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         88,
>         7,
>         7,
>         7,
>         100,
>         100,
>         12,
>         7,
>         183,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         7,
>         114,
>         251,
>         282,
>         281,
>         276,
>         131,
>         284,
>         144,
>         131,
>         144,
>         144,
>         131,
>         284,
>         144,
>         251,
>         284,
>         144,
>         284,
>         3,
>         284,
>         276,
>         284,
>         276,
>         3,
>         284,
>         144,
>         284,
>         7,
>         131,
>         144,
>         284,
>         284,
>         276,
>         131,
>         131,
>         114,
>         122
>        );
>
> my $tmp;
> my $i = 0;
>
> while ($i <= $#numbers) {
>    $sth->execute($i, $numbers[$i]);
>    $i++;
> }
>
> print "Inserted $i records.\n";
> $i = 0;
>
> while ($i <= $#numbers) {
>    $sth2->execute($i);
>    my @row = $sth2->fetchrow_array();
>    $sth2->finish;
>    print "Checking row $row[0] ($row[1])\n";
>    if ($numbers[$i] != $row[1]) {
>       print "Mismatch @ $i, ", $numbers[$i], " != ", $row[1], ": \n";
>    }
>    # print "$i: $txtinserted[$i]\n";
>
>    $i++;
> }
>
> print "Checked $i records\n";
> $dbh->disconnect;
>
> And here's the output of the script...
>
> D:\Webroot\cgi-bin\tempdir>perl int_test.pl
> Inserted 103 records.
> Checking row 0.00  (4.00 )
> Argument "4.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 1.00  (4.00 )
> Argument "4.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 2.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 3.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 4.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 5.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 6.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 7.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 8.00  (12.00 )
> Argument "12.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 9.00  (12.00 )
> Argument "12.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 10.00  (12.00 )
> Argument "12.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 11.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 12.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 13.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 14.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 15.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 16.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 17.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 18.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 19.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 20.00  (88.00 )
> Argument "88.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 21.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 22.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 23.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 24.00  (100.00 )
> Argument "100.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 25.00  (100.00 )
> Argument "100.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 26.00  (12.00 )
> Argument "12.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 27.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 28.00  (183.00 )
> Argument "183.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 29.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 30.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 31.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 32.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 33.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 34.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 35.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 36.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 37.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 38.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 39.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 40.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 41.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 42.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 43.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 44.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 45.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 46.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 47.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 48.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 49.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 50.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 51.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 52.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 53.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 54.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 55.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 56.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 57.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 58.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 59.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 60.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 61.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 62.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 63.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 64.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 65.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 66.00  (114.00 )
> Argument "114.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 67.00  (251.00 )
> Argument "251.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 68.00  (282.00 )
> Argument "282.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 69.00  (281.00 )
> Argument "281.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 70.00  (276.00 )
> Argument "276.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 71.00  (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 72.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 73.00  (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 74.00  (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 75.00  (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 76.00  (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 77.00  (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 78.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 79.00  (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 80.00  (251.00 )
> Argument "251.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 81.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 82.00  (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 83.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 84.00  (3.00 )
> Argument "3.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 85.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 86.00  (276.00 )
> Argument "276.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 87.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 88.00  (276.00 )
> Argument "276.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 89.00  (3.00 )
> Argument "3.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 90.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 91.00  (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 92.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 93.00  (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at int_test.pl line 149.
> Checking row 94.00  (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 95.00  (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 96.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 97.00  (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 98.00  (276.00 )
> Argument "276.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 99.00  (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 100.00  (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 101.00  (114.00 )
> Argument "114.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checking row 102.00  (122.00 )
> Argument "122.00" isn't numeric in numeric ne (!=) at int_test.pl
> line 149.
> Checked 103 records
>
> D:\Webroot\cgi-bin\tempdir>
>
> Jeff Urlwin wrote:
>
> > Gary/Jim -- please run the test I attached in the previous post
> responding
> > to Gary.  It retrieves and integer value as an integer.  Note that
> > DBI/DBD::ODBC takes the data the way that it's sent by the server/ODBC
> > driver...
> >
> > Jeff
>
>

coltest.pl
Description: Binary data

inttest.pl
Description: Binary data

RE: Number formatting using DBI/ODBC with SQL Server

Reply via email to