Hello,
I have beating my head against the wall for the last week
trying to figure this out...
When I ran this code on my most updated cf8 box, I do not get
the “dropdown” of values I used to get when I click on
the state column to edit.
I am going crazy and I need to have some validation that this
is a bug.
You can see it in action here….
http://www.gobluecricket.com/bluecricket/cfgrid/danvegagrid2.cfm
Do you have any idea if this is a bug in CF8? Is there any
technical help besides the support forums for developers like me
who are using CF8?
Thanks for you time.
Vince.
--------------- Grid Test
----------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1" />
<title>Grid Test</title>
</head>
<body>
<!--- <cfquery name="getArtists"
datasource="cfartgallery">
SELECT artistId, firstname, lastname, address, city, state,
postalcode, email
FROM Artists
</cfquery> --->
<cfscript>
getArtists = QueryNew("artistId, firstname, lastname,
address, city, state, email");
newRow = QueryAddRow(getArtists);
QuerySetCell(getArtists, "artistId", "1" );
QuerySetCell(getArtists, "FirstName", "Freddie" );
QuerySetCell(getArtists, "LastName", "Acker" );
QuerySetCell(getArtists, "address", "cowtown road" );
QuerySetCell(getArtists, "city", "gayton" );
QuerySetCell(getArtists, "state", "IL" );
QuerySetCell(getArtists, "email","james@acker.com" );
newRow = QueryAddRow(getArtists);
QuerySetCell(getArtists, "artistId", "2" );
QuerySetCell(getArtists, "FirstName","Angie" );
QuerySetCell(getArtists, "LastName", "Acker" );
QuerySetCell(getArtists, "address", "friendship road" );
QuerySetCell(getArtists, "city", "jamestown" );
QuerySetCell(getArtists, "state", "TX" );
QuerySetCell(getArtists, "email","angie@acker.com" );
// etc.
</cfscript>
<cfset args = structNew()>
<cfset args.name = "ArtistGrid">
<cfset args.format = "html">
<cfset args.query = "getArtists">
<cfset args.stripeRows = true>
<cfset args.selectColor = "##D9E8FB">
<cfset args.selectmode = "edit">
<cfset args.style="z-index:1000;">
<cfset args.onchange =
"cfc:artists.editArtist({cfgridaction},{cfgridrow},{cfgridchanged})">
<cfset state_abbr =
"AL,AK,AZ,AR,CA,CO,CT,DE,DC,FL,GA,HI,ID,IL,IN,IA,KS,KY,LA,ME,MD,MA,MI,MN,MS,MO,MT,NE,NV,NH,NJ,NM,NY,NC,ND,OH,OK,OR,PA,RI,SC,SD,TN,TX,UT,VT,VA,WA,WV,WI,WY">
<cfset state_name =
"Alabama,Alaska,Arizona,Arkansas,California,Colorado,Connecticut,Delaware,District
of
Columbia,Florida,Georgia,Hawaii,Idaho,Illinois,Indiana,Iowa,Kansas,Kentucky,Louisiana,Maine,Maryland,Massachusetts,Michigan,Minnesota,Mississippi,Missouri,Montana,Nebraska,Nevada,New
Hampshire,New Jersey,New Mexico,New York,North Carolina,North
Dakota,Ohio,Oklahoma,Oregon,Pennsylvania,Rhode Island,South
Carolina,South
Dakota,Tennessee,Texas,Utah,Vermont,Virginia,Washington,West
Virginia,Wisconsin,Wyoming">
<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">
<cfgridcolumn name="state" header="State" width="125"
select="yes" values="#state_abbr#" valuesdisplay="#state_name#"
valuesdelimiter=",">
</cfgrid>
</cfform>
</body>
</html>
------------------- Artists.cfc (in the same directory as
above file) ----------------------------------------------
<cfcomponent>
<cffunction name="editArtist" access="remote"
returntype="string">
<cfargument name="gridaction" type="string"
required="yes">
<cfargument name="gridrow" type="struct"
required="yes">
<cfargument name="gridchanged" type="struct"
required="yes">
<cfset myResult="foo">
<cfreturn myResult>
</cffunction>
</cfcomponent>
3
Replies
AdChoices