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?  
limhodavAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kriyengCommented:
first of all put the same name to the three date input fields.

edit your insert/update record using dreamweaver tool to pass ms access date to post form.

now, locate this lines in your dreamweaver code: (look over line number 90, depending your code could change) and add the lines between 'MY ADDED CODE and 'FINISH ADDED CODE like below

(...)
    If (MM_formVal = "") Then
      MM_formVal = MM_emptyVal
    Else
      If (MM_altVal <> "") Then
        MM_formVal = MM_altVal
      ElseIf (MM_delim = "'") Then  ' escape quotes
        MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'"
      Else
        
      'MY ADDED CODE
      if MM_delim= "#" Then
            
                                MM_formVal=replace(MM_formVal,",","/")

            Dim strDay
            Dim strMonth
            Dim strYear
      
            strDay=day(MM_formVal)
            strMonth=month(MM_formVal)
            strYear=year(MM_formVal)
            
            MM_formVal= strYear & "/" & strMonth & "/" & strDay
            
      end if
      'FINISH ADDED CODE
             
        MM_formVal = MM_delim + MM_formVal + MM_delim
      End If
(...)

This code I usually use to make dates universal with no country problems to save in access database. I added a replace function MM_formVal=replace(MM_formVal,",","/")   to solve your problem. I've not tested. try it.

good luck

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John_LennonCommented:
i think you have to add this line
MM_formVal=replace(MM_formVal," ","")
before
MM_formVal=replace(MM_formVal,",","/")
because values will come like '3, 4, 2006'

MM_formVal=replace(MM_formVal," ","")
MM_formVal=replace(MM_formVal,",","/")
MM_formVal=trim(MM_formVal) 'just it case
kriyengCommented:
yes, change to that (add space after the coma)

MM_formVal=replace(MM_formVal,",","/")
to
MM_formVal=replace(MM_formVal,", ","/")

like this ", "

bye
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.