feha
|
| Posted: 03/06/2002, 12:56 PM |
|
I would like to see some solution for dropdown (listbox-es) options...
How to implement this?
The first OPTION SELECTED value should be reading form a TABLE A where the values are saved before...(configuration for example...)
The rest of the OPTION values should contain values from another TABLE B in DB...
When SELECTED TABLE B value save to TABLE A...
And so on...
<option selected>value of TABLE A </option>
<option> values of TABLE B 1</option>
<option> values of TABLE B 2</option>
.
.
.
<option> values of TABLE B X</option>
(should be values reading from a column of TABLE B)
etc...
please send an e-mail to
feha@vision.to
if you find easy solution on CC without
custom coding...
|
|
|
 |
EMG
|
| Posted: 03/06/2002, 1:56 PM |
|
In the field properties for the ListBox, go to the List tab and enter your own lookup SQL utilizing the SQL "UNION" statement:
Select PrimaryKey_A, Showing_A From Table_A
UNION
Select PrimaryKey_B, Showing_B From Table_B
|
|
|
|
feha
|
| Posted: 03/06/2002, 10:08 PM |
|
Thank You EMG I will try it...
|
|
|
|
feha
|
| Posted: 03/06/2002, 10:34 PM |
|
I can do the part TABLE B but not TABLE A ?
|
|
|
|
feha
|
| Posted: 03/07/2002, 2:22 AM |
|
This is what I have programmed in CGI...
T
he link: http://vision.to/config/index.cgi
Custom coding from the scratch...
I would like it to port it as a CC project and My SQL db...
It has several textfile db-bases...
So I need som more examples in CC code project...
To port this project in to CC...
Send an e-mail to:
feha@vision.to
|
|
|
|
feha
|
| Posted: 03/07/2002, 2:22 AM |
|
This is what I have programmed in CGI...
Custom coding from the scratch...
I would like it to port it as a CC project and My SQL db...
It has several textfile db-bases...
So I need som more examples in CC code project...
To port this project in to CC...
Send an e-mail to:
feha@vision.to
|
|
|
|
feha
|
| Posted: 03/07/2002, 1:20 PM |
|
I tried:
Database error: Invalid SQL: Select Primarykey Name, showing Name from supplier UNION Select Primarykey Name, showing Name from artice
MySQL Error: 1064 (You have an error in your SQL syntax near 'UNION Select Primarykey Name, showing Name from artice' at line 1)
Session halted.
it does not work...
|
|
|
|
Nicole
|
| Posted: 03/11/2002, 2:21 AM |
|
Hello,
mySQL doesn't support union sql statements.
|
|
|
|
feha
|
| Posted: 03/11/2002, 12:28 PM |
|
Thank You Nicole...
Is there any other solution to this problem?
I want to read from another table the column values and when selected to save them in another table,whenever I edit it should contain as selected the last saved value...
|
|
|
|
Damien
|
| Posted: 03/19/2002, 2:39 PM |
|
Hi there,
MySQL v4.0.x supports the SQL UNION statement. Subsequent versions should soon support sub-selects and other set operators such as INTERSECT and DIFFERENCE.
Go to www.mysql.com for details.
|
|
|
|
feha
|
| Posted: 03/19/2002, 10:35 PM |
|
Damien thank you for info...
MySQL is still alpha but is seems to be stable so soon I will try it soon.
I need to use even DISTINCT etc... wich is a problem on CC generated SQL statmments...
|
|
|
|
