I'm keeping track of e-mail and phone directories for 3 different offices in
a SQL 2k database. I have my SQL queries setup to display the data but each
office has it's own e-mail and phone directory. How do I adjust this query
to display only a certain office's personnel?
Here are my queries. The below Query and Output are for the DIT office
phone directory. The other offices are OCTO, ETS and EIS.
****Phone Query ****
<CFQUERY NAME="qDITPhone" DATASOURCE="octo_employee">
SELECT office, first_name, last_name, title, phone
FROM dbo.octo_emp
</CFQUERY>
****
****Phone Output ****
<CFOUTPUT QUERY="qDITPhone">
<table align="center" border="1">
<tr>
<td>#qDITPhone.title#</td>
<td>#qDITPhone.first_name# #qDITPhone.last_name#</td>
<td>#qDITPhone.phone#</td>
</tr>
</table>
</CFOUTPUT>
How do I tell the queries to only find rows that contain a certain offices
value?
thanks,
Iain
Iain Burns
Web Development (CTO)
D.C. Public Schools
[EMAIL PROTECTED]
Tel (202)442-5664 (direct line)
-----Original Message-----
From: Novak Banda [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 11:25 AM
To: CFDJList
Subject: [cfdjlist] RE: 128 bit encryption
1024 bit encryption doesn't mean much anymore... didn't you see
"Swordfish"? ;-)
-N
----- Original Message -----
From: "A. Carcieri" <[EMAIL PROTECTED]>
To: "CFDJList" <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 5:24 AM
Subject: [cfdjlist] RE: 128 bit encryption
> Nathan,
>
> If I remember correctly, banks and the military actually use 1024 bit
> encryption. That sort of encryption is only available to those
institutions
> and I believe it was developed as a joint venture by the NSA, DOD, and the
> mapping agency that think they found the Mars Polar Lander.
>
> -----Original Message-----
> From: Nathan Jones [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 14, 2001 8:28 AM
> To: CFDJList
> Subject: [cfdjlist] 128 bit encryption
>
>
> Morning, Gang,
>
> All this talk of security made me wonder ... I know of 128-bit encryption
> protection for our sites (primarily banks), but is there something greater
> than that?
>
> I heard a reference to 156 or 164, but in research can't find any
> literature
> on it.
>
> Thanks!
>
> Nathan
>
>
> CFDJList brought to you by http://www.sys-con.com/coldfusionedge/
> To change your membership options, refer to:
> http://www.sys-con.com/coldfusion/list.cfm
> http://www.sys-con.com/coldfusion/
>
>
> CFDJList brought to you by http://www.sys-con.com/coldfusionedge/
> To change your membership options, refer to:
> http://www.sys-con.com/coldfusion/list.cfm
> http://www.sys-con.com/coldfusion/
CFDJList brought to you by http://www.sys-con.com/coldfusionedge/
To change your membership options, refer to:
http://www.sys-con.com/coldfusion/list.cfm
http://www.sys-con.com/coldfusion/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
