Greetings! As per request: +-------------------------------------------- diff -u ORIG.monetdb.pm NEW.monetdb.pm --- ORIG.monetdb.pm 2005-01-31 23:55:25.000000000 +0000 +++ NEW.monetdb.pm 2005-02-11 19:16:38.360595999 +0000 @@ -163,7 +163,8 @@ s/"/\\"/g; s/'/''/g; } - return "'$statement'"; + #return "'$statement'"; + return "\"$statement\""; } sub _count_param { @@ -629,7 +630,11 @@ my $rows = MapiLib::mapi_rows_affected($hdl); - if ( MapiLib::mapi_get_querytype($hdl) != 3 ) { +# if ( MapiLib::mapi_get_querytype($hdl) != 3 ) { +# $sth->{monetdb_rows} = $rows; +# return $rows || '0E0'; +# } + if ( MapiLib::mapi_get_querytype($hdl) == 0 ) { # Was a 0 meant here ??? $sth->{monetdb_rows} = $rows; return $rows || '0E0'; } +-------------------------------------------- Comments: (1) The first group was because '' demarks characters, while what seemed to be wanted in MIL is "". _However_, I have not tested this code using SQL statements, so it may be required that there is some test needed depending on MIL vs SQL mode for proper operation. (2) The second group was because I was getting a "statement not marked as Active" type error from DBI after a $sth->execute(). It is a complete hack just to get testing done, without digging to determine if this is the right correction (ie, what I did is most likely wrong and needs fixing). This may be a case of MIL vs SQL again. This can be tested via the sample MIL perl code, as this is how I found the problems. Even with the above 2 changes, the sample code does not run (fails to recognize error return codes, etc). Regards! Ed On Fri, 11 Feb 2005, Steffen Goeldner wrote:
Stefan Manegold wrote:
Since I'm not a perl expert, I feel free to forward this to Steffen Goeldner, who is generously taking care of the Perl interface of MonetDB.
Steffen,
I hope, you don't mind, if I put his on your desk, do you?
That's absolutely ok.
I would be great, I you could have a look at this problem. You can find the whole thread at http://sourceforge.net/mailarchive/forum.php?thread_id=6536996&forum_id=42505
If necessary, you can probabaly ask Ed for his patch...
Yes Ed, please send me a diff -u. In the face of the imminent release date, I'd prefer to make modifications in the development trunk only, not the release branch. Would that be acceptable?
Steffen
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users