Anybody see whats wrong with this multiple update?

[schase]

Hi all,

All the values are being passed a-ok, and database field names check out great - but I get the syntax error in update when I try to run it. Any ideas are greatly appreciated.

<%
Set Conn = Server.CreateObject(&quot;ADODB.Connection&quot
conn.open &quot;DSN=mydsn;&quot;
FOR i = 1 to Session(&quot;svRowCount&quot

SQLstmt = &quot;UPDATE tblDetail &quot;
SQLStmt = SQLstmt & &quot;SET fldPropertyID='&quot; & request.Form(&quot;txtDetailID&quot& i & &quot;',&quot;
SQLstmt = SQLstmt & &quot;fldDetail=&quot; & Request.Form(&quot;txtDetail&quot & i
SQLStmt = SQLStmt & &quot; WHERE detailID=&quot; & Request.Form(&quot;txtDetailNum&quot
Set RS = Conn.Execute(SQLStmt)
Next
set rs=nothing
Conn.Close
set conn=nothing
%> &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[gacaccia]

in the database, what data types are fldPropertyID and fldDetail? you're using quotes to enclose fldPropertyID, but you don't use them for fldDetail. does fldDetail hold a text value? if so, there's the problem (or a problem, at least).

glenn

 

[schase]

I've actually got that reversed don't I?

fldPropertyID is set for number(Long Integer) as is detailID, which is also autonumber.

the fldDetail is set for text &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart