Swn-Y-Mor
asked on
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__MMCol Param, "'", "''") + "%' 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
SELECT * FROM tblFixtures WHERE FixtureTeam LIKE '%" + Replace(rsFirstTeam__MMCol
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
ASKER
OK Sorry!
I answered my own question. I guess I was just being lazy posting a question on here without trying myself first
I answered my own question. I guess I was just being lazy posting a question on here without trying myself first
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"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?