I am trying to do a report in asp but one of the options in the drop down list says "Citizen's Presentation" here is the statement:
SQL = SQL & " where file_type = '" & request("filetype") & "'"

and this is what appears in the browser using response.write
select * from tblAgendaItemDetail(nolock) where file_type = 'Citizen' order by file_number

I have tried everything to make this works but I cannot figure it out. Any help please I would appreciate. Thank you

slypunk

__________________
slypunk

I also did this:

    SQL = SQL & " where file_type = '" & request("filetype") & "'''"

and in the browser it shows up as this:

select * from tblAgendaItemDetail(nolock) where file_type = 'Citizen''' order by file_number

and it still does not work. :(

slypunk

Can someone please tell me what I have to do I have to complete this by tomorrow.

Thanks sorry for the urgent request.

slypunk

Please try:

SQL = SQL & " where file_type = '" & replace(request("filetype"),"'","''") & "'"

Om Prakash