Search Results

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

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

• [Haskell]Curious about the Hash Table problem

  - by astamatto

  I read that hash tables in haskell are crippled ( citation: http://flyingfrogblog.blogspot.com/2009/04/more-on-haskells-hash-table-problems.html ) and since i like haskell it worried me. Since the blog-post one year has passed and im curious, The hash table problem in haskell was "fixed" in the traditional compilers? (like ghc) ps: I love stack overflow, im a long time visitor but only today i decided to try to post a question.

  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

• adjusting table content with javascript by enumerating rows

  - by Tom

  I have a table row with 4 columns on my ecommerce site and I want to replace the content of 1st column if total amount in last column (TD class "total") is over 10 EUR. How can I do this with javascript only, I guess somehow to enumerate through the table rows and look for a correct row (one with the last column class as total) and then access the content of 1st column on this row but how?

  Read the article

• Using NDbUnit with tables that have a table schema

  - by KevinT

  I am having issues using NDbUnit with tables that have their own schema - ie: CREATE TABLE MYSCHEMA.MyTable01 ( Id int NOT NULL, Description varchar(50) NOT NULL ) Is this a supported scenario? What do I need to do to get this to work? (working fine when the table is dbo.MyTable01)

  Read the article

• MYSQL DELETE from a table [closed]

  - by Hossein

  Possible Duplicate: MySQL DELETE in a single table Hi, I have this table: userurltag(id,user,Url,tag) I want to remove rows that contain urls that are used by only one user, can someone help me? It seems that DELETE...(SELECT...) is not supported in Mysql.

  Read the article

• jQuery - count number of rows in a table

  - by danjan

  How do I count the number of tr elements within a table using jquery. Sorry, I sense this might be basic but i've been banging my head against it. I know there is a similar thread, but I just want the total rows. http://stackoverflow.com/questions/613024/count-number-of-table-rows-between-two-specific-rows-with-jquery

  Read the article

• Excel: TableAdapter UpdateCommand for table without primary key

  - by Steven

  What is the syntax for an Update query / UpdateCommand for a table from an Excel Data Source (therefore having no a primary key)? Note: Similar to: MS-Access: TableAdapter UpdateCommand for table without primary key

  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

• Write physical table to csv file

  - by urema

  Hi, I was wondering if anyone knows how to write an actual table/grid to a csv file....i dont mean the content of the table/grid, i mean the actual grid lines etc etc, headers, axis..... Thanks greatly in advance. U.

  Read the article

• to take values of checkbox in table attributes

  - by mwj

  i have a database patient with 3-4 tables n each table has about 8 attributes.... i have a table medical history which has attribute additional info ... under which i have 5 checkboxes.... all the values entered are taken up except the chekbox values..... plz help

  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

• update myqsl table

  - by Simon

  how can i write the query, to update the table videos, and set the value of field name to 'something' where the average is max(), or UPDATE the table, where average has the second value by size!!! i think the query must look like this!!! UPDATE videos SET name = 'something' WHERE average IN (SELECT `average` FROM `videos` ORDER BY `average` DESC LIMIT 1) but it doesn't work!!!

  Read the article

• In @Table(name = "tableName") - make "tableName" a variable in JPA

  - by zengr

  I am using JPA and I need to make the "tableName" a variable. In a database, I have many tables, and my code needs to access the table where I specify it to read. @Entity @Table(name = "tableName") public class Database implements Serializable {...............} Any ideas?

  Read the article

• Rewrite SQL Fulltext Function to return Table only

  - by Alex

  I have a MS SQL Fulltext Function like this: (...) RETURNS TABLE AS RETURN SELECT * FROM fishes INNER JOIN CONTAINSTABLE(fishes, *, @keywords, @limit) AS KEY_TBL ON fishes.id = KEY_TBL.[KEY] When I use this function in LINQ, it generates a special return type which includes all fields of my "fishes" table, plus Key and Rank. How could I rewrite above query, or change something in LINQ, to omit Key and Rank and just return my "fishes" results (and to have the fulltext search result objects be of type Fish, which is what I really care about, so I don't have to cast)?

  Read the article

• SQL Server 2008 Reporting Services Charting - adding a data table to bottom of a chart

  - by Christopherous 5000

  I would like to add a data table to bottom of a (line) chart in a report. I know I can create a matrix report with the same data source. I would like to have everything lineup automatically like it does when you add a data table to a chart in Excel (as shown at http://www.tushar-mehta.com/excel/newsgroups/data_table/). Example from Excel (from above link) Any ideas?

  Read the article

• Disable table in javascript

  - by Muhammad Akhtar

  Hi, I have many controls in table and I want to disable all the controls using JavaScript upon clicking of some checkbox. I have google and found that we can't disable table instead all controls through loop. Please suggest me, what is better idea Thanks

  Read the article

• How to quote and reference MS SQL table and field names

  - by artvolk

  Good day! Despite the fact LINQ2SQL and ADO.NET Entity Framework exists there were situations when I need to revert to plain old DataSet (not typed) and friends. While writing SQL for SqlCommand: Is it needed to quote field and table names with []? Is it good to prefix table names with [dbo] I use to use this syntax: SqlCommand command = new SqlCommand("SELECT [Field1], [Field2] FROM [dbo].[TableName]", connection); May be there is a better way? Thanks in advance!

  Read the article

• SQL Comments on Create Table on SQL Server 2008

  - by user494901

  I need to create some pretty big tables in SQL server 2008, while I do have SQL Server Manager Studio, I would like to comment the tables and the columns when I create the table. How do I do this? Example of the query I am running: CREATE TABLE cert_Certifications ( certificationID int PRIMARY KEY IDENTITY, profileID int, cprAdultExp datetime null ) I've tried COMMENT'Expiration Date for the Adult CPR' and COMMENT='Expiration Date for the Adult CPR' after the data type, and SQL server is giving me an error.

  Read the article

• Google App Engine datastore-Table creation

  - by megala

  I have one doubt regarding table creation in google app engine datasore using jpa.my consatraints is ,Is it possible to create a table without using primary key.(i.e) without using @Id annotations. Thanks in advance

  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

• 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

• iPhone empty table message (eg like "No contacts" in simulator, or "No results" in search )

  - by jesse001

  Is there a right way to add empty table text? For example, if you go to the simulator and open contacts, the table is empty and displays "No Contacts". Or searching that gives "no results". I could do this via a label positioned and hidden at run time, but is the correct approach? Thanks for your help

  Read the article

• how to copy a sqlite3 table to another file in python

  - by james

  hey i was wondering how i could make a copy of a sqlite3 table and save it to a seperate file in python. im confused as in python your sqlite3 object can only be connected to one database so how would i make it save to a seperate database? the reason i want to do this is in sqlite3 the database file size can never get smaller, and ive made alot of changes so i want just copy this table to another file which wont have all the extra empty space and then delete the origonal database thanks guys

  Read the article

• Can I get a table name from a join select resultset metadata

  - by Matt

  Below is my code trying to retrieve table name form Resultset ResultSet rs = stmt.executeQuery("select * from product"); ResultSetMetaData meta = rs.getMetaData(); int count = meta.getColumnCount(); for (int i=0; i<count; i++) { System.out.println(meta.getTableName(i)); } But it returns empty, no mention it is a join select resultset. Is there any other approaches to retrieve table name from reusltset metadata?

  Read the article

• How can I make my table cell UITextField editable when the table has entered 'edit' mode?

  - by Lee Probert

  I have a simple table view which is editable. All I need the user to be able to do is edit the text field in the cell when they choose to edit the table.

  Read the article

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