.asp

[kapil29]

hey guys

I am working on thr professors website. In the website, when you fill in the author's name it retrieves information.

So if the authors name is J. smith, then if I write Smith, J. then it gets the information since it stored in the database in this format. But if I type in J. Smith it does not get any information.

I need to write this code in the .asp file where the scripting language in VBScript. So if anyone of you can help me out with this, i would reall appreciate it. Any form of help is appreciated.

Thanks guys

Kapil

[jhardman]

You could handle it in the query statement:

names = split(nameEntered, " ")
query = "SELECT * FROM authors WHERE authorName = '" & names(0) &_
     ", " & names(1) & "' OR authorName = '" & names(1) & ", " & names(0)_
    & "'"
response.write "<!-- query: " & query & " -->" & vbNewLine
 

let me know if this helps. Or you could use instr to see if the user used a comma.

Jared

[kapil29]

You could handle it in the query statement:

names = split(nameEntered, " ")
query = "SELECT * FROM authors WHERE authorName = '" & names(0) &_
     ", " & names(1) & "' OR authorName = '" & names(1) & ", " & names(0)_
    & "'"
response.write "<!-- query: " & query & " -->" & vbNewLine
 

let me know if this helps. Or you could use instr to see if the user used a comma.

Jared

Hey it did work Thanks a lot.