Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-04 Thread Richard Gaskin
Dave wrote: One word of warning on using a field to strip HTML text - it's VERY slow. When a field is on the current card, the engine makes the reasonable assumption that it may be used for editing, and does extra stuff to the object record to make sure it renders well. That extra stuff slo

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-04 Thread Dave
Hi, I added this and the time went up to 99 seconds as apposed to 80 without putting it into a field, WAY better than 327 tho! Thanks All the Best Dave On 4 Nov 2007, at 14:12, Stephen Barncard wrote: Did you lock/unlock the screen? VERY important. Hi One word of warning on using a fiel

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-04 Thread Stephen Barncard
Did you lock/unlock the screen? VERY important. Hi One word of warning on using a field to strip HTML text - it's VERY slow. When I ran the app on a 10,000 track database, without the put/get field, it took 80 seconds to complete, when I ran it with the put/get field the time went up to 327

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-04 Thread Dave
Hi One word of warning on using a field to strip HTML text - it's VERY slow. When I ran the app on a 10,000 track database, without the put/get field, it took 80 seconds to complete, when I ran it with the put/get field the time went up to 327 seconds!!! Will the template field be quick

Re: Jeanne de Voto cookbook (was Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More))

2007-11-02 Thread wayne durden
The bottom line is it's one of those Christopher Alexander Pattern Language problems... There is an overall quality of goodness we can't really capture from any one aspect, we just know what we have had so far isn't quite it... Longness or shortness, I don't know. I got immense value out of both

Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Mark Swindell
Funny, this. Just the other day I came across the "cookbook" as a link in the Scripter's Conference stacks (a great, but also disjointed resource). I was impressed, and surprised that I had never seen it. Come to snoop a little deeper, and I discovered it was indeed a part of the docum

Re: Jeanne de Voto cookbook (was Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More))

2007-11-02 Thread Eric Chatonet
May be Jan Schenkel could have an idea? :-) Adobe products (Mac or PC) allow to search a pdf document and, for instance, searching for 'Array' in the pdf doc, the first entry displayed is 5.5.6 Special Variable Types page 120... So the problem is elsewhere: Probably most people need to be

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Richard Gaskin
Andre Garzia wrote: doesn't that function makes you loose markup that is not displayed by rev implementation of htmltext. For example, if you have tag that is not understood by htmltext, do you still get its content when querying the text of the field? Good question. I just opened up my teste

Re: Jeanne de Voto cookbook (was Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More))

2007-11-02 Thread Richard Gaskin
Devin Asay wrote: Oh, arrays were covered, alright. In the section called "Containers, variables, and sources of value". Nowadays, it's in the PDF manual, in section 5.5.7, page 123. But that's just the point, isn't it? I dug around awhile before I found it. Once I did, the information was

Re: Jeanne de Voto cookbook (was Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More))

2007-11-02 Thread Devin Asay
On Nov 2, 2007, at 10:14 AM, Björnke von Gierke wrote: I don't care much for the cookbook. However I really loved the "About" pages. Actually these where the single rreason why I became the Rev coder I am today. I personally prefer to learn stuff by association, and a single stop short (

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Eric Chatonet
Hi Richard, Thanks to you for sharing this code snippet from Ken: I was not using the field method (we discussed about this may be two years ago) because, if I remember well (but it's a bit confused in my mind), we found it had to be placed in a substack to avoid some problem I don't even r

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Andre Garzia
Richard, doesn't that function makes you loose markup that is not displayed by rev implementation of htmltext. For example, if you have tag that is not understood by htmltext, do you still get its content when querying the text of the field? I don't know... Andre On 11/2/07, Richard Gaskin <[E

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Jim Ault
On 11/2/07 3:42 AM, "Eric Chatonet" <[EMAIL PROTECTED]> wrote: > Hi Jim and Dave, > > Sorry I did not read this thread too much... > I should have :-) > > Not sure that I understand Dave's request because I have not read all > novels posted in this thread :-) > Probably, Jim makes an allusion t

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Richard Gaskin
Dave wrote: Yes, I'm sure thats the function we were talking about! Where can I get it from? I don't know where that one resides, but when I need to strip HTML tags from text I just set the htmlText of a field and then get the text of that field. Ken Ray recently discovered this works wit

Re: Jeanne de Voto cookbook (was Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More))

2007-11-02 Thread Björnke von Gierke
I don't care much for the cookbook. However I really loved the "About" pages. Actually these where the single rreason why I became the Rev coder I am today. I personally prefer to learn stuff by association, and a single stop short (sometimes not short enough) description about how exactly the

Re: Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Dave
Hi Eric, Yes, I'm sure thats the function we were talking about! Where can I get it from? Thanks a lot All the Best Dave On 2 Nov 2007, at 10:42, Eric Chatonet wrote: Hi Jim and Dave, Sorry I did not read this thread too much... I should have :-) Not sure that I understand Dave's request

Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Andre Garzia
The buried treasures of Revolution Documentation... After you master these, you can move to the secrets of undocumented calls and beyond! Cheers andre On 11/2/07, Eric Chatonet <[EMAIL PROTECTED]> wrote: > Hi Devin, > > LOL and LOL... > Actually Jeanne de Voto's cookbook is now the 'Sample script

Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Eric Chatonet
Hi Devin, LOL and LOL... Actually Jeanne de Voto's cookbook is now the 'Sample scripts' section of the 'Getting started' section of the docs. You are completely right. In addition, the Rev Search Engine is able to search this section and displays all sample scripts where a specified keyword

Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Devin Asay
On Nov 2, 2007, at 5:45 AM, Sarah Reichelt wrote: In a next version, I think of adding a Wikipedia search and convince Runrev to put back Jeanne de Voto cookbook, so valuable for beginners... Eric, I agree entirely. The cookbook was brilliant and should have been expanded instead of dropped

Re: Jeanne de Voto cookbook (was Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More))

2007-11-02 Thread Richard Gaskin
Eric Chatonet wrote: Actually I have already asked Mark Waddingham to put back the cookbook (or let me doing it :-) in the next release of Rev. I would like all of you who know this valuable stuff (that was shipped until Rev 2.5 AFAIK) to post their feeling about a possible 'come back' on t

Jeanne de Voto cookbook (was Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More))

2007-11-02 Thread Eric Chatonet
Hi Sarah and all, Actually I have already asked Mark Waddingham to put back the cookbook (or let me doing it :-) in the next release of Rev. I would like all of you who know this valuable stuff (that was shipped until Rev 2.5 AFAIK) to post their feeling about a possible 'come back' on this

Re: ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Sarah Reichelt
> In a next version, I think of adding a Wikipedia search and convince > Runrev to put back Jeanne de Voto cookbook, so valuable for beginners... Eric, I agree entirely. The cookbook was brilliant and should have been expanded instead of dropped. Cheers, Sarah

ABout the Rev Search Engine (was: Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Eric Chatonet
Hi all, The Rev Search Engine (that was first a plugin of mine named 'Resources Picker' prior Rev 2.7) is not easy to find unless you are curious enough to click on 'Search' (last button in Rev Docs tool bar) then explore it. The Rev Search Engine searches for information from 4 main sour

Stripping html tags (was Re: Problem with revExecuteSQL - More)

2007-11-02 Thread Eric Chatonet
Hi Jim and Dave, Sorry I did not read this thread too much... I should have :-) Not sure that I understand Dave's request because I have not read all novels posted in this thread :-) Probably, Jim makes an allusion to the StripTags function that is in the script of the unique card of the Rev

Re: Problem with revExecuteSQL - More

2007-11-02 Thread Dave
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

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Dave
Thanks a bunch, I've been working like a dog on this project and this is a major milestone. Cheers! Take Care Dave On 2 Nov 2007, at 01:03, Jim Ault wrote: On 11/1/07 4:27 PM, "Dave" <[EMAIL PROTECTED]> wrote: This is my main gripe with RunRev really. There are three features that I've used

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Dave
On 1 Nov 2007, at 23:43, Brian Yennie wrote: Dave, I feel your pain, but unfortunately I don't think it is possible for the Rev documentation to encompass all of the nuances of working with XML and databases. There are entire libraries dedicated to those subjects, and there are times whe

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Jim Ault
On 11/1/07 4:27 PM, "Dave" <[EMAIL PROTECTED]> wrote: > 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 r

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Brian Yennie
Dave, I feel your pain, but unfortunately I don't think it is possible for the Rev documentation to encompass all of the nuances of working with XML and databases. There are entire libraries dedicated to those subjects, and there are times when Rev will only be able to provide a bridge.

Re: Problem with revExecuteSQL - More

2007-11-01 Thread 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 wou

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Jim Ault
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 th

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Brian Yennie
Dave, I think all of these character set / UTF8 / shortened file path threads may be leading you on a wild goose chase. Certain characters must be escaped in XML, and ampersand is one of them. I believe you just need to unescape them. Check this page: http://www.asciitable.com/ & is just

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Martin Baxter
Hi Dave, Looks like at some point the ampersand is being converted to an entity reference of itself. ampersand is character number 38 The entity reference for that is & That means that the ampersand you see is no longer a literal character in this case, but indicates the beginning of a charact

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Ian Wood
On 1 Nov 2007, at 19:25, Dave wrote: 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 probl

Re: Problem with revExecuteSQL - More

2007-11-01 Thread 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

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Ian Wood
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 f

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Dave
On 1 Nov 2007, at 18:57, Jim Ault wrote: On 11/1/07 11:01 AM, "Dave" <[EMAIL PROTECTED]> wrote: This works ok with the addition of a line to check for embedded apostrophes: put replace(myText,"'","''") into myText However I now have a another weird problem, I have a field that represents a

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Jim Ault
On 11/1/07 11:01 AM, "Dave" <[EMAIL PROTECTED]> wrote: > This works ok with the addition of a line to check for embedded > apostrophes: > > put replace(myText,"'","''") into myText > > However I now have a another weird problem, I have a field that > represents a file path, in this case the path

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Dave
Hi, If I look at the folder in question in the finder is says "Blank & Jones", and if I select the file in iTunes and do a "Show File in Finder" then it takes me to the file ok. However, when I read the Database file the weird characters are present. At a Guess I'd say there was a non-sho

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Len Morgan
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

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Dave
Hi, This works ok with the addition of a line to check for embedded apostrophes: put replace(myText,"'","''") into myText 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

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Robert Eppich
Hi Dave, I am no pro at SQL, (just started 3 weeks ago with MS SQL Server), but it looks to me that your values are using quotation marks instead of apostrophes. Try something simple like the following: INSERT INTO MusicBase (AlbumName,AlbumRating) VALUES ('FINALLY', '0') hope this works f

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Len Morgan
I've been using various versions of SQL (Postgres, mySQL, Oracle, etc) for several years now and the only character I've ever been able to use to delimit strings is the apostrophe. As Jan recommended, try that first and you'll probably see most of your problems go away. BTW: having a " inside

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Jan Schenkel
--- Dave <[EMAIL PROTECTED]> wrote: > Hi Jan, > > Thanks a lot, yes, a great help, Where exactly did > you see the > description of how to do this in the SQLite docs? I > had a quick look > again but still couldn't find it! > > Thanks again > All the Best > Dave > Hi Dave, And we're back t

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Dave
Hi Jan, Thanks a lot, yes, a great help, Where exactly did you see the description of how to do this in the SQLite docs? I had a quick look again but still couldn't find it! Thanks again All the Best Dave On 1 Nov 2007, at 09:27, Jan Schenkel wrote: --- Dave <[EMAIL PROTECTED]> wrote: H

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Jan Schenkel
--- Dave <[EMAIL PROTECTED]> wrote: > Hi, > > I am using SQLIte, I can't seem to find anything > that says what the > escape sequence character is. Does anyone know if > this is possible > with SQLite? > > Also, is this the same problem that I am getting > with the ":" > characters in the d

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Dave
Hi, I am using SQLIte, I can't seem to find anything that says what the escape sequence character is. Does anyone know if this is possible with SQLite? Also, is this the same problem that I am getting with the ":" characters in the date field? If so, is the solution the same? Thanks a l

Re: Problem with revExecuteSQL - More

2007-11-01 Thread Jan Schenkel
--- Dave <[EMAIL PROTECTED]> wrote: > Hi, > > I am also getting an [unrecognized token: "") "] > error, in this case > this is the string I pass in: > > [snip] > > Thanks a lot > All the Best > Dave > Hi Dave, Looking at your query, I'd say the following string is the culprit: "Finally

Problem with revExecuteSQL - More

2007-10-31 Thread Dave
Hi, I am also getting an [unrecognized token: "") "] error, in this case this is the string I pass in: INSERT INTO MusicBase (AlbumName,AlbumRating,AlbumRatingKind,ArtistName,BitRate,BPM,DateAdded, Duration,FileLocation,FileSizeBytes,Genre,ModDate,PlayedCount,PlayedDate ,SampleRate,Track