On Mar 22, 12:35 am, dave lilley <[email protected]> wrote: > From you're given sample > * DB[:table].full_text_search([:column1, :column2], ['term1','term2'])* > > I have this as it's only 1 column I want to search on on this occasion. > > @db[:cust_data].full_text_search([:cust_name], ['mobil']).each{|t| puts t} > > from executing the above inside a method within my sequel script i don't see > any output! > the DB is MYSQL.. > > to prove that i have a valid connection i try a display get the server > version and that's the second line down so have an issue with the reference > to the error Can't connect to MYSQL server on localhost.
That doesn't prove you have a valid connection. Datasets can be created without any connection being made. A connection is not made until it is necessary (i.e. you are issuing a SQL query). Try including the :test=>true option in your connection string to test the connection immediately after creating the Database object. Jeremy -- 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.
