on large queries. We were looking for alternate solutions. The UDF you
mentioned does a query rebuild so could not be suggested.
Still, a comparison between the UDF and a QoQ would be of interest.
> 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
>
> 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]
