Search Results

Search found 16978 results on 680 pages for '80 column'.

Page 103/680 | < Previous Page | 99 100 101 102 103 104 105 106 107 108 109 110  | Next Page >

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Can I really have just one column in UITableView?

  - by mystify

  From the docs: A table view in the UIKit framework is limited to a single column because it is designed for a device with a small screen.

  Read the article

• In SQL Server, how can I insert data into a table that has just one column which is of identity type

  - by Yousui

  In SQL Server, how can I insert data into a table that has just one column which is of identity type? Such as insert into the following table t. How can I write the insert statement? CREATE TABLE t ( id INT IDENTITY(1, 1) PRIMARY KEY ) Great thanks.

  Read the article

• Is there a decent technique for SSIS Derived Column date formatting?

  - by theog

  I just had to write the most redonkulous expression in an SSIS Derived Column to get dates formatted like "01-JAN-2010".  It lookes like this:        There's got to be a better way... isn't there?

  Read the article

• How do I drop 'NOT NULL' from a column in MySQL?

  - by Will

  A show create table command shows the following: 'columnA' varchar(6) NOT NULL DEFAULT ''; How do I modify that column so that the not null is removed? I need it to be: 'columnA' varchar(6) DEFAULT NULL; I thought the following would work, but it has no effect: ALTER TABLE tbl_name MODIFY columnA varchar(6) DEFAULT NULL;

  Read the article

• How I can set a column value for all my rows that already exist in the database with some sort of my

  - by zeckdude

  I want to set the value of the column 'character_hold' to 'no' for all my rows in my MYSQL database. Is there a SQL statement I can use in phpmyadmin to set them all to 'no'?

  Read the article

• How can I query all rows that are currently before data specified in one column in table?

  - by newbie

  I need to get all rows tha are valid, ValidDate is column that shows how long these database items are valid. I need to get only valid items from the database. How can I do that? I use SQL Server.

  Read the article

• How can I add a column to this union result?

  - by MrXexxed

  I have this query (which I removed some keys from for brevity's sake): SELECT id as in_id, out_id, recipient, sender, read_flag FROM received WHERE recipient=1 UNION ALL SELECT in_id, id AS out_id, recipient, sender, read_flag FROM sent WHERE sender=1 Which combines the results from two tables showing messages sent and received by a given user. What I'd like to do is add a column/flag to the result to distinguish which table the row belongs to so when I display them I can show a relevant icon for sent or received messages. How would I add this?

  Read the article

• Decrypting an AES encryted column in mysql and adobe flex/flash builder?

  - by user345593

  How do i decrypt an aes encryted column when using flash/flex to display the table data? adobe flex connected using php connection class to mysql for php, we would use aes_decrypt() however i am not sure how i can get flex to do this.

  Read the article

< Previous Page | 99 100 101 102 103 104 105 106 107 108 109 110  | Next Page >