Hello!

Using the JDBC_StaticViewPanelParam as a guide, I am trying to create an Xpage that will return a result set from a MS SQL Server db based on a parameter entered in an Xpages edit box control.  I have a "submit" button on the form.  I have the edit control setup as a viewScope variable.  I can display the value entered on the screen using computed field control.

When clicking the "submit" button, the entered value appears in the computed field, but no data is returned.  Below is my jdbcQuery code.

                        var="jdbcData1" sqlQuery="select * from employees where districtid=?"
                        defaultOrderBy="employeeid" calculateCount="true">
                        
                            
                                
                            
                        

I have hardcoded a value in the tag and gotten results, so the connection is working.  I also switched to a combo box control and the page returns results.

Any idea why I can't get results if my parameter is entered in a edit box control?

thanks,

chuck