properly in the dropdown list in the proper format using LEFT or MID but
the query returns all entries in the database.
I need the display to be group by YEAR then MONTH in the dropdown list.
Whenever I add DISTINCT or a GROUP by to the query, I get the error
"ByteArray objects cannot be converted to strings."
I've checked the documentation and came up with nothing. Has DISTINCT
gone extinct in MX?
-----Original Message-----
From: Donnie Bachan [mailto:[EMAIL PROTECTED]
Sent: Monday, February 16, 2004 11:05 PM
To: CF-Talk
Subject: RE: Trying to group dates in dropdown list
I ran across this problem using MySQL and CFMX 6.1 and dates, I have
been
too lazy to figure out the root of the problem but I used the MySQL date
format functions to format the date before returning it to ColdFusion
and
that solved the problem. If the Month and Year are stored as part of a
date/time type use the date format function and return the part that you
want.
HTH
======================
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]
