lowes93
Posts: 3
|
Posted: 04/05/2008, 2:07 PM |
|
I'm building a Search form and trying to use the "IN" option in Query Builder.
Questions:
1. The field is an Integer - What settings do I need in Query Builder in order to use the "IN" option in the "Where" clause?
2. Can I make the entry field on my Search dialogue a "Text Area"? and set to "Memo"?
3. How should the user enter their string of numbers?
Example:
387, 404, 595, 444
or does the user enter...
(387, 404, 595, 444)
or
"387", "404","595","444"
Nothing I try seems to work.
Help!
_________________
Andy |
|
|
Edd
Posts: 547
|
Posted: 04/05/2008, 6:39 PM |
|
The In operator would expect integers in the format of
where id in (387, 404, 595, 444)
The problem you may find is that you are passing them as a string and CCS is probably doing this to the where clause
where id in '(387, 404, 595, 444)' surrounding it with single quotes.
You can manually alter the where clause in code, look up Quote :Dynamically Modify the WHERE Clause in help.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
lowes93
Posts: 3
|
Posted: 04/06/2008, 5:58 AM |
|
Still stuck
Why have an "IN" option if there is no way to make it work.
_________________
Andy |
|
|
DonB
|
Posted: 04/07/2008, 12:42 PM |
|
It works if the 'type' is Expression and you provide an array -
array(1,2,3,4) - as the expression value
--
DonB
"lowes93" <lowes93@forum.codecharge> wrote in message
news:647f8c8f56e84e@news.codecharge.com...
> Still stuck
>
> Why have an "IN" option if there is no way to make it work.
> _________________
> Andy
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
DonB
|
Posted: 04/07/2008, 5:02 PM |
|
Oh, but this is the ASP forum. I gave the PHP syntax...
--
DonB
"DonB" <~ccbth~@gotodon.com> wrote in message
news:ftdte8$5b6$1@news.codecharge.com...
> It works if the 'type' is Expression and you provide an array -
> array(1,2,3,4) - as the expression value
>
> --
> DonB
>
>
>
> "lowes93" <lowes93@forum.codecharge> wrote in message
>news:647f8c8f56e84e@news.codecharge.com...
>> Still stuck
>>
>> Why have an "IN" option if there is no way to make it work.
>> _________________
>> Andy
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>
|
|
|
|