table

Mysql Prepare Statement error while executing

Hi All, I am trying to create a table though prepare statement but it is giving me syntax error. well if o try to execute the same statement individually then it work fine. here's my statement - SET @Stmt1 = Concat('DROP TABLE IF EXISTS ',DB,'.`county`;\n' 'CREATE TABLE IF NOT EXISTS ',DB,'.`County` ( `CountyID` INT UNSIGNED NOT NULL...

Extending tables in SQL

How to add a column to the table: create table table1 (id integer primary key, field1 text) ? The column would be field2 text and the value for existing rows in this column should be value. ...

how to divide a long article and store in the database for easy retrieval and with paging?

Suppose it is a long article (say 100,000 words), and I need to write a PHP file to display page 1, 2, or page 38 of the article, by display.php?page=38 but the number of words for each page can change over time (for example, right now if it is 500 words per page, but next month, we can change it to 300 words per page easily). What i...

Efficient way to implement paged SQL result table in a Java desktop application

Hi all, I need to build a table from SQL select result set. I want to add some paging functionality to the table because the result set can be very large. There was many discussions how to do the paging at the SQL level. But how to implement the paging at the GUI level? I have two ideas: Do the paging in a web UI style - for example g...

Postgres: Table inheritance: Enforcing unique constraints across partitions?

I have a table that I would like to partition, but I don't know how to deal with the uniqueness constraints. Is it possible to create a unique constraint across multiple child tables? ...

How to extract nested tables from HTML?

Hi everybody. I have an HTML file (encoded in utf-8). I open it with codecs.open(). The file architecture is: <html> // header <body> // some text <table> // some rows with cells here // some cells contains tables </table> // maybe some text here <table> // a form and other stuff </table> // probably some more...

How to addClass to the first td in every tr inside a table using jQuery

I'm trying to add a class to the first td inside a tr w/ a specific class. But for some reason it adds this class only to the first td in the first tr -not the first td in each tr $("#appendTD").find("#gridFormInformation").children(0).children().each( function() { if ($("#appendTD").find('tr').filte...

How do I present a tree in an HTML table?

I'm trying to show a tree structure in an HTML table. It's basically a list of people you referred to a site, but you can expand each and see the people they referred too (only 2 or 3 levels). I'm also showing a number of pieces of information on each person, so I'm using a table, with several columns. I'm wondering what's the best way ...

How can I make an HTML table sortable with javascript without loading data via AJAX?

How can I make a table sortable using javascript without loading data via AJAX? More specifically, I'm looking for a solution that gives me the following: Works on a plain old HTML table Makes columns sortable using a natural comparison Is agnostic of server-side technology (should be portable regardless of whether the tables are bein...

Table View

Hi, I want button on every cell on table View. and on button click i m populating action sheet . When i click on action sheet button ,the selected value should be displayed on a clicked button (which is used to open action sheet). Thanks Harita ...

JTable selects wrong cell on click

I am working inside of a quite complex eclipse based application, and having a problem with a JTable based custom component inside of a JSplitPane. The part of the application that I actually have access to is a panel, within a tab, within a panel, within the actual application, so there are a lot of things that can go wrong. The speci...

WPF Table?

I'm very new to WPF, so I've just started making a very simple Memory card game just to learn the syntax and such. The game is where all the cards are facing down, you flip two over and if they match you remove them, otherwise reflip them down and try to remove all the cards in the shortest number of flips. Like I said, very simple... ...

jquery table read input field value

Hi all! I made a place management system where you can create, delete or edit placenames. I'ts a table where in every row there is a placename an edit button and an delete button. At the end of the table there is a "create new place" button. Now when I click on the "create new place" button then I get a new generated row where I can wr...

SubSonic isn't generating MySql foreign key tables

I two tables within a MySql 5.1.34 database. When using SubSonic to generate the DAL, the foreign-key relationship doesn't get scripted, ie; I have no Parent.ChildCollection object. Looking inside the generated DAL Parent class shows the following; //no foreign key tables defined (0) I have tried SubSonic 2.1 and 2.2, and various MySq...

Border gone from table?

For some reason, one of the inside borders disappears on my table whenever I change the default height with some CSS. HTML: <table class="event"> <tr> <td>Start Date</td> <td>2009-6-2</td> </tr> <tr> <td>End Date</td> <td>2009-6-8</td> </tr> <tr> <td>Location</td> <td>Vail</td> </tr> </table> CSS: ...

Using "Show values as" option in Excel 2007 pivot table when source is SSAS cube?

I have an Excel 2007 pivot table showing "Year" across the top and "Month" down the side. What I am trying to do is represent the values as "% Difference" from the same month of the previous year. (Ex. If Jan-07 is $100,000 and Jan-08 is $120,000, I would like Jan-08 to show '20%'). However, every time I try to do this (using the "Sh...

Can you print a Flowdocument Table in WPF with repeatable table column headers

How can you print a Flowdocument Table in WPF with repeatable table column headers? I have seen this one [http://www.codeproject.com/KB/WPF/PimpedDocumentPaginator.aspx] and it does not work. ...

Custom Generic GetTable

For a DataContext I'm working on, I don't want to load the Tables untill their needed. I want to make a little method that would check if a certain Table is loaded before loading it, but I end up having n Methods doing the same thing : private void Load(ref Table<Order> Orders) { if (Orders == null) Orders = this.GetTable<Or...

Make an iframe fill to bottom of screen without using tables

I want display a header with arbitrary content above an iframe that takes up the rest of the screen. I have managed to get this working with tables using the following: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt; <html> <head> <style> html, body, iframe, ta...

Need help naming a field (and table)

I'm creating a new table which is related to a Contacts table (where I store first name, last name etc). The table has: int Id (PK, Identity) int ContactId (FK) int Type (this identifies whether the following is an email, tel, fax etc.) nvarchar(40) [I need a name for this one] The nvarchar field is basically storing either ab...