automatic fill-in

[sirTemplar]

hi again.

let's say i have a database with this fields:

name
surname
country code
country_english
country_italian
country_german

and i have a form that inputs only the first three, i.e.

name
surname
country code

is it possible that when the country code is filled. the rest:
country_english
country_italian
country_german

will be filled in automatically? what is the easiest way? the reason for doing this is to not to type manually the country in other languages by those who fill in the form!

[sfullman]

If you know what the value will normally be, you may set it when you create the table,

Create Table SomeName (

country_english char(30) not null default='English'
..
..

)

Or, you can put a hidden field in the form:

<input type="hidden" name="country_english" value="English">

and that will do it.

Just to make it clear, if you don't specifically mention the field when you do the update, then the default will be assigned. If you specify fieldName = '' then the value will be blank instead.

Sam