similar to: MySQL backticks and column names

Displaying 20 results from an estimated 1000 matches similar to: "MySQL backticks and column names"

2010 Mar 30
2
remove_index missed quote_table_name
in lib/active_record/connection_adapters/abstract/schema_statements.rb there is a missing quote_table_name in line 286 (def remove_index): execute "DROP INDEX #{quote_column_name(index_name(table_name, options))} ON #{table_name}" so my "keys" table can get an index with "add_index" but can''t remove it (without tweaking) replacing it to execute
2006 Mar 20
1
Migrations with multi-column indexes
Hey Folks, I can''t really glean this from the documentation. Is there a way to do: add_index(table_name, column_name, index_type) within my migration for an index that spans multiple columns? Ie: A covering index on FIRST_NAME, LAST_NAME or something like that? Best, Brian --------------------------- Brian Corrigan ---------------------------
2006 Jul 04
3
OCIError: ORA-00918: column ambiguously defined
Hi all, when I execute the command "rake db:schema:dump" i get this error in the db/schema.rb file. ____________________________________________________ # Could not dump table "region" because of following ActiveRecord::StatementInvalid # OCIError: ORA-00918: column ambiguously defined: SELECT lower(i.index_name) as index_name, i.uniqueness, lowe r(c.column_name) as
2009 Sep 28
5
Multi-databases support
Hi, While I was hacking ovirt-server, I have found that it's currently restricted to Postgres DB. Even if I like postgres for serious work on a server, I really prefer to hack/dev locally on a Sqlite or MySQL DB. I have googled on rails in order to find a good answer for the "foreign key problem" which forces OVirt to stay on pg. I have found a plugin on this particular
2007 Oct 09
5
Backticks wrapping SQL values in polymorphic associations...
Hopefully the subject line didn''t scare you. That said... I have a simple polymorphic relationship (is that possible?): class Part has_many :attachments, :as => :attachable end class Attachment belongs_to :attachable, :polymorphic => true end Calling Part.find(:first).attachments yields this SQL error: ActiveRecord::StatementInvalid: Mysql::Error: Unknown column
2007 Aug 24
2
error in rails 1.2.3 activerecord
i''m a rails nuby so i don''t know where to fix this in the activerecord module.... there is no such column in the sys.view.user_constraints. SELECT uc.index_name FROM user_constraints uc WHERE uc.constraint_type = ''P'' this prevents me from doing a rake test:functionals ...as in below.... C:\railsspace>c:\ruby186\ruby\bin\ruby c:\ruby186\ruby\bin\rake
2015 Apr 09
2
[LLVMdev] BNF for IL/IR interpreter
This might be a very beginner question, but I'm looking for an example for something that I have never done. Suppose that I wanted to express actions with respect to lifted semantics of CPU instructions to an intermediate representation, BAP IL or LLVM IR. How might I go about providing a Backus Naur Form specification and then dynamically interpreting those lifted instructions by also
2006 May 01
17
Radiant CMS
I am pleased to announce that Radiant CMS is now publically available from the Subversion repository at: http://radiantcms.org/ What is Radiant? ---------------- Radiant is a no-fluff, open source content management system designed for small teams. It is similar to Textpattern or MovableType, but is a general purpose content management system (not a blogging engine). Radiant features:
2006 Jul 03
9
Migrations from Mysql to Oracle. PLS HELP!
Hi all, I''m using Rails/Mysql as development platform. the production server is under Rails/Oracle. Right now, i''m trying to install my application under the production server, the connection to orcale is fine via Rails, but i have a weird problem. example : here is a extract from my db scheme : Table User :_____________ id_user | first_name |
2010 Dec 14
4
Change primary_key column name
Hi, after changing a primary key column name, the auto-increment information (MySQL) and sequence (Oracle) are lost. What is the correct way to rename primary keys? Thanks, Gustavo -- 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
2007 Oct 16
10
Scenarios Plugin Pre-Announcement
This is sort of a pre-announcement for a Rails plugin my friend Adam Williams and I are working on. We''re in the process of extracting it from a project we are working on so that it can be generally useful to the Rails community. We are calling it "Scenarios". It is a drop in replacement for Rails fixtures: http://faithfulcode.rubyforge.org/svn/plugins/trunk/scenarios/README
2006 Jul 31
2
Testing the flash.now
What''s the best way to test the flash when you use flash#now ? For example, if I set the flash in my controller: flash.now[:notice] = ''This will only show up on this action.'' How do I test it? Normally I would do: assert_equal ''This will only show up on this action.'', flash[:notice] But this doesn''t seem to work with flash.now. Any
2011 Jun 24
1
Installation of bigmemory fails
Hello All, I tried to intall the bigmemory package from a CRAN mirror site and received the following output while installing. Any idea what's going on and how to fix it? The system details are provided below. --------------------- begin error messages ----------------------- * installing *source* package 'bigmemory' ... checking for Sun Studio compiler...no checking for
2006 Apr 17
20
Rubricks - CMS on Rails
Hi list, I made an open source CMS powered by Rails, named Rubricks. I have a web page for Rubricks. You can download it or view a flash demo there. Please try them and feed me back, like bug report etc. Check it out at: http://rubricks.org/index_en.html Thanks. Shouta
2006 May 01
1
Radius 0.0.1 -- Powerful Tag-Based Templates
I am pleased to announce the immediate release of Radius 0.5.0. Radius is a small, but powerful tag-based template language for Ruby inspired by the template languages used in MovableType <www.movabletype.org> and TextPattern <www.textpattern.com>. It uses tags similar to XML, but can be used to generate any form of plain text (HTML, e-mail, etc...). This release is much more feature
2007 Nov 14
6
a few add_index questions..
on previous apps i hadn''t really worried much about adding foreign key indexes on my tables just because they''ve been fairly small and i didn''t really think i needed them. well, i''m working on something now that has the potential to have a lot more data, and a lot more foreign keys. so i have 3 tables... users, projects, and tasks.. should i be using add_index
2006 Dec 04
1
backticks
I noticed just now that package.skeleton() produces R files in which the function names are escaped with backticks. ?Quotes says that "The preferred quote is the backtick (`)", but I don't understand _why_ this is preferred. ?formula gives some clues but points out that there are no guarantees that formulae using non-syntactic names such as `like this` will be accepted. What
2010 Aug 17
1
prompt () and backticks for default arguments
Dear all, I just noticed, that prompt () looses backticks that protect default arguments: f <- function (FUN = `*`) {} cat (prompt (f, NA)$usage) yields: \usage{ f(FUN = *) } %- maybe also 'usage' for other objects documented here. without the backticks, which is of course found by R CMD check as syntax error. While this is easily fixed if the .Rd is further edited manually, I
2006 Dec 30
3
problems with escaping backticks
I can't escape backticks if on a line with other code: $ echo 'maybe use `fixed face` for `/path/to/file` by using \`back ticks\` around it' | /usr/pkg/bin/Markdown <p>maybe use <code>fixed face</code> for <code>/path/to/file</code> by using \<code>back ticks\</code> around it</p> and this is even more wrong: $ echo 'maybe use
2008 Feb 18
0
Pulling a variable from a shell script into Asterisk - backticks?
Hi, Is anyone still using backticks on 1.4? Or is there another way to pull a variable from a shell script into Asterisk 1.4? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080218/bd9a92f8/attachment.htm