Re: Date fun with MySQL

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58467
interpreted = N
texte = Yes, that is an option I might have to go. It does not seem that WebDNA 6.x has a option to format the date field even we get the date value with [fiel= d seek=3Dnamed:mydate&get=3Dvalue&raw=3DT] out of the MySQL DB. Or, Scott? Nitai --=20 Tools to energize your business Web Content Management =ABRedakto=BB & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > From: eLists > Reply-To: WebDNA Talk > Date: Thu, 17 Jun 2004 09:25:28 -0500 > To: WebDNA Talk > Subject: Re: Date fun with MySQL >=20 > I realize this might not be as efficient, but how about saving 2 fields, > one in native mysql format and one as number of days for webcat? >=20 > Then you could possibly use an include (or the 6.x functions?) to define > how you are searching/manipulating the date stuff so that if in the > future you need to change from one method to the other you could > hopefully only have to change your function or include. >=20 > Just an idea >=20 > Nitai @ ComputerOil wrote: >> Alain my man:-) >>=20 >> I figured that saving them in native format will keep the DB save for ot= her >> applications. >>=20 >> But what about if we need to show them in other formats. Each of my host= s >> want to have different date formats. No I am not using sandboxes :-) >>=20 >> Is there any way to achieve this, like the good old [format] tag with My= Sql >> date fields? >>=20 >> Nitai >=20 >>=20 >>> From: Alain Russell >>> Reply-To: WebDNA Talk >>> Date: Thu, 17 Jun 2004 21:28:15 +1200 >>> To: WebDNA Talk >>> Subject: Re: Date fun with MySQL >>>=20 >>> I'd save them in native MySQL Date format. >>>=20 >>> They will then be fast for searching and I'm guessing at a later date >>> SMSI will add a function to read/change dates from MySQL format to >>> WebDNA format as an option. >>>=20 >>> As well you will be able to access the database with other applications >>> (PHP) that will not need to many workarounds to read/write the date. >>>=20 >>> Alain >>>=20 >>> On 17/06/2004, at 5:53 PM, Nitai @ ComputerOil wrote: >>>=20 >>>=20 >>>> Hi guys, >>>>=20 >>>> No one working with MySQL and WebDNA? I can't ask that question no >>>> where >>>> else, since no one knnows WebDNA .......... >>>>=20 >>>> Nitai >=20 > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ >=20 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  2. Re: Date fun with MySQL ( Gary Krockover 2004)
  3. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  4. Re: Date fun with MySQL ( Gary Krockover 2004)
  5. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  6. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  7. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  8. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  9. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  10. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  11. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  12. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  13. Re: Date fun with MySQL ( eLists 2004)
  14. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  15. Re: Date fun with MySQL ( Alain Russell 2004)
  16. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  17. Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
Yes, that is an option I might have to go. It does not seem that WebDNA 6.x has a option to format the date field even we get the date value with [fiel= d seek=3Dnamed:mydate&get=3Dvalue&raw=3DT] out of the MySQL DB. Or, Scott? Nitai --=20 Tools to energize your business Web Content Management =ABRedakto=BB & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > From: eLists > Reply-To: WebDNA Talk > Date: Thu, 17 Jun 2004 09:25:28 -0500 > To: WebDNA Talk > Subject: Re: Date fun with MySQL >=20 > I realize this might not be as efficient, but how about saving 2 fields, > one in native mysql format and one as number of days for webcat? >=20 > Then you could possibly use an include (or the 6.x functions?) to define > how you are searching/manipulating the date stuff so that if in the > future you need to change from one method to the other you could > hopefully only have to change your function or include. >=20 > Just an idea >=20 > Nitai @ ComputerOil wrote: >> Alain my man:-) >>=20 >> I figured that saving them in native format will keep the DB save for ot= her >> applications. >>=20 >> But what about if we need to show them in other formats. Each of my host= s >> want to have different date formats. No I am not using sandboxes :-) >>=20 >> Is there any way to achieve this, like the good old [format] tag with My= Sql >> date fields? >>=20 >> Nitai >=20 >>=20 >>> From: Alain Russell >>> Reply-To: WebDNA Talk >>> Date: Thu, 17 Jun 2004 21:28:15 +1200 >>> To: WebDNA Talk >>> Subject: Re: Date fun with MySQL >>>=20 >>> I'd save them in native MySQL Date format. >>>=20 >>> They will then be fast for searching and I'm guessing at a later date >>> SMSI will add a function to read/change dates from MySQL format to >>> WebDNA format as an option. >>>=20 >>> As well you will be able to access the database with other applications >>> (PHP) that will not need to many workarounds to read/write the date. >>>=20 >>> Alain >>>=20 >>> On 17/06/2004, at 5:53 PM, Nitai @ ComputerOil wrote: >>>=20 >>>=20 >>>> Hi guys, >>>>=20 >>>> No one working with MySQL and WebDNA? I can't ask that question no >>>> where >>>> else, since no one knnows WebDNA .......... >>>>=20 >>>> Nitai >=20 > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ >=20 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Nitai @ ComputerOil"

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Email Set-Up? (1997) Webcat no longer supported? (2006) WebCat2 - storing unformatted date data? (1997) problems with 2 tags shakur (1997) Requiring that certain fields be completed (1997) cybercash on OSX - was Executing remote AppleScript (2000) Sorting Orders (1997) Pithy questions on webcommerce & siteedit (1997) When to use [convertchars] ?!?!? (2000) Number of Open Databases (1998) [WebDNA] testing (2012) Sorting LISTFILES (1997) WebCatalog Hosting (1996) NetForms for mail, sorry (1998) You *can!!* overwrite username/password using an HTML form. Also, experts *please* see Q at end (2000) Help name our technology! (1997) [WebDNA] A new popuated field to a DB with 700.000 records (2009) redirect from the errorsMessages.db entry (1997) Add to Cart & List of Products (1997) WebCat2b15MacPlugin - [protect] (1997)