RE: ANOTHER CF_GRID question

2000-11-18 Thread Luis

The problem begins when I write more characters in the CFGrid 
and then update the information, could I control the update 
statment on my CFGRID?, Another thing, I want to convert to 
UPPERCASE the information typed on the grid before it was 
updated, that is I want to save UCASE information only, is that 
possible?


On 17 Nov 2000, at 7:31, McCollough, Alan wrote:

 Since you are using MS SQL 7, set up a view for your datasource, and trim
 the view's output to 10 chars.
 
 Alan McCollough
 Web Programmer
 Allaire Certified ColdFusion Developer
 Alaska Native Medical Center
 
  -Original Message-
  From:   Luis [SMTP:[EMAIL PROTECTED]]
  Sent:   Friday, November 17, 2000 7:02 AM
  To: CF-Talk
  Subject:ANOTHER  CF_GRID question
  
  How can I truncate the information typed on the grid if my filed has 
  a length of 10 (example)? Now I receive an error, I'm using SQL 7 
  and ColdFusion 4.5 on WinNT 4
  ~~
  Structure your ColdFusion code with Fusebox. Get the official book at
  http://www.fusionauthority.com/bkinfo.cfm
  
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: ANOTHER CF_GRID question

2000-11-17 Thread McCollough, Alan

Since you are using MS SQL 7, set up a view for your datasource, and trim
the view's output to 10 chars.

Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center

 -Original Message-
 From: Luis [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, November 17, 2000 7:02 AM
 To:   CF-Talk
 Subject:  ANOTHER  CF_GRID question
 
 How can I truncate the information typed on the grid if my filed has 
 a length of 10 (example)? Now I receive an error, I'm using SQL 7 
 and ColdFusion 4.5 on WinNT 4
 ~~
 Structure your ColdFusion code with Fusebox. Get the official book at
 http://www.fusionauthority.com/bkinfo.cfm
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists