you might expect to get a string. Most of CFMX knows how to transparently
convert it to a string for use, but there are certain places it doesn't work
(such as QofQs). The solution is to use the CF built-in function
toString(), which will force the conversion.
Cheers,
barneyb
> -----Original Message-----
> From: Ron Eis [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 26, 2004 1:15 PM
> To: CF-Talk
> Subject: RE: Trying to group dates in dropdown list
>
> Still having problems. I can get the YEAR-MONTH to return and display
> 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]
