Hello,
When I submit my form, I need to use a stored procedure on a remote database which accepts named value pairs. I want to pass the form elements' shortname AND value, but not able to figure out the correct token for the shortname.
For example: SaveDemographic Population=123, ChildPoverty=12, ChildFoster=12, ChildMedicaid=4
alternately, I could write the stored procedure to accept one big string encased in single qutoes and comma delimited:
SaveDemographic 'Population=123, ChildPoverty=12, ChildFoster=12, ChildMedicaid=4'
The reason I'm needing this is that my destination table is vertical and I don't have a corresponding column to each of my form elements. My table is a "mapping" table which relates a demographic metric with a value and a location identifier.
CountyID, DemoID, Metric
1 1 19281
1 2 12398
1 4 12290
1 5 12890
1 6 12992
1 7 12290
1 8 12291
Please advise,
Thanks!