20. august 2003 - 23:36
Der er
5 kommentarer og 1 løsning
Hjælp til IF udtræk fra DB
Nedenstående trækker de nyheder ud af DB, der er under 3 måneder gamle. Men hvis jeg vil lave et check der siger: <% If showNewsArchive = "true" Then %> = så skal [created]<=90)) ORDER BY i stedet være: [created]>=90)) ORDER BY Hvordan skriver jeg det ind i nedenstående? <% 'Create database connection object Set Conn = Server.CreateObject("ADODB.Connection") 'Create database connection string DSN = "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=" & Server.MapPath("../../../db/database.mdb") & ";" & _ "Uid=admin;" & _ "Pwd=" 'Open connection to database Conn.Open(DSN) 'Create SQL querystring strSQL = "SELECT * FROM page " & _ "WHERE isNews = True " & _ "AND language = '" & language & "' " & _ "AND ((Now()-[page]![created]<=90)) ORDER BY page.pageID desc" 'Execute querystring (recordset contain data) Set rs = Conn.Execute(strSQL) 'Loop as long as there is data in the recordset While NOT rs.EOF %>
Annonceindlæg fra Deloitte
20. august 2003 - 23:38
#1
<% 'Create database connection object Set Conn = Server.CreateObject("ADODB.Connection") 'Create database connection string DSN = "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=" & Server.MapPath("../../../db/database.mdb") & ";" & _ "Uid=admin;" & _ "Pwd=" 'Open connection to database Conn.Open(DSN) 'Create SQL querystring if showNewsArchive = "true" Then strSQL = "SELECT * FROM page " & _ "WHERE isNews = True " & _ "AND language = '" & language & "' " & _ "AND ((Now()-[page]![created]<=90)) ORDER BY page.pageID desc" else strSQL = "SELECT * FROM page " & _ "WHERE isNews = True " & _ "AND language = '" & language & "' " & _ "AND ((Now()-[page]![created]>=90)) ORDER BY page.pageID desc" end if 'Execute querystring (recordset contain data) Set rs = Conn.Execute(strSQL) 'Loop as long as there is data in the recordset While NOT rs.EOF %>