similar to: Is it true that you cannot use bind variables with Oracle?

Does ROR + Oracle use bind variables? Using :conditions in a find statement gives the appearance that bind variables might be used : header = "test header" Posts.find(:all,:conditions=>["header = ?",header]) i.e. Does AR just pass the whole string to oracle or the SQL and the parameters? I''m in an oracle shop and my boss wants to know, i''d be very

Notice the "AS" keyword appears many times. Oracle does not support this keyword: ActiveRecord::StatementInvalid: OCIError: ORA-00905: missing keyword: SELECT tim esheets.id AS t0_r0, timesheets.start_date AS t0_r1, timesheets.status AS t0_r2, timesheets.cost AS t0_r3, timesheets.charge AS t0_r4, timesheets.employee AS t0 _r5, employees.id AS t1_r0, employees.name AS t1_r1,

It seems as though it cannot be done. Does anyone know how to do it? Thanks Chris -- Posted via http://www.ruby-forum.com/.

Oracle has no boolean value type, so how do i treat fields as being boolean in activerecord?? I know i could rewrite the accessor methods in the model class to return the correct boolean value, but this seems too tedious and wrong. Does anyone know a better way?? Any help is greatly appreciated, Thanks, Chris -- Posted via http://www.ruby-forum.com/.

In my database the id for a field is 810. RoR thinks that it is 809. My log file (below) shows that just before the insert it grabs the next sequence value. I dont think it should do that. This causes problems further down the line when trying to access the Person object. Development Log file : "SQL (0.016000) select people_seq.nextval id from dual Person Create (0.015000) INSERT

All of a sudden, on three different systems, the "server_ip_address/sid_name" syntax in database.yml has stopped working for me. I can''t even do a OCI8.new(blah blah blah) statement from an IRB shell. I get "ORA-12541: TNS:no listener", or some variant, depending on how I phrase it. On systems where I have a real deal client installed, and OCI can find the tnsnames

Hello all, I have a syntax question. How does one refer to a field brought in via a has_one/belongs_to relationship in a form helper? Basically, I have two models: class Resource < ActiveRecord::Base has_one :other_thing end class OtherThing < ActiveRecord::Base belongs_to :resource end It has the normal id-resource_id foreign key relationship. OtherThing has two fields, plus the

hi, i want to make a behavior shared between models, the examples need to create new instances etc. Is there a way to pass the model class to the shared behavior? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/rspec-users/attachments/20071218/5b400cc5/attachment-0001.html

Hi When i change my classes in the LIB folder they are not updating on the server. My server is in development mode. Any ideas why? Any help is appreciated Thanks, Chris -- Posted via http://www.ruby-forum.com/.

Hi, I need to get the environment variable ORACLE_SID from the OS. I know this can be done with the following: $blah = env("PATH") However, the ORACLE_SID variable is only set under the oracle user account. So I would need a way to login as the oracle account first to retrieve the ORACLE_SID variable. Is there anyway to get the environment variable from a user''s account

Hi, I have a question about bundle: RoR + oracle + bind variables. Heaving read forums/blogs/etc I found out RoR does not use bind vars for oracle particularly (and for all adapters in general). Then I found Michael''s patch (http://dev.rubyonrails.org/attachment/ticket/5199/oracle_bind.patch) but it was not added to the following RoR versions (since the end of May). As I suppose it was

I never want to alter a model(row). When a model has been changed i want a new copy to be created. What is the best way to implement this? I think using callbacks might be the answer. So model.save will create a new row, and leave the old one unchanged. Any ideas? I can easily implement this in the controller but i''d rather it be done transparently. Also errors should be passed back

I''ve just started creating a web application with approx. 100 tables. Possibly more. Oracle is the DB. There exists a legacy schema I that i will use some of. So far i have created a small bit of the app, approx 10 tables. Im using webrick on my local machine. The Oracle DB is on its own server. My boss has noticed that its not really that zippy, there is a small delay between

One of my actions runs for more than 2 minutes. In development mode it runs and completes successfully, but in production mode it quits out with a timeout error: "Timeout::Error (execution expired):" Any ideas how i can stop this? I''m desperate to find a solution. Is there a setting i can change somewhere? Any help would be greately appreciated, Thanks Chris -- Posted

@products["car"] is not being recognized in my tests: class ProductsControllerTest < Test::Unit::TestCase fixtures :products def test_view_product post :view_product, :id=>@products["car"].id assert_template "view_product" ... end end products.yml : car: id:1 name:test Does anyone have any idea why its not working? Im having to do

I cant figure out how to do global regular expressions in ruby. Im not even sure if its possible. In the "Programming Ruby" book there is no mention of it. Can you do this? text = "aaa1 bbb2 ccccc3 dddddd4 eee5" re = /\w+\d{1}/ matches = re.match text m[0] = "aaa1" m[1] = nil m[2] = nil and so on.... Is there any way to get an array of all the matches??

Experts, I''m installing Oracle 9i on Solaris 10 11/06(update 3),I created some zfs volumes which will be used by oracle data file,as: # zfs create -V 200m ora_pool/controlfile01_200m # zfs create -V 800m ora_pool/system_800m ... # ls -l /dev/zvol/rdsk/ora_pool lrwxrwxrwx 1 root root 39 Apr 11 12:23 controlfile01_200m -> ../../../../devices/pseudo/zfs at 0:1c,raw

Hi I know i can use loggger.info("info") to output a message to the log file from within ActionController classes. HOw do I do it from my own custom class? Thanks Chris -- Posted via http://www.ruby-forum.com/.

When using array.each_with_index how do you start at a desired index position? I can do it like this, but its not very clean and doesnt seem efficient : desired_index_start = 20 array.each_with_index do |value,index| next if index<desired_index_start end Thanks Chris -- Posted via http://www.ruby-forum.com/.

I searched the archives and found a thread about it, but I didn''t understand: are prepared statement used by ActiveRecord on those databases that could handle them (Postgresql, Mysql, Oracle etc)? In case they are not used, are they planned? Is there a roadmap about Rails I can find somewhere?