Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Web server, problem with form write and read from DB

Created by: AutoGen_795420 at: 9/27/2015 8:58 PM (4 Replies)

Rating (0)

Thanks 2

5 Entries

9/27/2015 8:58 PM	Rate (0)
AutoGen_795420 Member Joined: 1/17/2015 Last visit: 8/7/2023 Posts: 2 Rating: (0)	Hi, I have problem with form write and read from DB. When I read and write to Tag everything is ok To DB <form method="POST"> <input name='"webdata".myInt' value=:='"webdata".myInt': type="text"> </form> To Tag <form method="POST"> <input name='"MyVariable"' value=:="MyVariable": type="text"> </form> Can you help me? ------------------------------------------------------------------------------------------ Split from Problem modifying a REAL number from my web page.
	Last edited by: Min_Moderator at: 9/28/2015 11:51:29 AM New subject after splitting
Suggestion To thank Quote Answer

9/28/2015 4:39 PM	Rate (0)
0_Einstein Diamond Expert Joined: 7/7/2010 Last visit: 1/21/2025 Posts: 15549 Rating: (2467)	With DBs, I had the best luck defining an alias in the <meta> section of the html. Then it is just referencing the simple alias in the form or display tags. <!-- AWP_Enum_Def Name="OnOff" Values='0:"Off",1:"On"' --> <!-- AWP_Out_Variable Name='"someDB"' --> <!-- AWP_Out_Variable Name='adHP' Use='"someDB".Hyd_Pump_MS' --> <!-- AWP_Out_Variable Name='outHP' Use='out_Hyd_Pump_MS' --> <!-- AWP_Out_Variable Name='fltHP' Use='flt_Hydr_Pump_MS' --> <!-- AWP_Out_Variable Name='ESSR' Use='EStop_Stop_Request' --> <!-- AWP_Enum_Ref Name='adHP' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='fltHP' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='ESSR' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='outHP' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='PLC_Fault' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='PLC_IO_Fault' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='Profinet_Fault' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='PLC_AI2_Fault' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='IO_Module1_Fault' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='in_Hydr_Pump_OL' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='in_ESTOP_Status' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='out_SafetyRelay_Reset' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='in_Hydr_Pump_Drive_FLT' Enum="OnOff" --> <!-- AWP_Enum_Ref Name='out_Hyd_Pump_RUN' Enum="OnOff" --> Maybe this example is useful to you in deciding if using the AWP_..'s is useful. It makes it easier in many ways, plus I found the DB AWP makes the syntax easier to get right. AutoGen_795420 Hi, I have problem with form write and read from DB. When I read and write to Tag everything is ok To DB <form method="POST"> <input name='"webdata".myInt' value=:='"webdata".myInt': type="text"> </form> To Tag <form method="POST"> <input name='"MyVariable"' value=:="MyVariable": type="text"> </form> Can you help me? ------------------------------------------------------------------------------------------ Split from Problem modifying a REAL number from my web page.
	science guy
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users AutoGen_795420

10/3/2015 7:31 PM	Rate (0)
AutoGen_795420 Member Joined: 1/17/2015 Last visit: 8/7/2023 Posts: 2 Rating: (0)	Many thanks! Maybe you have example application with forms www and S7-1200? Regards Martin

Suggestion To thank Quote Answer

10/4/2015 12:38 PM	Rate (0)
Estring Posts: 86 Rating: (3)	Hi, use as huggy suggested i use the same way and it works wonder full. <!-- AWP_In_Variable Name='"Master_MB_DB"."Min_ADDR"' --> <!-- AWP_In_Variable Name='"Master_MB_DB"."Max_ADDR"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Device_ID1"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Device_ID2"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Device_ID3"' --> ... <!-- AWP_In_Variable Name='"Web"."MBM_StartAdd_1"' --> <!-- AWP_In_Variable Name='"Web"."MBM_StartAdd_2"' --> <!-- AWP_In_Variable Name='"Web"."MBM_StartAdd_3"' --> ... <!-- AWP_In_Variable Name='"Web"."MBM_Lenth_1"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Lenth_2"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Lenth_3"' --> .... and then you can use the variable name: <td><input name='"Web"."MBM_Device_ID1"' value=':="Web"."MBM_Device_ID1":' type="text" /></td> for example
Estring Posts: 86 Rating: (3)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users 0_Einstein

10/6/2015 10:19 AM	Rate (0)
StamatisJE Posts: 5 Rating: (0)	Estring Hi, use as huggy suggested i use the same way and it works wonder full. <!-- AWP_In_Variable Name='"Master_MB_DB"."Min_ADDR"' --> <!-- AWP_In_Variable Name='"Master_MB_DB"."Max_ADDR"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Device_ID1"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Device_ID2"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Device_ID3"' --> ... <!-- AWP_In_Variable Name='"Web"."MBM_StartAdd_1"' --> <!-- AWP_In_Variable Name='"Web"."MBM_StartAdd_2"' --> <!-- AWP_In_Variable Name='"Web"."MBM_StartAdd_3"' --> ... <!-- AWP_In_Variable Name='"Web"."MBM_Lenth_1"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Lenth_2"' --> <!-- AWP_In_Variable Name='"Web"."MBM_Lenth_3"' --> .... and then you can use the variable name: <td><input name='"Web"."MBM_Device_ID1"' value=':="Web"."MBM_Device_ID1":' type="text" /></td> for example Hi, I would like to ask you if it works for "REAL" values, because it works fine for INT values, but when I use REAL values and try to write a decimal variable, I don't get any result. Also, when I use REAL value and try to write a negative value, the displayed value is 4.294967e+09. If you want, I can post you my code immediately. Thank you in advance.
StamatisJE Posts: 5 Rating: (0)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on