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=3Dlists&body=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">
<HTML><HEAD><TITLE>Query 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#ffffff>
<DIV><FONT face=3DArial size=3D2>You could relatively easily do it using =
the=20
QueryNew() function and looping over. But what would be the point? =
Just=20
don't selec the column in the first place.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>DC</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 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"><B>From:</B>=20
<A href=3D"mailto:[EMAIL PROTECTED]" =
[EMAIL PROTECTED]>Planet CF</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:[EMAIL PROTECTED]"=20
[EMAIL PROTECTED]>[EMAIL PROTECTED]</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, August 08, 2000=20
14:34</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Query Delete?</DIV>
<DIV><BR></DIV>
<P><FONT size=3D2>Hi,</FONT> </P>
<P><FONT size=3D2>Is there a custom tag somewhere out there, =
that</FONT>=20
<BR><FONT size=3D2>deletes a column from a query?</FONT> </P>
<P><FONT size=3D2>Thanks</FONT> <BR><FONT size=3D2>Kedar Desai</FONT> =
<BR><FONT=20
size=3D2>Differential Technologies</FONT> <BR><FONT size=3D2>Fairfax, =
VA</FONT>=20
</P><BR>
<P><FONT =
size=3D2>__________________________________________________</FONT>=20
<BR><FONT size=3D2>Do You Yahoo!?</FONT> <BR><FONT size=3D2>Kick off =
your party=20
with Yahoo! Invites.</FONT> <BR><FONT size=3D2><A=20
href=3D"http://invites.yahoo.com/"=20
target=3D_blank>http://invites.yahoo.com/</A></FONT> <BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
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://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
