I have a web form created in Web Dev express and one of the fields is a drop down for a resource, in the database the table has resource name and resource email address, so to select it I can run the following:
select email from Resource_Ref_data where resource = ('strResource')
strResource is the drop down text and is populated from the Resource name field.
I want, when the submit button is clicked on this form to send an email automatically to the selected resource, by using the above statement.
My issue is, how can i run this statement and then assign the output to strResourceEmail ?
So that in turn I can modify my send mail routine: