CodingForums.com - View Single Post

Old Pedant · 11-07-2012, 01:03 AM

Also, is there some reason you are using method="get" in your <form> tag instead of method="post"?

And is this page private to your company? That is, is the page accessible on the internet or is it strictly an inTRAnet page? If it is on the inTERnet, is it password protected?

FWIW, *IF* all my suspicions are correct, I *THINK* you will be able to simply do this on your updatemm_select.asp page to make it change *ALL* of the checked items to maintenance mode:

Code:

<%
set Conn=Server.CreateObject("ADODB.Connection")
Conn.open "Provider=sqloledb;Server=server;Initial Catalog=db;UID=user;PWD=pw;" 

sql = "UPDATE object SET status = 'maintenance' WHERE objid IN (" & Request("toggle_maint") & ")"
howmany = 0
conn.Execute sql, howmany

Response.Write "Changed " & howmany & " to maintenance mode"
conn.Close
%>

(The actual value you set status to of course depends on your needs, but that's the general idea.)

If you want, you can just try that code to see if it works.

But if it doesn't work, then I need all that I have asked for from you.

11-07-2012, 01:03 AM	PM User \| #8
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,172 Thanks: 59 Thanked 3,994 Times in 3,963 Posts	Also, is there some reason you are using method="get" in your <form> tag instead of method="post"? And is this page private to your company? That is, is the page accessible on the internet or is it strictly an inTRAnet page? If it is on the inTERnet, is it password protected? FWIW, IF all my suspicions are correct, I THINK you will be able to simply do this on your updatemm_select.asp page to make it change ALL of the checked items to maintenance mode: Code: <% set Conn=Server.CreateObject("ADODB.Connection") Conn.open "Provider=sqloledb;Server=server;Initial Catalog=db;UID=user;PWD=pw;" sql = "UPDATE object SET status = 'maintenance' WHERE objid IN (" & Request("toggle_maint") & ")" howmany = 0 conn.Execute sql, howmany Response.Write "Changed " & howmany & " to maintenance mode" conn.Close %> (The actual value you set status to of course depends on your needs, but that's the general idea.) If you want, you can just try that code to see if it works. But if it doesn't work, then I need all that I have asked for from you. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.