Query records Within a Range of Numbers

[sboyd]

I have an SQL table. I need to build an infopath form to query
records in that table within a number range. There will only be one
table to work with. I know that I can query one number but I can't
figure out how to get the query to get all the records within the
range.

Flight_Id is my primary key in the table. What I want to do is to add
two fields in the query section of the form. I figured I would add the
fields to myFields as From and To. My thought was the user would add
a number in both fields and I want all the Flight_Id records that fall
within that range. We need to update a bunch of records and I don't
want to do them one at a time.

Can anyone help?

 

[Mr. Andersen]

I need to do almost the exact same thing in my form. Let me know if you find any resolution from other sources.



sboyd wrote:

Query records Within a Range of Numbers
22-Jan-10

I have an SQL table. I need to build an infopath form to quer
records in that table within a number range. There will only be on
table to work with. I know that I can query one number but I canno
figure out how to get the query to get all the records within th
range

Flight_Id is my primary key in the table. What I want to do is to ad
two fields in the query section of the form. I figured I would add th
fields to myFields as From and To. My thought was the user would ad
a number in both fields and I want all the Flight_Id records that fal
within that range. We need to update a bunch of records and I do no
want to do them one at a time

Can anyone help?

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
11 Ways to use JavaScript efficiently
http://www.eggheadcafe.com/tutorial...6-d98c3ffbc098/11-ways-to-use-javascript.aspx

 

[sboyd]

I need to do almost the exact same thing in my form.  Let me know if you find any resolution from other sources.

sboydwrote:

Query records Within a Range of Numbers
22-Jan-10

I have an SQL table.  I need to build an infopath form to query
records in that table within a number range.  There will only be one
table to work with.  I know that I can query one number but I cannot
figure out how to get the query to get all the records within the
range.

Flight_Id is my primary key in the table.  What I want to do is to add
two fields in the query section of the form. I figured I would add the
fields to myFields as From and To.  My thought was the user would add
a number in both fields and I want all the Flight_Id records that fall
within that range.  We need to update a bunch of records and I do not
want to do them one at a time.

Can anyone help?

Previous Posts In This Thread:

Submitted via EggHeadCafe - Software Developer Portal of Choice
11 Ways to use JavaScript efficientlyhttp://www.eggheadcafe.com/tutorials/aspnet/60a4a785-5349-43ba-bc76-d...

Still no solutions. I know someone has done this before. Finding one
record at a time is not practicle when you need to update several.
Any suggestions would be appreciated.

 

[No.7]

Hi

I have done this with Infopath and an access database located in Sharepoint.
Well, not exactly the same, but with a date range.
I didn’t use the standard query fields, as you mentioned, you can only query
one value at a time. I used some text fields and made a button with code
behind.

You can find the code/setup on my blog, if this is what you're looking for:
http://delepunkt.blogspot.com/2010/02/infopath-date-range-search-with.html

It's in Danish, but if you have any questions, just ask.