Update database on server
I have some software that I hope to distribute at some point and am trying to figure how how to develop the last piece. While the user(s) is working with the software, it collects information which I will use to further enhance the software in future updates. The information is not a large amount of data (approx. 0 - 1000 characters of data). What I need to do is upload the data to either a MySQL database or as text files in a folder on the server. The update would be done when the user quits the software. I am looking for any suggestions on the best way to do this as I have some concerns/questions: 1) MySQL database or FTP text files to a folder (I can easily process the data either way)? 2) Is there the potential of uploads being blocked by firewalls on the users machine? If so...how could I avoid this? By the way...I am using RR v4.0 Thanks for any suggestions! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
MatchText
What is the syntax of the matchtext command to search a variable for multiple characters (".", "!" or "?"). If it contains any characters in my list, it returns a TRUE? I am able to get it working with one value... answer MatchText(tValue,"(\.)") Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cursor Position Within A Field
Thanks Klaus! On Wed, Oct 6, 2010 at 12:51 PM, Klaus on-rev wrote: > Hi Warren, > > > Is there a command that tells me the character position of the where the > > cursor is located in a field? > > see "selectedchunk" in the dictionary, that is what you are looking for. > > > Also..is there a command that allows me to specify a character position > to > > change the cursor position within a field? > > ... > select after char 2 of fld 1 > .. > will do :-) > > > Thanks, > > Warren > > Best > > Klaus > > -- > Klaus Major > http://www.major-k.de > kl...@major.on-rev.com > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cursor Position Within A Field
Jonathan, Thank you...this is exactly what I was looking for. Appreciate it! Warren On Wed, Oct 6, 2010 at 12:50 PM, Jonathan Lynch wrote: > check out Select and SelectedChunk > > On Wed, Oct 6, 2010 at 1:37 PM, Warren Kuhl wrote: > > > Is there a command that tells me the character position of the where the > > cursor is located in a field? > > > > Also..is there a command that allows me to specify a character position > to > > change the cursor position within a field? > > > > Thanks, > > Warren > > ___ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > -- > Do all things with love > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Cursor Position Within A Field
Is there a command that tells me the character position of the where the cursor is located in a field? Also..is there a command that allows me to specify a character position to change the cursor position within a field? Thanks, Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: SelectedChunk
Mike, You have saved me lots of brainstorming. This forum post should work for what I am doing. Thanks again! Warren On Mon, Sep 27, 2010 at 10:10 AM, Mike Bonner wrote: > http://forums.runrev.com/phpBB2/viewtopic.php?f=7&t=3199 > > Not the post I was thinking of, but some really useful stuff in that forum > thread about whole word selections. > > On Mon, Sep 27, 2010 at 9:05 AM, Warren Kuhl wrote: > > > Mike, > > > > Thank you very much. You have been most helpful! > > > > All the best! > > Warren > > > > On Mon, Sep 27, 2010 at 10:03 AM, Mike Bonner > wrote: > > > > > Would have to program it, and now that i'm more awake, not sure you > need > > to > > > go through all the convoluted stuff I did. > > > > > > This is probably closer to what you can end up with. > > > on mouseUp > > > put word 2 of the selectedchunk into tChar > > > put char 1 to tChar of field 1 into tTmp > > > put the number of words in tTmp > > > end mouseUp > > > > > > This will work with the exception that if your selection includes a > space > > > at > > > the left the wordcount will be off by 1, so you'd have to test and > decide > > > how you want it to behave in that situation. Will also have to test > for > > a > > > simple insertion point rather than a selection also and adjust > > accordingly. > > > > > > > > > To force full word selections, I believe one of the Marks posted > > something > > > a > > > not too long ago that would do this... The gist of the script (If I > > recall > > > correctly) was that when a selection is made, you check for word > > boundaries > > > to the right and left and adjust the selection accordingly. > > > Once you have your char positions you can set the selection. > > > > > > select char 5 to 12 of field "yourfield" > > > > > > I haven't actually tried the forced selection part. > > > > > > G'luck with all this. If I can locate the script I'm trying to > remember, > > > i'll post a link. > > > > > > > > > > > > On Mon, Sep 27, 2010 at 8:40 AM, Warren Kuhl > > wrote: > > > > > > > Mike, > > > > > > > > Thank you very much for this. I really appreciate it. Looks exactly > > > like > > > > what I was looking for. > > > > > > > > You mentioned forcing only whole words. Is this a command? Or > > something > > > I > > > > would need to program? > > > > > > > > Thanks again! > > > > Warren > > > > > > > > > > > > > > > > > > > > On Mon, Sep 27, 2010 at 9:21 AM, Mike Bonner > > wrote: > > > > > > > > > I'm positive this can be shortened, but as is should do what you > > want. > > > It > > > > > could be simplified greatly of course if you are forcing only whole > > > word > > > > > selections, but this will account for partial word selects, and > also > > > just > > > > > an > > > > > insertion point. > > > > > * > > > > > on mouseUp > > > > > -- Determine if there is actually a selection of more than 1 char > > > > > if word 2 of the selectedchunk - word 4 of the selectedchunk < 0 > > then > > > > > put word 2 of the selectedchunk into tChar > > > > > else > > > > > put word 4 of the selectedchunk into tChar > > > > > end if > > > > > > > > > > -- Determine if the selection is already on a word boundary. > > > > > --if so determine which word the break is at. > > > > > if char tChar of field 1 is space then > > > > > put true into tCharMatch > > > > > put char 1 to tChar of field 1 into tTmp > > > > > put"Word: " & the number of words in tTmp + 1 into tWord > > > > > end if > > > > > > > > > > -- if a match hasn't been found yet, and we're not at the field > > start > > > > > -- nudge 1 char left and check for word break. Repeat until top > of > > > > field > > > > > or match > > > > > repeat while tChar > 1 and tCharMatch is empty > > > >
Re: SelectedChunk
Mike, Thank you very much. You have been most helpful! All the best! Warren On Mon, Sep 27, 2010 at 10:03 AM, Mike Bonner wrote: > Would have to program it, and now that i'm more awake, not sure you need to > go through all the convoluted stuff I did. > > This is probably closer to what you can end up with. > on mouseUp > put word 2 of the selectedchunk into tChar > put char 1 to tChar of field 1 into tTmp > put the number of words in tTmp > end mouseUp > > This will work with the exception that if your selection includes a space > at > the left the wordcount will be off by 1, so you'd have to test and decide > how you want it to behave in that situation. Will also have to test for a > simple insertion point rather than a selection also and adjust accordingly. > > > To force full word selections, I believe one of the Marks posted something > a > not too long ago that would do this... The gist of the script (If I recall > correctly) was that when a selection is made, you check for word boundaries > to the right and left and adjust the selection accordingly. > Once you have your char positions you can set the selection. > > select char 5 to 12 of field "yourfield" > > I haven't actually tried the forced selection part. > > G'luck with all this. If I can locate the script I'm trying to remember, > i'll post a link. > > > > On Mon, Sep 27, 2010 at 8:40 AM, Warren Kuhl wrote: > > > Mike, > > > > Thank you very much for this. I really appreciate it. Looks exactly > like > > what I was looking for. > > > > You mentioned forcing only whole words. Is this a command? Or something > I > > would need to program? > > > > Thanks again! > > Warren > > > > > > > > > > On Mon, Sep 27, 2010 at 9:21 AM, Mike Bonner wrote: > > > > > I'm positive this can be shortened, but as is should do what you want. > It > > > could be simplified greatly of course if you are forcing only whole > word > > > selections, but this will account for partial word selects, and also > just > > > an > > > insertion point. > > > * > > > on mouseUp > > > -- Determine if there is actually a selection of more than 1 char > > > if word 2 of the selectedchunk - word 4 of the selectedchunk < 0 then > > > put word 2 of the selectedchunk into tChar > > > else > > > put word 4 of the selectedchunk into tChar > > > end if > > > > > > -- Determine if the selection is already on a word boundary. > > > --if so determine which word the break is at. > > > if char tChar of field 1 is space then > > > put true into tCharMatch > > > put char 1 to tChar of field 1 into tTmp > > > put"Word: " & the number of words in tTmp + 1 into tWord > > > end if > > > > > > -- if a match hasn't been found yet, and we're not at the field start > > > -- nudge 1 char left and check for word break. Repeat until top of > > field > > > or match > > > repeat while tChar > 1 and tCharMatch is empty > > > subtract 1 from tChar > > > if char tChar of field 1 is space then > > > put true into tCharMatch > > > put char 1 to tChar of field 1 into tTmp > > > put "Word: " & the number of words in tTmp + 1 into tWord > > > else if tChar = 0 then > > > --if we reach the start of the field, must be the first word > > > put "Word: 1" into tWord > > > end if > > > end repeat > > > > > > answer information tWord > > > end mouseUp* > > > > > > On Mon, Sep 27, 2010 at 7:17 AM, Warren Kuhl > > wrote: > > > > > > > Is there an easy way to retrieve the word # of a field based on the > > > > SelectedChunk? The SelectedChunk contains the start/end position of > a > > > word > > > > of a field. Just am trying to determine which word without to much > > > > coding...if possible. > > > > > > > > Thanks for any help! > > > > Warren > > > > ___ > > > > use-revolution mailing list > > > > use-revolution@lists.runrev.com > > > > Please visit this url to subscribe, unsubscribe and manage your > > > > subscription preferences: > > > > http://lists.runrev.com/mailman/li
Re: SelectedChunk
Mike, Thank you very much for this. I really appreciate it. Looks exactly like what I was looking for. You mentioned forcing only whole words. Is this a command? Or something I would need to program? Thanks again! Warren On Mon, Sep 27, 2010 at 9:21 AM, Mike Bonner wrote: > I'm positive this can be shortened, but as is should do what you want. It > could be simplified greatly of course if you are forcing only whole word > selections, but this will account for partial word selects, and also just > an > insertion point. > * > on mouseUp > -- Determine if there is actually a selection of more than 1 char > if word 2 of the selectedchunk - word 4 of the selectedchunk < 0 then > put word 2 of the selectedchunk into tChar > else > put word 4 of the selectedchunk into tChar > end if > > -- Determine if the selection is already on a word boundary. > --if so determine which word the break is at. > if char tChar of field 1 is space then > put true into tCharMatch > put char 1 to tChar of field 1 into tTmp > put"Word: " & the number of words in tTmp + 1 into tWord > end if > > -- if a match hasn't been found yet, and we're not at the field start > -- nudge 1 char left and check for word break. Repeat until top of field > or match > repeat while tChar > 1 and tCharMatch is empty > subtract 1 from tChar > if char tChar of field 1 is space then > put true into tCharMatch > put char 1 to tChar of field 1 into tTmp > put "Word: " & the number of words in tTmp + 1 into tWord > else if tChar = 0 then > --if we reach the start of the field, must be the first word > put "Word: 1" into tWord > end if > end repeat > > answer information tWord > end mouseUp* > > On Mon, Sep 27, 2010 at 7:17 AM, Warren Kuhl wrote: > > > Is there an easy way to retrieve the word # of a field based on the > > SelectedChunk? The SelectedChunk contains the start/end position of a > word > > of a field. Just am trying to determine which word without to much > > coding...if possible. > > > > Thanks for any help! > > Warren > > ___ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
SelectedChunk
Is there an easy way to retrieve the word # of a field based on the SelectedChunk? The SelectedChunk contains the start/end position of a word of a field. Just am trying to determine which word without to much coding...if possible. Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Valentina Help
Mark, It looks like the log is telling (from what I can tell) that a record is written...but there is no data being written in my table. I manually added 7 records to the table, so I am assuming that the.. VTable_AddRecord... PARAM: tblRef = "135884248" return res = 8 ...is telling me record number 8 has been added? I am looking at the file in Valentina Studio and refreshed, closed, etc and it is not added. Warren Valentina_DebugLevel... PARAM: inLevel = "kLogParams" return VDatabase_Constructor... PARAM: inEnumStorageType = "0" return revDb = 48040944 VDatabase_Open... PARAM: dbRef = "48040944" PARAM: inStrPath = "C:/Users/Warren/Desktop/NewSpinner/Database/Spinnables.vdb" return VDatabase_Table... PARAM: dbRef = "48040944" PARAM: inIntIndexOrStrName = "Spinnables" return res = 135884248 VTable_SetBlank... PARAM: tblRef = "135884248" return VTable_Field... PARAM: tblRef = "135884248" PARAM: inIntIndexOrStrName = "Keyword1" return res = 135815896 VTable_Field... PARAM: tblRef = "135884248" PARAM: inIntIndexOrStrName = "Term1" return res = 135816128 VField_Value... PARAM: fldRef = "135815896" PARAM: inStrValue = "999" return VField_Value... PARAM: fldRef = "135816128" PARAM: inStrValue = "999" return VTable_AddRecord... PARAM: tblRef = "135884248" return res = 8 On Tue, Sep 21, 2010 at 5:48 PM, Mark Schonewille < m.schonewi...@economy-x-talk.com> wrote: > Hi Warren, > > I don't see any obvious mistakes in your script. Perhaps you need to use a > variable instead of a value. > > put "test" into myVar > get VField_Value( f1, myVar ) > > You might want to post the script that reads the record from the database. > Are you sure that you closed the database when you accessed it previously? > Is the database in a writable location? > > -- > Best regards, > > Mark Schonewille > > Economy-x-Talk Consulting and Software Engineering > Homepage: http://economy-x-talk.com > Twitter: http://twitter.com/xtalkprogrammer > KvK: 50277553 > > Download the Installer Maker plugin for Runtime Revolution at > http://qurl.tk/ce > Create installers for Mac and Windows on *every* Rev-compatible platform. > No additional software needed. > > On 22 sep 2010, at 00:05, Warren Kuhl wrote: > > > I just purchased Valentina ADK and am trying what I thought was a simple > > example but can't seem to grasp the concept. Hopefully someone can help > who > > is familar with Valentina. I am sure Valentina is a great product...but > the > > support and the documentation for the RunRev version leaves a lot to be > > desired. > > > > On the card, I have the following... > > > > on OpenCard > > get Valentina_Init( 10 * 1024 * 1024,"","(serial number)","" ) > > end OpenCard > > > > on CloseCard > > get Valentina_ShutDown > > end CloseCard > > > > I created a button to just try to write a record to a database that > already > > exists. I just can't get any data written to the database. Is there > > anything obvious I am missing? I am getting numeric values in the > variables > > mDatabase, tblSpin, and f1 and f2 so I assume something is working...just > no > > data in my table. Thanks for any help! > > > > on mouseUp > > > > put VDatabase_Constructor() into mDatabase > > get the effective filename of this stack > > set the itemDel to slash > > put the (item 1 to -2 of it) & slash & "Database/Spinnables.vdb" into > dbPath > > > > > > get VDatabase_Open( mDatabase, dbPath ) > > put VDatabase_Table( mDatabase, "Spinnables" ) into tblSpin > > > > get VTable_SetBlank(tblSpin) > > > > put VTable_Field( tblSpin, "Keyword1" ) into f1 > > put VTable_Field( tblSpin, "Term1" ) into f2 > > > > get VField_Value( f1, "test" ) > > get VField_Value( f2, "test" ) > > > > get VTable_AddRecord(tblSpin) > > > > end mouseUp > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Valentina Help
I just purchased Valentina ADK and am trying what I thought was a simple example but can't seem to grasp the concept. Hopefully someone can help who is familar with Valentina. I am sure Valentina is a great product...but the support and the documentation for the RunRev version leaves a lot to be desired. On the card, I have the following... on OpenCard get Valentina_Init( 10 * 1024 * 1024,"","(serial number)","" ) end OpenCard on CloseCard get Valentina_ShutDown end CloseCard I created a button to just try to write a record to a database that already exists. I just can't get any data written to the database. Is there anything obvious I am missing? I am getting numeric values in the variables mDatabase, tblSpin, and f1 and f2 so I assume something is working...just no data in my table. Thanks for any help! on mouseUp put VDatabase_Constructor() into mDatabase get the effective filename of this stack set the itemDel to slash put the (item 1 to -2 of it) & slash & "Database/Spinnables.vdb" into dbPath get VDatabase_Open( mDatabase, dbPath ) put VDatabase_Table( mDatabase, "Spinnables" ) into tblSpin get VTable_SetBlank(tblSpin) put VTable_Field( tblSpin, "Keyword1" ) into f1 put VTable_Field( tblSpin, "Term1" ) into f2 get VField_Value( f1, "test" ) get VField_Value( f2, "test" ) get VTable_AddRecord(tblSpin) end mouseUp ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Valentina ADK
I just purchased the Valentina ADK and am having a heck of a time trying to write records to a table. I created the database and and table in Valentina...just not exactly sure how to write to the table. I tried following the supplied examples but for some reason I just can't grasp the concept. Are there any good examples/tutorials outside of what was supplied with the software that anyone can point me too? Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Server Side Database Advice
I am developing software that needs to pass information to a centralized MySQL database. My current host started blocking connections as they said the MySQL database was for web applications only and had an issue with updating it with an application. Plus they only allowed a few concurrent connections. Anyone have any advice as to how I should handle this or experience with a host that didn't have any issues with this? Thanks! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Resizing Stack
Craig, Thank you very much for the advice. You really helped me as I was trying to determine if there was a combination of geometry manager and programming to accomplish this. I will focus on the resizestack message and follow your advice. This seems a lot easier with your explanation. Appreciate you taking the time to help me. Much appreciated! Warren On Wed, Sep 15, 2010 at 9:46 PM, wrote: > I have never used the geometry manager. This is supposed to do exactly what > you asked. > > But it would be better to do it the old fashioned way, just to practice > using Rev. Let's say that your text field is one quarter the height and > three > quarters the width of your stack. Trap the "resizeStack" message. Get the > height and width of the new stack and set those properties of your field by > scaling accordingly. Now do it with a custom property. Or yet another way. > Simple and fun. > > If your field has a fixed topLeft, set that, too. If not, scale it in the > same way. > > Read about the "resizeStack" message. There is, I have found, a message, > property or function that seems to do exactly what you need to get a job > done. > This is because Rev has just about everything imaginable. The hard part is > finding these goodies. You need to learn to do this, and pay special > attention to the "see also" stuff when you attempt search. In this case, > you might > have tried "resize". That would lead you quickly to the right place. But > even if you searched "stack" or "size", you still would have found the > right > message. This is an art, just like searching Google. You get good at it > after > a while. > > The alternative is to learn, and remember, the entire dictionary. Good > luck. > > Craig Newman > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Resizing Stack
I have a text field on a stack that I want the size to increase/decrease based on the size of the stack changing. Can I do this with the geometry properties on my text field alone? Or is there more too this? I am trying to grasp the concept of the resizing concept and still don't have it figured out. Basically I want my text field to resize proportionate to the size of the stack. I have read the user manual and am still confused. Any direction greatly appreciated! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Card Question
Klaus/Richard, Thanks for your help. This worked exactly as I was hoping. Warren On Sun, Sep 12, 2010 at 11:45 AM, Richard Gaskin wrote: > Warren Kuhl wrote: > >> Is there a way to open a stack without the title bar? Basically the card >> should be a square box. Currently the stack is opened as modeless. >> > > set the decorations of stack "StackName" to none > > See the Dictionary entry for the decorations stack property for details. > > -- > Richard Gaskin > Fourth World > Rev training and consulting: http://www.fourthworld.com > Webzine for Rev developers: http://www.revjournal.com > revJournal blog: http://revjournal.com/blog.irv > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Card Question
Is there a way to open a stack without the title bar? Basically the card should be a square box. Currently the stack is opened as modeless. Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: lineoffset Command
Richard/Hugh, Thanks for the suggestions. I will give it a try! Warren On Sat, Sep 11, 2010 at 1:30 PM, FlexibleLearning < ad...@flexiblelearning.com> wrote: > Warren Kuhl wrote: > > > I am using the lineoffset to search through a large number of lines > (approx > > 40,000). My problem is I want to do a search where I return the line # > if > > the string is the whole line and not just a subset. Can this be done > with > > the lineoffset? If not, what would be my best option for efficiency? > > > > Richard supplied: > > Add this before your call to lineOffset: > > > > set the wholeMatches to true > > Alternative: > get lineOffset(CR&tString&CR,CR&tList&CR) > > Can be useful as it explicitly specifies the match typing within the > syntax. > > Hugh > FLCo > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
lineoffset Command
I am using the lineoffset to search through a large number of lines (approx 40,000). My problem is I want to do a search where I return the line # if the string is the whole line and not just a subset. Can this be done with the lineoffset? If not, what would be my best option for efficiency? Thanks, Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Hilite Text
Mark, Thanks...that will work me me. Apprecaite your help! Warren On Thu, Sep 9, 2010 at 1:10 PM, Mark Schonewille < m.schonewi...@economy-x-talk.com> wrote: > Hi Warren, > > You can't select mutiple areas in a text, unless the field is a list field. > Surely, you can set the textStyle of the selectedChunk. For example > something like > > set the backgroundcolor of the selectedChunk to red > > -- > Best regards, > > Mark Schonewille > > Economy-x-Talk Consulting and Software Engineering > Homepage: http://economy-x-talk.com > Twitter: http://twitter.com/xtalkprogrammer > KvK: 50277553 > > Download the Installer Maker plugin for Runtime Revolution at > http://qurl.tk/ce Create installers for Mac and Windows on *every* > Rev-compatible platform. No additional software needed. > > On 9 sep 2010, at 20:02, Warren Kuhl wrote: > > > Is there anyway to hilite/dehilite (or reverse selection) multiple areas > of > > a text area? I was hoping I could use textstyle, but this doesn't see > like > > an option. > > * > > > > set* the textstyle of selectedChunk() to ? > > > > Warren > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Closing Substack With Mouse Click
Klaus, Perfect...this worked great. Thanks for your help! Warren On Thu, Sep 9, 2010 at 12:54 PM, Klaus on-rev wrote: > Hi Warren, > > > What would be the best method to close a substack if I click a mouse > button > > anywhere outside of the substack card? > > put this into the stack script > > on suspendstack > close this stack > end suspendstack > > Hm, on the second thought I would rather: > > on suspendstack > if the environment <> "development" then close this stack > end suspendstack > > :-) > > > Warren > > Best > > Klaus > > -- > Klaus Major > http://www.major-k.de > kl...@major.on-rev.com > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Hilite Text
Is there anyway to hilite/dehilite (or reverse selection) multiple areas of a text area? I was hoping I could use textstyle, but this doesn't see like an option. * set* the textstyle of selectedChunk() to ? Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Closing Substack With Mouse Click
What would be the best method to close a substack if I click a mouse button anywhere outside of the substack card? Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Selected Text
Jonathan, No I have not. In fact...I never even heard of this until now. Thanks for the suggestion I will look into this as well. Appreciate it! Warren On Tue, Sep 7, 2010 at 1:57 PM, Jonathan Lynch wrote: > Have you explored the selectionchanged message? > > For one of my applications, I use this for detecting clicks inside unlocked > fields. > > On Tue, Sep 7, 2010 at 2:52 PM, Warren Kuhl wrote: > > > Mark, > > > > Thanks for the explanation. It really gaves me a good understand with > how > > the process works. I will see if I can lock/unlock the field as > necessary > > as the user needs to ability to change the text. > > > > Appreciate your help! > > Warren > > > > On Tue, Sep 7, 2010 at 1:38 PM, Mark Schonewille < > > m.schonewi...@economy-x-talk.com> wrote: > > > Hi Warren, > > > > > > It looks like the problem is not the selectedText but the mouseUp > > message. > > Unlocked fields don't receive a mouseUp message when the user clicks in > > such > > a field, but control-click and command-click do trigger a mouseUp > message. > > So, either you have to provide a way to lock and unlock the field as > > necessary or you need to tell the user that control-click or > command-click > > will allow him or her to edit or process selected text. > > > > > > You can't have a field editable without allowing the user to drag text > > around, but you can allow the user to select text without making the > field > > editable. If you lock the text but don't turn off the traversalOn, then > the > > text will be selectable but not editable. Or don't you want the user to > be > > able to select text? In this case, turn off the traversalOn too. > > > > > > If the lockText of a field is true and the traversalOn is tru too, you > > will be able to click in a field and trigger the mouseUp message that > way, > > without pressing the command or control key. > > > > > > -- > > > Best regards, > > > > > > Mark Schonewille > > > > > > Economy-x-Talk Consulting and Software Engineering > > > Homepage: http://economy-x-talk.com > > > Twitter: http://twitter.com/xtalkprogrammer > > > KvK: 50277553 > > > > > > Download the Installer Maker plugin for Runtime Revolution at > > http://qurl.tk/ce Create installers for Mac and Windows on *every* > > Rev-compatible platform. No additional software needed. > > > > > > On 7 sep 2010, at 19:59, Warren Kuhl wrote: > > > > > >> 1) I am trying to return the selected text in a field. It looks like > > >> this can only be done on locked text. Is there anyway around this? > > >> > > >> In the field I am trying: > > >> > > >> on mouseup > > >> answer selectedtext() > > >> end mouseup > > >> > > >> The above is only true when the field is locked. > > >> > > >> 2) Also...how do I prevent text to be dragable in a field? > > >> > > >> Thanks for any help! > > >> > > >> Warren > > > > > > > > > ___ > > > use-revolution mailing list > > > use-revolution@lists.runrev.com > > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > ___ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > -- > Do all things with love > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Selected Text
Mark, Thanks for the explanation. It really gaves me a good understand with how the process works. I will see if I can lock/unlock the field as necessary as the user needs to ability to change the text. Appreciate your help! Warren On Tue, Sep 7, 2010 at 1:38 PM, Mark Schonewille < m.schonewi...@economy-x-talk.com> wrote: > Hi Warren, > > It looks like the problem is not the selectedText but the mouseUp message. Unlocked fields don't receive a mouseUp message when the user clicks in such a field, but control-click and command-click do trigger a mouseUp message. So, either you have to provide a way to lock and unlock the field as necessary or you need to tell the user that control-click or command-click will allow him or her to edit or process selected text. > > You can't have a field editable without allowing the user to drag text around, but you can allow the user to select text without making the field editable. If you lock the text but don't turn off the traversalOn, then the text will be selectable but not editable. Or don't you want the user to be able to select text? In this case, turn off the traversalOn too. > > If the lockText of a field is true and the traversalOn is tru too, you will be able to click in a field and trigger the mouseUp message that way, without pressing the command or control key. > > -- > Best regards, > > Mark Schonewille > > Economy-x-Talk Consulting and Software Engineering > Homepage: http://economy-x-talk.com > Twitter: http://twitter.com/xtalkprogrammer > KvK: 50277553 > > Download the Installer Maker plugin for Runtime Revolution at http://qurl.tk/ce Create installers for Mac and Windows on *every* Rev-compatible platform. No additional software needed. > > On 7 sep 2010, at 19:59, Warren Kuhl wrote: > >> 1) I am trying to return the selected text in a field. It looks like >> this can only be done on locked text. Is there anyway around this? >> >> In the field I am trying: >> >> on mouseup >> answer selectedtext() >> end mouseup >> >> The above is only true when the field is locked. >> >> 2) Also...how do I prevent text to be dragable in a field? >> >> Thanks for any help! >> >> Warren > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Selected Text
1) I am trying to return the selected text in a field. It looks like this can only be done on locked text. Is there anyway around this? In the field I am trying: on mouseup answer selectedtext() end mouseup The above is only true when the field is locked. 2) Also...how do I prevent text to be dragable in a field? Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Revolution Enterprise - Encrypt
Perfect...thanks for all the help. This is the route I will take. Appreciate it! Warren On Sat, Sep 4, 2010 at 11:45 AM, Mark Schonewille wrote: > Hi Warren, > > Sure, you can do this. Since the encrypted data would be binary, you probably > will want to encode it using the base64encode function before writing it to > the database. > > -- > Best regards, > > Mark Schonewille > > Economy-x-Talk Consulting and Software Engineering > Homepage: http://economy-x-talk.com > Twitter: http://twitter.com/xtalkprogrammer > KvK: 50277553 > > From 15th August, we'll have time for new projects! Be the first in line and > contact me now! > > Download the Installer Maker plugin for Runtime Revolution at > http://qurl.tk/ce > > On 4 sep 2010, at 18:38, Warren Kuhl wrote: > >> With the encrypt command with Enterprise, would I be able to encrypt >> data that I write to SQLite and decrypt it when retrieving it? I just >> have Studio (so I can't test ths) but would upgrade if this was the >> case. >> >> Thanks, >> Warren > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Revolution Enterprise - Encrypt
With the encrypt command with Enterprise, would I be able to encrypt data that I write to SQLite and decrypt it when retrieving it? I just have Studio (so I can't test ths) but would upgrade if this was the case. Thanks, Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: SQLite Database
Monte, I thanks for the advice. $2000 is a little steep. I may loook at writing an encryption/decrypt module for my data and decrpyt it after retrieving it from the database. Thanks! Warren On Sat, Sep 4, 2010 at 2:58 AM, Monte Goulding wrote: > Not without writing a new db driver I wouldn't think. From memory there is an > encrypted version of sqlite with a $2000 license fee. If you don't need it to > be ultra secure then you could store your db in a custom property of an > encrypted stack and save it to a hidden file at startup, save it back to your > encrypted stack at shutdown and delete the hidden file. Anyone that knows > it's a rev stack could open the file in rev, copy out the db file and see > your data though. > > Cheers > > Monte > On 04/09/2010, at 3:56 PM, Warren Kuhl wrote: > >> Is there anyway to encrypt a SQLite database that I can use in >> Revolution Studio? >> >> Thanks for any suggestions! >> Warren >> ___ >> use-revolution mailing list >> use-revolution@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
SQLite Database
Is there anyway to encrypt a SQLite database that I can use in Revolution Studio? Thanks for any suggestions! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Password Protect Folder
I am trying to password protect a folder...where it is visible (and accessible) only when activated by Revolution. Is this possible with Revolution? Thanks, Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Check If URL Is Valid
Colin, I did use code similar to what you and Jeff recommended below and it is working great for my purposes. Colin/Jeff...Thanks again for all your help! Warren On Sun, Aug 8, 2010 at 1:07 PM, Colin Holgate wrote: > > On Aug 8, 2010, at 1:28 PM, Warren Kuhl wrote: > >> The websites I are checking do not redirect so this is working >> perfect. Thanks for all your help! > > > That's good. Given a choice, I would go with the way Jeff was suggesting: > > get url "some maybe valid url" > > if the result is not empty then > --something went wrong > end if > > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Check If URL Is Valid
Colin/Jeff, The websites I are checking do not redirect so this is working perfect. Thanks for all your help! Warren On Sun, Aug 8, 2010 at 12:23 PM, Colin Holgate wrote: > > On Aug 8, 2010, at 12:49 PM, Jeff Massung wrote: > >> I believe "the result" of your get will have an error message in it if the >> URL doesn't exist. Otherwise the result is empty. > > > It does indeed contain: > > error 404 Not Found > > but it has the same limitation I mentioned, if you try a nonexistent page > that redirects successfully, the result will still be empty. > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Check If URL Is Valid
Thanks Colinthis is a great start. Appreciate it! Warren On Sun, Aug 8, 2010 at 11:37 AM, Colin Holgate wrote: > > On Aug 8, 2010, at 12:19 PM, Warren Kuhl wrote: > >> I need to check if a URL is valid and receive notification for invalid >> URLs. I don't want my program to open any browswers when checking. Is >> this possible? > > In some cases it is. If the page you try to access doesn't exist, but the > server traps for that, then it's harder to tell. Try these in the message box > to see the difference: > > put url "http://www.runrev.com/"; contains "404 Not Found" > > put url "http://www.runrevv.com/"; contains "404 Not Found" > > put url "http://www.runrev.com/abcdefg.html"; contains "404 Not Found" > > The first and third ones show "false", and the middle one "true". Although > the third one returns false, the page doesn't really exist, but runrev.com > handles that and redirects you to another page. > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Check If URL Is Valid
I need to check if a URL is valid and receive notification for invalid URLs. I don't want my program to open any browswers when checking. Is this possible? Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Reading/Deleting Last Line Of File
Thanks for all the suggestions. I will look into trying some of them to see what works best for me. The file currently contains 105,750,304 records. I will report back my findings. Thanks, Warren On Tue, Feb 9, 2010 at 11:58 PM, J. Landman Gay wrote: > Jim Bufalini wrote: >> >> Jacque wrote: >> >>> Worth a test anyway. I've used it on files that were several megs in >>> size without a problem, but they weren't super huge, just kinda big. >> >> Hi Jacque, I made the suggestion I did because at 100 Million records plus > > 100 million? Yes, well...I think I read the zeros wrong. > > -- > Jacqueline Landman Gay | jac...@hyperactivesw.com > HyperActive Software | http://www.hyperactivesw.com > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Reading/Deleting Last Line Of File
Jim, Thanks for the explanationI will give this a try. Thanks! Warren On Tue, Feb 9, 2010 at 9:08 AM, Jim Bufalini wrote: > Warren, > >> I will give this a try. I was trying to go down the same path by >> getting the number of records of the file...then trying to determine >> if I could just read the last line and removing the EOF. Is there >> anyway to specifiy a READ to a certain line of a file without reading >> through the whole file? > > The read from file command allows you start at a character offset and then > read to a string, or for a number of bytes/chars/words/items (see > dictionary) or to EOF. The write command will replace from the starting > character offset and move the EOF for you. So, in your case, I don't think > you have to be exact in your read. Just read in close to the end to EOF and > write from the same offset and let the write command handle the EOF for you. > > Aloha from Hawaii, > > Jim Bufalini > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Reading/Deleting Last Line Of File
Jim, I will give this a try. I was trying to go down the same path by getting the number of records of the file...then trying to determine if I could just read the last line and removing the EOF. Is there anyway to specifiy a READ to a certain line of a file without reading through the whole file? Warren On Tue, Feb 9, 2010 at 8:34 AM, Jim Bufalini wrote: > Warren, > >> I have a large text file (100,000,000+ records). I need to write a >> utility that removes the last record of the file. Is there anyway to >> just remove the last record without reading through the complete file >> with RunRev? > > This is totally untested but "logically" you could: > > 1. First get the size of the file on disk and approximate a character offset > that should be only a few lines from the end of the file. > > 2. Then Open the file for read and read from file starting at the char > offset you calculated to EOF into a var and delete the last line of the var. > > > 3. Then Close the file and Open it again for write. > > 4. Now write the var to file at the same starting offset you read from. > > The reason you don't use open for update is that you want to open the file > for write, so that whatever you write to the file replaces everything from > the offset to the EOF. Update will replace chars and leave the last record > at the end. > > What I don't know here is if internally the read/write from file at start > still has to go through the entire file to calculate the starting offset, so > I don't know how long this will take on a file of your size. But, at least, > doing it this way won't require reading the whole file into memory and > should result in the last line being deleted from the file in the quickest > way available. > > Aloha from Hawaii, > > Jim Bufalini > > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Reading/Deleting Last Line Of File
I have a large text file (100,000,000+ records). I need to write a utility that removes the last record of the file. Is there anyway to just remove the last record without reading through the complete file with RunRev? Thanks, Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: HTML Editor
Stephen, I was also looking into this. I actually decided to write one myself as I need a very basic editor. Warren On Mon, Jan 25, 2010 at 12:37 PM, stephen barncard wrote: > CK Editor won't work in revbrowser? > > > - > Stephen Barncard > San Francisco > http://houseofcubes.com/disco.irev > > > 2010/1/25 Warren Kuhl > >> I am looking for a WYSIWYG HTML editor I can attach to a text field >> (similar >> to FCKeditor). Any direction would be greatly appreciated! >> >> Warren >> ___ >> use-revolution mailing list >> use-revolution@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution >> > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Replacing Text
Mark, Your seconds example worked great. I assume the first example you provided would replace multiple occurenences of the text if it existed? The second example doesn't do this and is exactly what I was trying to resolve. Thanks for your help! Warren On Mon, Jan 25, 2010 at 11:34 AM, Mark Schonewille wrote: > Hi Warren, > > The selectedChunk is a reference to particular characters in a field. Also, > the selectedChunk of fld x isn't a reference the actual text in that field > but rather a string containing that reference. > > For example, if you tell Revolution to replace "xyz" with "abc" in "char 1 > to 2 of field 1" it isn't going to work. > > You might try this. > > put the selectedText into mySelection > replace mySelection with "" & mySelection & "" in field x > > or > > put the selectedText into mySelection > put "" & mySelection & "" into the selectedChunk > > I have tested this and both methods work. > > -- > Best regards, > > Mark Schonewille > > Economy-x-Talk Consulting and Software Engineering > Homepage: http://economy-x-talk.com > Twitter: http://twitter.com/xtalkprogrammer > > Try the new URL shortening service http://qurl.tk > > Op 25 jan 2010, om 18:20 heeft Warren Kuhl het volgende geschreven: > >> I am trying to replace a selected chunk of text with the selectedchunk >> of text and some html codes. I tried the code below and the software >> doesn't like this. >> >> replace the selectedtext of field "field" with "" & the >> selectedtext of field "field" & "" in the selectedchunk of field >> "field" >> >> I could use: >> replace the selectedtext of field "field" with "" & the >> selectedtext of field "field" & "" in field "field" >> ...but the replace would replace all occurrences of the text in my >> field...instead of just the selectedchunk. >> >> How would I accomplish this? I assume it is something simple. >> >> Warren > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Replacing Text
I am trying to replace a selected chunk of text with the selectedchunk of text and some html codes. I tried the code below and the software doesn't like this. replace the selectedtext of field "field" with "" & the selectedtext of field "field" & "" in the selectedchunk of field "field" I could use: replace the selectedtext of field "field" with "" & the selectedtext of field "field" & "" in field "field" ...but the replace would replace all occurrences of the text in my field...instead of just the selectedchunk. How would I accomplish this? I assume it is something simple. Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: HTML Editor
Martin, Thanks for the link. I will check this out now. Appreciate the help! Warren On Mon, Jan 25, 2010 at 9:50 AM, Martin Baxter < mb.use...@harbourhosting.co.uk> wrote: > Warren Kuhl wrote: > > I am looking for a WYSIWYG HTML editor I can attach to a text field > (similar > > to FCKeditor). Any direction would be greatly appreciated! > > > > Warren > > TinyMCE ? > > <http://www.moxiecode.com/products_tinymce.php> > > Martin Baxter > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
HTML Editor
I am looking for a WYSIWYG HTML editor I can attach to a text field (similar to FCKeditor). Any direction would be greatly appreciated! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: SQL/MySQL Database Question
William, Thanks for the suggestion! It was an error in my SQL which I fixed. Warren On Thu, Jan 21, 2010 at 1:35 PM, william humphrey < b...@bluewatermaritime.com> wrote: > Did you try running your query in a SQL utility first? > > On Thu, Jan 21, 2010 at 3:02 PM, Warren Kuhl wrote: > > > I am trying to get the number of records that exist in 1 tables that do > not > > exist in another table. Looking online, I saw an example of a > > SELECTWHERE NOT EXISTS. > > > > I have a two questions: > > > > 1) Does RR handle the scenario below? For some reason I am getting a > > error around the "not exists (select * from" when I try to run this. > > > > 2) Is there a better way to do this? > > > > put revQueryDatabase (gConID, "SELECT Brand_URL, Product_URL, > Product_Name, > > Product_UOM, Product_Retail, Product_Price, Product_Image, > > Product_Description, from products where not exists (select * from > > z-products where brand_url = z_brand_url and brand_name = z_brand_name > and > > product_url = z_product_url and product_name = z_product_name and > > product_uom = z_product_uom)") into tNotExists > > > > put revNumberofRecords(tNotExists) into vRecNo > > > > Thanks for any help! > > Warren > > ___ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > -- > http://www.bluewatermaritime.com > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
SQL/MySQL Database Question
I am trying to get the number of records that exist in 1 tables that do not exist in another table. Looking online, I saw an example of a SELECTWHERE NOT EXISTS. I have a two questions: 1) Does RR handle the scenario below? For some reason I am getting a error around the "not exists (select * from" when I try to run this. 2) Is there a better way to do this? put revQueryDatabase (gConID, "SELECT Brand_URL, Product_URL, Product_Name, Product_UOM, Product_Retail, Product_Price, Product_Image, Product_Description, from products where not exists (select * from z-products where brand_url = z_brand_url and brand_name = z_brand_name and product_url = z_product_url and product_name = z_product_name and product_uom = z_product_uom)") into tNotExists put revNumberofRecords(tNotExists) into vRecNo Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Images on a webpage
Thanks Jacqueline! I am always looking for the easy way out. I will use your solution. Warren On Wed, Jan 13, 2010 at 2:23 PM, J. Landman Gay wrote: > Warren Kuhl wrote: > >> Figured it outlibURLDownloadToFile. No matter what the problem...RR >> always seems to have the answer! >> >> On Wed, Jan 13, 2010 at 1:19 PM, Warren Kuhl >> wrote: >> >> If I have the url of a image, is there a way to save the image to a folder >>> on computer using Revolution Studio? >>> >> > It can be even easier than that: > > put url "http://www.domain.com/imagename.jpg"; into url > ("binfile:folder/folder/imgname.jpg") > > But your way works too. > > -- > Jacqueline Landman Gay | jac...@hyperactivesw.com > HyperActive Software | http://www.hyperactivesw.com > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Images on a webpage
Figured it outlibURLDownloadToFile. No matter what the problem...RR always seems to have the answer! On Wed, Jan 13, 2010 at 1:19 PM, Warren Kuhl wrote: > If I have the url of a image, is there a way to save the image to a folder > on computer using Revolution Studio? > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Images on a webpage
If I have the url of a image, is there a way to save the image to a folder on computer using Revolution Studio? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: HTML Text
Thank youthe htmltext worked perfectly! Warren On Wed, Jan 13, 2010 at 12:52 PM, Mark Schonewille < m.schonewi...@economy-x-talk.com> wrote: > Warren and Stephen, > > If you really want just the text, put fld "yourfield" into fld "yourfield" > after setting the htmlText. Might sound weird, but it works. If you want to > make it look clever and elegant, set the lockScreen to true while doing > this. > > -- > Best regards, > > Mark Schonewille > > Economy-x-Talk Consulting and Software Engineering > Homepage: http://economy-x-talk.com > Twitter: http://twitter.com/xtalkprogrammer > > We make software, websites and webware. We are always looking for new > projects. Feel free to contact us and ask for a quote without any further > obligations > http://economy-x-talk.com/contact.html > > Op 13 jan 2010, om 19:44 heeft stephen barncard het volgende geschreven: > > > get the HTML from the website then >> >> set the htmltext of fld "yourfield" to it >> >> > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
HTML Text
I am using the put url command to retrieve the html code from a website. Is there a command to strip out the html code? I just want the text. ie. This is an example I would want: This is an example Thanks for any help, Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: FTP Error - Previous Request Not Completed
Thanks Andre...you have been most helpful. Warren On Wed, Oct 28, 2009 at 1:14 PM, Andre Garzia wrote: > There are probably sane ways to do this which I can't remember right now... > but a > > resetall > > will break every single connection... it is like an atomic bomb, it really > resets all the networking. You can use it to abort things but I bet that > there are better ways. > > > On Wed, Oct 28, 2009 at 4:11 PM, Warren Kuhl wrote: > > > Andre, > > > > Thanks for the information. Is there a way to force the connection > closed > > if the user wants to cancel the upload? > > > > Warren > > > > On Wed, Oct 28, 2009 at 1:02 PM, Andre Garzia > > wrote: > > > > > Err, if you close it then you're really aborting it midway which will > > give > > > you a corrupted file on the server you're uploading to. There are many > > ways > > > around this, what I do is: > > > > > > 1) Use liburlsetstatuscallback call to create a routine that will > receive > > > periodic status reports from liburl. > > > 2) Maintain a download queue > > > 3) if the callback receives a call that says that a file transfer is > > > completed, then pick the next one in the queue. > > > 4) if there's a recoverable error such as a timeout, then I restart the > > > same > > > transfer > > > 5) if there's an unrecoverable error such as the server being hit by a > > > meteor, I gracefuly exit the routine > > > > > > This way, there's no collision, I will only start a transfer when I > > trully > > > know that the previous one finished. > > > > > > On Wed, Oct 28, 2009 at 3:55 PM, Warren Kuhl > > wrote: > > > > > > > Andre, > > > > > > > > Thanks for the explanation. Is there anyway for me to check if there > > is > > > > another connection open and close it? > > > > > > > > Warren > > > > > > > > On Wed, Oct 28, 2009 at 12:53 PM, Andre Garzia < > an...@andregarzia.com > > > > >wrote: > > > > > > > > > Warren, > > > > > > > > > > you can maintain only one connection (file transfer) at a time, if > > you > > > > > request a file transfer and the previous one is not finished yet, > > this > > > is > > > > > the error you get. > > > > > > > > > > :D > > > > > > > > > > On Wed, Oct 28, 2009 at 3:35 PM, Warren Kuhl > > > > > wrote: > > > > > > > > > > > Does anyone know why I am getting the 'Previous Request Not > > > Completed' > > > > > > error > > > > > > when FTPing files to a server. I have a process that loops > through > > a > > > > > list > > > > > > of files and uploads them to my server using the put url command. > > It > > > > > seems > > > > > > to fail halfway and I get this error. Then when I try to run the > > > > program > > > > > > again...I still get this error. > > > > > > > > > > > > Thanks, > > > > > > Warren Kuhl > > > > > > ___ > > > > > > use-revolution mailing list > > > > > > use-revolution@lists.runrev.com > > > > > > Please visit this url to subscribe, unsubscribe and manage your > > > > > > subscription preferences: > > > > > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > http://www.andregarzia.com All We Do Is Code. > > > > > ___ > > > > > use-revolution mailing list > > > > > use-revolution@lists.runrev.com > > > > > Please visit this url to subscribe, unsubscribe and manage your > > > > > subscription preferences: > > > > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > > > > ___ > > > > use-revolution mailing list > > > > use-revolution@lists.runrev.com > > > > Please visit this url to subscribe, unsubscribe and manage your > > > > subsc
Re: FTP Error - Previous Request Not Completed
Andre, Thanks for the information. Is there a way to force the connection closed if the user wants to cancel the upload? Warren On Wed, Oct 28, 2009 at 1:02 PM, Andre Garzia wrote: > Err, if you close it then you're really aborting it midway which will give > you a corrupted file on the server you're uploading to. There are many ways > around this, what I do is: > > 1) Use liburlsetstatuscallback call to create a routine that will receive > periodic status reports from liburl. > 2) Maintain a download queue > 3) if the callback receives a call that says that a file transfer is > completed, then pick the next one in the queue. > 4) if there's a recoverable error such as a timeout, then I restart the > same > transfer > 5) if there's an unrecoverable error such as the server being hit by a > meteor, I gracefuly exit the routine > > This way, there's no collision, I will only start a transfer when I trully > know that the previous one finished. > > On Wed, Oct 28, 2009 at 3:55 PM, Warren Kuhl wrote: > > > Andre, > > > > Thanks for the explanation. Is there anyway for me to check if there is > > another connection open and close it? > > > > Warren > > > > On Wed, Oct 28, 2009 at 12:53 PM, Andre Garzia > >wrote: > > > > > Warren, > > > > > > you can maintain only one connection (file transfer) at a time, if you > > > request a file transfer and the previous one is not finished yet, this > is > > > the error you get. > > > > > > :D > > > > > > On Wed, Oct 28, 2009 at 3:35 PM, Warren Kuhl > > wrote: > > > > > > > Does anyone know why I am getting the 'Previous Request Not > Completed' > > > > error > > > > when FTPing files to a server. I have a process that loops through a > > > list > > > > of files and uploads them to my server using the put url command. It > > > seems > > > > to fail halfway and I get this error. Then when I try to run the > > program > > > > again...I still get this error. > > > > > > > > Thanks, > > > > Warren Kuhl > > > > ___ > > > > use-revolution mailing list > > > > use-revolution@lists.runrev.com > > > > Please visit this url to subscribe, unsubscribe and manage your > > > > subscription preferences: > > > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > > > > > > > > > > > -- > > > http://www.andregarzia.com All We Do Is Code. > > > ___ > > > use-revolution mailing list > > > use-revolution@lists.runrev.com > > > Please visit this url to subscribe, unsubscribe and manage your > > > subscription preferences: > > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > ___ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > -- > http://www.andregarzia.com All We Do Is Code. > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: FTP Error - Previous Request Not Completed
Andre, Thanks for the explanation. Is there anyway for me to check if there is another connection open and close it? Warren On Wed, Oct 28, 2009 at 12:53 PM, Andre Garzia wrote: > Warren, > > you can maintain only one connection (file transfer) at a time, if you > request a file transfer and the previous one is not finished yet, this is > the error you get. > > :D > > On Wed, Oct 28, 2009 at 3:35 PM, Warren Kuhl wrote: > > > Does anyone know why I am getting the 'Previous Request Not Completed' > > error > > when FTPing files to a server. I have a process that loops through a > list > > of files and uploads them to my server using the put url command. It > seems > > to fail halfway and I get this error. Then when I try to run the program > > again...I still get this error. > > > > Thanks, > > Warren Kuhl > > ___ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > -- > http://www.andregarzia.com All We Do Is Code. > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
FTP Error - Previous Request Not Completed
Does anyone know why I am getting the 'Previous Request Not Completed' error when FTPing files to a server. I have a process that loops through a list of files and uploads them to my server using the put url command. It seems to fail halfway and I get this error. Then when I try to run the program again...I still get this error. Thanks, Warren Kuhl ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: FTP Questions
Richard, Thanks for the response. I have noticed that the put url seems to work very well. Just wanted to see if I was missing something by using this command. Appreciate your help! Warren On Wed, Oct 28, 2009 at 11:29 AM, Richard Gaskin wrote: > Warren Kuhl wrote: > >> I am working on a application that needs to upload multiple files to a >> server. I see there are multiple ways to take care of this: >> >> ie. >> put url("binfiles:" & tFile) into url turl >> -or- >> libURLftpUploadFile command >> >> My question is...is one way better then the other as far as efficiency, >> error checking, etc? >> >> Also...I have encountered the message 'Error - Previous request in >> process" and the FTP doesn't work. What does this mean? How can I get >> around >> this? >> > > I believe the difference is that "put url..." is a blocking call, so that > no further attempts will be made until the last one has completed. > > FWIW I use "put url..." in my WebMerge product, and we have some customers > uploading tens of thousands of files in a batch without error. > > I wish I could take credit for that, but it's all Dave Cragg's excellent > work in libURL. Thanks, Dave! > > -- > Richard Gaskin > Fourth World Media Corporation > Developer of WebMerge: Publish any database on any Web site > ___ > ambassa...@fourthworld.com > http://www.FourthWorld.com<http://www.fourthworld.com/> > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
FTP Questions
I am working on a application that needs to upload multiple files to a server. I see there are multiple ways to take care of this: ie. put url("binfiles:" & tFile) into url turl -or- libURLftpUploadFile command My question is...is one way better then the other as far as efficiency, error checking, etc? Also...I have encountered the message 'Error - Previous request in process" and the FTP doesn't work. What does this mean? How can I get around this? Thanks for any help, Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: FTP Files To Server
Jim, Thanks...this worked! Appreciate your help! Warren On 10/23/09, Jim Ault wrote: > > try > > put url ("binfile:" & gInitialFolder & "/" & "az.bk") into url turl > > > On Oct 23, 2009, at 11:20 AM, Warren Kuhl wrote: > > I am running into a weird situation. I have been uploading a backup of a >> database to a server and everything was working file. I decided to change >> my host to hostgator.com and updated my program to reflect the changes. >> Now, instead of my database backup, I am getting the path of the datafile >> being uploaded. >> >> The command I am using is... >> >> put "ftp://tUserID:tpassw...@ftp.mywebsite.com/www/az/"; & tFile into turl >> put url "binfile:" & (gInitialFolder & "/" & "az.bk") into url turl >> >> when I check az.bk on my server, it contains... >> E:/Program Files/az/az.bk >> >> ...instead of the database. Any suggestions? >> >> Thanks for any help! >> Warren >> > > Jim Ault > jimaultw...@yahoo.com > > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
FTP Files To Server
I am running into a weird situation. I have been uploading a backup of a database to a server and everything was working file. I decided to change my host to hostgator.com and updated my program to reflect the changes. Now, instead of my database backup, I am getting the path of the datafile being uploaded. The command I am using is... put "ftp://tUserID:tpassw...@ftp.mywebsite.com/www/az/"; & tFile into turl put url "binfile:" & (gInitialFolder & "/" & "az.bk") into url turl when I check az.bk on my server, it contains... E:/Program Files/az/az.bk ...instead of the database. Any suggestions? Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Condition stored as a variable.
Andre, Thank you...this worked! Really appreciate you taking the time to help me out. Warren On 10/22/09, Andre Garzia wrote: > > try making the variable: get "002" <> "001" > do a: > > do Variable1 > > if it is true then > ... > end if > > see if this works! :D > > On Thu, Oct 22, 2009 at 5:19 PM, Warren Kuhl wrote: > > > I have a viable with the following value: > > > > Variable1: "002" <> "001" > > > > I would like to use the variable as a condition and see if it is true. I > > have tried: > > > > If Variable1 then > > > > ... > > > > End if > > > > ...this couldn't seem to work. Any suggestions? > > > > Thanks for any help! > > > > Warren > > ___ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > > -- > http://www.andregarzia.com All We Do Is Code. > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Condition stored as a variable.
I have a viable with the following value: Variable1: "002" <> "001" I would like to use the variable as a condition and see if it is true. I have tried: If Variable1 then ... End if ...this couldn't seem to work. Any suggestions? Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
AUTO: Warren Kuhl is out of the office. (returning 10/05/2009)
I am out of the office until 10/05/2009. If you need an immediate reponse for any EDI issues, please contact EDI Support at 952-808-6626. Note: This is an automated response to your message "use-revolution Digest, Vol 73, Issue 1" sent on 10/1/09 8:33:56. This is the only notification you will receive while this person is away. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Determine last character of a variable
Phil/Stephen, Thanks for your help! I never understood what the -1 meant when dealing with characters. Appreciate your quick responses! Warren On 8/26/09, Phil Davis wrote: > > Try "char 1 to -1 of tdata". > > char -1 is the last char > char -2 is the next-to-last char > and so on. > > Phil Davis > > > Warren Kuhl wrote: > >> This is probably a very stupid question.. >> >> I am trying to extract a substring from a variable and am unsure how to >> determine the last character... >> >> I tried... >> put char 1 to last character of tdata into tsubstring >> ...but this fails. >> >> Thanks for any help! >> Warren >> ___ >> use-revolution mailing list >> use-revolution@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution >> >> >> > > -- > Phil Davis > > PDS Labs > Professional Software Development > http://pdslabs.net > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Determine last character of a variable
This is probably a very stupid question.. I am trying to extract a substring from a variable and am unsure how to determine the last character... I tried... put char 1 to last character of tdata into tsubstring ...but this fails. Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Print to PDF?
Richard, Try http://www.runrev.com/products/related-software/quartam-pdf-library/ I had to use this for a order entry application I wrote and it worked really well. Plus you get great support from Jan Schenkel who is a frequent contributor to this list. Warren On 8/6/09, Richmond Mathewson wrote: > > Print to PDF? > > I think I am reinventing the wheel . . . > > advice welcomed. > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Processing Large Amounts Of Data
Richard, Thanks...that really helps! I will give it a try. Warren On 7/29/09, Richard Gaskin wrote: > > Warren Kuhl wrote: > > I have a variable that has approx 100,000 records (loaded from a text >> file). >> I need to read through each record and extract items from each record. >> >> I am currently using: >> Repeat with x = 1 to tRecordCount >> Put item 2 of line x of tData into tItem2 >> Put item 6 of line x of tData into tItem6 >> ...process data >> End Repeat >> >> I find this very slow to process. Is there a fast way to process through >> the >> data? >> > > The "repeat with..." construct will be slow when using the iteration > variable to access the data, because each time through the loop it needs to > count from 1 to x to find the line in question. > > You should see at least an order of magnitude performance gain using > "repeat for each...", e.g.: > > repeat for each line tLine in tData > put item 2 of tLine into tItem2 > put item 6 of tLine into tItem6 > ...process data > end Repeat > > With "repeat for each", the engine parses the data as it goes, putting each > line as it finds it into tLine, and keep track of where it is so the next > time through the loop it just picks up where it left off. Much, much faster. > > -- > Richard Gaskin > Fourth World > Revolution training and consulting: http://www.fourthworld.com > Webzine for Rev developers: http://www.revjournal.com > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Processing Large Amounts Of Data
I have a variable that has approx 100,000 records (loaded from a text file). I need to read through each record and extract items from each record. I am currently using: Repeat with x = 1 to tRecordCount Put item 2 of line x of tData into tItem2 Put item 6 of line x of tData into tItem6 ...process data End Repeat I find this very slow to process. Is there a fast way to process through the data? Thanks! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: If Statement/Operator Question (MISSED OPPORTUNITY)
Jan/Craig, This is working great! I was banging my head against the wall for 4 hours trying to get this figured out. Really appreciate the help! Warren On 7/23/09, dunb...@aol.com wrote: > > You're welcome. You see Jan's response does basically the same thing; > another level of evaluation sets complex things right, and can be invoked > is > several ways. > > BUT AS SOON AS I SENT MY RESPONSE, I realized I could have written: > > put "*" into tOperator > do "put 6" && tOperator && "9" > > you get 42 > > Life is a string of missed opportunities. > > Craig Newman > > > ** > Dell Deals: Treat yourself to a sweet deal on > popular laptops! > ( > http://pr.atwola.com/promoclk/100126575x1223100673x1201716527/aol?redir=http:%2F%2Faltfarm.mediaplex.com%2Fad%2Fck%2F12309%2D81939%2D1629% > 2D7) > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: If Statement/Operator Question
Craig, Thanksthat does make sense. I will give it a try. Thanks for your help! Warren On 7/23/09, dunb...@aol.com wrote: > > You likely have to evaluate before the parser will make this work for you: > > if you write: > > put "+" into tOperator > put 5 && tOperator && 6 > > you will get "5 + 6" > > but if you write: > > put "+" into tOperator > do "put 5" && tOperator && "6" > > you get 11 > > Craig Newman > > > ** > Dell Deals: Treat yourself to a sweet deal on > popular laptops! > ( > http://pr.atwola.com/promoclk/100126575x1223100673x1201716527/aol?redir=http:%2F%2Faltfarm.mediaplex.com%2Fad%2Fck%2F12309%2D81939%2D1629% > 2D7) > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
If Statement/Operator Question
Is it possible to pass the operator as a variable. When I try, the code doesn't seem to work. When I hardcode the operator, everything works fine. The problem is the operator can be different depending on what the user selects and I don't want to hardcode each condition if I don't have to. Here is an example where tCondition1 could be =, >, >=, <, <=, etc. When I try the following (tCondition1 is "="), I get no results if (item tField1 of line x of tdata) & tCondition1 & (field "S1 Compare 1 Field") then Answer "This works" delete line x of tdata end if When I try the following, I get results... if (item tField1 of line x of tdata) = (field "S1 Compare 1 Field") then Answer "This works" delete line x of tdata end if Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Contains, Begins With, Ends With
Devin, Thanks for your help! Appreciate it! Warren On 7/22/09, Devin Asay wrote: > > > On Jul 22, 2009, at 1:40 PM, Warren Kuhl wrote: > > Is there anyway to use a NOT condition with Contains, Begins With, Ends >> With? >> >> I am trying to create a if statement with multiple conditions... >> >> ie. >> >> If tData does not contain "Tree" and tData Begins with "House" then >> ...do something >> End if >> > > Try: > > if not(tDate contains/begins with/ends with) "house" then > > There is also the is in/is not in comparison operator. > > HTH > Devin > > Devin Asay > Humanities Technology and Research Support Center > Brigham Young University > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Contains, Begins With, Ends With
Is there anyway to use a NOT condition with Contains, Begins With, Ends With? I am trying to create a if statement with multiple conditions... ie. If tData does not contain "Tree" and tData Begins with "House" then ...do something End if Thanks! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Sort a container - AScending / Descending
Sarah, Thanks for the quick response! This is exactly what I was looking for. All the best, Warren On Mon, Jul 20, 2009 at 11:33 PM, Sarah Reichelt wrote: > On Tue, Jul 21, 2009 at 12:57 PM, Warren Kuhl wrote: > > Is there anyway to sort multiple items in a variable mixing ascending and > > descending? > > > > ie. sort lines of tData by word 1 of each, word 2 of each, word 3 of each > > ...where word 1 and word 2 are acscending and word 3 is descending. > > Sorts are non-destructive, so just do them in sequence with the least > important first and the most important last. > e.g. > > sort lines of tData descending by word 3 of each > sort lines of tData by word 2 of each > sort lines of tData by word 1 of each > > (I may have got this the wrong way around, but just alter the order of > the lines to get what you want.) > > HTH, > Sarah > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Sort a container - AScending / Descending
Is there anyway to sort multiple items in a variable mixing ascending and descending? ie. sort lines of tData by word 1 of each, word 2 of each, word 3 of each ...where word 1 and word 2 are acscending and word 3 is descending. Thanks for any help! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Anyone Still Using v3 or earlier?
Thanks everyone for looking into this for me. Judy sent me the stack I was looking for. I really appreciate everyone going out of their way for me...especially Judy for sending me the stack!!! Have a wonderful weekend Warren Judy Perry wrote: I think I found it; already sent it to him. Judy On Sat, 2 May 2009, Shao Sean wrote: I have no issues getting it for you but you will need to provide a name because a cursory glance did not show anything with HTML in the name ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Anyone Still Using v3 or earlier?
I found a great html field editor in RevOnline (in the general category) when I was on v3. My problem is I upgraded to v3.5 and the RevOnline also upgraded and now I can't download the editor. If someone is on v3 and could send me the html editor.I would be very grateful! Thanks for any help! Warren c...@suppsearch.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Loading Webpage Fields From Fields From Card
I am opening up a internet page using revBrowserOpen. Is it possible to load some fields on the internet page from fields on my card? I don't need to POST the formjust want to fill out some of the fields. Is this possible with Revolution Studio? Thanks, Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Retrieve html code from webpage
Scott/Stephen, Thanks for your help...appreciate it. This worked perfect now! Warren From: Scott Rossi To: Revolution Mail List Date: 04/21/2009 10:58 AM Subject:Re: Retrieve html code from webpage Sent by:use-revolution-boun...@lists.runrev.com Recently, warren.k...@northerntool.com wrote: > I am trying to capture the raw html code from a webpage. I am trying: > > set the htmltext of field "Field 1" to url "http://www.website.com/"; > > When I look at my field, I am not getting the html tags (ie. > ., etc.). Is it possible to get the raw html code > from a webpage? Try this instead: put url "http://www.website.com/"; into fld "field 1" Setting the htmlText of a field renders the text of the field as HTML which is why you're not seeing any tags. Regards, Scott Rossi Creative Director Tactile Media, Multimedia & Design ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Retrieve html code from webpage
I am trying to capture the raw html code from a webpage. I am trying: set the htmltext of field "Field 1" to url "http://www.website.com/"; When I look at my field, I am not getting the html tags (ie. ., etc.). Is it possible to get the raw html code from a webpage? Thanks! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Multi Thread FTP
Mark, Thanks for any help! Much appreciated. I have downloaded the libRevCurl script and it looks very impressive. Warren Mark Smith To Sent by: How to use Revolution use-revolution-bo un...@lists.runre cc v.com Subject Re: Multi Thread FTP 04/08/2009 02:25 PM Please respond to How to use Revolution Warren, there's the beginnings of ftp support in libRevCurl, but because that hasn't been what my own need is, I haven't really developed it. I'll take a look and see how poor it is! Best, Mark On 8 Apr 2009, at 19:20, warren.k...@northerntool.com wrote: > Bernard, > > Thanks for your feedback. I will check out libRevCurl. I was > looking for > a way to open up multiple ftp connections and uploading html pages. > Hopefully this Mark Smith's libRevCurl will point me in the right > direction. > > Warren > > > > > Bernard Devlin > > om>To > Sent by: How to use Revolution > use-revolution-bo revolut...@lists.runrev.com> > > un...@lists.runre cc > v.com > > Subject >Re: Multi Thread FTP > 04/08/2009 12:08 > PM > > > Please respond to > How to use > Revolution >ists.runrev.com> > > > > > > > Hi Warren, > > Revolution is single-threaded. However, are you sure that you need > multi-threading? I'm asking this because you can use callbacks with > various internet actions in Rev, and this kind of event-based > interactivity might be sufficient. There's a very good presentation > by John Ousterhout (the man who designed Tcl/Tk) that puts forward a > very effective case for event-based processing instead of > multi-threaded processing (bottom line: only a small percentage of > programmers are capable of writing working multi-threaded code). > > If you still need more than the event-based processing provided by > callbacks, then you could look at Mark Smith's libRevCurl. I referred > to it a couple of days back in a discussion on the list about getting > round the fact that the POST action of Rev's internet library does not > work with callbacks. > > Mark's library will make calls to the CURL executable, and such calls > will all be independent of each other and will exploit the OS capacity > for multi-processing. > > Bernard > > On Wed, Apr 8, 2009 at 4:33 PM, wrote: >> Is it possible to create a program to do multi-thread FTP upload? >> From >> what I understand about Revolution Studio, everything is single >> thread. >> >> Warren >> >> ___ >> use-revolution mailing list >> use-revolution@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution >> > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution __
Re: Multi Thread FTP
Bernard, Thanks for your feedback. I will check out libRevCurl. I was looking for a way to open up multiple ftp connections and uploading html pages. Hopefully this Mark Smith's libRevCurl will point me in the right direction. Warren Bernard Devlin To Sent by: How to use Revolution use-revolution-bo un...@lists.runre cc v.com Subject Re: Multi Thread FTP 04/08/2009 12:08 PM Please respond to How to use Revolution Hi Warren, Revolution is single-threaded. However, are you sure that you need multi-threading? I'm asking this because you can use callbacks with various internet actions in Rev, and this kind of event-based interactivity might be sufficient. There's a very good presentation by John Ousterhout (the man who designed Tcl/Tk) that puts forward a very effective case for event-based processing instead of multi-threaded processing (bottom line: only a small percentage of programmers are capable of writing working multi-threaded code). If you still need more than the event-based processing provided by callbacks, then you could look at Mark Smith's libRevCurl. I referred to it a couple of days back in a discussion on the list about getting round the fact that the POST action of Rev's internet library does not work with callbacks. Mark's library will make calls to the CURL executable, and such calls will all be independent of each other and will exploit the OS capacity for multi-processing. Bernard On Wed, Apr 8, 2009 at 4:33 PM, wrote: > Is it possible to create a program to do multi-thread FTP upload? From > what I understand about Revolution Studio, everything is single thread. > > Warren > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Multi Thread FTP
Is it possible to create a program to do multi-thread FTP upload? From what I understand about Revolution Studio, everything is single thread. Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: List Magic
Jim, Thanks for your help! I purchased List Magic a couple of days ago and couldn't be happier with the product. The only thing that would improve it (if you are making any changes on future versions) is a right justify for a column. I know this was a limitation with Revolution. Not sure if it still is with V3.5...but this would be a great feature. Thanks again! Warren "Jim Bufalini" To Sent by: "'How to use Revolution'" use-revolution-bo un...@lists.runre cc v.com Subject RE: List Magic 04/08/2009 05:52 AM Please respond to How to use Revolution Hi Warren, > I was in the process of purchasing List Magic when I found out that the > person responsible for writing it has passed away. > > I have a question on the product and was hoping someone that is using > the > product would be able to answer. I am trying to change the tool tip on > my > headings by going into the properties. Whenever I change them, it keeps > going back to: > > 'A right click allows many operations' > > Is there anyway to change this? Hopefully there is someone here that > has > used List Magic? It looks very impressive! > > Thanks for any help you can provide! > Warren My apologies for being away and not noticing this post sooner. Yes. To change this tooltip, go to the card where you have installed a ListMagic widget. You will find a group with the name you called the list. This is the header group. Go to custom properties for this group and select cSSSTooltips. Then if you want to change the English tooltip, select the *en* custom property and change it to whatever you would prefer. You will also find the cSSSMenus here for the header. To make similar changes for the list itself, change the custom properties of the same names for the field that has the name you gave the ListMagic widget. Aloha from Hawaii Jim Bufalini ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: List Magic
Bernard, Thanks for the quick response! Yes...I am using the trial version. Just started using it today and was shocked at how easy it was to create lists. If this is a limit to the trial version, that would be good news as I am planning on purchasing the product today. I will wait for a response from Jim. Warren Kuhl Senior Programmer Northern Tool and Equipment Company 952-641-2420 warren.k...@northerntool.com ** >>>> EDI ISSUES <<<< Phone: 952-808-6626 Email : supp...@northerntool.com (EDI in subject line) ** Bernard Devlin To Sent by: How to use Revolution use-revolution-bo un...@lists.runre cc v.com Subject Re: List Magic 04/06/2009 01:56 PM Please respond to How to use Revolution Hi Warren, Jim is supporting ListMagic on behalf of Eric's family. I'm sure he will answer your question here shortly. ListMagic is indeed very impressive. Could it be that you are using the demo copy? I remember when I looked at it that there were a few features that were not enabled until one had a license key. Bernard On 4/6/09, warren.k...@northerntool.com wrote: > > I was in the process of purchasing List Magic when I found out that the > person responsible for writing it has passed away. > > I have a question on the product and was hoping someone that is using the > product would be able to answer. I am trying to change the tool tip on my > headings by going into the properties. Whenever I change them, it keeps > going back to: > > 'A right click allows many operations' > > Is there anyway to change this? Hopefully there is someone here that has > used List Magic? It looks very impressive! > > Thanks for any help you can provide! > Warren > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
List Magic
I was in the process of purchasing List Magic when I found out that the person responsible for writing it has passed away. I have a question on the product and was hoping someone that is using the product would be able to answer. I am trying to change the tool tip on my headings by going into the properties. Whenever I change them, it keeps going back to: 'A right click allows many operations' Is there anyway to change this? Hopefully there is someone here that has used List Magic? It looks very impressive! Thanks for any help you can provide! Warren ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution