Transfer Some data to a database

Transfer Some data to a database (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

wizard_oz -> Transfer Some data to a database (9/28/2006 7:24:41)

Hi,
I created a page whcih send to DATA the code is:(only part of the code)

	<FORM action="EditPriority.asp" method=POST id=form1 name=form1>
<%
		Response.Write "<td><INPUT type=""text"" id=""IdRight"" name=""IdRight"" size=5 value=" & rs("ID") & "></td>"
		Response.Write "<td><INPUT type=""text""' id=""Priority"" name=""Priority"" size=1 value=" & rs("Priority") & "></td>"
		
		rs.MoveNext
	wend

At the other page I am trying to UPDATE me records:

<%
	IdRight=Request.Form("IdRight")
	set conn=server.CreateObject("ADODB.connection")
	conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\WebSite\MagenLi\magenli.mdb"
	
	If Len(Request.Form("Priority")) = 0 Then
		Response.Write "You haven't selected any software, that makes me sad :("
	Else
		Response.Write "You have selected the following software: <br />"
	Dim t_soft
	For each t_soft in Request.Form("Priority")
	For each t_id in Request.Form("IdRight")
	
	conn.Execute "UPDATE RightMenu SET Priority='" & t_soft & "' where id=" & t_id
	
	next
	
	Next
	End If
	conn.Close
	set conn=nothing	

%>

The code is not working fine becasue the second FOR command is wrong becasue I need to update every id's record and this code updates all the record with the same data
I understand why it's happend, how can I move the next id without the for command?

rdouglass -> RE: Transfer Some data to a database (9/28/2006 9:10:25)
quote: conn.Execute "UPDATE RightMenu SET Priority='" & t_soft & "' where id=" & t_id Just before that line try putting these two lines: Response.write("UPDATE RightMenu SET Priority='" & t_soft & "' where id=" & t_id) Response.end That should write the full SQL to the screen so you can see anything there. Also, you have what looks like a typo in there (see the apostrophe?) Response.Write "<td><INPUT type=""text""' id=""Priority"" name=""Priority

wizard_oz -> RE: Transfer Some data to a database (9/28/2006 11:50:34)
How is thise lines that you wrote will help me? I know what's the problem. the problem is I have 2 loops and I don't need them, I need the extranal loop and then every priority i need to match it to a certain record

rdouglass -> RE: Transfer Some data to a database (9/28/2006 12:39:31)
quote: How is thise lines that you wrote will help me? Sorry. Just trying to figure out what the problem is. I'm not sitting in your seat. You posted incomplete code with bad syntax in your first section and I just wanted to confirm step A was working correctly before step B. But anyways....I guess I dunno' then... Did you fix your typos?

wizard_oz -> RE: Transfer Some data to a database (9/28/2006 12:45:36)
First thanks for your help. I tryied your code and it gave me what i thought , It gave me the selection of a certain record and that it what I need is to find how do I update my records for example I have 4 records and I would like to update the first recocrd, and me data for that record is: priority 1 and id=1 now the second record is priority 3 and id=2 and the third record is priority 2 and id=3 this way I can sort my data is this help you to understand my problem?

wizard_oz -> RE: Transfer Some data to a database (9/29/2006 11:28:16)
anyone??????????

rdouglass -> RE: Transfer Some data to a database (9/29/2006 11:41:27)
quote: conn.Execute "UPDATE RightMenu SET Priority='" & t_soft & "' where id=" & t_id So instead of that line, what if you put this line in there temporarrily: response.write ("UPDATE RightMenu SET Priority='" & t_soft & "' where id=" & t_id & "<br>") That would output all your SQL statements to the screen and that might give you hints. My biggest recommendation is to don't overlook 'response.write' especially when it comes to lopping thru SQL statements and such. You absolutely need to confirm you're using the proper SQL and the right values. IMO that is invaluable in determining which way to turn. PS. None of us get paid anything on this forum - we're all volunteers. So I try to get you to do some of the work. I usually try to nudge you in a certain direction and not do the work for you. It's that whole 'teach a person to fish' thing. Hope that helps.

wizard_oz -> RE: Transfer Some data to a database (9/30/2006 5:25:29)
Hi Again, thanks for your help and I'm sorry if I sounds rude, that wasn't my intention. I just didn't know how to explain my problem I mean I tried almost everythinh before I contact you.usually I'm working hard to do it by my self and only if a have a serious problem for me I am contact you Again Sorry and thank you for you help I will try to do it Elen

Page: [1]

7.897949E-02