 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Advanced Techniques / July 2007dateformat within cfselect flash form
I'm needing to format smalldatetime sql field within cfselect in a flash form. How does one accomplish this? 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. Could you provide an example? Thx! 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. <cfquery name="MyQuery" datasource="#MyDS#"> SELECT CONVERT(varchar,MyDateField,107) AS MyDate FROM MyTable </cfquery> ... <cfselect query="MyQuery" ... display="MyDate"> I got it handled a less elegant way but it works: <cfformgroup type="HORIZONTAL" label="Choose an event:"> <cfselect name="eventday" size="1" width="150" visible="Yes" enabled="Yes" required="Yes"> <cfloop query="events"> <cfoutput><option value = "#eid#">#dateformat(edate, "long")#</option></cfoutput> </cfloop> </cfselect> </cfformgroup> A minor comment. You don't need cfloop + cfoutput. All you need is <cfoutput query="..."> I had that at first but then the flash form wouldn't display and CF 7 got stuck holding 30% cpu. Weird. Works for me with MX7. <cfformgroup type="HORIZONTAL" label="Choose an event:"> <cfselect name="eventday" size="1" width="150" visible="Yes" enabled="Yes" required="Yes"> <cfoutput query="events"> <option value = "#eid#">#dateformat(edate, "long")#</option> </cfoutput> </cfselect> </cfformgroup> 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')#" /> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.