Witango-Talk: Select 1 From xxx where 1=0

[Dave Machin]

We're still having trouble with WiTango 5.5.009 reading or writing from the wrong data source.   In trying to figure out it, we've come up with a question.   We're running MS-SQL profiler to see all the database queries issued by WiTango.  We see one like this:   "select 1 from AgentIdToName where 1=0"   which happens before every database query in our .taf application.  We're assuming this is to check that the data source is still alive, in fact if we rename the AgentIdToName table in the middle of an execution, WiTango makes a new DB connection.  We also saw this in WiTango 5.0, although I seem to remember it only happening once at the beginning of a page request, not once for each query in the request.   Anyhow, here's our question:   On our development machine we see this keep alive query before each query executed, but on our production machine it seems to happen intermittently.  Some page requests have the keep alive before each query, some only have it every few queries.   Does anyone know if this is normal? ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf