Brug for ekspert SQL hjælp

hvad for en database er det, msAccess?

Jeps

Her er et et bud på de 4 SQL sætninger:

#1:

kommentar = "davs"
SQL = "SELECT Count(*) as Antal FROM (SELECT distinct billedid FROM Photos WHERE Comments LIKE '% & kommentar & "%')"


#2:

billedeID = 398
SQL = "SELECT Count(*) as Antal FROM (SELECT distinct billedid FROM Photos WHERE (Comments is not Null) AND (billedeID = " & billedeID & "))"



#3:

billedeID = 21
SQL = "SELECT billedeID FROM Photos WHERE (Comments is not Null) AND (billedeID > " & billedeID & ")"
set rs = conn.execute (SQL)
if rs.EOF then
  nextID = ""
else
  nextID = rs("billedeID")
end if


#4:

billedeID = 26
SQL = "SELECT billedeID FROM Photos WHERE (Comments is not Null) AND (billedeID < " & billedeID & ") ORDER BY billedeID DESC"
set rs = conn.execute (sql)
if rs.EOF then
  prevID = ""
else
  prevID = rs("billedeID")
end if

Super mange tak... med lidt modifikationer virkede alle 4 perfekt. Du er SQL-guden :o)