Search found 361 matches

by AxWald
Wed Nov 01, 2017 5:12 pm
Forum: Databases
Topic: Sanitization
Replies: 10
Views: 1609

Re: Sanitization

Hi, SELECT * FROM bugs WHERE id=:1 Is there any documentation what this actually does? In the end there's a SQL string that is sent to the db, sure. Means, I know how to use the "id=:1" syntax - I just don't know what magik LC does to justify a statement like: If you use query parameters, sql-inject...
by AxWald
Mon Oct 30, 2017 12:02 pm
Forum: Databases
Topic: Sanitization
Replies: 10
Views: 1609

Re: Sanitization

Hi, attached a stack to play with. It's not a 'real SQL Sanitation', but it helps a lot for getting unwanted chars removed/ replaced from your input. It's a tool to setup 2 arrays ("Replace array" & "Kill array") that are later used for replacement/ killing potentially harmful chars from an input st...
by AxWald
Mon Sep 18, 2017 10:26 am
Forum: Databases
Topic: API or remote database?
Replies: 8
Views: 1964

Re: API or remote database?

Hi, have you read this already? Obviously: revexecuteSQL gConnectionID, "BEGIN TRANSACTION; repeat with x = 1 to the number of lines of (the keys of tAPIArray) put "INSERT into dbname (col1, col1, .... col20) values [...] into tSQL revExecuteSQL gConnectionID, tSQL end repeat revexecuteSQL gConnecti...
by AxWald
Fri Sep 08, 2017 10:34 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Find my IP Address?
Replies: 18
Views: 3919

Re: Find my IP Address?

Hi, The bigger question here is: why is the address needed? There's quite many possibilities why you would want to know your external IP: For checking the functionality of your DynDNS, for pinging/ portscanning yourself from the outside, for finding your clients data in the log on a remote server et...
by AxWald
Sat Sep 02, 2017 2:58 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Accessing Table Field Data
Replies: 9
Views: 1464

Re: Accessing Table Field Data

Hi, I could only find this online and it totally confused me: http://lessons.livecode.com/m/datagrid/l/7313-how-do-i-get-data-associated-with-a-row-or-column That's about "DataGrids". These are a different beast from table fields. You can think of the datagrid as a tablefield with attached arrays, s...
by AxWald
Sat Sep 02, 2017 11:40 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Accessing Table Field Data
Replies: 9
Views: 1464

Re: Accessing Table Field Data

Hi, [...] the data into a Table Field with 4 lines down and 2 columns across . All I am trying to do is access the second columns that contain the important data. [...] set itemdel to tab get item 2 of line 1 of fld "table_fld" This way? [...] So my question is....is there a straight forward way to ...
by AxWald
Sat Jul 29, 2017 1:44 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: FTP Upload on mobile device
Replies: 15
Views: 1781

Re: FTP Upload on mobile device

Hi,

here's a stack that asks for credentials, doesn't save anything. APK made from the exact stack works flawlessly, here. But is too large to append :/

Hope it helps! Have fun!
by AxWald
Fri Jul 28, 2017 2:41 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: FTP Upload on mobile device
Replies: 15
Views: 1781

Re: FTP Upload on mobile device

Hi, [...] Both times it worked perfectly fine on Windows, the file was uploaded with the given name but both times I get a crash on my android device. [...] Really strange. I have code like this installed on various Android devices, never had problems with it (using it to provide log files/ telemetr...
by AxWald
Thu Jul 27, 2017 1:41 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: FTP Upload on mobile device
Replies: 15
Views: 1781

Re: FTP Upload on mobile device

Hi, this code here works for me (LC 6.7.10 ("search required inclusions", permission: "Internet"), Android 5.0.1). Just tested again: on mouseUp -- setting up Vars: -- put URLEncode("myUserName") into myUSR -- Username put URLEncode("mySecretPassWord") into myPSW -- Password put "myDomain.org/" into...
by AxWald
Tue Jul 04, 2017 9:06 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: revExecuteSQL failure
Replies: 5
Views: 938

Re: revExecuteSQL failure

Hi,

you may want to post the resulting tSQL string for better inspection, and, most important, "the result" after the call to revExecuteSQL.

Have fun!
by AxWald
Wed Jun 21, 2017 2:15 pm
Forum: Talking LiveCode
Topic: Sending emails with LiveCode
Replies: 6
Views: 2392

Re: Sending emails with LiveCode

Hi,

for sending EMails on Win MailAlert does a very fine job for me.

Have fun!
by AxWald
Thu Jun 15, 2017 1:18 pm
Forum: Android Deployment
Topic: Using the updated Android SDK / Android Studio with LiveCode
Replies: 3
Views: 1040

Re: Using the updated Android SDK / Android Studio with Live

Hi, The new LiveCode release, 8.1.5 RC-1, has support for the latest version of Android Studio. Thx, nice to know! But: Is there a way to apply this bugfix to any version of LC suitable for production ? Having the fix in an RC is fine, but it leaves everybody in the rain that's doing serious work. T...
by AxWald
Thu Jun 08, 2017 5:35 pm
Forum: Talking LiveCode
Topic: How to call a stored procedure in an external MySQL DB?
Replies: 1
Views: 927

Re: How to call a stored procedure in an external MySQL DB?

Hi,

Code: Select all

   put "CALL `myStoredProcedure`;" into StrSQL
   get revdb_execute(myDBID,StrSQL)
Have fun!
by AxWald
Sat Jun 03, 2017 10:24 am
Forum: Android Deployment
Topic: Radio Buttons look awful...
Replies: 12
Views: 2328

Re: Radio Buttons look awful...

Hi,

for Android style icons look here.

Have fun!
by AxWald
Thu Jun 01, 2017 5:49 pm
Forum: Databases
Topic: revdberr,Lost connection to MySQL server during query
Replies: 11
Views: 3965

Re: revdberr,Lost connection to MySQL server during query

Hi, I have a rather long winded query on a MySQL database that runs each night and stores its data in a temp table, for faster access. The way I do it could be what you need. The actions starts from Livecode. I send these Statements to the db: DROP TABLE IF EXISTS `myTable`; (if this fails, the tabl...

Go to advanced search