CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 [RESOLVED]Help with Listbox in Grid with multiple tables

Print topic Send  topic

Author Message
BJB

Posts: 4
Posted: 08/12/2010, 2:15 PM

Hello,
I'm hoping someone can help me figure out why my list box within a grid does not filter data by the WHERE statements I'm using. There are multiple tables involved with this grid but when it displays the data my listbox shows all of the po-po data for every reference for this customer. It filters by UserID from the session but not REFNO from the list. It works fine on the maintenance page only displaying the p.o. numbers for that reference but not in the listing.
Here is the code from the VQ builder. Any help would be appreciated.

SELECT [po-po]
FROM pofile
WHERE [po-cusid] = '{UserID}'
AND [po-ref] = '{REFNO}'


Resolved by taking out of page.
View profile  Send private message
Oper


Posts: 1190
Posted: 08/14/2010, 12:37 PM

Screen shot of the Datasource Where Builder?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
View profile  Send private message
Oper


Posts: 1190
Posted: 08/14/2010, 12:37 PM

with both where...
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first
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.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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