SQL dB Query ?? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

WRXSTi -> SQL dB Query ?? (4/5/2002 17:55:43)

I have the following code: 
sql = "SELECT items.id, " & _  
 	  "items.subject, " & _  
 	  "items.condition, " & _ 
 	  "items.price, " & _  
 	  "items.category, " & _ 
 	  "items.email, " & _ 
 	  "items.user, " & _ 
 	  "items.submit_date, " & _ 
 	  "items.submit_type " & _ 
 	"FROM items " & _ 
 	"WHERE ((items.submit_type)='" & sType & "') AND ((items.user)='" & sUser & "');"


In my web page I have two text boxes where visitors will fill in for query conditions. sType is a item condition, new, used, etc, and sUser is the users ID. If a user fills in sType, but not sUser no results will be returned. can I force a '*' in for either sType or sUser for a representation of all results returned ?

Example: Query only used items and from all users? Is there a character or condition I can inser in the where condition or must I remove it for the query example to return all used items of all users.



Me



alveyuk -> RE: SQL dB Query ?? (4/5/2002 18:20:45)

As you are building the SQL in ASP code, the easy way is to build the WHERE clause using IF statements. If sType is populated then include that in the where clause. If sUser is populated then add that into the where clause.

You would need to trap the situation where neither had been supplied to make sure you did not perform an open query.

To get round the problem of whether including sUser started with WHERE or AND depending upon on whether sType was populated, you could start the clause with

WHERE ((1 = 1)

then both of the could always start with (AND items....... etc) and then finish after both IF tests with

)

Ken Alvey



WRXSTi -> RE: SQL dB Query ?? (4/5/2002 18:46:42)

I see... I'll look in to it. thanks !

Me



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875