Strange behaviour with excel datasource

2002-04-18 Thread Dave Wilson
Hi all, I'm running two consecutive queries on an excel datasource as follows: first query simply updates values in a single record in the spreadsheet. The spreadsheet then uses these values to calculate APR on a loan using successive approximations method (RATE function in excel). The second

RE: Strange behaviour with excel datasource

2002-04-18 Thread Craig Thomas
the excel file into a SQL server 7 database and using it as the data source. Craig -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:52 AM To: CF-Talk Subject: Strange behaviour with excel datasource Hi all, I'm running two consecutive queries

RE: Strange behaviour with excel datasource

2002-04-18 Thread Dave Wilson
getting a consistently cached value. Thanks for your suggestion though, Dave -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: 18 April 2002 14:18 To: CF-Talk Subject: RE: Strange behaviour with excel datasource I have had this problem too (with CF 4.5). I was able