Application login

Jamie Symonds Tue, 04 Jul 2000 10:20:08 -0700
This is a multi-part message in MIME format.
--------------F44B5655F3D55230F0AB6774
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
Hi Folks - In the organzation where I've created an application, we have
employees that have been submitting their info to a database.&nbsp; We
also have an officer that want to see a quick list of all records in the
db, and drill-down to see further info.&nbsp; Here's a piece of my code
(my apologies for such a long message):
<BR>-----------------------------------------------------------------------------------
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;CFQUERY DATASOURCE="Academic
Funding &amp; Research" NAME="Faculty"></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;SELECT name, username,
department</FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;FROM Faculty</FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;ORDER BY name</FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;/CFQUERY></FONT></FONT><FONT 
FACE="Courier New,Courier"><FONT SIZE=-1></FONT></FONT>
<P><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;HTML></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;HEAD></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;TITLE>Faculty
List&lt;/TITLE></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;/HEAD></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;BODY></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;font face="Arial,
Helvetica"></FONT></FONT><FONT FACE="Courier New,Courier"><FONT SIZE=-1></FONT></FONT>
<P><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;H2>Current Database
Listing of Faculty&lt;/H2></FONT></FONT><FONT FACE="Courier New,Courier"><FONT 
SIZE=-1></FONT></FONT>
<P><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;TABLE CELLPADDING=10
BORDER=1></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;CFOUTPUT 
QUERY="Faculty"></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;TR></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;TD>&lt;font
face="Arial, Helvetica"></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT 
SIZE=-1>&nbsp;&lt;B>#name#&lt;/B>&lt;BR></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;A HREF="<A 
HREF="mailto:#username#@stfx.ca">mailto:#username#@stfx.ca</A>">#username#@stfx.ca&lt;/a>&lt;BR></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;Department of
#department#&lt;/FONT></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;/TD></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;TD>&lt;font
face="Arial, Helvetica">&lt;A 
HREF="ViewFacultyInfo.cfm?username=#username#">VIEW&lt;/a>&lt;/FONT>&lt;/td></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;TD>&lt;font
face="Arial, Helvetica">&lt;A 
HREF="UpdateFacultyInfo.cfm?username=#username#">UPDATE&lt;/a>&lt;/FONT>&lt;/td></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;TD>&lt;font
face="Arial, Helvetica">&lt;A 
HREF="DeleteFacultyInfo.cfm?username=#username#">DELETE&lt;/a>&lt;/FONT>&lt;/td></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;/TR></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&nbsp;&lt;/CFOUTPUT></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;/TABLE></FONT></FONT><FONT 
FACE="Courier New,Courier"><FONT SIZE=-1></FONT></FONT>
<P><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;/BODY></FONT></FONT>
<BR><FONT FACE="Courier New,Courier"><FONT SIZE=-1>&lt;/HTML></FONT></FONT>
<BR>-----------------------------------------------------------------------------------
<P>My Question:&nbsp; The data submitted by members of the organization
is quite confidential; and while the "officer" must be able to review every
record, nobody else should be able to.&nbsp; How do I enable some type
of "administrator login" for this application?&nbsp; I DO have a table
in my database, "Admin", with fields "adminuser" and "adminpass" - could
I work with this?
<P>Thanks.
<BR>Jamie
<BR>&nbsp;
<BR>&nbsp;</HTML>

--------------F44B5655F3D55230F0AB6774
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Symonds, Jamie
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Jamie Symonds
n:              Symonds;Jamie
adr:            Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada
email;internet: [EMAIL PROTECTED]
title:          Bachelor of Information Systems, Major (student)
x-mozilla-cpt:  ;0
x-mozilla-html: TRUE
version:        2.1
end:            vcard


--------------F44B5655F3D55230F0AB6774--

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
Application login

Reply via email to
