Good deal. If you need more info, there are some really good code samples in the Irony source download at http://www.sourceforge.net/irony.

Thanks

Mike C

You declared it, but didn't instantiate it. Try something like this:

Dim _compiler As New Irony.Compile.LanguageCompiler

(I'm not 100% sure what the constructor...

webmaster 46469 (4/21/2011)

---

Thanks for the help Mike. I've been able to move forward with some testing. Was able to reference the irony dll.

One issue I'm having on build now is:

Object...

webmaster 46469 (4/19/2011)

---

Mike, first off good article. It opened my eyes to so many other possibilities and efficient ways to use the search features in my db. I have a...

Ahhh, you need to handle unbalanced parentheses. I believe Irony continues to try to parse your input string after an error is encountered. You may be able to leverage that...

Good deal, glad to hear it's working well for you! I'm working on another project incorporating the awesome Irony library now, planning to demo it in about a week or...

Here you go. It's not really a good solution, but it's not a particularly well-defined business problem either. And the tables used in the example are really lacking....

I think you just encountered my point. You haven't spelled out all your business rules yet. You just added another one to your list, but a solution that does what...

Very interesting. I hope you can share, I'd like to see how you handled operator precedence and all that.

Very interesting! Just wondering, but how many lines of code did you end up writing for that? Did you use recursion at all? Did you go with...

For portability across enviromments without using sql clr you might consider a middle-tier app, like a web service or something. If it absolutely has to be done in the database...

OK, so long as you don't care which is paired with which that should work well for you.

Hi bugmesh

Unfortunately I don't know of a simple or efficient way to do this in pure T-SQL. Essentially you want a T-SQL based parser and lexical analyzer. That functionality doesn't...

Look up and play with EncryptByPassPhrase first. Once you have that going, look into EncryptByKey. EncryptByPassPhrase doesn't have all the setup requirements that encryption by symmetric key has. And listen...

Just wondering, what leads you to believe the second result is the correct result?