asked on

COldFusion form submit

I am building the report in coldfusion using table. And i have i column called completion which is the checkbox field. Actually this cell is the form itself. What I need to do is to setup the way so when somebody click on that cell it will update the database without refreshing the report itself

Please help

<td valign="top" align="center">
							<form name="frm" method="post" action="" id="frm">
								<input type="checkbox" name="chk#Employeeid#" value="#getCapstone.isAccept#" onClick="javascript:chkSubmit ();" <cfif getCapstone.isAccept eq 1>checked</cfif>>
							</form>
							<cfif isDefined("form.chk")>
				
								<cfquery name="qryUpdate" datasource="cfelsunrise">
									Update EDITCapstone set isAccept = <cfif getCapstone.isAccept eq 1><cfqueryparam cfsqltype="cf_sql_integer" value="0"><cfelse><cfqueryparam cfsqltype="cf_sql_integer" value="1"></cfif> where EmpID = #EmployeeID#
								</cfquery>
							</cfif>
						</td>

Open in new window

ASKER CERTIFIED SOLUTION

SRIKANTH MADISHETTI

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SRIKANTH MADISHETTI

i am just confued with the query u have but the thing when u submit your form using coldfusion.ajax.submitform it will submit with our page refresh to the mentioned cfc or page.

erikTsomik

ASKER

all i want to refresh is that particular column of the report

erikTsomik

ASKER

when I execute the code i get an error
ColdFusion is Undefined. Is there something that i need to import first

SRIKANTH MADISHETTI

you have coldfusion 8 right

SRIKANTH MADISHETTI

coldfusion 8 and and when u instal coldfusion 8 u will get this folders

C:\Inetpub\wwwroot\CFIDE\scripts\ajax

erikTsomik

ASKER

I can not Update the mapping to this path . Is there other way to import this library

SRIKANTH MADISHETTI

u have cfide mapped in your iis

erikTsomik

ASKER

yes . It mapped to /cfide

SRIKANTH MADISHETTI

if coldfusion 8 in your root folder u should have CFIDE\scripts\ajax folder with js files

erikTsomik

ASKER

OK . I lnkied to this folder now i get error saying that cfmessage is undefined