similar to: function of ruby to get cdbl(date)

hello all i have a trouble whit a controller i need filter the collection by a date, but i dont know how to get the values of a date, because i need that values to build my sql sentences for example: @products = Product.find_by_sql "SELECT * FROM products WHERE cdbl(date_availabe) > " + first_date_double_value + " AND cdbl(date_available) <= " +

please i need to know if in ruby on rails can i get the value double of a date for example in the next sql sentence select * from employes where cdbl(finish_date) < 35678 -- Posted via http://www.ruby-forum.com/.

how can i get the month number of a specific. for example this code don?t work month(Date.today) -- Posted via http://www.ruby-forum.com/.

Hallo all! Know somebody, if exist Dialplan commands (specifically sql sentences) for Asterisk Realtime? For example: I have users defined in mysql database. In the dialplan, I would like to select one field of a table. select email from sip_buddies where name=200 I try to use DBget, but I have error. I think because DBget use intern Database, and can 't connect to mysql. (Sintaxis:

Hi, I have 2 tables as follows:- _________________ ________________ ____________ taggings | |stores | | tags | -----------------| |---------------| |------------| --tag_id | |--store_id | |tag_id | --store_id | |--store_name | |tag_name | --user_id | |---------------| |------------| -----------------| Now I want to execute

Hi Everyboy ! I read that LVM2 is not cluster aware (specially with OCFS2) from different post on internet forum... If it's true, could someone could confirm this information and point me where i can find this affirmation in documentation ? I do some test with OCFS2 on LVM2 and it's seems to run correctly , so i have some interrogation about this fact ! If it's true that LVM2 are

I am executing some arbitrary SQL in which i need to convert a date/time object into an sql formatted string. Is there a simple way to do this in rails? Thanks Chris -- Posted via http://www.ruby-forum.com/.

I just installed ruby on rails on my windows laptop (so I can code on the road dontcha know), I normally use my gentoo box for this, but since moving things to the window box, I get this error when I try to run my application: Mysql::Error: Lost connection to MySQL server during query: ############################# And for the life of me can''t figure out why, it works just dandy on my

Ruby on Rails Programmer - Junior Our client, based in Austin, TX, is looking for a Ruby on Rails Programmer to join their dynamic team of experienced programmers. As a Ruby on Rails Programmer, you will perform a critical role in designing and building code for our top-secret, cutting edge suite of products. Your top-quality ROR programming skills and your ability to be flexible, highly

Hi guys, I'm a new to R and following along with Tutorials using this book: http://www.amazon.com/Practical-Statistical-Analysis-Non-structured-Applications/dp/012386979X In one of them, they use the twitteR package and describe the following function (see below). From what I can tell from the documentation (R), there's a method to call it directly in an interactive session. The way

Ruby on Rails Junior Programmer/Tester - Otherinbox OtherInbox is looking to hire an experienced Ruby On Rails Junior Programmer/Tester to join our team. We are looking for a highly motivated, goal-oriented individual who will be responsible for designing, building and maintaining sections of the product. The successful candidate should be a flexible, highly independent worker as well as an

Hi All, I want to know the EOL date for the below gems for ROR. Can anyone help me how to find the EOL dates - authlogic - will paginate - oauth-plugin 0.3.14 - statistics 0.1.1 - YUI - cucumber 0.6.4 - cucumber-rails 0.3.0 - rspec 1.3.0 - rspec-rails 1.3.2 - webrat 0.7.0 - factory-girl 1.2.4 - database_cleaner 0.5.0 - SSL requirement - calender_select

Hi all, I'm trying to find something like the "==" operator that will work on vectors or something equivalent to SQL's "IN" function. For e.g., if I have: x <- c(1,2,3,4,5) y <- c("apples", "oranges", "grapes", "bananas", "pears") z <- data.frame (x,y) w <- c(2,4,5) I want R to return the values

Hi, how do i use passed in arguments and convert those to something sql can understand? do the aliases have to be double qouted? single qouted? i think i tried all but no avail...thanks! def get_count(doctype, towne) @profiles = Profile.count_by_sql("SELECT COUNT(*) from Profiles where Profiles.doctype_id = 1 and town_id = towne") end -- Posted via

Dear R users, Version 2.1-1 of the sem package, for structural equation modeling, is now on CRAN. Unlike version 2.0-0, which was a major overhaul of the package, version 2.1-1 just sprinkles some syntactic sugar on it, introducing the specifyEquations() and cfa() functions; specifyEquations() supports model specification in equation (rather than path) format, and cfa() facilitates compact

Dear R users, Version 2.1-1 of the sem package, for structural equation modeling, is now on CRAN. Unlike version 2.0-0, which was a major overhaul of the package, version 2.1-1 just sprinkles some syntactic sugar on it, introducing the specifyEquations() and cfa() functions; specifyEquations() supports model specification in equation (rather than path) format, and cfa() facilitates compact

https://bugzilla.samba.org/show_bug.cgi?id=2423 Summary: Feature Request: Ability to transfer files newer than date or file. (--newer switch). Product: rsync Version: 2.6.3 Platform: All OS/Version: Linux Status: NEW Severity: enhancement Priority: P3 Component: core AssignedTo:

This is obviously not a long term acceptable solution. Could someone please enlighten me as to the permanent solution, or at least see why it doesn't work? This is not my problem, therefore I have not had the opportuntity to test - I don't have a version that old. Let me know if it is solved in a newer version as well. Thanks. It is a workable solution, although the generally accepted

If you used MySQL FULLTEXT indexes and just upgraded to Rails 1.1, watch out for this one. Rails 1.1 now defaults to Ruby as your schema format. So instead of development-structure.sql, Rake will use schema.rb. That''s portable and good stuff overall but there is a slight compatibility issue. Ruby schema doesn''t know how to do FULLTEXT index syntax for MySQL. To work around it,

Hi everybody At work we''ve finally convinced the chief to develop some small project using open source technology. Unfortunately we are deeply involved with Micro$oft technology. That means, windows 2003 server, IIS, MS SQL 2005 and asp. I was thinking about recommending ruby on rails instead of asp, but I''d like to know how well it goes with IIS and MS SQL, because for the