Similar to a recent post but still can't get it to work.

Using CF MX 6.1, MySQL 3.23.44-nt, phpMyAdmin 2.4.0.  

I'm trying to group entries by month, to display MONTH YEAR in a drop
down list.  

Current month/year is the default display.

User has the option to select a previous month/year which will display
the entries submitted during that time period.  

When using CF 5, used [[SELECT DISTINCT LEFT(dataDateReported,7) AS
dropDownMenu]] AND [[<cfselect name="selectMonth" size="1"
query="buildDropDown" value="dropDownMenu"
display="dropDownMenu"></cfselect>]] but get the following error message
using 6.1: "ByteArray objects cannot be converted to strings."  

Can anyone help?  Please let me know if additional information is
needed.  Thanks in advance!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to