Re: Dumb question--between/and
From Holly Gordon:
*
* Can someone tell me what is wrong with this between clause? Seems to cause a
* long transaction, which aborts--
*
* Select author from marc
* where creation_date between "19930901*" and "19940831*" and
* title_id in (select title_id from item where agency_id = "TNR")
* end
You cannot have wildcard matching characters within a date field match.
The '*' and '?' wildcards are only used in CHAR fields.
(See manual INFORMIX-4GL Users Guide Version 4.00 Page 12-10 Part No. 000-7043)
Change to:
Select author from marc
where creation_date between "19930901" and "19940831" and
title_id in (select title_id from item where agency_id = "TNR")
end
Robert Minter |Data Systems Support| \\\\\\_///
Programmer, Software Development | Orange, CA | ( _ _ )
internet: rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |)
bangpath: uunet.uu.net!dssmktg!rob| Fax: 714.771.3028 | \\`-'/
#include <disclaimer.h> SURF'S UP \\_/