yet another newbie question( sorry )

Results 1 to 2 of 2

Thread: yet another newbie question( sorry )

  1. #1
    Join Date
    Dec 1969

    Default yet another newbie question( sorry )

    sorry. i have yet another newbie question:<BR>i have just done a search engine but it seems to displays eveything that exists in my database.<BR>the following is my code:<BR>i used this to retrieve data from my database:<BR><BR>SearchMain = "SELECT * from Gold WHERE super like &#039;%" & keyword & "%&#039;;"<BR><BR>Set SearchMain = CategoryConnect.Execute(SearchMain)<BR><BR>den this :<BR>&#060;% Do While not SearchMain.EOF %&#062;<BR>&#060;%=(""&SearchMain.Fields("super")& "")%&#062;<BR>&#060;%SearchMain.MoveNext %&#062;<BR>&#060;% Loop %&#062;<BR><BR>and these are inside a table. it is supposed to display what i typed in to search but it displays everything that is in my database. <BR>Please help. Sorry for wasting your time but i am a newbie. hope someone can clarify my doubts.THanks!

  2. #2
    Join Date
    Dec 1969

    Default I think keyword is blank

    How are you getting keyword?<BR><BR>As it appears to be empty<BR><BR>DeBUG your SQL

Posting Permissions

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