I am looking for help creating a postcode distance search. Have a database with postcodes, longditues, latitude etc etc and have tried to create a search.

The problem is that it works with longer postcode such as WV10 but not with shorter postcode such as B1.

Does anybody have any ideas???



www.cmiexcel.com

Try having a look here

www.webthang.co.uk/tuts/tuts_dmx/dan1/dan1.asp

cheers

Simon

DWMX 2004 | ASP | VBScript

Hi Simon

That is where I got all of the original instructions from. I have added a few records of my own and any postcode that begins with a letter then number i.e. B4 does not show any results despite being in the database.

<a href="www.cmiexcel.com">www.cmiexcel.com</a>

u could try contacting the guy who originally started this post
www.dmxzone.com/forum/topic.asp?topic_id=31231

it worked great when he was building it, but haven't seen him around for a while.

regards

Dave Thomas
<b>DMX Zone Forums Manager</b>
Tip: Use Google or our own Search function to find answers before asking. You'd be surprised what's already written <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>