View Single Post
  #2 (permalink)  
Old Aug 7th, 2007, 11:43
thriftyspider thriftyspider is offline
Junior Member
Join Date: Aug 2007
Location: UK
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Keep getting error message Microsoft VBScript runtime error '800a01a8'

Not too sure (fairly new to ASP myself), but '" & strLeague & "'" does not look quite right shouldn't the & signs be outside the quotes when your doing concatenation? i.e. strQ_Teams = "SELECT * FROM tbldt200708B WHERE league=' & "strLeague" &"

Rob
Reply With Quote