my query in a cfc function :

SELECT blogId, blogTitle, DATE_FORMAT(blogDate, '%c/%e/%y - %l:%i %p')# AS
dateL, regNicName
FROM zr_blog, zr_reg
WHERE bcatsId = #cat#
AND arcived = 0
AND private = 0
AND zr_blog.regId = zr_reg.regId
ORDER BY blogDate DESC

This works fine if I there is only one record returned, but as soon as there
are multiple records, dateL returns as an object with about 17 undefined
params. When I run this query in mySQL it works fine, even with multiple
records. Is there some thing about remoting and dates that I am missing?
Please help...
Russ

Target,

I remove all date masks form the flash form firstly. ThenI use my SQl query to
convert any datetime or smalldatetime columns in my select query. eg:

SELECT DISTINCT TOP 100 PERCENT
CONVERT (nvarchar, dtmBatchDate ,110) AS dtmBatchDate
, bitIsPrinted
FROM dbo.tblInvoiceBatches
WHERE (bitIsArchived = 0)
ORDER BY dtmBatchDate

The CONVERT changes the datetime or smalldatetime column to a nvarchar type,
then table column name, then the style which is the USA standard (110) string
for mm-dd-yy or you could use (101) which is the string for mm/dd/yy.

This will be viewed in the grid via remoting correctly with no mask.

Hope this helps?