Thread: query string value expression problem

Hi,

below is my query from my ASP page:

Code:

sql= "SELECT shows.[showID], shows.[showName], performances.[performance_time] FROM shows INNER JOIN performances ON shows.[showID] = performances.[showID] WHERE shows.[showName]='"& showName & "' AND performances.[performance_time]='"&performance_time & "'"

when i debug response.write SQL i get this :

Code:

SELECT shows.[showID], shows.[showName], performances.[performance_time] FROM shows INNER JOIN performances ON shows.[showID] = performances.[showID] WHERE shows.[showName]='Godzilla' AND performances.[performance_time]=''
Oops! No records found!

any ideas?

Originally Posted by jmurrayhead

Do you actually have shows where performances.[performance_time]='' ?? Otherwise, it would seem that your performance_time variable is empty.

i have shows:

Code:

[1] | Godzilla | 1:00
[2] | Godzilla | 2:00
[3] | Godzilla | 3:00

running the query in access produces the correct result.. :s

Originally Posted by jmurrayhead

It returns the correct result when you don't provide a performance_time value??

J,

I figured it out. My own fault, had uppercase and lower case in the database and it wasnt the same in the ASP page. Also added square brackets around the column names. Let that be a lesson to anyone designing there database