Somebody has to say it ....
that's one of the reasons why "Variable checking (aka explicitVariables)
is so useful, it helps to catch things like this.
Of course, it is unfortunately not available in LC Server scripts :-(
So I should go add an enhancement request.
The only reason I haven't done that before is that my typical LCServer
script looks like
<?lc
set the errormode to inline
start using stack "thewholething"
justdoit
?>
and all the real code lives within stacks, which can be developed and
debugged locally.
-- Alex.
On 07/06/2015 00:59, Mike Bonner wrote:
You're welcome. Fresh eyes are usually pretty helpful. I get code blind
LOTS and end up putting it away for a while in hopes that I'll get some of
that freshness back. Seldom works, but I keep trying!
On Sat, Jun 6, 2015 at 4:46 PM, JOHN PATTEN <johnpat...@me.com> wrote:
Yup. That was it… It’s incredible how easy it is to miss this kind of
thing and waste time :(
I can’t wait until I can just tell the robot to write the code for what I
describe. The robot would never make this type of error ;)
Thanks Again!
On Jun 5, 2015, at 5:14 PM, Mike Bonner <bonnm...@gmail.com> wrote:
You're putting your data to post into ArgList
And you're posting tArgList
If thats not a typo here, I suspect its the typo culprit there.
On Fri, Jun 5, 2015 at 5:01 PM, JOHN PATTEN <johnpat...@me.com> wrote:
Thanks Matthias,
I did try both ways $_POST and $_GET. I get the same results; a new
record is created but the fields are empty. By the way, the "LiveCode
Cloud" tutorials show $_POST for inserting new record too.
I’ll keep looking :)
On Jun 5, 2015, at 3:39 PM, Matthias Rebbe | M-R-D <
matthias_livecode_150...@m-r-d.de> wrote:
John,
if you post data to a livecode server script then you need to use
$_post[] instead of $_get
$_get[] is used if you add the parameters to the url like
put URL ("
http://username.on-rev.com/ipad_1/add_datga_2.lc?object_name=“
& tName) into tResult
Regards,
Matthias
Am 06.06.2015 um 00:31 schrieb JOHN PATTEN <johnpat...@me.com>:
Hi All,
I must be missing something simple and I can’t find it…
I have a mysql database with one table and one field. Varchar(1000)
I have a LiveCode project with one button and the following code:
on mouseUp
put urlEncode(the name of target) into tName
put "object_name=" & tName into ArgList
--answer ArgList
post tArgList to URL "http://username.on-rev.com/ipad_1/add_data_2.lc
"
end mouseUp
My .lc file looks like this:
<?lc
put revOpenDatabase ("mysql”,"username.on-rev.com
”,"username_ipad_2”,"username_ipad_2”,"password")
into tConID
put "ipad_data" into tTableName
put $_GET["object_name"] into object_name
put "object_name" into tFields
put "INSERT INTO" && tTableName && "(" & tFields & ") VALUES (:1);"
into tSQL
revExecuteSQL tConID, tSQL, "object_name"
revCloseDatabase tConID
put empty
?>
The .lc script creates a new record but it never puts the name of the
button in the object_name field? The record is completely empty. I was
having the same problem on a much more complex database and script, so I
thought I would super simplify but I’m still having the problem.
Does anybody see anything I’m missing?
Thank you!
John Patten
SUSD
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
