limhodav
asked on
Submit date in 3 combo boxes into database without passing control to another asp page?
I have a question.
I know how to allow users to enter date using 3 combo boxes (dd, mm,yy) and then passing it thro another asp page to be processed into the database.
The only problem is that I have other details to process too. I use the Dreamweaver built in Insert Record behaviour whose action is <%=MM_editAction%> and it's actually processed in the same page and not to another page.
So how can I combine the fields from the combo boxes and insert into the database without passing conttrol to another asp page. My field in database is dd/mm/yyyy.
or is there a better alternative?
I know how to allow users to enter date using 3 combo boxes (dd, mm,yy) and then passing it thro another asp page to be processed into the database.
The only problem is that I have other details to process too. I use the Dreamweaver built in Insert Record behaviour whose action is <%=MM_editAction%> and it's actually processed in the same page and not to another page.
So how can I combine the fields from the combo boxes and insert into the database without passing conttrol to another asp page. My field in database is dd/mm/yyyy.
or is there a better alternative?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yes, change to that (add space after the coma)
MM_formVal=replace(MM_form Val,",","/ ")
to
MM_formVal=replace(MM_form Val,", ","/")
like this ", "
bye
MM_formVal=replace(MM_form
to
MM_formVal=replace(MM_form
like this ", "
bye
MM_formVal=replace(MM_form
before
MM_formVal=replace(MM_form
because values will come like '3, 4, 2006'
MM_formVal=replace(MM_form
MM_formVal=replace(MM_form
MM_formVal=trim(MM_formVal