-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, October 31, 2003 11:52 AM
To: CF-Talk
Subject: Re: Query Delete???
Like I said...here's the UDF...it does work...not sure why Ray and Michael
don't think it will work??
http://www.cflib.org/udf.cfm?ID=11 <http://www.cflib.org/udf.cfm?ID=11>
I've used it before with no problems. I was storing a query in a WDDX
packet in a cookie and adding/deleting rows as needed....but hey...mabye
your situation is different
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Craig Dudley
To: CF-Talk
Sent: Friday, October 31, 2003 8:26 AM
Subject: RE: Query Delete???
Query Of a Query should do that just fine?
e.g.
<cfquery datasource="anydsn" name="query1">
select field1,fiedl2,field3
from sometable
</cfquery>
<cfquery dbtype="query" name="query2">
select field1,field3
from query1
</cfquery>
-----Original Message-----
From: chris [mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 16:34
To: CF-Talk
Subject: Query Delete???
I have scoured the list archives and CF forums and can't find an
answer. Is
there any way to delete rows from a CF query?
I am attempting to use CF 5 and WDDX for data storage and I need
a way to
delete rows. I know that I can simply rebuild the query without
the
deleted items, but I assume there must be a better way? The
larger the
data gets, the bigger perfomance hit from rebuilding.
Any suggestions?
If there is no elegant or efficient way to do this, are there
any
suggestions on an alternative data storage method that would
allow easy
retrieval into CF as well as the ability to perform modifcations
to the
data? (I'm trying to avoid using a central db)
TIA,
Chris
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
