I'm trying to forego my Stored proc problem by using a query of a query. If
queries r1,r2,r3 run with no problem, the following query will run
occasionally.
<cfquery dbtype="query" name="request.LoginStats" >
SELECT r1.LoginType, r1.Logins, r3.NumSessions, r2.TimeOnline
FROM r1, r3, r2
WHERE (r1.LoginType = r3.LoginType) and (r1.LoginType =
r2.LoginType)
</cfquery>
Most of the time it produces:
unknown exception condition
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
I'm running MSSql7.0 on winnt 4 sp6 with MDAC 2.6 <-- Just updated today,
but was having similar problems before, and of course CF5
Thanks,
Marlon
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org