On Mon, 7 Mar 2005 14:54:10 -0500, Qasim Rasheed <[EMAIL PROTECTED]> wrote:
> You can use something like this as Dave as already pointed out
>
> select *
> from user_tables
> where upper(table_name) = 'devicestate'
>
The only reason I'd advise against that (besides the fact that it
should be LOWER()) is because Oracle will not use the index on that
column if you use a Oracle function. In a small schema, it's probably
not a big deal, but I'd err on the side of ColdFusion and put a
UCase() around the table name being passed in so that Oracle properly
uses any defined indexes:
SELECT *
FROM user_tables
WHERE table_name = '#UCase("devicestate")#'
Of course, I'd also suggest using cfqueryparam, but I didn't want to
muddy the example above with extra CF stuff.
Regards,
Dave.
Regards,
Dave.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197743
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
