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/[email protected]/=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/[email protected]/"=20
> =
>
target=3D_blank>http://www.mail-archive.com/[email protected]/</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/[email protected]/
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
