Search Results

Search found 10060 results on 403 pages for 'column'.

Page 244/403 | < Previous Page | 240 241 242 243 244 245 246 247 248 249 250 251  | Next Page >

• Joining tables 3 level deep using Alias in Hibernate Criteria

  - by chrismathew

  4 tables. table 1 mapped to table 2 mapped to table 3 mapped to table 4. I want to get a column data from table 4, in my search criteria for table 1 object. Is it possible using Alias. Is there any way using any API of Hibernate Criteria to get table 4 data in table 1 object using search criteria.

  Read the article

• Python: Comparing specific columns in two csv files

  - by coder999

  Say that I have two CSV files (file1 and file2) with contents as shown below: file1: fred,43,Male,"23,45",blue,"1, bedrock avenue" file2: fred,39,Male,"23,45",blue,"1, bedrock avenue" I would like to compare these two CSV records to see if columns 0,2,3,4, and 5 are the same. I don't care about column 1. What's the most pythonic way of doing this? EDIT: Some example code would be appreciated.

  Read the article

• How does Zend_Db_Table_Select work?

  - by jwhat

  I'm trying to figure out how to use Zend_Db_Table_Abstract correctly. I want to return just the name column from my query. Can you please explain what's wrong with the following code? class Model_DbTable_Foo extends Zend_Db_Table_Abstract { protected $_name = 'foo'; public function getFooById($id) { $select = $this->select(true)->columns('name')->where('id=' . $id); $row = $this->fetchRow($select); print_r($row->toArray()); } }

  Read the article

• how to place a button within a table in Java ?

  - by trinity

  Hi all , In the properties windows , we come across buttons in a table cell < as in font property's row , a button can be clicked on to set font properties . Is there a way to insert a button in a Jtable 's second column < which i've created using netbeans .. how to do that , if it is possible ?

  Read the article

• setup format for columns of DataTable or GridView

  - by ncdy

  How can I setup some format for cells in some column in my DataTable or GridView ? I need to make some double columns rounded , for example : 3.564643 - 3.56 3.546723 - 3.55 6.654644 - 6.65 thank you.

  Read the article

• Is relative positioning the ultimate alternative for the nightmare of writing thousands of IE hacks?

  - by janoChen

  I found this very interesting: http://matthewjamestaylor.com/blog/ultimate-3-column-holy-grail-pixels.htm He avoid using horizontal margin and paddings to avoid problems with IE. I think he "fakes" padding using relative positioning. Have you ever done something like this? I'm a missing a common trend against IE hacks? Does this practice have any drawbacks?

  Read the article

• Data validation in cell of datagridview control

  - by Yogi

  I am using datagridview control and in this grid user can edit the value of a fixed column. i want user only can write numaric values (e.g. 1, 2, 443 etc) I am not sure at which event of datagridview i have to write this code and what is the code to trap values

  Read the article

• How to switch from VARCHAR to TEXT in SQL 2000?

  - by MatthewMartin

  What do I need to consider before I switch a bunch of fields from VARCHAR(bignumber) to TEXT? Aside from performance, and sometime in the far future TEXT will be deprecated, and aside from the fact that it looks like I need to drop and recreate the table to alter the column's data type? This is for SQL 2000-- I can't do VARCHAR(max) and VARCHAR(8000) isn't large enough.

  Read the article

• Is it bad to have a non-clustered index that contains the primary key from the clustered index?

  - by Don

  If you have a table with a clustered index on the Primary Key (int), is it redundant and bad to have one (ore more) non-clustered indexes that include that primary key column as one of the columns in the non-clustered index?

  Read the article

• mysql multi count() in one query

  - by atno

  Hi, I'm trying to count several joined tables but without any luck, what I get is the same numbers for every column (tUsers,tLists,tItems). My query is: select COUNT(users.*) as tUsers, COUNT(lists.*) as tLists, COUNT(items.*) as tItems, companyName from users as c join lists as l on c.userID = l.userID join items as i on c.userID = i.userID group by companyID The result I want to get is --------------------------------------------- # | CompanyName | tUsers | tlists | tItems 1 | RealCoName | 5 | 2 | 15 --------------------------------------------- what modifications do i have to do to my query to get those results? Cheers

  Read the article

• Parsing Tabular cell data with space where there is td tag.

  - by Harikrishna

  I am parsing html tabular information with the help of the html agility pack. Now First I am finding the rows in that table like var rows = table.Descendants("tr"); then I find the cell data for each row like foreach(var row in rows) { string rowInnerText = row.InnerText; } That gives me the cell data.But with no spaces between them like NameAdressPhone No but I want the innertext like Name Address Phone No means where there is td tag I want to keep there one space between different column cell.

  Read the article

• SQL swap field values

  - by Silence

  I have a SQL table (MYSQL 4.0 to be precise) composed of the following : int no (primary) int field1 int field2 I would like to swap the values of field1 with the values of field2 and vice-versa. Ex.: 1;2.5;3.76 becomes 1;3.76;2.5 I need a swapping temporary variable of some sort. But I don't think I can use something like Set @var1 = field1 inside my update statement. And I don't think altering the table to add a temporary column is my best best either.

  Read the article

• Help with SQL query in C#

  - by DanSogaard

  I'm trying to rename the columns. The syntax should be the column name between double quotes incase of two words, like this: SELECT p_Name "Product Name" from items So I'm trying to do it in C# code like this: string sqlqry1 = "SELECT p_Name \"Prodcut Name\" from items"; But I get an error: Syntax error (missing operator) in query expression 'p_Name "Prodcut Name"'. It seems am having somthing wrong with the quotes, but I can't figure out.

  Read the article

• How to Auto-Increment Non-Primary Key? - SQL Server

  - by user311509

  CREATE TABLE SupplierQuote ( supplierQuoteID int identity (3504,2) CONSTRAINT supquoteid_pk PRIMARY KEY, PONumber int identity (9553,20) NOT NULL . . . CONSTRAINT ponumber_uq UNIQUE(PONumber) ); The above ddl produces an error: Msg 2744, Level 16, State 2, Line 1 Multiple identity columns specified for table 'SupplierQuote'. Only one identity column per table is allowed. How can i solve it? I want PONumber to be auto-incremented.

  Read the article

• R - indirectly calling a matrix using a string

  - by Boris Senderovich

  Example: There is a matrix of data called VE There is a vector of string where the first element is the string VE. I need to indirectly call the string and be able to access data. For example if I need the 6th column of matrix VE then I want to do: Vector[1][,6] Essentially I need R to start reading those string as if they are the matrix names that are already in this page. I need this syntax to be dynamic because I am putting it in a loop.

  Read the article

• Hibernate Annotation (Pyramid Structure - same table)

  - by fatnjazzy

  Hi, I have a person table that contains the following fields: id, name, parent_id. the parent_id is actually a FK for column id. the data should look like this (Like a pyramid): "id" "name" "parent_id" "1" "I am the Top Father" "1" "2" "My Father Is 1" "1" "3" "My Father Is 2" "2" "4" "My Father Is 2" "2" How is my bean suppose to look like? Thanks

  Read the article

• query multiple tables and combine results into one return table for stored procedure?

  - by Shawn

  I have several different tables, but they all have 2 columns that are the same name. I want to write a stored procedure that searches one column in all of the tables and returns the result. Ideas? I'm fairly nub when it comes to SQL.

  Read the article

• How to store data with N columns

  - by iconiK

  I need a way to store an int for N columns. Basically what I have is this: Armies: ArmyID - UINT UnitCount1 - UINT UnitCount2 - UINT UnitCount3 - UINT UnitCount4 - UINT ... I can't possible add a column for each and every unit, so I need a fast way to store the number of each units in an army (you might have guesses it's for a game by now). Using XML is not an option as it will be dead slow.

  Read the article

• In NHibernate (Fluent), How do you map a property on referenced object into parent object?

  - by JChristian

  I want to map the Name column from the Child table into the Parent object. How do you do this (using Fluent NHibernate)? public class Parent { public int Key { get; set; } public string ChildName { get; set; } } Tables +--------------+ +------------------+ | Parent | | Child | +--------------+ +------------------+ | Key INT | +--->| Key INT | | ChildKey INT |-----+ | Name VARCHAR(20) | +--------------+ +------------------+

  Read the article

• Passing parameter from one user control to another user control in an aspx page.

  - by AJ

  Hi I have two user controls on one aspx page. UC1 has a grid which contains a link button column which user clicks. Based on the value of clicked cell, I need to show some data into UC2. How do I pass data from UC1 to UC2? How do I invoke a function of UC2 from UC1? Please advise. Thanks AJ

  Read the article

• google app engine application

  - by megala

  Hi, I create one application in ecllipse.That application contains the coding to create table in google app engine datastore.(i.e)Google Big table.In that application a created two table .After that i deployed the application.My constraints is ,is it possible to create a new table after depolyment the project and is it possible to create new column in already exits table. Thanks in advance

  Read the article

• mysql category tree search

  - by ffffff

  I have the following schema on MySQL 5.1 CREATE TABLE `mytest` ( `category` varchar(32) , `item_name` varchar(255) KEY `key1` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; category column is filled with like that [:parent_parent_cat_id][:parent_cat_id][:leaf_cat_id] "10000200003000" if you can search all of the under categories :parent_parent_category_id SELECT * FROM mytest WHERE category LIKE "10000%"; it's using index key1; but How to use index when I wanna search :parent_cat_id? SELECT * FROM mytest WHERE category LIKE "%20000%"; Do you have a better solutions?

  Read the article

• How to insert manual line breaks inside LaTeX tables ?

  - by ssn

  I know that if you define a width in a table's column, you can get automatic word-wrapping. However, I need to control where newlines should happen in a specific table cell. Thus, how can I insert manual line breaks in a LaTeX table cell?

  Read the article

• Is it possible to Load hbm.xml info at app startup instead of via an embedded resource?

  - by Daniel Auger

  All of the NHibernate examples I've see that use hbm files have the hbm.xml file set as an embedded resource with "do not copy" chosen in the file properties. This means that if a database column name were to change in production, the app would have to be recompiled with the changes in the hbm.xml file during build time. Is there any way to make NHibernate load the hbm.xml files from the file system at application startup instead of using an embedded version?

  Read the article

• How to sort Current Page Rows of Gridview only in asp.net?

  - by Vamshi

  Hi! I have a requirement that, I have a GridView with paging, which has 5 pages. If i click on any column then rows present in current Pages have to Sort. If i navigate to other row i need to display as it is. This should developed in ASP.NET using C# Please help me. Thank You..............

  Read the article

< Previous Page | 240 241 242 243 244 245 246 247 248 249 250 251  | Next Page >