Need some help w/ CF

Richard Ramos Thu, 13 Apr 2000 17:32:03 -0700
This is a multi-part message in MIME format.

------=_NextPart_000_0021_01BFA554.5DDC0740
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm making a page that will let users view info about programs we use.  =
The page has a list of four major groups and an others group.  The =
others group is a drop down list.  I want to display the name of =
programs in this list, but the page I am accessing uses the ID # of the =
program.  Here's the code below.  Maybe someone can help. =20

Thanks in advance for your help.

Richard

from body2.cfm:

  <H3><FONT STYLE=3D"TEXT-DECORATION: underline">Other =
Programs</FONT></H3>
  =20
   <CFFORM ACTION=3D"view.cfm">
    <SELECT NAME=3D"Name">=20
     <CFOUTPUT QUERY=3D"Programs">
      <CFIF Group IS "Other Programs">
       <OPTION VALUE=3D"#ID#">#Name#
      </CFIF>
     </CFOUTPUT>
    </SELECT>
    <INPUT TYPE=3D"submit" VALUE=3D"View">
   </CFFORM>
 </TD>
</TR>
</table>
=20

view.cfm:

<CFQUERY DATASOURCE=3D"intranet" NAME=3D"Programs">
 SELECT ID, Name, Version, Notes, Group
 FROM Programs
 WHERE ID LIKE '#ID#'
</CFQUERY>

<HTML>

<HEAD>
 <TITLE>Program Info</TITLE>
</HEAD>

<BODY BGCOLOR=3D"#B3BAFB" TEXT=3D"Navy">

<CFOUTPUT QUERY=3D"Programs">

 <H3>#Group#</H3>

 Program name: <B>#Name#</B>
 <BR>
 Latest Version: <B>#Version#</B>
 <BR>
 Notes: #Notes#
</CFOUTPUT>

<P>

<FORM ACTION=3D"proau1.cfm" METHOD=3D"POST">
 <CFOUTPUT QUERY=3D"Programs">
  <INPUT TYPE=3D"hidden" NAME=3D"ID" VALUE=3D"#ID#">
 </CFOUTPUT>
 <INPUT TYPE=3D"submit" VALUE=3D"Update">
</FORM>

</BODY>

</HTML>

------=_NextPart_000_0021_01BFA554.5DDC0740
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I'm making a page that will let users =
view info=20
about programs we use.&nbsp; The page has a list of four major groups =
and an=20
others group.&nbsp; The others group is a drop down list.&nbsp; I want =
to=20
display the name of programs in this list, but the page I am accessing =
uses the=20
ID # of the program.&nbsp; Here's the code below.&nbsp; Maybe someone =
can=20
help.&nbsp; </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance for your =
help.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Richard</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>from body2.cfm:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp; &lt;H3&gt;&lt;FONT =
STYLE=3D"TEXT-DECORATION:=20
underline"&gt;Other Programs&lt;/FONT&gt;&lt;/H3&gt;<BR>&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp; &lt;CFFORM =
ACTION=3D"view.cfm"&gt;<BR>&nbsp;&nbsp;&nbsp;=20
&lt;SELECT NAME=3D"Name"&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp; &lt;CFOUTPUT=20
QUERY=3D"Programs"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;CFIF Group =
IS "Other=20
Programs"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;OPTION=20
VALUE=3D"#ID#"&gt;#Name#<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;/CFIF&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;/CFOUTPUT&gt;<BR>&nbsp;&nbsp;&nbsp; =
&lt;/SELECT&gt;<BR>&nbsp;&nbsp;&nbsp;=20
&lt;INPUT TYPE=3D"submit" VALUE=3D"View"&gt;<BR>&nbsp;&nbsp;=20
&lt;/CFFORM&gt;<BR>&nbsp;&lt;/TD&gt;<BR>&lt;/TR&gt;<BR>&lt;/table&gt;</FO=
NT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>view.cfm:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;CFQUERY DATASOURCE=3D"intranet"=20
NAME=3D"Programs"&gt;<BR>&nbsp;SELECT ID, Name, Version, Notes,=20
Group<BR>&nbsp;FROM Programs<BR>&nbsp;WHERE ID LIKE=20
'#ID#'<BR>&lt;/CFQUERY&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;HTML&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2>&lt;HEAD&gt;<BR>&nbsp;&lt;TITLE&gt;Program=20
Info&lt;/TITLE&gt;<BR>&lt;/HEAD&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;BODY BGCOLOR=3D"#B3BAFB"=20
TEXT=3D"Navy"&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;CFOUTPUT =
QUERY=3D"Programs"&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2>&nbsp;&lt;H3&gt;#Group#&lt;/H3&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;Program name:=20
&lt;B&gt;#Name#&lt;/B&gt;<BR>&nbsp;&lt;BR&gt;<BR>&nbsp;Latest Version:=20
&lt;B&gt;#Version#&lt;/B&gt;<BR>&nbsp;&lt;BR&gt;<BR>&nbsp;Notes:=20
#Notes#<BR>&lt;/CFOUTPUT&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;P&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;FORM ACTION=3D"proau1.cfm"=20
METHOD=3D"POST"&gt;<BR>&nbsp;&lt;CFOUTPUT =
QUERY=3D"Programs"&gt;<BR>&nbsp; &lt;INPUT=20
TYPE=3D"hidden" NAME=3D"ID"=20
VALUE=3D"#ID#"&gt;<BR>&nbsp;&lt;/CFOUTPUT&gt;<BR>&nbsp;&lt;INPUT =
TYPE=3D"submit"=20
VALUE=3D"Update"&gt;<BR>&lt;/FORM&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;/BODY&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2>&lt;/HTML&gt;</FONT></DIV></BODY></HTML>

------=_NextPart_000_0021_01BFA554.5DDC0740--


------------------------------------------------------------------------------
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.
Need some help w/ CF

Reply via email to
