troubleshooting Question

Query SQL Server with Infopath field value as query variable.

Avatar of jhboricua
jhboricua asked on
Microsoft SQL Server
7 Comments1 Solution1812 ViewsLast Modified:
I have an Infopath form with some text fields, drop downs, and a repeating table. In the query to the database I have some variables that will determine the output for the reapeating table. For example.

Declare @Whatever = TinyInt
  Set     @Whatever = (This is where I want whatever is entered into the Infopath text field to be)

Ideally it would be something like,
  Set     @Whatever = TextField1

Or

  Set    @Whatever = DropDownField1

I have the database connection setup and binds, I just need to know how to do this one thing. Thats it, I can't seem to find this answer anywhere without learning .net or xml.

Pleaset talk to me like I'm a four year old, this is the last thing I need to complete my process, Thanks a ton!
ASKER CERTIFIED SOLUTION
QPR

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros