---
title: "hum , 2 st till 1"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/79878-hum-2-st-till-1"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Rodan"
published: "2003-06-16T18:43:01.000Z"
updated: "2003-06-17T14:36:19.000Z"
replies: 6
views: 176
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/79878-hum-2-st-till-1"
---

# hum , 2 st till 1

## #1 — Rodan, 2003-06-16T18:43Z

hej

jag har två strängar.. som jag kallar de:P

```
1.Addera = "Select * From friends where ToiD =" &session("id") &" AND Approved = Yes order by relation desc"
```

```
2.Addera2 = "Select * From friends where fromiD =" &session("id") &" AND Approved = Yes order by relation desc"
```

hur kan man göra så att man slipper använda då? 

H/Rodan

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

## #2 — Rodan, 2003-06-16T18:45Z

kan de va ?

Addera = "Select \* From friends where ToiD,fromiD =" &session("id") &" AND Approved = Yes order by relation desc"

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

## #3 — LarsG, 2003-06-16T18:46Z

```
Addera = "Select * From friends where "  & session("id") &" in (toid,fromid) AND Approved = Yes order by relation desc"
```

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

## #4 — Rodan, 2003-06-16T18:48Z

tack,tack och tusen tack, åter kommer med andra liknande frågor :P

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

## #5 — Rodan, 2003-06-16T18:56Z

en annan fråga då...

jag vill ordna mina vänner typ så här

Vänner:
Olle
Hatobjekt:
Per
osv

nu undrar jag, hur kan jag göra de på de enklaste sättet ? jag har en väldig krånglig kod...  ni får se den här...

```
<%
Set Connect = Server.CreateObject("ADODB.Connection") 
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("databas/friends.mdb")&";"
Set rs = Server.CreateObject("ADODB.Recordset")
Addera = "Select * From friends where "  & session("id") &" in (toid,fromid) AND Approved = Yes order by relation desc"
rs.Open Addera, Connect, 3, 3
if not rs.eof then
%><b><font face="Verdana">

<html>
<head>
<LINK REL=stylesheet HREF="SwedenWorld.css" TYPE="text/css">
<body class="bg">

</font></b>

<table width="553" class="ram" cellspacing="0" bordercolor="#000000" bgcolor="#FFFFFF" border="0" style="border-collapse: collapse" cellpadding="0">
<tr><td colspan="5" width="549" height="29"><font class="text"><%=rs("Toname")%><font face="Verdana"><b>
  </b></font><font face="Verdana">'s <b>VÄNNER:</b></font><hr color="navy" size="1"></td></tr>

<% do until rs.eof%><b><font face="Verdana"> </font></b>
<tr><td width="123" height="12"><font class="text">
<% if rs("toid") = session("id") then %><font face="Verdana"><b>
<%else%> </b>
  </font>
<%=rs("relation")%></td><td width="122" height="12">
<a href="whois.asp?checkid=<%=rs("toid")%>" target="inne">
<%=rs("Toname")%></a></td><td width="97" height="12">
<%=rs("age")%><font face="Verdana"><b> </b></font>

<b>

<a href="do_delete_friend.asp?delid=<%=rs("id")%>" target="inne"><font face="Verdana" color="#000000">Ta bort</font></a><font face="Verdana">
</font>
</b>
</td></tr>
<tr><td width="123" height="10">
<%end if%><font face="Verdana"><b>
<% if rs("fromid") = session("id") then %>
<%else%> </b>
</font>
<%=rs("relation")%></td><td width="122" height="10">
<a href="whois.asp?checkid=<%=rs("fromid")%>" target="inne">
<%=rs("namn")%></a></td><td width="97" height="10">
<%=rs("fromage")%><font face="Verdana"><b> </b></font>

<b>

<a href="do_delete_friend.asp?delid=<%=rs("id")%>" target="inne"><font face="Verdana" color="#000000">
Ta bort</font></a><font face="Verdana">
</font>
</b>
</td></tr>
<%end if%><b>
<%
rs.movenext
loop
rs.close
connect.close
%>
```

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

## #6 — Rodan, 2003-06-16T18:57Z

kan väl säga att den är väldigt stökig:P

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

## #7 — Rodan, 2003-06-17T14:36Z

ingen ?

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/79878-hum-2-st-till-1