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
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: 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 jonathandly...@gmail.comwrote: check out Select and SelectedChunk On Wed, Oct 6, 2010 at 1:37 PM, Warren Kuhl warrenk...@gmail.com 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
Re: Cursor Position Within A Field
Thanks Klaus! On Wed, Oct 6, 2010 at 12:51 PM, Klaus on-rev kl...@major.on-rev.comwrote: 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: 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 bonnm...@gmail.com wrote: http://forums.runrev.com/phpBB2/viewtopic.php?f=7t=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 warrenk...@gmail.com 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 bonnm...@gmail.com 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 warrenk...@gmail.com 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 bonnm...@gmail.com 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 putWord: 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 warrenk...@gmail.com 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
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: 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 bonnm...@gmail.com 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 putWord: 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 warrenk...@gmail.com 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
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 bonnm...@gmail.com 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 warrenk...@gmail.com 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 bonnm...@gmail.com 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 putWord: 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 warrenk...@gmail.com 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 ___ 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
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 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
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: 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, dunb...@aol.com 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
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: 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 ambassa...@fourthworld.com 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
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(CRtStringCR,CRtListCR) 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
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
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
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 kl...@major.on-rev.comwrote: 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
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
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: 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
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 jonathandly...@gmail.comwrote: 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 warrenk...@gmail.com 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: 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 mo...@sweattechnologies.com 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
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: 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 m.schonewi...@economy-x-talk.com 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
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
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: 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 co...@verizon.net 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
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 co...@verizon.net 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
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 co...@verizon.net 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: 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 jac...@hyperactivesw.com 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
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: 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 j...@visitrieve.com 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
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 j...@visitrieve.com 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
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: 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
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 b the selectedtext of field field /b in the selectedchunk of field field I could use: replace the selectedtext of field field with b the selectedtext of field field /b 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: 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 m.schonewi...@economy-x-talk.com 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 b mySelection /b in field x or put the selectedText into mySelection put b mySelection /b 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 b the selectedtext of field field /b in the selectedchunk of field field I could use: replace the selectedtext of field field with b the selectedtext of field field /b 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
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 stephenrevoluti...@barncard.com wrote: CK Editor won't work in revbrowser? - Stephen Barncard San Francisco http://houseofcubes.com/disco.irev 2010/1/25 Warren Kuhl warrenk...@gmail.com 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
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: 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 warrenk...@gmail.com 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
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. html body bThis is an example/b /body /html 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: 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
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: 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 warrenk...@gmail.com 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
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 jac...@hyperactivesw.comwrote: 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 warrenk...@gmail.com 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
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 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 ambassa...@fourthworld.com 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.comhttp://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 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 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 an...@andregarzia.comwrote: 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 warrenk...@gmail.com 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
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 an...@andregarzia.com 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 warrenk...@gmail.com 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 warrenk...@gmail.com 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
Thanks Andre...you have been most helpful. Warren On Wed, Oct 28, 2009 at 1:14 PM, Andre Garzia an...@andregarzia.com 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 warrenk...@gmail.com 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 an...@andregarzia.com 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 warrenk...@gmail.com 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 warrenk...@gmail.com 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 -- 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 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: FTP Files To Server
Jim, Thanks...this worked! Appreciate your help! Warren On 10/23/09, Jim Ault jimaultw...@yahoo.com 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
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
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 an...@andregarzia.com 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 warrenk...@gmail.com 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
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
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: 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 rev...@pdslabs.net 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
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 richmondmathew...@gmail.com 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
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: Processing Large Amounts Of Data
Richard, Thanks...that really helps! I will give it a try. Warren On 7/29/09, Richard Gaskin ambassa...@fourthworld.com 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
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: 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 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
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 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
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: Contains, Begins With, Ends With
Devin, Thanks for your help! Appreciate it! Warren On 7/22/09, Devin Asay devin_a...@byu.edu 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
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: 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 sarah.reich...@gmail.comwrote: On Tue, Jul 21, 2009 at 12:57 PM, Warren Kuhlwarrenk...@gmail.com 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
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
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
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
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. header./header, 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: Retrieve html code from webpage
Scott/Stephen, Thanks for your help...appreciate it. This worked perfect now! Warren From: Scott Rossi sc...@tactilemedia.com To: Revolution Mail List use-revolution@lists.runrev.com 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. header./header, 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
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 j...@visitrieve.c omTo Sent by: 'How to use Revolution' use-revolution-bo use-revolution@lists.runrev.com un...@lists.runre cc v.com Subject RE: List Magic 04/08/2009 05:52 AM Please respond to How to use Revolution use-revolut...@l ists.runrev.com 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
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: 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 bdrun...@gmail.c omTo Sent by: How to use Revolution use-revolution-bo use-revolution@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 use-revolut...@l 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, warren.k...@northerntool.com 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
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 li...@futilism.c omTo Sent by: How to use Revolution use-revolution-bo use-revolution@lists.runrev.com un...@lists.runre cc v.com Subject Re: Multi Thread FTP 04/08/2009 02:25 PM Please respond to How to use Revolution use-revolut...@l ists.runrev.com 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 bdrun...@gmail.c omTo Sent by: How to use Revolution use-revolution-bo use- 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 use-revolut...@l 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, warren.k...@northerntool.com 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
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
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 bdrun...@gmail.c omTo Sent by: How to use Revolution use-revolution-bo use-revolution@lists.runrev.com un...@lists.runre cc v.com Subject Re: List Magic 04/06/2009 01:56 PM Please respond to How to use Revolution use-revolut...@l ists.runrev.com 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 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
