On an ASP web page there is a Text Box with default Values for different records.
The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called 'BUSINESS_UNIT'.
On the same page i have created a Combo Box populated by a table called 'dbo.BUSINESS_UNITS' with 19 possible values only.
The field name for this is 'NAME''
My task is to make the Combo box "default value" equal to the "current text value" in the Original Text Box
The line of code i am working on is below .....
RS_DROP.Open "SELECT Name FROM BUSINESS_UNITS WHERE Name = "default value of textbox"
Does anyone know if this can be done in VBScript ?
Thanks & Regards
VBScript, ASP, SQL Server 2008
July 11, 2012 3:31 PM