Another Neophyte SQL Question

[Chuck Pelto]

On Feb 15, 2007, at 12:37 PM, Bart Pietercil wrote:

> Don't forget you can use parameter binding.

I'll remember to implement that.

> Are you using a Server or a local db ?

Developing it locally, first. Then I'll be moving this RB module into  
products that run on Servers.

Why?

Regards,

Chuck

>
> 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_reten 
>>> tion_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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>