Click here to Skip to main content
15,929,025 members
Home / Discussions / C#
   

C#

 
GeneralRe: Conventions.... Pin
23-Jun-02 9:35
suss23-Jun-02 9:35 
GeneralRe: Conventions.... Pin
leppie23-Jun-02 20:55
leppie23-Jun-02 20:55 
GeneralListView help... Pin
Vu Truong23-Jun-02 1:24
Vu Truong23-Jun-02 1:24 
GeneralRe: ListView help... Pin
23-Jun-02 9:37
suss23-Jun-02 9:37 
GeneralCrazy Form.... Pin
22-Jun-02 15:04
suss22-Jun-02 15:04 
GeneralGDI... I think Pin
22-Jun-02 10:13
suss22-Jun-02 10:13 
GeneralRe: GDI... I think Pin
23-Jun-02 9:04
suss23-Jun-02 9:04 
GeneralDodgy Access Database Pin
leppie22-Jun-02 5:29
leppie22-Jun-02 5:29 
Hi, perhaps someone can help me...

I run a query like this:
string str = "SELECT LOG.Type, LOG.Time, LOG.Nick, LOG.Message FROM LOG WHERE (((LOG.Type) Like 'SAY') OR ((LOG.Type) Like 'ACTION') ) AND ((LOG.Message) Like '*text*') ORDER BY LOG.Time DESC";
OleDbDataAdapter sda = new OleDbDataAdapter(str, accessConn);
sda.Fill(dt);
DataRow[] rows = dt.Select(); 


For simplicity, str equals the string i copied from a stringbuilder object while debugging. The Message field is of memo type. dt is a DataTable object.

Now the problems is, rows.Length = 0 after last statement, while sending the exact query via Access produces the correct results.

After some more debugging, it seems the problem is with the wildcards at Message Like '*text*'. Changing the query to Message Like 'text' produces the correct results.

Can anyone try this or help Cry | :((
GeneralRe: Dodgy Access Database Pin
leppie22-Jun-02 10:22
leppie22-Jun-02 10:22 
Questionhow to convert byte[] to String that code in unicode Pin
ygxdha22-Jun-02 3:52
ygxdha22-Jun-02 3:52 
AnswerRe: how to convert byte[] to String that code in unicode Pin
leppie22-Jun-02 4:48
leppie22-Jun-02 4:48 
GeneralPointers - DLL Pin
22-Jun-02 3:08
suss22-Jun-02 3:08 
GeneralRe: Pointers - DLL Pin
leppie22-Jun-02 4:53
leppie22-Jun-02 4:53 
GeneralUnfortunaly Pin
koenig23-Jun-02 8:00
koenig23-Jun-02 8:00 
GeneralRe: Unfortunaly Pin
leppie23-Jun-02 20:49
leppie23-Jun-02 20:49 
GeneralYou were right Pin
koenig24-Jun-02 5:43
koenig24-Jun-02 5:43 
GeneralRe: Pointers - DLL Pin
Chris Rickard24-Jun-02 5:17
Chris Rickard24-Jun-02 5:17 
GeneralRe: Pointers - DLL Pin
koenig24-Jun-02 5:47
koenig24-Jun-02 5:47 
GeneralMoving a form Pin
22-Jun-02 1:05
suss22-Jun-02 1:05 
GeneralRe: Moving a form Pin
Nish Nishant22-Jun-02 1:11
sitebuilderNish Nishant22-Jun-02 1:11 
GeneralRe: Moving a form Pin
22-Jun-02 10:10
suss22-Jun-02 10:10 
GeneralRe: Moving a form Pin
Mazdak22-Jun-02 3:44
Mazdak22-Jun-02 3:44 
GeneralAutoComplete -- DropDowns Pin
mvermef21-Jun-02 13:55
mvermef21-Jun-02 13:55 
GeneralRe: AutoComplete -- DropDowns Pin
Chris Rickard21-Jun-02 14:29
Chris Rickard21-Jun-02 14:29 
GeneralRe: AutoComplete -- DropDowns Pin
Nish Nishant21-Jun-02 15:08
sitebuilderNish Nishant21-Jun-02 15:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.