Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
Problem with IN ( operation |
Wed, Feb 24 2010 11:05 AM | Permanent Link |
Michael Reisch | 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 |
Thu, Feb 25 2010 4:09 AM | Permanent Link |
Uli Becker | 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 |
Thu, Feb 25 2010 2:02 PM | Permanent Link |
Michael Reisch | 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 |
Thu, Feb 25 2010 4:45 PM | Permanent Link |
Uli Becker | 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 |
Thu, Feb 25 2010 8:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |