mysql max() function

> Here is the error that is being thrown:
> ErrorCode 1305
> Message FUNCTION bohr.MAX does not exist
> SQLState 42000
>
> And here is the query that apparently is causing some problem:

I suspect it *isn't* that query because there's no reference to bohr.MAX in
it.

Does that string appear in your code / SQL anywhere?

--
Adam

I think the problem is that you do not have a stored procedure called
bohr.MAX:

http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html

Error: 1305 SQLSTATE: 42000 (ER_SP_DOES_NOT_EXIST)

Message: %s %s does not exist

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com


"suluclac" <webforumsuser@macromedia.com> wrote in message
news:gegod6$qus$1@forums.macromedia.com...
> Hi guys,
>
> I have an application that works just fine when using mssql.
> Got a new laptop where I am trying to get this application up and running,
> but
> with mysql now.
>
> Here is the error that is being thrown:
> ErrorCode 1305
> Message FUNCTION bohr.MAX does not exist
> SQLState 42000
>
> And here is the query that apparently is causing some problem:
>
>
> Any help would be HUGE!
> Thanks!
> - Gary
>
> <cfquery datasource="#application.settings.dataSource#" name="result">
> SELECT
> T1.TRANSFUSION_DICTIONARY_NAME,
> T1.TRANSFUSION_DICTIONARY_ID,
> T1.NUMBER_OF_UNITS,
> T1.TRANSFUSION_DATE,
> T1.DIAGNOSIS_DICTIONARY_NAME
> FROM
> TRANSFUSION T1
> WHERE
> T1.TRANSFUSION_DATE = (
> SELECT MAX
> (T2.TRANSFUSION_DATE)
> FROM
> TRANSFUSION T2
> WHERE
> T1.TRANSFUSION_DICTIONARY_NAME = T2.TRANSFUSION_DICTIONARY_NAME
> AND
> USER_ID = <cfqueryparam value="#arguments.userID#"
> cfsqltype="cf_sql_char">
> )
> AND
> USER_ID = <cfqueryparam value="#arguments.userID#"
> cfsqltype="cf_sql_char">
> AND
> DELETED <> 'true'
> ORDER BY
> TRANSFUSION_DATE DESC,
> TRANSFUSION_DICTIONARY_NAME
> </cfquery>
>