Replies Back to Article

Using Dreamweaver MX with ASP and mySQL

Er....what??

May 30, 2004 by jim holmes

I didn't actually understand any of that

RE: Er....what??

May 30, 2004 by Kerry Garrison

When you are using ASP pages with Access or SQL, you can use the data format of mm/dd/yyyy, however, with mySQL, the data format that you need to pass to the database is in yyyy-mm-dd.

Ah!

May 30, 2004 by jim holmes

I see! Thnx kerry. Have you written any tutorials on creating a 'cart' system using asp and mySQL?

cheers,

Jim

RE: Ah!

May 30, 2004 by Kerry Garrison

No. I typically use osCommerce for shopping cart systems. Its Open Source and quite powerful, although it is in PHP instead of ASP.

WHAT ABOUT THIS...

August 24, 2006 by Doc BEATs

i have a email system i made in my database where it stores userID, fromID, subject,message, datecreated, viewable, fromviewable, status. the datecreated default is set to CURRENT_TIMESTAMP. now when i insert a record is stores the date and time created, now i've found that when i update the record it changes the datecreated to the current date time updated.. i dont want that.. in access never had to worry about that.. what is the fix around this? can i create a hidden text field set value to CURRENT_TIMESTAMP and include in insert when creating a email?

THANKS

hiddenfield

January 15, 2007 by Kenny Darcy

I found having this on my page in a hidden field will do the trick too, ok its not as great as doing it server side but it works and was easier for me to understand. it would be great if some one created an extension specific for dates and mysql. dwfaq.com have a date extension but it will not formate it suitable for mysql databases.

any way this worked for me in the hidden field

kenny