Displaying 20 results from an estimated 1200 matches similar to: "SQL quoting for :order parameter"
2006 Apr 16
3
variable variables?
Hi everyone,
Does Ruby support variable variables like PHP
(http://www.php.net/manual/en/language.variables.variable.php)? Or do I have
to use eval, like
some_hash.each_pair{|key, pair|
eval "#{key} = #{value}"
}
Or is there some other way?
I''m actually trying to figure this out in order to use ez_where to create
its conditions from a hash, so if this isn''t even
2006 Aug 01
8
Dumb views?
Hello again! I''ve another "what would you do in this situation" question.
You''ve got 6 controllers, one named base. The other 5 controllers extend
base. Currently they share one layout.
Your layout displays navigation. However, there are two actions inside base
for which you do not want navigation displayed (index, new).
Do you...
a) Add logic to your layout telling
2006 Mar 28
11
ActionWebService date casting error
I have defined a web service to return information from a database as follows.
class BackendApi < ActionWebService::API::Base
api_method :find_all_vobs,
:returns => [[:int]]
api_method :find_vob_by_id,
:expects => [:int],
:returns => [Vob]
class BackendController < ApplicationController
wsdl_service_name ''Backend''
2007 Oct 15
6
SQL injection with :order, :limit, :group
I know how to avoid SQL injection attacks when you use :conditions
User.find :first, :conditions => ["login=?", params[:username]]
but how about with :order, :limit or :group?
# uh-oh...spaghetti-oh
User.find :first, :order => "login; delete from users; select * from users"
Pat
--~--~---------~--~----~------------~-------~--~----~
You received this message because you
2006 Dec 04
10
Avoiding SQL Injection in :order?
This thread references:
http://www.ruby-forum.com/topic/90258#new
http://www.ruby-forum.com/topic/82349#143790
ActiveRecord''s find() method has built in ways to avoid SQL injection by
using the format
> :conditions => [ "user_name = ?", user_name]
Is there any such system for escaping injection in :order? It seems to
only take a string and feed it to the SQL
2006 Jan 05
8
Repost - Do dynamic finders work with legacy schemas?
Hello everyone,
I have another question related to a legacy schema I am working with.
Do dynamic finders work with legacy schemas in general? The schema I am
working with uses hungarian prefixes for column names. For example fOpen is
0 if a bug is closed and 1 if it is open (type smallint). When I try @bugs
= Bug.find_all_by_fOpen(1), I get the following exception:
undefined method
2010 May 13
6
to "loop through" the instance variables of ActiveRecord?
to wrap each instance variable of an ActiveRecord object between "<td>"
and "</td>", is there a way to "loop through" them, at least in the
debug mode, no matter there is getter methods to get them or not, or at
least the ones with the getter methods?
Such as
<% @stories.each do |s| %>
<%= "<tr>" %>
<% s.each_property
2010 Sep 16
5
vestal_versions -- can I set it to ignore certain columns?
I''d like my published boolean to be excluded from the calculation as
to whether a version is created or not. Can anyone suggest a way to do
that?
Thanks,
Walter
--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To
2006 Jan 19
4
multiple database in the same actions?
Hi,
I read the example in
http://wiki.rubyonrails.com/rails/pages/HowtoUseMultipleDatabases,
it show us how to connect to other database, each time
we start a new action, however, this doesn''t work
while you try to connect to two different database
within the same action.
SO I wonder is it possible to bind to two or more
database within the same action????
Thanks you very much
Saiho
2010 Mar 11
3
Define column names to a series of data.frames
Greets to the list!
I am aware that this topic has been discussed several times. And I've
read quite some related posts [1]. Yet, can't seem to give a solution to
my problem.
I have 6 data frames consisting of 6 rows x 7 columns put together from
other data.frames.
Something like:
a b c d e f g
v1 # # # # # # #
v2 # # # # # # #
v3 # # # # # # #
v4 # # # # # # #
v5 # # # # # # #
v6
2008 Mar 08
9
Newbie worries with "Developing Rails Applications on Max OSX Leopard"
Hello There,
As a new comer to RoR, I started to follow the article
http://developer.apple.com/tools/developonrailsleopard.html. In short
you create to entities and one one-to-many relation linking them.
Everything was good until the establishment of the relation. I am
unable to go any further than "Linking Models Together" : I can create
the "vendors" mentionned in the
2009 Mar 10
5
'unknow column error' when using include and associated table condition in find
Here is my weird problem.
Two models like following:
Lexeme
id:int
name:string
Structure
id:int
ref_id:string
meta_id:int
Lexeme can have many structure records through foreign key ''ref_id'' in
the structures table.
And these structure records belonging to one lexeme differs between
each other using meta_id.
And if Lexeme has structures, then there must be a top_struct whose
2007 Aug 22
2
Access table names
Hello,
Anyone know if there is a way to get all of the column names from the
tables usinf rub on rails?
Thanks again
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to
2006 Jan 27
17
Multiple Model Validation
Hey All !
I have a form which contains two models. I would like both models to be
validated, but have their validations aggregated on the page.
If I do:
<%= error_messages_for(:model1) %>
<%= error_messages_for(:model2) %>
It puts two big validation blocks on the page. I would like all the errors
from both models, but only in one validation box.
Is this possible ? All my attempts
2006 Dec 27
10
Mixing html tags and Ruby blocks
I''m trying to get the following idea to work:
<%= @column_names.each { |t| <td> t.downcase </td> <td>
@listing.send(t.downcase)</td> } %>
Essentially I want to display a form that has a left and right TD, with
the left TD being a column name and the right TD being the column data.
If there''s a better way (the Rails way ?), I''m all ears
2007 Oct 24
7
NoMethodError when creating new ActiveRecord model object
the strangest thing is happening...i''m not getting this every time,
maybe 1/3 of the time, identical requests...
i''m a rails newbie, but i think i''m trying pretty standard stuff, this
is an excerpt from the log:
----------------------
Processing EmailConfigsController#edit_xml (for 127.0.0.1 at 2007-10-24
15:52:09) [GET]
Session ID: 6630219819a2da423d8c48a259dd28d6
2009 Mar 01
1
Strange behavior of Source.column_names
I have a class named Source and a controller named SourceController
etc.
When I use Source.column_names in the view all names except names
ending in _id is listed, although according to the documentation all
names should be listed
When I use Source.column_names in the source controller it lists
correctly all names also the ones ending in id.
When I first call Source.column_names in the
2006 Feb 23
9
auto provision of IP501 polycom
Has anyone been able to get the IP501 to discover the FTP server IP
address (via dhcp or dns) and download 100% of the config from a
provisioning server?
We are still having to touch each unit to enter the ftp server address
and password, as well as set many of the options that will not take from
the config file.
Have a sample config file you are willing to share?
What is required in
2012 May 21
4
Getting model column names
Hello,
I am writing a RoR application that connects to a couchDB database using
couchrest_model.
The definition of my model is the following one:
class BdsDataAuthor < CouchRest::Model::Base
property :id, Integer
property :first_name, String
property :last_name, String
end
I would like to be able to get the list of the model columns, e.g., the
result of
BdsDataAuthor.columns would be
2006 Mar 24
2
check_box_tag
hi,
What''s the right way to use the CHECK_BOX_TAG?
I used:
<% for @pippo in @model %>
<%= check_box_tag (:scelta,@pippo) %>
<% end %>
How Can I control if a person choosen the second or third element of the
vector @pippo?
--
Posted via http://www.ruby-forum.com/.