Help - select syntax if else

2003-01-08 Thread Svens Klave
Can anybody help me with select query how to do this: I have table foo1 with two fields image check | image | check | | 6782 | 0 | | 2732 | 1 | | 6734 | 1 | so I want to make query select * from foo1 where [so is it possible to make some if check=1 then image is

Re: Help - select syntax if else

2003-01-08 Thread Brent Baisley
You don't even need the check field you can just directly check the contents of the image field. Although I'm not sure if you are trying to set a filter or display something different. If you want to display a conditional on a field then you need to specify that field directly. select

Re: Help - select syntax if else

2003-01-08 Thread Roger Baklund
* Svens Klave Can anybody help me with select query I can try. how to do this: I have table foo1 with two fields image check | image | check | | 6782 | 0 | | 2732 | 1 | | 6734 | 1 | so I want to make query select * from foo1 where [so is it possible to

Re: Help - select syntax if else

2003-01-08 Thread Zak Greant
On Wed, Jan 08, 2003 at 03:27:51PM +0200, Svens Klave wrote: Can anybody help me with select query how to do this: I have table foo1 with two fields image check | image | check | | 6782 | 0 | | 2732 | 1 | | 6734 | 1 | so I want to make query select *

Re: Help - select syntax if else

2003-01-08 Thread Keith C. Ivey
On 8 Jan 2003, at 15:27, Svens Klave wrote: | image | check | | 6782 | 0 | | 2732 | 1 | | 6734 | 1 | so I want to make query select * from foo1 where [so is it possible to make some if check=1 then image is image but if check=0 then into image goes other