Search Results

Search found 10424 results on 417 pages for 'persisted column'.

Page 256/417 | < Previous Page | 252 253 254 255 256 257 258 259 260 261 262 263  | Next Page >

• 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

• VB Script enables multiple inserts into Access database table

  - by bachchan

  I added another column (Leave) I inserted a response.redirect but commented out two lines of code. Those two lines validate the form if sections are not entered/selected. This too should function without issue.

  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

• How to calculate "holes" in timetable

  - by genesiss

  I've got a 2-dimensional array like this (it represents a timetable): http://www.shrani.si/f/28/L6/37YvFye/timetable.png Orange cells are lectures and whites are free time. How could I calculate number of free hours between lectures in the same day? (columns are days and rows are hours) For example, in this table the result should be: 2 for first column 0 for second colum -- The function returns 2 (because 2+0=2)

  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 there a 'RowSpan = "All"' in WPF

  - by Chris Spicer

  Take for the following for example: <GridSplitter Grid.Row="0" Grid.Column="1" Background="Yellow" HorizontalAlignment="Stretch" VerticalAlignment="Stretch" Width="Auto" Height="Auto" Grid.RowSpan="3" ResizeDirection="Columns etc etc This will create a GridSplitter across the 3 rows that I have in my grid. However, it's conceivable that I might add another row to my grid at a later stage, and I don't really want to go back and have all of my rowspans. My first guess was Grid.RowSpan="*", but that doesn't compile. Does anyone know the answer to this off hand?

  Read the article

• 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

• Unserialize data and check it against an id in MySQL

  - by kylex

  I have a row of IDs in a database that has been serialized. What I'm trying to do is check those serialized IDs against a known ID to see if it should be excluded or not. for example: "SELECT * FROM mydb WHERE id = 4 AND checkID != 'an id in the serialized column' " What's the best way to go about this?

  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

• 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

• 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

• Hibernate many-to-one - bad usage?

  - by DaveA

  Just trying out Hibernate (with Annotations) and I'm having problems with my mappings. I have two entity classes, AudioCD and Artist. @Entity public class AudioCD implements CatalogItem { @Id @GeneratedValue(strategy = GenerationType.AUTO) private int id; private String title; @ManyToOne(cascade = { CascadeType.ALL }, optional = false) private Artist artist; .... } @Entity @Table(uniqueConstraints = { @UniqueConstraint(columnNames = { "name" }) }) public class Artist { @Id @GeneratedValue(strategy = GenerationType.AUTO) private int id; @Column(nullable = false) private String name; ..... } I get AudioCD objects from an external source. When I try to persist the AudioCD the Artist gets persisted as well, just like I want to happen. If I try persisting another different CD, but Artist already exists I get errors due to constraint violations. I want Hibernate to recognise that the Artist already exists and shouldn't be inserted again. Can this be done via annotations? Or do I have to manage the persistence of the AudioCD and Artist seperately?

  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

• 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

• Migrate MySQL database to Sql Server

  - by RPK

  I recently encountered a problem in my production database due to MySQL bug. The bug is in the TimeStamp column. To avoid any inconvenience, I want to migrate the database to either Sql Server. Is there any FREE tool to easily and reliably migrate data and table structures?

  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

• 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

• 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

• 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

• C#:checking existing record in database Mysql

  - by Meko

  HI.I searched this question inform and I found solution to change column property Unique Index.Now If I try to insert same record cmd.ExecuteNonQuery() gives error that record exist ,but how can use this exception to give user a message that record exist and must enter new one ? I am trying to make some thing like if(cmd.ExecuteNonQuery() !=true ) { MessageBox.Show("User Exists"); } But I dont know what returns cmd.ExecuteNonQuery() ? Or I must get records using reader in table and compare them with text in Textfiel?

  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

• 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

< Previous Page | 252 253 254 255 256 257 258 259 260 261 262 263  | Next Page >