Tim,

I found a crazy problem with this command:

select * from Media where Project_GUID = '{123}' and FileType in (2, 3, 4)

Result are all Filetypes not only 2, 3, 4.

FileType is an INTEGER field.
Project_GUID is an VARCHAR(48).

Changing the command to:

select * from Media where FileType in (2, 3, 4)

works fine!

I used this command in edb1 and it works fine there.

regards
Michael

Michael,

> I found a crazy problem with this command:
>
> select * from Media where Project_GUID = '{123}' and FileType in (2, 3, 4)
>
> Result are all Filetypes not only 2, 3, 4.

I tested that (latest version of EDB) and it seems to work fine.
Are you really using exactly this statement?

Uli

Uli,

yes, I use exactly this command, also with latest release. I changed then the command to:

select * from Media where Project_GUID = '{123}' and (FileType = 2 or FileType = 3 or
FileType = 4)

This works fine.

Regards
Michael

Uli Becker wrote:

Michael,

> I found a crazy problem with this command:
>
> select * from Media where Project_GUID = '{123}' and FileType in (2, 3, 4)
>
> Result are all Filetypes not only 2, 3, 4.

I tested that (latest version of EDB) and it seems to work fine.
Are you really using exactly this statement?

Uli

Michael,

> yes, I use exactly this command, also with latest release. I changed then the command to:
>
> select * from Media where Project_GUID = '{123}' and (FileType = 2 or FileType = 3 or
> FileType = 4)
>
> This works fine.

Weird. We have to wait what Tim says.

Uli

Michael,

<< I found a crazy problem with this command:

select * from Media where Project_GUID = '{123}' and FileType in (2, 3, 4)

Result are all Filetypes not only 2, 3, 4. >>

Can you send me an example that replicates this ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com