Search results for query: *

Hi foxbox, Yes, your syntax of course works perfectly... but I was just trying to understand why that Update method didn't work properly - and why it worked perfectly with one more field in the SELECT! :-( I've also tried to put a "response.write rs("rownumber") " before and...

Hi Fengshui1998, and thanks for your reply. Unfortunately the record updated outside my recordset are on the same table, and not on different tables with the same column name... Bruno Del Frate

Hello, I'm using a piece of code like this one, with SQL Server 7.0: <% query = &quot;SELECT rownumber FROM database WHERE ordernumber = 'XXX'&quot; rs.open query do until rs.eof rs(&quot;rownumber&quot;) = newvalue rs.update rs.movenext loop %> It works... BUT it also updates some...

Hello, I need to synchronize a MS Access database (97 or 2000, it doesn't matter) with a SQL Server 7.0 publication. I've tried the JetSQLSync routine located at http://msdn.microsoft.com/library/techart/JRORep.htm ... but it does not work: I keep getting a &quot;File not found&quot; message for...