aakici
Posts: 49
|
| Posted: 12/05/2004, 3:07 PM |
|
I have a record form. It contains several fields their values come from a MySql database. When i change listbox value other fields are blank. But i want to : when listbox value change all other fields must be updated automatically. An example : my fields are (id, name, surname, telefon number, address, etc). ıd is a listbox. When i change an id from listbox then all other fields must be automatically updated. For example; when i select 21 then name, surname, telefon number and address must be updated as alpaslan, akıcı, 13243546, main street no:29.
_________________
Regards,
M.Alpaslan AKICI |
 |
 |
Avenger_iSO
|
| Posted: 12/05/2004, 5:11 PM |
|
HTML code
<SELECT name="" onChange=this.form.submit()>
|
|
|
 |
Damian Hupfeld
|
| Posted: 12/06/2004, 3:36 AM |
|
set the parameters of your grid to id=id
then make the name field required
then on the list box add an action to Client-OnChange of Submit
you will get an error because the name field is required, however it should
also submit the id back to the page which should then populate your fields
regards
Damian Hupfeld http://www.nexthost.com.au/services.php
"aakici" <aakici@forum.codecharge> wrote in message
news:541b394c264abb@news.codecharge.com...
>I have a record form. It contains several fields their values come from a
>MySql
> database. When i change listbox value other fields are blank. But i want
> to :
> when listbox value change all other fields must be updated automatically.
> An
> example : my fields are (id, name, surname, telefon number, address, etc).
> ıd is a listbox. When i change an id from listbox then all other
> fields
> must be automatically updated. For example; when i select 21 then name,
> surname, telefon number and address must be updated as alpaslan,
> akıcı, 13243546, main street no:29.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
 |
aakici
Posts: 49
|
| Posted: 12/06/2004, 10:37 AM |
|
Thanks. It is ok. Your code is working.
_________________
Regards,
M.Alpaslan AKICI |
 |
 |
klwillis
Posts: 428
|
| Posted: 12/06/2004, 12:56 PM |
|
You may find this helpfull. 
http://forums.codecharge.com/posts.php?post_id=53454&s_keyword=Hidden+Field
Quote aakici:
I have a record form. It contains several fields their values come from a MySql database. When i change listbox value other fields are blank. But i want to : when listbox value change all other fields must be updated automatically. An example : my fields are (id, name, surname, telefon number, address, etc). ıd is a listbox. When i change an id from listbox then all other fields must be automatically updated. For example; when i select 21 then name, surname, telefon number and address must be updated as alpaslan, akıcı, 13243546, main street no:29.
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
 |
 |
aakici
Posts: 49
|
| Posted: 01/28/2005, 4:12 PM |
|
answers here are all incomplete or wrong. i found that i have to use html code. like this :
window.location.href = "fatura.php?user_id=" + document.orders.user_id.value ;
and i have to use before show event to fill fields.
_________________
Regards,
M.Alpaslan AKICI |
 |
 |
peterr
Posts: 5971
|
| Posted: 01/28/2005, 4:51 PM |
|
Let me just point that similar example was included in the recently released CCS Example Pack 2.
The online version is at http://examples.codecharge.com/CCSExamplePack2/Retrievi...ieldsValues.php
Possibly it works little differently since it retrieves all related textbox values from the database, while I don't know where you were getting your values.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
 |
aakici
Posts: 49
|
| Posted: 01/30/2005, 2:10 PM |
|
I don't see any difference between my and your solution. But, your code solved my another problem. Thanks peterr.
_________________
Regards,
M.Alpaslan AKICI |
 |
 |
|