I know that sometimes "Tango 2000" have had this problem (not only with Access). With Witango 5 I never have see the problem again. So, I suggest that you make a update to Witango 5.
regards Daniel ----- Original Message ----- From: "Wilcox, Jamileh (HSC)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 1:30 AM Subject: Witango-Talk: Inconsistent results from Search action 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
