Search found 295 matches

by AxWald
Thu Jan 18, 2018 4:25 pm
Forum: Databases
Topic: Select Col.name from table - SOLVED
Replies: 12
Views: 230

Re: Select Col.name from table

Hi,

might be that this happens 'cause "CAST" is a function name in SQL. You might try:

Code: Select all

put "SELECT `Title`,`Year`,`Format`,`Cast`,`Summary` FROM `Movies`" into tmpSql
Have fun!
by AxWald
Tue Jan 16, 2018 4:51 pm
Forum: Talking LiveCode
Topic: ASK Command Return Button means "OK"
Replies: 13
Views: 254

Re: ASK Command Return Button means "OK"

Hi, I can see the problem - the signal from the scanner is coming as keyboard input, and has to be caught somewhere. But as soon as you focus on any field (on mobile), this nasty keyboard pops up, covering half the screen. This way, opening an ask dialogue is a good way to fetch it. Only now the use...
by AxWald
Sun Dec 24, 2017 3:28 pm
Forum: Windows
Topic: I can not delete files on windows
Replies: 11
Views: 369

Re: I can not delete files on windows

Hi, maybe I misunderstand, but this works flawlessly here: on mouseUp -- you need an image area named "test_img" besides this btn! put specialFolderPath("Desktop") & "/Saved Pictures/" into myPath put specialFolderPath("Desktop") & "/Test_Picts/" into myTestPath put "P8010001.JPG" into pict1 put "P8...
by AxWald
Mon Dec 18, 2017 12:49 pm
Forum: Windows
Topic: I can not delete files on windows
Replies: 11
Views: 369

Re: I can not delete files on windows

Hi, I assume you have a minor mistake somewhere in your code; carefully testing "the result" and using the debugger should uncover it quite easily. To be sure it isn't a LC bug I wrote this short button handler - it creates a file in ./temp, copies it to ./docs, then deletes both of those again. Wor...
by AxWald
Tue Dec 05, 2017 12:15 pm
Forum: Windows
Topic: "Answer file" crashes in windows xp
Replies: 8
Views: 367

Re: "Answer file" crashes in windows xp

Hi, (Edit: Filed as Bug 20737 ) can reproduce this problem. Made a small stack (attached), with only a few lines of code in a single button: on mouseUp answer file "Please point me to a file:" titled "File Select" if it is empty then exit mouseUp put it into myFile put len(it) into myLen open file m...
by AxWald
Tue Dec 05, 2017 12:10 pm
Forum: Windows
Topic: LC Answer File across Win versions
Replies: 7
Views: 335

Re: LC Answer File across Win versions

Edit: Ooops, wrong place.

This belongs to the XP version of this bug...

Have fun!
by AxWald
Fri Nov 24, 2017 2:28 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Send mail in Windows without Outlook - Solved (use: Sarah Reichelts smtp library)
Replies: 12
Views: 558

Re: Send mail in Windows without Outlook

Hi, this may not be what you're looking for, but I really can recommend MailAlert for standalone mail sending in Win. It encrypts the mail password, and supports StartTLS & SSL/TLS, as well as attachments. And is small, simple & reliable. But it comes as an extra application (3 MB), and is called vi...
by AxWald
Wed Nov 22, 2017 12:19 pm
Forum: Teaching with LiveCode
Topic: Why do so few schools try LiveCode...?
Replies: 85
Views: 2468

Re: Why do so few schools try LiveCode...?

Hi, From personal experience, the single biggest obstacle for my nephews (4 and 6) has been English and while they both can read and write in their native language, adding the complexities of programming on top of a new language has been a bit too much of a hurdle to over come. I think this is a mis...
by AxWald
Mon Nov 06, 2017 1:28 pm
Forum: Databases
Topic: Sanitization
Replies: 10
Views: 471

Re: Sanitization

Hi, I may have been too vague in my question. What I wanted to know was: What does LC make with this statement: revExecuteSQL myDBID, "UPDATE t_test Set a_Num = :1 WHERE id = :2", "myDataArray" From the way SQL databases work we know that LC has to send some strings to the db to get any results. Wha...
by AxWald
Wed Nov 01, 2017 5:12 pm
Forum: Databases
Topic: Sanitization
Replies: 10
Views: 471

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: 471

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: 700

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: 2516

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: 510

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: 510

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 ...

Go to advanced search