sqlfel

 
  sql = " select id, rubrik, detalj, user, privat"

  sql = sql &  "  FORMAT$(datum, 'yyyy-mm-dd') as datum1,"
  sql = sql &  "  FORMAT$(frantid, 'hh:mm') as ftid,"
  sql = sql &  "  FORMAT$(tilltid, 'hh:mm') as ttid"
  sql = sql &  " from plan"
  sql = sql &  " where id = " & iId
[b] line 46--> [/b]Set RS = Conn.Execute(sql)

Och jag får felmeddelandet:

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'privat FORMAT$(datum, 'yyyy-mm-dd')'.

/edit.asp, line 46

Vad kan detta bero på?

Du saknar ett komma efter privat.

Tack!