Multiple WHERE Conditions in database Update ?

Question

0.00/5 (No votes)

See more:

hi all
can some pls advise me how i can add multiple where conditions in database when updated it
i try to use below code but its not successful and appear Syntax error (Missing operator )in query expression

VB

SavInto1.CommandText = "UPDATE PrintDetails set BaseFabricColor=" & "'" & TextBox3.Text & "'" & ",ArtWorkRef = " & "'" & TextBox4.Text & "'" & " WHERE OrderNo =" & "'" & TextBox1.Text & " AND PrintOn=" & "'" & TextBox2.Text & " '"

Posted 1-Oct-13 3:35am

Ahmed Shafea

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-10-01T03:39:00

The immediate problem is that you have missed out a quote:

VB

SavInto1.CommandText = "UPDATE PrintDetails set BaseFabricColor=" & "'" & TextBox3.Text & "'" & ",ArtWorkRef = " & "'" & TextBox4.Text & "'" & " WHERE OrderNo =" & "'" & TextBox1.Text & " AND PrintOn=" & "'" & TextBox2.Text & " '"

Should be

VB

SavInto1.CommandText = "UPDATE PrintDetails set BaseFabricColor='" & TextBox3.Text & "', ArtWorkRef = '" & TextBox4.Text & "' WHERE OrderNo ='" & TextBox1.Text & "' AND PrintOn='" & TextBox2.Text & "'"

But please don't do it like that!
Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.

Multiple WHERE Conditions in database Update ?

1 solution

Solution 1

Add your solution here

Preview 0

Multiple WHERE Conditions in database Update ?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us