Actually, I think I'm figuring it out. I'm using CF 5 and I'm using the new
connectstring attribute for <cfquery> which we use to specify the database
file that CF should connect to. I'm also using cachedwithin. Now, I don't
know if this is intentional, or a bug, but it looks like you can't use any
query caching when specifying a connectstring .. or at least a connect
string where the dbfile is specified. If you do, cf will just hang there
searching for the cached file in memory, which might or might not exist.
I'll post more if I ever figure out _exactly_ what is going on.
Todd
----- Original Message -----
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 11:56 AM
Subject: Re: laaaaaaaaaaaaaag
| I had some similar weirdness with cf 4.5 - I upgarded to the latest SP and
all was fine...
|
| HTH,
|
| Howie Hamlin - inFusion Project Manager
| On-Line Data Solutions, Inc.
| www.CoolFusion.com
| 631-737-4668 x101
| inFusion Mail Server (iMS) - The Intelligent Mail Server
| Join the DevCon community at www.coolfusion.com/devcon
|
| ----- Original Message -----
| From: "Todd Ashworth" <[EMAIL PROTECTED]>
| To: "CF-Community" <[EMAIL PROTECTED]>
| Sent: Tuesday, July 10, 2001 11:46 PM
| Subject: Re: laaaaaaaaaaaaaag
|
|
| > I know .. I was just looking for some sympathy and was trolling for a
muffin
| > or 2 ;)
| >
| > I wouldn't be at all suprised if it our mail server that's causing all
of
| > the trouble. I just haven't had the time or the desire to take a good
look
| > at the configuration. The tech support people all get their mail on
time,
| > so that's all that really matters.
| >
| > Oh .. oh .. technical question for all you smart peoples in here!!
| >
| > I have this query:
| >
| > <cfquery name="qry_ValidateLogin" datasource="#Request.mainDSN#"
| > connectstring="#Client.CustomConnectString#"
| > username="#qry_GetUserID.ContactPK#"
password="#Attributes.txtPassword#">
| > SELECT 1
| > FROM dummy
| > </cfquery>
| >
| > Anytime I run this query, the system just 'hangs'. It just sits there
| > forever like it's trying to find the site. It never finishes, it never
| > times out, and it never throws an error. I know the database isn't
locked
| > up, because I can go other places on the site which pull data from that
same
| > database and they all work fine. The Request.mainDSN is the same in all
| > queries, as is the connectstring (minus the userid and password for this
| > particular one.) I mean, this is the simplest query one can possibly
write.
| > It doesn't even really retrieve anything. I'm just testing to see if a
| > connection can be made to the database using the user-provided username
and
| > password.
| >
| > Has anyone seen this type of behavior before? After 16 months of
| > development, we are |<-->| that close to being able to relase this thing
| > into beta, but this is holding us up .. Help!!!
| >
| > Todd
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
