AFAIK it is possible to add your parameter in the WHERE clause.
So maybe you can test on NULL or NOT EMPTY as the first condition before the
other ones.
Cheers,
Erik
Kay C Lan wrote:
What is the trick to passing an empty variable to a mySQL database
using placeholders?
I have an SQL statem
What is the trick to passing an empty variable to a mySQL database
using placeholders?
I have an SQL statement that works in SQLite and mySQL except if the
value is empty, in which case it doesn't work with mySQL (works OK
with SQLite). I'm using a placeholder :1. If I remove the place holder
and
looks like a candidate for the dictionary and the release notes for 8...
On Thu, Aug 4, 2016 at 9:25 PM, Lyn Teyla wrote:
> Ali Lloyd wrote:
>
> > You can use the global property
> >
> > the scriptExecutionErrors
> >
> > To obtain this list. Note that this does not work in a standalone so if
> y
Hello Graham,
that’s what I’m looking for too, after seeing widgets on the great conference
in Edingburgh this week.
CrossPlatform, Opensource and free alternative is Inkscape.
An advanced substitute vor Illustrator in my opinion is AffinityDesigner (Mac)
for 40 £ and now also available as
Another possibility would be to add some code to the delete object code to
confirm, but undo would be better.
On Fri, Aug 5, 2016 at 12:37 PM, Bob Sneidar
wrote:
> Brilliant!
>
> Bob S
>
>
> On Jul 20, 2016, at 11:24 , Peter Haworth mailto:pete@
> lcsql.com>> wrote:
>
> I can only offer a third
Wha??!? Free BEER???
Bob S
On Aug 5, 2016, at 11:38 , Richard Gaskin
mailto:ambassa...@fourthworld.com>> wrote:
> /Inkscape./
Seconded.
Inkscape is free as in beer, free as in freedom, and made by really nice people
you can meet at the SoCal Linux Expo and other open source conferences. Gr
Ok, everyone - it’s Inkscape. To reassure Peter, I do normally contribute money
to stuff that’s created from community efforts as soon as I start using it
seriously.
Thanks to all who replied.
Graham
> On 5 Aug 2016, at 20:06, Peter TB Brett wrote:
>
> On 05/08/2016 15:57, Graham Samuel wrot
I use InkScape, the one mentioned by many, for laser milling. It takes some
effort to get up to speed. I miss Cricket Draw.
One important thing to remember, whatever the tool, is that you can edit by
hand if need be if there are quirks in the file. These are usually in scaling.
If your
On 05/08/2016 15:57, Graham Samuel wrote:
Having got very interested in LC widgets at the conference, I’m about to start
experimenting, but I need to create some SVG graphics based on my own designs.
I can’t afford Illustrator - has anyone got any recommendations for a free, or
at any rate, no
richmond wrote:
> On 08/05/2016 03:57 PM, Graham Samuel wrote:
>> Having got very interested in LC widgets at the conference, I’m
>> about to start experimenting, but I need to create some SVG graphics
>> based on my own designs. I can’t afford Illustrator - has anyone got
>> any recommendations
My preferate: Affinity Designer
https://affinity.serif.com
Thierry
2016-08-05 16:57 GMT+02:00 Graham Samuel :
> Having got very interested in LC widgets at the conference, I’m about to
> start experimenting, but I need to create some SVG graphics based on my own
> designs. I can’t afford Illus
/Inkscape./
/Richmond./
//
On 08/05/2016 03:57 PM, Graham Samuel wrote:
Having got very interested in LC widgets at the conference, I’m about to start
experimenting, but I need to create some SVG graphics based on my own designs.
I can’t afford Illustrator - has anyone got any recommendatio
On 08/05/2016 09:57 AM, Graham Samuel wrote:
Having got very interested in LC widgets at the conference, I’m about to start
experimenting, but I need to create some SVG graphics based on my own designs.
I can’t afford Illustrator - has anyone got any recommendations for a free, or
at any rate,
Brilliant!
Bob S
On Jul 20, 2016, at 11:24 , Peter Haworth
mailto:p...@lcsql.com>> wrote:
I can only offer a third party solution. My lcStackbrowser plugin remembers
all deleted objects (stacks, cards, controls) until you quit and you can
undo the delete of any of them from either a contextual
I've seen this happen with Copiers when scanning to file. Since the credentials
being used are valid, a placeholder for the file is created by the system, but
when the write of the data is attempted, it fails, either due to UAC or some
sandboxing issue. This has the effect of leaving a 0 byte fi
I happen to think that editing a data grid as a means of updating a database is
a little messy. What I do is I have a form for every table (I use a separate
stack for each table because I can manage the custom behaviors for each
application more effectively). I name the fields "fld" & the column
Just for your information.
Livecode support asked me to submit it as a bug.
http://quality.livecode.com/show_bug.cgi?id=18151
Matthias
> Am 05.08.2016 um 15:34 schrieb Matthias Rebbe
> :
>
> Hi,
>
> maybe i am missing something.
>
> I have here a script which connects fine in LC6 to a DB u
Set a global, then have an idle handler in a back script check the global. Have
the idle handler check the contents of the global. If empty pass idle,
otherwise and accordingly, then reset the global to empty when done.
Bob S
On Jul 23, 2016, at 11:05 , Dr. Hawkins
mailto:doch...@gmail.com>>
Is there a such thing as "first group"? If so, then "last group" has to mean
the one with the highest ordinal. So perhaps we need something like "latest
group" or "newest group"?
Bob S
On Aug 3, 2016, at 07:31 , Richard Gaskin
mailto:ambassa...@fourthworld.com>> wrote:
Thanks for moving that
Air 2. The problem seems to be a combination of Apple not being ready
(apparently I, and others ran into the issue because the servers were
overwhelmed, so the download timed out), a crap error message that doesn't
tell you what's really going on, and whatever is going on with the
Developer portal
Thanks Jacque. :-)
Bob S
On Aug 4, 2016, at 12:29 , J. Landman Gay
mailto:jac...@hyperactivesw.com>> wrote:
It's El Capitan, Apple changed the rules again.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscrib
Having got very interested in LC widgets at the conference, I’m about to start
experimenting, but I need to create some SVG graphics based on my own designs.
I can’t afford Illustrator - has anyone got any recommendations for a free, or
at any rate, not very expensive, editor suitable for making
Dave, for me and I would guess a lot of others who aren’t so bad at coding in
LC, **deployment** on the chosen platforms is the BIG show-stopper; so I’d like
to see a workshop that creates a trivial app (say a variation on the
clock/stopwatch theme - but it could be anything), discusses the diff
While i'm not yet good at reading json directly, i'm guessing mergeJson
works similarly to the built in json library, so I shoved your first sample
into a field and did the following in the message box.
put jsonimport(field 1) into tdat; put the keys of tdat
>From that first example, it looks lik
Roger Eller wrote:
> On Thu, Aug 4, 2016 at 12:46 PM, Richard Gaskin wrote:
>> And is there a way to make mobile-savvy menus from LC popup menus,
>> or do we need to roll our own for those too?
>
> I remember an old webinar where LC demonstrated (at least on iOS) a
> desktop pop-up automatically
Further correction (sorry!) There were some more levels to the JSON file...
Still trying to get the total_count value as well value from item 1/2 which
is the email address:
{"status":200,"response":{"entries":[{"1.6":"LName","transaction_id":null,"6":"","payment_date":null,"4":"This
is just a
tes
Clarification: I am looking to get the total_count value from this sample
JSON file:
{"entries":[{"payment_date":null,"transaction_id":null,"6":"","1.6":"LName","payment_method":null,"is_fulfilled":null,"form_id":2,"status":"active","post_id":null,"4":"This
is just a
test","is_starred":0,"transac
Good morning LC'ers!
I have been able to successfully user mergJson to create a treeview of my
JSON data, but I have a quick question: If I wanted to get a specific
value, several "levels" deep, how would I format that that code?
Thank you for your help!
SKIP
___
Hi,
maybe i am missing something.
I have here a script which connects fine in LC6 to a DB using an odbc
connection string.
The connection string looks like this:
get revOpenDatabase("ODBC","Driver={Actual SQL
Server};Server=192.168.1.250;Database=testdb;UID=mr;PWD=Baj43jaX;",,,)
In LC7 and up
Dave,
the first question is what is your aim? Is it to show people how to
program in LC or is it to hilight how LC can help them?
If it is the former, then most of the suggestions given will fit the
bill perfectly; they are just examples of something already done, but
you show them how to do it i
30 matches
Mail list logo
