> Why not do it in the query select statement by adding a column > expression to format the date there?
the way I read it, Steve is trying to squeeze a bit of code inbetween an untouchable SQL statement returning a query and some code further downstream to consume that query. You're right tho, if the world was your oyster the a Convert() on the select statement would be the way to go. Perhaps two references in the SQL for that DateTime field: the second as a string representation of it. or maybe it's not a query created from a database call itself? I can't remember, but does CFDirectory.dateLastModified return a proper DateTime value? > As for querySetCell(), I don't think that's possible. I didn't think it was either. Good for creating values when used with QueryAddRow() but IIRC, a query object returned is read-only (hence the idea of using QofQ for data conversion) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
