LiveDocs Comments - coldfusion - 7 - htmldocs - 00000266.htm

coldfusion/7/htmldocs/00000266.htm

2007-09-28T11:23:51

If you are getting expired certificate warnings, install TechNote b9c2d61c. Certificate then updated to 2010 May 20.

coldfusion/7/htmldocs/00000266.htm

Jools2 — 2007-06-07T08:35:55

When using a grid in edit mode, populating it with a query of queries breaks the ability of the posted grid to make use of the rowstatus action as per:

The array returns a 0 length

julian.simpson@bris.ac.uk

coldfusion/7/htmldocs/00000266.htm

2006-11-18T02:43:31

Should'nt the Description for the onBlur and onFocus attributes be
ActionScript that runs when the grid loses focus.
instead of
ActionScript that runs when the calendar loses focus.

coldfusion/7/htmldocs/00000266.htm

EricGyenes — 2006-06-14T13:32:19

I found a solution to the Horizontal scroll bar issue using actionscript and a trigger AFTER the grid loads.

...

name="myGridTrigger"
value=""
bind="{ (1==2) ? null : function() {
_root.myGrid.hScrollPolicy = 'on'; }.call() }"
visible="no"
height="0"
width="0" />

coldfusion/7/htmldocs/00000266.htm

maclonghorn — 2006-01-14T06:16:41

Apparently, and contrary to the docs, "rowheaders" property is applicable to a Flash form as well as an applet.

coldfusion/7/htmldocs/00000266.htm

Snake_Hollywood — 2005-09-30T05:16:57

There appears to be a bug if you try and use multiple instances of CFGRID on the same page (flash).
The columns are repeated for each instance.
I.E. If I have a cfgrid with 2 columns, and I have 6 instances of this on a page, instance 1 has 2 columns, instance 2 has 4 columns, instance 3 has 6 columns etc. And the data is always that form the first instance.

Example code:-

#component#

coldfusion/7/htmldocs/00000266.htm

jrunrandy — 2005-07-21T11:07:58

coacf,
Yes. I'm saying that CF converts the data to an array.

If you have additional questions, I suggest that you post them to the online Forum, which has heavier traffic than LiveDocs: http://webforums.macromedia.com/coldfusion

coldfusion/7/htmldocs/00000266.htm

2005-07-21T07:04:17

the cfgrid applet format does not support onChange event. I tried to submit the form on a change event and it just did not work. I think applets in form are a pain in the neural mass.

coldfusion/7/htmldocs/00000266.htm

coacf — 2005-07-20T15:24:59

not sure if that really answered my question.

so you're telling me that to simply pass the column/values of a single row i have to convert the data to an array? or is it automatically converted to an array?

i'm not updating the data i'm just using the value to pass into a query

coldfusion/7/htmldocs/00000266.htm

jrunrandy — 2005-07-20T14:00:09

Good catch. This is a problem in the docs. I ran into it a couple of months ago, but forgot to post a correction to LiveDocs.

Here is why the example doesn't work: form.[#GridName#][#ColName#] isn't really a structure. It's just a variable that happens to have periods in it. So to fix it, replace the following lines:

With the following lines:

That should do it. Of course, you also have to set the GridName variable to the name of the grid and the ColNameList variable to a list of the grid columns, as described in the cfgrid page.

coldfusion/7/htmldocs/00000266.htm

2005-07-20T09:13:22

OK I'd appreciate any help because I'm just not getting it. I'm using a cfgrid with two columns and a cfinput text field to pass values to an update page. The user selects a row (they can only select one row) from the grid then enters values in the text field. I don't understand how the cfgrid passes the values to the action page. The documentation description looks different from what I see in the debug on the action page.

here's what i get on the debug of the action page:
(I've added returns and comments)

//this is the value of the textbox;
ORG=1111

__CFGRID__BUDGETOBJECTS__FAO=__CFGRID__COLUMN__=CFGRIDROWINDEX;
__CFGRID__DATA__=11;
__CFGRID__COLUMN__=FUND;
__CFGRID__DATA__=3860;
__CFGRID__COLUMN__=AGENCY;
__CFGRID__DATA__=227;

how do I use this in my insert??

coldfusion/7/htmldocs/00000266.htm

guessed — 2005-07-18T08:12:08

The above documentation states that 'insertButton' and 'deleteButton' are only available to the applet format, however when I specify them in a flash grid they (fortunately!) appear.

I have no time to test this, but this 'bug' could also be affecting other parameters.

coldfusion/7/htmldocs/00000266.htm

yukonzach1 — 2005-07-17T20:57:03

Thank you "No screen name"!! Changing my cfform to format FLASH allowed the update to work!

coldfusion/7/htmldocs/00000266.htm

TheNewb — 2005-07-08T12:25:51

There seems to be an error in the CFGRID documentation.

The QUERY attribute is marked as being optional, and I know it definitely was in MX 6.1, however it is now required in MX7. A simple grid using this code:

Will throw the following error:

"The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.

Null Pointers are another name for undefined values."

Applying the QUERY attribute works however. Hope this helps!

coldfusion/7/htmldocs/00000266.htm

ASandstrom — 2005-07-05T12:53:00

Here is a simple code example to go to a different page based on what the user clicks in the grid:

query="getclasslist"
onchange="getURL(classlist.dataProvider[classlist.selectedIndex]['link']);"
>

coldfusion/7/htmldocs/00000266.htm

2005-06-24T11:16:48

For update to work on a flash cfgrid the entire form has to be a flash form.

coldfusion/7/htmldocs/00000266.htm

brookswift — 2005-06-13T13:55:17

I'm also having trouble figuring out how to set up a master/detail list in the flash grid. If someone knows how to do that, I'd be very appreciative.

coldfusion/7/htmldocs/00000266.htm

ccapodilupo — 2005-06-07T09:08:11

In reponse to -argolnx said on Feb 22, 2005 at 8:16 AM -

Macromedia needs to post a hotfix for
There is no way for the form to update data on the action page, I hate to gripe but this proably wasn't tested.

coldfusion/7/htmldocs/00000266.htm

2005-06-01T18:12:15

if anyone is still experiencing problems with CFGRID and wants an alternative (which is better and not better depending on your requirements) I have managed to reproduce the functionality using three templates which can be cfinclude'd.

this solution involves straight html, a tiny bit of javascript and stock standard coldfusion code (i.e. no java-based code).

It works a treat (for me) on MX6 and the calling templates are simpler than with cfgrid. Some functionality is missing but then you can code in what you like really if you change the include files.

email me on cfgrid@haroldsteptoe.mailhaven.com if you want copies and a sample.

coldfusion/7/htmldocs/00000266.htm

jrunrandy — 2005-05-25T15:13:57

shimmer, I have added enhancement request 60224 in response to your request.

FYI, the Bug Reporting link also allows you to request enhancements.

coldfusion/7/htmldocs/00000266.htm

billy nasty — 2005-05-18T00:00:56

yeah this is the code to insert or delete items from the grid manually

INSERT INTO _cards (FirmaCC, NummerCC, VervaldatumCC, CUV, ReizigerID)
VALUES ('#form.gridname.FirmaCC[i]#', '#form.gridname.Nummer[i]#', '#form.gridname.VervaldatumCC[i]#', '#form.gridname.CUV[i]#', '169')

DELETE FROM _cards
WHERE rid=#form.gridname.Original.rid[i]#

coldfusion/7/htmldocs/00000266.htm

2005-04-19T01:25:45

I got the same

A CFML variable name cannot end with a "." character.
The variable form. ends with a "." character. You must supply an additional structure key or delete the "." character.

Can anyone help? CFGRIDUPDATE is not working for me so I need to code this manually and unless I can enumerate the fields I am sunk.

coldfusion/7/htmldocs/00000266.htm

inix — 2005-04-17T10:12:27

Just realized that you can manipulated the "eanbled" state of another form element on the page on the CFGRID's onChange event.

onChange="mySubmitButton.enabled=true"...>

TYPE="submit"
name="mySubmitButton"
enabled="FALSE">
...kind of cool

coldfusion/7/htmldocs/00000266.htm

2005-04-08T16:02:56

After setting the GridName and ColNameList variables as follows:

The Grid Modification Diplay Routine Above Gives the Following Error:

A CFML variable name cannot end with a "." character.
The variable form. ends with a "." character. You must supply an additional structure key or delete the "." character.

The CFML compiler was processing:

* a cfset tag beginning on line 12, column 8.
* a cfset tag beginning on line 12, column 8.
* a cfset tag beginning on line 12, column 8.
* a cfset tag beginning on line 12, column 8.

The error occurred in C:\Program Files\Apache2\htdocs\Workload\owners.cfm: line 12

10 :
form.#GridName#.#ColName#:

11 :
12 :
13 :
14 :

coldfusion/7/htmldocs/00000266.htm

drew_falkman — 2005-04-03T16:36:07

When using INSERT in a Flash form, if the user enters multiple new rows, it only allows carries over form information for the last row entered.

coldfusion/7/htmldocs/00000266.htm

neilb98 — 2005-03-30T18:28:31

I managed to get horizontal scrollbars on a CFGRID, but I had to finagle it myself, and its still not a perfect solution. I set the form height to 200px, width680px

I had a TON of data to be displayed in the grid, so I set the width of the grid to 1400, and the height of the grid to this formula: height="#50+(queryname.recordcount * 21)#"

No, this isn't a perfect solution. But it works for me so far.

The email address and website in this login is outdated. Send any comments to neil.bailey@i-dezynes.com/website:www.i-dezynes.com

coldfusion/7/htmldocs/00000266.htm

ZeroOne — 2005-03-21T16:26:29

If you just put the datagrid inside a cfform (which you have to anyway) and give the cfform a width you will automatically get a horizontal slider if the datagrid is too wide. e.g. if the cfform is 640 wide and the cfgrid is 690 wide.

coldfusion/7/htmldocs/00000266.htm

broon — 2005-03-20T07:58:13

What is the best way to add record set paging and filtering to a flash grid? I'd like to be able to display a max number of records and then provide the user buttons to page thru the test of the record set.

coldfusion/7/htmldocs/00000266.htm

jrunrandy — 2005-03-14T14:10:36

I can think of two techniques (neither of which I've tried):
* Define the calculated field in the SELECT statement using SQL
* Use the QueryAddColumn function (http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000598.htm)

coldfusion/7/htmldocs/00000266.htm

2005-03-10T09:50:23

When using a query to populate a grid, is it possible to add additional columns that do not exist in the query (programmatically calculated fields)?