Hmm can't try it now but if you use the substitution form for the insert
(revExecuteSQL myID, insert into mytable values(:1,:2,:1),
valueX,valueY)
does it work that way?
On Tue, Jan 31, 2012 at 12:55 AM, Mike Bonner bonnm...@gmail.com wrote:
urlencode the data before putting it into the db,
Hehe, had another little look at it this afternoon and now I'm sending little
messages to my wife :-)
Also added a few things to the video recording external: edit video, save video
to photo album and save image to photo album.
Hi Monte,
an external to manage the bluetooth stuff in GameKit
Apostrophe is a reserved character in SQL so you'll have to escape it.
If you take the part of your INSERT statement that has the field with
the apostrophe in it and expand the variable (i.e., write it in with
the *contents *of the variable instead (e.g., INSERT
.,'[[globaldata] ]'
On 31/01/2012 12:32, Len Morgan wrote:
Apostrophe is a reserved character in SQL so you'll have to escape it.
If you take the part of your INSERT statement that has the field with
the apostrophe in it and expand the variable (i.e., write it in with
the *contents *of the variable instead (e.g.,
Mike,
Thank you so much for sharing this here. Hope doesn't always get a front page
story yet it is so very very powerful. I'm really very grateful for you sharing
this.
-- Tom McGrath III
http://lazyriver.on-rev.com
3mcgr...@comcast.net
On Jan 30, 2012, at 11:17 PM, Ralph DiMola wrote:
Wow, this is great, Monte, I really need the Push Notification in all of my
apps. Even just local would be great. Video recording and Game Kit are a bonus
as well.
What is your experience so far working with the SDK and with xCode? Gotcha's,
advice, etc?
-- Tom McGrath III
Thx everyone for all the well wishes, and thanks for letting me post my
glee! The amount of stubborn refusal to quit that has kept me trying is
finally paying off. It is so strange. As a kid I used to dream of flying.
In recent years that has shifted to dreams of walking around (you know the
Mike,
Thanks for sharing your good news. You've brought a bright spot to everyone's
day here.
I've always believed there is more real inspiration and hope in the lives of
real people than in any Hollywood epic.
Best wishes for many more good days,
Devin
On Jan 30, 2012, at 7:53 PM, Mike
Thx again all. I'm not usually much of a gusher but sometimes the
milestones are big enough you just have to share.
The link for the curious is here. http://guidezone.info/walking.html I
don't write very well and make up for it by trying way too hard but
hopefully its readable.
Escape your data first. I am sure someone has written an SQL escape library.
Another way might be to encode your data before inserting/updating and decode
it in your select statements. sqlYoga automagically escapes your data for you
if you use the commands and functions provided. (I should get
merge([[artist]][[policeman]]) = A brush with the law
Sorry I had to.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
WOOT!
On Jan 30, 2012, at 6:53 PM, Mike Bonner wrote:
Ok. I know this is not the most appropriate place for this but.. Today for
the first time in about 12 years I walked 5 unassisted steps in physical
therapy. (no walker, cane, walking sticks or anything) And no face plant!
So on the count
Two different topics here, I think, - escaping single (and double) quotes
and sql injection. Both appear to be solved with the revExecuteSQL
substitution.
If you don't use revExecuteSQL solution then there's two choices for
escaping. SQL accepts either single or double quotes to enclose
YAY!! Congrats Mike
On Tue, Jan 31, 2012 at 3:22 PM, Bob Sneidar b...@twft.com wrote:
WOOT!
On Jan 30, 2012, at 6:53 PM, Mike Bonner wrote:
Ok. I know this is not the most appropriate place for this but.. Today for
the first time in about 12 years I walked 5 unassisted steps in
For those interested in automating GUI tasks without writing tedious
Applescript, VBSCript, etc, take a look at http://sikuli.org/
--
Pete
Molly's Revenge http://www.mollysrevenge.com
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please
On 01/31/2012 04:53 AM, Mike Bonner wrote:
Ok. I know this is not the most appropriate place for this but.. Today for
the first time in about 12 years I walked 5 unassisted steps in physical
therapy. (no walker, cane, walking sticks or anything) And no face plant!
So on the count of 3. 1, 2,
Well done Mike. That's quite an inspirational story, you obviously don't give
up too easily.
Best wishes for the future, but for now I'd say you certainly deserve a beer.
Paul
On 31 Jan 2012, at 16:04, Mike Bonner wrote:
Thx again all. I'm not usually much of a gusher but sometimes the
Hi all.
I was given to understand that the dgDataOfLine referenced the visible lines of
a datagrid, so that if I scrolled to the bottom of a datagrid that had 8
visible lines, the dgDataOfLine[8] would give me the mast line of data. It
seems this is not so, unless something has gone wrong in
On 01/02/2012, at 06:12 AM, Bob Sneidar wrote:
Hi all.
I was given to understand that the dgDataOfLine referenced the visible lines of
a datagrid, so that if I scrolled to the bottom of a datagrid that had 8
visible lines, the dgDataOfLine[8] would give me the mast line of data. It
seems
On 1/31/12 10:04 AM, Mike Bonner wrote:
The link for the curious is here. http://guidezone.info/walking.html
Thanks very much for posting that. It made me think about why I love
LiveCode. I had a major life setback 25 years ago that propelled me into
the abyss -- and the only thing that
Mike, thanks for sharing... a very inspiring journey that makes many of our
day-to-day irritations and struggles in living pale in comparison. I wish
you MUCH SUCCESS!!
-- Mark
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/OT-Walking-tp4343357p4345637.html
Sent
Hi Thomas
I'm quite enjoying the iOS sdk. It's certainly a breeze compared to the sdk for
the other platforms. I hope they all get updated to match. The main gotcha I've
found the test app won't copy in any resources so in most cases it's e to
test via livecode.
As for push
Greetings,
I added a data grid obj to a project recently but encountered a
problem once I built a standalone. The data grid worked fine in the
ide but did not load the data in the standalone. I tested just my
implementation of the data grid in a single stack and the standalone
worked fine. The
Thank you all... you have left me with a number of great suggestions to look
into. It does seem like using variable lists as in the substitution
approach would be the more/most generic solution to this problem... since
I'm on a deadline I'll probably do a quick and dirty escape on apostrophe
On Jan 31, 2012, at 11:35 AM, Terry Judd wrote:
On 01/02/2012, at 06:12 AM, Bob Sneidar wrote:
Hi all.
I was given to understand that the dgDataOfLine referenced the visible lines
of a datagrid, so that if I scrolled to the bottom of a datagrid that had 8
visible lines, the
Peter Haworth-2 wrote
If you use single quotes, double quotes don't need to be escaped in the
literal, and vice versa. So, if you're sure that your data won't contain
double quotes, then you can use double quotes to enclose the literals and
single quotes won't cause a problem.
Pete
You're right, it would mess things up - sorry, didn't look closely enough
at your code. The only way you could do it would be to use LC's quote
constant but that would make setting up the merge command a horrendous
mess!
To be honest though, I usually just build the VALUES part of the SQL
Monte,
Actually that might still be useful because I can poll for the reason for the
scheduled notif and react accordingly. I just don't know how useful…..
-- Tom McGrath III
http://lazyriver.on-rev.com
3mcgr...@comcast.net
On Jan 31, 2012, at 2:44 PM, Monte Goulding wrote:
Hi Thomas
I'm
I am looking for beta testers for my first publicly available Livecode
application, SQLiteAdmin.
SQLiteAdmin is an database administration tool for configuring and editing
the data in SQLite databases. It provides a GUI interface to all the
available SQLite Data Definition Statements. It also
Hold the phone... it looks like there's a workaround using
NSNotificationCenter. I'll look into it.
On 01/02/2012, at 8:03 AM, Thomas McGrath III wrote:
Monte,
Actually that might still be useful because I can poll for the reason for the
scheduled notif and react accordingly. I just don't
Hi Pete,
I'd love to test for you. I'm currently building SQL that is running
100 to 150 lines in some cases just to update a simple view.
I'm running sqlite and Mysql (mysql runs on windows server 2008 and
another Linux version running on a Synology 212 NASS) on LC 5.02 on
Mac Lion, Windows 7
Hi Jeff,
Thanks for volunteering. Just to clarify, this is a database
administration tool (create tables, indexes, triggers, etc) with some basic
data editing capabilities, not a end user/developer's tool.
Just mentioning that since you brought up the amount of code you're having
to write to do
I'd love to test SQLAdmin for you!
Jeff
On Tue, Jan 31, 2012 at 4:59 PM, Pete p...@mollysrevenge.com wrote:
Hi Jeff,
Thanks for volunteering. Â Just to clarify, this is a database
administration tool (create tables, indexes, triggers, etc) with some basic
data editing capabilities, not a end
I am getting ready to release a LC app for B2B use. Also an app for public
use. Both use SQLite DBs. I would love to test it for you.
Ralph DiMola
IT Director
Evergreen Information Services
-Original Message-
From: use-livecode-boun...@lists.runrev.com
Hi Ralh,
Thanks for volunteering. I'm putting the finishing touches to packaging
and installation right now but I should be able to point you to a download
in the next couple of days.
What flavour of OS X/Windows are you on?
Thanks,
Pete
On Tue, Jan 31, 2012 at 2:14 PM, Ralph DiMola
Hi all.
I know I can detect dgScrollBarDragV, but that gets sent whether or not the
actual data scrolls. It is possible to move the elevator box a slight bit and
not have it effect the data in the datagrid. I only want to know what the
visible data has changed. Any ideas? I already looked
On Jan 31, 2012, at 11:35 AM, Terry Judd wrote:
On 01/02/2012, at 06:12 AM, Bob Sneidar wrote:
Hi all.
I was given to understand that the dgDataOfLine referenced the visible
lines of a datagrid, so that if I scrolled to the bottom of a datagrid that
had 8 visible lines, the
Pete,
Went to a Irish festival in Saratoga Springs NY this summer and saw some
great bands. One that stood out was 4 or 5 betties with the front man being
the drummer. She had pipes that just projected from NY to CA. There was one
driving beat tune that stuck in my head for weeks. They gave me
Hi all.
I know I can detect dgScrollBarDragV, but that gets sent whether or not the
actual data scrolls. It is possible to move the elevator box a slight bit and
not have it effect the data in the datagrid. I only want to know what the
visible data has changed. Any ideas? I already
Hmm... I can't seem to convince NSNotificationCenter to send the
UIApplicationDidFinishLaunchingNotification notification. I suspect somehow
externals are loaded after that's sent. I'm not sure. So we are back to apps
launching without knowing they are launching in response to a notification.
Peter Haworth-2 wrote
so I just have to:
put buildValuesClause(globaldate,tmaternalname,tmaternalphin,etc) after
tSQL
I put that together before I knew revexecuteSQL substitution deals with
all that and more but it kinda works for me.
Smart. Sounds like the direction I will be
This is very neat.
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Automated-Testing-Tool-tp4345249p4346888.html
Sent from the Revolution - User mailing list archive at Nabble.com.
___
use-livecode mailing list
42 matches
Mail list logo