Stack Overflow
Stack Overflow

Questions tagged [cfgrid]

is a tag in ColdFusion is used to create data grids: two dimensional spreadsheet-type view. cfgrid supports simple and Ajax use.

66 questions
4
votes
2 answers

Why is my cfgrid showing extra space to the right?

I have a cfgrid with 5 columns. The funny thing is, it's showing a sort of extra column to the right, but without any of the formatting that applies to the rest of the grid. I can't seem to get rid of it by playing with the width of the grid or the…
froadie
  • 79,995
  • 75
  • 166
  • 235
4
votes
1 answer

cfgrid not working after upgrade from Coldfusion 11 to Coldfusion 2018

After upgrading from CF11 to CF2018, Update 3, none of my editable cfgrids are working. When I make an edit and then submit the form, the columns seem to get jumbled. I created the simplest cfgrid I could (below) but am still getting the same…
whywontitwork
  • 43
  • 6
4
votes
1 answer

JavaScript errors using tag with ColdFusion 2018

With ColdFusion 2018 using the with the format set to "html".
Hedge7707
  • 557
  • 1
  • 5
  • 17
4
votes
1 answer

CFGRID bind in HTML format does not work in Coldfusion 11

OK, so I've spent the last couple of days researching this issue on various websites including this one and I'm still no closer to having an answer. I have seen claims that this was a bug and was fixed on Adobe's end in one of the CF11 patches and…
William
  • 41
  • 3
4
votes
2 answers

Can I replace the cfgridkey with my own custom variable name? Or else build my own href?

I have a simple cfgrid that's displaying my ids. I want the id to be a link to a new page, passing a url parameter of "myID" with the id value. I've tried this code:
froadie
  • 79,995
  • 75
  • 166
  • 235
3
votes
2 answers

cfgrid boolean column as Yes/No

I have a boolean type column in an html cfgrid. The data is stored in the database as 1/0 and is returned from CF as such. I want the user to see Yes/No instead of 1/0. I tried QuerySetCell, and couldn't get it to work. The form is editable,…
Gene R
  • 1,555
  • 5
  • 19
  • 32
3
votes
2 answers

How to create Master/Detail view with two datagrids in ColdFusion

In Coldfusion, I have Master and Detail data that I need to display in two separate cfgrids; like the typical Customers/Orders scenario. My cfgrids are bound to cfc functions which populate the cfgrids. In my current dataset, only one Customer…
Maklar
  • 31
  • 1
3
votes
2 answers

Coldfusion: Simple cfgridupdate validation

I trying to use a very simple CFGRID (with CFGRIDUPDATE) but not allow NULLS.
nope_four
  • 492
  • 1
  • 4
  • 16
2
votes
1 answer

CFGRID with CF 9.0.1

I have a CFgrid that was working fine in CF 9.0, but now we have upgraded to 9.0.1, nothing comes up form (form.#GridName#.#Column1Name#) after the form is submitted. I made up some test code (below) which i have tried on a 9.0.1 server, which comes…
Simon
  • 21
  • 1
2
votes
2 answers

getting error information on cfgrid - cfdebug

I'm using CF9 When editing a field which updates information on a db in a cfgrid, I get this error: "Error invoking CFC /assetMgmt/assetdata.cfc : Error Executing Database Query. [Enable debugging by adding 'cfdebug' to your URL parameters to see…
Barrett Chamberlain
  • 119
  • 1
  • 2
  • 16
1
vote
2 answers

CFGRID, CFGRIDUPDATE and extra values

I'm using CFGRID and CFGRIDUPDATE to insert values into a database. The problem is, each record needs to get an additional field that isn't in the grid. Is there any way to save that additional field to the record, or do I have to whip up an…
Jordan Reiter
  • 20,467
  • 11
  • 95
  • 161
1
vote
0 answers

cfgrid displays values instead of valuelist on edit

I have a cfgrid in CF 8 that contains a list of names in dropdown boxes using valuelists to hold the data. The values are employee keys as that is what I need to save on update and the valuesdisplayed holds the employee name. Everything works as…
starfire
  • 13
  • 4
1
vote
1 answer

Decimal numbers in a HTML cfgridcolumn

For some reason all my cfgrids drop the ending 0 of dollar amounts. So 104.50 is coming up as 104.5 and 332.80 is coming up as 332.8 It displays the last digit if it is not a 0. So 345.43 is fine. I have tried using the currency type but that only…
Sequenzia
  • 2,333
  • 9
  • 40
  • 59
1
vote
2 answers

Cfgrid cell contain hyperlink?

Using CF9 and have a pretty basic html cfgrid that returns results from a SQL query. There are just two columns in the grid: "ID" and "IDType". I'm looking to see if there's a way to implement some logic so that when I certain IDType shows up, the…
stuttsdc
  • 101
  • 1
  • 4
  • 18
1
vote
2 answers

ColdFusion 9 ORM CFGird connecting several tables

When using ColdFusion ORM where you have several tables with relationships can I bind a CFC to a CFGrid to get all of the columns I would like to have displayed? Example if I have a query with 7 joins on the current application I am working on to…
Nathan Stanford
  • 1,336
  • 3
  • 23
  • 37
1
2 3 4 5