First of all CSPBIND binds a form variable to a Object Property. You have two ways:
1 - Never mind the form variable and act in the form directly with the object you want, populating the drop down and act with some javascript or methods in order to manipulate the object.
2 - Bind the variable to the object - Create a Query in the class that will give you the field that you want:
In my case i want to select non Salesmen (Comercial) Name (Nome) Empregado (Employee)
Query NotComercial() As %SQLQuery(CONTAINID = 1)
{
SELECT ID, Nome FROM ECOM.Empregado emp
WHERE NOT EXISTS
(select Empregado->id, Empregado->nome from Ecom.Comercial
where Empregado->id = emp.id)
ORDER BY Nome
}of course this query gives you the ID and writes the name.
document.form.Comercial.value is ID and document.form.Comercial.text is Name (Nome).
You can pass an argument that will select directly the number you want.
For instance if you need ID 5 to be selected on <select name="Comercial"> you just say in your previous URL somethin like page2.csp?Comercial=5
I have some examples on the first case if somebody need an example i can post it !!
Hope this helps ! Nuno RJH wrote:
Cach� CSP wizard gives you a page where you can search and retrieve existing information from a table. It uses CSPBIND="somedata" to display information on text boxes. But what happens when you want to display a selected option from a drop down? not a text box? CSPBIND returns blank on a drop down. Can someone give an example on how to accomplish this?
