Search Results

Search found 36762 results on 1471 pages for 'common table expression'.

Page 150/1471 | < Previous Page | 146 147 148 149 150 151 152 153 154 155 156 157  | Next Page >

• Fluent: Table name different from entity name

  - by Matt

  I am trying to use the automapping feature of Fluent with nHinbernate to map a class with a different name than the table itself is name. (This is purely for stylistic reasons we have a class named Foo which contains an object named Bar but the table name is FooBar. We would rather not have a property Foo.FooBar.) I can't find anything detailing how to give Fluent a clue on this change.

  Read the article

• table to updated after selection with uipicker

  - by Guille10k

  An UIPicker shows up when I select a row in a table, so I can choose some things I want to be displayed on the same row. How can I update the table once I finished with the uipicker? I used reloadData right after the call to the picker, but the code is executed before I do "Done" on the picker. Some idea? Thank u

  Read the article

• Database Table of Boolean Values

  - by guazz

  What's the best method of storing a large number of booleans in a database table? Should I create a column for each boolean value or is there a more optimal method? Employee Table IsHardWorking IsEfficient IsCrazy IsOverworked IsUnderpaid ...etc.

  Read the article

• Parsing or Extracting the content of html table.

  - by Harikrishna

  Can I parse the html tables by giving only column name ? Like only those data should be extracted from the table which matches those column names I give. Like for example I have table of column names like serial no., name, address, phone no,total Rs.. And I want to extract the information about only name, phone no and total Rs.. Then how can I do it?

  Read the article

• how to delete duplicates on mysql table?

  - by Ronnie Chester Lynwood

  hello I need to know any way to delete duplicated items for specified sid on table. how can I do this with SQL queries ? DELETE (DUPLICATED TITLES) FROM table WHERE SID = "1" something like this but i don't know true one :/ thanks.

  Read the article

• manually updating database table values are not reflecting in webpage - aspnet mvc

  - by FosterZ

  hi,i noticed some wierd problem i.e i have built a web page on which information comes from database table named "school", when i change some data in that table manually from mssql the web page data is still same as previous, its not gettin' changed, i dn't know how it is possible.

  Read the article

• Create Word/RTF file with table of contents from Java

  - by Glen

  Hi, I want to create a Word or RTF file with a table of contents (with links to each section) from Java. From my understanding, iText & Apache POI do not support generating a table of contents. Some clients of the app still use older versions of Word, so I need a library that supports the older Word doc format. Does anyone know how I can do this? Thanks, Glen

  Read the article

• Append SQL table name with today's date

  - by Ricardo Deano

  Hello all. I understand that I can change a sql table using the follow sp: EXEC sp_rename 'customers', 'custs' How would I go about appending this so that the new table has today's date as a suffix? I've attempt variations on the below theme with little success!! EXEC sp_rename 'customers', 'customers +(CONVERT(VARCHAR(8),GETDATE(),3))' Any help greatly appreciated.

  Read the article

• Cross Join 'n' times a table

  - by SDReyes

  It is possible to write a generic function/procedure/select/somethingElse to cross-join a table against himself 'n' times? (yes, 'n' is a given parameter : ) How would you do it? Example Having this table: Value ------- 1 2 3 cross join it 2 times, would return: Value | Value ------------------ 1 1 1 2 1 3 2 1 2 2 2 3 3 1 3 2 3 3

  Read the article

• Access ELF string table section header

  - by idealistikz

  Assume: Elf_Section_Header *sectionHeaderTable //points to the start of a ELF section header table Elf_Section_Header *symtabHeader //points to the start of the symtab section header Why doesn't the following point me to the associated string table section header? Elf_Section_Header *strTabSectionHeader = (Elf_Section_Header *)((char *)sectionHeaderTable + (symtabHeader-strtab_index)); 'strTabSectionHeader-type == SHT_STRTAB' is equal to false How should I point ot the strTabSectionHeader?

  Read the article

• Get data from table from a list of strings on MySQL

  - by steamboy

  Hello, How can I query data from a table available on a list of strings? I only want to get the data from the list of strings. Example: Table ID Name 1 Big 2 Small 3 Extra 4 Orange 5 Drink List of Strings: Big Small Extra Thanks!

  Read the article

• Chage table columns width as you resize the window (or splitter) in which the table exsists.

  - by Narek

  Consider there is a QTablWidget and a QTextEdit. Both of them are in a horisontal QSplitte. Let the QTable widget has 2 columns. The problem is to resize the table columns' width as you do resize operation by moving the splitter with mouse. Are there any options to may colums to be resized synchornosly with the table? Thanks.

  Read the article

• Incorrect table name, php/mysql

  - by user296516

  Hi guys, I've got this code mysqli_query ( $userdatabase, 'CREATE TABLE `user_'.$emailreg.'` ( ID int NOT NULL AUTO_INCREMENT PRIMARY KEY, IP varchar(10), FLD1 varchar(20), FLD2 varchar(40), FLD3 varchar(25), FLD4 varchar(25), FLD5 varchar(25) )' ); echo ( mysqli_error ($userdatabase) ); that works fine on my localhost, but when I upload it to the server, it starts giving me a "Incorrect table name '[email protected]'" error. any idea? Thanks!

  Read the article

• Select column value that matches a combination of other columns values on the same table

  - by Ala

  I have a table called Ads and another Table called AdDetails to store the details of each Ad in a Property / Value style, Here is a simplified example with dummy code: [AdDetailID], [AdID], [PropertyName], [PropertyValue] 2 28 Color Red 3 28 Speed 100 4 27 Color Red 5 28 Fuel Petrol 6 27 Speed 70 How to select Ads that matches many combinations of PropertyName and PropertyValue, for example : where PropertyName='Color' and PropertyValue='Red' And where PropertyName='Speed' and CAST(PropertyValue AS INT) > 60

  Read the article

• delete last row in a table android

  - by Sephy

  Hi everybody, My question is quite straightforward. I have a table, with, lets say x rows, with each an id, but i don't know how many rows i have. Now i want to delete the last row of my table for some reason... Is there an easy way to do that in android? I have been trying to use the last_insert_rowid in my where clause...but no luck so far... any idea? thx for help

  Read the article

• Fastest way to check array items existence in mySQL table

  - by Enrique

  User writes a series of tags (, separated) and posts the form. I build an array containing the tags and delete dupes with array_unique() php function. I'm thinking of doing: go through the array with foreach($newarray as $item) { ... } check each $item for existence in the tags mySQL table if item does not exists, insert into tags table Is there a FASTER or MORE OPTIMUM way for doing this?

  Read the article

• mysql concat all field table

  - by hafizan

  Is there a way we can concat all field in the table(1 sql statement)(automatic) ? The reason was before user updated or delete a record,the record will push to another table for future reference.

  Read the article

• CSS - center an oversized div inside a table cell which is too small

  - by domspurling

  I want to display a DIV inside a table cell which is too narrow for it. I'm using overflow:hidden to allow the div to spill out one side of the table cell but now I want to center it so that it spills out a wee bit on both sides insdead of alot on one side. How do I horizontally center a DIV inside a TD which is too narrow for the DIV?

  Read the article

• set position in a table

  - by Senthilkumar

  Hi can any one tell .. how to set position inside a table.. I have table inside which I have span and certain links .. I made as cetre alignment and span text s starting from centre but when i do the same for all links everthing displayed in centre if it own.. but i need to start all text at the same position/.. how to do this???

  Read the article

• How to create a table type in Sql Server 2005

  - by Nikola Stjelja

  Hi, I'm trying to create a table type in sql server 2005. Here is what my code looks like: CREATE TYPE NameResourceType AS TABLE ( ID int, [Value] Varchar(256) ) GO I receive the following error: Incorrect syntax near the keyword 'AS'.

  Read the article

• Adding metadata attributes to MySQL table

  - by Jack

  I would like to add custom attributes to a MySQL table which I can read via php. These attributes are not to interfere with the table itself - they are primarily accessed by php code during code generation time and these attributes HAVE to reside in the DB itself. Something similar in concept to .NET reflection. Does MySQL support anything like this? Thanks.

  Read the article

• How can I alter a temp table?

  - by William

  I need to create a temp table, than add a new int NOT NULL AUTO_INCREMENT field to it so I can use the new field as a row number. Whats wrong with my query? SELECT post, newid FROM ((SELECT post`test_posts`) temp ALTER TABLE temp ADD COLUMN newid int NOT NULL AUTO_INCREMENT)

  Read the article

• Alternate three and three rows in a table with jQuery

  - by Frode Lillerud

  I want to set the alternate background color for rows in a table - but the twist is that I don't want every other row to be colored, I want to treat them in blocks of three rows. So for a table with eight rows I want the first three to be white, then the next three to have a background color, and the last two are back to white again. How can I do this using jQuery?

  Read the article

• How to transfer data to the target table from multiple sources without using Joiner Transformation i

  - by Velava

  I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

  Read the article

• Is derived table executed once or three times?

  - by AspOnMyNet

  Every time you make use of a derived table, that query is going to be executed. When using a CTE, that result set is pulled back once and only once within a single query. Does the quote suggest that the following query will cause derived table to be executed three times ( once for each aggregate function’s call ): SELECT AVG(OrdersPlaced),MAX(OrdersPlaced),MIN(OrdersPlaced) FROM ( SELECT v.VendorID, v.[Name] AS VendorName, COUNT(*) AS OrdersPlaced FROM Purchasing.PurchaseOrderHeader AS poh INNER JOIN Purchasing.Vendor AS v ON poh.VendorID = v.VendorID GROUP BY v.VendorID, v.[Name] ) AS x thanx

  Read the article

< Previous Page | 146 147 148 149 150 151 152 153 154 155 156 157  | Next Page >