Here is the resulte of when I use the debug=2
This result is from using the below code:
DBIx::Recordset::Undef ('set');
$fdat{'!DataSource'} = GetDSN();
$fdat{'!Table'} = 'note';
$fdat{'!Fields'} = 'MAX(note.note_key) AS dave';
$fdat{'=search'} = 'ok';
*set = DBIx::Recordset->Execute({%fdat});
push @debugMessage, "another one set{dave} = $set{dave}";
DB: Use already open dbh for Nisys05 (id=186, numOpen = 0)
DB: 'SELECT MAX(note.note_key) AS dave FROM note WHERE (
(note.employee_key = ?)) and ( (note.note = ?)) and (
(note.note_datetime = ?)) and ( (note.note_key = ?)) and (
(note.incident_key = ?)) ' bind_values=<14 dfasfafasfasfas dsfas fdasdf
asdf 8/28/2001 10037 10118> bind_types=<3 12 9 3 3>
Any clue as to why there is a where statement? pretty wacky.
-----Original Message-----
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 10:40 AM
To: Boyd, David; EmbPerl News Group (E-mail)
Subject: Re: Help on using DBIx
> What is the difference between these statemens:
>
Should be the same if $DSN and GetDSN and $Table and 'note' are the same.
BTW. The use of \%fdat instead of {%fdat} is a little fater
If it still doesn't work, set $DBIx::Recordset::Debug = 2 before any access
and watch the log output
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]
