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
