Go Back   SitePoint Forums > Forum Index > Program Your Site > .NET
Newsletter FAQ Members List Calendar Mark Forums Read

New to SitePoint Forums? Register here for free!

SitePoint Sponsor
 
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old Jul 11, 2005, 22:09   #1
ahooi
SitePoint Member
 
Join Date: Jul 2005
Posts: 7
Exclamation [important] rowfilter in visual studio.net V1.1

Hi,
can anyone please try to filter the following data using rowfilter and see whether it works or not.
Note: Have to escape [ and ].So, [ is written as [[] and ] is written as []]. All the data is stored as NVARCHAR not VARCHAR.

i'm using visual basic.net V1.1.

When the data are stored as unicode, the rowfilter works properly. However, when tehd ata are stored
as NVARCHAR, the rowfilter is not working properly. Is is it because the data are stored as
NVARCHAR that makes rowfilter doesn't works properly?

Three records in the database are:
1# [1222 -2201 ภาษาไทยเพื่อการสื่อสาร]
3# [1212 - 2200 วิทยาศาสตร์พื้นฐาน ]
12# [1122 - 3201 วิถีธรรมวิถีไทย ]

Let say i want to get the third record with one of the string below, i can get the desired data.
'%12%'
'%12#%'
'%[[]%'
'%[]]%'
'%[[]1122%'
'%[[]1122 - 3201 วิถีธรรมวิถีไทย []]%'
'%#%'
'%-%'
'%วิถีธรรมว%'


However, i can't get the third record if i use one of thestring below.
'%# %' (a space after #)
'%# [[]%'
'%12# [[]%'
'%12# %' (a space after #)
'%# [[]1122%'
'%12# [[]1122 - 3201 วิถีธรรมวิถีไทย []]%'

Can you help me?
ahooi is offline   Reply With Quote
 

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Display Modes

 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Sponsored Links
 
Forum Jump


All times are GMT -7. The time now is 23:36.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Copyright 1998-2009, SitePoint Pty Ltd. All Rights Reserved