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-2024, Maryland Cold Fusion User Group. All rights reserved.
< >