Microsoft Access is terrible.
I recommend switching to *any* other database engine.
You should then be able to use the COLLATE SQL command to enforce
case-sensitivity on a column.
~|
Want to reach the ColdFusion community wit
the COMPARE function should do the trick for you.
http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt138.htm
http://www.scandicweb.com/coldfusion/tutorials/tutorial90.cfm
~|
Want to reach the ColdFusion communit
>>Microsoft Access is terrible.
Well, yet another legendary Access database bashing :-(
Access database are GREAT for any small/medium web application.
Most databases implement the string comparison to be case insensitive by
default.
They also have provisions to change it either globally or lo
>>the COMPARE function should do the trick for you.
The COMPARE function is a CF function. What is needed here is an SQL
function.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
Claude Schneegans wrote:
> >>Microsoft Access is terrible.
>
> Well, yet another legendary Access database bashing :-(
> Access database are GREAT for any small/medium web application.
>
> Most databases implement the string comparison to be case insensitive by
> default.
> They also have prov
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 di
--
From: "Peter Boughton"
Sent: Monday, June 15, 2009 11:02 AM
To: "cf-talk"
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
&
What are the data types of the columns you're trying to GROUP BY? I'm sure
it will barf on a memo field, for instance.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
>>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.
Legend, pure urban legend !
Access applications have a bad reputation, but do not forget that
accessing an
On Mon, Jun 15, 2009 at 7:33 AM, Claude
Schneegans wrote:
>
> >>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.
>
> Legend, pure urban legend !
Ok.. So you d
AND city = #form.city#
ORDER BY region
now if I add 'GROUP BY clust' then it gives an error.
The cluster field is Integer.
Regards,
Arsalan
------
From: "Phillip Vector"
Sent: Monday, June 15, 2009 8:40 PM
To:
>>There is very few reasons why you would want a Web App with Access.
None of them that I can think of would be useful in a web app that is
worked on by 2 or more people (which most web apps are).
1. Access is not sensitive to SQL injection.
2. Only one file for the whole database, the whole dat
>>now if I add 'GROUP BY clust' then it gives an error.
Where do yo add the GROUP BY clause ?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
htt
15, 2009 9:10 PM
To: "cf-talk"
Subject: Re: Case Sensitive SQL
>
> >>now if I add 'GROUP BY clust' then it gives an error.
>
> Where do yo add the GROUP BY clause ?
>
>
~|
Want to r
>>now if I add 'GROUP BY clust' then it gives an error.
In a GROUP BY clause, you must enumerate all fields in your SELECT
See :
http://msdn.microsoft.com/en-us/library/aa259187(SQL.80).aspx#_group_by_clause
~|
Want to reach
On Mon, Jun 15, 2009 at 4:56 PM, Arsalan Tariq Keen wrote:
>
> SELECT id, site, far_end, site_type, phase, lat, long, cluster AS
> clust, city, region, sites_status
> FROM sites
> ORDER BY region
>
>
>
> now if I add 'GROUP BY clust' then it gives an error.
Don't forget th
ter = #form.cluster#
form.phase IS NOT '0'>AND phase = #form.phase#
form.city IS NOT '0'>AND city = #form.city#
ORDER BY region
----
From: "Jochem van Dieten"
Sent: Monday, June 15, 2009 12:15 PM
To: "cf-ta
t's basically a Telecom data management project :)) (That is why it has to
be so mismanaged ;)... lolz!)
--
From: "Jason Fisher"
Sent: Monday, June 15, 2009 11:08 PM
To: "cf-talk"
Subject: Re: Case Sensitive SQL
>
> Righ
Okay, that makes sense, but I'm thinking that you won't be able to do the
grouping at the SQL level in that case.
As Jochem noted, GROUP BY can only put records together where all the
grouped fields match, and the assumption is that all other columns are
summarized or otherwise aggregated. In
>>ID and SITE will always have unique values no duplicates allowed.
Ok, but you still have to list all columns in your SELECT list, it is a
matter of SQL syntax, not logic.
In pure logic, a "GROUP" clause should be enough, since one has no choice,
but this is the way SQL has been designed.
Lol you said MS Access and GREAT in the same sentence.
.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Claude Schneegans [mailto:schneeg...@internetique.com]
Sent: Saturday, June 13, 2009 1:15 PM
To: cf-talk
Subject: Re: Case
Try using the function compare() maybe?
there may be more to it.
Shawn Regan
Applications Developer
Pacific Technology Solutions
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:00 PM
To: CF-Talk
Subject: case sensitive sql query
I
Try
SELECT ColumnName
FROM tableName
WHERE upper(ColumnName) = #ucase(theText)#
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:00 PM
To: CF-Talk
Subject: case sensitive sql query
Is there a way to do a case sensitive SELECT que
ROTECTED]
ColdFusion Developer
- Original Message -
From: "Nilufer Basagaoglu" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 4:44 PM
Subject: RE: case sensitive sql query
>
> Try
>
>
>
> SELECT ColumnName
&
This depends on the database you use.
Oracle's result would be only 'Test Query' not 'TesT Query'.
What is your database?
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 2:54 PM
To: CF-Talk
Subject: Re: case s
Use compare()
Shawn Regan
Applications Developer
Pacific Technology Solutions
-Original Message-
From: Nilufer Basagaoglu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 3:08 PM
To: CF-Talk
Subject: RE: case sensitive sql query
This depends on the database you use
...
I'd guess the overhead would be heavy
Orlando
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 3:54 PM
To: CF-Talk
Subject: Re: case sensitive sql query
That doesn't solve anything at all, what I am wanting to do is get a m
e the statement at the end
-Original Message-
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 4:50 PM
To: CF-Talk
Subject: RE: case sensitive sql query
If the database has been set up to do case-sensitive searching only you may
have to get into some
2001 5:54 PM
To: CF-Talk
Subject: Re: case sensitive sql query
That doesn't solve anything at all, what I am wanting to do is get a match
where ColumnName is 'Test Query' and NOT 'TesT Query'. Your solution would
pull both of those from the db, doesn't solve the case se
SQL SELECT queries ARE case sensitive.
The problem is in your data -- you're using columnames
from your tables as data. Depending on the database,
this information is stored in auxiliary tables (in
Oracle, it would be in a table like
"all_tab_columns"), and may be in a case-insensitive
form. For
TED]
www.doceus.com
-Original Message-
From: cf refactoring [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 9:11 AM
To: CF-Talk
Subject: Re: case sensitive sql query
SQL SELECT queries ARE case sensitive.
The problem is in your data -- you're using columnames
from your tables
and
> pass in the value you are searching on. CAST is
> preferred over CONVERT.
>
> Alex Santantonio,
> Lead Developer
> Macromedia Coldfusion 5 Certified Professional
> Macromedia Certified Web Site Developer
> [EMAIL PROTECTED]
> www.doceus.com
>
> -----Ori
fied Web Site Developer
[EMAIL PROTECTED]
www.doceus.com
-Original Message-
From: cf refactoring [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 9:11 AM
To: CF-Talk
Subject: Re: case sensitive sql query
SQL SELECT queries ARE case sensitive.
The problem is in your data -- you'
Yes.
convert(varbinary, 'a') = convert(varbinary, 'A')
- Original Message -
From: Duane Boudreau <[EMAIL PROTECTED]>
Date: Friday, January 10, 2003 1:10 pm
Subject: Case Sensitive SQL JOIN
> Hi All,
>
> Using SQLServer2k, is there a way to do a case sensitive join? *my
> SQLServer2k ser
There's several ways to do this. A decent starting point is here:
http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm
Basically, the options are:
play with collation order and collation functions/clauses (or change the
collation of the database)
use binary comparisons which *are* ca
35 matches
Mail list logo
