Printable View
Does anyone have an example of how to create an SQL statement that deals with Postcodes and using ASP. I need to be able to query my database via postcodes, but the trouble I want people to be able to enter something like
BETWEEN 'NE1' AND 'TS15', I don't get the right results and I've tried several ways.
Also what is the best way to stop a session timing out. I need to keep the session going till the user closes the browser.
1. Try SQL like "... WHERE CODE > 'NE1' AND CODE < 'TS15'" -- It works for Last Names on a SQL Server 2000 db I have.
2. Well, ASP has no way of knowing when the browser closes, but you could have them keep opening pages - you could use a frameset, and have one of the frames refresh every few minutes.
Thanks I've tried that, but since there are number in the postcodes it doesn't return true results
Example
>='Ne1' AND <='TS3'
Returns things like TS16, TS17, etc