| Posted By |
Discussion Topic: cfgrid issues
|
|
MIGhunter |
06-08-2012 @ 5:33 AM |
|
|
Senior Member
Posts: 568
Joined: Apr 2006
|
I'm hoping that someone uses cfgrids to make some
tables. I'm not very good at javascripts or jquery so
I am using cfgrid to make a table. I'm having a few
issues.
1. This is my biggest issue. I need 1 of the columns
(the primary key) to be uneditable or deletable. I
need it to always be displayed in the table.
Basically, the primary key acts as rooms. Like rooms
in a hotel. They do not change and they always need
displayed. Right now they are in the same table as the
info on who is in the room, etc. Should I just make a
2nd table and link them?
2. I'm using an editable table but I want some of the
fields to not be editable. When I change those fields
to <cfgridcolumn select = "no"> I get an SQL integer
type error. When I take the select = "no" out, the
error goes away. Why would that be.
3. Finally, I'm using a mask for the date and it
doesn't display the hour and the minutes correctly. If
I use G:i a It will just say 00:00 am even though my
database will say 0500.
|
|
Webmaster |
|
06-09-2012 @ 11:44 PM |
|
|
Administrator
Posts: 4533
Joined: Jan 2002
|
I am not a big fan of cfgrid... havent used it in years... however on the
primary key question, you can show it.. just make sure that you don't
have this on the field:
selectmode="edit"
By not having that.. it will NOT allow editing of that column.
I think you should really look into newer methods of doing this.. you
might want to check out this tutorial:
http://www.coldfusion-ria.com/Blog/index.cfm/2009/1/27/Using-jQuery-based-jqGrid-with-ColdFusion-Part-1
Pablo Varando 
Senior Application Architect
EasyCFM.COM, LLC.
904.483.1457 \\ mobile
webmaster@easycfm.com \\email
\m/ (>.<) \m/
--- rock on ---
This message was edited by Webmaster on 6-9-12 @ 11:44 PM
|
|
MIGhunter |
|
06-10-2012 @ 5:11 PM |
|
|
Senior Member
Posts: 568
Joined: Apr 2006
|
Main reason I'm using cfgrid is I wanted to make it so
the rows were editable. I'm just writing a little
program for the ER that I work in. It's only for when
our main multi-million dollar piece of crap system goes
down so that we can track patients and their room
assignments, etc. So, in order to do this, I need the
staff to be able to change things and I didn't want
them to have to go through a separate page since the ER
is super busy (less steps are good).
Also, I had planned on a separate thread later but how
do you do the separate post method? I'm going to need
the ability to refresh the page without resubmitting
data.
|
|
MIGhunter |
|
06-14-2012 @ 10:39 PM |
|
|
Senior Member
Posts: 568
Joined: Apr 2006
|
I looked at that tutorial and it's not very involved in
the explanation. I can't seem to get it to work and my
javascript skill suck.
|
