similar to: find_by_sql - multiple selects, same statement SQL error

Displaying 20 results from an estimated 200 matches similar to: "find_by_sql - multiple selects, same statement SQL error"

2003 May 09
1
OH323 Channel Driver buffer sizes
Hello! Anyone with some insight into the oh323 channel driver please shed some light on the code block below from wrapendpoint.cxx. When enabling trace on the channel driver i get this, for me, strange debug info: WrapH323EndPoint::OpenAudioChannel: Direction => PLAYER, Buffer => 320 WrapH323EndPoint::OpenAudioChannel: FrameSize 8, FrameTime 8, TimeUnits 8
2005 May 17
5
Strings, Variables and GetText
Hi, I''m starting to use GetText and have this code: render_text %(<script language="JavaScript" type="text/javascript"> parent.mainframe.onUpdateNew("Gallery <b>#{@media.name}</b> was successfully created.", "#{@media.name}","#{String(@media.id)}","#{@media.media_type}"); </script>) I need to convert
2013 Jun 23
1
Some General questions related to icecast api
there is also a directory provided by shoutcast radio server i have some questions related to icecast 1.How much Internet streams are in the icecast radio directory and accessible using this url ?? 2.Streams on icecast server are different or it is possible that both api will return same stream url ?? 3. what is the significance of these json attributes "channels":NaN
2002 Jan 01
6
new vorbisenc behaviour
Just got around to compiling RC3 under beos and came across an anomaly when using managed bitrates. I haven't changed the code for the beos encoder but I now get double the bitrates so vorbis_encode_init(&vi,mediaFormat.u.raw_audio.channel_count,(long)mediaFormat.u.raw_audio.frame_rate , -1, 128000, -1); now gives me vorbis files that average around 325 - 350. Is this now the correct
2009 Nov 20
0
[PATCH] memdisk: Use boot_lba logic for booting an offset within the di
The previous MEMDISK El Torito code merge did not actually work without this. Signed-off-by: Shao Miller <shao.miller at yrdsb.edu.on.ca> --- memdisk/setup.c | 17 +++++++++-------- 1 files changed, 9 insertions(+), 8 deletions(-) diff --git a/memdisk/setup.c b/memdisk/setup.c index 40f3f8c..5a45f39 100644 --- a/memdisk/setup.c +++ b/memdisk/setup.c @@ -338,6 +338,7 @@ struct geometry
2008 Nov 22
0
[patch] [vuxml] net/wireshark: fix DoS in SMTP dissector
>Submitter-Id: current-users >Originator: Eygene Ryabinkin >Organization: Code Labs >Confidential: no >Synopsis: [patch] [vuxml] net/wireshark: fix DoS in SMTP dissector >Severity: serious >Priority: high >Category: ports >Class: sw-bug >Release: FreeBSD 7.1-PRERELEASE i386 >Environment: System: FreeBSD 7.1-PRERELEASE i386 >Description: Today the DoS
2002 Oct 20
3
OCX for playing ogg files in MS windows perform
Hi All, I was wondering if anyone could point me to the right direction to get a OCX which can play the ogg file in MS windows perform? Thanks all Wai --- >8 ---- List archives: http://www.xiph.org/archives/ Ogg project homepage: http://www.xiph.org/ogg/ To unsubscribe from this list, send a message to 'vorbis-dev-request@xiph.org' containing only the word 'unsubscribe' in
2002 Oct 20
3
OCX for playing ogg files in MS windows perform
Hi All, I was wondering if anyone could point me to the right direction to get a OCX which can play the ogg file in MS windows perform? Thanks all Wai --- >8 ---- List archives: http://www.xiph.org/archives/ Ogg project homepage: http://www.xiph.org/ogg/ To unsubscribe from this list, send a message to 'vorbis-dev-request@xiph.org' containing only the word 'unsubscribe' in
2005 Sep 11
0
OpenH323-Channel Q.931-Problems with Gatekeeper
Dear Mailinglist-User currently we`re working with an IP-PBX, based on Asterisk, with SIP, H.323 and ISDN-Capabilities. SIP and ISDN works fine, but H.323 not. In our first test, we started to connect Asterisk to an Cisco IOS-Gatekeeper with the "chan_oh323" (version 0.6.5). We successfully tested in/egress calls without any problems. But when we started to connect our Asterisk
2007 Mar 05
1
Using act_as_ferret with find_by_sql
Hello, I wonder if its possible to combine ferret queries with find_by_sql queries? Or should I try to rewrite my query using find and then use find_by_content when I''m done? Thanks for a great product! Regards, henrik
2006 Nov 04
0
How to paginate a find_by_sql query?
Does anybody know how to paginate a find_by_sql query? Unfortunately I need to paginate a query which is next to impossible for ActiveRecord or just too much of a pain to implement. So I''m using find_by_sql. However, I anticipate a large number of rows returned eventually. So I may need paginate. Does anyone know how? Thanks Phillip Novess http://primalart.net
2006 Jul 05
0
@products = Product.find_by_sql "SELECT *...... "
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) <= " +
2006 Apr 04
1
has_many fails where find_by_sql succeeds
Can anyone explain why the method form of the following works, but the (apparently identical) has_many fails? I have 3 sites in my fixtures. Initially, for a new StockGroup, sites_not_using_this_stock_group should return all 3 sites (which it does). When you add a site to the StockGroup, it should disappear from the output of sites_not_using_this_stock_group. But the has_many form
2006 Apr 20
1
Returning Count from find_by_sql
I want to return an int from a find_by_sql call. But when I use that result to compare to another count the error tells me I have an array. MODEL: # Returns the number of comments in a specified post def self.find_count(post_id) find_by_sql(["SELECT COUNT(*) FROM commments WHERE post_id = ?", post_id]) end CONTROLLER: def test @post =
2006 Jan 10
0
find_by_sql + partials question
Ok now that I have find_by_sql love working for my "Top 10 List" I want to make them a bit more DRY. Tis is what I have so far: Model: def self.topfish find_by_sql["select species.name, length,species.multiplier*length as score,caught_on from entries join species on species_id = species.id where species_id = ? order by score DESC LIMIT 10", species]
2006 Jan 26
1
Help constructing a find_by_sql command
Hello all. I am trying to do the equivalent of: @componentlogs = Componentlog.find(:all, :conditions => [ "cl_compname like ?", @criteria ], :offset => offset, :limit => items_per_page, :order => "cl_spr DESC" ) in a find_by_sql statement. I cannot use the build in because the adaptor isn''t quite right (OCI8) When I use it I get the following error
2006 Jan 30
1
find_by_sql and memcached
Is a find_by_sql query cached with memcached and cached_model (http://dev.robotcoop.com/Libraries/)? Looks like the answer is no. Is there a reason for this? I have a lot of very complicated querys with a lot of unions, subquerys and joins that would greatly benefit from the cache. Going through the code I can see that the find_by_sql method is changed in cached_model.rb, but it does not call
2009 Apr 06
0
find_by_sql returns Strings! How to I type cast?
When i run find_by_sql the extra fields not in the Model are returned as Strings. What is the correct way to convert all the extra fields to their correct type? Is there a way to somehow define these extra fields in the Model class to ensure they will always be returned correctly? Or is their a better method. I will be using find_by_sql a lot so a clean solution would be good. (I am using
2010 May 07
1
undefined method 'find_by_sql'
Why would I get an undefined method `find_by_sql'' for #Example: 0x981a4e4> for error when trying to use the find_by_sql method in my model? def init_dictionaries tables = find_by_sql( "SHOW TABLES FROM thesaurus" ) @@tables = tables.collect{ |t| t.Tables_in_thesaurus } end -- You received this message because you are subscribed to the Google Groups "Ruby
2011 Aug 19
0
find_by_sql Method
Hello guys! I am new in rails. I am querying the courses table for specific courses that belong to specific institute using this sql statement. I''m getting the same courses for all the institutes that I have. Any help on what to put in place of 1 or how to restructure my query will be highly appreciated. Here is my query! <%= select ("course_code",