Another Neophyte SQL Question

[Bart Pietercil]

Hi Chuck,

Don't forget you can use parameter binding.
Are you using a Server or a local db ?

Bart


On 15-feb-07, at 20:21, Chuck Pelto wrote:

> Hi Bart,
>
> On Feb 15, 2007, at 12:13 PM, Bart Pietercil wrote:
>
>> Probably this is what you are after.
>>
>> http://www.valentina-db.com/dokuwiki/doku.php? 
>> id=paradigma:public:en:documentation:vsql:reference:select:set_retent 
>> ion_check
>>
>> Mind you , still good to check the index by words flag for the field
>
> So, I could use the IN function and write the SQL search verbiage  
> as follows....
>
> WHERE f1 IN (value1, value2....valuex)
>
> That's nice to have learned. It'll make the string much easier to  
> build....I hope....
>
> Regards,
>
> Chuck
>
>
>
>> On 15-feb-07, at 19:55, Chuck Pelto wrote:
>>
>>> Greetings,
>>>
>>> If I have multiple search criteria in a textual field, how would  
>>> I have to write the SQL query?
>>>
>>> Case in point, I have a VText field with scads of text in it, say  
>>> from on-line newspaper articles.
>>>
>>> I want to find all the articles that mention "strawberries" and  
>>> "gun laws".
>>>
>>> Which is the proper syntax to use?
>>>
>>> "....WHERE f1 LIKE %'" + value1 + "'% AND LIKE %'" + value2 +  
>>> "'%" // mentioning the field only once for all values to be  
>>> checked for
>>>
>>> or
>>>
>>> "....WHERE f1 LIKE %'" + value1 + "'% AND f1 LIKE %'" + value2 +  
>>> "'%" // mentioning the field for every value to be checked for
>>>
>>>
>>> Regards,
>>>
>>> Chuck
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina