---
title: "cookie, variabel och databasproblem"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/54599-cookie-variabel-och-databasproblem"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "LR^evil.sid"
published: "2002-09-29T14:53:33.000Z"
updated: "2002-09-29T15:08:11.000Z"
replies: 4
views: 234
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/54599-cookie-variabel-och-databasproblem"
---

# cookie, variabel och databasproblem

## #1 — LR^evil.sid, 2002-09-29T14:53Z

tjena!

jag har en variabel som får sitt värde genom en request.cookies och sedan ska jämnföras mot ett recordset.
problemet är att ifsatsen i presentationsfilen nedan inte fungerar. den går oavsätt värde till **else

head.asp:**

```
[red]	option explicit

	timePage        = timer ( )
	response.buffer = true
	session.timeout = 20
	session.lcid    = 1053

	bgColor         = siteColor ( bgColor )
	scriptName      = request.servervariables ( "script_name" )
	newsId          = request.cookies ( "dikk" ) ( "newsId" ) [blue]<-- har värdet 5[/blue]

	response.cookies ( "dikk" ) ( "date" ) = now( )
	response.cookies ( "dikk" ).expires = now ( ) + 30

<!-- #include virtual = 'func.asp' -->[/red]
```

**func.asp:**

```
[red]	sub openDb ( database )
		set con = server.createobject ( "adodb.connection" )
		con.open " provider = microsoft.jet.oledb.4.0; data source = d:\db\" & database & ".mdb "
	end sub[/red]
```

**presentationsfilen:**

```
[red]<!-- #include virtual = 'inc/head.asp' -->
	database = "database"
	openDb ( database )

	sql = " select news.nwsId, news.nwsTitle, news.nwsPost, format$ ( news.nwsDate, 'yyyy-mm-dd' ) as nwsDate, format$ ( live.livDate, 'yyyy-mm-dd HH:mm' ) as livDate from live, news order by news.nwsDate desc, live.livDate "
	set rs = con.execute ( sql )

	strOut = rs ( "nwsId" ) [blue]<-- har värdet 5[/blue]

' write the news
	response.write _
		"<a href = 'news.asp'>news</a>: <br>newsId: " & newsId & "<br> rs news: " & rs ( "nwsId" ) & "<br>"

	if rs ( "nwsId" ) = newsId then
		response.write _
			"Det finns inga nya nyheter sedan ditt senaste besök"
	[b][blue]else[/blue][/b]
		response.write _
			"<b>" & rs ( "nwsTitle" ) & " " & rs ( "nwsDate" ) & "</b>"

	' get the ten first words from news
		arrPost = split ( rs ( "nwsPost" ), " " )
		for i = 0 to 9
			post = post & " " & arrPost ( i )
		next
		strOut = post
		strOut = formatStr ( strOut ) & " ..."

		response.write _
			"<br><br>" & strOut & "<br>" & vbcrlf
	end if[/red]
```

en response.write på newsId ger värdet 5 och likaså rs ( "nwsId" )

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

## #2 — Jesper T, 2002-09-29T15:00Z

Det här då?
if cint(rs ( "nwsId" )) = newsId

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

## #3 — @nders, 2002-09-29T15:01Z

Olika subtyper?
Konvertera i if-satsen till lämplig subtyp.

```
if clng(rs ( "nwsId" )) = clng(newsId) then
```

Mvh,

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

## #4 — LR^evil.sid, 2002-09-29T15:03Z

gav ingen förändring

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

## #5 — LR^evil.sid, 2002-09-29T15:08Z

tack hörni nu fungerar det...

```
if clng ( rs ( "nwsId" ) ) = clng ( newsId ) then
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/54599-cookie-variabel-och-databasproblem