• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Query MySql and output in another readonly field.

Query MySql and output in another readonly field. 16 years 11 months ago #2990

I would be very pleased if this scenario has a solution :

I need to check data inserted in one field, and check the input against a MySql database,
output the result of the query in the readonly field next to it.
In the same form, on the same page, before the submit button is pressed!


Possible anyone ?
The administrator has disabled public write access.

Re:Query MySql and output in another readonly field. 16 years 7 months ago #4638

  • nettemor
  • nettemor's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 33
Hi,
Did you find any solution to this ?

I also need to implement this functionallity.
The administrator has disabled public write access.

Re:Query MySql and output in another readonly field. 16 years 7 months ago #4640

  • dragonjc
  • dragonjc's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 151
Maybe one solution is this :
First create your selectlist with code.
Into special attributes, insert the javascript code on a change or exit field action (of your choise, just learn javascript) and for action = write :
javascript:location.reload()

Into second field, in manage, write a code (learn knowledgbase from rsform pro) with your request.
This code will not be execute on first load, but will execute on reload.

I don't know if it is fonctionned, but maybe it is.

Second solution is this :
Into your manage form, create a select list for select country.
Add a hide field.
Into process, write your request. It will be execute on submit action. User will not see the result of request but is it reallly necessary ?
Component RS SHow Form in build
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!