When I use this select statement within my code I do not get any results: -

strShowDetails = "SELECT * FROM Houses WHERE RentingPrice <= ? AND HouseHold = 'Baffins' AND Smoking = ? AND Furnished = ?";

I am using parameters but I want the HouseHold value to be static. Any ideas??



Adz - The World is not enough

__________________
Adz - Learning The J2EE Ways.

What database are you using? I didn't know ? was a reserved term... are you replacing this with something later?

Brian

Is it possible that your query just doesn't return anything?

I guess u used ? instead of parameters!
If u wanna use param for ur command there are 2 ways:
1_ use SP & set the value
2_ use something like @par1, @par2 instead of ? char!!

HTH.

Always:),
Hovik Melkomian.

Isn't ? the parameter identifier in Access?

Hello,

In the access documentation that I found, ? is a wildcard character that represents any single alphabetic character... How does ? differentiate between parameters if used in this manner?

Brian

So- what your doing wrong is your not understanding how to write a SQL statement.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

For access you can list parameters using ?. I've only seen it used for UPDATE and INSERT statements.

"INSERT INTO table_name" & _
                    "(column1, column2) " & _
                    "VALUES (?, ?)"
Dim dbComm As New OleDbCommand(strSQL, objConn)
dbComm.Parameters.Add("column1", OleDbType.Char, 49, "column1")
dbComm.Parameters.Add("column2", OleDbType.Char, 49, "column2")

dbComm.Parameters("column1").Value = txtFirstName.Text
dbComm.Parameters("column2").Value = txtLastName.Text

etc.

With Access the parameters have to be in the exact order of your INSERT statement or whatever statement you use.

From within access you can use ?'s... but if your writing the SQL from ASP- I think it needs to conform to standard SQL.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

I use the ? all the time on my small web apps but I am using ASP.NET. I don't think you can use the ? with old ASP.