CFGRID not displaying data
3 Message(s) by 2 Author(s) originally posted in flash and cfml
| From: CF_Hack |
Date: Friday, June 22, 2007
|
I'm using CFGRID to
display a
query of queries. CFGRID as
type applet displays
everything perfectly. as flash only two columns display. Also I can't change
the format of the number in flash while I can in applet. The mask
attribute
does not seem to work. Code below of a smaller grid that does not work either.
query
<CFQUERY DBTYPE="query" NAME="all_oil">
SELECT get_total_oil.yyyy, get_total_oil.ievalue as total,
get_crd_prod.ievalue as crude
FROM get_total_oil,get_crd_prod
where get_total_oil.yyyy=get_crd_prod.yyyy
order by YYYY
</CFQUERY>
<CFQUERY DBTYPE="query" NAME="all_oil2">
SELECT all_oil.yyyy, all_oil.total,all_oil.crude , get_conc.ievalue as conc
FROM get_conc, all_oil
where all_oil.yyyy=get_conc.yyyy
order by YYYY desc
</CFQUERY>
<CFFORM format="flash">
<CFGRID format="flash" query="all_oil" name="test" >
<CFGRIDCOLUMN name="yyyy" header="Year" width="40">
<CFGRIDCOLUMN name="total" header="Total Oil Production">
<CFGRIDCOLUMN name="crude" header="Crude Production" >
</CFGRID>
</CFGRID>
| From: Chuck1411 |
Date: Tuesday, June 26, 2007
|
Reason this one does not work is because you've two </CFGRID> closing tags.
You also do not need to define the grid as format flash if the form is format
flash.
According to the docs, mask only works with Flash, not applet, wonder if that
is a typo. Pg 200 of Reference Vol 1.
And if you want the grid to use the QoQ all_oil2, you should specify that name
in the <CFGRID query tag.>
| From: CF_Hack |
Date: Tuesday, June 26, 2007
|
[q][i]Originally posted by: [b][b]Chuck1411[/b][/b][/i]
Reason this one does not work is because you've two
</CFGRID> closing tags.
Typo. My
code has a closing
</CFFORM> tag
You also do not need to define the grid as format flash if the form is format
flash.
This does not matter since it does not work either way.
According to the docs, mask only works with Flash, not applet, wonder if that
is a typo. Pg 200 of Reference Vol 1.
That is correct. Does not matter still no
data either way.
And if you want the grid to use the QoQ all_oil2, you should specify that name
in the
<CFGRID query tag.>
Either way it does not work
Next Message: Flash forms not working
Blogs related to CFGRID not displaying data
CFGrid Issue sort of resolved
SO now when I click Save, the database is updated but the grid columns being displayed are
not refreshing. What do I need to do so that the
data is refreshed in the
display? Thanks, -- Bruce Sorge "I'ma mawg: half man, half dog.
...
Updating the database from CFGRID
Simple, by reducing the amount of steps it takes to add, edit, and manipulate
data without giving a mess of confusion in one page. This is
not so simple when it comes to
CFGRID. There are a million examples of how to edit
data within
...
Re: CFGrid data not showing
On 2/9/07, Michael Beins wrote: > I have never used
cfgrid before, and I have followed the
coldfusion mx 7 documentation examples, and I have read through some articles on the macromedias developer community on using
cfgrid but I am
...
CFGRID & CFGRIDUPDATE - updating an array value before using ...
In the
CFGRID, I am
displaying fname, lname, and email as columns, and ownerid is in a column that is
not displayed. The problem arises when I go to add a new record to the
CFGRID, because there is no value for ownerid.
...
Re: CFGrid data not showing
A grid is generated but there is no
data in it. It has colomun names and few empty rows. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe
ColdFusion MX7 Experience Flex 2 & MX7 integration & create
...