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.xhas a option to format the date field even we get the date value with [fiel=dseek=3Dnamed:mydate&get=3Dvalue&raw=3DT] out of the MySQL DB.Or, Scott?Nitai--=20Tools to energize your businessWeb Content Management =ABRedakto=BB & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://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:
Yes, that is an option I might have to go. It does not seem that WebDNA 6.xhas a option to format the date field even we get the date value with [fiel=dseek=3Dnamed:mydate&get=3Dvalue&raw=3DT] out of the MySQL DB.Or, Scott?Nitai--=20Tools to energize your businessWeb Content Management =ABRedakto=BB & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://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)