Update query?

[SmileeTiger]

What is the format for an update query?<br><br>I tried <br>&lt;%<br>' Open Database Connection<br>Set Con = Server.CreateObject( &quot;ADODB.Connection&quot; )<br>Con.Open &quot;DSN=SN_Reg_System&quot;<br><br>' Execute the UPDATE statement<br>mySQL = &quot;UPDATE Survey SET Number='50' WHERE Name='Mac'&quot;<br>Con.Execute(mySQL)<br>%&gt;<br><br>but there seems to be something slightly wrong with it

 

[shaugen]

<br><br>try this:<br><br>mySQL = &quot;UPDATE Survey SET [Number]='50' WHERE Name='Mac'&quot;<br><br>..

 

[SmileeTiger]

Yup that worked QUITE fine. Why did I have to use []'s though?<br><br>Cory

 

[Keebler]

You have to use the brackets, [], because Number is a word reserved by SQL. There should be a complete list of reserved words in the help section of your database program.<br><br>HTH,<br>-Kelly

 

[shaugen]

Glad Icould be of any help <br><br>Hang in there!