#9 bind_param() coercion problem

closed-fixed
None
5
2003-11-23
2003-11-19
No

Statement:

dbd_st_prepare: sqldialect: 1.
dbd_st_prepare: statement: INSERT INTO Transactions
(id, Creator, OldValue, RTType, TimeTaken, Ticket,
Data, NewValue, Field, Created) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?).
dbd_st_prepare: isc_dsql_prepare succeed..

--------------

Working:

dbd_st_prepare: sth inserted into linked list.
<- prepare= DBI::st=HASH(0x84a806c) at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 385
via /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 90
-> execute for DBD::InterBase::st
(DBI::st=HASH(0x84a806c)~0x8dce2c4 124 4 '33' 'Set' 0
27 undef '20' 'Queue' '2003-11-18 14:24:13')
dbd_bind_ph

Gives a 20 for NewValue and 33 for OldValue in the Database

--------------

Broken:

dbd_st_prepare: sth inserted into linked list.
<- prepare= DBI::st=HASH(0x84a8460) at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 385
via /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 90
-> execute for DBD::InterBase::st
(DBI::st=HASH(0x84a8460)~0x8dcd6b0 126 4 33 'Set' 0 27
undef 20 'Queue' '2003-11-18 14:27:50')
dbd_bind_ph

Gives a blank string '' for NewValue and 33 for
OldValue in the Database

Discussion

  • Edwin Pratomo

    Edwin Pratomo - 2003-11-19
    • status: open --> open-fixed
     
  • Edwin Pratomo

    Edwin Pratomo - 2003-11-19

    Logged In: YES
    user_id=47221

    Fixed in current cvs repos.

     
  • Edwin Pratomo

    Edwin Pratomo - 2003-11-23
    • status: open-fixed --> closed-fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks