EasyCFM.COM ColdFusion Forums / MS Access Related Issues / generating an order or confirmation number

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: generating an order or confirmation number -- page: 1 2

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

jimo
08-16-2007 @ 1:13 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 8
Joined: Jul 2006

Well I spoke too soon,

After more testing the confirmation number does display in the action page. It does not display in the database
I created conf_number field in the database made it a date/time field and set the default value to Now()

on the action page i have <cfset conf_number = "#dateformat(now(),'yymmdd')##timeformat(now(), 'hhmmss')#">  does this keep the date from displaying in the database?

If i remove it the conf_number is not defined message displays. Sorry to be a pest. thnks

PAGE: 1 2

Website Designed and Developed by Pablo Varando.