---
title: "session med databasinformationen"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/110845-session-med-databasinformationen"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "LR^evil.sid"
published: "2004-09-05T10:56:13.000Z"
updated: "2004-09-05T10:56:13.000Z"
replies: 0
views: 181
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/110845-session-med-databasinformationen"
---

# session med databasinformationen

## #1 — LR^evil.sid, 2004-09-05T10:56Z

Smart eller hur korkat som helst?

```
Set oRs = oCon.Execute("SELECT COUNT(id) FROM querys WHERE ispublic = 1")
If Not oRs.EOF Then DbData = oRs.GetRows() Else Session("QueryCount") = 0

If DbData(0,0) > 0 Then
	If "" & Session("QueryCount") = "" Then Session("QueryCount") = 0
	If DbData(0,0) > Session("QueryCount") Then
		SQL = "SELECT * FROM usrquerys u,godrespond g WHERE ispublic = 1"
		Session("DbData") = GetQuerys(SQL)
		Session("QueryCount") = DbData(0,0)
	End If
	For i = 0 To UBound(Session("DbData"),2)
		.Write Session("DbData")(1,i)
	Next
End If
```

Permalänk: https://www.webforum.nu/p/110845

---

Tråden på webben: https://www.webforum.nu/amne/asp/110845-session-med-databasinformationen