AMTo: [EMAIL PROTECTED]Subject: Re: select
staetment
I keep 7 days in the actlog - the event
log must have the data - as you can do a query past one day using begind and
begint.
Does anyone know the tables used in the q
events command?
Jane
Jane
: 1996-04-25 14:31:19.025065
COLCOUNT: 8
INDEX_COLCOUNT: 1
UNIQUE_INDEX: FALSE
REMARKS: Scheduled Event Results
-Original Message-
From: Jane Bamberger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 8:17 AM
To: [EMAIL PROTECTED]
Subject: Re: select staetment
I
Hi,
Hopefully someone can help me. I want to do
a select statement on the events table, but for some reason when I do a select -
it will only give me todays events. If I do a query with a begind of yesterday -
I get yesterday's events.
for example:
tsm: BASSETTselect * from events where
Search the list archive for select+event.
http://search.adsm.org/
In particular check out http://msgs.adsm.org/cgi-bin/get/adsm0009/619.html
-Original Message-
From: Jane Bamberger [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 3:26 PM
To: [EMAIL PROTECTED]
Subject: select
select * from events where date(actual_start) = '2002-02-19'
But, it depends on how long you keep
them.
-Original Message-From: Jane Bamberger
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20,
2002 4:26 PMTo: [EMAIL PROTECTED]Subject: select
staetment
Hi