OK,
that worked,(not specifying a query), one more small one and I think I will have
this puppy. The field in the database is a date field. The data that
got entered was a time 12:00:43 am. The seconds change slightly depending
on what goes in. Is there a way I can do a dateformat in cfgrid. I
think Access is intrepreting the / as a divide. Or maybe I need to do it
in the action page?
-----Original Message-----
From: Dave Cahall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 5:23 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnYou could also just set up a query that never returns anything. However, if you alwas want the grid to come up empty, you do not have to specify a query at all.Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 4:20 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnNo problem. Perhaps you can help me with a simpler problem with cfgrid (I hope simpler). I want the cfgrid on the form page to always come up empty. But it won't do that with the query I have set up. The query I am using is the same one I am putting data in. Do I need to set up a dummy table that never has data in it and use it in my query?-----Original Message-----
From: Dave Cahall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 5:10 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnGood work - that will do it. The real killer was the CFGRIGUPDATE just does not give you any flexibility. Sorry for not being complete with my last post but indirectly, that is exactly what I was suggesting you were going to have to do. Please excuse me for not being more thorough.Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 4:09 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnDave, I figured it out. It was in help, but when I looked at it the first time, I didn't understand it. If anyone is interested the action page looks like this:<CFIF IsDefined("form.Meetingsgrid.rowstatus.action")><cfloop INDEX = "Counter" FROM = "1" TO = #ArrayLen(form.meetingsgrid.rowstatus.action)#><CFIF form.meetingsgrid.rowstatus.action[Counter] IS "D">
<CFQUERY NAME="DeleteExistingMeeting"
DATASOURCE="#Application.db#">
DELETE FROM tblmeetingdates
WHERE
MeetingID=#form.meetingsgrid.original.MeetingID[Counter]#
</CFQUERY>
<CFELSEIF form.meetingsgrid.rowstatus.action[Counter] IS "U"><CFQUERY NAME="UpdateExistingMeeting"
DATASOURCE="#Application.db#">
UPDATE tblmeetingdates
SET
MeetingNo='#form.meetingsgrid.MeetingNo[Counter]#',
MeetingDAte=#form.meetingsgrid.MeetingDate[Counter]#
WHERE
MeetingID=#form.meetingsgrid.original.MeetingID[Counter]#
</CFQUERY><CFELSEIF form.meetingsgrid.rowstatus.action[Counter] IS "I"><CFQUERY NAME="InsertNewMeeting"
DATASOURCE="#Application.db#">
INSERT into tblmeetingdates
(DistrictID, MeetingNo, MeetingDate)
VALUES ('#session.districtID#',
'#form.Meetingsgrid.meetingno[Counter]#',
#form.Meetingsgrid.meetingdate[Counter]#)
</CFQUERY></CFIF>
</cfloop>
</CFIF>-----Original Message-----
From: Dave Cahall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 3:41 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnI have looked at several options and none of them are "clean". CFGRID and the CFGRIDUPDATE tags are not very intelligent and robust. I was not able to set a dynamic value for a column on an insert. I then played around with adding a hidden form field but CFGRIDUPDATE will not recognize the hidden form field (although it got passed to the action page). I would suggest that you eithr use a standard form page or "roll your own code" for the action page. Neither of these are as easy as the cfgrid but they are about all you can do. I even tried messign with some of the expanded capabilities in CF 5, but they did not produce the desired results either.Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 11:43 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnYes, the table has a column called DistrictID-----Original Message-----
From: Dave Cahall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 11:42 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnI hate to ask this, but does the database contain a column named DistrictID. Since you are using the CFGRIDUPDATE tag, the column names in your CFGRIDCOLUMN tags MUST match a database column name EXACTLY. This is one of the pitfalls of using the short cut method.Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 10:30 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnI made the column visible and when I add a row (I have cfgrid set to Insert="yes") DistrictID does not show up. But I know the variable exists because I can output it elsewhere on the page
-----Original Message-----
From: Dave Cahall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 11:18 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnAre you sure the session variable is set? Make the value visible to make sure it is there!Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 10:17 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnI get no error message but the data that goes into the database does not include the DistrictID. Everything else goes in-----Original Message-----
From: Dave Cahall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 11:03 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnWhat happens when you "submit" your grid?Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 10:04 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnDave, on this issue. I tried to put a value in the cfgridcolumn but it didn't get into the database. Here is the code. Did I do something wrong?<cfgridcolumn value="#session.districtID#" name="DistrictID" display="no">Do I have to do something to the cfgridupdate or maybe I can't even use that in the action page?-----Original Message-----
From: Dave Cahall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 9:29 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Put a value into a cfgrid columnValues are placed in CFGRIDCOLUMN tags or CFGRIDROW tags. CFGRIDCOLUMN has a Value attribute and CDGRIDROW has a Data attritube. That is where you insert values.Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 8:28 AM
To: DFWCFUG (E-mail)
Subject: Put a value into a cfgrid columnI have a cfgrid for a table. I would like to have a column that automatically displays a session variable. I could not find a default or value attribute for the column. Is there one?
