But, if I tell you then you'll know just how stupid my theoretical test
with no potential for real world application really is...
It's basically a small chat engine stored as an application variable so
that it's not easily traceable and it only resides in the server's
memory and the browser window. And to limit the impact on performance
and traceability, I wanted it to purge older messages.
Alas, here's the code snippet I finally used. Perhaps it will help
someone else. In the end moving an object from query type to something
else such as a struct was too much code and since data volatility isn't
an issue, it was easier just to recreate the query.
If anyone's interested I'll post the code somewhere. It's just 3 files:
1 Application.cfm, 1 index.cfm and 1 datarequestor.js. It's about 150
lines of CF code. The JS file does all the ajaxy stuff and it's 490+
lines.
kthxbye.
mf
<cfquery name="qSelect" dbtype="query">
select * from application.msgs where
id>#evaluate(getTickCount()-250000)#
</cfquery>
<cflock timeout="10" throwontimeout="Yes" name="msgs"
type="EXCLUSIVE">
<cfset
application.msgs=QueryNew("ID,USR,MSG,DTS","BigInt,VARCHAR,VARCHAR,DATE"
)>
<cfoutput query="qSelect">
<cfset temp = queryAddRow(application.msgs)>
<cfset temp = QuerySetCell(application.msgs, "ID", id)>
<cfset temp = QuerySetCell(application.msgs, "USR", usr)>
<cfset temp = QuerySetCell(application.msgs, "MSG", msg)>
<cfset temp = QuerySetCell(application.msgs, "DTS", dts)>
</cfoutput>
</cflock>
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, January 10, 2008 7:49 AM
To: [email protected]
Subject: RE: [ACFUG Discuss] queryNew() ?
Mark;
Is there any chance you could give a better explination on what you are
trying to accomplish? Please use sudo code to explain, there might be
someone out here in ACFUG land that has accomplished the same thing your
are looking to do but in a different manner.
Thanks
Jason L West
--- Quote ---
Learn to ask yourself at least three times through out your day, "Am I
being productive or just active?", in order
to keep yourself on track to what produces effective results instead of
just looking efficient.
"Fennell, Mark P." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/10/2008 06:54
Please respond to
[email protected]
To
<[email protected]>
cc
Subject
RE: [ACFUG Discuss] queryNew() ?
Yeah. I don't know if it was the right thing to do, but I basically just
used a QoQ to selected the "desired" data and rebuilt the queryNew
variable.
Thanks.
mf
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darin Kohles
Sent: Wednesday, January 09, 2008 1:23 PM
To: [email protected]
Subject: RE: [ACFUG Discuss] queryNew() ?
Your best bet is to simply to do a query of queries - you can then
filter either columns or row using SQL
<cfquery name="q_newQuery" dbtype="query">
SELECT row1, row5, etc...
FROM q_oldQuery
WHERE uncle like '%bob%'
</cfquery>
Darin Kohles, Application Developer
[EMAIL PROTECTED]
Digital Positions, Inc.
2289 Peachtree Road NE
Atlanta, GA 30309
404-351-8878 support phone
404-351-2366 main phone
404-351-4055 fax
http://www.d-p.com/ <http://www.d-p.com/>
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fennell,
Mark P.
Sent: Wednesday, January 09, 2008 1:04 PM
To: [email protected]
Subject: [ACFUG Discuss] queryNew() ?
Is there anyway to delete data from a query? Yes, delete from a _query_
not from a table or other database object.
See, I want to use the queryNew() family of functions to collect some
data from the client before I stick it in the database, kind of like in
a shopping cart. You should be able to smell the stench of AJAX...
Can structDelete() be used?
I seem to recall that this can be done. I just don't remember the
details.
Thanks.
mf
-------------------------------------------------------------
Annual Sponsor - Figleaf Software <http://www.figleaf.com/>
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
<http://www.acfug.org?fa=login.edituserform>
For more info, see http://www.acfug.org/mailinglists
<http://www.acfug.org/mailinglists>
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
<http://www.mail-archive.com/discussion%40acfug.org/>
List hosted by FusionLink <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor - Figleaf Software <http://www.figleaf.com/>
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
<http://www.acfug.org?fa=login.edituserform>
For more info, see http://www.acfug.org/mailinglists
<http://www.acfug.org/mailinglists>
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
<http://www.mail-archive.com/discussion%40acfug.org/>
List hosted by FusionLink <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor - Figleaf Software <http://www.figleaf.com/>
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
<http://www.acfug.org?fa=login.edituserform>
For more info, see http://www.acfug.org/mailinglists
<http://www.acfug.org/mailinglists>
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
<http://www.mail-archive.com/discussion%40acfug.org/>
List hosted by FusionLink <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor - Figleaf Software <http://www.figleaf.com>
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
