Maybe DW (I don't use it - so who knows) doesn't like the column name max(zinr) maybe try:
SELECT max(zinr) as max_zinr FROM zimmer WHERE mpehotel=1 Just a thought. Mark On Fri, 22 Oct 2004 10:35:55 +1000, Ian Van Kretschmar <[EMAIL PROTECTED]> wrote: > I cannot see to get the SQL function MAX() to work (not to be confused with > the CMFL function of the same name). I would assume that when designing an > SQL query using the SELECT statment I would be able to use all of the > standard SQL commands and/or functions. > > When I try to create a new Recordset (Query) in Dreamweaver MX and "test" > the following statement I get "No Recordset was Returned." > > SELECT max(zinr) > FROM zimmer > WHERE mpehotel=1 > > Obviously this query is designed to return the highest value in the column > "zinr" where the value for mpehotel is equal to 1. > > If I remove the max() function I get results when I click on the "test" > button (all values in the zinr column. I know the syntax of my statement is > correct because it works in any other SQL clients and query analysers. I am > working with a MS SQL database. > > Alternatively, how can I have returned the highest number in a column? > > Kind Regards, > > IHVK > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
