home Links Articles Books Past Meetings Photos SiteMap
The MDCFUG is sponsored by TeraTech. Visit us at www.TeraTech.com

Please send
comments/questions to

michael@
teratech.com

 
Unexpected problems

Unexpected problems

  • False matches

    • SQL Case-sensitive vs CF case-insensitive
    • ColdFusion null same as empty string
      • (unless query uses COALESCE to give a value to nulls)
  • False differences

    • Extra rows on both sides (“ships passing in the night”)
    • Trailing blanks (do not count in SQL, do in CF)
  • Sort sequences differ

    • Across database products
    • Across database configurations of same product
    • ColdFusion has its own sort sequence
  • SQL query special characters hard to store

    • need URLEncodedFormat

Previous slide Next slide Back to first slide View graphic version


Home | Links | Articles | Past Meetings | Meeting Photos | Site Map
About MDCFUG | Join | Mailing List |Forums | Directions |Suggestions | Quotes | Newbie Tips
TOP

Copyright © 1997-2017, Maryland Cold Fusion User Group. All rights reserved.
< >