update multiple records

[alexz]

I'm trying to to update multiple records with a drop
down. My update statment updates all selected records with
all selected choices. I get for example A,C in all the selcted grade fields
instead of A in one field and C in another.


Response.Write "<INPUT type=""hidden"" name=""Recordid"" value='"& StrID &"'>"

My drop down

Response.Write("<SELECT NAME=""grade"">")
Response.Write "<option value=" & rs("grade") & ">" & rs("grade")&"</option>"
Response.Write "<option value=""A"">A</option>"
Response.Write "<option value=""B"">B</option>"
Response.Write "<option value=""C"">C</option>"
Response.Write "<option value=""D"">D</option>"
Response.Write("</SELECT>")
Response.Write ("</td>")
rs.MoveNext
Loop
rs.Close
------------------------------

strgrade = Request.Form("grade")
strID = Request.Form("Recordid")
SQLstr = "Update courseReg Set grade = '"& strgrade &"' Where Id =" & strID
set RS=MyConn.execute(sqlstr)

Thanks in advanced.

[Manohar Kamath [MVP]]

I don't get this... are you trying to update multiple records with one
UPDATE, but have different values for each record? If that's the case, you
will need one UPDATE statement for each record. From the looks of it, you
probably have two "grade" fields on your page, and hence getting multiple
values.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"alexz" <alexz33@hotmail.com> wrote in message
news:43d72b53.0402060658.55c54f5f@posting.google.c om...

> I'm trying to to update multiple records with a drop
> down. My update statment updates all selected records with
> all selected choices. I get for example A,C in all the selcted grade

fields

> instead of A in one field and C in another.
>
>
> Response.Write "<INPUT type=""hidden"" name=""Recordid"" value='"& StrID

&"'>"

>
> My drop down
>
> Response.Write("<SELECT NAME=""grade"">")
> Response.Write "<option value=" & rs("grade") & ">" &

rs("grade")&"</option>"

> Response.Write "<option value=""A"">A</option>"
> Response.Write "<option value=""B"">B</option>"
> Response.Write "<option value=""C"">C</option>"
> Response.Write "<option value=""D"">D</option>"
> Response.Write("</SELECT>")
> Response.Write ("</td>")
> rs.MoveNext
> Loop
> rs.Close
> ------------------------------
>
> strgrade = Request.Form("grade")
> strID = Request.Form("Recordid")
> SQLstr = "Update courseReg Set grade = '"& strgrade &"' Where Id =" &

strID

> set RS=MyConn.execute(sqlstr)
>
> Thanks in advanced.

[dabendschein]

Sorry about this... i am a newcomer to dreamweaver and publishing programs in
general. I need to update multiple records in an Access db. I have figured out
how to create update forms with master/detail pages where I can update one
record at a time. What I need to be able to do is update a repeated region
table and have the right info in the right field. Right now if I try to do this
I end up with either an error or at best multiple records in one field (example
I try to input three "unit prices" of 1$, 2$, and 3$ in three distinct records
and they end up in the first record's "unit price" field with a value of
"1,2,3")

Any help is appreciated, thank you

[Paul Whitham TMM]

There are some tutorials on [url]www.charon.co.uk[/url] that explain how to handle
multiple updates

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"dabendschein" <webforumsuser@macromedia.com> wrote in message
news:d6l52j$56m$1@forums.macromedia.com...

> Sorry about this... i am a newcomer to dreamweaver and publishing programs

in

> general. I need to update multiple records in an Access db. I have figured

out

> how to create update forms with master/detail pages where I can update one
> record at a time. What I need to be able to do is update a repeated region
> table and have the right info in the right field. Right now if I try to do

this

> I end up with either an error or at best multiple records in one field

(example

> I try to input three "unit prices" of 1$, 2$, and 3$ in three distinct

records

> and they end up in the first record's "unit price" field with a value of
> "1,2,3")
>
> Any help is appreciated, thank you
>
>