LiveCode Forums.

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

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

Hello Klaus ,

Thanks for your reply!

Actually i want to update the database instead of inserting, any idea how?

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

Hello matthiasr!

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

Because i was only trying out livecode to play around hahaha but ofcourse i will look up the HostM tutorial soon thanks

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

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

Solution found!

Hello , karmacomposer!

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" ?

Hello Klaus :D

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

Example;

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.

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

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

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

Hello FourthWorld

I only want the code for those validation as for my reference guide so i can use it the next time!

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!