CODEWITHSUNDEEP
razorif-statementwebmatrix
Gavin5511
Gavin5511

Reputation: 791

Webmatrix if statement issues. any ideas?

I have written a SQL query, which extracts the lowest weekly price for a property stored in my database:

var rPropertyId = Request.QueryString["PropertyID"];
var cheapestrate = "SELECT TOP 1 * FROM RateInfo WHERE PropertyID=@0 ORDER BY RateWeekly ASC";
var qcheapestrate = db.QuerySingle (cheapestrate, rPropertyId);

I'm pretty confident that this statement is correct. The problem i have, is that not ALL propertys have pricing, so i only want to show this price if they do. I have created the below if statement, but it's telling me i'm missing an ; somewhere?

@if(qcheapestrate=!null){
Rates From qcheapestrate.rateweekly per week
}

So i'm trying to check if the query returns an entry. if it does, i want to show the lowest "rateweekly" value. Hopefully this all makes sense!

Upvotes: 0

Views: 106

Answers (1)

Ethan Pelton
Ethan Pelton

Reputation: 1796

Try this...

@if(qcheapestrate!=null){
<text>Rates From</text>
@qcheapestrate.rateweekly
<text>per week</text>
}

Upvotes: 1

Related Questions