I have list of possible travel locations in my db table for vacation packages we offer. I'm using a SELECT DISTINCT (SELECT DISTINCT Category FROM dbo.VacPckg) to weed out duplicate location categories.
My Results as expected:
Here is where I need help.
I want add "Europe" into the above results in ABC order but "Europe" is not in the db table. Is it possible to add it inside of a loop/wend? Is there another method I should try?
<!--#include virtual="/Connections/myConString.asp" -->
Set strObj = Server.CreateObject ("ADODB.Command")
strObj.ActiveConnection = MYl_STRING
SQL = "SELECT DISTINCT Category FROM dbo.VacPckg"
strObj.Prepared = true
strObj.CommandText = sql
Set rsCategory = strObj.Execute
rsCategory_numRows = 0
<% while not rsCategory.EOF %>
Set rsCategory = Nothing