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

Reply via email to