similar to: Using varchar() and/or concatented pks

Displaying 20 results from an estimated 10000 matches similar to: "Using varchar() and/or concatented pks"

2006 Jul 25
3
Ruby hangman (was Re: List etiquette question)
"Beast" is more appropriate than you know. It''s definately Frankenstein code. (read: it ain''t pretty, but it works - some of the time). Anyway, it entertains my wife; not sure if hardcore programmers will get anything out of it or not. You might find it interesting (or pointless) that in a complete bastardization of rails'' main reason for being it
2006 Jul 13
4
script injection/cross-site scripting protection
When is it possible to set <script>while(true){}</script> as the value of project.name, what it the best way to escape the output of the following? <td><%= project.name %></td> Dennis Byrne -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060713/bbdedb86/attachment.html
2006 Jul 05
3
override created_on column name
We are using Rails for a project that must integrate with a legacy database. Is there a way to get Rails to automatically set the timestamp for a column named something other created_on or updated_on ? Also, how does one manipulate the size of the database connection pool? Dennis Byrne -------------- next part -------------- An HTML attachment was scrubbed... URL:
2006 Jun 27
2
Transaction syntax for > 1 table/model
If I want to wrap two account updates, the syntax is ... Account.transaction(dennis, david) do dennis.withdraw(10); david.deposit(10); end .. where both dennis and david are instances of Account. Can someone please let me know what the syntax is for starting and ending a *single* database transactions which spans two *different* kinds of models/tables ? Dennis Byrne -------------- next
2006 Jul 11
1
session state w/ >1 processes
When routing requests to more than one fcgi process, what are my options with Rails? Are most people in the community just using some form of session affinity? Dennis Byrne -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060711/2a366faa/attachment.html
2006 Jun 28
20
Rails Vs JBoss Seam
I have been frustrated with J2EE technology just like any other developer who has worked in that technology for a long time. This made me learn about Rails and I was excited about RoR. Today I came across JBoss Seam framework and I am not able to contain my excitement. My passion for JEE development is back. It seems like it is better than RoR. I would like to hear differnt opinions about this
2006 Mar 12
5
AR - Migrations - how to use a varchar as primary key instead of int ?
Hi I''d like to have a varchar primary key named id instead of the default int id. Does anyone knows how to specify this from migrations ? Should I also specify something in the model class ? thanks! Thibaut -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060312/797bca4b/attachment.html
2006 May 22
2
Inserting data in a table with a varchar key field
Hi all, I have some problems inserting data into a legacy table. the key field of this table is a field named CIN which is a varchar(15). when I try insert into this table using a form (generated by the scaffold generator) I get this Error : _____________________________________________________________________ undefined method `CIN_before_type_cast'' for #<Candidat:0x370d8c8> |
2006 Jun 12
0
Varchar not valid parameter ?
Is the type varchar not valid for migrations scripts ? I kept getting migration failures until I changed it to type :string. Stuart -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060612/407e17bf/attachment.html
2008 May 13
0
SqlServer Activerecord Adaptor + VARCHAR(MAX) Woes
I seem to be running into various issues between SqlServer and Rails, and so far have been able to solve everything save for a particular quirk when running unit tests. When I run "rake test:units" on my app, it gets so far as to run db:schema:load. I''m dealing with a legacy database, so it''s loading all sorts of tables that I don''t care about, but
2007 Nov 29
2
sqlQuery of variable of type varchar - confusion with "."
Dear list, I have a rather large dataset in SAS which I export to a SQLite database for subsequent use in R. One of the columns is cowidp 1881501224.2 1881501224.2 and the column is stored as a character in SAS. It becomes a varchar in the database (it should be - it is an identifier; not a number). Reading this into R gives cowidp 1 1881501224 2 1881501224 .... - i.e. the
2008 Sep 02
2
MySQL lookups on VARCHAR with accents
I am running into problems with MySQL and lookups. The table has character set utf8, but: mysql> select id, token from tokens where token = ''esta''; +-------+-------+ | id | token | +-------+-------+ | 83417 | está | +-------+-------+ 1 row in set (0.00 sec) How do I configure things so MySQL doesn''t ignore accents? TIA, Jeffrey
2006 Jan 18
1
using unique varchar instead of id
Hi, I just signed up so ''hello everybody''. As the title suggests, I was wondering if there was an easy way to specify that I want all actions/controls to be based upon a particular parameter rather than :id (in this case :unique_name). I don''t :id to appear in URLs or elsewhere, I want it all to work from :unique_name. It seems like something that I should be able to
2005 Feb 15
1
Trellis barchart, column display order issue
I have searched the archives and instructions high and low but have not found what I need. I have a dataframe named Data with columns: AdjResND0 - the numeric result Parameter - the classification (chemical name) Sort - the order I want the chemical names to appear, with leading zeros so all are the same length Client.Name - the sample name I am trying to generate a series of 1 page barcharts,
2015 Sep 18
1
CentOS-6 Logwatch 7.3.6 behaviour
After some experimenting I have observed that overriding settings from /usr/share/logwatch/default.conf/logwatch.conf in /etc/logwatch/conf/logwatch.conf does not produce consistent results. For example, if I replace the default detail configuration in etc/logwatch/conf/logwatch.conf with: Detail = High It does indeed change the level of detail from the default Low set in
2006 Jun 26
0
DBI question. How do I load a database with data parsed from REXML?
I wrote a rexml script that parses rather big xml files (DOM parsing) and builds an object out of them. This is what it looks like after i parse the xml file and display the object: [#<Article:0xb79e7428 @brand="This is a story from ", @id=5337, @fblurb="burb", @ntype="news type here", @copy="Copyright \302\251 2006 ", @source="source",
2002 Oct 10
3
pks for openssh
I was directed to the following site by one of our customers regarding a keyserver built into openssh. There's a patch for 3.4p1 on their site, but the license isn't very clear, nor is it clear if they have approached the openssh team regarding the inclusion of this subsystem into openssh proper. I've been asked to patch Mandrake's openssh with this feature, but I'm
2000 Sep 05
0
[PATCH] Added features for AIX authentication
Please find attached a patch I put together to provide some useful extras using OpenSSH 2.2.0p1 under AIX. I have been forced to write these to allow OpenSSH to conform to our local security policy and to aid our user administration department. Please note that in testing of this latest release we found "useLogin yes" to be broken again. Since login provides no extra functionality in
2006 May 18
8
Concatenated key
Hi all, I started playing a couple days ago with Rails and it find it very interesting. But I''m a bit stuck with making it work with a concatenated primary key. I want to use my own names for the DB fields and I''m using SQL Server 2005. My tables look roughly like this: CREATE TABLE USERS ( USR_ID VARCHAR(25) NOT NULL PRIMARY KEY, USR_PASS VARCHAR(25) ) CREATE TABLE
2004 Dec 01
1
rsync transfers whole content when a new hardlink is created
Hi, I detected a silly behaviour of rsync when new hardlinks of already synced files are created: Scenario: There are a local directory and a equal remote directory created by former run of rsync. Create a hardlink from a already existing file (both inside the local directory). If this hardlink has a filename with comes before the original filename when both are sorted in alphabetic order,