mydatabasepilot-cvs

[<nan...@us...>]

Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query
In directory sc8-pr-cvs1:/tmp/cvs-serv8802/Query

Modified Files:
	alterTable.cfm 
Log Message:
Functionality Added:
[ 763489 ] Added Length to TimeStamp and Year datatypes

Index: alterTable.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/alterTable.cfm,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** alterTable.cfm	27 Jun 2003 14:14:17 -0000	1.24
--- alterTable.cfm	30 Jun 2003 21:09:12 -0000	1.25
***************
*** 167,172 ****
  								// Set Temporal Type to TRUE
  								isTemporalCol = TRUE;
  								break;
- // todo				Timestamp and Year Length
  							}
  						}
--- 167,177 ----
  								// Set Temporal Type to TRUE
  								isTemporalCol = TRUE;
+ 								
+ 								// Add Length to Output Strings if Specified
+ 								if((ATTRIBUTES.alterSpec[i].colType IS "TIMESTAMP" OR ATTRIBUTES.alterSpec[i].colType IS "YEAR") AND ATTRIBUTES.alterSpec[i].length IS NOT ""){
+ 									rawSQL = "#rawSQL#(#ATTRIBUTES.alterSpec[i].length#)";
+ 									htmlSQL = "#htmlSQL#(<span class=""Number"">#ATTRIBUTES.alterSpec[i].length#</span>)";
+ 								}
  								break;
  							}
  						}