Search Results

Search found 6257 results on 251 pages for 'columns'.

Page 133/251 | < Previous Page | 129 130 131 132 133 134 135 136 137 138 139 140  | Next Page >

• Naming of boolean column in database table

  - by Space Cracker

  I have 'Service' table and the following column description as below Is User Verification Required for service ? Is User's Email Activation Required for the service ? Is User's Mobile Activation required for the service ? I Hesitate in naming these columns as below IsVerificationRequired IsEmailActivationRequired IsMobileActivationRequired or RequireVerification RequireEmailActivation RequireMobileActivation I can't determined which way is the best .So, Is one of the above suggested name is the best or is there other better ones ?

  Read the article

• Django - 2 fields unique together

  - by webvulture

  Suppose, I want to record say poll choices by users everyday. In this case, i have a table named vote which has columns poll , choice and user-id . So how can i out the constraint (maybe in the django models or wherever possible) that poll and user-id both should not be the same for any entry but like the same user can vote for various different polls once and obviously various users can vote for the same poll. I hope I am clear.

  Read the article

• How to access Excel Max Column value?

  - by Phsika

  i try to create table from excel rows. however; excel columns : column1 has max 200 character row column2 has max 300 character row column3 has max 500 character row So i need to create sql create MyTable column3 nvarchar(500) according to Excel Max Character.

  Read the article

• How efficient is a details table?

  - by Jeffrey Lott

  At my job, we have pseudo-standard of creating one table to hold the "standard" information for an entity, and a second table, named like 'TableNameDetails', which holds optional data elements. On average, for every row in the main table will have about 8-10 detail rows in it. My question is: What kind of performance impacts does this have over adding these details as additional nullable columns on the main table?

  Read the article

• how to insert a jpeg image into an excel sheet

  - by Shiny

  Im able to generate tables with all required columns and with datas in excel sheet. now i want to insert image that is present in my bin.how can i achieve this. thanks in advance

  Read the article

• SQL Server 2008 management studio drop tables warning?

  - by Curtis White

  Why does SQL server 2008 always warn about needing to drop tables to rename columns? I was under impression this was not required unless it was a key. If I change a column from null to not null even if is not a key field it wants to drop table and all relations.

  Read the article

• swing layout: vertical flow

  - by pstanton

  Hi All, What LayoutManager should I use to achieve a transposed version of FlowLayout? Essentially, I want a vertical list which occupies multiple columns if it can't fit all of it's components within one column. +------------------------+ | item 1 | | item 2 | | item 3 | | item 4 | | item 5 | | item 6 | | item 7 | | item 8 | +------------------------+ or +------------------------+ | item 1 item 7 | | item 2 item 8 | | item 3 | | item 4 | | item 5 | | item 6 | +------------------------+

  Read the article

• Evaluate column value into rows

  - by Hugo Palma

  I have a column whose value is a json array. For example: [{"att1": "1", "att2": "2"}, {"att1": "3", "att2": "4"}, {"att1": "5", "att2": "6"}] What i would like is to provide a view where each element of the json array is transformed into a row and the attributes of each json object into columns. Keep in mind that the json array doesn't have a fixed size. Any ideas on how i can achieve this ?

  Read the article

• SQL-wrappers (activerecord) to recommened for python?

  - by Horace Ho

  is there an activerecord (any similar SQL-wrapper) for python? which is good for: used in a server-side python script light-weight supports MySQL what I need to do: insert (filename, file size, file md5, the file itself) into (string, int, string, BLOB) columns if the same file (checksum + filename) does not exist in db thx

  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

• How to add a property table to a form in Visual Studio?

  - by roddik

  Hi. I don't have much experience with C# or VS, but I want to add a property table to a form, like this one: So that columns are resizable, editable, of different types (e.g. checkbox for boolean) and sortable. How do I do that?

  Read the article

• Django - Add rows to MySQL database

  - by yeenow123

  So I already have a database setup with a few columns and a few rows already inserted in. I'm trying to create a view that you would just input information into a form and press Submit, then a row would be added to the MySQL database with the information you just typed in. I believe you can do this with admin, but I would like to try without admin and I'm not sure if this is possible? I've been using the MySQL commandline to add rows as of now..

  Read the article

• Can MySQL do row level security or what Oracle calls virtual private databases?

  - by JavaRocky

  Does MySQL have any equivalent feature to Oracle's virtual private databases in 10g. It is also known as row level security. I prefer not to implement anything like columns and triggers. I am looking for a solution similar to Oracle's.

  Read the article

• Find all the varchar() fields in sql server?

  - by JD

  Hi, Is it possible to find all the varchar() columns in my database? I am using SQL Server 2008 and would like to get the list in SQL server management console. JD.

  Read the article

• DISTINCT clause in SQLite

  - by Eye of Hell

  Hello. Recently i found that SQLite don't support DISTINCT ON() clause that seems postgresql-specific. For exeample, if i have table t with columns a and b. And i want to select all items with distinct b. Is the following query the only one and correct way to do so in SQLite? select * from t where b in (select distinct b from t)

  Read the article

• how to create table which has a column from another table in mySQL

  - by dexter

  i want to create a table : products which looks like (these are columns name) Id Name Category-id Description now Category-id column gets the values from another table category which looks like Id Name Description now category.Id is used in products.Category-id how to do this in mySQL

  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

• jquery column values on click..

  - by rockers

  Hello all, I have a table with 5 columns,,when I click on first column on the row i need to get the all column row values using jquery? Thanks

  Read the article

• Getting a count of users each day in Mondrian MDX

  - by user1874144

  I'm trying to write a query to give me the total number of users for each customer per day. Here is what I have so far, which for each customer/day combination is giving the total number of user dimension entries without splitting them up by customer/day. WITH MEMBER [Measures].[MyUserCount] AS COUNT(Descendants([User].CurrentMember, [User].[User Name]), INCLUDEEMPTY) SELECT NON EMPTY CrossJoin([Date].[Date].Members, [Customer].[Customer Name].Members) ON ROWS, {[Measures].[MyUserCount]} on COLUMNS FROM [Users]

  Read the article

• Create comma separated string from 2 lists the groovy way

  - by Micor

  What I have so far is: def imageColumns = ["products_image", "procuts_subimage1", "products_subimage2", "prodcuts_subimage3", "products_subimage4"] def imageValues = ["1.jpg","2.jpg","3.jpg"] def imageColumnsValues = [] // only care for columns with values imageValues.eachWithIndex { image,i -> imageColumnsValues << "${imageColumns[i]} = '${image}'" } println imageColumnValuePair.join(", ") It works but I think it could be better. Wish there was a collectWithIndex ... Any suggestions?

  Read the article

• mysql: inserting data and autoincrement

  - by every_answer_gets_a_point

  i am converting from access to mysql i have a table in access where one of the columns is an autonumber when i transfer the data into the mysql database (where i also have a column that is auto_increment), should i be transfering the auto_increment data into the auto_increment column, or will it auto_increment itself? how do i ensure that if i do not transfer the autoincrement data from access, that it auto_increments properly?

  Read the article

• How can i create a context menu in c# in a datagridview

  - by lanoxx

  Hi all, I have written a datagridview with a couple of columns to store data of a product, now i want to be able to right click any row and have a context menu appear with the options delete and copy. Copy should have the same functionality as if I press Ctrl+C. Any help would be appreciated. Im using C# and WinForms. I have never done context menus before, so I would be thank full for any hint or link to further readings. Cheers

  Read the article

• MySQL: Update table column from subquery result

  - by Jhourlad Estrella

  On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!

  Read the article

• DataGridView formatting

  - by Vadim

  I have a DGV with columns "code" and "name". Depends of lenght of a code I want to add tabulation to the "name" cells, to show structure of a data. Like that in this picture: How is it better to do? I think there is a better way then just loop for all rows and add spaces in front of names, right?

  Read the article

• How can I make the Entity data model designer use my database column descriptions?

  - by Jack

  I am using EF4 with Visual Studio 2010. I have a SQL database already created and all my columns are documented with the Description property in SQL management studio. When I create the edmx in Visual Studio, how can I make it read those descriptions and use them to add comments to my generated classes? I know I can use the Summary and LongDescription in the edmx properties but I'm looking for a way to do this without having to copy and paste every description. Thanks!

  Read the article

< Previous Page | 129 130 131 132 133 134 135 136 137 138 139 140  | Next Page >