displaying database info via asp

[RFH Reseller: UKFlyer]

No problems with displaying the information as per my first example - except the fact I get a number for CourseLocation from the database - which I expected. It's converting that number to LocationTown ... which was achieved on another site from this thread but with players names...

The line is

set adoS1 = adoCn.Execute(strSQL)

[RFH Reseller: UKFlyer]

I spent about two hours last night working through it all changing various varibles and finally discovered it was the data type in the access db. I had made courselocation 'text' and as it contained numbers it displayed and linked OK as a number. However using my revised select statement it caused the page error. Changing the field to number and it works as I want it to work even though the information remains the same! Simple really.... doh!