Have you verified that all of the queries referenced have no funky data in
them? Like reserved characters?
---
Billy Cravens
HR Web Systems, EDS
[EMAIL PROTECTED]
----- Original Message -----
From: "Marlon Moyer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 2:10 PM
Subject: Query of Query
>
> 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
>
-------------------------------------------------------------------------
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
