PHP SQL - isnull wrong number of arg error

Author

isnull wrong number of arg error

Goomba

2006-06-02, 7:02 pm

i am trying find whether or not a value in a field is null, but i keep
coming up with 'wrong number of arguments' error. as far as i am aware, the
isnull function takes two arguments, and those i have defined. im not sure
what else is wrong.

SELECT title, isnull(season, 'undefined') as season
FROM movies

the database im using is MS Access 2002.

thanks for any input!

strawberry

2006-06-03, 8:01 am

Does this work?

SELECT title,replace(ISNULL(hint),'1','Undefine
d') FROM movies;

Goomba wrote:
> i am trying find whether or not a value in a field is null, but i keep
> coming up with 'wrong number of arguments' error. as far as i am aware, the
> isnull function takes two arguments, and those i have defined. im not sure
> what else is wrong.
>
> SELECT title, isnull(season, 'undefined') as season
> FROM movies
>
> the database im using is MS Access 2002.
>
> thanks for any input!

strawberry

2006-06-03, 7:00 pm

Oops,

I think I meant

SELECT title,replace(ISNULL(season),'1','Undefi
ned') season FROM
movies;

but anyway, this is probably more appropriate:

SELECT title,coalesce(season,NULL,'undefined') season FROM movies;

strawberry wrote:[color=darkred]
> Does this work?
>
> SELECT title,replace(ISNULL(hint),'1','Undefine
d') FROM movies;
>
> Goomba wrote:

Goomba

2006-06-03, 7:00 pm

thanks for the response!

the first one
- SELECT title,replace(ISNULL(season),'1','Undefi
ned') season -
i receive a missing operator error

the second one
- SELECT title,coalesce(season,NULL,'undefined') season -
i just get a database error.., but no information about it.

i am finding answers everywhere.., but when i apply them all i get is errors
with no information. i dont understand whats wrong.

i am also trying to do a case expression such as:
SELECT title, season
case when season is null then 'undefined'
end as season
FROM movies

i have tried different variations of the null such as = null, = '', i even
tried on other fields with numbers using <> and = and i still get "Error
Executing Database". i dont get it. =(

"strawberry" <zac.carey@gmail.com> wrote in message
news:1149344871.276697.114140@j55g2000cwa.googlegroups.com...
> Oops,
>
> I think I meant
>
> SELECT title,replace(ISNULL(season),'1','Undefi
ned') season FROM
> movies;
>
> but anyway, this is probably more appropriate:
>
> SELECT title,coalesce(season,NULL,'undefined') season FROM movies;
>
>
> strawberry wrote:
>

Sponsored Links