Im using the most excellent 4GuysfromRolla tutorial for multiple updates/deleting found here @:
www.4guysfromrolla.com/webtech/100199-2.shtml

On my site Im needing to update multiple records <b>and</b> multiple fields...

Any ideas on how this could be done using their code?

To update multiple fields, just modify the update portion of the code:

------------------------------------------------------------------------
strSQL = "UPDATE Products SET Cost = " & CDBl(strCost) & _
" WHERE ProductID = " & strID
------------------------------------------------------------------------

The update command format is like this:

UPDATE TableName SET Field1 = Value1, Field2 = Value2, Field3 = Value3 WHERE RecordID = ThisRecordID

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Followed the tutorial on this page (part 1&2). I dont get it to work with multiple fields and records.... hmm. Please help me <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
____________________________________________________________

&lt;%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%&gt;
&lt;!--#include file="../Connections/myconnection.asp" --&gt;
&lt;%
Response.Buffer = True

'First, we need to get the total number of items that could be updated
Dim iCount
iCount = Request.Form("Count"

'We need to obtain
Dim strOs, strOsv, strVplus, strV, strVvi, strVi, str3sid, strBla, strID

Dim strSQL
Dim Command1
set Command1 = Server.CreateObject("ADODB.Connection"
Command1.ConnectionString = myconnection
Command1.Open

Dim iLoop

For iLoop = 0 to iCount
strOs = Request(iLoop & ".os"
strOsv = Request(iLoop & ".osv"
strVplus = Request(iLoop & ".vplus"
strV = Request(iLoop & ".v"
strVvi = Request(iLoop & ".vvi"
strVi = Request(iLoop & ".vi"
str3sid = Request(iLoop & ".3sid"
strBla = Request(iLoop & ".bla"
strID = Request(iLoop & ".ID"
strSQL = "UPDATE furu SET os = " & strOs & ", osv = " & strOsv & " AND vplus = " & strVplus & " AND v = " & strV & " AND Vvi = " & strVvi & " AND vi = " & strVi & " AND 3sid = " & str3sid & " AND bla = " & strBla & "" &_
" WHERE Nr = " & strID

Command1.Execute strSQL
Next

Command1.Close
Set Command1 = Nothing

Response.Write "Links were updated ! One moment..."

%&gt;

Edited by - powerpete on 13 May 2004 09:08:51

i guess the problem is in the update code... But why? i just added some more fields there!

...trying to use this:
www.dmxzone.com/showDetail.asp?TypeId=2&NewsId=1714

Edited by - powerpete on 13 May 2004 10:00:07

From the fields you have listed in your sql statement, are they all numerical? If not, list the text fields here and the numerical ones and i will correct your sql...

Regards
Vince

DMX Talkzone Manager

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Here's another tutorial for you to take a look at: www.drdev.net/article11.asp

Regards

Owen.

-------------------------------------------------------------------------------------------
Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
From the fields you have listed in your sql statement, are they all numerical? If not, list the text fields here and the numerical ones and i will correct your sql...

Regards
Vince

DMX Talkzone Manager

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

they are all numerical... so i don't se why it shouldn't work <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Here's another tutorial for you to take a look at: www.drdev.net/article11.asp

Regards

Owen.

-------------------------------------------------------------------------------------------
Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
i will look at it...

what the F*** is wrong, cant get it to work....

syntax error in update expression
'80040e14

all fields i wan't to update are numerical, so no ' here

crying for help...

is i possible to use access with this....

is i possible to use access with this....