Problem with revExecuteSQL - More

[Dave]

Yo Jim,

I knew someone would remember! Guess I've been on here to long to not  
think that! Thanks Y'All!

I just knew it would be something like that. This is a place where  
the documentation is poor, just a mention about this in anyone of the  
"database" related topics of the online help would have made it  
sooooooooooooo much easier.

This is my main gripe with RunRev really. There are three features  
that I've used lately (and not used before), advertised to death on  
the news letters, etc. And when you use them, god help you if you  
want to do anything other than the rather plain examples. As soon as  
you get into a "real-life" situation RunRev (in my experience) lets  
you down.

Hours coding and design takes a day or more to get right, just  
because of the documentation and the lack of central place and bad  
support.

Oh well such is life...................

All take and thanks for the help, Eric if you read this and have the  
code, please send me a link???

All the Best
Dave


On 1 Nov 2007, at 22:41, Jim Ault wrote:

> Sorry about that, Dave,  I thought you were referring to the
> INSERT command in Sql.  My mistake.
>
>>>
>>> Basically, you are including control characters in the data you are
>>> trying
>>> to store, so Sql does not see those characters as *data*.
>>
>> This has nothing to do with SQL, this is before the data is written,
>> in fact I can insert the data ok. The problem is that some of the
>> data has these weird characters. I am dealing with a "typical"
>> MusicBase. From looking at the track that have these characters in
>> then I'd say they came from a PC. I seem to remember somewhere now
>> that said you have to do something to the data you wrote to ensure it
>> will work on a Mac and PC. Does anyone remember??
>
> 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.
> http://sonsothunder.com/devres/revolution/revolution.htm
> About half way down the page are some goodies.
>
> 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.
>
> Jim Ault
> Las Vegas
>
>
> _______________________________________________
> 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