Displaying 20 results from an estimated 100 matches similar to: "Help constructing a find_by_sql command"
2006 Jan 25
4
Cannot :order when using :offset and :limit in find
Hello all.
I am using the Paginate_with_ajax code as described on the wiki but I am
running into the following problem. The following code will work fine
and retrieved unsorted records in a hunky dory fashion:
@componentlogs = Componentlog.find(:all,
:conditions => [ "cl_compname like ?", @criteria ],
:offset => offset,
:limit => items_per_page )
However if I try and add an
2006 Jan 18
5
Exception not caught?
Hello all.
I have started reading up on exceptions and tried replacing a manual
check with one. Given the following code:
def results
begin
@componentlogs = Componentlog.find(:all, :conditions => [
"cl_compname = ?", params[:componentlog][:cl_compname].strip] )
rescue ActiveRecord::RecordNotFound
render_text "<p class=''center''>No
2006 Jan 16
8
AJAX + Table.
Hello all.
I am trying ot load table rows using AJAX based on a search. The
following code results in:
1. Firefox renders correctly (Multiple rows inserted into page).
2. Opera renders the entire returned string in one <td> by the looks of
it (Bunched up under first header, the <> tags arne''t visible)
3. IE6 does nothing....great ;)
This is driving me nuts so any help
2006 Jan 13
19
Problems with scaffold''s parameter on Oracle
Hi
I run Ruby on Rails on Oracle XE.
I have a simple table:
create table customer(id number primary key, name varchar2(100));
And
ruby script\generate model Customer
ruby script\generate controller Customer
http://localhost:3000/customer/
- show a fine list, but when I click show/edit/destroy, I get an
ORA-01722:
OCIError: ORA-01722: invalid number: select * from (select raw_sql_.*,
2006 Feb 20
1
Form linking question
Hello all.
I currently have a method that is accessed from a form using this:
View:
<%= start_form_tag :action => :history %>
<p><label for="componentlog_cl_compname">Component Name</label><br />
<%= text_field ''componentlog'', ''cl_compname'', :class => ''mandatory'',
:value =>
2006 Mar 01
4
Oracle Bug
I''m using 2 database. The first wrote in MySQL and the second in Oracle.
If i use the command "SET_TABLE_NAME" to forge the model to use another
table, there isn''t no error with MySQL, while with Oracle if i ask the
view "_Form.rhtml" The compiler tell me "No sequence in SELECT
TableName_seq.nextval id from dual"(???).
Could someone tell me where
2007 Oct 07
0
Rails AR/Oracle Unit Test: [7769] failed (getting worse)
"bitsweat" has kicked AR/Oracle while it was down...
http://dev.rubyonrails.org/changeset/7769
------------------------------------------------------------------------
r7769 | bitsweat | 2007-10-06 22:29:37 -0700 (Sat, 06 Oct 2007) | 1 line
MySQL: speedup date/time parsing.
------------------------------------------------------------------------
U
2006 Mar 14
2
How to not display :id in link_to URL
Hello all.
I have a page which has a form on it. the page''s URL is
http://127.0.0.1:3000/Component/history and The form action is:
<%= start_form_tag :action => :history %>
<%= text_field_tag ''id'', "#{session[:component_criteria]}" || nil,
:class => ''mandatory'' %><br />
<%= submit_tag "Search", :class
2006 Mar 08
4
unless connected? + multiple databases
Hello all.
I am still having fun with multiple databases. In this case it is the
unless connected? statement.
ActiveRecord::Base establishes a connection that is inherited by the
majority of my models. However one Model (Componentlog) that uses a
separate DB is coded as:
unless Componentlog.connected?
establish_connection(
:adapter => "oci",
:database =>
2006 Aug 10
3
Ruby on Rails with Oracle
Hello everyone,
I am trying to convince my colleagues to convert to Ruby on Rails,
however I am up against the following problem:
Ruby on rails seems to be primarily designed a single database doing a
small number of queries. While trying to process a webpage that does
thousands of sql queries on Oracle, I get the message that I have used
up too many cursors.
In Java, I can use stmt.close()
2012 Feb 24
6
strange behaviour of "POSIXlt" "POSIXt" object
Hi,
Does anybody know why get I this kind of strange situation:
Browse[2]> hcEnd
[1] "2009-03-29 06:30:00"
Browse[2]> class(hcEnd)
[1] "POSIXlt" "POSIXt"
Browse[2]> is.na(hcEnd)
[1] TRUE
This issue is the source of my all issues in my program,
Thanks for your help
--
View this message in context:
2008 Jul 18
0
spreading the risk
This is for ACroske but I can't find his email so I'll just send it to
the list. Hi ACroske: The code below takes a zeros and ones matrix and
puts ones
in the places you wanted. It can be made shorter ( maybe ?. i haven't
thought about that ) but first let me know if that's what you wanted ?
The original matrix is called binary.matrix and the final matrix is
called tempbinmat.
2011 May 18
4
Loop stopping after 1 iteration
Hi all,
This is a very basic question, but I just can't figure out why R is handling
a loop I'm writing the way it is.
Here is the script I have written:
grid_2_series<-function(gage_handle,data_type,filename)
series_name<-paste(gage_handle,data_type,sep="_")
data_grid<-read.table(file=paste(filename,".txt",sep=""))
2006 Jul 04
1
[Fwd: formatting using the write statement]
>I have a series of write statements because
>i am writing to a file
>where the characters strings are the column names of a dataframe
>and the numbers are the elements in a particular row.
>So, a file might look like
>
>AAA 2.1
>BB 3.1
>AHLZ 0.2
>
>and it would be named "rowname".mls.
>
>so, each time i get to a new row, i create a new file and
2011 Apr 04
1
moving mean and moving variance functions
Hello
Lets say as an example I have a dataframe with the following attributes:
rownum(1:405), colnum(1:287), year(2000:2009), daily(rownum x colnum x year)
and foragePotential (0:1, by 0.01). The data is actually stored in a netcdf
file and I'm trying to provide a conceptual version of the data.
Ok. I need to calculate a moving mean and a moving variance for each cell on
the following
2010 May 30
1
Count the number of consecutive 1's
Hi All,
We have a raw dataset that, on the sampling time column, for example:
t <- c(0,1,2,5,0,5,0,2,5)
And we need to create a second column that indicates the day of the sampling, so the end result of what we want is a vector:
1,1,1,1,2,2,3,3,3
Additional information that might simplify the matter is that, for each day, the time starts with zero and ends with 5.
I am a beginner with R.? So
2004 Mar 19
2
for loop or Hmisc library trap.rule function syntax error
Hello:
I am new R user stumped why the R code after this paragraph generates "Error:
syntax error" messages after each of the last 2 lines. I have tried searching
the manuals, Hmisc documentation, contributed manuals, help archives, and
Internet. I am running R 1.7.1 under Windows 2000 (I will upgrade when my
imminent OS upgrade happens). My data was successfully entered and
2008 Aug 11
2
sampling
Hello,
I have a matrix and I want to sample 20 rows that are the the percentiles of
0-100 in 0.05 increments. I have a vector of my sequence
(0, 0.05, 0.10, 0.15,....1.0) and also
a normalised vector of rownumbers. That is, there are 234 rows (for
example) so I do
perc<-c(1:234/234)
which looks like a bunch of numbers from 0 - 1.
In Excel (which I try not to use at every possible
2011 Jun 23
2
Confidence interval from resampling
Dear R gurus,
I have the following code, but I still not know how to estimate and extract
confidence intervals (95%CI) from resampling.
Thanks!
~Adriana
#data
penta<-c(770,729,640,486,450,410,400,340,306,283,278,260,253,242,240,229,201,198,190,186,180,170,168,151,150,148,147,125,117,110,107,104,85,83,80,74,70,66,54,46,45,43,40,38,10)
x<-log(penta+1)
plot(ecdf(x),
2006 Jul 06
4
Oracle HR on Rails
Interesting read...apologies if it has been posted already.
http://www.oracle.com/technology/pub/articles/saternos-rails.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060706/619e650a/attachment.html