Converting Access SQL for use in ASP

Results 1 to 2 of 2

Thread: Converting Access SQL for use in ASP

  1. #1
    Join Date
    Dec 1969
    Posts
    240

    Default Converting Access SQL for use in ASP

    &nbsp;<BR>How do you convert the following sql, generated in Access, so that you can use it in ASP/ADO???<BR><BR>"SELECT Log.ID, Log.Time, Log.IP, Log.File FROM Log<BR>WHERE (((Log.File) Like "*legal.asp*"));"<BR><BR>Thanks in advance,<BR><BR>Richard

  2. #2
    Join Date
    Dec 1969
    Posts
    52

    Default RE: Converting Access SQL for use in ASP

    Try replace "*" with "%"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •