CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Followup to Keyword Search Question

Print topic Send  topic

Author Message
mlapl1

Posts: 66
Posted: 05/30/2008, 11:36 AM

IN

http://forums.yessoftware.com/posts.php?post_id=97267

I asked for some help on how to do a keyword search. My question was kindly answered and I wrote a variation of the piece of code found at http://forums.codecharge.com/posts.php?post_id=94083

Here is a NEW problem though. The code which generated by the keyword search seems to overwrite the information generated by other parts of the search form (I have a search form which contains both boolean and keyword parameters. I would like to combine the search based on both boolean parameters AND the keyword search just mentioned). Now, instead of returning a result based on both the BOOLEAN and KEYWORD parameters, I only get KEYWORD search results and no account is taken of the BOOLEAN requirements. If I do not enter keywords, the Boolean search works fine. If I enter Keywords, the Boolean search is ignored. This leads me to believe that the Boolean results are somehow overwritten by the Keyword results.

Any clue on how to combine both results?

Thank you
Andrew
View profile  Send private message
datadoit
Posted: 05/30/2008, 1:30 PM

Add this to the beginning of your BeforeBuildSelect:

if ($Container->ds->Where <> "") {
$Container->ds->Where .= " AND ";
}

See the docs....
http://docs.codecharge.com/studio40/html/Components/Eve...Select.html?toc

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.