>
> If I put debug statements in SQL::Statement (the C code) I find that
> the column is a string "85"
DBIx::Recordset passes it always as string to DBI
>and the parameter is.... sometimes an
> integer (works) and sometimes a real (doesn't).
>
strange...
> I have no idea whatsoever why it's a real. I gave up debugging (it
> gets real messy around the interface the C code)
I can imagine this...
>
> Fortunately, this works:
>
> my $cnt = $$set->Delete({'#uid' => 85});
This let DBIx::Recordset convert it to an integer before it passes it down
to DBI
>
> Is there a way of setting that up at Setup time instead of every time
> I do a query?
unfortunately not. The information is taken from the driver, in Database.pm
in function QueryMetaData, around line 241. It would be necessary to set the
hash %Numeric accordingly. If it's important for you, maybe you can make a
patch. I am happy to include it
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
