Search Results

Search found 6532 results on 262 pages for 'computed columns'.

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

• Zend Framework PDF to excel type

  - by Uffo

  How can I make something like this with Zend_PDF: I have a few columns A, B, C, D, E and after them I will have some information, something like excel. A | B | C | D ss|das|dad|ds ss|das|dad|ds ss|das|dad|ds How can I create something like this with ZF_pdf? I will pull the data from DB, can you please give me an example?

  Read the article

• Sql query to get this result..

  - by bala3569

  Consider i have a user table and i have three columns mobilePhone,homePhone and workPhone... I have to select homePhone for every user as first pref if there is no value i ll go for mobilePhone and if there is no value for it i ll go for workPhone.... Any suggestion how it can be done in mysql..

  Read the article

• Latex: index of symbols

  - by Daniel

  I want to create an index of symbols or notation, similar to the usual index one obtains with makeindex. I have gotten this to work, using the glossaries package. However, just as in the usual index, I would like to get two columns in the index of symbols, while glossaries puts everything under each other. Commands like twocolumn or multicol also do not work, because then the second column starts higher than the first, above the title of the index of symbols. Any suggestions?

  Read the article

• Are there any modeling tools that can visually generate jpa or sql queries?

  - by Shervin

  Does anyone know of a tool like PowerArchitect or SquirrelSQL or maybe eclipse plugin that lets you also generate jpa/sql queries? Imagine you choosing your database, or your entity beans, and the modeling would reverse engineer your database/entity model, so that you could visually just choose the columns you wanted to select, and it would generate jpa or sql queries for you. For instance choosing A.b and X.y would generate something like this: select a.b, x.y from A a, X x join ......

  Read the article

• How to Update the primary key of table which is referenced as foreign key in another table?

  - by Mobin

  Suppose a Table "Person" having columns "SSN","Name","Address" and another Table "Contacts" having "Contact_ID","Contact_Type","SSN"(primary key of Person) similarly Table "Records" having "Record_ID","Record_Type","SSN"(primary key of Person) Now i want that when i change or update SSN in person table that accordingly changes in other 2 tables. If anyone can help me with a trigger for that Or how to pass foreign key constraints for tables

  Read the article

• CSS ul userlist formatting

  - by Titan

  Hi, I am trying to break away from using tables in my formatting, and am trying out using userlist html tags <ul> Say I have a panel with 10 controls, and I want a 3 columns display, therefore 3 controls in each row, and a total of 4 rows for 10 controls. Should I use 4 different <ul> or should I just stack them inside one <ul> Please tell me the advantages and disadvantages Thanks

  Read the article

• Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column

  - by AJM

  I’ve been trying to understand some strange values in the RESOURCE_ASSOCIATED_ENTITY_ID column of SYS.DM_TRAN_LOCKS when RESOURCE_TYPE is “OBJECT”. Although these should be object Ids, I cannot determine what object they actually refer to. I’ve tried everything I can think of, including querying all system tables with columns of type INT and BIGINT to see if I can find the value. No luck. The funny values actually appear in SYS.DM_TRAN_LOCKS, SYS.SYSLOCKINFO and SP_LOCK.

  Read the article

• How to push the right side elements to the top

  - by Blankman

  I have 2 columns, one of them I float to the left and the other I float to the right. The right side has input buttons on them. For some reason the buttons are kind of in the middle of the column, I want them to be vertically aligned all the way to the top and to the right. How can I do this? Is it just playing with padding?

  Read the article

• winforms - datagridview row height doesn't resize when defaultcellstyle is set to wrapmode

  - by BhejaFry

  Hi folks, i have a datagrid that displays long text on couple columns. I have set the cells defaultcellstyle to wrap. This works but now the row height doesn't change to compensate for the wrapped text & the text is getting cut-off. What am i missing? TIA

  Read the article

• How to SELECT the last 10 rows of an SQL table which has no ID field?

  - by Edward Tanguay

  I have an MySQL table with 25000 rows. This is an imported CSV file so I want to look at the last ten rows to make sure it imported everything. However, since there is no ID column, I can't say: SELECT * FROM big_table ORDER BY id DESC What SQL statement would show me the last 10 rows of this table? The structure of the table is simply this: columns are: A, B, C, D, ..., AA, AB, AC, ... (like Excel) all fields are of type TEXT

  Read the article

• UNIQUE Constraints in SQL (SQL Server)

  - by rockbala

  Why are UNIQUE Constraints needed in database ? Can you provide any examples ? Primary Key is UNIQUE by default... Understandable as they are referred in other tables as Foreign keys... relation is needed to connect them for rdbms platform... but why would one refer to other columns as UNIQUE, what is benefit of doing so ?)

  Read the article

• jquery-plugin columnizer: is it really so slow ?

  - by Patrick

  hi, I'm using jquery-plugin columnizer http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=columnizer for this website: http://donatellabernardi.ch/drupal It is sometimes very slow to create the columns (you can try changing the browser window size, or selecting a filter. Sometimes Firefox gives the error message: "Unresponsive Javascript script" and I have to press on continue to continue the navigation. thanks

  Read the article

• extracting only unique row from csv based on multiple column criteria ?

  - by wefwgeweg

  basically i have rows after rows of data event | venue | date | some | other | columns | here| there are lot of overlapping event that happens at same venue and date. so i would like to end up with only unique events by matching event, venue, date. is this possible in excel , how to approach this ? VBA ? or some option i dont know about ? thank you.

  Read the article

• Store Image in DataTable

  - by Aizaz

  I want to store image into my datatable and while adding colum I want to set its default value, sending you code doing with checkboxes.. public void addCheckBoxesRuntime(){ for (int i = 0; i < InformationOne.Length; i++) { dt = new DataColumn(InformationOne[i][1] + " (" + InformationOne[i][0] + " )"); dt.DataType = typeof(Boolean); viewDataTable.Columns.Add(dt); dt.DefaultValue = false; } }

  Read the article

• Need this VB code changed into Python.

  - by David

  I wrote this code in VB to label columns in a table but now im writting a python script to automate the process and i can't make it work. Any thoughts?? Static v1 as variant Static v2 as variant Dim Output as double Dim Start as double Start = 1 If v2 = [XMIN] Then Output = v1 Else Output = v1 + 1 End If v1 = Output v2 = [XMIN]

  Read the article

• Basic xhtml/css models ?

  - by Skeptic

  Hi, I need to produce a very simple website (no dynamic-content, 2-columns, header&footer) and I have a basic knowledge of xhtml/css. So I could probably come with something from scratch, but it would probably won't work in "all" browsers. I've done some googling, but it's difficult for me to evaluate the quality of the "free templates" advertized all over the place. So is there any web developer here that has good references or even such models/templates ?

  Read the article

• Fluent NHibernate: Mapping a column with a different name

  - by Fred

  Let's say I have a table: Project Id Title ProjectManagerId ContactId ProjectManagerId and ContactId are both id's from a table named Person: Person PersonId Firstname Lastname How can I map these two columns to create a person object? (either using automapping or fluent's normal mapping). Thanks

  Read the article

• Can I split up the values from one text field into multiple text fields?

  - by spencewah

  I have a text field that stores a combination of three values, ':' delimited. (looks like A:B:C). I'd like to split those values into three actual columns in the table, but I'm not sure of the best way to go about doing this. I'm using sqlite3, any help super appreciated!

  Read the article

• combine 2 files with AWK based last colums

  - by mohammad reshad

  i have two files file1 ------------------------------- 1 a t p b 2 b c f a 3 d y u b 2 b c f a 2 u g t c 2 b j h c file2 -------------------------------- 1 a b 2 p c 3 n a 4 4 a i want combine these 2 files based last columns (column 5 of file1 and column 3 of file2) using awk result ---------------------------------------------- 1 a t p 1 a b 2 b c f 3 n a 2 b c f 4 4 a 3 d y u 1 a b 2 b c f 3 n a 2 b c f 4 4 a 2 u g t 2 p c 2 b j h 2 p c

  Read the article

• Avoid duplication of values in a SELECT query in PostgreSQL

  - by Shyam Solanki

  I have a table named product which contains two columns: id name 1 p1 2 p2 3 p1 4 p3 5 p4 I run the following query: SELECT DISTINCT id, name FROM product; As a result, PostgreSQL gives me the following output: id name 1 p1 2 p2 3 p1 4 p3 5 p4 I want to avoid duplication of values in the name field, so the desired output should look like this: 1 p1 2 p2 4 p3 5 p4 How should I go about achieving this?

  Read the article

• What are my best ASP.Net GridView replacement options?

  - by Homer

  We currently use a GridView to display 1000+ rows of data. Minimum requirement for replacement is a fixed header row, fixed footer and columns would be a plus. This would have to work across IE 6 and greater. I've heard good things about Infragistics, but the demo on their page is slow. So what are my best options? jQuery? YUI? other 3rd party?

  Read the article

• How to make a report with count of type of cases in each month in Acess 2010

  - by amir shadaab

  I have a database is access with each record having a date and yes/no type columns for each record which shows which category the record comes under. I want to create a report which shows the types of cases in each month by taking a date range as a parameter through prompts. I have done the prompt part but I'm not sure how the query should be to show values for each month in that date range. Can someone please help me with this?

  Read the article

• writing to a dataframe from a for-loop in R

  - by CCID

  I'm trying to write from a loop to a data frame in R, for example a loop like this for (i in 1:20) { print(c(i+i,i*i,i/1))} and to write each line of 3 values to a data frame with three columns, so that each iteration takes on a new row. I've tried using matrix, with ncol=3 and filled by rows, but only get the last item from the loop. Thanks.

  Read the article

• What are the differences between these?

  - by Amit Ranjan

  What are the differences between the two queries? SELECT CountryMaster.Id FROM Districts INNER JOIN CountryMaster ON Districts.CountryId = CountryMaster.Id SELECT CountryMaster.Id FROM CountryMaster INNER JOIN Districts ON Districts.CountryId = CountryMaster.Id Please mind the i) Table positions and second ii) On Fields As I know, output will be same. But I want to know, is there any drastic effects of the same if I neglect positions of tables and columns in complex queries or tables having tons of data like thousands and lakhs of rows...

  Read the article

• Help with MySQL query

  - by Michael S.

  I have a table that contains the next columns: ip(varchar 255), index(bigint 20), time(timestamp) each time something is inserted there, the time column gets current timestamp. I want to run a query that returns all the rows that have been added in the last 24 hours. This is what I try to execute: SELECT ip, index FROM users WHERE ip = 'some ip' AND TIMESTAMPDIFF(HOURS,time,NOW()) < 24 And it doesn't work. Can someone help me out? Thanks :)

  Read the article

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