seasonedgeek
Programmer
A SQL Stored Procedure can be used to create HTML Markup, particularly an OPTION tag set for a SELECT (dropdown list) box. The OPTION VALUE attribute can be programmed to contain a single character or a character delimited string depending on how the data will be used.
An example:
SELECT '<OPTION VALUE="' + locationID + '">' +
locationName + '</OPTION>' AS opt
FROM someTable
ORDER BY locationName, locationID
Note: The resulting rows of "opt" will be truncated if length exceeds 255 chars.
Cheers!
An example:
SELECT '<OPTION VALUE="' + locationID + '">' +
locationName + '</OPTION>' AS opt
FROM someTable
ORDER BY locationName, locationID
Note: The resulting rows of "opt" will be truncated if length exceeds 255 chars.
Cheers!