[RESOLVED] RE: Expected statement but conding is right..

[kaihirst]

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

[Besoup]

I was getting that error when I accidently saved the file as rich text.... dunno if you made the same mistake but figured I would throw it out there.

[kaihirst]

Hi,

Cheers anyways but I got it.

The problem was that the expected statemewnt was coming because it was trying to execute an arbritrary command twice regardless of the case tests.

in thsi case it was assigning the function value to getrows() sub twice regardless of the outcome of the test.

tI have now put the function assignment outside of the select statement and it has worked, and speeded the response time fo the applicaiton , as no error handling needed now.

ta

kai

P.S.

If you ever want to run multiple sql statrements within a probram but done want to create the objects all over again, this is a handy way to do this using querystrings.

ta

kai (again)