General

Re: Query

Greg Collins — Mon, 25 Oct 2004 21:01:30 GMT

I'm glad you got it working! Thanks for sharing the finished code with us!

Greg Collins [InfoPath MVP]

Re: Query

BrownR — Mon, 25 Oct 2004 15:28:59 GMT

Heres the code i put behind my search. This takes both numbers that im searching between and displays the records inbetween to be changed.

function CTRL2_8::OnClick(eventObj)
{ 
  // Get the default SQL command for the form.
  var strOrigSQLCommand = XDocument.QueryAdapter.Command;

  var queryCase = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:Master");

  var strSearch1 = XDocument.DOM.selectSingleNode("//dfs:myFields/my:Search1").text; 
  var strSearch2 = XDocument.DOM.selectSingleNode("//dfs:myFields/my:Search2").text;
  
  // Ask InfoPath to construct an SQL command that is based on all other field values.
  var strMySQLCommand = XDocument.QueryAdapter.BuildSQLFromXMLNodes(queryCase);

    var strCase = queryCase.selectSingleNode("@Case").text;
  queryCase.selectSingleNode("@Case").text = "";
  
  // Construct the full query string.
  var strSQLQuery = strOrigSQLCommand;
      strSQLQuery = strSQLQuery + " WHERE  ([Case] >= '" + strSearch1 + "') AND ([Case] <='" + strSearch2 + "')";
  var Test = XDocument.DOM.selectSingleNode
  // This is the query.
  //XDocument.UI.Alert(strSQLQuery);

  // Run the query.
  XDocument.QueryAdapter.Command = strSQLQuery;
  XDocument.Query();

  }

Re: Query

Greg Collins — Thu, 21 Oct 2004 18:15:57 GMT

I'm not much of a SQL person yet, and I'm assuming you are using SQL to store these 130,000 records.

But it seems to me that if you have the beginning number and ending number for the range you want that you should be able to build your query in code and then call the Query() method to retrieve your records.

I.E. query = * WHERE CASE >= TEXT1 AND CASE <= TEXT2 (or something to that effect).

Greg Collins [InfoPath MVP]

Re: Query

BrownR — Wed, 20 Oct 2004 19:46:48 GMT

I have a form that i want to retrieve maybe 50- 100 records out of 130,000. each record has a "Case" number. I want to be able to query from a begining case number<text1> to case number <text2>. And have it return the 75-100 records to be amended.

Re: Query

Greg Collins — Wed, 20 Oct 2004 19:42:50 GMT

Please provide more details. I don't understand what you mean by "query between two text boxes".

Greg Collins [InfoPath MVP]

Query

BrownR — Wed, 20 Oct 2004 19:31:18 GMT

I need to query between 2 text boxs. There both going to have nothing but number in either one. How would i go about doing this? Ive tried to have custom text boxs but i'm not sure how to wuery between the two numbers...