Macromedia coldfusion 4.5-cfml language reference User Manual

114

CFML Language Reference

SELECT CommentID, EMail, FromUser, Subject, CommtType, MessText,
Posted, Processed
FROM Comments
</CFQUERY>
<HTML>
<HEAD>
<TITLE>
CFINSERT Example
</TITLE>
</HEAD>

<BODY bgcolor=silver>
<H3>CFINSERT Example</H3>

<P>First, we’ll show a list of the available comments in the
cfsnippets datasource.

<TABLE>

<TR>

<TD>From User</TD><TD>Subject</TD><TD>Comment Type</TD>

<TD>Message</TD><TD>Date Posted</TD>

</TR>

<TR>

<TD valign=top><a href="mailto:#Email#">#FromUser#</A></TD>
<TD valign=top>#Subject#</TD>
<TD valign=top>#CommtType#</TD>
<TD valign=top><FONT SIZE="-2">#Left(MessText, 125)#

</FONT></TD>

<TD valign=top>#Posted#</TD>

</TR>

</CFOUTPUT>
</TABLE>

<P>Next, we’ll offer the opportunity to enter your own comment:

<FORM ACTION="cfinsert.cfm" METHOD="POST">
<PRE>
Email:<INPUT TYPE="Text" NAME="email">
From:<INPUT TYPE="Text" NAME="fromUser">
Subject:<INPUT TYPE="Text" NAME="subject">
Message:<TEXTAREA NAME="MessText" COLS="40" ROWS="6"></TEXTAREA>
Date Posted:<CFOUTPUT>#DateFormat(Now())#</CFOUTPUT>

<INPUT TYPE="Hidden" NAME="posted" VALUE="<CFOUTPUT>#Now()#</CFOUTPUT>">
</PRE>

</BODY>
</HTML>