Ron Gillies
|
| Posted: 09/20/2002, 12:52 PM |
|
I have been working on a simple application (learning CCS slowly) using an Access database and PHP code instead of hardcoding all my data in HTML.
The application is a list of local businesses and agencies with contact information.
All the data properly displays in the application built with CCS 1.07.
Can anyone suggest how I can enhance two data fields (email address and web site location) so that users can link to the website (similar to the HTML href http= command) and invoke their email client (the html mailto: command).
I was able to do this in Code Charge itself, but Studio has me stumped!
Thanks very much
Ron Gillies
|
|
|
 |
Gary D
|
| Posted: 09/20/2002, 1:53 PM |
|
Here is how I did it.
dim myemail
myemail = agents.email.Value
agents.email.Value = "<a href=mailto:" & myemail & ">" & myemail & "</a>"
agents.email.Value is the value from the data base
hope this helps
|
|
|
|
per
|
| Posted: 09/20/2002, 2:45 PM |
|
Ron,
search on this topic: Escaping quotes in PHP events, which will give you answers in php to your questions.
|
|
|
|
eDuck
|
| Posted: 09/21/2002, 12:16 AM |
|
I don't know PHP, and I don't know how CCS interacts with PHP, but on ASP I see newbies trip over this a lot. If you have a field that comes from a database which holds some sort of HTML formatting, then on the Data tab of the Properties window, make sure you set Content to HTML, as the default is Text. Having this set to Text will display HTML in text format, and you would therefore loose your HTML formatting like a link to click on the website or mailto field coming from your database.
|
|
|
|
|
