Help with SQL from ASP

Results 1 to 2 of 2

Thread: Help with SQL from ASP

  1. #1
    Join Date
    Dec 1969

    Default Help with SQL from ASP

    I have an ASP script that generates SQL code for me. However, I the following SQL generates no matches (even when it should).<BR><BR>The SQL:<BR><BR><BR>Select Bible.ID, Bible.Book, Bible.Chapter, Bible.Verse, Bible.TextData, Books.BookID, Books.BookName From Bible Inner join Books On Bible.Book = Books.BookID where (Bible.TextData like &#039;%jesus%&#039; And Bible.TextData LIKE &#039;%christ%&#039;) and Bible.Book = 40 order by asc<BR><BR>It doesn&#039;t generate any errors however. &#039;On Error Resume Next&#039; is not enabled.<BR><BR>Any help would be most appreciated.<BR><BR>Conrad

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default I would think

    &#062;Bible.Book = Books.BookID<BR>shoudl be Bible.BookID = Books.BookID<BR><BR><BR>try that first....<BR><BR>

Posting Permissions

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