...
> fdat{note.employee_key} = 1
...
> fdat{note.note_datetime} = 8/29/2001
> fdat{note.note_key} = 10037
> fdat{note.incident_key} = 10149
The above values of %fdat, are made to the where expression by
DBIx::Recordset. You only pass %fdat to Execute not to Search, that's the
difference:
> DB: Execute =search
> DB: SelectWhere <!Table>=<note> type = !
> DB: SelectWhere <note.employee_key>=<1> type = n
> DB: SelectWhere <update>=<Update> type = u
> DB: SelectWhere <=search>=<ok> type = =
> DB: SelectWhere <!Filter>=<> type = !
> DB: SelectWhere <note.note>=<this is another test of the notes function>
> type = n
> DB: SelectWhere <note.note_datetime>=<8/29/2001> type = n
> DB: SelectWhere <!DataSource>=<DBI::db=HASH(0x502ed8c)> type = !
> DB: SelectWhere <note.note_key>=<10037> type = n
> DB: SelectWhere <note.incident_key>=<10149> type = n
> DB: SelectWhere <!Fields>=<MAX(note.note_key) AS dave> type = !
> DB: FLUSH Recordset id = 194 DBIx::Recordset=HASH(0x4ffdde0)
> 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=<1 this is another test of the
> notes function 8/29/2001 10037 10149> bind_types=<3 12 9 3 3>
I hope it's more clear now
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]
