Hah. Go go database designer. I cannot use the contains clause on the DB I had intended to use it on, because the tables I would have liked to do it to are not full-text-indexed. Being that it's not mine to maintain, I'm not too keen on enabling it, in the event that they do something later to break it. Nothing quite like interacting with other people's systems. Well, I guess that's yet another reason to duplicate the data necessary into my own structures (which I'm doing anyway, but into a postgresql database at the moment).
From the look of it, however, the contains clause will do what I want, just not in a database-agnostic fashion i was trying to keep close to. Thanks, -Joe On Feb 9, 2008, at 12:42 PM, Sharon Rosner wrote: > >> Wow, that would solve one of my current problems on a multitude of >> levels, especially if this were supported with the odbc_mssql driver >> as well. I have no idea if mssql even supports the feature though, >> and especially not if it's something available in mssql2000. > > As of now the odbc_mssql adapter supports full text search using the > CONTAINS clause. Please give it a try and let me know if it works > properly. > > best > sharon > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
