This topic is locked
[SOLVED]

 ADDING A TEXTBOX NOT ASSOCIATED WITH FIELD

1/23/2020 6:34:07 AM
PHPRunner General questions
S
sharizkhan author

Hi
please guide me how can i add a text box to a from which will just hold values after
a selection is made from dropdown menu.
Normally All controls are associated with fields but this required text box should have no association with any field. Just an area to display message.
For making it more clear i am attaching a picture

=============================================================================================

I have created temporary column named tempField with values "NULL" in the sql query it allows me to create a text box and also JS is supplying text to it as values are clicked in a dropdown menu but as save is pressed error comes up
<<< Record was NOT added >>>
Unknown column 'tempTextHolder' in 'field list'
==============================================================================================
Waiting for your comprehensive support

https://gifyu.com/image/qKFq

N
Nir Frumer 1/23/2020

hi

I would add a space(100) as my_field to the sql query

and include it in the add/edit forms
just remember to "unset" it in the before add/edit
hope it helps

Nir.

Sergey Kornilov admin 1/23/2020

+1 to what Nir says. Here is the example from the manual:

https://xlinesoft.com/phprunner/docs/update_multiple_tables.htm

S
sharizkhan author 1/24/2020

Thanks

unset worked