CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 About The Listbox (Lookup SQL option)

Print topic Send  topic

Author Message
Dante S.
Posted: 05/22/2001, 3:18 AM

How does one use the Lookup SQL option found in the List tab, in the
properties window of a Listbox field type? I played with it around but
haven't gotten anywhere. What're the situations that this will be used?

Thank you CodeCharge Support Team for all the help extended to me for my
last two postings.

- Dante S.

Alexey Alexapolsky
Posted: 05/23/2001, 8:27 AM

Your sql must be in form of

select id,name from some_table where some_condition

The trick is that first field must be id (value for listbox) ,
and second field must be some text value (what will be shown in listbox)

--
Regards,
Alexey
CodeCharge Support



Dante S. <disandigan@loyolaplans.com> wrote in message
news:9ededc$ltu$1@mail.tankhill.com...
> How does one use the Lookup SQL option found in the List tab, in the
> properties window of a Listbox field type? I played with it around but
> haven't gotten anywhere. What're the situations that this will be used?
>
> Thank you CodeCharge Support Team for all the help extended to me for my
> last two postings.
>
> - Dante S.
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.