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!

I forgot to mention that the easy answer "just write out your shortnames and put the $(shortname) after the equals sign", is not going to work because my destination is a mapping table.  I can't just write an update statement in my stored procedure.  I have to loop through the parameters and update when it finds a match.

Thanks for your reply.

I was shooting for your solution #3.  However, I need to know if there are tokens which represent the shortfieldnames instead of just the value.

Here's what I'd like to be able to do:

sp_MyStoredProcedure '$(FormField1_text)=$(FormField1_value)'

note:  "FormField1"  describes the first element dynamically, my shortfield name isn't named "FormField1", it's something else. I  just want to reference the formfields without using the explicit shortname- using the reference.

Can you expose these properties?