selecting a bigint
I'm trying to use DBI and DBD::mysql with perl-5.8.8 on a 64bit Redhat host: Linux host 2.6.9-67.0.20.ELsmp #1 SMP Wed Jun 18 12:35:02 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux I need to do table lookups based on a column of type bigint. I don't generate or manipulate the bigint value myself - I actually read it in from the database. But when I turn around and try to select on the bigint value, it is not found. I scanned the web etc and have tried "use bigint", quoting the value, forcing it to be string, etc. Testing shows that defining a large int as a string and inserting it into the database works fine (I pass $query to prepare() and $token to execute()): my $token = "18288286186892797895"; $query = "insert into table (uid, token) VALUES (9, ?)"; But I cannot figure out a way to turn around and select on that same token. For instance, these do nothing: $query = "UPDATE table set uid = 8 where (uid = 9) and (token = ?)"; OR $query = "SELECT * from table where (uid = 9) and (token = ?)"; If I try a smaller number for token, everything works as expected. Tod Sandman Sr. Systems Administrator Middleware Development & Integration Rice University Voice: 713.348.5816
RE: unable to write from a select into outfile
Apologies for the email. I've got about a dozen web sites in my dev environment. Changed IIS params for one and apparently hosed up all. Fixed the params and all is well again. Found it by tracing and not connecting to the database I thought I was connecting to. Enough overlap in the DBs that I did not pick up on it right away. E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems - C2SD MailStop 4S02 2340 Dulles Corner Blvd. Herndon, VA 20171 703-561-3671 703-713-1601 (fax) -Original Message- From: Martin Evans [mailto:martin.ev...@easysoft.com] Sent: Friday, May 15, 2009 1:02 PM To: Stricker, Scott E (IS) Cc: dbi-users@perl.org Subject: Re: unable to write from a select into outfile -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stricker, Scott E (IS) wrote: > All: > > I'm running on a windows XP box with latest MS updates, > ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread) > DBI (1.607) > DBD-ODBC (1.21) > SQL Server 2005 (SP3) > > Seems like all of a sudden queries against my database are not returning > the correct data. First noticed when executing a query like > Select a, b, c from vtbl where a like 'test%' > > And nothing was returned. I've got a record where a is 'test.' > > After playing with that for a while, for example trying select a,b,c > from vtbl where a='test.', I tried select a,b,c from vtbl where a like > 'a%' and got back 9 out of 8013 expected records. Most of the records > that I did not get back have embedded periods or single quotes or > dashes. > > Note that the same queries executed in the sql server enterprise manager > and sqlcmd return the correct results. > Also, I have not tried with earlier versions of dbd-odbc yet. > > Any light that can be shed on this would be greatly appreciated. > > E. Scott Stricker > Senior Software Engineer > Northrop Grumman - Information Systems - C2SD > MailStop 4S02 > 2340 Dulles Corner Blvd. > Herndon, VA 20171 > 703-561-3671 > 703-713-1601 (fax) > > If you enable a DBI trace at level 15 and send it to me I'll take a look. It would also be good if you can add the following to the start of your test script as it enables extra logging that would be useful: use DBD::ODBC; DBI->trace(DBD::ODBC->parse_trace_flags('odbcconnection|odbcunicode')); Perhaps you could explain what you mean by "all of a sudden". Before this happened what was happening correctly with what versions? Martin - -- Martin J. Evans Easysoft Limited http://www.easysoft.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFKDaAchd1KVpsamNgRAgQLAJ98VUcsp6uFJpJ7RhTw5xe84XmbYwCfc4SG XE1lPlcVEkTx+jwVNRKv5p8= =qz+a -END PGP SIGNATURE-
Re: unable to write from a select into outfile
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stricker, Scott E (IS) wrote: > All: > > I'm running on a windows XP box with latest MS updates, > ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread) > DBI (1.607) > DBD-ODBC (1.21) > SQL Server 2005 (SP3) > > Seems like all of a sudden queries against my database are not returning > the correct data. First noticed when executing a query like > Select a, b, c from vtbl where a like 'test%' > > And nothing was returned. I've got a record where a is 'test.' > > After playing with that for a while, for example trying select a,b,c > from vtbl where a='test.', I tried select a,b,c from vtbl where a like > 'a%' and got back 9 out of 8013 expected records. Most of the records > that I did not get back have embedded periods or single quotes or > dashes. > > Note that the same queries executed in the sql server enterprise manager > and sqlcmd return the correct results. > Also, I have not tried with earlier versions of dbd-odbc yet. > > Any light that can be shed on this would be greatly appreciated. > > E. Scott Stricker > Senior Software Engineer > Northrop Grumman - Information Systems - C2SD > MailStop 4S02 > 2340 Dulles Corner Blvd. > Herndon, VA 20171 > 703-561-3671 > 703-713-1601 (fax) > > If you enable a DBI trace at level 15 and send it to me I'll take a look. It would also be good if you can add the following to the start of your test script as it enables extra logging that would be useful: use DBD::ODBC; DBI->trace(DBD::ODBC->parse_trace_flags('odbcconnection|odbcunicode')); Perhaps you could explain what you mean by "all of a sudden". Before this happened what was happening correctly with what versions? Martin - -- Martin J. Evans Easysoft Limited http://www.easysoft.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFKDaAchd1KVpsamNgRAgQLAJ98VUcsp6uFJpJ7RhTw5xe84XmbYwCfc4SG XE1lPlcVEkTx+jwVNRKv5p8= =qz+a -END PGP SIGNATURE-
RE: unable to write from a select into outfile
All: I'm running on a windows XP box with latest MS updates, ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread) DBI (1.607) DBD-ODBC (1.21) SQL Server 2005 (SP3) Seems like all of a sudden queries against my database are not returning the correct data. First noticed when executing a query like Select a, b, c from vtbl where a like 'test%' And nothing was returned. I've got a record where a is 'test.' After playing with that for a while, for example trying select a,b,c from vtbl where a='test.', I tried select a,b,c from vtbl where a like 'a%' and got back 9 out of 8013 expected records. Most of the records that I did not get back have embedded periods or single quotes or dashes. Note that the same queries executed in the sql server enterprise manager and sqlcmd return the correct results. Also, I have not tried with earlier versions of dbd-odbc yet. Any light that can be shed on this would be greatly appreciated. E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems - C2SD MailStop 4S02 2340 Dulles Corner Blvd. Herndon, VA 20171 703-561-3671 703-713-1601 (fax)
Re: DBI Make error
On Thu, May 14, 2009 at 2:28 PM, Ritesh patel wrote: > I am trying to install DBI module on AIX 5.3 for perl 5.8.2 64bit. > > During software build I am getting error. Does anyone has any idea? > /bin/sh: cc_r: not found. You don't have a C compiler (or the correct C compiler) installed. -- Jonathan Leffler #include Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."
DBI Make error
I am trying to install DBI module on AIX 5.3 for perl 5.8.2 64bit. During software build I am getting error. Does anyone has any idea? Thanks DBI.log Description: Binary data