Re: Sending Email with attachment
Holá Bill, Google for "BLAT262", download, read the docs, install and enjoy. Works perfect for me (under Windows) kind regards Horst BILL HUMPHREY wrote: > > Since > > *Syntax: revMail address[,ccAddress[,mailSubject[,messageBody]]]* > > > does not allow for attaching a file how do you do that? > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/Re%3A-Sending-Email-with-attachment-tp23117602p23120589.html Sent from the Revolution - User mailing list archive at Nabble.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: RevCopyFolder XP problem
Holá David,
Why don't you use XCOPY?
f.e. get shell("start xCopy /e /c /d /y /h /k /v D:\*.* H:\test\*.*")
that works fine
David Glasgow wrote:
>
> Way back in October, Eric, Ken and others helped out with identifying
> special folders in XP and Vista, in which I could save shared and non
> shared data. (Because the system I used in my app previously breaks
> under Vista).
>
> Having finally decided on appropriate locations and file structures,
> I have started to script a routine which checks on the platform, then
> checks in each location for the expected folders, and copies them
> there if they are not present.
>
> Debugging is a bit of a painful process on Windows, because I am
> using Studio on Mac and testing under Parallels (XP). However, as
> far as I can tell, RevCopyFolder doesn't work as advertised on XP.
> In the Rev 2.0 language reference it states:
>
> "The revCopyFolder command makes a copy of the entire folder,
> including all files, subfolders, and their contents. The folder
> remains in its original location and the copy is placed in the new
> location."
>
> I only get the top level (i.e foldertocopy) folder created in the
> new location, with none of its contents, be they files or folders. I
> look at the result for each instance of RevCopyFolder after each
> partial successful copy, which gives me the numerical value '4'.
>
> I know that RevCopyFolder seems to be very erratic on the Mac, but is
> my problem on Win recognised by others? Is there an easy workaround?
>
> Thanks
>
> David Glasgow
>
>
>
> ___
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
--
View this message in context:
http://www.nabble.com/RevCopyFolder-XP-problem-tp21235671p21240249.html
Sent from the Revolution - User mailing list archive at Nabble.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
opening cd/Stack so slow
Hola a todo el mundo! opening a card or a substack takes up to 2 minutes(!!!) inside the Application Browser. I'm using Win XP/2k and RR2.9.0 thank you for answering, best regards and good luck for 2009 Horst -- View this message in context: http://www.nabble.com/opening-cd-Stack-so-slow-tp21233923p21233923.html Sent from the Revolution - User mailing list archive at Nabble.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: AW: Slow down of the 3.0 IDE
Hey Malte, That's the trick! Speeds up a lot! Nice to know, that there are some experts somewhere :) Hey Tiemo, now it's funny to work again. Thanks for opening that question again :) "Steter Tropfen höhlt den Stein" Horst Tiemo Hollmann TB wrote: > > Wow, Malte, you are a 3 star expert :) > That was the clue, now everything runs like a canon ball :) > Obviously the prefs wanted to do something with any old plugins I had > bound > sometimes in the past but deleted the wrong way... > Many thanks - you saved my day! > Tiemo > >> -Ursprüngliche Nachricht- >> Von: [EMAIL PROTECTED] [mailto:use-revolution- >> [EMAIL PROTECTED] Im Auftrag von Malte Brill >> Gesendet: Donnerstag, 2. Oktober 2008 10:05 >> An: use-revolution@lists.runrev.com >> Betreff: Re: Slow down of the 3.0 IDE >> >> Tiemo, >> >> it might be worth a try to delete revPreferences.rev (while rev is >> closed) >> >> In the messagebox type: >> >> put the filename of stack "revPreferences" >> >> to get the full path. Now close rev to delete that file and restart. >> But maybe you tried that already? >> >> All the best, >> >> Malte >> ___ >> use-revolution mailing list >> use-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 > > -- View this message in context: http://www.nabble.com/Slow-down-of-the-3.0-IDE-tp19774666p19809843.html Sent from the Revolution - User mailing list archive at Nabble.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: GLX2 and Rev 3.0
Holá Tiemo, Just to make things clear: I'm working with W2k AND XP! Same reaktion on both systems. Best Regards Horst Tiemo Hollmann TB wrote: > > Hi, I've just installed Rev 3.0 and noticed two things > > > > 1. The reaction time on menu mouseclicks (I reported before) in Rev IDE > 3.0 > on Win XP (with and without stacks open) is still a crawl. Anybody else > (beside of Horst) having performance problems with the IDE? > > > > 2. When trying to open a script with activated GLX2, nothing happens. > After > deactivating GLX2 the scripts are opened in the new Rev editor. I didn't > found any deinstall procedure fro GLX2. What is the appropriate way to do > it. Just remove the GLX2 plugins from the plugins folder and that's it? > > > > Thanks > > Tiemo > > > > > > > > > > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/GLX2-and-Rev-3.0-tp19570535p19583924.html Sent from the Revolution - User mailing list archive at Nabble.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: AW: AW: slown down of IDE 2.9 under windows
Holá Bernard, Same to me! Maybe the Stack(s) are to big with a total of +/- 25MB. So I'm thinking now to splitt the Mainstack and it's Substacks and Cards (+/- 120) into smaller parts. Do you think that makes sense? A wise man told me something about 6-7 MB (if I remember correct) Salu2 Horst Tiemo Hollmann TB wrote: > > Hi Bernard, > noop, no front- or backscripts. > Thanks > Tiemo > >> >> The reason why I asked was I identified a bug in R3 which slowed down all >> actions in fields (including the message box). That slow down was >> something >> to do with revMenuBar's menus being refreshed. The slow down DID NOT >> exist >> in 2.9, that's why I was making sure that you were not working on R3 and >> had >> forgotten :-) >> >> Now that there are two of you with this problem, I'm doubtful that the >> same >> solution will work! Anyway, have either of you introduced any >> frontscripts >> (or possibly backscripts - I've never used those), where you trap >> menuPick >> messages? >> >> Bernard >> >> On Wed, Sep 10, 2008 at 11:00 AM, Horst <[EMAIL PROTECTED]> wrote: >> > volution > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/slown-down-of-IDE-2.9-under-windows-tp19393010p19411973.html Sent from the Revolution - User mailing list archive at Nabble.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: AW: AW: slown down of IDE 2.9 under windows
Holá Tiemo, I also installed on a brandnew Laptop under XP few weeks ago Salu2 Horst Tiemo Hollmann TB wrote: > > Holá Horst, > did you already tried a fresh install of runrev? > Tiemo > >> -Ursprüngliche Nachricht- >> Von: [EMAIL PROTECTED] [mailto:use-revolution- >> [EMAIL PROTECTED] Im Auftrag von Horst >> Gesendet: Mittwoch, 10. September 2008 10:00 >> An: use-revolution@lists.runrev.com >> Betreff: Re: AW: slown down of IDE 2.9 under windows >> >> >> Holá Tiemo, >> >> Yes, I also have that Phenomenal thing here. Yes, I also rum RR2.9.0 >> Build >> 610 and I use Win2k and XP. I also fond this problem on the Beta 3.0.0 >> But >> I'm working under 2.9.0 now. >> >> I find this slowdown on both, IDE and standalone. >> >> The good thing is now: I'm not alone with this (thought it is MY problem >> only), the bad thing: it should be fond :-( >> >> Best regards >> >> Horst >> >> >> Tiemo Hollmann TB wrote: >> > >> > Hi Bernhard, >> > yes, 2.9.0 Build 610 :) >> > Tiemo >> > >> >> -Ursprüngliche Nachricht- >> >> Von: [EMAIL PROTECTED] [mailto:use-revolution- >> >> [EMAIL PROTECTED] Im Auftrag von Bernard Devlin >> >> Gesendet: Mittwoch, 10. September 2008 09:21 >> >> An: How to use Revolution >> >> Betreff: Re: slown down of IDE 2.9 under windows >> >> >> >> This may sound like a stupid question (so apologies in advance), but >> are >> >> you >> >> sure this is on Rev 2.9 and not Rev 3.0? >> >> Bernard >> >> >> >> On Tue, Sep 9, 2008 at 2:57 PM, Tiemo Hollmann TB >> >> <[EMAIL PROTECTED]>wrote: >> >> >> >> > Hi there, >> >> > >> >> > Win XP, SP2, Rev 2.9 >> >> > >> >> ___ >> >> use-revolution mailing list >> >> use-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 >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/slown-down-of-IDE-2.9- >> under-windows-tp19393010p19408605.html >> Sent from the Revolution - User mailing list archive at Nabble.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 > > -- View this message in context: http://www.nabble.com/slown-down-of-IDE-2.9-under-windows-tp19393010p19411893.html Sent from the Revolution - User mailing list archive at Nabble.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: AW: slown down of IDE 2.9 under windows
Holá Tiemo, Yes, I also have that Phenomenal thing here. Yes, I also rum RR2.9.0 Build 610 and I use Win2k and XP. I also fond this problem on the Beta 3.0.0 But I'm working under 2.9.0 now. I find this slowdown on both, IDE and standalone. The good thing is now: I'm not alone with this (thought it is MY problem only), the bad thing: it should be fond :-( Best regards Horst Tiemo Hollmann TB wrote: > > Hi Bernhard, > yes, 2.9.0 Build 610 :) > Tiemo > >> -Ursprüngliche Nachricht- >> Von: [EMAIL PROTECTED] [mailto:use-revolution- >> [EMAIL PROTECTED] Im Auftrag von Bernard Devlin >> Gesendet: Mittwoch, 10. September 2008 09:21 >> An: How to use Revolution >> Betreff: Re: slown down of IDE 2.9 under windows >> >> This may sound like a stupid question (so apologies in advance), but are >> you >> sure this is on Rev 2.9 and not Rev 3.0? >> Bernard >> >> On Tue, Sep 9, 2008 at 2:57 PM, Tiemo Hollmann TB >> <[EMAIL PROTECTED]>wrote: >> >> > Hi there, >> > >> > Win XP, SP2, Rev 2.9 >> > >> ___ >> use-revolution mailing list >> use-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 > > -- View this message in context: http://www.nabble.com/slown-down-of-IDE-2.9-under-windows-tp19393010p19408605.html Sent from the Revolution - User mailing list archive at Nabble.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: Stack opens behind Windows desktop
Holá Jacqueline, System settings??? Don't think so, cause there is/was never a problem with IDE-Version. Just Standalone makes this Problems. During next days I'll install some more Standalones on different PC's. Let's hope to get some more infos then. best regards Horst J. Landman Gay wrote: > > > That's good info. It means the stack title bar doesn't matter, it is > something else. Also, it is good to know that it only happens on one of > your PCs (same as me) and not on all of them. Maybe the problem is a > system setting? I have no idea which one it might be. > > Your English is very good, by the way. :) > > -- > Jacqueline Landman Gay | [EMAIL PROTECTED] > 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 > > -- View this message in context: http://www.nabble.com/Stack-opens-behind-Windows-desktop-tp19354380p19408405.html Sent from the Revolution - User mailing list archive at Nabble.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: Stack opens behind Windows desktop
Holá Klaus, my mentor, Sometimes it is difficult enough to describe or understand a problem in my own language. But then in english? Puh... Of course, I didn't change the "default" settings. Thanks for the translation and your helpfull hand. Klaus Major wrote: > > Hola Horst, > >> Holá Jacqueline, >> >> Thanks to try to be my "personal hero" and I would like to answer your >> question, but what do you mean with "Are your stack's window >> decorations set >> to empty?" Which decorations? > > The window decorations = titlebar, close button etc... > I remember that all your windows decorations are just "set" to default, > unless you have been experimenting in the last time :-) > >> Until now this problem occurs on one XP only. >> best regards >> >> Horst > > Best > > Klaus Major > [EMAIL PROTECTED] > http://www.major-k.de > > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/Stack-opens-behind-Windows-desktop-tp19354380p19389974.html Sent from the Revolution - User mailing list archive at Nabble.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: Stack opens behind Windows desktop
Holá Jacqueline, Thanks to try to be my "personal hero" and I would like to answer your question, but what do you mean with "Are your stack's window decorations set to empty?" Which decorations? Until now this problem occurs on one XP only. best regards Horst J. Landman Gay wrote: > > Horst wrote: >> Holá Jacqueline, >> >> Yes we have same problem here, no idea, why and thought, it would be a >> spanish problem :-) >> Working with Win 2000, Win XP and RR 2.9 > > I just compiled with Rev 3.0 and the problem is still there, but just > for that one person. Are your stack's window decorations set to empty? > I'm going to send this person a standalone with default decorations and > see if that helps. Have you been able to find a consistent recipe? Is it > always on only one machine or does it always happen to you? > >> >> Ho finds a solution will be my hero! >> >> best regards >> >> Horst >> >> >> J. Landman Gay wrote: >>> Odd Windows problem, that happens inconsistently: A standalone's >>> mainstack has its decorations set to empty and is sized to the >>> windowboundingrect. On launch, or sometimes when maximizing from the >>> task bar, the stack window opens invisibly. One person described it as >>> being "behind" the desktop. It can sometimes be brought back to view by >>> pressing the Windows key on the keyboard, and when that key is released >>> the stack pops back into view where it belongs. >>> >>> I've tried forcing it by specifically issuing the "toplevel" command and >>> the "show" command on both openstack and uniconifystack. The client says >>> it still sometimes fails to display. I've seen it happen only once, on >>> launch, and couldn't reproduce it again. It never happens in the IDE. >>> The stack is never made invisible or hidden; only its iconic is changed. >>> >>> This happens only on Windows, the Mac version goes to and from the dock >>> without any problem. Has anyone seen this? >>> >>> -- >>> Jacqueline Landman Gay | [EMAIL PROTECTED] >>> 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 >>> >>> >> > > > -- > Jacqueline Landman Gay | [EMAIL PROTECTED] > 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 > > -- View this message in context: http://www.nabble.com/Stack-opens-behind-Windows-desktop-tp19354380p19387566.html Sent from the Revolution - User mailing list archive at Nabble.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: Stack opens behind Windows desktop
Holá Jacqueline, Yes we have same problem here, no idea, why and thought, it would be a spanish problem :-) Working with Win 2000, Win XP and RR 2.9 Ho finds a solution will be my hero! best regards Horst J. Landman Gay wrote: > > Odd Windows problem, that happens inconsistently: A standalone's > mainstack has its decorations set to empty and is sized to the > windowboundingrect. On launch, or sometimes when maximizing from the > task bar, the stack window opens invisibly. One person described it as > being "behind" the desktop. It can sometimes be brought back to view by > pressing the Windows key on the keyboard, and when that key is released > the stack pops back into view where it belongs. > > I've tried forcing it by specifically issuing the "toplevel" command and > the "show" command on both openstack and uniconifystack. The client says > it still sometimes fails to display. I've seen it happen only once, on > launch, and couldn't reproduce it again. It never happens in the IDE. > The stack is never made invisible or hidden; only its iconic is changed. > > This happens only on Windows, the Mac version goes to and from the dock > without any problem. Has anyone seen this? > > -- > Jacqueline Landman Gay | [EMAIL PROTECTED] > 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 > > -- View this message in context: http://www.nabble.com/Stack-opens-behind-Windows-desktop-tp19354380p19367073.html Sent from the Revolution - User mailing list archive at Nabble.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
Free Icons?
please look here http://www.famfamfam.com/lab/icons/silk/ best regards Inselfan -- View this message in context: http://www.nabble.com/Free-Icons--tp19243609p19243609.html Sent from the Revolution - User mailing list archive at Nabble.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: how to uniencode text for VCard v. 3.0? [2]
Hi Hugh, Yes, please sent also a copy to me best regards Horst Hugh Senior wrote: > > Hi Klaus, > > I just replied totally incorrectly to your UTF-8 query! Must be having a > bad > hair day... My apologies. > > To avoid converting the entire string to UTF8 (when it's only accented > chars > that need it), what I have done is store the decimal/UTF8/Hex character > equivalents in a customproperty, then run each element value through this > encoder... > > function UTF8.encode tStr > put numtochar(13)&numtochar(10) into tCRLF > set the itemDel to TAB > set the caseSensitive to "TRUE" > repeat for each char L in tStr > get chartonum(L) > if it>=160 then > get lineOffset(CR&it&TAB, CR&the UTF8Table of this stack) --| Get > the > table line > if it >0 then > if VCVERS="2.1" then put toUpper(item 3 of line it of the > UTF8Table > of this stack) after stdout --| Use UTF8 > else put toUpper(item 2 of line it of the UTF8Table of this stack) > after stdout --| Use HEX > end if > else put L after stdout > end repeat > replace "\" with "\\" in stdout > replace "," with "\," in stdout > replace ";" with "\;" in stdout > replace CR with "=0D=0A" in stdout --| v2.1 WAB > return stdout > end UTF8.encode > > If the above looks of interest, let me know and I'll send you the look-up > table of character equivalents . > > /H > > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/Re%3A-how-to-uniencode-text-for-VCard-v.-3.0---2--tp17782967p17793506.html Sent from the Revolution - User mailing list archive at Nabble.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
printrotated ?? sometimes works sometimes not
Holá everybody, to print Landscape, I use the following in a button on the card: on mouseUp set the printmargins to 5,5,5,5 set the printrotated to true print card set the printrotated to false end mouseUp http://www.nabble.com/printrotatedsometimes-works-sometimes-not-tp16081672p16081672.html Sent from the Revolution - User mailing list archive at Nabble.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: 2.9 dp-3 for linux has expired...!
Hi RunRev, why don´t all 2.9 testers get dp-4? Is there a selection or is it just a mistake? best regards Horst Peter Alcibiades wrote: > > OK, all good things come to an end. > > So where do I get the next one? > > Peter > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/2.9-dp-3-for-linux-has-expired...%21-tp15649708p15649932.html Sent from the Revolution - User mailing list archive at Nabble.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: UPDATE table and quote in a text
Hey Trevor,
This works (of course) fine :-)
Thanks a lot also to Mark and Viktoras
Horst
Trevor DeVore wrote:
>
> On Feb 17, 2008, at 5:23 PM, Horst wrote:
>> I know, the easiest way would be to encode the data with
>> base64encode. But
>> there must also be a way to save a text f.e. like 1234'5'6öä'ioup"#
>> in a
>> varchar or text type. With base64encode it will f.e. not be possible
>> to use
>> the "fulltext" indexing, which I will need. No, there must be
>> another way.
>> SQL is not that silly and I learned, that RR is a a powerfull tool,
>> if you
>> (or someone else) knows the "tricks". Once again the question: How
>> to save
>> any text via RR to a SQL-Table as described before.
>
>
> Hi Horst,
>
> You can definitely insert any text into a database using Rev as long
> as you cleanse the input first. I've attached a modified handler from
> libDatabase that you can use to escape strings you want to use in an
> UPDATE clause.
>
> SQLite only requires for single quote to be escaped. MySQL has a
> slightly more complex escape sequence as does PostGreSQL. I haven't
> tested the postgresql code myself but I based the code off of some
> docs I found somewhere.
>
> Here is an example of how you could use it:
>
> ...
> put escapeStringForSQL("mysql", the text of field "UserSuppliedData")
> into theData
> put format("UPDATE my_table SET user_data = '%s' WHERE ID = %u",
> theData, theID) into theSQL
>
>
>
> Regards,
>
> --
> Trevor DeVore
> Blue Mango Learning Systems
> www.bluemangolearning.com-www.screensteps.com
>
>
>
> function escapeStringForSQL pDBType, pString
> switch pDBType
> case "mysql"
> replace numtochar(92) with numtochar(92) & numtochar(92)
> in pString --> \ to \\
> replace numtochar(39) with numtochar(92) & numtochar(39)
> in pString --> ' to \'
> replace numtochar(34) with numtochar(92) & numtochar(34)
> in pString --> " to \"
> replace numtochar(0) with numtochar(92) & numtochar(48)
> in pString --> NULL to \0
> replace numtochar(26) with numtochar(92) & numtochar(90)
> in pString --> Control-Z to \Z
> replace numtochar(10) with numtochar(92) & numtochar(110)
> in pString --> newline to \n
> replace numtochar(13) with numtochar(92) & numtochar(114)
> in pString --> carriage return to \r
> replace numtochar(9) with numtochar(92) & numtochar(116)
> in pString --> tab to \t
> replace numtochar(8) with numtochar(92) & numtochar(98)
> in pString --> backspace to \b
> break
> case "postgresql"
> replace numtochar(92) with numtochar(92) & numtochar(92)
> in pString --> \ to \\
> replace numtochar(39) with numtochar(39) & numtochar(39)
> in pString --> ' to ''
> replace numtochar(12) with numtochar(92) & numtochar(102)
> in pString --> formfeed to \f
> replace numtochar(10) with numtochar(92) & numtochar(110)
> in pString --> newline to \n
> replace numtochar(13) with numtochar(92) & numtochar(114)
> in pString --> carriage return to \r
> replace numtochar(9) with numtochar(92) & numtochar(116)
> in pString --> tab to \t
> replace numtochar(8) with numtochar(92) & numtochar(98)
> in pString --> backspace to \b
> break
> case "sqlite"
> default
> replace numtochar(39) with numtochar(39) & numtochar(39)
> in pString --> ' to ''
> break
> end SWITCH
> end lib escapeStringForSQL___
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
--
View this message in context:
http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15560555.html
Sent from the Revolution - User mailing list archive at Nabble.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: UPDATE table and quote in a text
Good morning Trevor,
Thanks for that. I´ll try tomorrow and let you know here
best regards
Horst
Trevor DeVore wrote:
>
> On Feb 17, 2008, at 5:23 PM, Horst wrote:
>> I know, the easiest way would be to encode the data with
>> base64encode. But
>> there must also be a way to save a text f.e. like 1234'5'6öä'ioup"#
>> in a
>> varchar or text type. With base64encode it will f.e. not be possible
>> to use
>> the "fulltext" indexing, which I will need. No, there must be
>> another way.
>> SQL is not that silly and I learned, that RR is a a powerfull tool,
>> if you
>> (or someone else) knows the "tricks". Once again the question: How
>> to save
>> any text via RR to a SQL-Table as described before.
>
>
> Hi Horst,
>
> You can definitely insert any text into a database using Rev as long
> as you cleanse the input first. I've attached a modified handler from
> libDatabase that you can use to escape strings you want to use in an
> UPDATE clause.
>
> SQLite only requires for single quote to be escaped. MySQL has a
> slightly more complex escape sequence as does PostGreSQL. I haven't
> tested the postgresql code myself but I based the code off of some
> docs I found somewhere.
>
> Here is an example of how you could use it:
>
> ...
> put escapeStringForSQL("mysql", the text of field "UserSuppliedData")
> into theData
> put format("UPDATE my_table SET user_data = '%s' WHERE ID = %u",
> theData, theID) into theSQL
>
>
>
> Regards,
>
> --
> Trevor DeVore
> Blue Mango Learning Systems
> www.bluemangolearning.com-www.screensteps.com
>
>
>
> function escapeStringForSQL pDBType, pString
> switch pDBType
> case "mysql"
> replace numtochar(92) with numtochar(92) & numtochar(92)
> in pString --> \ to \\
> replace numtochar(39) with numtochar(92) & numtochar(39)
> in pString --> ' to \'
> replace numtochar(34) with numtochar(92) & numtochar(34)
> in pString --> " to \"
> replace numtochar(0) with numtochar(92) & numtochar(48)
> in pString --> NULL to \0
> replace numtochar(26) with numtochar(92) & numtochar(90)
> in pString --> Control-Z to \Z
> replace numtochar(10) with numtochar(92) & numtochar(110)
> in pString --> newline to \n
> replace numtochar(13) with numtochar(92) & numtochar(114)
> in pString --> carriage return to \r
> replace numtochar(9) with numtochar(92) & numtochar(116)
> in pString --> tab to \t
> replace numtochar(8) with numtochar(92) & numtochar(98)
> in pString --> backspace to \b
> break
> case "postgresql"
> replace numtochar(92) with numtochar(92) & numtochar(92)
> in pString --> \ to \\
> replace numtochar(39) with numtochar(39) & numtochar(39)
> in pString --> ' to ''
> replace numtochar(12) with numtochar(92) & numtochar(102)
> in pString --> formfeed to \f
> replace numtochar(10) with numtochar(92) & numtochar(110)
> in pString --> newline to \n
> replace numtochar(13) with numtochar(92) & numtochar(114)
> in pString --> carriage return to \r
> replace numtochar(9) with numtochar(92) & numtochar(116)
> in pString --> tab to \t
> replace numtochar(8) with numtochar(92) & numtochar(98)
> in pString --> backspace to \b
> break
> case "sqlite"
> default
> replace numtochar(39) with numtochar(39) & numtochar(39)
> in pString --> ' to ''
> break
> end SWITCH
> end lib escapeStringForSQL___
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
--
View this message in context:
http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15540022.html
Sent from the Revolution - User mailing list archive at Nabble.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: UPDATE table and quote in a text
Holá Mark, ik wil u danken. I know, the easiest way would be to encode the data with base64encode. But there must also be a way to save a text f.e. like 1234'5'6öä'ioup"# in a varchar or text type. With base64encode it will f.e. not be possible to use the "fulltext" indexing, which I will need. No, there must be another way. SQL is not that silly and I learned, that RR is a a powerfull tool, if you (or someone else) knows the "tricks". Once again the question: How to save any text via RR to a SQL-Table as described before. best regards Horst Mark Schonewille-3 wrote: > > Hallo Horst, > > You could write a function to escape all special characters, but the > easiest and most reliable way is to encode the data with base64encode > () before storing it. > > Best regards, > > Mark Schonewille > > -- > > Economy-x-Talk Consulting and Software Engineering > http://economy-x-talk.com > http://www.salery.biz > > Convert colours between different colour spaces with Color Converter. > Download at http://economy-x-talk.com/cc.html > > > > Op 17-feb-2008, om 17:09 heeft Horst het volgende geschreven: > >> >> Holá Mark, >> >> The main question seems to be: How to "include" a textfile for >> example: >> .. >> put "1234'5'6öä'ioup"#" into mytext ## I know, this text is >> senseless, but >> never mind, it should be able to be saved >> replace quote with "\" & quote in mytext ## and then, how to >> replave the ' >> ??? >> put "UPDATE table set textfile = '" & mytext & "'... into sql_messqage >> revexecutesql (my_ID), sql_message >> put the result ## shows an SQL-Error message and mytext will not >> be saved >> .. >> >> best regards and, as usual, a big thank You for answering >> >> Horst >> > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15535637.html Sent from the Revolution - User mailing list archive at Nabble.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: UPDATE table and quote in a text
Holá Mark, The main question seems to be: How to "include" a textfile for example: .. put "1234'5'6öä'ioup"#" into mytext ## I know, this text is senseless, but never mind, it should be able to be saved replace quote with "\" & quote in mytext ## and then, how to replave the ' ??? put "UPDATE table set textfile = '" & mytext & "'... into sql_messqage revexecutesql (my_ID), sql_message put the result ## shows an SQL-Error message and mytext will not be saved .. best regards and, as usual, a big thank You for answering Horst Mark Schonewille-3 wrote: > > Dear Horst, > > Single quotes should be escaped the way you do and this should work > fine. I have seen reports of commands starting with revdb being > unable to escape single quotes, but this can be solved by using > revExecuteSQL -- I don't know whether there really is a bug with > escaping characters, I didn't encounter this problem myself. Make > sure that you only replace single quotes that are part of the data > and not the two single quotes that surround the string. > > Best regards, > > Mark Schonewille > > -- > > Economy-x-Talk Consulting and Software Engineering > http://economy-x-talk.com > http://www.salery.biz > > Convert colours between different colour spaces with Color Converter. > Download at http://economy-x-talk.com/cc.html > > > > Op 17-feb-2008, om 13:24 heeft Horst het volgende geschreven: > >> >> Hi there, >> >> A question to all SQL-Masters: >> To update a record in a SQL-Table and to store text which includes >> the " >> sign in an SQL-Syntax I learnd, that it is necessary to use >> >> replace quote with "\" & quote in zText >> Well, that works fine, but what about The ' sign? >> >> replace "'" with "\'" in zText >> seems NOT to work. >> >> Thanks a lot to all of you and best regards >> >> Horst >> -- >> View this message in context: http://www.nabble.com/UPDATE-table- >> and-quote-in-a-text-tp15529083p15529083.html >> Sent from the Revolution - User mailing list archive at Nabble.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 > > -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15530593.html Sent from the Revolution - User mailing list archive at Nabble.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
UPDATE table and quote in a text
Hi there, A question to all SQL-Masters: To update a record in a SQL-Table and to store text which includes the " sign in an SQL-Syntax I learnd, that it is necessary to use replace quote with "\" & quote in zText Well, that works fine, but what about The ' sign? replace "'" with "\'" in zText seems NOT to work. Thanks a lot to all of you and best regards Horst -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15529083.html Sent from the Revolution - User mailing list archive at Nabble.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
How to show a picture from a MySQL Database
Holá everybody, working happy with mySQL since a few month now. But, I can´t figure out how to show a picture stored in the database. Don´t know if it´s base64 encoded or not. As usual, it will be easy, but please give me a hand best regards -- View this message in context: http://www.nabble.com/How-to-show-a-picture-from-a-MySQL--Database-tf4898240.html#a14029189 Sent from the Revolution - User mailing list archive at Nabble.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: 2 slightly silly stacks
Hey Richmond, Can't find the stacks. Where did you put them? Best regards Horst Richmond Mathewson wrote: > > Just uploaded to RevOnline 2 stacks: > > 1. MachineDetails.rev ; illustration for the "hardware > info" discussion" > > 2. Finde.rev ; bl**dy silly really, but the > by-product of some fairly infantile messing-around I > was doing with FIND with a view to getting kids to > make their own picture-dictionaries. > > sincerely, Richmond Mathewson > > > > > > A Thorn in the flesh is better than a failed Systems Development Life > Cycle. > > > > ___ > Want ideas for reducing your carbon footprint? Visit Yahoo! For Good > http://uk.promotions.yahoo.com/forgood/environment.html > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/2-slightly-silly-stacks-tf4436593.html#a12669460 Sent from the Revolution - User mailing list archive at Nabble.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
QUARTAM Report
Hi there, Does anybody knows, when Version 1.1 will be out and, if the printout will be much better as now with all the printed pixels? A printout now looks like the needel-printer 20 years ago and this layout is out of discussion f.e. a professional invoice or other professional printouts. Does anybody has another idea? Best regards Horst -- View this message in context: http://www.nabble.com/QUARTAM-Report-tf3279004.html#a9119269 Sent from the Revolution - User mailing list archive at Nabble.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
UPDATE SQL-DB maker Errors
Holá Erverybody, I´m Using RR 2.7.4 and MySQL 4.1 I try to update an existing record with put "UPDATE post SET Mail_body =" & Mail_text & "' where lfdnr = " & Mail_Number into SQL_Befehl revexecute DB_ID SQL_Befehl Sometimes it works, sometimes not. So I found out, if the Mail_Text includes one " or ' the datas will not be Updated. OK, But, and that´s the question, How to solve the problem without changing the data to base64, because that seems to be a global problem an it makes no sense to convert all fields in my DB. I'm glad, if you have a helpfull hand thanks Horst -- View this message in context: http://www.nabble.com/UPDATE-SQL-DB-maker-Errors-tf3170373.html#a8794446 Sent from the Revolution - User mailing list archive at Nabble.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: ejecting a disk after using "the files" funtion
Hi Richard, Could you please post the link to ³Listing and Sorting Files in Revolution²? That sounds interesting, but I can´t find the article. best regards Horst -- View this message in context: http://www.nabble.com/ejecting-a-disk-after-using-%22the-files%22-funtion-tf2937580.html#a8254294 Sent from the Revolution - User mailing list archive at Nabble.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: Variables in DB Query Builder
Hola Jan, thanks for answering! You wrote: For now the easiest way to achieve dynamic queries is to save a template query somewhere, and fill in the dynamic parts, then update the SQL of the query using the undocumented command "'revSetSQLOfQuery ,". An example : ## on mouseUp put "123456" into tCustomerID # or some field data put "SELECT * FROM orders WHERE customerid='" & \ tCustomerID & "'" into tSQLStatement revSetSQLOfQuery "orders",tSQLStatement end mouseUp ## - Well, but what does this do? I don´t understand that. What to do with revSetSQLOfQuery "orders",tSQLStatement best regards Horst -- View this message in context: http://www.nabble.com/Variables-in-DB-Query-Builder-tf2832420.html#a7948998 Sent from the Revolution - User mailing list archive at Nabble.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
Variables in DB Query Builder
Holá SQL-Professionals, I´m thinking, how to put a variable Part in the SQL-Message of the DB Query builder f.e. Select Landname, Landvorwahl from land_kz where Landname BETWEEN "A%" AND "¦" ORDER BY Landname ASC; How to put the variable instead of "A%" witch makes by the way, no sense. Thanks for many good ideas and don´t let me alone :-) Best regards Horst -- View this message in context: http://www.nabble.com/Variables-in-DB-Query-Builder-tf2832420.html#a7907686 Sent from the Revolution - User mailing list archive at Nabble.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: Commands out of sync, you can ´ t run t his command now = FIXED NOW
Hello everybody, I´m happy that I found the reason for the message. I just changed revexecuteSQL DB_ID, SQL_Befehl to get revQueryDatabase (DB_ID, ... That´s it Thank you all for your help Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7904882 Sent from the Revolution - User mailing list archive at Nabble.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: Commands out of sync, you can ´ t run t his command now
Good morning Ken, You wrote: > I guess the only thing left to do is restart mySQL (either by restarting > the > server or at the command line) unless someone else has a better idea... > > Ok, But How? shut down the PC and start again? >Yes, the PC that is actually running mySQL server (i.e. not a client PC that >is simply *accessing* mySQL). Well, That´s (Shutdown the PC) what I did a few minutes ago. The message is still the same. Anybody with another idea? Thank you and best regards Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7904307 Sent from the Revolution - User mailing list archive at Nabble.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: Commands out of sync, you can ´ t run th is command now
Hi Ken, You say: I guess the only thing left to do is restart mySQL (either by restarting the server or at the command line) unless someone else has a better idea... Ok, But How? shut down the PC and start again? Well, I´m happy, that mySQL is running and I never thought about restarting Thank you Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7899560 Sent from the Revolution - User mailing list archive at Nabble.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: Commands out of sync, you can ´ t run thi s command now
Hi friends, I do (as possible) what ever you want me to do! It happens here: on closefield GLOBAL kundennummer, DB_ID ### Land Aendern # put the text of me into temp3 put "Select * from land_kz where Kfz_Kennz = '" & temp3 & "'" into SQL_Befehl revexecuteSQL DB_ID, SQL_Befehl ###### I hope, it helps. best regards Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7897154 Sent from the Revolution - User mailing list archive at Nabble.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: Commands out of sync, you can ´ t run thi s command now
Hi Ken, Thanks for answering :-)) You wrote: The only thing you can do (AFAIK) is close your connection to the server and then reopen it and try again. Well, that´s what I have done by closing RunRev. Than, I tried again, same message. So I uninstalled RunRev, deleted all RunRev Folders, to be sure, that nothing is working som ewhere behind. Installed RunRev again and... ... YES, the same message :-( Must be something else I think best regards Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7896415 Sent from the Revolution - User mailing list archive at Nabble.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
Commands out of sync, you can´t run this comman d now
Hi There, Do you know this message? And if so, what does it mean? best regards Horst -- View this message in context: http://www.nabble.com/Commands-out-of-sync%2C-you-cant-run-this-command-now-tf2828066.html#a7894721 Sent from the Revolution - User mailing list archive at Nabble.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
