Simon
|
| Posted: 03/20/2003, 1:29 PM |
|
I use CCS2 beta 4.........
I have 2 tables.
Pages
page_id int
page_title varchar
page memo
Templates
template_id int
template_title varchar
template_page memo
I CCS i have a record called "pages1", with data source =pages, templates (no joins or anything)
Title : TextBox -> page_title
Type : ListBox -> Control source = page
data source = templates
text column = template_title
bound column = template_page
Insert Button
I want to be able to select the template page for the new page via the listbox,
(insert the content of the appropriate template_page into the page field in pages)
I have tried many approaches, but without any luck... Can anyone help ???
|
|
|
 |
Sinisa
|
| Posted: 03/26/2003, 6:07 AM |
|
I have installed new version of CCS in hope it would work but it still fails. Note I'm using Perl.
I have a simple test database with tables:
CUSTOMER (CUSTOMER_ID, EMAIL, PASSWORD)
SHOPS (SHOPID, SHOPNAME)
TRANSACTIONS (TID,CUSTOMER_ID,SHOP_ID,PUR_DATE,AMOUNT,STATUS)
I create a grid with search where search can be done by transaction id, customer id or shop id. Initially all searches are defined textboxes and this works.
Then if you change field for shop_id from text box to list box and setup it to lookup SHOPS table by the book it doesn't work...
the error returned:
DBD::Oracle::db selectrow_array failed: Database disconnected at c:/payg/AdvAdmin/./Common.pm line 503.
DBD::Oracle::db prepare failed: Database disconnected at c:/payg/AdvAdmin/./Common.pm line 1784.
Can't call method "fetchrow_hashref" on an undefined value at c:/payg/AdvAdmin/./Common.pm line 1798.
Tried also the examples, and the same problem occurs there...
Any clue?
|
|
|
|
|
