CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 mailto:

Print topic Send  topic

Author Message
Ann Harrell
Posted: 06/22/2001, 7:05 PM

This will be simple for you all. I used the Master/Detail four page wizard.
And I got what I expected at
http://ann.bourbon.hoosierlink.net/wobinfo/WobInfoGrid.cfm.

I would like to add Mailto: to the Email column and I would like to format
the dates in the birthday column.

Hints? I've looked at various examples for serveral hours now.

Ann Harrell

Dr. Scott R. Senay
Posted: 06/22/2001, 9:21 PM

Hello Ann,

There are a couple of ways to deal with the email issue;

1.) Simply change the property of the field html and add the appropriate
code i.e. <a
href="mailto:yourmail@yourdomain.com">yourmail@yourdomain.com</a>

2.) Use a before show event to append the above code to EACH field which
will create the magic for you (you STILL need to have html turned on):

/* In PHP you would use the following code (or something like it) */
----------------------------------------------------------------------------
-------------------------------------
$fldemail = "<a href='mailto:" . $fldemail . "'>" . $fldemail . "</a>";
----------------------------------------------------------------------------
-------------------------------------

This will take each email address, format it, and place it in the right spot
with the appropriate linking turned on...

As to formatting the date field, take the field parse it into the pieces you
want, and do a before show for that as well. Something like this:

/* In PHP & MySQL you would use the following code (or something like it) */
----------------------------------------------------------------------------
-------------------------------------
$dateonly = explode(" ", $flddate)
$newsplit = explode("-", $dateonly);
$gooddate = date("("F j,
Y",mktime(0,0,0,$newsplit[0],$newsplit[1],$newsplit[2]));
----------------------------------------------------------------------------
-------------------------------------

Hope this helps...

Scott...


Ann Harrell <ann@hoosierlink.net> wrote in message
news:9h0tgr$od4$1@news.codecharge.com...
> This will be simple for you all. I used the Master/Detail four page
wizard.
> And I got what I expected at
> http://ann.bourbon.hoosierlink.net/wobinfo/WobInfoGrid.cfm.
>
> I would like to add Mailto: to the Email column and I would like to format
> the dates in the birthday column.
>
> Hints? I've looked at various examples for serveral hours now.
>
> Ann Harrell
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.