| Re: list2 not respecting list1 key [message #729 is a reply to message #728] |
Fri, 30 March 2007 13:12   |
rgervais
Messages: 7
Registered: March 2007
|
Junior Member |
|
|
Hmm those sample tables work right. I did not add any code to the function. It looks pretty much like the samples.
$outer_table = 'period'; // name of outer (parent) table
$inner_table = 'log'; // name of inner (child) table
$screen = 'log.list2.screen.inc'; // file identifying screen structure
require 'std.list2.inc'; // activate page controller
I decided I would try again in a new subsystem, all fresh and new. When I hit the popup on the jrn table in a create relationship, I get:
Fatal Error: pg_query() [function.pg-query]: Query failed: ERROR: 42703: column "column_count" does not exist LOCATION: transformColumnRef, parse_expr.c:396 (# 256).
SQL query: SELECT count(*) FROM dict_table LEFT JOIN dict_column ON (dict_table.database_id=dict_column.database_id AND dict_table.table_id=dict_column.table_id) WHERE dict_table.database_id='it' GROUP BY dict_table.database_id, dict_table.table_id, dict_table.table_desc HAVING column_count > 0
Error in line 295 of file '/srv/www/htdocs/radicore/includes/dml.pgsql.class.inc'.
Host Info: localhost, Server Version: 8.1.4
Client Encoding: UTF8, Server Encoding: LATIN1
Database: RADICORE, Schema: "DICT", PUBLIC
Script: /radicore/dict/table_popup.php
Request URI: /radicore/dict/table_popup.php?session_name=menu3
I'm not sure how I added them in the past, but clear other stuff is wrong.
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
