Thanks! I don't know exactly what happened, but the problem disappeared. I figured that some step I took when testing must have fixed it unbeknownst to me so I copied the exact code from my first post and presto! it worked. Gotta love it :)
On Nov 19, 9:03 am, Jeremy Evans <[email protected]> wrote: > On Nov 18, 4:24 pm, Steve Ross <[email protected]> wrote: > > > I have the following code: > > > database = Sequel.connect('sqlite://lrdb.db') > > puts database.inspect > > > t = database[:Adobe_images] # <= See if I can get to the table using > > core functionality. Yes!!! > > puts t.first > > > class Image < Sequel::Model(:Adobe_images) # <= See if I can get to > > the table using model > > end > > > Image.filter{:fileHeight > 1000}.each do |add| # <= Failure. > > This is the only problem I can spot in your code. If you are using a > virtual row block, you should be doing: > > Image.filter{fileHeight > 1000}.each do |add| > > Note the missing colon. That doesn't explain the weird error you are > receiving though. Could you try removing the colon and posting a full > SQL log (using require 'logger'; database.loggers << > Logger.new($stdout)) if you still have problems? > > > # stackParent____aspectRatioCache, > > # stackParent____captureTime, > > # stackParent____colorLabels, > > # stackParent____fileFormat, > > # stackParent____pick, > > # stackParent____rating, > > # stackParent____touchCount, > > # stackParent____touchTime, > > These could potentially cause issues if you attempt to modify a > record, as Sequel treats double/triple underscores in symbols > specially. The easiest way to work around that is to use an > identifier_(input|output)_method that does the translation in and > out. Search the Google Group, I gave an example fairly recently. > You'd probably want to squash the 4 underscores to one in > identifier_output_method, and expand the 1 underscore to 4 in > identifier_input_method, just for those specific identifiers. > > 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.
