Update der driller...

Har det her update script:

Dim strNews
Dim strHead
Set strNews = Request.Form("news")
Set strHead = Request.Form("headline")
strNews = Replace(strNews,"'","''")
strHead = Replace(strHead,"'","''")
       
strSQL = "Update news set "
strSQL = strSQL & "headline =  '" & strHead & "' "
strSQL = strSQL & "news = '" & strNews & "' "
strSQL = strSQL & " Where ID =" & Request.Form("ID")

Conn.Execute(strSQL)

Conn.Close
Set Conn = Nothing


Jeg prøver at indsætte dette:

And speaking of top 10's . . .

A list has been made of the <A HREF="http://www.gamerspulse.com/modules.php?op=modload&name=Sections&file=index&req=viewarticle&artid=126&page=1" class=text>most anticipated MMORPGs</A> at this point. Ofcourse WoW is on the list.


Men for dette:

ADODB.Connection.1 error '80004005'

SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'news = 'A list has been made of the /editexec.asp, line 26