Thanks Peter, Roger, Claude and Shane :) well I am using encryption and I do agree MS Access is only good for small personal works and not for medium or large scale applications.
Besides, I have another small query, when I use the GROUP BY clause with MS Access it gives the error something like 'object overflow'. The query works fine without the GROUP BY clause. It's a simple select query having a where clause followed by an ORDER BY clause but when I add the GROUP BY clause it gives the object overflow error. Even when I write this SQL in MS Access itself, it gives the same error. Does any1 has any idea... is there a problem with my SQL skills or do I just need to change my database ;) If any1 could provide his workable SELECT QUERY with WHERE, ORDER and GROUP BY clause... that would be superb :)) Regards, Arsalan -------------------------------------------------- From: "Peter Boughton" <[email protected]> Sent: Monday, June 15, 2009 11:02 AM To: "cf-talk" <[email protected]> Subject: Re: Case Sensitive SQL > > Probably a little over-the-top, but the point still stands. > > MS Access is fine for basic office use, but for web apps you're better off > picking Derby, H2, MySQL, Postgres, etc - or one of the free 'Express' > editions of Oracle or MS SQL Server. > > > More importantly though, I just noticed this is discussing passwords, > which I missed the first time. > > If something is important enough to password protect, then that password > should - at the very least - be MD5 hashed, (if not a more secure salted > SHA hash, or similar). > If it's not important enough for that, just ditch the password altogether. > > And that aside, if the value is user input, use cfqueryparam! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
