TheunisP
Posts: 342
|
| Posted: 05/10/2007, 5:12 PM |
|
Hi 1 and all, just ran into somthing stupid - I want a where clause but only want the records where a certain field is not empty - I'm not talking about a field that is NULL but one that has an empty string in it
but query builder removes the where if I test a field against an expression with value ""
any ideas?
|
 |
 |
Benjamin Krajmalnik
|
| Posted: 05/10/2007, 5:51 PM |
|
Use the BeforeBuildSelect embed and hand code it in.
"TheunisP" <TheunisP@forum.codecharge> wrote in message
news:64643b4d4a5ca9@news.codecharge.com...
> Hi 1 and all, just ran into somthing stupid - I want a where clause but
> only
> want the records where a certain field is not empty - I'm not talking
> about a
> field that is NULL but one that has an empty string in it
>
> but query builder removes the where if I test a field against an
> expression
> with value ""
>
> any ideas?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
TheunisP
Posts: 342
|
| Posted: 05/10/2007, 6:16 PM |
|
Thanks B, I suppose there is bugs in query builder - I have found that using " " (notice the space) CCS translates it into "" (with no space)
scary
|
|
|
|
r1xliquid
Posts: 41
|
| Posted: 05/16/2007, 1:56 PM |
|
why not use the trim function on the field, this would reduce any spaces to ""
|
|
|
|
|
