PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 2024 → Insert a clickable link in an email
Insert a clickable link in an email
Débuté par Mimmo Ghiara, 02 jan. 2020 15:11 - 4 réponses
Posté le 02 janvier 2020 - 15:11
Hello everyone and happy new year,
I have to insert a link in an email so that the user receiving this email can click on the link that sends him back to the site.
I wrote this code

-------
MyMessage is Email
MyMessage..Sender = sMail_imvio

sRecipient_1 is string = users.email

Add (MyMessage..Recipient, sRecipient_1)

MyMessage..Subject = "Fast Ball - User registration confirmation"
sLinkatt is string = "<a href="+sLinkveri+"</a>"

sNote = "Dear" + users.userid + [CR]

sNote = sNote + "thank you for registering on the Fast Ball website" + [CR]
sNote sNote + = [CR]
sNote = sNote + "Copy the line you find below and copy it in a browser to activate your account"
sNote sNote + = [CR]
sNote sNote + = [CR]
sNote sNote = + sLinkatt
sNote sNote + = [CR]
sNote sNote + = [CR]
sNote sNote + = [CR]
sNote = sNote + "Greetings from Ludikproject"

MyMessage..HTML = TextToHTML (sNote)


IF NOT EmailSendMessage (MySession, MyMessage) THEN
IF ErrorOccurred = True THEN
// Full message of the main error
Trace (ErrorInfo ())
// Browse the sub-errors (if any)
FOR i = 1 _TO_ ErrorInfo (errNumberSubError)
// Full message of each sub-error
Trace ("Sub-error" + i + ":" + ErrorInfo (errMessage, i))
END
END
ELSE
// Info ("Mail sent successfully." + "Check your mailbox you should have received a" + "message with your password!")
END

// Error ("The mail could not be sent.", ErrorInfo (), ...
// "Check the parameters!")

EmailCloseSession (MySession)


-----
The email is sent correctly but where the link should be, the line with <a ref = etc remains and has not become a clickable link

Thanks for the tips

Mimmo
Posté le 02 janvier 2020 - 17:41
you are doing a texttohtml of your message, but you already have html code in it (your link)
a texttohtml of html content will NOT give you html...

So replace your link by something like MYTAG, do the texttohtml, then replace MYTAG by your link in the result
Posté le 03 janvier 2020 - 15:31
I thank you for the suggestion that I applied and now the email arrives as I wanted

I submit you a problem with the connection to a MariaDB database which is similar to a MySql database

I downloaded the libmariadb.dll files and as indicated by the instructions I inserted this dll in the Programs / Framework / Win32x86 folder and one in Programs / Framework / Win64x86 but when I go to connect with the database I get an error 730001 as if it could not find the connector. I have tried other positions too but nothing always the same mistake. The strange thing is that if I use HFSQL Control Center I can connect with the same credentials that I insert in the code
Can you give me a solution
Thank you
Mimmo
Posté le 03 janvier 2020 - 16:37
I could, but there is no need...

Fabrice Harari already answered that question here:

http://fabriceharari.com/UK/Page_Article.awp…
Posté le 13 janvier 2020 - 15:32
Thanks for the information, I understand where I was wrong

Mimmo