CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Grid Selection Won't File Record Form

Print topic Send  topic

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

I have a PHP webpage that contains a grid and record form. The grid contains data joined by 2 tables and record form only inserts to the one of the tables. When I select a row from the grid, the record form fields do not populate. The primary key is being passed as a parm in the URL, I can see it. The record form was created with Insert and Update configurations. There are restrictions based on a group but I know the login id is part of the update group.

Why is the record form acting this way? Is it because the grid has a join between two tables?

Any help would be greatly appreciated.
Peter K
Posted: 11/09/2003, 1:47 PM

After extensive research looking at the code that was generated when I selected the Grid and Record wizard, it appears that the CCS generated the wrong parameter name for the HREF Source Property link parameters.

The two tables that I joined had similiar column names between the two. CCS prefixed all the column names with the tablename_ (example: table1 has column name INCIDENT_NO, table2 has colum name INCIDENT_NO, the generated name became table1_INCIDENT_NO). After browsing the CCS PHP code, I noticed a reference to urlINCIDENT_NO. The link name in the url was actually table1_INCIDENT_NO. Since the two didn't match it never passed the incident number to the query thus the record fields were never loaded.

Once I corrected the source parameter name and dropped the table1_ prefix, everything worked great.


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login

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