Re: SQL IN() function

Hard to tell without knowing more about the app, but it feels like your devicelist should be a separate table with one entry per device and probably keyed by the key of the original table Pete lcSQL Software On May 23, 2015 2:32 AM, "Dr. Hawkins" wrote: > On Fri, May 22, 2015 at 1:13 PM, Bob Sne

Re: crashing LiveCode regularly with this innocent-looking script

I’m using LiveCode 7.04 Community Edition, Build 10030. Thanks, Ben, you got me 1/2 way there. Creating a button with just “send testyears()” on mouseup does exactly what I expected with no crash. So it’s not the function I should look at, it’s the invocation in the field script on closefield:

Re: Livecode <=> SQL?

> Le 23 mai 2015 à 02:30, Dr. Hawkins a écrit : > > On Thu, May 21, 2015 at 7:58 PM, Pierre Sahores > wrote: >>> I'm not sure what you're saying here--I'm assuming a central server being >>> hit by >>> clients around the country, wo how can locahost handle that? >> >> The remote client -> HT

Re: SQL IN() function

On Fri, May 22, 2015 at 1:13 PM, Bob Sneidar wrote: > Because it is a list of integers, which is a string. I suppose I could have > used archer, but when I am uncertain how many values might end up in the > column, I always go with some kind of blob to be safe. There is also TEXT, which has no

Re: Livecode <=> SQL?

On Thu, May 21, 2015 at 7:58 PM, Pierre Sahores wrote: >> I'm not sure what you're saying here--I'm assuming a central server being >> hit by >> clients around the country, wo how can locahost handle that? > > The remote client -> HTTPS -> Apache -> (LC-Server -> PostgreSQL, both those > two la

Re: crashing LiveCode regularly with this innocent-looking script

Bob Sneidar writes: > > Once I fixed the smart quote it works as expected, but you should know that > the cancel button does nothing, > which is unexpected. Why is that unexpected? There's no code to exit on Cancel. The loop will continue until the user finally gives in and types an integer. -

Re: Again HTML5...

On 22/05/15 23:19, Richard Gaskin wrote: Richmond wrote: On 22/05/15 22:26, Richard Gaskin wrote: Roger Eller wrote: > I remember several years passing while the "Revolution" website > stated "New version for Irix - Coming Soon". And then suddenly, > the supported OS list went from 7 or 8 to

Re: Again HTML5...

Richmond wrote: On 22/05/15 22:26, Richard Gaskin wrote: Roger Eller wrote: > I remember several years passing while the "Revolution" website > stated "New version for Irix - Coming Soon". And then suddenly, > the supported OS list went from 7 or 8 to just 3. Are you using Irix? That ques

Re: crashing LiveCode regularly with this innocent-looking script

Once I fixed the smart quote it works as expected, but you should know that the cancel button does nothing, which is unexpected. Bob S On May 22, 2015, at 13:17 , Bob Sneidar mailto:bobsnei...@iotecdigital.com>> wrote: First, one of these quotes is a smart quote… Bob S On May 22, 2015, at

Re: crashing LiveCode regularly with this innocent-looking script

First, one of these quotes is a smart quote… Bob S On May 22, 2015, at 09:44 , Tony Vazquez mailto:ton...@zquez.us>> wrote: if it is an integer then exit repeat else ask "This needs to be a year." with “1492" ___ use-livecode mailing list use

Re: Again HTML5...

On 22/05/15 22:26, Richard Gaskin wrote: Roger Eller wrote: > I remember several years passing while the "Revolution" website > stated "New version for Irix - Coming Soon". And then suddenly, > the supported OS list went from 7 or 8 to just 3. Are you using Irix? That question is not the po

Re: SQL IN() function

varchar (stupid spell correct) > On May 22, 2015, at 13:13 , Bob Sneidar wrote: > > Because it is a list of integers, which is a string. I suppose I could have > used archer, but when I am uncertain how many values might end up in the > column, I always go with some kind of blob to be safe. >

Re: SQL IN() function

Because it is a list of integers, which is a string. I suppose I could have used archer, but when I am uncertain how many values might end up in the column, I always go with some kind of blob to be safe. Bob S > On May 22, 2015, at 01:26 , Peter Haworth wrote: > > IN works fine in sqlite to

Re: Again HTML5...

On 22/05/15 22:17, Roger Eller wrote: On Fri, May 22, 2015 at 3:08 PM, Richmond wrote: On 22/05/15 21:10, Glen Bojsza wrote: I am not certain if I missed the announcement but if so I apologize for asking again? What does "soon" mean? I didn't really think this was such a difficult question

Re: Again HTML5...

On Fri, May 22, 2015 at 3:26 PM, Richard Gaskin wrote: > Roger Eller wrote: > > > I remember several years passing while the "Revolution" website > > stated "New version for Irix - Coming Soon". And then suddenly, > > the supported OS list went from 7 or 8 to just 3. > > Are you using Irix? > >

Re: LC-only 'POST' file upload code?

Phil Davis writes: > > That was my concern too. I've done the simple POST as Mark showed but > have never uploaded a file that way. OK - my bad. I missed the 'file' part of uploading there. I *have* uploaded files using the curl method, but haven't tried the bare-bones post. Probably depends

Re: Again HTML5...

Roger Eller wrote: > I remember several years passing while the "Revolution" website > stated "New version for Irix - Coming Soon". And then suddenly, > the supported OS list went from 7 or 8 to just 3. Are you using Irix? -- Richard Gaskin Fourth World Systems Software Design and Developme

Re: LC-only 'POST' file upload code?

On Fri, May 22, 2015 at 8:40 AM, Richard Gaskin wrote: > > Why File Upload Forms are a Major Security Threat > yes, Little Bobby Tables https://xkcd.com/327/ -- Stephen Barncard - Sebastopol Ca. USA - Deeds Not Words

Re: Again HTML5...

On Fri, May 22, 2015 at 3:08 PM, Richmond wrote: > On 22/05/15 21:10, Glen Bojsza wrote: > >> I am not certain if I missed the announcement but if so I apologize for >> asking again? >> >> What does "soon" mean? >> >> I didn't really think this was such a difficult question but apparently I >> st

Re: Again HTML5...

On 22/05/15 21:10, Glen Bojsza wrote: I am not certain if I missed the announcement but if so I apologize for asking again? What does "soon" mean? I didn't really think this was such a difficult question but apparently I still have idea as to when to expect HTML5... Again I ask the question.

Go to method for interface resizing (for mobile)

Good afternoon LC'ers What is everybody's go to method for resizing mobile interfaces and / or components on those apps. Good old fashioned coding? Geometry manager? Some of my older tools don't seem to be working any more for this purpose. Thanks for your input! SKIP _

Re: [OT] More on false timeouts and headers

On 5/22/2015 3:25 AM, Mark Waddingham wrote: Dave's patch to libURL should solve the issue for you. Just to confirm: the patch does solve the problem. We just ran a test and the data is coming through as expected. This is a big relief. Thank you all so much. Now we just need to figure out wh

Again HTML5...

I am not certain if I missed the announcement but if so I apologize for asking again? What does "soon" mean? I didn't really think this was such a difficult question but apparently I still have idea as to when to expect HTML5... Again I ask the question. regards, Glen On Wed, Apr 29, 2015 a

Re: [OT] More on false timeouts and headers

On 5/22/2015 3:25 AM, Mark Waddingham wrote: Thus it seems to me that Dave is correct - this is actually a bug in libURL - it is being too lax when parsing headers and interpreting a header it should not be thus meaning it is not entering into 'chunked' mode even though it is explicitly specified

Re: crashing LiveCode regularly with this innocent-looking script

Hi Tony, Does it crash if you invoke this function directly, or only when it is called in the context of a closeField handler? Which version of LiveCode do you see this in? thank you, Ben On 22/05/2015 17:44, Tony Vazquez wrote: I’m playing a little with error messages, or trying to, but I

crashing LiveCode regularly with this innocent-looking script

I’m playing a little with error messages, or trying to, but I’m crashing LiveCode instead. A closeField message sends us to this function when something other than an integer was entered into it: function testYears put "" into it repeat until it is an integer if it is an integer then

Re: LC-only 'POST' file upload code?

J. Landman Gay wrote: > I use that to talk to servers but does that work with files? Don't > you need credentials or something? Yes, POST covers the client side. For the server side this tutorial shows how to extract that incoming data and write it to a file:

Re: LC-only 'POST' file upload code?

Phil: I have a script that posts successfully to PHP on a server. I use it to upload files and access mySQL databases. If you’re interested, I’ll scare it up. Best, Bill > On May 22, 2015, at 12:57 AM, Phil Davis wrote: > > Thanks Dave. I'll investigate. > Phil > > On 5/22/15 12:18 AM, Dave Cra

Re: [ANN] mergAV 4, mergBanner 2 & iOS 8.3 builds

Just a followup on barcode scanning in mergAV. Our guys started using this in one of our inside apps, this week, and they are amazed and amped over how fast and accurate it is. They can't wait to get rid of our existing CCD scanners and PC software so they can do everything on ipads and ipods. Th

Re: SQL IN() function

and, I have found that IN doesn't like parameter substitution, for whateve reason. On Fri, May 22, 2015 at 4:26 AM, Peter Haworth wrote: > IN works fine in sqlite to find any item in the supplied list. Having said > that, I've never used it with a BLOB type. Can't tell from your post but is > th

Re: SQL IN() function

IN works fine in sqlite to find any item in the supplied list. Having said that, I've never used it with a BLOB type. Can't tell from your post but is there a reason you're using BLOB rather than INTEGER? How is your devicelist formatted? Pete lcSQL Software On May 21, 2015 10:10 AM, "Bob Sneidar

Re: [OT] More on false timeouts and headers

On 2015-05-21 23:44, J. Landman Gay wrote: To be honest, you've been more help than anyone else, for which I'm really grateful. She originally contacted the Passenger forum and they had little to offer outside of "your app should be handling the chunking. Not our problem." And then they locked th

Re: LC-only 'POST' file upload code?

Thanks Dave. I'll investigate. Phil On 5/22/15 12:18 AM, Dave Cragg wrote: On 22 May 2015, at 02:02, Phil Davis wrote: Does anyone have a LC code you're willing to share that uploads a file to a server via POST? I'm looking for pure LC code, not where LC is used to build an HTML form that up

Re: LC-only 'POST' file upload code?

That was my concern too. I've done the simple POST as Mark showed but have never uploaded a file that way. Phil On 5/21/15 10:30 PM, J. Landman Gay wrote: I use that to talk to servers but does that work with files? Don't you need credentials or something? On May 21, 2015 11:27:40 PM CDT, Ph

Re: LC-only 'POST' file upload code?

> On 22 May 2015, at 02:02, Phil Davis wrote: > > Does anyone have a LC code you're willing to share that uploads a file to a > server via POST? I'm looking for pure LC code, not where LC is used to build > an HTML form that uploads a file in revBrowser or other browser. > > Here's hoping! Ot