Problem with revExecuteSQL - More
dave at looktowindward.com
Fri Nov 2 06:09:16 EDT 2007
On 1 Nov 2007, at 22:41, Jim Ault wrote:
> The weird characters are the code for special characters in HTML
> and XML.
> Browsers will decode these so the view of the page will see only
> the single
> character represented. Your program has to do the same thing as a
> parse the file paths to detect and convert these codes.
> Eric Chatonet wrote a web page tag cleaning routine that did just this
> (quite a while ago). I cannot remember which stack it was, but
> this would
> be a repeat loop where a whole set of these html entities will be
> Perhaps he will chime in and remind us.
> Ken Ray has very good info on how to detect the platform and adjust
> the file
> path to work in Rev.
> About half way down the page are some goodies
Thanks a lot, I took a look I'm not sure which article you are
referring to. Which section is it in?
All the Best
> Also, you should use the following:
> if not(there is a file tPathFilename) then answer "ooops"
> if not(there is a folder tFoldername) then answer "ooops"
> Hope this is of more help. I thought you were trying to move data
> in and
> out of Sql.
I was and am, I thought the weird characters were caused when writing
to the database, but it turns out to be a PC/Mac issue.
> Jim Ault
> Las Vegas
All the Best
More information about the Use-livecode