----- Original Message ----- From: "Palacios, Gethsemani" <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED]" Date: Wed, 31 Jul 2002 11:56:56 -0500 Subject: [dbforms] DBQuery
> 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. Why don't you try something like: select SHORT_NAME from COMMUNICATIONS_PARTNER or select COMMUNICATIONS_PARTNER.SHORT_NAME from COMMUNICATIONS_PARTNERS Stratos Nikolaidis Thessaloniki, Greece ------------------------------------------------------------- http://www.mail.gr/ - Get Your Private Free Email Address! http://www.ringtone.gr/ - Ringtones & Logos for your mobile! ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
