Search found 65 matches

by ace16vitamine
Tue May 26, 2020 10:45 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Line Graph: Double X Entrys
Replies: 7
Views: 602

Re: Line Graph: Double X Entrys

Any news if this will be fixed in 9.6.0 (RC3)?

Stef
by ace16vitamine
Fri May 15, 2020 5:49 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: StackOnly: How to start as standalone without card
Replies: 5
Views: 401

Re: StackOnly: How to start as standalone without card

Its a script. But how can I start the script? in the openstack handler I have timer to run some actions every x minutes.

Or can I hide a complete card that it is not shown in the taskbar?
by ace16vitamine
Fri May 15, 2020 4:42 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: StackOnly: How to start as standalone without card
Replies: 5
Views: 401

StackOnly: How to start as standalone without card

Dear all, I have developed a StackOnly script to run some DB selects etc. in the background from the OS as "Service". But... If I create a standalone application only from this stack it is not working, seems that the "on openstack" Handler is not starting. But why? I can see the process in the Windo...
by ace16vitamine
Wed May 13, 2020 8:38 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Close opensockets after 30 sec
Replies: 2
Views: 263

Re: Close opensockets after 30 sec

Hi,

this does only work from the one who is open the socket.

But I need to do this from the "Server":
accept secure connections on port 9999 with message "verbindung_client_read"

Thanks
Stef
by ace16vitamine
Tue May 12, 2020 10:08 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Close opensockets after 30 sec
Replies: 2
Views: 263

Close opensockets after 30 sec

Dear all,

is there any way to close open sockets after 30 sec? socket timeout does not work because I want to kill the opensocket
whatever datas will be transfered.

Regards
Stef
by ace16vitamine
Sun May 03, 2020 11:41 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Line Graph: Double X Entrys
Replies: 7
Views: 602

Line Graph: Double X Entrys

Dear all, I have a strange problem and I do not know why or what is going on wrong. 2 Line Graphs: lg_wrong2.jpg 1st with the data 0,0 1,2 2,6 3,5 4,5 5,4 6,6 2nd with the data 0,2 1,6 2,5 3,5 4,4 5,6 6,7 7,3 (..) In the 2nd Graph I have double Items on the X Axis description and I dont know why. If...
by ace16vitamine
Sun May 03, 2020 9:44 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Repeat around SQL Selects...
Replies: 4
Views: 348

Re: Repeat around SQL Selects...

Solved:

Code: Select all

SELECT date(Auftragsdatum), UserID, COUNT(Bestellnummer) AS jobCount, DATEDIFF(DATE(NOW()),Auftragsdatum)AS daySince 
FROM `t_daten` WHERE (DATEDIFF(DATE(NOW()),Auftragsdatum) < 101) AND (UserID = '1234') 
GROUP BY date(Auftragsdatum) ORDER BY Auftragsdatum, UserID
Thanks
Stef
by ace16vitamine
Sun May 03, 2020 9:14 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Repeat around SQL Selects...
Replies: 4
Views: 348

Re: Repeat around SQL Selects...

OK... Sounds easy. But it is not :-p Because: The date is not only JJJJ/MM/TT, it is a date string. SELECT Auftragsdatum, UserID, COUNT(Bestellnummer) AS jobCount, DATEDIFF(DATE(NOW()),Auftragsdatum)AS daySince FROM `t_daten` WHERE (DATEDIFF(DATE(NOW()),Auftragsdatum) < 10) AND (UserID = '1234') GRO...
by ace16vitamine
Sun May 03, 2020 12:01 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Repeat around SQL Selects...
Replies: 4
Views: 348

Repeat around SQL Selects...

Dear all, I wrote a simple function to create statistics from my SQL Database. It is collecting the count of orders every day. I copy the code e.g. 20 times but I think it can be easier with a repeat loop :-p I mean for 3 days I can copy paste, no problem. But now I have to collect 50 days, 100 days...
by ace16vitamine
Wed Feb 26, 2020 11:39 pm
Forum: Windows
Topic: App beside the clock...
Replies: 2
Views: 535

App beside the clock...

Hi all, I have a simple question: What can I do that my App is running beside the clock icon right in my task bar? See screenshot. My Idea is that the application starts with Autorun (or as a service or whatever) and that it is possible to manage it beside the clock icon. That means I can make a kli...
by ace16vitamine
Fri Feb 07, 2020 9:00 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Kill socket after x seconds
Replies: 3
Views: 807

Re: Kill socket after x seconds

Hey Klaus,
well, that should be -> the sockettimeoutinterval
cool, thanks!

@FourthWorld
If Linux I'd set up UFW to handle those DDOS concerns
Yes, I have iptables in front of the DMZ, but it can not hurt to develop the application with this feature too.
by ace16vitamine
Fri Feb 07, 2020 7:22 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Kill socket after x seconds
Replies: 3
Views: 807

Kill socket after x seconds

Dear all, we are communicating with clients over socket via accept connections on port 9999 with message blablabla and read from socket xzy until Now, if a client fails, or an attacker makes 10000000 sessions :cry: or whatever the socket is multiple times open... Is there a possibility to kill the i...
by ace16vitamine
Thu Feb 06, 2020 11:18 pm
Forum: Databases
Topic: Different between numbers and Chars
Replies: 3
Views: 1145

Re: Different between numbers and Chars

@SparkOut, sure, this is stored cleartext only for testing. @AxWald, seems that there was another problem. My DB select was right, it was a problem with the variable username_passwort... I dont know why (because I received this from another function and I have checked this multiple times) put if i p...
by ace16vitamine
Wed Feb 05, 2020 10:51 pm
Forum: Databases
Topic: Different between numbers and Chars
Replies: 3
Views: 1145

Different between numbers and Chars

Dear all, it is really strange... I have a Maria DB (UTF-8). In the Database i have stored a simple table (T_USER) with test datas in a text Field: This is working with my simple script: UserID: 1234 Passwort: 1234 And this is not working: UserID: 1234 Passwort: 1234 a ### Create SELECT to get the p...
by ace16vitamine
Sat Feb 09, 2019 1:35 am
Forum: Databases
Topic: LC and MariaDB
Replies: 2
Views: 1494

Re: LC and MariaDB

Thanks Klaus!

textencode() is working in the case that I encode every SQL insert.

Go to advanced search