I understand that it does not make a difference when you run the raw SQL
against the database. but for some reason it makes a difference when it is
run under EmbPerl. the first one does not return a record set while the
second one does.
-----Original Message-----
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 1:00 PM
To: Boyd, David; EmbPerl News Group (E-mail)
Subject: Re: Another DBIx question.
> DB: 'SELECT unanet_employee.first_name || ' ' ||
unanet_employee.last_name
> as employee_name,
> note.note_datetime,
> note.note
> FROM note, unanet_employee
> WHERE (unanet_employee.employee_key = note.employee_key) and
> ( ( (note.incident_key = ?)))
> ORDER BY note.note_datetime ' bind_values=<10149> bind_types=<3>
>
> I was expecting the following (based on the documentation)
>
> DB: 'SELECT unanet_employee.first_name || ' ' ||
unanet_employee.last_name
> as employee_name,
> note.note_datetime,
> note.note
> FROM note, unanet_employee
> WHERE ( ( (note.incident_key = ?))) and
> (unanet_employee.employee_key = note.employee_key)
> ORDER BY note.note_datetime ' bind_values=<10149> bind_types=<3>
>
Sorry, but where is the difference. I don't see it. Except that the and
condition is exchanged which doesn't matter
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]
