SQL Statement

[em00guy]

I'm creating a query that will extract records from a clients DB. However some of the DB fields are assigned names with two words ("activity type" for example). IIS doesn't seem to like this. How do I query a field with a two word name with out changing the field name ?

[justa]

I'd advise you to rename the fields. It is a long painful task but will save you time and problems in the future. Spaces in field names are a big no no. Try to keep them to one word, or include an _ if you must have a space (although I have heard of that causing problems also).

[ralnikov]

set rs = conn.execute("select * from [hello hunny]")

[em00guy]

That worked. Thanx.