CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Help writing an if statement?

Print topic Send  topic

Author Message
Frank S.
Posted: 07/01/2002, 6:49 AM

Was wondering if someone could help me on writing an if statement?
I read Alex's "show/hide" article but I don't know how to word the
conditional part of the code. Here's the problem:

Grid and Edit (One Page)
I have a table (Table1) that I would like to hide if it doesn't contain a
record/recordset. It's name is Table1. If the grid on the left (named Table)
has a record selected, I would like to display the details in Table1 (Edit).
Can anyone tell me how to go about writing this statemen?
PHP - MySQL - Linux
thanks,
Frank


Alexey Alexapolsky
Posted: 07/02/2002, 2:53 AM

You should run a count sql , take form's sql from sSQL variable ,
replace field list between SELECT and FROM with COUNT(*)
execute it and see if it returns 0. Then based on this show or hide a form.

--
Alex
CodeCharge Developer


"Frank S." <no_spam_info@auuooh.com> wrote in message
news:afpmlf$6su$1@news.codecharge.com...
> Was wondering if someone could help me on writing an if statement?
> I read Alex's "show/hide" article but I don't know how to word the
> conditional part of the code. Here's the problem:
>
> Grid and Edit (One Page)
> I have a table (Table1) that I would like to hide if it doesn't contain a
> record/recordset. It's name is Table1. If the grid on the left (named
Table)
> has a record selected, I would like to display the details in Table1
(Edit).
> Can anyone tell me how to go about writing this statemen?
> PHP - MySQL - Linux
> thanks,
> Frank
>
>
>


   


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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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