JayEdgar
Posts: 77
|
| Posted: 02/12/2008, 9:54 PM |
|
Woe is me when attempting to find some of these things in documentation. Why is it so incomplete? </gripe>
I'm building a query for a control, and when adding a WHERE clause using the Table Parameter, I am not able to figure out how to search for an integer field being NULL or NOT NULL. I thought you put whatever in the expression on the right and select type Expression.
She no work.
Can someone please share a bit of wisdom with me?
Thanks,
Jay
P.S. If anyone has a wiki they're building of CCS documentation, I would GLADLY contribute to it. Thanks.
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 02/13/2008, 7:48 PM |
|
JayEdgar
How are you determining if the field is NULL or Not NULL?? Are you using MySQL or PHP to determine this?
|
|
|
|
JayEdgar
Posts: 77
|
| Posted: 02/13/2008, 7:52 PM |
|
I'm not sure how that question relates to my original one, so I must not have been clear.
I want a grid to display a recordset. I want it to select records in some cases where a field is null. How do I enter the parameters into the query builder's table parameter dialog box?
In other instances, I want it to query for records where a field is NOT null. How do I fill out the table parameter dialog box for that?
I'm using PHP and MSSQL.
Thanks for the reply.
Jay
|
|
|
|
DonB
|
| Posted: 02/14/2008, 4:40 AM |
|
You can put anything at all in the 'value' (rightmost field) - as it
requires input, even though it isn't used. Or you can change the where from
'parameter' to 'expression' and just type in the 'somecolumn IS NULL' as a
text string.
--
DonB
"JayEdgar" <JayEdgar@forum.codecharge> wrote in message
news:547b3bb176f95b@news.codecharge.com...
> I'm not sure how that question relates to my original one, so I must not
> have
> been clear.
>
> I want a grid to display a recordset. I want it to select records in some
> cases
> where a field is null. How do I enter the parameters into the query
> builder's
> table parameter dialog box?
>
> In other instances, I want it to query for records where a field is NOT
> null.
> How do I fill out the table parameter dialog box for that?
>
> I'm using PHP and MSSQL.
>
> Thanks for the reply.
>
> Jay
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
|
