Search Results

Search found 30190 results on 1208 pages for 'table row'.

Page 163/1208 | < Previous Page | 159 160 161 162 163 164 165 166 167 168 169 170  | Next Page >

• mysql search number in table

  - by Sanjay

  hi, i am using php/mysql. i have a product table . in which most product have starting name with number. i want to listout all products start with any number. any one have idea about it....

  Read the article

• How do I customize a table view?

  - by Nathan

  Interface Builder Question I know there's a way to change the background color of a table, but is there a way to change the text color? Please Help

  Read the article

• free pivot table implementation for qt

  - by Michal Nowotka

  I'm looking for free implementation of pivot table view for Qt. Does someone know where to find such piece of code? Or maybe it's trivial to implement...

  Read the article

• what is an index in a table?

  - by Ramesh

  What is an index in table? Related with realworld entitly like librabry. what are the types of indexes? please related this too also with real world entity.

  Read the article

• Select distinct values from a table field

  - by alj

  I'm struggling getting my head around the Django's ORM. What I want to do is get a list of distinct values within a field on my table .... the equivalent of one of the following: SELECT DISTINCT myfieldname FROM mytable (or alternatively) SELECT myfieldname FROM mytable GROUP BY myfieldname I'd at least like to do it the Django way before resorting to raw sql.

  Read the article

• Determine Last Modification Datetime for an Azure Table

  - by embeddedprogrammer

  I am developing an application which may be hosted on a microsoft sql server, or on Azure SQL, depending upon the end user's wishes. My whole system works fine with the exception of some WCF functions which determine the last modification time of tables using the following technique: SELECT OBJECT_NAME(OBJECT_ID) as tableName, last_user_update as lastUpdate FROM mydb.sys.dm_db_index_usage_stats This query fails in Azure. Is there any analogous way to get table last modification dates from Azure's sql?

  Read the article

• Passing table data to PRPT from xaction

  - by Manoj

  I am getting data from a query and processing it using Javascript in the xaction file. Now I want to pass the processed data (a 2D array) down to a prpt where it will be used to generate graph and table. What is the format in which Javascript would generate the data and how is it passed to and received by the prpt file from the xaction. Thanks...

  Read the article

• I cannot get the value of a table view cell in cocoa touch

  - by Michael Amici

  I am trying to get the value of a cell in a table view but it won't let me. If someone could help that would be great. int numberOfChecks = -1; numberOfChecks = numberOfChecks +1; if ([objectsForTable count]-1 >= numberOfChecks) { UITableViewCell *cell = [self.tableView cellForRowAtIndexPath:numberOfChecks]; NSString *cellTitle = cell.textLabel.text; }

  Read the article

• how to generate primary key values while inserting data into table through pl/sql stored procedure

  - by thulasi policherla

  hi friends, I am trying to insert data into particular table through pl/sql stored procedure,my requirement is while inserting i should generate PRIMARY KEY values for particular column and also i should return that PRIMARY KEY value to output and one more thing is that for another column i should validate my string such that it should contain only characters not integers. please help me in writing code for the above requirement Thanks and regards thulasi policherla

  Read the article

• select distinct col1 with min(col2) and max(col3) from table

  - by user338804

  My table looks like this with duplicates in col1 col1, col2, col3, col4 1, 1, 0, a 1, 2, 1, a 1, 3, 1, a 2, 4, 1, b 3, 5, 0, c I want to select distinct col1 with max (col3) and min(col2); so result set will be: col1, col2, col3, col4 1, 2, 1, a 2, 4, 1, b 3, 5, 0, c I have a solution but looking for best ideas?

  Read the article

• Query for retrieving top two rows from a table in SQL Server

  - by Praveen

  Hi All, I have a table called Employee with EmpID,Salary,Name fields. I want to get top two employees with maximum salary. How can i write this query ?

  Read the article

• Setting column width in Table View

  - by Jeremy

  I am having a hard time understanding how to change the width of columns when creating a table view. I know you can set the width in pixels of a column but that is not what I want to do. Say, for instance, I have 2 columns and want each column to take up half the screen. How do I do this without explicitly setting the pixels, so that my code can work on multiple screen sizes?

  Read the article

• Taking backup of data in a table.

  - by Rishabh Ohri

  Hi All, Is there some way to backup the data in a table in sql server by using sql scripts. Note: I dont want to take the backup of the whole database. And later on restore the same data back in case of any failure. Please suggest some solution.

  Read the article

• MYSQL updating data from other table

  - by atif089

  Hi, I have two tables like of this structure content (content_id, content_type, user_id, time, comment_count) comments (comment_id, content_id, userid, comment, comment_time) What I wold like to do is update the comments_count field with sum of comments i.e COUNT(content_id) from the comments table. I am not able to figure out the right syntax Thanks

  Read the article

• Nth Largest element from a table sql Query

  - by Binu

  can any one explain hiow this query works..It's for getting the Nth largest elemet from a table.here it's 4 th largest SELECT a.ID FROM tblitem a WHERE (4) = (select count(*) from tblItem b where b.id < a.id) Thanks in advance

  Read the article

• SQL Server: how to create multiple text files from a table

  - by Patrick

  hi, I need to extract data from my SQL Server database into multiple text files. I have a table with 4 columns: UserID, UserName, Tag, Score. I need to create a text file for each Tag (so basically I need to group by Tag and order by score). Before to start I would like to know what's the fastest way to create several text files: File titles = TAG field each line = userID

  Read the article

• Change the Default Size of the filterBy text box in Rich Table

  - by Nisansala

  How can I change the Default Size of the filterBy text box in Rich Table? In all the columns, it has a same (fix) size. I used the property width, but it didn't work.

  Read the article

• Transfer table from one database to another?

  - by Mahmoud

  Hey all i am working at my project where it collects information from two database, one is supplied by the program lets name it DB Y and the other supplied by the user lets name it DB X , now i have an query that depends on companies which is on DB x so i want to transfer this table from DB x to DB y at run time and also checks if there is new updates in DB x and transfer them but i am confused

  Read the article

• New table for every user?

  - by SonOfOmer

  Hi everyone, I want to crate new table for each new user on the web site and I assume that there will be many users, I am sure that search performance will be good, but what is with maintenance?? It is MySQL which has no limit in number of tables. Thanks a lot.

  Read the article

• MySQL function to compare values in a db table against the previous

  - by Stuart

  Iam quite new to functions in SQL and I would like to create a function to compare values in a MySQL table against previous and I am not sure how to do this. For example (iId is the input value) DECLARE pVal INT(20); DECLARE val INT(20); SELECT price INTO pVal FROM products WHERE Id=iId; SELECT price FROM products; IF price == pVal THEN SET val = price; END IF; Thanks

  Read the article

• 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

• GDI+ Problem drawing a table

  - by Emanuel

  I try to draw a table on a panel in C# Windows Form by using GDI+. The problem is that when I minimize the application, my drawing disappears. How can I avoid this and why acting this way?

  Read the article

• Hash Table v/s STL map in C++

  - by anon

  Hi, I am trying to learn C++ maps. Was just wondering about the implementation of STL map. I read it employs Binary search tree. Is there a implementation of hash table in STL? How exactly do STL map stores Key Value pairs?

  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

• Scripting all the constraints and indexes without the create table statement

  - by Ice

  Hi there, How to get a script for all tables about all default constraints and indexes from an existing database? SQL Server Management Studio produces SQL-Scripts with the create table statements and there is no option to dismiss it. Peace Ice

  Read the article

< Previous Page | 159 160 161 162 163 164 165 166 167 168 169 170  | Next Page >