On Fri, 27 Oct 2006, Ferindo Middleton wrote:
Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have
Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have a trigger on it, I'd like to iterate
through ind
How about
SELECT * FROM queLog
WHERE accessed = "Y"
AND targetApp = "acadreg"
AND enteredQue >= '2004-11-09 18:00:00';
(You said greater than first, then you said greater than or equal to. I
went with the latter.)
Michael
Kory Wheatley wrote:
I'm trying to do a select statement where:
fi
I'm trying to do a select statement where:
field "targetApp" equals the value "acadreg" and
field accessed equals the value "Y" and
filed enteredQue is like "2004-11-09 18%" the whole "enterqueue"
fieild is something like "2004-11-09 16:00:34"
Here's what I'm trying to accomplish, I want to
