[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

asp sql query to asp.net sql query

I have a asp webpage working using the following sql query :

SELECT *  FROM tblFixtures  WHERE FixtureTeam LIKE '%" + Replace(rsFirstTeam__MMColParam, "'", "''") + "%' AND FixtureDate >= Now -1  ORDER BY FixtureDate ASC

using the following also :

<%
Dim rsFirstTeam__MMColParam
rsFirstTeam__MMColParam = "1st Team"
If (Request("MM_EmptyValue") <> "") Then
  rsFirstTeam__MMColParam = Request("MM_EmptyValue")
End If
%>

Following years of using Dreamweaver and asp, I now need to convert existing pages to asp.net - How should my asp.net datasource SelectCommand  query look?

As you can tell from my question, I am not very experienced. Dreamweaver query created using gui
0
Swn-Y-Mor
Asked:
Swn-Y-Mor
  • 3
1 Solution
 
Swn-Y-MorAuthor Commented:
Ah OK. I managed to find the Query Builder within VS 2008 and managed to get this sql query :-

"SELECT FixtureDate, FixtureDay, FixtureType, FixtureTeam, HomeTeam, AwayTeam, HomeAway, KickOff FROM tblFixtures WHERE (FixtureTeam = '1st Team') ORDER BY FixtureDate DESC"

 ... but I need to show the next fixture ie Now -1 but not sure how?
0
 
Swn-Y-MorAuthor Commented:
OK Sorry!
I answered my own question. I guess I was just being lazy posting a question on here without trying myself first
0
 
Swn-Y-MorAuthor Commented:
SELECT FixtureDate, FixtureDay, FixtureType, FixtureTeam, HomeTeam, AwayTeam, HomeAway, KickOff FROM tblFixtures WHERE (FixtureTeam = '1st Team') AND (FixtureDate &gt;= Now - 1) ORDER BY FixtureDate
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now