Hi guys, boy y'all have been busy. I'm trying to catch up on the last
month's worth of list mail, but there's been a LOT!
Anyways, on to my question.
Tango2000 & Access2000 on W2K server (I know, I know, but the database
wasn't up to me)
I have an Access query:
SELECT classsched.class_name, classsched.class_date,
classsched.class_time, classsched.class_session_number,
Count(enrollment.username) AS CountOfusername, classsched.cancelled,
classsched.class_sess_autoID
FROM classsched LEFT JOIN enrollment ON
classsched.class_sess_autoID = enrollment.class_session_ID
GROUP BY classsched.class_name, classsched.class_date,
classsched.class_time, classsched.class_session_number,
classsched.cancelled, classsched.class_sess_autoID
HAVING (((classsched.class_date)>=Format(Now(),"Short
Date")))
ORDER BY classsched.class_date, classsched.class_time
WITH OWNERACCESS OPTION;
that produces resultset:
class_name class_date class_time
class_session_number CountOfusername cancelled
class_sess_autoID
Analyzer A/R Cubes 7/22/2003 1:00 pm - 2:30pm
0003 2 No 147
Analyzer A/R Cubes 7/22/2003 10:00 am - 11:30
am 0002 4 No
146
Analyzer A/R Cubes 7/22/2003 3:00 pm - 4:30
pm 0004 5 No
148
Analyzer A/R Cubes 7/22/2003 8:00 am - 9:30
am 0001 7 No
145
Analyzer A/R Cubes 7/23/2003 1:00 pm - 2:30pm
0006 2 No 150
Analyzer A/R Cubes 7/23/2003 3:00 pm - 4:30
pm 0007 0 Yes
151
Analyzer A/R Cubes 7/23/2003 9:00 am - 12:00
pm 0005 0 Yes
149
Then I've got a Tango Search Action:
SELECT
q1.class_name,q1.class_date,q1.class_time,q1.class_session_number,q1.Cou
ntOfusername,q1.class_sess_autoID FROM qry_ClassEnrollment_UserCount q1
WHERE (q1.cancelled=0 AND q1.class_date>=<@CURRENTDATE>) ORDER BY <@VAR
local$columnSort> ASC
that produces resultset:
class_name class_date
class_time class_session_number CountOfusername
class_sess_autoID
Analyzer A/R Cubes 07/22/2003 00:00:00 1:00 pm
- 2:30pm 0003 0 147
Analyzer A/R Cubes 07/22/2003 00:00:00 10:00 am
- 11:30 am 0002 4 146
Analyzer A/R Cubes 07/22/2003 00:00:00 3:00 pm
- 4:30 pm 0004 5 148
Analyzer A/R Cubes 07/22/2003 00:00:00 8:00 am
- 9:30 am 0001 7 145
Analyzer A/R Cubes 07/23/2003 00:00:00 1:00 pm
- 2:30pm 0006 2 150
As you can see, the CountOfusername is wrong in one record
(class_sess_autoID=147) in the Tango resultset.
For grins & giggles, I deleted the WHERE parameter "q1.cancelled=0" from
Tango and refreshed the page - the results from the database query &
Tango search then matched exactly. I added the same WHERE parameter
back to the Search action and refreshed - and the webpage showed correct
results (i.e., 5 records with correct values in the CountOfusername
column). All of this was done in a test copy.
I then opened the original TAF and saved it without making any changes.
That seems to have fixed the problem - the webpage started showing
correct results.
Has anyone seen a similar problem? I'm quite concerned, as this page
was working correctly and suddenly started giving bad data with no
warning. I can't tell my users it's fixed if it may quit working again
at any moment.
Thanks for any ideas or advice!
jamileh
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
