Hi Gethsemani,
documentation for queryData tag says:
query building convention: first column is the "key" column for the
radio/check/select
elements,
all other colums are just "data" columns visible to the user
example:
SELECT DISTINCT customer.id, customer.name, customer.adress, debitors.debit
FROM customer INNER JOIN id
ON (SELECT id FROM debitors WHERE debit>100000)
ORDER BY debit DESC
- "id" will be threaten as key-value in select box, "name and address will be
shown in
select box
You just have the key column, you better take something like:
query="Select SHORT_NAME,SHORT_NAME from COMMUNICATIONS_PARTNER"
to see the short name column in your page.
Regards
Dirk
"Palacios, Gethsemani" wrote:
>
> Thank you to Bradley M. Handy and Dirk Kraemer for helping with the invalid
> table error I was having earlier.
>
> Now I am trying to use dbquery to populate a select.
>
> <db:select fieldName="SHORT_NAME">
> <db:queryData name="aQuery" query="Select
> communications_partner.SHORT_NAME from COMMUNICATIONS_PARTNER" />
> </db:select>
>
> I don't get anything. The select is empty.
>
> When I use the following:
>
> <db:select fieldName="SHORT_NAME">
> <db:queryData name="aQuery" query="Select * from
> COMMUNICATIONS_PARTNER" />
> </db:select>
>
> The select is filled with everything in the table.
>
> Regards,
> Gethsemani Palacios
> Computer Specialist
> Austin Automation Center
> 512-326-6708
> 512-762-7295
>
> -------------------------------------------------------
> This sf.net email is sponsored by: Dice - The leading online job board
> for high-tech professionals. Search and apply for tech jobs today!
> http://seeker.dice.com/seeker.epl?rel_code=31
> _______________________________________________
> DbForms Mailing List
>
> http://www.wap-force.net/dbforms
-------------------------------------------------------
This sf.net email is sponsored by: Dice - The leading online job board
for high-tech professionals. Search and apply for tech jobs today!
http://seeker.dice.com/seeker.epl?rel_code=31
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
