CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Grid Question About Bound Columns

Print topic Send  topic

Author Message
Peter K
Posted: 11/08/2003, 11:48 AM

I have a grid that contains several columns of data that I would like to show the text column from a bound column. Except I don't want to change the column type to listbox.

Is there an easy way to decode the value of the column as a text field?

I hope this makes sense. If not, I will provide more details on request.

I am using PHP with MySQL.
Hamilton
Posted: 11/08/2003, 7:34 PM

The easiest way to perform this is to change the link to a label control.
In the Before_Show event do the following;

Dim lngRecordID
Dim sWebsite
Dim sEmail
Dim sResult


lngRecordID = Users.DataSource.Recordset.Fields("user_id")
sWebsite = Users.DataSource.Recordset.Fields("Website")
sEmail = Users.DataSource.Recordset.Fields("Email")

If Len(sWebsite) > 0 then sResult = sWebsite
If Len(sEmail) > 0 Then sResult = sEmail

'Or modify this to accomdate if the user provided both
If Len(sWebsite) > 0 AND Len(sEmail) > 0 Then
sResult = sWebsite & "<BR>" & sEmail
End If

Users.lblEContact.value = sResult
_________________
Hamilton
www.dataobjx.net
Peter K
Posted: 11/09/2003, 2:19 AM

How about PHP code? That is what I am using.
DaveRexel
Posted: 11/09/2003, 2:30 AM

::
Try using the following generic CCS function (PHP example here) in the BeforeShowRow Event for your grid

CCDLookUp(field, table, where_clause, connection)

Hope this helps
Greetings
Dave

RexDesign CodeCharge Studio Tutorials
http://www.rexdesign.com/ccs/default.php

   


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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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