Problem with revExecuteSQL - More

Dave dave at
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  
> browser,
> 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  
> converted.
> 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 mailing list