Jim,
What's really not encouraging is the fact that the type returned, normally
an integer, is coming back as a decimal point. That's why there are errors
in the tests and I'm sure that's why there are errors in the script coming
back.
My driver is has the following information:
Driver: SQL Server
Version: 2000.80.194.00
Date: 8/6/2000
I'm connecting to a plain vanilla install of SQL Server 2000.
In my SYSTEM DSN configuration for my SQLSERVER, I have:
Use Regional settings when outputting currency, numbers, dates and times:
OFF <<<<<***
BINGO! I tried turning this on and I get your results...
I'm not sure what I can do about this but I can tell you it's causing it!
I think if you turn this off (may not be an option for you, though), it will
work correctly...???
Regards,
Jeff
> -----Original Message-----
> From: Jim Clark [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 23, 2002 9:49 PM
> To: Jeff Urlwin
> Subject: Re: Number formatting using DBI/ODBC with SQL Server
>
>
> Jeff,
>
> You were right about the folders (I dragged the files from WinZip
> instead of
> extracting with folder names) so I extracted them the right way
> and ran nmake
> again. Quite a few of the tests failed which isn't encouraging.
> Also, coltest.pl
> failted when fetching the query but inttest.pl ran ok.
>
> Thanks.
>
> -Jim
>
>
> C:\Download\Perl\DBD-ODBC-0.45_5>dir
> Volume in drive C has no label.
> Volume Serial Number is 1CAC-72BA
>
> Directory of C:\Download\Perl\DBD-ODBC-0.45_5
>
> 07/23/2002 03:35 PM <DIR> .
> 07/23/2002 03:35 PM <DIR> ..
> 07/23/2002 04:44 AM 20,019 Changes
> 07/23/2002 04:35 AM 100,094 dbdimp.c
> 07/23/2002 04:19 AM 6,553 dbdimp.h
> 03/08/2000 06:45 PM 262 fixup_c.h
> 03/08/2000 06:45 PM 258 fixup_t.h
> 03/31/2002 10:32 AM 13,864 Makefile.PL
> 07/23/2002 04:40 AM 651 MANIFEST
> 02/04/2002 10:14 AM 126 MANIFEST.SKIP
> 07/23/2002 03:35 PM <DIR> mytest
> 03/08/2000 06:45 PM 1,044 ODBC.h
> 07/23/2002 04:43 AM 45,842 ODBC.pm
> 02/09/2002 10:32 AM 6,184 ODBC.xs
> 01/28/2002 09:10 AM 5,762 README
> 03/08/2000 06:45 PM 1,298 README.adabas
> 07/23/2002 03:35 PM <DIR> t
> 13 File(s) 201,957 bytes
> 4 Dir(s) 7,829,725,184 bytes free
>
> 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
>
> Checking if your kit is complete...
> Looks good
> 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 ODBC.pm blib\lib\DBD\ODBC.pm
> 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 TEST_VERBOSE=1
>
> Microsoft (R) Program Maintenance Utility Version 6.00.8168.0
> Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
>
> C:\Perl\bin\perl.exe -Mblib -IC:\Perl\lib -IC:\Perl\lib
> -e "use Test::Ha
>
> rness qw(&runtests $verbose); $verbose=1; runtests @ARGV;"
> t\01base.t t\02simple
>
> .t t\03dbatt.t t\05meth.t t\07bind.t t\08bind2.t t\09multi.t
> Using C:/Download/Perl/DBD-ODBC-0.45_5/blib
> t\01base............1..5
> ok 1
> ok 2
> ok 3
> ok 4
> ok 5
> ok
> t\02simple..........1..17
> ok 1
> Test 2: connecting to the database
> ok 2
> Test 3: create test table
> DBD::ODBC::st fetchrow failed: [Microsoft][ODBC SQL Server
> Driver]String data, r
>
> ight truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long
> truncated) err=-1) at t
>
> /ODBCTEST.pm line 56.
> DBD::ODBC::st fetchrow failed: [Microsoft][ODBC SQL Server
> Driver]String data, r
>
> ight truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long
> truncated) err=-1) at t
>
> /ODBCTEST.pm line 56.
> Unable to find a suitable test type for field COL_C at
> t/ODBCTEST.pm line 63.
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 3-17
> Failed 15/17 tests, 11.76% okay
> t\03dbatt...........1..9
> ok 1
> ok 2
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid
> object name 'PERL_DBD_TEST'. (SQL-42S02)(DBD: Execute immediate
> failed err=-1) a
>
> t t\03dbatt.t line 104.
> Use of uninitialized value in numeric lt (<) at t\03dbatt.t line 37.
> Use of uninitialized value in numeric eq (==) at t\03dbatt.t line 38.
> not ok 3
> ok 4
> DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid
> object name 'PERL_DBD_TEST'. (SQL-42S02)(DBD: Execute immediate
> failed err=-1) a
>
> t t\03dbatt.t line 104.
> Use of uninitialized value in numeric lt (<) at t\03dbatt.t line 45.
> Use of uninitialized value in numeric eq (==) at t\03dbatt.t line 46.
> ok 5
> ok 6
> ok 7
> not ok 8
> not ok 9
> FAILED tests 3, 8-9
> Failed 3/9 tests, 66.67% okay
> t\05meth............1..6
> ok 1
> ok 2
> DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server
> Driver][SQL Server]Inv
>
> alid object name 'PERL_DBD_TEST'. (SQL-42S02)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could
> not be prepare
>
> d. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at t\05meth.t line 30.
> not ok 3
> DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server
> Driver][SQL Server]Inv
>
> alid object name 'PERL_DBD_TEST'. (SQL-42S02)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could
> not be prepare
>
> d. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at t\05meth.t line 38.
> DBD::ODBC::st fetchrow failed: (DBD: no select statement
> currently executing err
>
> =-1) at t\05meth.t line 39.
> $sth->err: -1
> $sth->errstr: (DBD: no select statement currently executing err=-1)
> $dbh->state:
> ok 4
> DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server
> Driver][SQL Server]Inv
>
> alid object name 'PERL_DBD_TEST'. (SQL-42S02)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could
> not be prepare
>
> d. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at t\05meth.t line 52.
> DBD::ODBC::st fetchrow failed: (DBD: no select statement
> currently executing err
>
> =-1) at t\05meth.t line 53.
> DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server
> Driver][SQL Server]Inv
>
> alid object name 'PERL_DBD_TEST'. (SQL-42S02)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could
> not be prepare
>
> d. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at t\05meth.t line 59.
> Statement has no result columns to bind (perhaps you need to call
> execute first)
>
> at t\05meth.t line 60.
> Issuing rollback() for database handle being DESTROY'd without
> explicit disconne
>
> ct().
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 3, 5-6
> Failed 3/6 tests, 50.00% okay
> t\07bind............1..11
> ok 1
> Test 2: connecting to the database
> ok 2
> Test 3: create test table
> DBD::ODBC::st fetchrow failed: [Microsoft][ODBC SQL Server
> Driver]String data, r
>
> ight truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long
> truncated) err=-1) at t
>
> /ODBCTEST.pm line 56.
> DBD::ODBC::st fetchrow failed: [Microsoft][ODBC SQL Server
> Driver]String data, r
>
> ight truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long
> truncated) err=-1) at t
>
> /ODBCTEST.pm line 56.
> Unable to find a suitable test type for field COL_C at
> t/ODBCTEST.pm line 63.
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 3-11
> Failed 9/11 tests, 18.18% okay
> t\08bind2...........1..3
> Test 1: insert various test data, without having this test tell
> the driver the
>
> type
> that is being bound to a column. This tests the use of
> SQLDescribePar
>
> am to obtain
> the column type on the insert. This is experimental
> and will most lik
>
> ely fail.
> Argument "93.00" isn't numeric in numeric eq (==) at
> t/ODBCTEST.pm line 171.
> These are tests which rely upon the driver to tell what the
> parameter type is fo
>
> r the column. This means you need to ensure you tell your driver
> the type of th
>
> e column in bind_col().
> TYPE FOUND = 93.00
> 93.00 is not date!
> not ok 1
> Argument "93.00" isn't numeric in numeric eq (==) at
> t/ODBCTEST.pm line 171.
> TYPE FOUND = 93.00
> 93.00 is not date!
> not ok 2
> Argument "93.00" isn't numeric in numeric eq (==) at
> t/ODBCTEST.pm line 171.
> TYPE FOUND = 93.00
> 93.00 is not date!
>
> not ok 3
> FAILED tests 1-3
> Failed 3/3 tests, 0.00% okay
> t\09multi...........1..0 # Skipped multiple statements not
> supported using Micro
>
> soft SQL Server
> DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server
> Driver][SQL Server]Inv
>
> alid object name 'PERL_DBD_TEST'. (SQL-42S02)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could
> not be prepare
>
> d. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at t\09multi.t line 46.
> skipped: multiple statements not supported using Microsoft SQL Server
> Failed Test Status Wstat Total Fail Failed List of Failed
> ------------------------------------------------------------------
> --------------
>
> t\02simple.t 255 65280 17 15 88.24% 3-17
> t\03dbatt.t 9 3 33.33% 3, 8-9
> t\05meth.t 255 65280 6 3 50.00% 3, 5-6
> t\07bind.t 255 65280 11 9 81.82% 3-11
> t\08bind2.t 3 3 100.00% 1-3
> 1 test skipped.
> Failed 5/7 test scripts, 28.57% okay. 33/51 subtests failed, 35.29% okay.
> NMAKE : fatal error U1077: 'C:\Perl\bin\perl.exe' : return code '0xff'
> Stop.
>
> 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
> Skipping C:\Perl\site\lib\DBD\ODBC.pm (unchanged)
> 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>coltest.pl
> Getting column info for: MyDSN, dbo, foo
> TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME,
> COLUMN_SIZE, BUFFER_LENGTH, DECIMAL_DIGITS, NUM_PREC_RADIX,
> NULLABLE, REMARKS,
> COLUMN_DEF, SQL_DATA_TYPE, SQL_DATETIME_SUB, CHAR_OCTET_LENGTH,
> ORDINAL_POSITION, IS_NULLABLE, SS_DATA_TYPE
> DBD::ODBC::st fetchrow_array failed: [Microsoft][ODBC SQL Server
> Driver]String
> data, right truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated)
> err=-1) at D:\Webroot\cgi-bin\tempdir\coltest.pl line 29.
> DBD::ODBC::st fetchrow_array failed: [Microsoft][ODBC SQL Server
> Driver]String
> data, right truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated)
> err=-1) at D:\Webroot\cgi-bin\tempdir\coltest.pl line 29.
>
> D:\Webroot\cgi-bin\tempdir>inttest.pl
> Connected to Microsoft SQL Server
> Inserted 103 records.
> Checking row 0.00 (4.00 )
> Argument "4.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 1.00 (4.00 )
> Argument "4.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 2.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 3.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 4.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 5.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 6.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 7.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 8.00 (12.00 )
> Argument "12.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 9.00 (12.00 )
> Argument "12.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 10.00 (12.00 )
> Argument "12.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 11.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 12.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 13.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 14.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 15.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 16.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 17.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 18.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 19.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 20.00 (88.00 )
> Argument "88.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 21.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 22.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 23.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 24.00 (100.00 )
> Argument "100.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 25.00 (100.00 )
> Argument "100.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 26.00 (12.00 )
> Argument "12.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 27.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 28.00 (183.00 )
> Argument "183.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 29.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 30.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 31.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 32.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 33.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 34.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 35.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 36.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 37.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 38.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 39.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 40.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 41.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 42.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 43.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 44.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 45.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 46.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 47.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 48.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 49.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 50.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 51.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 52.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 53.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 54.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 55.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 56.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 57.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 58.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 59.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 60.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 61.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 62.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 63.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 64.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 65.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 66.00 (114.00 )
> Argument "114.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 67.00 (251.00 )
> Argument "251.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 68.00 (282.00 )
> Argument "282.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 69.00 (281.00 )
> Argument "281.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 70.00 (276.00 )
> Argument "276.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 71.00 (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 72.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 73.00 (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 74.00 (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 75.00 (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 76.00 (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 77.00 (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 78.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 79.00 (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 80.00 (251.00 )
> Argument "251.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 81.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 82.00 (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 83.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 84.00 (3.00 )
> Argument "3.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 85.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 86.00 (276.00 )
> Argument "276.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 87.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 88.00 (276.00 )
> Argument "276.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 89.00 (3.00 )
> Argument "3.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 90.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 91.00 (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 92.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 93.00 (7.00 )
> Argument "7.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 94.00 (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 95.00 (144.00 )
> Argument "144.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 96.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 97.00 (284.00 )
> Argument "284.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 98.00 (276.00 )
> Argument "276.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 99.00 (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 100.00 (131.00 )
> Argument "131.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 101.00 (114.00 )
> Argument "114.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checking row 102.00 (122.00 )
> Argument "122.00" isn't numeric in numeric ne (!=) at
> D:\Webroot\cgi-bin\tempdir\inttest.pl line 152.
> Checked 103 records
>
> D:\Webroot\cgi-bin\tempdir>
>
>
> Jeff Urlwin wrote:
>
> > 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
>
>
