Newbie Questions

Re: Validate textbox field against sql

jar92380 — Mon, 17 Mar 2008 13:29:31 GMT

Can someone please look at my code to see where I went wrong please

xdXDocument:GetDOM("Vision Database")/dfs:myFields/dfs:dataFields/d:ProjectCustomTabFields/@custReimbursibleMaxRateAir[../@WBS1 = xdXDocument:get-DOM()/my:travelRequest/my:JobNumber]

Re: Validate textbox field against sql

jar92380 — Wed, 12 Mar 2008 16:17:29 GMT

Clay

I just shot you an email

Re: Validate textbox field against sql

Clay Fox — Wed, 12 Mar 2008 15:56:11 GMT

So the problem is you are getting the values from the very first record not the one selected?

A filter is what you need to say set the values but where jobnumber = WBS1.

When selecting @airfareamount use the filter button and add WBS1 = JobNumber

That way you get the data for the correct record.

I work with databases and InfoPath every day.

If you want to email me I could show you some examples.

Validate textbox field against sql

jar92380 — Wed, 12 Mar 2008 15:41:23 GMT

Hello

This may seem like something very easy but I just can't get it working correctly. I have a text box field and a submit button setup. The submit button takes the data from the textbox and I want it to check a particular table in a SQL DB, and if the number is there to display some static numbers.

Here is what i have so far

Conditions

JobNumber is equal to WBS1 (SQL DB field)

Actions: Query using a data connection: sql db

Set a field's value airfare = @airfareamount

When i press the submit button all 0's are placed in the static field and I know there is a true number in there since I placed in the number

Any ideas?