multiple-columns

Does making a primary key in multiple columns generate indexes for all of them?

If I set a primary key in multiple columns in Oracle, do I also need to create the indexes if I need them? I believe that when you set a primary key on one column, you have it indexed by it; is it the same with multiple column PKs? Thanks ...

How do I overflow the contents of a column into the next column using XSL-FO?

I have a table with three columns in which I'm trying to get some long paragraphs to flow dynamically from the first column into the second and then into the third. Currently, the table will continue on a next page when the first column overflows instead of moving into the second column and so I get several pages filled with only a singl...

DataSet and Primary Key with multiple columns

How Can I use Find method in DataSet that has Primary Key make of 3 Columns? dadSample.SelectCommand = New SqlCommand("SELECT * FROM StockBalance", conxMain) dadSample.FillSchema(dsSample, SchemaType.Source, "StockBalance") dadSample.Fill(dsSample, "Stock") Dim keyColStock(3) As DataColumn keyCol...

BindingSource.Find Multiple Columns

Is it possible to use the Find method of a BindingSource on multiple columns? For example, say I have a gridview displaying current pets; two comboboxes, cboPetType and cboGender; and a button to create a new record into the Pet table based on the values of these two comboboxes. Now, let's say I only want one of each PetType/Gender c...

mysql keyword search across multiple columns

Various incarnations of this question have been asked here before, but I thought I'd give it another shot. I had a terrible database layout. A single entity (widget) was split into two tables: CREATE TABLE widgets (widget_id int(10) NOT NULL auto_increment) CREATE TABLE widget_data ( widget_id int(10), field ENUM('name','size','color...

Sort multiple columns while using a bindingsource or bindinglist

Hi everyone. I have a problem I am trying to fix and it's sorting a DataGridView on multiple columns. I have read that this option is not a feature built-in the DataGridView and I have to implement it. I have found multiple solutions, but none quite got to do the work. I'm also quite a newbie in C# and I don't know much of the .Net lib...

How do I Put Several Select Statements into Different Columns

I basically have 7 select statements that I need to have the results output into separate columns. Normally I would use a crosstab for this but I need a fast efficient way to go about this as there are over 7 billion rows in the table. I am using the vertica database system. Below is an example of my statements: SELECT COUNT(user_id)...

Using subselect to accomplish LEFT JOIN

Is is possible to accomplish the equivalent of a LEFT JOIN with subselect where multiple columns are required. Here's what I mean. SELECT m.*, (SELECT * FROM model WHERE id = m.id LIMIT 1) AS models FROM make m As it stands now doing this gives me a 'Operand should contain 1 column(s)' error. Yes I know this is possible with LEFT JOI...

Is there a text editor that displays a file in more than one column

I have a wide screen and I would like to see the code I edit on multiple columns, like an article in a news paper. Ideally I would want the full screen filled with the content of the file I edit. I am not interested in displaying multiple views of the same file in multiple windows, that's a different feature. ...

CakePHP hasMany relationship with multiple columns

Hi, I am using CakePHP framework to build a web application. The simplest form of my problem is this: I have a users table and a messages table with corresponding models. Messages are sent from a user to another user. So messages table has columns from_id and to_id in it, both referencing to id of users. I am able to link Message model ...

Upper limit to number of columns I can JOIN two tables on in MySQL?

Is there a limit to the number of columns I can JOIN two tables on in MySQL? ...

Combobox with multiple columns

Scenario: I am in the process of moving an application from access to C# and on one of the forms(in access) the user is able to select a drop down that has 3 columns (ID, FirstName, LastName). Once they select from the list the ID is displayed on the drop down. Question: Is it possible to recreate this functionality using a combo box? W...

Listbox with multiple columns wpf

Hi All, I want to show multiple columns in the list box. I have referred the following link http://stackoverflow.com/questions/908089/using-wrappanel-and-scrollviewer-to-give-a-multi-column-listbox-in-wpf. Problem: I want to scroll the content using repeat button. How to control the listbox scrollbar using button. Code: <ListBox N...

Select two datacolumns from a datarow in linq (vb.net 3.5)

Dim orders = From tt In testTable _ Order By tt.Item("OrderNumber") _ Select tt.Item("OrderNumber"), tt.Item("OrderId") This is breaking. Is there a way to do this? I would have thought it was easy enough. Obviously, I thought wrong.... ...

NY Times Multiple Columns

hey guys... have you seen NY Times Editor's choice (on iPad) ?? .... so if you have .... i'm trying to make the same design (multiple columns in full article) .... how? through css3 , -webkit-columns-count , -webkit-columns-width and so forth.... but the problem is when i try to make an image span across 2 or more columns (this feature i...

creating a new variable using two columns when they satisfy certain conditions using R

Hi R experts, I am providing this example data to get my question across. aid=c(1,2,3,4,5,6,7,8,9,10) foson=c(0,1,2,0,6,9,0,0,3,0) fosof=c(0,0,2,3,0,0,0,5,0,0) data=data.frame(aid,foson,fosof) Now, I need to create a new variable (column) named data$hist with the following conditions: if foson==0 and fosof==0, then hist = 0; if foso...

join multiple fields to one table

I have 2 tables (there are more but un related to question) optionValue and productStock I want to get the option names from the optionValue table for each option1, option2, option3 (the query below will should help to make more sense) below is my attempt, the current query it only works if all options are set but is returns null if a...

MySQL join multiple columns from same table

Hi all I am trying to write a query that returns a users profile information, along with a count of occurrences of the user's ID in 2 columns from another table. An example below: TableA userID userName 1 UserA 2 UserB TableB LinkID leadID followID 1 1 2 2 1 3 3 2 1 Querying against...

if values of two columns are equal, change the value of resultant column to NA and if not keep to original value of resultant column - using R

Hi R users, This question is similar to the previous one. I am providing this example data to get my question across. id=c(1,2,3,4,5,6,7,8,9,10) var1=c(0,1,2,0,6,9,0,0,3,0) var2=c(0,0,2,3,0,0,0,5,0,0) var3=c(0,1,4,3,6,9,0,5,3,0) data=data.frame(id,var1,var2, var3) What I need is: if values of var1==var2, then make var3==NA but i...

nhibernate: many-to-one using multiple columns

So I have scavenged the internet for a while now and am still stumped on this current issue I am facing with nHibernate: I have two tables that I have mapping files for. Table A stores information about "Things", and Table B stores how these "Things" are related. The problem is as follows. Table A is mapped to the Thing class. Table B n...