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.
|
|
|
Oper
Posts: 1195
|
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 |
|
|
Oper
Posts: 1195
|
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 |
|
|
|