QueryRenameColumn()
Rename a column
Introduced: 6.0.0.57
QueryRenameColumn( query=query, column=string, newColumnName=string );
Returns: void
| Argument | Description |
|---|---|
|
query
query,
required
|
edit
Name of a query object. |
|
column
string,
required
|
edit
Name of the column to rename. Alias: columnName |
|
newColumnName
string,
required
|
edit
New name of the column. |
Examples
edit qry= queryNew( "name , age" , "varchar , integer" , [ [ "Susi" , 24 ] , [ "Urs", 28 ] ]);
writeOutput("Before changing the QueryColumn name : ");
writeDump(qry);
QueryRenameColumn( qry, "name", "employee" );
writeOutput("After changing the QueryColumn name : ");
writeDump(qry);
See also
- Queries
- query.renameColumn()
- Search Issue Tracker open_in_new
- Search Lucee Test Cases open_in_new (good for further, detailed examples)