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]
Re: Query Delete???
Pretty darn sure there is a UDF on cflib.org to delete rows from queries 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: chris To: CF-Talk Sent: Friday, October 31, 2003 8:33 AM 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]
RE: Query Delete???
Afaik, the only way is to rebuild the query. There is a UDF at cflib.org for this to make it easier. If your 'rows to delete' criteria is a logic test, like Delete rows where column X is 1, then you could use QofQ. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Query Delete???
There is no function for this and running such a function would be costly in the long run as you mentioned. As for your setup, are you reading and writing the WDDX packet from disk and using that as storage? If so and theres no reason for a query, then save the data as a structure. You would have a lot more control and can set it up to do almost as much as a query can (though with a little more code in some cases). 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]
Re: Query Delete???
Thank you for that Raymond. I didn't even think of QoQ as a solution. Interesting approach. I wonder what the performance would be with a large (1000+ item) query in comparison to rebuilding the query. Looks like something new to test. :) Afaik, the only way is to rebuild the query. There is a UDF at cflib.org for this to make it easier. If your 'rows to delete' criteria is a logic test, like Delete rows where column X is 1, then you could use QofQ. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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]
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 I've used it before with no problems.I was storing a query ina WDDX packet in a cookie and adding/deleting rows as neededbut 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]
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 I didn't say it wouldn't work. Michael said that it may not be best for large queries, and that is certainly true. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query Delete???
That UDF just rebuilds the query... -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 ina WDDX packet in a cookie and adding/deleting rows as neededbut 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]
Re: Query Delete???
The original poster didn't want to rebuild the query due to performance hits 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 ina WDDX packet in a cookie and adding/deleting rows as neededbut 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]
Re: Query Delete???
Ahhhgotcha...and yes...agreedthe queries I was dealing with had at most 5-10 rows (thus being able to stuff it into WDDX packet and into a cookie) Thanks 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: Raymond Camden To: CF-Talk Sent: Friday, October 31, 2003 8:56 AM 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 I didn't say it wouldn't work. Michael said that it may not be best for large queries, and that is certainly true. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query Delete???
An alternative method of storing complex datatypes is to store it as cfscript, e.g. save a file with the following, then cfinclude it: cfscript foo = StructNew(); foo.bar=1; /cfscript There's a udf on cflib (http://www.cflib.org/udf.cfm?ID=713) that will turn a CF var into a cfscript block, but you'll need to do any file writing or whatever. One advantage i've found over wddx is its much simpler and faster to get the data into memory - i've been using it on a couple of busy sites for over 18 months now. Obviously there are plenty of reasons why you might rather use WDDX - horses for courses. Cheers Bert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 17:35 To: CF-Talk Subject: Re: Re:Query Delete??? WDDX can store any complex or non-complex data type. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query Delete?
The permissions are in the database and trying to do it at display time (I understand this as doing it while displaying it on the browser) may not be the best way to do it. Kedar Desai Differential Technologies Fairfax, VA --- "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] wrote: why can't you handle that logic at display time? check to see to what the user has permissions, and display accordingly? Chris Olive, DOEHRS Website Administrator -Original Message- From: Planet CF [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 4:46 PM To: [EMAIL PROTECTED] Subject: RE: Query Delete? The need for a QueryDeleteColumn or QueryDeleteRow arises in situations where one wants to manipulate the query due to various reasons. One of them could something like applying security on the query. This means that the user does not priviledges to view all the rows/columns of the query (which is a join). In such a case you would want to delete data which is secure. One can say that incorporate that in the 'select' itself. However this cannot be done bcoz some users have override security priviledges, meaning that security does not apply for such users. The bottomline is that, if there is a QueryAddColumn then why not a QueryDeleteColumn and also QueryDeleteRow. Kedar Desai Differential Technologies Fairfax, VA -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: Query Delete? This is a multi-part message in MIME format. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Query Delete?You could relatively easily do it using the QueryNew() = function and looping over. But what would be the point? Just don't = selec the column in the first place. DC - Original Message -=20 From: Planet CF=20 To: [EMAIL PROTECTED]=20 Sent: Tuesday, August 08, 2000 14:34 Subject: Query Delete? Hi,=20 Is there a custom tag somewhere out there, that=20 deletes a column from a query?=20 Thanks=20 Kedar Desai=20 Differential Technologies=20 Fairfax, VA=20 __=20 Do You Yahoo!?=20 Kick off your party with Yahoo! Invites.=20 http://invites.yahoo.com/=20 = -= -=20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEQuery Delete?/TITLE META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2You could relatively easily do it using = the=20 QueryNew() function and looping over. But what would be the point?nbsp; = Just=20 don't selec the column in the first place./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2DC/FONT/DIV DIVnbsp;/DIV BLOCKQUOTE=20 style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px" DIV style=3D"FONT: 10pt arial"- Original Message - /DIV DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"BFrom:/B=20 A href=3D"mailto:[EMAIL PROTECTED]" = [EMAIL PROTECTED]Planet CF/A=20 /DIV DIV style=3D"FONT: 10pt arial"BTo:/B A=20 href=3D"mailto:[EMAIL PROTECTED]"=20 [EMAIL PROTECTED][EMAIL PROTECTED]/A /DIV DIV style=3D"FONT: 10pt arial"BSent:/B Tuesday, August 08, 2000=20 14:34/DIV DIV style=3D"FONT: 10pt arial"BSubject:/B Query Delete?/DIV DIVBR/DIV PFONT size=3D2Hi,/FONT /P PFONT size=3D2Is there a custom tag somewhere out there, = that/FONT=20 BRFONT size=3D2deletes a column fromnbsp; a query?/FONT /P PFONT size=3D2Thanks/FONT BRFONT size=3D2Kedar Desai/FONT = BRFONT=20 size=3D2Differential Technologies/FONT BRFONT size=3D2Fairfax, = VA/FONT=20 /PBR PFONT = size=3D2__/FONT=20 BRFONT size=3D2Do You Yahoo!?/FONT BRFONT size=3D2Kick off = your party=20 with Yahoo! Invites./FONT BRFONT size=3D2A=20 href=3D"http://invites.yahoo.com/"=20 target=3D_blankhttp://invites.yahoo.com//A/FONT BRFONT=20
RE: Query Delete?
why can't you handle that logic at display time? check to see to what the user has permissions, and display accordingly? Chris Olive, DOEHRS Website Administrator -Original Message- From: Planet CF [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 4:46 PM To: [EMAIL PROTECTED] Subject: RE: Query Delete? The need for a QueryDeleteColumn or QueryDeleteRow arises in situations where one wants to manipulate the query due to various reasons. One of them could something like applying security on the query. This means that the user does not priviledges to view all the rows/columns of the query (which is a join). In such a case you would want to delete data which is secure. One can say that incorporate that in the 'select' itself. However this cannot be done bcoz some users have override security priviledges, meaning that security does not apply for such users. The bottomline is that, if there is a QueryAddColumn then why not a QueryDeleteColumn and also QueryDeleteRow. Kedar Desai Differential Technologies Fairfax, VA -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: Query Delete? This is a multi-part message in MIME format. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Query Delete?You could relatively easily do it using the QueryNew() = function and looping over. But what would be the point? Just don't = selec the column in the first place. DC - Original Message -=20 From: Planet CF=20 To: [EMAIL PROTECTED]=20 Sent: Tuesday, August 08, 2000 14:34 Subject: Query Delete? Hi,=20 Is there a custom tag somewhere out there, that=20 deletes a column from a query?=20 Thanks=20 Kedar Desai=20 Differential Technologies=20 Fairfax, VA=20 __=20 Do You Yahoo!?=20 Kick off your party with Yahoo! Invites.=20 http://invites.yahoo.com/=20 = -= -=20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEQuery Delete?/TITLE META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2You could relatively easily do it using = the=20 QueryNew() function and looping over. But what would be the point?nbsp; = Just=20 don't selec the column in the first place./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2DC/FONT/DIV DIVnbsp;/DIV BLOCKQUOTE=20 style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px" DIV style=3D"FONT: 10pt arial"- Original Message - /DIV DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"BFrom:/B=20 A href=3D"mailto:[EMAIL PROTECTED]" = [EMAIL PROTECTED]Planet CF/A=20 /DIV DIV style=3D"FONT: 10pt arial"BTo:/B A=20 href=3D"mailto:[EMAIL PROTECTED]"=20 [EMAIL PROTECTED][EMAIL PROTECTED]/A /DIV DIV style=3D"FONT: 10pt arial"BSent:/B Tuesday, August 08, 2000=20 14:34/DIV DIV style=3D"FONT: 10pt arial"BSubject:/B Query Delete?/DIV DIVBR/DIV PFONT size=3D2Hi,/FONT /P PFONT size=3D2Is there a custom tag somewhere out there, = that/FONT=20 BRFONT size=3D2deletes a column fromnbsp; a query?/FONT /P PFONT size=3D2Thanks/FONT BRFONT size=3D2Kedar Desai/FONT = BRFONT=20 size=3D2Differential Technologies/FONT BRFONT size=3D2Fairfax, = VA/FONT=20 /PBR PFONT = size=3D2__/FONT=20 BRFONT size=3D2Do You Yahoo!?/FONT BRFONT size=3D2Kick off = your party=20 with Yahoo! Invites./FONT BRFONT size=3D2A=20 href=3D"http://invites.yahoo.com/"=20 target=3D_blankhttp://invites.yahoo.com//A/FONT BRFONT=20 = size=3D2= --/FONT=20 BRFONT size=3D2Archives: A=20 href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20 = target=3D_blankhttp://www.mail-archive.com/cf-talk@houseoffusion.com//A= /FONT=20 BRFONT size=3D2To Unsubscribe visit A=20 = href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp;body=3D= lists/cf_talk"=20 = target=3D_blankhttp://www
RE: Query Delete?
The need for a QueryDeleteColumn or QueryDeleteRow arises in situations where one wants to manipulate the query due to various reasons. One of them could something like applying security on the query. This means that the user does not priviledges to view all the rows/columns of the query (which is a join). In such a case you would want to delete data which is secure. One can say that incorporate that in the 'select' itself. However this cannot be done bcoz some users have override security priviledges, meaning that security does not apply for such users. The bottomline is that, if there is a QueryAddColumn then why not a QueryDeleteColumn and also QueryDeleteRow. Kedar Desai Differential Technologies Fairfax, VA -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: Query Delete? This is a multi-part message in MIME format. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Query Delete?You could relatively easily do it using the QueryNew() = function and looping over. But what would be the point? Just don't = selec the column in the first place. DC - Original Message -=20 From: Planet CF=20 To: [EMAIL PROTECTED]=20 Sent: Tuesday, August 08, 2000 14:34 Subject: Query Delete? Hi,=20 Is there a custom tag somewhere out there, that=20 deletes a column from a query?=20 Thanks=20 Kedar Desai=20 Differential Technologies=20 Fairfax, VA=20 __=20 Do You Yahoo!?=20 Kick off your party with Yahoo! Invites.=20 http://invites.yahoo.com/=20 = -= -=20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEQuery Delete?/TITLE META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2You could relatively easily do it using = the=20 QueryNew() function and looping over. But what would be the point?nbsp; = Just=20 don't selec the column in the first place./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2DC/FONT/DIV DIVnbsp;/DIV BLOCKQUOTE=20 style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px" DIV style=3D"FONT: 10pt arial"- Original Message - /DIV DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"BFrom:/B=20 A href=3D"mailto:[EMAIL PROTECTED]" = [EMAIL PROTECTED]Planet CF/A=20 /DIV DIV style=3D"FONT: 10pt arial"BTo:/B A=20 href=3D"mailto:[EMAIL PROTECTED]"=20 [EMAIL PROTECTED][EMAIL PROTECTED]/A /DIV DIV style=3D"FONT: 10pt arial"BSent:/B Tuesday, August 08, 2000=20 14:34/DIV DIV style=3D"FONT: 10pt arial"BSubject:/B Query Delete?/DIV DIVBR/DIV PFONT size=3D2Hi,/FONT /P PFONT size=3D2Is there a custom tag somewhere out there, = that/FONT=20 BRFONT size=3D2deletes a column fromnbsp; a query?/FONT /P PFONT size=3D2Thanks/FONT BRFONT size=3D2Kedar Desai/FONT = BRFONT=20 size=3D2Differential Technologies/FONT BRFONT size=3D2Fairfax, = VA/FONT=20 /PBR PFONT = size=3D2__/FONT=20 BRFONT size=3D2Do You Yahoo!?/FONT BRFONT size=3D2Kick off = your party=20 with Yahoo! Invites./FONT BRFONT size=3D2A=20 href=3D"http://invites.yahoo.com/"=20 target=3D_blankhttp://invites.yahoo.com//A/FONT BRFONT=20 = size=3D2= --/FONT=20 BRFONT size=3D2Archives: A=20 href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20 = target=3D_blankhttp://www.mail-archive.com/cf-talk@houseoffusion.com//A= /FONT=20 BRFONT size=3D2To Unsubscribe visit A=20 = href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsamp;body=3D= lists/cf_talk"=20 = target=3D_blankhttp://www.houseoffusion.com/index.cfm?sidebar=3Dlistsam= p;body=3Dlists/cf_talk/A=20 or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in=20 the body./FONT/P/BLOCKQUOTE/BODY/HTML --=_NextPart_000_0175_01C00146.6E5DE680-- -- Archives: http
Query Delete?
Hi, Is there a custom tag somewhere out there, that deletes a column from a query? Thanks Kedar Desai Differential Technologies Fairfax, VA __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.