mysql max() function

Report · Oct 31, 2008

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

Report · Nov 02, 2008

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>
>

Report · Nov 02, 2008

> 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