Search Results

Search found 12287 results on 492 pages for 'column oriented'.

Page 122/492 | < Previous Page | 118 119 120 121 122 123 124 125 126 127 128 129  | Next Page >

• 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 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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 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

• 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

• Find a column with specified text and then search rows for zero enries and delete whol reo if zero f

  - by total newbie

  I need a macro to do this please - any know where i can find one? Find a column with specified text and then search rows for zero enries and delete whole row if zero found

  Read the article

• oracle index for string column - does format of data affects quality of index?

  - by Jayan

  We have following type of "Unique ID" column for many tables in the database (Oracle). It is a string with following format <randomnumber>-<ascendingnumber>-<machinename> So we have some thing like this U1234-12345-NBBJD U1234-12346-NBBJD U1234-12347-NBBJD U1234-12348-NBBJD U1234-12349-NBBJD The UID value is unique, we have unique index on them. Does the following format is more efficient than above for index scans? NBBJD-U1234-12345 NBBJD-U1234-12346 NBBJD-U1234-12347 NBBJD-U1234-12348 NBBJD-U1234-12349

  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

• How can I convert this column value to an integer?

  - by Kevin

  My C# code looks like this: myNum = dt.Columns[0]; myNum is an integer and dt is a datatable. The value in column 0 of dt is a string ("12"), but I'd like to convert it to an integer. How can I do this? I've tried: myNum = int.Parse(dt.Columns[0]); ...but that doesn't work. Any ideas?

  Read the article

• How to remove the inner border from a certain column in a DataGrid?

  - by the_drow

  I have a DataGrid that needs to have the following borders: ------------------- | | | | |________| | | | | |________| | | | | |________| | | | ------------------- How do I set the border for a certain column and keep it for the rest of the datagrid? This is a windows app that uses winforms in C#.

  Read the article

• Multiple footer rows in a column of worksheet in excel.

  - by niveditha

  I need to have three rows within the footer section of a column while generating an excel worksheet... I wrote a code as follows I expected the output to be : Header cell 1 Footer 1 Footer 2 Footer 3 But I get the output as: Header cell 1 Footer 3 Please help me with this issue. Thank You in advance.

  Read the article

• NHibernate, updating a db column to a function call when persisting a domain object.

  - by Wyass

  I have a domain class that when persisted to Oracle must update a column to sysdate. NHibernate must only generate 1 SQL. e.g. update person set age = 12, stamp = sysdate where id = 1; Can this be done?

  Read the article

• mysql query to find every occurrence of a non-ascii character in a table column and replace it with

  - by Gaurav

  I have a column that contains HTML strings and has characters like ® and ™ in it. I want to replace all such characters with their HTML equivalent. Is this possible?

  Read the article

• In 64 bit systems, a 32 bit column occupies less space than a 64 bit one?

  - by estourodepilha.com

  In MySQL running on a 64bit OS, every column occupies at least 64 bits? A bit would occupy a whole byte? or a whole word?

  Read the article

• i want to add a column in my table.. can any body help me for that..

  - by Abid

  there is already some columns added in my table starsin.. i want to add a column address in my table starsin by using a query..

  Read the article

• How do I compare a DateTime column to now() in a query filter in SqlAlchemy?

  - by Ben

  I have a table with an 'expires' datetime column. I want to find all the items that have an 'expires' date earlier than now. I've tried session.query(Item).filter(Item.expires < now()) but it doesn't return anything regardless of the dates in the table. I'm using PostgreSQL 8.4. How do I do this comparison?

  Read the article

• How do I serve a large file using Pylons?

  - by Chris R

  I am writing a Pylons-based download gateway. The gateway's client will address files by ID: /file_gw/download/1 Internally, the file itself is accessed via HTTP from an internal file server: http://internal-srv/path/to/file_1.content The files may be quite large, so I want to stream the content. I store metadata about the file in a StoredFile model object: class StoredFile(Base): id = Column(Integer, primary_key=True) name = Column(String) size = Column(Integer) content_type = Column(String) url = Column(String) Given this, what's the best (ie: most architecturally-sound, performant, et al) way to write my file_gw controller?

  Read the article

< Previous Page | 118 119 120 121 122 123 124 125 126 127 128 129  | Next Page >