Hi,

getting a expected statement error in select case function, but as it is a case statement, there is not need for any If statements. AHve inserted them to try (long shot) but to no avail. any bright ideas??

ta

kai


function getLiveData()

dim caseDetermine : caseDetermine = request.querystring("case")

select case Cstr(caseDetermine)

case "specific"

strSQL = "SELECT keyword,store,address,date,product,hours FROM "&request.querystring("area")&" WHERE keyword = '"&request.querystring("keyword")&"';"
objRS.open strSQL, objconn
response.write strSQL 'debug command for SQL statement...
if not objRS.eof or not objRS.bof then
getLiveData = objRS.GetRows()

case "nonspecific"

strSQL = "SELECT keyword,store,address,date,product,hours FROM "&request.querystring("area")&";"
response.write strSQL 'debug command for SQL statement...
objRS.open strSQL, objconn
if not objRS.eof or not objRS.bof then
getLiveData = objRS.GetRows()

case Else

redim temp(1,1)
temp(0,0) = -1
getLiveData = temp

end if
end select
end function