http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T16:41:08 en-us http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa58.htm#56325 Use "JavaCast" to avoid unwanted type conversions.<br /><br />Example - <QuerySetCell(PortsTable, "PortArrival", "#JavaCast('string', ThisDebark)#")> sks447 0 0 2006-11-14T13:11:31 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa58.htm#33176 Why use this function when there is an equivalent syntax which is easier to read?<br /><br />myQuery["columnName"][rowNum] = value; wtf-dude-cmon 0 0 2005-05-09T12:59:11 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa58.htm#26622 I'm running into the same issue. Creating one query and using QueryAddColumn(), then creating another query from that query. It's converting strings to timestamps. Really undesireable behavior. Anyway around this? It's converting a string like 9-3 to {ts '2005-09-03 00:00:00'}. r.sesser 0 0 2005-01-17T08:05:03 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa58.htm#26102 After creating a query variable using QueryNew(""), and adding rows, then assigning values to the cells with QuerySetCell() from an existing database query, the datatype of the cell is set automatically.<br /><br />This converts strings to numbers and strings to dates, which has the affect that the values have to be converted back explicitly to the desired output format.<br /><br />It would really be nice to be able to specify the datatype either in QueryNew(), QueryAddRow(), or QuerySetCell(). Holger 0 0 2005-01-03T13:10:38