Displaying 2 results from an estimated 2 matches for "media_type_id".
2009 Sep 16
3
find_by_sql - multiple selects, same statement SQL error
I''m trying to get the following statement to work using variable
substitution (it works if hard-code the where (med_type) param in the
inner SQL statement):
med_type = ''game''
@mediaformats = MediaFormat.find_by_sql("select * from media_formats
where media_formats.media_type_id = (select media_type_id from
media_types where media_type = ?, :med_type) order by description")
The error is generated by MySQL because the query it receives is:
select * from media_formats where media_formats.media_type_id =
(select media_type_id from media_types where media_type
= ?, :med...
2013 Jun 23
1
Some General questions related to icecast api
...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
,"media_type_id"103",
"current_song":"89ers - Louder"
please reply !!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.xiph.org/pipermail/icecast-dev/attachments/20130623/8dc480ed/attachment.htm