please help

[jarv]

Problem with my string, need help

<!--#include file="includes/functionlib.asp" -->
<%
objconn.execute("UPDATE homepage SET Body = " & Body & " AND Title = '" & Title )

msg = "Updated!"
set rs = nothing
closedb()

response.redirect "settings.asp?msg=" & msg
%>

[abduraooft]

Please help us by following http://www.codingforums.com/postguide.htm, especially the second one(and third?). (You may edit your thread)

[Shoot2Kill]

is there supposed to ba a single quote ' before the title ???

[hinch]

objconn.execute("UPDATE homepage SET Body = '" & Body & "' AND Title = '" & Title &"'")

should do it

[jarv]

objconn.execute("UPDATE homepage SET Body = '" & Body & "' AND Title = '" & Title &"'")

should do it

Thanks, I tried that.... I now don't get any errors but I get teh Body changes to 0 and nothing updates

[jarv]

so now i just have:


<!--#include file="includes/functionlib.asp" -->
<%
logincheck()
opendb()
Dim Body : Body = EncodeSQL(request.Form("Body"))
Dim Title : Title = EncodeSQL(request.Form("Title"))

objconn.execute("UPDATE homepage SET Body = '" & Body & "' AND Title = '" & Title &"'")

msg = "Updated!"
set rs = nothing
closedb()
response.redirect "settings.asp?msg=" & msg
%>

[hinch]

if your updating a int field then you don't need the single quotes ' you only need them if your inserting a string.

so atm the query is setup for a string update if body is an int it needs changing to Body = " & Body & "

same goes with Title

[jarv]

ok so i removed the single quotes ' ' now i get the error: Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression '<div id="lipsum"> <p> </p><p> Sidcom Southern Limited is a highly experienced and enthusiastic sign manufacturing and <a href="page.asp?PageNo=2" title="Sign Installation">installation</a> company. </p> <p> Based in Romsey on the South Hampshire '.

/update_home.asp, line 8

[hinch]

so it is a string so it needs the single quotes then the sql query is correct when you put back in the single quotes so I assume its something to do with how your opening your db and such

i rarely use conn.execute so no idea really if it works properly or not.

[jarv]

it was the objconn.execute

this works fine now!

SQL1="UPDATE homepage SET Body = '" & Body & "', Title = '" & Title &"'"
objConn.Execute (SQL1)


Thanks for your help Hinch!

[jarv]

it was the objconn.execute

this works fine now!

SQL1="UPDATE homepage SET Body = '" & Body & "', Title = '" & Title &"'"
objConn.Execute (SQL1)


Thanks for your help Hinch!