CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ColdFusion

 How to remove N from like N'% statements generated by contains in table parameter dialogue in Visual Query builder

Print topic Send  topic

Author Message
seanwelsh77

Posts: 2
Posted: 12/18/2007, 4:57 PM

Hi,

I have a CodeCharge search form that does a query which populates a grid.

Our platform is ColdFusion 8 / MSSQL 2005.

What I am curious to understand is the behaviour of the 'contains' dropdown in the Table Parameter dialogue accessed from Visual Query Builder. Looking at the generated code it puts an N before the like string.

E.g. where x like N'%search_string%'

instead of plain

where x like '%search_string%'

The table has 1.6 million records and treating the search string as a Unicode takes 10 s whereas leaving the N out takes < 1s.

The datatype of the column being searched is a varchar(11) of collation SQL_Latin1_General_CP1_CI_AS (the database default).

Does anyone know of a way to kill the N generated by CodeCharge?

Regards,

Sean

View profile  Send private message
seanwelsh77

Posts: 2
Posted: 12/18/2007, 9:11 PM

Hi,

I was able to solve my own problem.

In essence I deleted the where clause in Visual Query Builder and followed the instructions in the Code Charge help doc "Dynamically Modify the WHERE Clause"

You add an event to the grid (Before Build Select) and write the like statement without the Unicode alteration.

Thanks,

Sean

View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.