Problem with revExecuteSQL - More

[Dave]

Hi,

The path is coming out of the iTunes XML file. It's not just this  
path, it's a load of them, for instance there are a lot of instances  
that wherever there is an ampersand it is followed by #38; There are  
files that have funny accents that cause the problem too, If I read  
back the same track using AppleScript the weird characters are not  
there.

I think that the tracks where this occurs were imported from a PC.

Thanks a lot
All the Best
Dave

On 1 Nov 2007, at 19:22, Ian Wood wrote:

> It looks like the folder name has been abbreviated at some stage by  
> an OS that didn't understand file/folder names that long.
>
> Where *exactly* is the filepath coming from?
>
> Ian
>
> On 1 Nov 2007, at 18:01, Dave wrote:
>
>> However I now have a another weird problem, I have a field that  
>> represents a file path, in this case the path is:
>>
>> /Users/Dave/Music/iTunes/iTunes Music/Blank & Jones/Addicted  
>> To Trance (Disc 1)/11 DJs, Fans And Freaks.mp3
>>
>> However a "if there is a file" fails on this path. When I look I  
>> can't see the & in the file name. I'm guessing it's something  
>> to do with UTF16 vs UTF8 or something, but I'm not sure how to  
>> resolve it. The database I am writing is set to UTF8 which AFAIK  
>> is the only option for SQLite.
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution