Home arrow MySQL arrow Page 4 - Two Lessons in ASP and MySQL
MYSQL

Two Lessons in ASP and MySQL


ASP and MySQL are designed and distributed with completely different rationale, not to mention by two very different companies. But there is a good chance that you may want these two technologies for your dynamic application, in which case you need them to 'talk' to each other. One major obstacle to this could be that they differ in their handling of dates and times. This article will show you two functions you can implement to allow them to communicate peacefully, without trying to re-configure date/time formatting in either.

Author Info:
By: Justin Cook
Rating: 4 stars4 stars4 stars4 stars4 stars / 77
May 10, 2004
TABLE OF CONTENTS:
  1. · Two Lessons in ASP and MySQL
  2. · It's a Date!
  3. · ¿Que Horas Son?
  4. · Conclusion

print this article
SEARCH DEVARTICLES

Two Lessons in ASP and MySQL - Conclusion
(Page 4 of 4 )

Anyhow, those are the two lessons I've learned. If at any time I need to work with a full datetime string, I just call both functions, and stitch the two resulting strings together with a space in between. I've found the time function especially helpful in cleaning up user input.
Here is all the code if you want it:

'====================
function mysqlDate( d, dir )
'====================
 'if not isDate( d ) then call errorMessage( d & " is not a date " )
 'if not isDate( d ) then exit function
 if not isDate( d ) then d = Date()
 
 dim strNewDate
 select case dir

  case 1 '=== store in db
  strNewDate = year( d ) & "-" & month( d ) & "-" & day( d )
  
  case 2 '=== use with asp
   strNewDate = month( d )& "/"  & day( d ) & "/" & year( d )
 end select

 strNewDate = cDate( strNewDate )
 mysqlDate = strNewDate
end function


'====================
function mysqlTime( t, dir )
'====================
 
 dim strSuffix, arTime, i, x
 
 t = trim( Lcase( t ) )
 if inStr( t, "pm" ) > 0 OR inStr( t, "am" ) > 0 then
  strSuffix = right( t, 2 )
  t = left( t, inStr( t, strSuffix ) -2 )
  t = trim( t )
 end if 

 for i = 1 to len( t )
  x = mid( t, i, 1 )
  if not isReallyNumeric( x ) and x <> ":" then t = replace( t, x, "" )
 next
 
 arTime = split( t, ":" )
 t = ""
 for i = 0 to 2
  if uBound( arTime ) < i then redim preserve arTime( i )
  
  if i = 0 then
   if dir = 1 then
    if strSuffix = "pm" and cInt( arTime( i ) ) < 12 then
     arTime( i ) = cInt( arTime( i ) ) + 12
    end if
   else
    if cInt( arTime( i ) ) > 12 then
     arTime( i ) = cInt( arTime( i ) ) - 12
     strSuffix   = "PM"
     else
      strSuffix   = "AM"
    end if
   end if
  end if
  
  do until len( arTime( i ) ) = 2
   arTime( i ) = "0" & arTime( i )
  loop
  
  t = t & arTime( i )
  if i < 2 then t = t & ":"
 next
 arTime = null
 if dir = 2 then t = t & " " & strSuffix
 'debug( t )
 mysqlTime = t
end function


DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

blog comments powered by Disqus
MYSQL ARTICLES

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 – More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials