livecode server, postgres

2011-12-13 Thread Malte Brill
Hi all, I have no idea why this would fail: It is working on the Mac. It fails on UBUNTU and Windows. Return value is revdberr, invalid database type Is this some sort of case sensitivity the mac is agnostic of? Lost once again... All help much appreciated, Malte __

Re: Running a multiline shell command

2011-12-13 Thread Bernard Devlin
How about if you set the shellCommand so that instead of pointing to "/bin/sh" it points to "/bin/tcsh", or even have the shellCommand set to point to "/usr/bin/telnet" itself. There are definitely some oddities with OS X and line endings (I seem to remember Mark Schonewille explaining it to me so

Re: livecode server, postgres

2011-12-13 Thread Roger Eller
On Tue, Dec 13, 2011 at 5:54 AM, Malte Brill wrote: > Hi all, > > I have no idea why this would fail: > > local tDBConnId > put > revOpenDataBase("postgresql","127.0.0.1:5432","grabung","postgres","postgres") > into tDBConnID > put tDBConnID > ?> > > It is working on the Mac. It fails on UBUN

Re: livecode server, postgres

2011-12-13 Thread Malte Brill
Hi Roger, each machine has its own Database Server, so localhost would be correct. I can connect to the database on each machines localhost. I got the UBUNTU server running again, now it is only the windows machine that is acting up. I reinstalled apache and updated to the 5.0 engine to no avai

Re: Re: livecode server, postgres

2011-12-13 Thread Malte Brill
I have now replaced dbpostgresql.dll in my CGI bin with the one that comes with the liveCode IDE and TADA it connects. Maybe it is just broken in Servers zip archive... H Cheers, Malte ___ use-livecode mailing list use-livecode@lists.runre

Re: livecode server, postgres

2011-12-13 Thread Van Brollini
Please, Do you have any idea as to why my mac version tells me I don't have a license and I am pretty sure I do, having upgraded in october. thanks in advance, van - Start Original Message - Sent: Tue, 13 Dec 2011 14:43:23 +0100 From: Malte Brill To: use-livecode@lists.runrev.com Subje

Re: sort by length of line (Weird)

2011-12-13 Thread Bob Sneidar
I went to bed thinking about this. Think about what would have to happen for Livecode to conclude this needed to be a numeric sort: It would have to evaluate every line in the sort, and if it found just one line that was not a number, it would have to then use a text sort. What if the list was 1

Re: sort by length of line (Weird)

2011-12-13 Thread Pete
Hi Mark, Looks like your bug report got changed to an enhancement request with not much chance of happening (reading between the lines). On Mon, Dec 12, 2011 at 6:10 PM, Mark Wieder wrote: > Craig- > > Monday, December 12, 2011, 5:18:26 PM, you wrote: > > > I'm OK with it. > > I'm sort of OK wit

Re: [OT] Ghostery

2011-12-13 Thread Bob Sneidar
A long time ago I noticed a memory leak, albeit a small one in Safari. Later I discovered it was a known problem, but it wasn't fixed for several versions thereafter. Maybe Apple thought it was so small that it didn't merit attention. By the time they fixed it I had given up and went with Firef

Re: Running a multiline shell command

2011-12-13 Thread Bob Sneidar
Oh interesting. I've been suspecting it was the particular shell that Livecode uses by default (I learned that from prior posts). Also, does using variables like that mask the actual username and password in the shell window? the downside to my method is that it opens a new shell window and then

Re: sort by length of line (Weird)

2011-12-13 Thread Richard Gaskin
Mark Wieder wrote: I'm sort of OK with it because there's a simple way to get the desired answer. But I filed bug 9910 requesting the simplified syntax with "numeric" being optional. Respectfully, I think it may be asking a bit much of the engine - and perhaps the scripter - to expect the eng

Re: [OT] Ghostery

2011-12-13 Thread Robert Brenstein
On 12.12.2011 at 15:59 Uhr -0800 Bob Sneidar apparently wrote: Wild turkey guess off the top of my head: Some "web bugs" as Jacque put it do not like being blocked and try to re-establish themselves, and they are what is leaking. Bob That would be too simple. Unfortunately, the problem is sa

Re: sort by length of line (Weird)

2011-12-13 Thread Colin Holgate
How did you sort those lines, before reading between them? On Dec 13, 2011, at 12:29 PM, Pete wrote: > Looks like your bug report got changed to an enhancement request with not > much chance of happening (reading between the lines). ___ use-livecode m

Re: sort by length of line (Weird)

2011-12-13 Thread Pete
I think Mark's point is specifically to do with the length function which can only return a numeric value. The suggestion is that the sort command should be smart enough to know that and automatically use a numeric sort (unless overridden) since it's not possible for text data to be produced. I a

Re: sort by length of line (Weird)

2011-12-13 Thread Bob Sneidar
You have to read between them to know how not to sort. Bob On Dec 13, 2011, at 10:04 AM, Colin Holgate wrote: > How did you sort those lines, before reading between them? > > > On Dec 13, 2011, at 12:29 PM, Pete wrote: > >> Looks like your bug report got changed to an enhancement request wit

Re: livecode server, postgres

2011-12-13 Thread Andre Garzia
Malte, This will sound stupid but too often I type the database type capitalized such as MySQL and Postgres, this will break under Linux because the file system is case-sensitive. It will look for dbMySQL.so instead of the correct dbmysql.so. Also, under linux you can: ldd dbpostgres.so And che

Re: sort by length of line (Weird)

2011-12-13 Thread Pete
Nice! I wish that had been a conscious play on words. On Tue, Dec 13, 2011 at 10:04 AM, Colin Holgate wrote: > How did you sort those lines, before reading between them? > > > On Dec 13, 2011, at 12:29 PM, Pete wrote: > > > Looks like your bug report got changed to an enhancement request with n

Re: livecode server, postgres [Van Brollini]

2011-12-13 Thread Malte Brill
Dear Van, I guess you are referring to animationEngine. What you will need to do in liveCode is go to Help-> relicense liveCode. Your license is tied to your liveCode license and thus it must be validated against their server. This lesson shows how it is done: http://lessons.runrev.com/s/lesson

Re: sort by length of line (Weird)

2011-12-13 Thread Mark Wieder
Colin- Tuesday, December 13, 2011, 10:04:50 AM, you wrote: > How did you sort those lines, before reading between them? Note to self: file enhancement request for sort between the lines of -- -Mark Wieder mwie...@ahsoftware.net ___ use-livecode

Re: sort by length of line (Weird)

2011-12-13 Thread stephen barncard
A downside with plain english style programming code methods is that this can lead to uncontrolled bouts of alliteration, pun-making and double entendre. Basic and COBOL people don't talk that way. On 13 December 2011 10:45, Pete wrote: > Nice! I wish that had been a conscious play on words. >

Re: sort by length of line (Weird)

2011-12-13 Thread Mark Wieder
Pete- Tuesday, December 13, 2011, 10:05:05 AM, you wrote: > I think Mark's point is specifically to do with the length function which > can only return a numeric value. The suggestion is that the sort command > should be smart enough to know that and automatically use a numeric sort > (unless ov

Re: sort by length of line (Weird)

2011-12-13 Thread Mark Wieder
stephen- Tuesday, December 13, 2011, 11:32:30 AM, you wrote: > A downside with plain english style programming code methods is that this > can lead to uncontrolled bouts of alliteration, pun-making and double > entendre. Basic and COBOL people don't talk that way. CONTINUE. -- -Mark Wieder mw

Re: sort by length of line (Weird)

2011-12-13 Thread Mark Wieder
Richard- Good points all. I'm not requesting that the sort command be smart enough to handle all situations, but this is enough of a confusing point that I think the engine could benefit from some extra smarts. A simple parsing optimization for cases like sort tVar by length(each) could insert t

Re: Applescript for getting data from a spreadsheet

2011-12-13 Thread Bob Sneidar
Thanks to all who offered help on Applescript and Shell access. I now have a functioning stack that will query a Procurve switch for mac addresses, and compare it to my Spreadsheet data to show me what device is using that mac address, and on which port on the switch it is. Next phase: Go thro

Possible bug setting a watch point

2011-12-13 Thread Bob Sneidar
Hi all. I tried setting a watch on a global variable. I set it to gSiteID <> "3". Each time I do this Livecode CTD's. I have removed all plugins to verify it's not something with one of those, but the problem persists. Can anyone else verify this happens to them before I attempt a bug rep

[OT] Delivering Content on Facebook

2011-12-13 Thread Scott Rossi
Hi List: I have a client who is interested in implementing a Flash quiz I built in Facebook and I'm looking for some help in figuring out options for this. If anyone out can offer any insight and maybe some consulting time, please contact me off list. Thanks! Regards, Scott Rossi Creative Dire

Re: livecode server, postgres [Van Brollini]

2011-12-13 Thread Van Brollini
hmm, I only have one license and process did not behave as indicated in license. I think you are correct. Not fixed as yet. thanks van - Start Original Message - Sent: Tue, 13 Dec 2011 20:24:40 +0100 From: Malte Brill To: use-livecode@lists.runrev.com Subject: Re: livecode server, postg

Re: [OT] Delivering Content on Facebook

2011-12-13 Thread Bob Sneidar
I wonder if Facebook has an API published? They must have something. Bob On Dec 13, 2011, at 12:16 PM, Scott Rossi wrote: > Hi List: > > I have a client who is interested in implementing a Flash quiz I built in > Facebook and I'm looking for some help in figuring out options for this. If > an

Re: Possible bug setting a watch point

2011-12-13 Thread Mark Wieder
Bob- Tuesday, December 13, 2011, 12:04:11 PM, you wrote: > Hi all. > I tried setting a watch on a global variable. I set it to gSiteID > <> "3". Each time I do this Livecode CTD's. I have removed all > plugins to verify it's not something with one of those, but the > problem persists. > C

Re: Possible bug setting a watch point

2011-12-13 Thread Bob Sneidar
5.02. The latest greatest. Bob On Dec 13, 2011, at 1:17 PM, Mark Wieder wrote: > Bob- > > Tuesday, December 13, 2011, 12:04:11 PM, you wrote: > >> Hi all. > >> I tried setting a watch on a global variable. I set it to gSiteID >> <> "3". Each time I do this Livecode CTD's. I have remove

Re: sort by length of line (Weird)

2011-12-13 Thread Richard Gaskin
Mark Wieder wrote: Richard- Good points all. I'm not requesting that the sort command be smart enough to handle all situations, but this is enough of a confusing point that I think the engine could benefit from some extra smarts. A simple parsing optimization for cases like sort tVar by length

Re: sort by length of line (Weird)

2011-12-13 Thread Mark Wieder
Richard- Tuesday, December 13, 2011, 1:48:56 PM, you wrote: > There are others, and they wind up consuming a fair amount of time when > I'm teaching someone LiveCode for the first time. > Exceptions require memorization, and with a language this broad it can > helpful to keep the rule set as sma

Re: sort by length of line (Weird)

2011-12-13 Thread Bob Sneidar
eerm... yes we can. Bob On Dec 13, 2011, at 2:20 PM, Mark Wieder wrote: > in the same > way that we can't just say "add 1 to x" ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage yo

Re: ios image file names

2011-12-13 Thread J. Landman Gay
On 12/12/11 11:42 PM, edward cawley wrote: Jacque, I used your suggestion and got the following : 12/12/11 11:23:43 PM/Users/ecawley/Library/Application Support/iPhone Simulator/4.1/Applications/9D450172-E7E2-4FA3-8C03-E761055E3180/Lawn2.app/Lawn2[6296] AVController -[AVControll

Re: Screen redraw after visual effect

2011-12-13 Thread J. Landman Gay
On 12/13/11 12:00 AM, Peter Bogdanoff wrote: Yes, audio is playing while the visual effect happens with no audio issues. Setting the currentTime didn't seem to fix the redraw. I do want to keep the controller on the card as there are multiple windows that each may have playing audio of their o

Setting the value of a button hilite in script

2011-12-13 Thread Pete
I wrote myself a script to set the initial values of controls on a card in preOpenCard. It looks for a custom property name cInitialValue, then initialises the control to the value of the custom property, depending on that type of control (field, button, etc). I set the value of cInitialValue for

Re: Setting the value of a button hilite in script

2011-12-13 Thread J. Landman Gay
On 12/13/11 4:50 PM, Pete wrote: I wrote myself a script to set the initial values of controls on a card in preOpenCard. It looks for a custom property name cInitialValue, then initialises the control to the value of the custom property, depending on that type of control (field, button, etc). I

characters lost pasting from Word To LiveCode field

2011-12-13 Thread Sieg Lindstrom
I use a LiveCode app (OSX) to parse text taken from Word files, glean relevant data, write records to a database and also reformat the original text in certain ways. I copy and paste text from Word into a field in my app, click a button and it does the rest, until I upgraded to 5.0x. I'll say up f

Re: Setting the value of a button hilite in script

2011-12-13 Thread Bob Sneidar
Hmmm... breakpoint in the loop and check that the control you think you are setting is actually a checkbox or radio button, then make sure the property is what you think it is. Also check for a carriage return in the property. That bit me in the butt recently. Bob On Dec 13, 2011, at 2:50 PM

Re: Setting the value of a button hilite in script

2011-12-13 Thread Pete
l check for empty in the cprop and ignore it if so. The control that's being processed when I get the error is a checkbox. I don't get any errors on other type of controls except checkboxes and radio buttons when trying to set their hilite. On Tue, Dec 13, 2011 at 3:02 PM, J. Landman Gay wrote:

RE: characters lost pasting from Word To LiveCode field

2011-12-13 Thread Mark Powell
Hi Sieg I have lot of fields that I have to handle like this and have found that a pasteKey handler in the field serves my purposes. It first does put the clipboardData["text"] into tTemp followed by various filtering and replacement, followed by put tTemp into me Which of course replaces th

Re: characters lost pasting from Word To LiveCode field

2011-12-13 Thread Bob Sneidar
Pasting from Office applications has been discussed in length in prior threads, but the gist of it is, Microsoft maintains their own internal clipboard to facilitate pasting between their dissimilar applications, so that a range of cells copied from a spreadsheet can be pasted into a word docume

Re: characters lost pasting from Word To LiveCode field

2011-12-13 Thread Bernard Devlin
Is it possible to export the text from Word as RTF, then import into Livecode as RTF? Bernard On Tue, Dec 13, 2011 at 11:09 PM, Sieg Lindstrom wrote: > I use a LiveCode app (OSX) to parse text taken from Word files, glean > relevant data, write records to a database and also reformat the origina

Re: Setting the value of a button hilite in script

2011-12-13 Thread Mark Wieder
Pete- Try it without the parentheses. It's kind of unpredictable when they'll work and when they won't. This works for me where the parenthetical one gives me an error. set the hilite of control x of this card to the cInitialValue of \ control x of this card -- -Mark Wieder mwie...@ahsoftware.

Re: use-livecode Digest, Vol 99, Issue 23

2011-12-13 Thread Sieg Lindstrom
Thanks Bob & Mark. Bob's fix sounds like the ticket. As to whether I'd blame Microsoft or RunRev, my first inclination is to blame Microsoft. However, this is the third time I've had to retool for different handling of characters like the em dash over several updates of RunRev/LiveCode, always past

RE: characters lost pasting from Word To LiveCode field

2011-12-13 Thread Sieg Lindstrom
Thanks Bob & Mark. Bob's fix sounds like the ticket. As to whether I'd blame Microsoft or RunRev, my first inclination is to blame Microsoft. However, this is the third time I've had to retool for different handling of characters like the em dash over several updates of RunRev/LiveCode, always past

Checkbox in datagrid column

2011-12-13 Thread Bob Sneidar
Hi all. I guess this would be a zryip question. It may be too difficult to attempt, but I am going to give it a try anyway. I have a datagrid that already contains data. There are 3 modes to the form, browse, edit and newrecord. In edit and newrecord mode I want to display a checkbox in a co

Re: characters lost pasting from Word To LiveCode field

2011-12-13 Thread Bob Sneidar
Yes. It's called "Textedit". You 2 hop it and all works wonderfully. Now that I think about it, I wonder what Applescript could do... Bob On Dec 13, 2011, at 4:41 PM, Bernard Devlin wrote: > Is it possible to export the text from Word as RTF, then import into > Livecode as RTF? > > Bernard >

Re: Setting the value of a button hilite in script

2011-12-13 Thread Pete
Hi Mark, That's where I started - I added the parens to see if it made any difference. I just tried it again without the parens and still get the same error. Wonder if it's a version thing - I'm on 4.6.4 On Tue, Dec 13, 2011 at 5:01 PM, Mark Wieder wrote: > Pete- > > Try it without the parenth

Re: [OT] Ghostery

2011-12-13 Thread Pete
Thanks for introducing me to Ghostery - it's opened up a whole new world of tracking that I had no idea was going on. A lot of sites use Google Analytics of course and I'm not inclined to block that since I've used it myself and found it very useful. I don;t believe it keeps anything more intrusi

Re: Checkbox in datagrid column

2011-12-13 Thread Pete
I think the easiest way would be to change the dgvisible property of the checkbox column to true or false depending on the requirements. On Tue, Dec 13, 2011 at 5:21 PM, Bob Sneidar wrote: > Hi all. > > I guess this would be a zryip question. It may be too difficult to > attempt, but I am going

Re: Setting the value of a button hilite in script

2011-12-13 Thread Phil Davis
Hi Pete, I'm not always good at staying on-topic, but maybe some of this will help... On 12/13/11 2:50 PM, Pete wrote: I wrote myself a script to set the initial values of controls on a card in preOpenCard. It looks for a custom property name cInitialValue, then initialises the control to the

Re: Setting the value of a button hilite in script

2011-12-13 Thread Pete
Thanks for the suggestions Phil. I'm attempting to put initial values into all the controls on the card not just buttons. My code figures out what type of control it's dealing with by looking at the first word of the abbrev name, then the menumode and style if it's a button. Once it's figured ou

Supported versions of OS X

2011-12-13 Thread Pete
Just tried to install an LC app on OS X 10.2.x and it won't run. The icon appears in the dock then disappears before any app screen shows. I suspect 10.2 isn;t supported? Is there a log file I can look at somewhere to confirm the problem? -- Pete Molly's Revenge

Re: Supported versions of OS X

2011-12-13 Thread Marty Knapp
Hey Pete, The last few versions of LC require 10.4 or newer if I remember correctly. I see from the release notes that the current version 5.0.2 does. Marty Just tried to install an LC app on OS X 10.2.x and it won't run. The icon appears in the dock then disappears before any app screen show

Re: Supported versions of OS X

2011-12-13 Thread Pete
Thanks Marty, I was pretty sure that was the case. Pete On Tue, Dec 13, 2011 at 7:35 PM, Marty Knapp wrote: > Hey Pete, > The last few versions of LC require 10.4 or newer if I remember correctly. > I see from the release notes that the current version 5.0.2 does. > > Marty > > Just tried to in

Ann: Installer Maker Plugin 1.7 for LiveCode with 16 new features

2011-12-13 Thread Mark Schonewille
Dear all, I'm pleased to announce that after 6 months of hard work Economy-x-Talk is releasing Installer Maker 1.7. Installer Maker is a plug-in for LiveCode, which allows you to wrap your standalones in an installer with only LiveCode itself --no additional software needed. This version cont

Re: characters lost pasting from Word To LiveCode field

2011-12-13 Thread J. Landman Gay
On 12/13/11 5:09 PM, Sieg Lindstrom wrote: I'll say up front the details of text encoding are not my strong suit. With earlier versions (RunRev 4.x and earlier), I'd sometimes have to write special routines to search and replace certain characters from the pasted text. For example, the em-dash,

Re: Setting the value of a button hilite in script

2011-12-13 Thread Mark Wieder
Pete- Tuesday, December 13, 2011, 5:23:11 PM, you wrote: > Hi Mark, > That's where I started - I added the parens to see if it made any > difference. I just tried it again without the parens and still get the > same error. Wonder if it's a version thing - I'm on 4.6.4 I did that on 4.6.4 as we

Re: Setting the value of a button hilite in script

2011-12-13 Thread J. Landman Gay
On 12/13/11 11:37 PM, Mark Wieder wrote: Pete- Tuesday, December 13, 2011, 5:23:11 PM, you wrote: Hi Mark, That's where I started - I added the parens to see if it made any difference. I just tried it again without the parens and still get the same error. Wonder if it's a version thing - I'm

Re: Setting the value of a button hilite in script

2011-12-13 Thread Pete
Very strange. As mentioned, I got round the problem by using a do command: do "set the hilite of control x of this card to" && the cInitialValue of control x of this card That worked with no other changes to the overall logic of the handler in detecting what type of control I'm dealing with. Pe