https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/11458.aspxThu, 12 Apr 2007 17:44:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:11458Greg Collins0https://www.infopathdev.com:443/forums/thread/11458.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=11458XDocument.Query() is used when your main DOM is connected to a datasource like SQL or Access.<br /><br />You have a data connection called "matters". You need to query that data connection.https://www.infopathdev.com:443/forums/thread/6188.aspxThu, 12 Apr 2007 15:50:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6188Wallen0https://www.infopathdev.com:443/forums/thread/6188.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6188I have a InfoPath form that I need to create a connection to a SQL database and return some values. I can create with using the Data Connection wizard, but that returns too many records. What I want to do is to pass a parameter. Here is my current code.<br /><br />function RetreiveMatters::OnClick(eventObj)<br />{<br />var objADOAdapter;<br />objADOAdapter = XDocument.DataObjects("matters").QueryAdapter ;<br />XDocument.objADOAdapter.Command = "exec _get_Lookup_values @table = 'matter', @filter = 'c.client_code = ''012307'"; <br /><br />//Query the Data Source. <br />XDocument.Query();<br />}<br /><br />What Am I doing Wrong?<br />TIA<br /><br />O<br />...If God didn't want us to eat animals, why did he make them out of meat???!!!