Re: Number formatting using DBI/ODBC with SQL Server

2002-07-24 Thread Jim Clark
Jeff, It worked! I reran the coltest.pl script (which worked this morning) and the inttest.pl script with much better results. I also reran 'nmake test TEST_VERBOSE=1' and attached the new results as well. Thanks again. -Jim D:\Webroot\cgi-bin\tempdir>coltest.pl Getting column info for: MyDSN,

RE: Number formatting using DBI/ODBC with SQL Server

2002-07-23 Thread Jeff Urlwin
s, 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 t

RE: Number formatting using DBI/ODBC with SQL Server

2002-07-23 Thread Jeff Urlwin
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 t

Re: Number formatting using DBI/ODBC with SQL Server

2002-07-23 Thread Jim Clark
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 p

RE: Number formatting using DBI/ODBC with SQL Server

2002-07-23 Thread Jeff Urlwin
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 > > Jim; > I've the same problem with Access2000. > > Based upon you

Re: Number formatting using DBI/ODBC with SQL Server

2002-07-23 Thread Gary Gauthier
Jim; I've the same problem with Access2000. Based upon your e-mail, I think it is due to DBI not knowing how to decode the various type values used by different databases. Try using the TYPE attribute for the recordset to get the pointer to an array of type-values for the recordset. Once you h

Number formatting using DBI/ODBC with SQL Server

2002-07-22 Thread Jim Clark
A quick question regarding numeric formatting and SQL Server 2000. I have a view set up that has an integer field of length 4. When I fetch the data, instead of seeing values such as '1024' as it is displayed in SQL Enterprise Manager, the data shows up in my array ref as '1,024.00'. I can remove