Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CFGRID
- Thread starter saurabh
- Start date
The best advice I can give concerning CFGRID is... Don't use CFGRID!!
The problem with this tag is that it's a Java applet and, (as far as I'm concerned anyway) its incompatible with too many browsers.
You can make a simple html table pretty easily with a CFQUERY and CFOUTPUT that'll output in a grid format, then put an html form at the end for any inserts. Doing this will alleviate your CFGRID headaches...
A quick example...
[tt]
<!--- records.cfm --->
<CFPARAM NAME="action" DEFAULT="">
<CFIF action EQ "insert">
<CFQUERY DATASOURCE="mydb" NAME="insertrecord">
INSERT INTO Employees (FirstName,LastName)
VALUES ('#FirstName#','#LastName#')
</CFIF>
<CFQUERY DATASOURCE="mydb" NAME="TheRecords">
select ID,FirstName,LastName from Employees
order by LastName
</CFQUERY>
<HTML><HEAD><TITLE>Grid Example</TITLE></HEAD>
<BODY>
<TABLE>
<CFOUTPUT QUERY="TheRecords">
<TR>
<TD>#ID#</TD>
<TD>#FirstName#</TD>
<TD>#LastName#</TD>
</TR>
</CFOUTPUT>
</TABLE>
<FORM ACTION="records.cfm" method="post">
<INPUT TYPE="hidden" NAME="action" VALUE="insert">
First Name: <INPUT TYPE="text" NAME="FirstName"><br>
Last Name: <INPUT TYPE="text" NAME="LastName"><br>
<INPUT TYPE="submit" VALUE="SUBMIT">
</FORM>
</BODY>
</HTML>
[/tt]
You could put the output fields in form fields and put update and delete buttons in each row as well to allow more functionality.
Hope this helps,
DM
The problem with this tag is that it's a Java applet and, (as far as I'm concerned anyway) its incompatible with too many browsers.
You can make a simple html table pretty easily with a CFQUERY and CFOUTPUT that'll output in a grid format, then put an html form at the end for any inserts. Doing this will alleviate your CFGRID headaches...
A quick example...
[tt]
<!--- records.cfm --->
<CFPARAM NAME="action" DEFAULT="">
<CFIF action EQ "insert">
<CFQUERY DATASOURCE="mydb" NAME="insertrecord">
INSERT INTO Employees (FirstName,LastName)
VALUES ('#FirstName#','#LastName#')
</CFIF>
<CFQUERY DATASOURCE="mydb" NAME="TheRecords">
select ID,FirstName,LastName from Employees
order by LastName
</CFQUERY>
<HTML><HEAD><TITLE>Grid Example</TITLE></HEAD>
<BODY>
<TABLE>
<CFOUTPUT QUERY="TheRecords">
<TR>
<TD>#ID#</TD>
<TD>#FirstName#</TD>
<TD>#LastName#</TD>
</TR>
</CFOUTPUT>
</TABLE>
<FORM ACTION="records.cfm" method="post">
<INPUT TYPE="hidden" NAME="action" VALUE="insert">
First Name: <INPUT TYPE="text" NAME="FirstName"><br>
Last Name: <INPUT TYPE="text" NAME="LastName"><br>
<INPUT TYPE="submit" VALUE="SUBMIT">
</FORM>
</BODY>
</HTML>
[/tt]
You could put the output fields in form fields and put update and delete buttons in each row as well to allow more functionality.
Hope this helps,
DM
- Status