CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Multiple where clauses for a listbox

Print topic Send  topic

Author Message
Dorin

Posts: 50
Posted: 08/03/2012, 6:35 AM

Hello,

What is the correct code to add multiple where clause to dynamically modify the values of a listbox?

For example, a single where clause the code added to the Before Build Select event of the listbox is:

Tasks.Status.DataSource.Where = "id >2"

I tried

Tasks.Status.DataSource.Where = "( id >2 and status>0) "

but is not working.

Thanks.
View profile  Send private message
Vasiliy

Posts: 378
Posted: 08/04/2012, 12:30 AM

Here is an example from my code:

If Tickets.Datasource.Where = EMPTY Then
Tickets.Datasource.Where = SQL
Else
Tickets.Datasource.Where = " AND " & SQL
End If

_________________
Vasiliy
View profile  Send private message
Dorin

Posts: 50
Posted: 08/05/2012, 11:30 PM

Quote Vasiliy:
Here is an example from my code:

If Tickets.Datasource.Where = EMPTY Then
Tickets.Datasource.Where = SQL
Else
Tickets.Datasource.Where = " AND " & SQL
End If


Thanks Vasiliy, I'll give it a try.
View profile  Send private message

Add new topic Subscribe to topic   


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.