Count function ignores where statement

[gavray]

Hi,

I'm using mySQL with ASP. This count function is really frustating because it counts all the records in the database. It ignores the where statement NowLive=1 .

Any ideas?

sSQL2="SELECT COUNT(ArtistNameTable2.NowLive) AS results_count"
sSQL2=sSQL2 & " FROM ArtistNameTable2"
sSQL2=sSQL2 & " WHERE NowLive=1"

Many thanks.

Gavin

the boho from soho

 

[sleipnir214]

If you use this query in your preferred MySQL admin tool, does it work correctly there?

What is the column type of NowLive? Could it be a type conversion problem?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[gavray]

Thanks,

I've tried it via my admin tool and it picks up the LiveNow row with only 1 in it.

The column type is TINYINT, length 1, default 0, not null

I can't understand it.

gavin

the boho from soho