DataTable in Coldfusion (in cfscript)

Hi i want to add DataTable in Coldfusion script...Like c# code...C# code is following:

DataTable productPropertyFilterTable = new DataTable();

productPropertyFilterTable.Columns.Add("RowID", typeof(int));

productPropertyFilterTable.Columns.Add("PropertyId", typeof(long));

productPropertyFilterTable.Columns.Add("PropertyWeight", typeof(string));

productPropertyFilterTable.Columns.Add("LowerRange", typeof(float));

productPropertyFilterTable.Columns.Add("UpperRange", typeof(float));

This topic has been closed for replies.

Correct answer duncancumming

You want to use QueryNew and QueryAddColumn.

productPropertyFilterTable = queryNew('');

queryAddColumn(productPropertyFilterTable, 'RowID', 'Integer');

queryAddColumn(productPropertyFilterTable, 'PropertyWeight', 'VarChar');

Alternatively you can just do the same with QueryNew on its own.

productPropertyFilterTable = queryNew('RowID,PropertyWeight', 'Integer,VarChar');

duncancummingCorrect answer

Participating Frequently

productPropertyFilterTable = queryNew('');

queryAddColumn(productPropertyFilterTable, 'RowID', 'Integer');

queryAddColumn(productPropertyFilterTable, 'PropertyWeight', 'VarChar');

Alternatively you can just do the same with QueryNew on its own.

productPropertyFilterTable = queryNew('RowID,PropertyWeight', 'Integer,VarChar');

Known Participant

How to add data in datatabel like C# Code:

productPropertyFilterTable.Rows.Add(i, wordsStrings[0], wordsStrings[3], Limit[0], Limit[1]);

Participating Frequently

Now you need to use QueryAddRow and QuerySetCell

Sign up