Thread: Search module
View Single Post
  #3 (permalink)  
Old August 6th, 2007, 10:48 AM
jimibt jimibt is offline
Friend of Wrox
 
Join Date: Mar 2007
Location: Creetown, UK
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

koen - not sure if you're still around. i 'saw' some of your code on another forum re searching but can't for the life of me find it. at present, i still use LIKE comparisons on my search sp's but am migrating over to full-text-indexing.

any chance you could drop off a copy of the stored procs that you used (and any other useful info). I've now started playing with the full-text-indexing malarkie but am unsure on the best way to implement the patterns. just thought i'd seen you add a few regex and NEAR expressions on your implementation, so didn't want to reinvent the wheel (again!!)

[edit] also, how did/do you overcome the 'user instance' caveat when running the application against a user instance of the sqlexpress database??
jimi

http://www.jamestollan.com