gstrohmann
|
Posted: 01/11/2004, 1:14 PM |
|
Hi
Does anyone know if it is possible (and how to ...) to enter boolean words in search fields when executing CCS 2.0 web pages ?
Normally, meta-characters (eg *,?, %) and boolean codes (AND, OR, NOT, XOR) are used to define complex searches.
i've tried to enter without success such requests for the moment (no records found all the time).
Can anyone confirm me these functions are allowed in CCS 2.0 ? Thx to reply (FYI i've been using CCS2 with Access database & ASP language)
Regards and thx again for your help
|
|
|
peterr
Posts: 5971
|
Posted: 01/11/2004, 10:28 PM |
|
Quote :Can anyone confirm me these functions are allowed in CCS 2.0 ?
Yes, almost everything is allowed in CCS
You would need to create a custom code in the "Before Build Select" event to modify the regular SQL statement that CCS generates.
See: http://docs.codecharge.com/studio/html/Components/RTProperties/ASP/SQL.html
You may need to create a loop that checks all the keywords entered by users and builds the corresponding SQL statement.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
DonB
|
Posted: 02/04/2004, 3:19 PM |
|
I adapted code from http://www.planet-source-code.com/vb/scripts/ShowCode.a...d=6297&lngWId=4
which worked really well.
--
DonB
http://www.gotodon.com/ccbth
"peterr" <peterr@forum.codecharge> wrote in message
news:240023e8ea628d@news.codecharge.com...
> Quote :Can anyone confirm me these functions are allowed in CCS 2.0
?
>
> Yes, almost everything is allowed in CCS
> You would need to create a custom code in the "Before Build Select" event
to modify the regular SQL statement that CCS generates.
> See:
> http://docs.codecharge.com/studio/html/Components/RTProperties/ASP/SQL.html
>
> You may need to create a loop that checks all the keywords entered by
users and builds the corresponding SQL statement.
> _________________
> Peter R.
> YesSoftware Support Representative
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|