Can't get WHERE-syntax in place

[Morten Snedker]

This is from my Query Analyzer:

select * from tblDokument
where CONTAINS(Content,'"*this-text*" and "*that-t*"')

I can't seem to get the quotation right in my rs.Open:

rs.Open("SELECT * FROM tblDokument WHERE CONTAINS(Content, ??, cn)


Thx in advance for your help!

Regards /Snedker

 

[Frans Bouma [C# MVP]]

This is from my Query Analyzer:

select * from tblDokument
where CONTAINS(Content,'"*this-text*" and "*that-t*"')

I can't seem to get the quotation right in my rs.Open:

rs.Open("SELECT * FROM tblDokument WHERE CONTAINS(Content, ??, cn)

VB.NET:
rs.Open("SELECT * FROM tblDokument WHERE CONTAINS(Content,
"""*this-text*"" and ""*that-t*""", cn)

C#:
rs.Open("SELECT * FROM tblDokument WHERE CONTAINS(Content,
"\"*this-text*\" and \"*that-t*\"", cn);

Though, I expect this is ado stuff, i.e.: vb6?

FB

--

 

[Morten Snedker]

On Tue, 01 Mar 2005 14:46:08 +0100, "Frans Bouma [C# MVP]"


First of all, thanks for your time and input.

Though, you guessed wrong - I am using VB.NET. But since you're
assuming VB6, I'm guessing that I'm doing something that's not
optimal...or not the proper .Net-way?

Regards /Snedker

 

[Cor Ligthert]

Morten,

You are using code from ADODB that will work in C# and VBNet and other net
program languages as well. .

However, as you see is this newsgroup ADONET the data part of dotNet

This is in the so named system.data namespace.

See on this page bellow to get the general information from it.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemData.asp

I hope this helps?

Cor

 

[Sahil Malik]

You had "rs.Open", that looks very much like RecordSet.Open. That's ADo.
2.x, vb6ish - but hey nothing stops you from interoping that into VB.NET -
but most certainly you should try using ADO.NET instead.

But we're playing detectives here by judging that you are using ADO 2.x
based on "rs.Open"

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

On Tue, 01 Mar 2005 14:46:08 +0100, "Frans Bouma [C# MVP]"


First of all, thanks for your time and input.

Though, you guessed wrong - I am using VB.NET. But since you're
assuming VB6, I'm guessing that I'm doing something that's not
optimal...or not the proper .Net-way?

Regards /Snedker

VB.NET:
rs.Open("SELECT * FROM tblDokument WHERE CONTAINS(Content,
"""*this-text*"" and ""*that-t*""", cn)

C#:
rs.Open("SELECT * FROM tblDokument WHERE CONTAINS(Content,
"\"*this-text*\" and \"*that-t*\"", cn);

Though, I expect this is ado stuff, i.e.: vb6?

FB