Search found 66 matches

by jwtea
Tue Dec 31, 2019 12:09 pm
Forum: Databases
Topic: Can't connect to my mySQL server
Replies: 1
Views: 3501

Can't connect to my mySQL server

Hello, i just purchased a shared hosting plan from NameCheap and i'm unable to connect to mySQl server on my livecode. When i tried to connect the database, the error msg say "Can't connect to mySQL server" Can i know what is the issue? Is there any setting i had to do on cpanel or the credentials i...
by jwtea
Tue Dec 04, 2018 7:39 pm
Forum: Talking LiveCode
Topic: Upload image into SQL [Longblob]
Replies: 6
Views: 4697

Re: Upload image into SQL [Longblob]

Mikey wrote:
Sun Dec 02, 2018 4:31 pm
@jwtea
Just curious, whatcha cookin' with this project?
Hahahah i'm actually just trying out the function not cooking anything yet :D
by jwtea
Sat Dec 01, 2018 7:57 pm
Forum: Talking LiveCode
Topic: Upload image into SQL [Longblob]
Replies: 6
Views: 4697

Re: Upload image into SQL [Longblob]

Hello Klaus ,

Thanks for your reply!

Actually i want to update the database instead of inserting, any idea how?
by jwtea
Sat Dec 01, 2018 6:03 pm
Forum: Talking LiveCode
Topic: Upload image into SQL [Longblob]
Replies: 6
Views: 4697

Upload image into SQL [Longblob]

Hello , i got trouble uploading image to my sqldatabase ; my column for the image in the database will longblob. Anybody got any idea on this issue? I uses this code below to select a image on mouseup put "*.jpg;*.gif;*.png" into types if there is not an image "photo" then create image "photo" end i...
by jwtea
Tue Sep 25, 2018 4:02 pm
Forum: Talking LiveCode
Topic: CPanel
Replies: 9
Views: 6257

Re: CPanel

Hello matthiasr!

Finally managed to connect to my database because of your help! :D

Because i was only trying out livecode to play around hahaha but ofcourse i will look up the HostM tutorial soon thanks 8)
by jwtea
Tue Sep 25, 2018 3:34 pm
Forum: Talking LiveCode
Topic: CPanel
Replies: 9
Views: 6257

Re: CPanel

Hi, if i remember right, you have to allow remote access to your MySQL database to be able to access your database from a desktop app. For security reasons the access to the database is only allowed from the localhost. So if you want to allow the access from remote then add your ip or %.%.%.% (as a...
by jwtea
Mon Sep 24, 2018 5:23 pm
Forum: Talking LiveCode
Topic: CPanel
Replies: 9
Views: 6257

CPanel

Hello, i am trying to connect my database from Cpanel ~ ~~ I tried the code below but still failed to connect ~ put "mp04.projectsbit.org" into tDatabaseAddress' put "runrev_test" into tDatabaseName put "fakeuser" into tDatabaseUser put "fakepassword" into tDatabasePassword put revOpenDatabase("MySQ...
by jwtea
Fri Jul 20, 2018 9:30 am
Forum: Talking LiveCode
Topic: Android Native Field Return Key
Replies: 5
Views: 3750

Re: Android Native Field Return Key

Solution found!

Code: Select all

On inputReturnKey

if mobileControlTarget() is "fieldA" then
      answer "hello
   end if

if mobileControlTarget() is "fieldB" then
      answer "goodbye
   end if

end inputReturnKey
by jwtea
Fri Jul 20, 2018 2:35 am
Forum: Talking LiveCode
Topic: [SOLVED] How do I put the results of a checkbox into a variable
Replies: 3
Views: 2722

Re: How do I put the results of a checkbox into a variable

Hello , karmacomposer! :D

What do you mean by the results of a checkbox into a variable??

You mean by when the checkbox is tick you receive "1" and checkbox is untick you receive "0" ?
by jwtea
Fri Jul 20, 2018 2:20 am
Forum: Talking LiveCode
Topic: Android Native Field Return Key
Replies: 5
Views: 3750

Re: Android Native Field Return Key

Hello Klaus :D

I mean it worked for the type of returnKey but i want different returnKey function for fieldA and fieldB.

Example;

Code: Select all

on InputReturnKey
answer hello
end InputReturnKey
Both of the field returnKey answer hello but i want fieldA to answer "hello" and fieldB to answer goodbye.
by jwtea
Thu Jul 19, 2018 4:14 am
Forum: Talking LiveCode
Topic: Android Native Field Return Key
Replies: 5
Views: 3750

Android Native Field Return Key

Hello guys, i got 2 different android native field in 1 card and i want field A to have this return key function and field B to have another return key function. Any idea how? PS: The code to create my field on preopencard mobileControlCreate "input", "fieldA" mobileControlSet "fieldA", "rect", the ...
by jwtea
Tue Jul 17, 2018 4:35 am
Forum: Talking LiveCode
Topic: Field Validation
Replies: 6
Views: 4675

Re: Field Validation

put "MyPassw0rd@tH0me" into tPassword put the length of tPassword into tlengthPassword Put "QWERTYUIOPASDFGHJKLZXCVBNM" into tUCLetters Put "1234567890" into tNumbers Put "!@#$%^&*(){}[]:;<>" into tSymbols repeat with tCharNumber = 1 to tlengthPassword put char tCharNumber of tPassword into tCharac...
by jwtea
Tue Jul 17, 2018 4:31 am
Forum: Talking LiveCode
Topic: Field Validation
Replies: 6
Views: 4675

Re: Field Validation

on t_analyse pPW put "! @ # $ % ^ & *)" into tSymbol put empty into tSymbolInString put empty into tUpperL put the num of chars of pPW into tNbC repeat for each char tChar in pPW get offset(tChar,tSymbol) if it <> 0 then put it into tSymbolInString end if put chartoNum(tChar) into tCN if tCN > 64 a...
by jwtea
Mon Jul 16, 2018 8:44 am
Forum: Talking LiveCode
Topic: Field Validation
Replies: 6
Views: 4675

Re: Field Validation

Hello FourthWorld :D

I only want the code for those validation as for my reference guide so i can use it the next time!
by jwtea
Mon Jul 16, 2018 3:57 am
Forum: Talking LiveCode
Topic: Field Validation
Replies: 6
Views: 4675

Field Validation

Hello guys , i'm trying to do a field validation.....

The validation consist of
1) Minimum 1 Symbol (eg of symbol "! @ # $ % ^ & *)
2) At least 1 upper case letter
3) Minimum 8 Characters

Thanks!

Go to advanced search