dateformat within cfselect flash form

[Matrosity]

I'm needing to format smalldatetime sql field within cfselect in a flash form. How does one accomplish this?

[ssawka]

It's probably easiest to format the query prior to the cfselect generating. You can accomplish this a number of ways, but the most efficient way would be to do it in the SQL Select. How you do it depends on the DBMS that you are using.

[Matrosity]

Could you provide an example? Thx!

[ssawka]

It would really depend on the DBMS that you are using. The code example below is for SQL Server. Also, it would be helpful to know what query you are running and what fields you're using in the CFSelect.

[Matrosity]

I got it handled a less elegant way but it works. One would think that Adove would have added something so needed in the flash form. Oh well.

[cf_dev2]

A minor comment. You don't need cfloop + cfoutput. All you need is <cfoutput query="...">

[Matrosity]

I had that at first but then the flash form wouldn't display and CF 7 got stuck holding 30% cpu.

[cf_dev2]

Weird. Works for me with MX7.

[Guest]

Could you not try it like this?

<cfselect name="eventday" size="1" width="150" visible="Yes" enabled="Yes" required="Yes" query="events" value="eid" display="#LSDateFormat(edate, 'DD/MM/YYYY')#" />