Search Results

Search found 12215 results on 489 pages for 'identity column'.

Page 98/489 | < Previous Page | 94 95 96 97 98 99 100 101 102 103 104 105  | Next Page >

• SQL function to get count of how many times string appears in column?

  - by Kristopher Ives

  Is there a function for MySQL that will count the number of times a string occurs in another string or column? Basically I want: SELECT SUB_COUNT('my word', `my_column`) AS `match_count` FROM `table` Thanks!

  Read the article

• Show yes/no in bool column of gridview bound to datasource in Winforms?

  - by Carrie Nelson

  I have a gridview that is bound to a datasource (Windows Forms, VB.NET). One of columns is a property of type boolean, and I want to show "yes/no" in the column instead of 0/1 or "true/false". Is this possible? Can you edit displays of columns that are bound?

  Read the article

• How to merge two different child nodes in the same XML file

  - by user814698

  I have an XML file and I would like to merge two different CONTACT child nodes. I have checked these websites it shows how to merge two different xml files into a single file. http://www2.informatik.hu-berlin.de/~obecker/XSLT/#merge Merge XML documents In my case this is my first contact in the xml file: <CONTACT> <PDE-Identity>N65539</PDE-Identity> <FirstName>Arun_niit</FirstName> <LastName>Arun_niit</LastName> <Facebook-ID/> <EMAILS> <EMail> <Type>yahoo</Type> <Value>[email protected]</Value> </EMail> </EMAILS> </CONTACT> This is the second contact in the file: <PDE-Identity>N65567</PDE-Identity> <FirstName>Arun_niit</FirstName> <LastName>Ramanathan</LastName> <Facebook-ID/> <EMAILS> <EMail> <Type>gmail</Type> <Value>[email protected]</Value> </EMail> <EMail> <Type>yahoo</Type> <Value>[email protected]</Value> </EMail> </EMAILS> </CONTACT> <CONTACT> I know both of the contacts are belongs to the same person. How can i merge these two contacts in the same xml file. Original XML File: <?xml version="1.0" encoding="UTF-8"?> <CONTACTS> <CONTACT> <PDE-Identity>N65539</PDE-Identity> <FirstName>Arun_niit</FirstName> <LastName>Arun_niit</LastName> <Facebook-ID/> <EMAILS> <EMail> <Type>yahoo</Type> <Value>[email protected]</Value> </EMail> </EMAILS> </CONTACT> <CONTACT> <PDE-Identity>N65567</PDE-Identity> <FirstName>Arun_niit</FirstName> <LastName>Ramanathan</LastName> <Facebook-ID/> <EMAILS> <EMail> <Type>gmail</Type> <Value>[email protected]</Value> </EMail> <EMail> <Type>yahoo</Type> <Value>[email protected]</Value> </EMail> </EMAILS> </CONTACT> <CONTACT> <PDE-Identity>N65567</PDE-Identity> <FirstName>Rangarajkarthik</FirstName> <LastName>karthik Rangaraj</LastName> <Facebook-ID/> <EMAILS> <EMail> <Type>gmail</Type> <Value>[email protected]</Value> </EMail> <EMail> <Type>yahoo</Type> <Value>[email protected]</Value> </EMail> </EMAILS> </CONTACT> <CONTACTS>

  Read the article

• How to insert the column with data in between datatable ?

  - by Harikrishna

  I have datatable like : id name address --------------- 1 abc akjdk 2 bcd dkjkl Now I want to insert one column with data in between to that datatable like : id name phoneno address ----------------------- 1 abc 11231 akjdk 2 bcd 12313 dkjkl How can I do this ?

  Read the article

• How to apply formula to cell based on IF condition in Excel

  - by Captain Comic

  Hi I have an Excel spreadsheed like the one shown below A B 10.02.2007 10 10.03.2007 12 Column A is date and B is price of share Now in another sreadsheet I need to create a new column called return In this column i need to place formula like = ln(B2/B1) but on condition that this formula is only applied date in column A is in range StartDate < currentDate < EndDate. So I want to apply my formula only to specific period say only to 2007 year have new column placed in another spreadsheet starting from given location say A1 Please suggest

  Read the article

• Exporting each Excel column to individual text or csv files?

  - by powerofgrayskull

  I have an Excel worksheet with around 100 cols. Does anyone know of an easy way to write the contents of each column to a csv or txt file?

  Read the article

• How can i learn Table Name in database an column name?

  - by Phsika

  How can i learn table Name in database an how can i learn any Table's Column name? SELECT Col.COLUMN_NAME, Col.DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS AS Col LEFT OUTER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS Usg ON Col.TABLE_NAME = Usg.TABLE_NAME AND Col.COLUMN_NAME = Usg.COLUMN_NAME LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS Con ON Usg.CONSTRAINT_NAME = Con.CONSTRAINT_NAME WHERE Col.TABLE_NAME = 'Addresses_Temp' AND Con.Constraint_TYPE = 'PRIMARY KEY' But it returns to me empty data:(

  Read the article

• How to map a Entity Data Model conceptual model property to a storage model column using the "Serial

  - by codekaizen

  I have a conceptual model in EDM where one of the entities has a property which is essentially a big value object whose properties aren't really useful as columns in the datamodel. I'd like to apply the Serialized LOB pattern to it so that I can fit it into a 192 byte binary column. How do I map this in the EDM v4? Is it even possible at this time? Actually, is it possible in any ORM?

  Read the article

• How do you set a default value for a MySQL Datetime column?

  - by Brian Boatright

  How do you set a default value for a MySQL Datetime column? In SQL Server it's getdate(), what is the equivalant for MySQL? I'm using 5.x if that is a factor.

  Read the article

• DataGrid view inserting new row when filling column headers.

  - by fireBand

  DataGridView inserting an extra row every time I populate with data. The row appears even if I Only fill the column headers. This is causing problems when I try to get values of each cell. Is there a way to avoid this perhaps in properties? Thanks in advance for any suggestions.

  Read the article

• In Django, how do I set a unique on a columN?

  - by alex

  class Radio(models.Model): title = models.CharField(max_length=2000, blank=True, null=True) listeners = models.IntegerField(default = 0, blank=True, null=True) I don't want duplicate TITLE column. How do I set a unique key?

  Read the article

• is able to accommodate multiple data type in one column?

  - by Jothi

  hi, i have one problem that, i have to change type of data in column based on foreign key stored in that row. unit_id unit_name 1 String 2 Float 3 Date 4 Int Id spec value unit id 1 "A" 1 2 30.90 2 3 null 3 4 100 4 now i should achieve the above codition. how do i achieve it? please help me.

  Read the article

• Update column using rows of a table, without using cursor or any other iteration.

  - by Muhammad Kashif Nadeem

  Update Combined column using CategoryCode of every OrderId. In this example there are two OrderIds 990 and 986. Need to concatenate categories of these two individually. The desired result is like this. 990 Bus, Pub, Shoot, Club, Bus, Hos Thanks.

  Read the article

• How to get the Grid.Row Grid.Column from the selected added control?

  - by younevertell

  How to get the Grid.Row Grid.Column from the added control? Basically I have 16 grids with 4 rows and 4 columns, each grid is added a round button. how to determine which rows and columns the selected round buttons are located respectively in the below MouseEventHandler of mouseover? For mouseclick, there is only round button selected, but for mouseover, there would be a collection of buttons. RoundButton_MouseEnter, RoundButton_MouseLeave, RoundButton_MouseDown, RoundButton_MouseUp Thanks

  Read the article

• Use Awk to Print every character as its own column?

  - by wizkid84

  Hi there, I am in need of reorganizing a large CSV file. The first column, which is currently a 6 digit number needs to be split up, using comma's as the field separator. For example, I need this: 022250,10:50 AM,274,22,50 022255,11:55 AM,275,22,55 turned into this: 0,2,2,2,5,0,10:50 AM,274,22,50 0,2,2,2,5,5,11:55 AM,275,22,55 Let me know what you think! Thanks!

  Read the article

• Can I create a datetime column with default value in sqlite3?

  - by NobodyMan

  Is there a way to create a table in sqlite3 that has a datetime column that defaults to 'now'? The following statement returns a syntax error: create table tbl1(id int primary key, dt datetime default datetime('now'));

  Read the article

• How to I display a sort arrow in the header of a list view column using C#?

  - by Andrew Moore

  How can I display a sort arrow in the header of the sorted column in a list view which follows the native look of the operating system?

  Read the article

• Need VB code to paste an data retrived during runtime in QTP scipt in an column of an excel sheet.

  - by Sweety

  I am running a QTP script where a data is produced dynamically.I am retriving the data during runtime and then I need to paste that data in an excel sheet (in an column).Please suggest how to code it. Thanks for any help.

  Read the article

• Rails 3: How not to include column's name in a validation message without plugins ?

  - by Misha Moroshko

  I have the following validation: validates_presence_of :price, :message => "my message" and I get the following error when the price is blank: Price my message Is there a way not to include the column name (price) in the message ? I tried to do: validates_presence_of :price, :message => "^ my message" as suggested here, but it didn't work for me. I got the following message: Price ^ my message

  Read the article

• How do I find all "true" in a column and insert two rows above each found true?

  - by Justin

  AccountCode 01-80-07 03-24-00 True 03-24-00 03-69-00 04-16-00 True 04-20-00 04-21-00 05-99-00 True 07-01-00 True 07-01-00 07-10-00 07-10-00 94-40-95 True Does anyone understand what I need? Trues are in column B and each month there may be a different number of trues and different spacing between them.

  Read the article

• How do I layout my web page using CSS so that the right-hand column doesn't wrap?

  - by csells

  On most of my web site (http://sellsbrothers.com), the right-hand column where I keep the search bar and the ads stays on the right-hand side as I intended. However, on some pages (http://www.sellsbrothers.com/Posts/Details/12670), it doesn't. How do I fix the ones that don't? Thanks!

  Read the article

• MySQL Date_Format based on today's date and another column?

  - by JM4

  I am aware of the MySQL Date_Format function but am looking to achieve the following: I have on column with a day date in 2 digit format (01-30). I am trying to update another date formatted field with the current year, the next month (m+1) and the day field mentioned previously. In PHP i would do this using mktime function but this must be done using mysql calls only. Is it possible to transform in this way?

  Read the article

• MYSQL trigger to select from and update the same table gives error #1241 - Operand should contain 1 column(s)

  - by Bipin

  when i try to select and update the same table mysql gives error error #1241 - Operand should contain 1 column(s) The trigger is DELIMITER $$ CREATE TRIGGER visitor_validation BEFORE INSERT ON ratingsvisitors FOR EACH ROW BEGIN SET @ifexists = (SELECT * FROM ratingcounttracks WHERE userid=New.vistorid AND likedate=New.likevalidation AND countfor=New.likeordislike); IF (@ifexists = NULL) THEN INSERT INTO ratingcounttracks(userid, likedate, clickcount,countfor) values (New.vistorid, New.likevalidation ,'1',New.likeordislike); ELSE UPDATE ratingcounttracks SET clickcount=clickcount+1 WHERE userid=New.vistorid AND likedate=New.likevalidation AND countfor=New.likeordislike; END IF; END$$

  Read the article

• How can I change column length using HQL query?

  - by gmugmu

  I tried session.createSQLQuery("ALTER TABLE People MODIFY address VARCHAR(1000);").executeUpdate(); but this throws org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query After a lot of googling, the recommendation is to use HQL instead of SQL query to do bulk updates. Not sure how to use HQL to accomplish this. There seems to be no decent HQL documentation for updating column length in a table. Thanks so much for the help.

  Read the article

• Getting a date value in a postgres table column and check if it's bigger than todays date

  - by Roland

  I have a Postgres table called clients. The name column contains certain values eg. test23233 [987665432,2014-02-18] At the end of the value is a date, I need to compare this date, and return all records where this specific date is younger than today I tried select id,name FROM clients where name ~ '(\d{4}\-\d{1,2}\-\d{1,2})'; but this isn't returning any values. How would I go about to achieve the results I want?

  Read the article

< Previous Page | 94 95 96 97 98 99 100 101 102 103 104 105  | Next Page >