Custom Resource for asset viewing on Orion website

Question

Hello, All- I've been using what little VBscript/ASP/HTML knowledge that I have to code some things for the website. This is very simple (at least I think so) so I feel like a dunce that this isn't working! What we are trying to do is make a simple view that we can add on to devices at our locations. I've added a few simple tables in the NetPerfMon DB and coded the Resource file to my liking- so that it generates this: The problem comes from the edit button. As of right now, the edit button opens up a completely seperate .asp file...so it's not being called from view.asp (which I think is related to the problem). The issue is that none of the SQLResource.SQL="Select ****" commands are doing anything. I would like for them to populate the input fields so that changes could be made to these tables if needed- here is what I have so far (obvsiously the input default values are not being populated....) The only solution I can think of is to have the edit button open up a totally seperate view...which i guess would be fine, I would just rather go this route and see if I can get it to work. Just FYI, the .Resource and edit.Resource file were based off the "view configurations from the website" files. <% SelectWeb "NetPerfMon" VerifyLogin "CUSTOMIZE" Dim ResourceID Dim Resource Dim ViewID Dim NetObject Dim NetObjectID Dim DetailAction Dim ConfigFilter Set ConfigFilter = Node.GetProperty("NodeID") Set SQLResource = NetPerfMon.NewSQLResource SQLResource.SQL="Select ISNULL(Count(NodeID),0) AS ConfigCount From Nodes where ConfigFlag = 1 AND NodeID=" & Node.NodeID SQLResource.Execute Set Session("NetPerfMon") = NetPerfMon ResourceID = Request("ResourceID") ViewID = Request("ViewID") NetObjectID = Request("NetObject") Set NetObject = NetPerfMon.GetNetObject(NetObjectID) Set Resource = NetPerfMon.SelectResourceByID(ResourceID) Set SQLResource2 = NetPerfMon.NewSQLResource() Set SQLResource3 = NetPerfMon.NewSQLResource() Set SQLResource4 = NetPerfMon.NewSQLResource() Set SQLResource5 = NetPerfMon.NewSQLResource() SQLResource2.SQL="Select terminal AS TerminalNumber From Nodes where NodeID =" & NetObject.GetProperty("NodeID") SQLResource2.Execute SQLResource3.SQL="Select terminal_address1 TAddress, terminal_city TCity, terminal_state TState, terminal_speed_dial TSpeed from xx_terminals where term_id=" & SQLResource2.GetProperty("TerminalNumber") SQLResource3.Execute SQLResource4.SQL="Select phone_number Pnum, roll_pattern Proll, fax Pfax, modem Pmodem, Fuel_master Pfuel from xx_phone_numbers where term_id=" & SQLResource2.GetProperty("TerminalNumber") SQLResource4.Execute SQLResource5.SQL="Select vendor_name VName, vendor_number VNum, Vendor_other VOther from xx_Vendor where term_id=" & SQLResource2.GetProperty("TerminalNumber") SQLResource5.Execute %> Edit <%=Resource.Title%> <% DoStyleSheets %> <% DoHeader %>

vhcato · Answer

I'm looking for something similar to what NG did in the post mentioned above, but I would like to be able to make multiple changes simultaneously. For example, if I have 20 custom properties associated with a particular node, it would be nice to be able to edit the text in more than one field, and be able to update all of them with a single click of the mouse, as opposed to updating each individual field.

Has anyone done anything like this?

Network_Guru · Answer

Thanks Mark, I see the in-line JPGs are back now as well

mark_wiggans · Answer

Guru-

URL Links have now been fixed- (crossing fingers)