Update - There does seem to have been some odd sort of file corruption, in that opening & saving the file without making any changes fixed the problem.
However, I just discovered that a coworker made changes to this taf on Monday, "just to add a couple things he needed". So the errors didn't just happen out of nowhere, they were probably caused by his changes. That's not nearly as worrisome. :^) -----Original Message----- From: Wilcox, Jamileh (HSC) Sent: Wednesday, July 23, 2003 9:41 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Inconsistent results from Search action Well, at least I've not lost all of my marbles. I think there's only a few more burning hoops and swaying highwires to get through before I can upgrade. In the meantime, I just keep patching things up. :) Thanks. j > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 23, 2003 5:32 AM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: Inconsistent results from Search action > > > 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_num > ber,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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
