"Chris Boget" <[EMAIL PROTECTED]> wrote:
>> > What's going on with the MAX() function? Why did it return NULL
>> > in the first query above. There were no adding/deleting data between
>> > the above queries and yet MySQL didn't pull the MAX from the table
>> > until I added the "AND assets IS NOT
At 16:09 -0500 6/12/03, Chris Boget wrote:
> CREATE TABLE do_deductibles (
currency varchar(10) NOT NULL default '',
assets int(20) NOT NULL default '0',
deductible int(10) NOT NULL default '0',
do_deductibles_id int(5) NOT NULL auto_increment,
PRIMARY KEY (do_deductibles_id),
U
> CREATE TABLE do_deductibles (
> currency varchar(10) NOT NULL default '',
> assets int(20) NOT NULL default '0',
> deductible int(10) NOT NULL default '0',
> do_deductibles_id int(5) NOT NULL auto_increment,
> PRIMARY KEY (do_deductibles_id),
> UNIQUE KEY do_deductibles_idx (currency
> > What's going on with the MAX() function? Why did it return NULL
> > in the first query above. There were no adding/deleting data between
> > the above queries and yet MySQL didn't pull the MAX from the table
> > until I added the "AND assets IS NOT NULL" to the query. And yet
> > after I ran
"Chris Boget" <[EMAIL PROTECTED]> wrote:
> We are running v4.0.12.
>
> Consider the following:
>
> mysql> SELECT MAX(assets) as assets
>-> FROM do_deductibles
>-> WHERE currency = 'usd';
> ++
> | assets |
> ++
> | NULL |
> ++
> 1 row in set (0.00 sec)
>
> mysql>
hello
in delphi the type for max(date) if tstring.
the only problem is there is no CAST in mysql 3.23.49
bye
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: "'Jean Bernard'" <[EMAIL PROTECTED]>
Sent: Thursday, April 25,
On Friday 17 August 2001 07:13, Jim Lynn wrote:
> I have a database of bids on auctions that I keep separate from the auction
> information. The problem comes when I attempt to generate a list of
> auctions with highest bid information. I set the database for bids like
> this:
>
> ANum, varchar(
