alpha55
Posts: 14
|
| Posted: 05/21/2008, 5:57 AM |
|
when i insert values into database using normal input fields it inserts the value but when i use a list box to select a value it does not write any value to the database any help around ?
|
 |
 |
TheunisP
Posts: 342
|
| Posted: 05/21/2008, 6:12 AM |
|
do you have a bound column selected? check your resulting page's source the option tags should have a value="" in it
|
|
|
|
alpha55
Posts: 14
|
| Posted: 05/21/2008, 6:29 AM |
|
i don't have a bound column selected; the fact is i've put 2 values in drop down for the user to select from the code is as under
<select id="productsUOM" name="{UOM}">
<option value="NOS" selected>NOS</option>
<option value="METER">METER</option>
{UOM_Options}
</select>
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 05/21/2008, 8:58 AM |
|
normal practice would be:
your record form has (besides all the datafields that are inserted correctly) a field blabla of type integer.
your listbox would then have 1- NOS 2-METER
user picks METER from the listbox 2 gets entered in your datafield blabla and insert would work.
So, what field in the record is it?
What value do you expect?
What is the listbox's dataset?
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
alpha55
Posts: 14
|
| Posted: 05/21/2008, 9:31 AM |
|
i expect only a text value and the data type is text
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 05/21/2008, 10:34 AM |
|
Then your listbox should have
NOS-NOS
METER-METER
as key, value pair
the value is what is shown the key is what is entered
in the record form click the blabla field, then in its properties click the datasource to enter the listdata.
walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
alpha55
Posts: 14
|
| Posted: 05/21/2008, 11:34 AM |
|
this is the error that i'm getting when i make it as required input
"The value in field UOM is required."
|
|
|
|
alpha55
Posts: 14
|
| Posted: 05/21/2008, 11:44 AM |
|
the thing that i've figured out is that the drop down is actually not holding any value i've created the drop down using select properties of the dropdown menu and added name and values there.
correct me if i'm wrong
|
|
|
|
wkempees
|
| Posted: 05/21/2008, 12:33 PM |
|
I would do the following:
In Design Open your RecordForm.
The field, currently set as Listbox, rightclick it, and select ''change to"
set it to Textbox.
This will delete the Listbox.
Regenerate and publish, test the form, to make sure it is storing whatever
you type in that field.
If that works, and I have no reason to think it won't, go back in to Design.
Rightclick the field again, and select "change to"Listbox".
Then reselect the Listbox, and make sure the properties (right lower pane)
is showing Listbox xxx properties.
Now set all properties correct and press Datasource to enter the
ListOfValues.
Regenerate and publish, test the form, to make sure it is storing whatever
you type in that field.
This should be as easy as saying tataaa.
Walter
"alpha55" <alpha55@forum.codecharge> schreef in bericht
news:248346d8d2c1a2@news.codecharge.com...
> the thing that i've figured out is that the drop down is actually not
> holding
> any value i've created the drop down using select properties of the
> dropdown
> menu and added name and values there.
>
> correct me if i'm wrong
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
