Boy I hope you can help me...
at the present I have a page with multiple check boxs
the query for the record set is this :
SELECT pay_code,description,cc_payment
FROM ADMIN_PAY_METHODS
WHERE expiration_date >= SYSDATE
OR expiration_date IS NULL
ORDER BY payment_code ASC;
This populates the screen with all possible payment terms.
Now what I need to do is add this query to this one:
SELECT c.ADMIN_PAY_METHOD_XREF.source_system_id
FROM Admin_Order_Routing a,
Enterprise_Customer_Attributes b,
ADMIN_PAY_METHOD_XREF c
Where a.Source_System_ID = b.Source_system_ID
AND b.Source_system_ID = c.SOURCE_SYSTEM_ID
AND c.SOURCE_SYSTEM_ID = a string passed in in state(ASP)
AND c.SOURCE_SYSTEM_PAY_METHOD Is Not Null
The goal is to attach the resulting array of source system IDS as a hidden field. I would like to be able to validate that a payment_code is a viable option for the source_system_id, so that I may validate the data on the asp page through javascript. The first query populates the screen and i can not get it to only display a distinct set of pay_codes.
at the present I have a page with multiple check boxs
the query for the record set is this :
SELECT pay_code,description,cc_payment
FROM ADMIN_PAY_METHODS
WHERE expiration_date >= SYSDATE
OR expiration_date IS NULL
ORDER BY payment_code ASC;
This populates the screen with all possible payment terms.
Now what I need to do is add this query to this one:
SELECT c.ADMIN_PAY_METHOD_XREF.source_system_id
FROM Admin_Order_Routing a,
Enterprise_Customer_Attributes b,
ADMIN_PAY_METHOD_XREF c
Where a.Source_System_ID = b.Source_system_ID
AND b.Source_system_ID = c.SOURCE_SYSTEM_ID
AND c.SOURCE_SYSTEM_ID = a string passed in in state(ASP)
AND c.SOURCE_SYSTEM_PAY_METHOD Is Not Null
The goal is to attach the resulting array of source system IDS as a hidden field. I would like to be able to validate that a payment_code is a viable option for the source_system_id, so that I may validate the data on the asp page through javascript. The first query populates the screen and i can not get it to only display a distinct set of pay_codes.
