Expand my Community achievements bar.

Validate entered values based on a database

Avatar

Former Community Member
I'm trying to do something that seems that like it would be relatively simple but I just can't find the answer.



I have a form that I'm trying to design which would reference 4 database fields. I want the user to manually enter the value and then get an error message if they enter an invalid value. Drop down boxes won't work because they all have at least a couple hundred values.



There are about 3000 values in total so manually entering them isn't really an option. The values are in an Oracle database and can pull them into Excel or Access if I need to.



Suggestions on how to best handle this?
2 Replies

Avatar

Former Community Member
One way would be to use a SOAP call; do you have a web server that you could make a call to with the entered data?



To do this you'd create a data connection to the SOAP service that does the validation, add hidden fields for the parameters and the response, and then in the exit event for the field, click the hidden submit button to call the service.



Try creating the service and a connection to it first - testing a connection to a web service is pretty easy. You add the WSDL, drop the request and response fields from the Data View onto the form, drop the button that submits the response and hit Preview. Fill out the request fields and hit the button, and the response fields should fill in with the results of the call.



Once that works, you can set the request fields programmatically, programmatically click the button by using buttonName.execEvent("click") and then programmatically get the values from the response fields.



Let me know if this doesn't make sense to you, it seems a little strange but once you get it, it's not so bad.

--

Steve Tibbett, Developer Guy

Adobe Systems

Avatar

Level 3
Hi,

This kind of helped me, but the problem here is, after I execute the WSDL, it shows some fields that I had made invisible. Anyway around this?



Thanks,

RV