What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: Date fun with MySQL

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58462
interpreted = N
texte = Hi guys, No one working with MySQL and WebDNA? I can't ask that question no where else, since no one knnows WebDNA .......... Nitai > From: "Nitai @ ComputerOil" > Reply-To: WebDNA Talk > Date: Wed, 16 Jun 2004 21:05:30 +0200 > To: WebDNA Talk > Subject: Date fun with MySQL >=20 > Hi all, >=20 > Running a test system here with the native MySQL support of WebDNA and go= t a > question about how dates should be stored. >=20 > The best practice so far for WebDNA solutions were to store dates a numbe= rs > like [math]{[date]}[/math]. >=20 > Should we do the same with MySQL db's and could other systems read that? >=20 > We have some fields in our tables that have the fieldtype "date" and of > course MySQL stores them as year-month-date. Returning those fields gives= me > the correct values, but trying to convert those date fields into European > format does not work. Also using the [field > seek=3Dnamed:mydate&get=3Dvalue&raw=3DT] returns me the date as set in the WebD= NA > preferences. >=20 > Appreciate any advices. >=20 > Nitai >=20 > --=20 > Tools to energize your business > Web Content Management =ABRedakto=BB & eBusiness Systems >=20 > ComputerOil=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 >=20 > info@computeroil.com > http://computeroil.com >=20 >=20 >=20 >=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)
Hi guys, No one working with MySQL and WebDNA? I can't ask that question no where else, since no one knnows WebDNA .......... Nitai > From: "Nitai @ ComputerOil" > Reply-To: WebDNA Talk > Date: Wed, 16 Jun 2004 21:05:30 +0200 > To: WebDNA Talk > Subject: Date fun with MySQL >=20 > Hi all, >=20 > Running a test system here with the native MySQL support of WebDNA and go= t a > question about how dates should be stored. >=20 > The best practice so far for WebDNA solutions were to store dates a numbe= rs > like [math]{[date]}[/math]. >=20 > Should we do the same with MySQL db's and could other systems read that? >=20 > We have some fields in our tables that have the fieldtype "date" and of > course MySQL stores them as year-month-date. Returning those fields gives= me > the correct values, but trying to convert those date fields into European > format does not work. Also using the [field > seek=3Dnamed:mydate&get=3Dvalue&raw=3DT] returns me the date as set in the WebD= NA > preferences. >=20 > Appreciate any advices. >=20 > Nitai >=20 > --=20 > Tools to energize your business > Web Content Management =ABRedakto=BB & eBusiness Systems >=20 > ComputerOil=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 >=20 > info@computeroil.com > http://computeroil.com >=20 >=20 >=20 >=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:

lookup command (1999) Emailer port change (1997) can WC render sites out? (1997) select multiple 2 more cents (1997) [addlineitems] (1997) Problem with version 4 browsers (1998) WebCatalog Technical Reference (1997) NT vs Mac (1997) WebCat website for developers and hosters (2001) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) Speed Optimization - Mac (1997) Internet Explorer 6 Form problems (2005) [ShowNext] feature in 2.0 (1997) Is there an alternative to emailer? (1999) RE: [taxRate] [TaxTotal] ? (1997) Emailer setup (1997) CORR: date format (2000) changing prices in cart (1997) Cart Number sequence (1997) Problem with updating 2.1b7 -> 2.1.1 (1998)