Re: Remote database access: How?

2009-06-07 Thread Mark Schonewille
Hi Tereza, A host may not allow direct access to a database. You may indeed need a CGI or PHP script, which I do by default nowadays. However, if you can connect with Navicat, I'd expect you'd be able to connect with any other tool, including your own. Haven't you forgotten to set the pas

Re: Remote database access: How?

2009-06-07 Thread Nicolas Cueto
Hi Tereza, > A great chasm of ignorance is open at my feet. Having gotten across that chasm -- barely! -- I hesitate to re-approach, but, in case it helps you, I'll brave some advise that were the keys to my Rev 2.9 + SQL successful setup. > Do I need to install a rev cgi on the remote server t

Re: What do Rev programmers charge per hour for programming?

2009-06-07 Thread Kay C Lan
On Mon, Jun 8, 2009 at 12:28 AM, Andre Garzia wrote: > > I am thinking about creating a new service of elegant designer > fashionable code tied to the price of some undisclosed quantity of > porcini mushrooms, high quality pasta, dried tomatoes, tons of spices > and good wine. > > So long as you

Re: dead click functions

2009-06-07 Thread J. Landman Gay
dunb...@aol.com wrote: Jacques: Well, OK, but then why do the "loc-like" functions always seem to work? And why then do the "text-like" functions always work within the object itself? If, as you say, the engine only checks at the exact moment the script asks for it, then I don't get it. The

Re: Array keys oddity?

2009-06-07 Thread Kay C Lan
On Sun, Jun 7, 2009 at 6:00 PM, Bernard Devlin wrote: > Part of the problem is that we refer to these containers in Rev as > "arrays". Really what Rev has is a container that is more > appropriately referred to as a "dictionary". It is commonplace in > other languages to expect that a dictionar

Remote database access: How?

2009-06-07 Thread Tereza Snyder
Hi All, I told my client Rev could do it...and now I'm stuck! Here's what my app needs to do: 1) user downloads Rev app from web page 2) user runs app 3) user types username and password 4) app looks up username/password in remote MySQL database ...if found: 5) user does stuff with app that

Re: [OT] Customs

2009-06-07 Thread Kay C Lan
On Sun, Jun 7, 2009 at 11:03 PM, Andre Garzia wrote: > > Another funny time in the U.S. was when I was trying to leave the > country and they made me strip, I will not enter in any detail and > will deny everything I believe it was caught on video and distributed on youTube: http://www.youtube

Re: dead click functions

2009-06-07 Thread DunbarX
Jacques: Well, OK, but then why do the "loc-like" functions always seem to work? And why then do the "text-like" functions always work within the object itself? If, as you say, the engine only checks at the exact moment the script asks for it, then I don't get it. The engine, at mouseUp, knows at

Re: replaceText

2009-06-07 Thread -= JB =-
I think you have a point and will store it as a binary in a custom property. thanks again -=>JB<=- On Jun 7, 2009, at 2:11 PM, Richmond Mathewson wrote: There are 2 schools of thought about this sort of problem: 1. The elegant code school. 2. The garden spade school. I belong to the sec

Re: What do Rev programmers charge per hour for programming?

2009-06-07 Thread Charles Szasz
Thanks to everyone for their comments. Charles Szasz wrote: > > What do Rev programmers charge per hour for programming? > -- View this message in context: http://www.nabble.com/What-do-Rev-programmers-charge-per-hour-for-programming--tp23898061p23916336.html Sent from the Revolution - User

Re: replaceText

2009-06-07 Thread -= JB =-
I am actually not storing strings in fields in the sense you might think. I am put html code in one field, a list of file names in another field and a list of files in the third field. I am using rev to access folders and get the files and then update the code with that file list. My scho

Re: replaceText

2009-06-07 Thread Richmond Mathewson
There are 2 schools of thought about this sort of problem: 1. The elegant code school. 2. The garden spade school. I belong to the second; as I am not unduly worried about the fact that a couple of extra lines of code may add a few micro-seconds to the time taken for it to execute. Hence the "D

Re: replaceText

2009-06-07 Thread -= JB =-
Got it working, thanks I was concerned if it would find the text if it had other characters on each side instead of spaces and like you say it works. -=>JB=- On Jun 7, 2009, at 1:46 PM, Richmond Mathewson wrote: I don't think Runtime Revolution as such parses words the way human beings do, it

Re: replaceText

2009-06-07 Thread Richmond Mathewson
I don't think Runtime Revolution as such parses words the way human beings do, it will replace any string (or part thereof) with any other string. For the sake of argument try this: on mouseUp put "id=d2b516" into oldWord put "id=xyz59wk" into newWord if fld id 1004 contains "id=d2b516" then

Re: replaceText - correction

2009-06-07 Thread -= JB =-
That did it! I was going to tell you I got an error because for some reason I didn't change fSATUFF to fld id 1004 but you caught it before I had a chance. thanks to everyone for the help. -=>JB<=- On Jun 7, 2009, at 1:22 PM, Richmond Mathewson wrote: Sorry, should have written: on mouseUp

Re: replaceText

2009-06-07 Thread -= JB =-
Will this work if it needs to be characters and not words? I will give it a try and get back with you. -=>JB<=- On Jun 7, 2009, at 1:19 PM, Richmond Mathewson wrote: Dunno what all the fuss is about; this works: on mouseUp put "id=d2b516" into oldWord put "id=anything" into newWord if fl

Re: replaceText

2009-06-07 Thread Richmond Mathewson
If you really insist on using replaceText you can do this: on mouseUp put "id=d2b516" into oldWord put "id=anything" into newWord if fld id 1004 contains "id=d2b516" then put replaceText(fld id 1004, oldWord, newWord) into fld id 1004 end if end mouseUp in my opinion it seems rather les

Re: replaceText - correction

2009-06-07 Thread Richmond Mathewson
Sorry, should have written: on mouseUp put "id=d2b516" into oldWord put "id=anything" into newWord if fld id 1004 contains "id=d2b516" then replace oldWord with newWord in fld id 1004 end if end mouseUp rather than on mouseUp put "id=d2b516" into oldWord put "id=anything" into newWord if

Re: replaceText

2009-06-07 Thread Richmond Mathewson
Dunno what all the fuss is about; this works: on mouseUp put "id=d2b516" into oldWord put "id=anything" into newWord if fld id 1004 contains "id=d2b516" then replace oldWord with newWord in fld "fSTUFF" end if end mouseUp -= JB =- wrote: Below is a piece of text from the field, /link

Re: replaceText

2009-06-07 Thread Mark Schonewille
Longer please? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com Snapper Screen Recorder 2.0.1 http://snapper.economy-x-talk.com If you sent me an e-mail before 15 May and haven't got a reply yet, please send me a reminder. On

Re: replaceText

2009-06-07 Thread -= JB =-
Below is a piece of text from the field, /link.php?&gr=1&id=d2b516&url=/ftt/ I will be replacing id=d2b516 with id=anything -=>JB<=- On Jun 7, 2009, at 1:00 PM, Mark Schonewille wrote: JB, can you post a piece of the text you are modifying? -- Best regards, Mark Schonewille Economy-x-Tal

Re: replaceText

2009-06-07 Thread Mark Schonewille
JB, can you post a piece of the text you are modifying? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com Snapper Screen Recorder 2.0.1 http://snapper.economy-x-talk.com If you sent me an e-mail before 15 May and haven't got a reply

Re: What do Rev programmers charge per hour for programming?

2009-06-07 Thread Richmond Mathewson
I will not stoop to haggis flavoured pot noodles; however, I am more than happy to tell any interested parties about deep-fried haggis and black-pudding: far less MSG, far more "healthy, healthy, healthy" super-saturated fat. Haggis flavoured pot noodles would be like having to depend on HyperNex

Re: replaceText

2009-06-07 Thread -= JB =-
In the code below the reason I delete chars is because I am actually replacing the same line twice but the first time that line has id= before it with no .jpg while the second time it has thumbs/ before it and a .jpg after. Any ideas on how to accomplish this task? -=>JB<=- On Jun 7, 2009,

Re: replaceText

2009-06-07 Thread Jim Ault
Please note the difference in programming languages between a command and a function syntax. Command replace findWords with newWords in fld "fSTUFF" --the original has been changed Function put replaceText(field "Stats",return,comma) into newTextBlock --the original remains unchanged --the new

Re: replaceText

2009-06-07 Thread -= JB =-
The original script is more complex than the one I relayed before. I have a field with a bunch of text and then I have a field with a number of lines of chars that now match the chars in my field with text. I also have a field with a number of lines of chars that will replace each line of t

Re-2: ON-REV SQL host/server name?

2009-06-07 Thread runrev260805
Why sorry. On-Rev belongs to Rev, so the question is here in place. Use just your on-rev domain-name. In my case i use matthias.on-rev.com with HeidiSQL and that works. Regards, Matthias Original Message Subject: Re: ON-REV SQL host/server name? (07-Jun-2009 19:57) From:

Re: replaceText

2009-06-07 Thread Richmond Mathewson
Funnily enough I've nev r used this before . . . Tried your recipe and duplicated your error & more importantly: I know why . . . If you look in the Documentation under replaceText it shows this: replaceText(field "Stats",return,comma) while your replacetext(fld id 1004, findWords, replaceWo

Re: replaceText

2009-06-07 Thread Mark Schonewille
Hmmm... wait a sec... Which version of Revolution are you using and are you executing this function from the message box? If so, there is a problem with the message box, which now requires you to put "put" or "get" in front of every function you execute from the message box. -- Best regar

Re: replaceText

2009-06-07 Thread Mark Schonewille
OK, JB, Could you post your actual script? Do you realise that this is a function, not a command? You need to use "put". -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com Snapper Screen Recorder 2.0.1 http://snapper.economy-x-talk.c

Re: replaceText

2009-06-07 Thread -= JB =-
Hi Mark, error 573 handler can't find handler -=>JB<=- On Jun 7, 2009, at 12:24 PM, Mark Schonewille wrote: JB, what error? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com Snapper Screen Recorder 2.0.1 http://snapper.economy-x

Re: replaceText

2009-06-07 Thread Mark Schonewille
JB, what error? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering http://economy-x-talk.com Snapper Screen Recorder 2.0.1 http://snapper.economy-x-talk.com If you sent me an e-mail before 15 May and haven't got a reply yet, please send me a reminder. On

replaceText

2009-06-07 Thread -= JB =-
The Rev dictionary shows the following two forms for replaceText, replacetext("malformed","mal","well") -- returns "wellformed" replacetext(field "Stats",return,comma) -- makes comma-delimited Let's say I want to replace the text "Hello world" in fld id 1004 with "Another Day" I put "Hello w

Re: [OT] Customs

2009-06-07 Thread Richmond Mathewson
Exactly the reverse! Mark Wieder wrote: Richmond- Sunday, June 7, 2009, 10:22:44 AM, you wrote: If you'll drive a car from San Francisco to Edinburgh, I'll swim there from Bulgaria! Is this more like what you were thinking of? http://www.edinburgh-scotland.net/images/Leith%20Port%2

Re: [OT] Customs

2009-06-07 Thread Andre Garzia
I am thinking about borrowing the ferryboat that crosses the guanabara bay here in Rio. I think a ferry service from Rio to Edinburgh would be pretty popular still need a captains license though... (my old license don't allow me to go out of the bay area, but, hey, catch me if you can!) On Su

Re: What do Rev programmers charge per hour for programming?

2009-06-07 Thread Andre Garzia
Richmond, I've been a grad student for 10 years, believe me when I say I hold a bachelor degree on noodles. In edinburgh, I might go for hosteling so, don't think me as being not nice to the whole student class or those that count their pennies because I do that too. And since you like noodles so

Re: ON-REV SQL host/server name?

2009-06-07 Thread stephen barncard
never mind, I'll use the FORUM instead. Sorry for the OT. - Stephen Barncard San Francisco http://barncard.com 2009/6/7 stephen barncard > I'd like to know how to get the hostname of the MYSQL server at ON-REV? > I'm trying to use Navicat to manage.Couldn't find any i

Re: [OT] Customs

2009-06-07 Thread Mark Wieder
Richmond- Sunday, June 7, 2009, 10:22:44 AM, you wrote: > If you'll drive a car from San Francisco to Edinburgh, > I'll swim there from Bulgaria! Is this more like what you were thinking of? http://www.edinburgh-scotland.net/images/Leith%20Port%20Sign4.jpg -- -Mark Wieder mwie...@ahsoftware.

RE: What do Rev programmers charge per hour for programming?

2009-06-07 Thread Lynn Fredricks
> That remark about Cup Noodles was not very nice: > > The first thing I will do when I arrive in Edinburgh is stock > up on Pot/Cup Noodles to last me through the conference: > > Pot Noodles occupy an important position in my personal > development, having got me through my Bachelor's degree a

ON-REV SQL host/server name?

2009-06-07 Thread stephen barncard
I'd like to know how to get the hostname of the MYSQL server at ON-REV? I'm trying to use Navicat to manage.Couldn't find any info on the cPanel or anywhere else. also will 'localhost' work for SQL calls from within? - Stephen Barncard San Francisco http://barncard.com _

Re: [OT] Customs

2009-06-07 Thread stephen barncard
THAT is an awesome bridge. I've seen it on 'Modern Marvels' on the History channel. - Stephen Barncard San Francisco http://barncard.com 2009/6/7 Richmond Mathewson > If you'll drive a car from San Francisco to Edinburgh, > I'll swim there from Bulgaria! > > Let's meet

Re: [OT] Customs

2009-06-07 Thread Richmond Mathewson
If you'll drive a car from San Francisco to Edinburgh, I'll swim there from Bulgaria! Let's meet on the beach by the bridge: http://www.edinburgh-scotland.net/galleryEHQueensferry.htm stephen barncard wrote: I'm SO NOT looking forward to traveling internationally, something I haven't done sinc

Re: What do Rev programmers charge per hour for programming?

2009-06-07 Thread Richmond Mathewson
That remark about Cup Noodles was not very nice: The first thing I will do when I arrive in Edinburgh is stock up on Pot/Cup Noodles to last me through the conference: Pot Noodles occupy an important position in my personal development, having got me through my Bachelor's degree and all those ni

Re: [OT] Customs

2009-06-07 Thread stephen barncard
I'm SO NOT looking forward to traveling internationally, something I haven't done since 2000. I really really hate flying today. Guilty until proven innocent. If I have to go to LA, I'll rent a car and DRIVE. - Stephen Barncard San Francisco http://barncard.com 2009/6/7 A

Re: What do Rev programmers charge per hour for programming?

2009-06-07 Thread Andre Garzia
my price fluctuates with the variations of the market forces behind quality tea and coffee I have a special price for NGOs and academics in general which is tied to the Cup Noodles price I am thinking about creating a new service of elegant designer fashionable code tied to the price of some

Re: [OT] Customs

2009-06-07 Thread Andre Garzia
Well Friends I've been to some really interesting places during our conferences, I made airport connections everywhere since getting tickets from frequent flyer reward program has a rule that you will connect at least your age divided divided by three. And mind you that I an a mid age Brazilian an

Re: [OT] Customs

2009-06-07 Thread Bernard Devlin
Never mind coming in to the UK. I always get a grilling from Customs when I'm trying to leave the UK to go to France. They are always incredibly rude and aggressive, asking the most personal of questions, but they never search in my bags but always hold me back for at least 20 minutes. Meanwhile

Re: Array keys oddity?

2009-06-07 Thread Bernard Devlin
Part of the problem is that we refer to these containers in Rev as "arrays". Really what Rev has is a container that is more appropriately referred to as a "dictionary". It is commonplace in other languages to expect that a dictionary object will return the keys in an unsorted (and generally unpr

Re: What do Rev programmers charge per hour for programming?

2009-06-07 Thread Richmond Mathewson
I never charge for anything (except EFL teaching) per hour; to my mind that stinks; lazy types like myself, safe in the knowledge they were being paid by the hour would take things in a leisurely fashion and the end result would be continually delayed. Of course teaching kiddos English is diffe