aaaah I'm going insane ![Resolved]

What's wrong with this sql statement ??:rolleyes:

VB Code:

Dim Updater As String = "UPDATE " & MyTable & "SET C_URL='" & _ 
str1 & "'" & " C_category='" & str2 & "'" & " C_language='" & str3 _ 
& "'" & " C_USERNAME='" & str4 & "'" & " C_PASSWORD='" & str5 _ 
& "'" & " C_TIME='" & str6 & "'" & " C_DATE='" & str7 & "'" & " _ 
C_RATING='" & str8 & "'" & " C_COMMENT='" & str9 & "'" & " _ 
 
WHERE C_URL='" & str1 & "'"

You need to put a space before SET for one.

Quote:

---

"UPDATE " & MyTable & "SET

---

Put a space before SET and after MyTable

Actually there's a space but I forgot to include it here . Sorry to tell you , it won't work either .:rolleyes:

I should've told the error it throws : "Missing Operator" . It looks fine but don't know that's wrong in here .

You don't have any commas in there.

It should be like Update myTable SET fieldA = valueA, fieldB = valueB, fieldC = valueC where fieldD = valudD

No need to have commas in SQL Str.I'm sure ;)

In a SET statement that sets multiple values you do.

do what ? Umm ? What're you talking about!!!!!:D

btw , Don't you think field names are sensitive ??:rolleyes:

Dim Updater As String = "UPDATE " & MyTable & " SET C_URL='" & _
str1 & "'," & " C_category='" & str2 & "'," & " C_language='" & str3 _
& "'," & " C_USERNAME='" & str4 & "'," & " C_PASSWORD='" & str5 _
& "'," & " C_TIME='" & str6 & "'," & " C_DATE='" & str7 & "'," & " _
C_RATING='" & str8 & "'," & " C_COMMENT='" & str9 & "'" & " _

WHERE C_URL='" & str1 & "'"

hellswraith :D what did you add . No more errors but it isn't updating my db !

I c , so the magic in commas .How come ?:confused: . I remember I've tried like that but without commas .

Thanks hellswraith :D . Now everything is fixed !:p

Quote:

---

Originally posted by Shurijo
You don't have any commas in there.

It should be like Update myTable SET fieldA = valueA, fieldB = valueB, fieldC = valueC where fieldD = valudD

---

That's right .thanks;)