Displaying 20 results from an estimated 100 matches similar to: "Inserting data from 1 table to another by using find_by_sql"
2009 Mar 10
5
onsubmit for remote_form_for not working properly
I want to use onsubmit for a form validation using javascript on
remote_form_for
for this i am doing something like this
<% remote_form_for :timesheet, @timesheet, :url =>{:action =>
''report_user''}, :html => {:onsubmit=>"return ValidateDate();" } do |f|
%>
// Form elements here
<% end %>
but it not works well. if condition return false
2009 Sep 23
2
FFMPEG Query
Hi All,
I want to convert a video file which is located at the Amazon-S3 Store,
through ffmpeg. How can it b possible? please help me if anyone have any
idea.
for ex:-
is it possible to execute following command:-
system "ffmpeg -i
2009 Jul 07
1
Adding data in two tables simul;taneously with Validations
Hi All,
I have 2 tables
1] user_infos &
2] users
class UserInfo
has_one :user
validates_presence_of :city
class User
belongs_to :user_info
validates_presence_of :first_name
i write following code in my create method.
@user_info = UserInfo.new(params[:user_info])
@user=@user_info.build_user(:first_name=>'''')
if @user_info.save
else
end
now what i want is to
2009 Jan 27
6
German letter ä, ö, ü in rfpdf
Hi,
I need PDF creation in Rails and decided for RFPDF.
Everything works quite nice the only problem is that I can''t display
ä,ö,ü in the pdf documents.
I found a tutorial that says that I have to create a font config file
with MakeFont.
I did it, but now I don''t now where to put al this files.
Does anyone has experience with creating PDFs in Rails with ä,ü,ö
letters?
Thx
2006 Jul 18
3
Newbie validation question
I am having problems with a validation, the full model code is below.
The validate routine is attempting to see if another record with the
same artist_name, title, & catalogue_no exists in the products table. If
so, it should throw an error.
This is the validation code:
def validate
if Product.find(:all, :conditions => ["artist_name = ?, title = ?,
catalogue_no = ?",
2004 Oct 01
5
Song Updates
Run this from command line:
curl --user admin:hackme 'http://192.168.0.1:8000/admin/metadata?mount=/live&mode=updinfo&song=Artist_name+Title'
That should set you all up, just change IP, Port and MountPoint.
-- Cody Tubbs : (Certified Master Linux Administrator)
: (Certified Unix Security Specialist)
-- Broadway Internet
On 1 Oct 2004 at 12:15, Dave St John wrote:
>
2006 Dec 07
2
need to transfer data from old php like db to rails style db
hey all,
I have two tables like that from an old php project:
artists(id,name)
albums(id,artist_id,album_name)
and I need to transfer the data of this database to three tables that
look like this:
artists(id,name)
albums(id,name)
artists_albums(album_id,artist_id)
any idea what''s the fastest query to do this?
thanx in advance
Pat
--~--~---------~--~----~------------~-------~--~----~
2007 May 09
1
form.select wrong number of arguments (0 for 1)
I am new to rails, PHP background. I''m completely lost on this. I am
trying to pull all of the albums from the albums table into a select
box. But every time I run the script I get the "wrong number of
arguments (0 for 1)" error. I''ve looked on other message boards and
searched the web but I can''t seem to find the answer. I''ve tried several
different
2011 May 28
3
Three sigma rule
Dear Sir,
I have data, coming from tests, consisting of 300 values. Is there a way in
R with which I can confirm this data to 68-95-99.8 rule or three-sigma rule?
I need to look around percentile ranks and prediction intervals for this
data. I, however, used SixSigma package and used ss.ci() function, which
produced 95% confidence intervals. I still am not certain about percentile
ranks
2006 Jan 10
1
[AJAX] related drop-down list question
Hi all,
I followed the example on: http://www.roryhansen.ca/?p=9 for creating
related drop-down lists.
However, this code actually creates HTML in the controller component:
@albums = Album.find_all_by_artist_id(@params["artist_id"])
@html = "<select id=''album_id'' name=''album_id''>"
@html += "<option
2007 Feb 26
24
Ruby/rails port of Cocoon/hibernate
Hi,
I''m currently running an apache/jboss cocoon/flow/hibernate/ajax
paypal (directpayment) project and am looking into the possibility of
porting it across to ruby/rails. For that reason I would like to know
the following:
1. Can I call my java classes or would I be looking at a complete
rewrite in ruby?
2. How effective is ruby in terms of seperation of concerns regarding
design from
2010 Apr 14
1
Rails does not display form error message on a custom method
Hi all,
I''ve created a custom method called checkout in my app. I create an
order (which is done my adding products to my "cart"), assign it to my
client, and then I head to my checkout screen where I confirm the items
and enter their customer order number and complete the order (submit).
Everything works great except that it doesn''t display error messages.
2004 Sep 30
2
Song Updates
Hello Everyone,
What is the string to update song titles?
I have seen a few but none seem to work.
Thanks
John
2009 Jul 15
2
Fixing ogg vorbis corruption caused by bad metadata
Adam Rosi-Kessel wrote:
> Yes, it was Mediamonkey. They claim that it was due to a bug in vorbis
> libraries.
All software has bugs, but this explanation doesn't really add up.
libvorbis is the codec. If they had blamed libogg, which does the
container, then yes, that would have been a believable explanation :-).
Erik
--
2009 Apr 16
0
how to convert the find_by_sql code to the find code
I want to convert following query into pure ruby one i.e. by using find
@us_state_sales=SalesReport.find_by_sql("SELECT z.state,
sum(s.royalty_price) as royalty_price, sum(s.units) as units FROM
sales_reports s, zip_codes z
WHERE royalty_currency = ''USD'' && z.zip_code=s.postal_code GROUP BY
z.state ORDER BY royalty_price desc LIMIT 10")
i try something like
2006 Aug 13
3
ruby and mysql syntax? tried single quotes, double, none, ...
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
2003 Nov 27
1
commands
hi
I have made ext3 from ext2 by using mkfs -j option.
I want to know if all commands of ext2 like dumpe2fs ( provided in e2fs-1.36
) works fine with ext3 ?
Do we have some commands that are unique for ext3 file system ?
____________________________________________
Salvy
HCL Technologies Ltd A-11, Sector 16 Noida, U.P., India Ph: 91-9811250247
salilt@noida.hcltech.com
2006 Dec 16
1
where can I find source code of bridge control utility (brctl).(bridge-utils-0.9.5.tar.gz)
Hi All,
Can anybody suggests where can I find source code of bridge control utility
(brctl).(bridge-utils-0.9.5.tar.gz)
Regards
_______________________________________________
LARTC mailing list
LARTC@mailman.ds9a.nl
http://mailman.ds9a.nl/cgi-bin/mailman/listinfo/lartc
2006 Apr 25
6
Searching over multiple MySQL tables
I am racking my brain over this, probably because I only know very
simple mysql functions.
Basically I''ve got a few tables, ex:
Albums (id,name,band_id); Bands (id,name,label_id), and Label (id,name)
I want to search through both album.name, band.name, and label.name
throwing all results into a variable, with no redundant info.
I think what I need to be doing is setting up some
2006 Jul 19
0
Form helpers produce invalid XHTML code!
Hi all
The following scaffold creation form code...
<%= start_form_tag :action => ''create'' %>
<%= render :partial => ''form'' %>
<%= submit_tag "Create" %>
<%= end_form_tag %>
...creates this HTML colde:
<form action="/en/bookings/create" method="post">
<!--[form:artist]-->