Doubt with insert in the CFGRID
guys,
i need of us. have cfgrid , doubt is, how insert new records in database using cfgrid?
where put insert in code? need use cfc or using cfm 's fine?
folow code.
the function onadd dont show button.
where problem guys?
[ ]'s
fabiano magno pechibella
<!--- need proxy add/delete calls cfc--->
<cfajaxproxy cfc="data" jsclassname="dataproxy">
<html>
<head>
<script type="text/javascript" src="/cfide/scripts/ajax/ext/source/widgets/toolbar.js"></script>
<script type="text/javascript">
// create new js proxy object cfc
var dataproxy = new dataproxy();
dataproxy.setcallbackhandler(handleresult);
function handleresult(response)
{
alert(response);
}
// add 2 custom buttons toolbar
function init(){
grid = coldfusion.grid.getgridobject("artistgrid");
var gridhead = grid.getview().getheaderpanel(true);
var tbar = new ext.toolbar(gridhead);
tbar.addbutton({text:"add artist", handler:onadd });
tbar.addseparator();
tbar.addbutton({ text:"delete artist", handler:ondelete });
}
function onadd(button,event){
coldfusion.window.show('addartistwin');
}
function ondelete(){
coldfusion.window.show('deleteartistwin');
}
function addartist()
{
//send data cfc add artist, result handled handleresult function above
var f = document.frmartist;
dataproxy.addnewartist(
f.txtfirstname.value
,f.txtlastname.value
,f.txtemail.value
,f.txtaddress.value
,f.txtcity.value
,f.txtstate.value
,f.txtpostalcode.value
);
coldfusion.window.hide('addartistwin');
grid.refresh();
}
function deleteartist(s)
{
// if user choose delete, send cfc call, otherwise sit back!
if (s == 'yes')
{
var grid = coldfusion.grid.getgridobject("artistgrid");
var record = grid.getselections();
// remember, cf makes column names uppercase, dont forget that
dataproxy.deleteartist(record[0].data.artistid);
}
coldfusion.window.hide('deleteartistwin');
grid.refresh();
}
</script>
</head>
<cfset args = structnew()>
<cfset args.name = "artistgrid">
<cfset args.format = "html">
<cfset args.bindonload = "true">
<cfset args.bind = "cfc:data.getartists({cfgridpage},{cfgridpagesize},
{cfgridsortcolumn},{cfgridsortdirection})">
<cfset args.striperows = true>
<cfset args.selectcolor = "##d9e8fb">
<cfset args.selectmode = "edit">
<cfset args.onchange = "cfc:data.editartist({cfgridaction},{cfgridrow},{cfgridchanged})">
<cfform>
<cfgrid attributecollection="#args#">
<cfgridcolumn name="artistid" display="false">
<cfgridcolumn name="firstname" header="first name">
<cfgridcolumn name="lastname" header="last name">
<cfgridcolumn name="email" header="email address">
<cfgridcolumn name="address" header="address">
<cfgridcolumn name="city" header="city" display="false">
<cfgridcolumn name="state" header="state" display="false">
<cfgridcolumn name="postalcode" header="zip" display="false">
</cfgrid>
</cfform>
<cfwindow width="150" height="150" name="deleteartistwin" modal="true" resizable="false" title="delete artist?"
bodystyle="font-family: verdana; color: ##000000;font-size:15px;font-weight:bold;"
headerstyle="font-family: verdana; background-color: black; color: white">
<div style="margin-left:5px;margin-top:5px;">
please confirm action.
<input type="button" value="yes, surely!" onclick="deleteartist('yes')">
<input type="button" value="no, please! " onclick="deleteartist('no')">
<br/>
</cfwindow>
<cfwindow name="addartistwin" modal="true" resizable="false" title="add new artist" bodystyle="font-size:10px;font-family: verdana; color: ##ff0000;"
headerstyle="font-family: verdana; background-color: black; color: white">
<form name="frmartist" style="font-size:10px;">
<table width="100%">
<tr>
<td>firstname</td>
<td><input type="text" name="txtfirstname" value="dummy"></td>
</tr>
<tr>
<td>lastname</td>
<td><input type="text" name="txtlastname" value="dummy"></td>
</tr>
<tr>
<td>email</td>
<td><input type="text" name="txtemail" value="dummy"></td>
</tr>
<tr>
<td>address</td>
<td><input type="text" name="txtaddress" value="dummy"></td>
</tr>
<tr>
<td>city</td>
<td><input type="text" name="txtcity" value="ca"></td>
</tr>
<tr>
<td>state</td>
<td><input type="text" name="txtstate" value="ny"></td>
</tr>
<tr>
<td>postalcode</td>
<td><input type="text" name="txtpostalcode" value="dummy"></td>
</tr>
<tr>
<td colspan="2"><input type="button" value="add artist" onclick="javascript:addartist();"></td>
</tr>
</form>
</cfwindow>
<cfset ajaxonload("init")>
</html>
More discussions in ColdFusion
adobe
Comments
Post a Comment