just a simple question...

[Danny Lewkin]

Thanks Ruslan, that was it!


Op 8-aug-07, om 10:59 heeft Ruslan Zasukhin het volgende geschreven:

> On 8/8/07 11:32 AM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:
>
> Hi Danny,
>
>> anyone knows why this doesn't return any records? (Record does exist
>> of course ;-)
>>
>> select ** FROM tbl_lu_media WHERE lu_media_path = '\\.PSF\Shared
>> \DSCN3586.MOV'
>
> What value present really in RECORD?
>
> It is as this INSIDE of db ?
>
>           '\\.PSF\Shared\DSCN3586.MOV'
>
>
> Then you need ESCAPE \  using Valentina.EscapeString()
>
> And most probably it will look after this as
>
>
> select **
> FROM tbl_lu_media
> WHERE lu_media_path = '\\\\.PSF\\Shared\\DSCN3586.MOV'
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina