roropacific
IS-IT--Management
the search.cfm appears to be not working. My browser just refreshes.
Here is my action file "search.cfm"
<CFPARAM NAME=DATASRC DEFAULT=custsrvc>
<cfoutput>#form.searchvar# </cfoutput>
<CFQUERY NAME=GETITEMS DATASOURCE=#DATASRC#>
SELECT * FROM complaint where product_id like '#form.searchvar#%'
</CFQUERY>
<CFOUTPUT>
<TABLE BORDER=1 CELLPADDING=1 CELLSPACING=1 ALIGN=CENTER bgcolor="cccccc" >
<TR>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Agent
</FONT>
</td>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Product ID
</FONT>
</TD>
<TD ALIGN=CENTER>
<font COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Issue Summary
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Issue Description
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Current Date
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Location of Purchase
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Date of Purchase
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Tracking Number
</FONT>
</TD>
</TR>
<CFLOOP QUERY=GETITEMS>
<TR>
<TD>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.username#
</FONT>
</A>
</TD>
<td>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.product_id#
</FONT>
</A>
</td>
<td>
<font COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.issue_summary#
</FONT>
</TD>
<TD>
<FONT COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.issue_description#
</FONT>
</TD>
<TD>
<font COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.currentdate#
</FONT>
</TD>
<TD>
<FONT COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.locationofpurchase#
</FONT>
</TD>
<TD>
<FONT COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.dateofpurchase#
</FONT>
</TD>
<TD>
<FONT COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.issueid#
</FONT>
</TD>
</TR>
</CFLOOP>
</TABLE>
</CFOUTPUT>
Here is my action file "search.cfm"
<CFPARAM NAME=DATASRC DEFAULT=custsrvc>
<cfoutput>#form.searchvar# </cfoutput>
<CFQUERY NAME=GETITEMS DATASOURCE=#DATASRC#>
SELECT * FROM complaint where product_id like '#form.searchvar#%'
</CFQUERY>
<CFOUTPUT>
<TABLE BORDER=1 CELLPADDING=1 CELLSPACING=1 ALIGN=CENTER bgcolor="cccccc" >
<TR>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Agent
</FONT>
</td>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Product ID
</FONT>
</TD>
<TD ALIGN=CENTER>
<font COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Issue Summary
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Issue Description
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Current Date
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Location of Purchase
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Date of Purchase
</FONT>
</TD>
<TD ALIGN=CENTER>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
Tracking Number
</FONT>
</TD>
</TR>
<CFLOOP QUERY=GETITEMS>
<TR>
<TD>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.username#
</FONT>
</A>
</TD>
<td>
<FONT COLOR=FFFFFF STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.product_id#
</FONT>
</A>
</td>
<td>
<font COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.issue_summary#
</FONT>
</TD>
<TD>
<FONT COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.issue_description#
</FONT>
</TD>
<TD>
<font COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.currentdate#
</FONT>
</TD>
<TD>
<FONT COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.locationofpurchase#
</FONT>
</TD>
<TD>
<FONT COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.dateofpurchase#
</FONT>
</TD>
<TD>
<FONT COLOR=000000 STYLE="font-size: 12px" FACE="Arial">
#GETITEMS.issueid#
</FONT>
</TD>
</TR>
</CFLOOP>
</TABLE>
</CFOUTPUT>