can anyone shed some light on what I am doing (obviously) wrong?
This excerpt of code is inside a URL handler of Tim Dietrichs exceptionally well designed Allow Express Framework. Although I think that is is not important that it runs in such a REST server environment.
The function retrieves data from a database and display the data on a web site. The search pattern for the data is coming in through Request.URLParams and FetchBOM is doing the database query.
But rs is always empty ! When using the very same query string “hard coded” it works! Even if I do this stupid comparison you see i the code.
Any idea ?
// Dynamically generate a response. dim nav as new NavDBEngine.navDB dim rs as RecordSet dim stkStr as String = Request.URLParams dim stkStr2 as String = "EL 40 926" stkStr = stkStr.ReplaceAll("%20"," ") if stkStr=stkStr2 then rs = nav.FetchBOM(stkStr2) 'Retrieves all records. Works as expected 'rs = nav.FetchBOM(stkStr) 'returns an empty rs. Why ? end if