[thelist] ASP ADO Quirks?

[Burhan Khalid]

Hello all,

      A colleague has this strange problem with a SQL query. It works
      fine locally (on a MSAccess database), but when stuck on an ASP
      script, doesn't give any output.

      Here is the SQL :

      strSql = _
      "SELECT " &_
      "ArtAds.ArtAdId, " &_
      "ArtAds.ArtAdArtist, " &_
      "ArtAds.ArtAdDesc, " &_
      "Categories.CategoryDesc, " &_
      "Subjects.SubjectDesc " &_
      "FROM " &_
      "(ArtAds INNER JOIN Categories ON ArtAds.CategoryId = Categories.CategoryId) " &_
      "INNER JOIN Subjects ON ArtAds.SubjectId = Subjects.SubjectId " &_
      "WHERE " &_
      "(((ArtAds.ArtAdArtist) Like '*" & strSearchText & "*')) " &_
      "OR (((ArtAds.ArtAdDesc) Like '*" & strSearchText & "*')) " &_
      "OR (((Categories.CategoryDesc) Like '*" & strSearchText & "*')) " &_
      "OR (((Subjects.SubjectDesc) Like '*" & strSearchText & "*'));"

      Is there any reason why this wouldn't work online?



--
*---------------*
| Burhan Khalid |
*---------------*---------------------------*
| Email : burhankhalid[at]members.evolt.org |
| Web   : members.evolt.org/burhankhalid    |
*-------------------------------------------*