table

How can I get the name of all tables in a JavaDB database?

How can i programmatically get the names of all tables in a JavaDB database? Is there any specific SQL-statement over JDBC I can use for this or any built in function in JDBC? I will use it for exporting the tables to XML, and would like to do it this way so I don't miss any tables from the database when exporting. ...

How to dynamically show/hide rows in a table

I'm working on a website where I need to show/hide table rows. I got the feature working, but the CSS gets bad when I do show. I'm providing a working link; click the 'More...' link and see the action for an example. I'm using jQuery's toggle(slow) for hiding and showing hi, i have a page built using tables . http://ratingscorner.c...

How to apply paging to a dataset?

How can i apply paging to a dataset? I have a method in wich i dynamically build a table from a dataset. Querying the database from wich i get my dataset from is not an issue but iterating the datarows from the dataset is slow. To increase performance when loading a page containing a lot of datarows i wanna apply paging ability. A feat...

div popup inside td

I have a table with a bunch of cells. (No way! Amazing! :P) Some of the cells have a small div that when you put your mouse over, it gets bigger so you can read all the text. This works well and all. However, since html elements that come later in the document have a higher z-index, when the div gets bigger it is underneath the other div...

Finding which table a constraint belongs to

Hi, I need to find out which table(name) a particular constraint belongs to. Does anyone have any TSQL to achieve this? ...

Oracle: How can I get all the triggers linked to a specific table?

Hi, I'm searching for a way to retrieve all the triggers where there is an action linked to a specific table. I don't want to read manually all the triggers I have on the server as there are too many. Any ideas? Thanks ...

Help with SQL query

Hello, I have list of DateTime values, and for each value I need to fetch something from the database. I would like to do this with one query. I know it's possible to pass a table (list) to the stored procedure, but Im not sure how to write the query itself. Let's say I have the following table: CREATE TABLE Shows( ShowId [int] N...

How to copy a 110GB table with BLOBs from one schema to another on ORACLE

Hello, I have a table containing 110GB in BLOBs in one schema and I want to copy it to another schema to a different table. I only want to copy a column of the source table so I am using an UPDATE statement, but it takes 2,5 hours to copy 3 GB of data. Is there a faster way to do this? Thank you update: The code I am using is very...

Add Table to FlowDocument In Code Behind

Hi, I have tried this..... _doc = new FlowDocument(); Table t = new Table(); for (int i = 0; i < 7; i++) { t.Columns.Add(new TableColumn()); } TableRow row = new TableRow(); row.Background = Brushes.Silver; row.FontSize = 40; row.FontWeight = FontWeights.Bold; row.Cells.Add(new TableCell(new Paragraph(new Run("I span 7 columns")...

Combining database tables

Hi all, I have two tables which look kind of similar and i was thinking about combining them and thought i would get some input from everyone. Here's what they currently look like: Issues Id | IssueCategory | IssueType | Status | etc.. ------------------------------------------------- 123 | Copier | Broken | Open | 1...

Core Data table record count

I have an entity called Person and it has a relationship called participatingGames, to another entity called GameParticipant. I (apparently) can retrieve the number of matches in the GameParticipant entity using this simple code in the Person object I created from the entity in the model: [self.participatingGames count]; However, I'd ...

Vertically Merge Multiple Tables in MySQL by Joint Primary Key

Hello, I'll attempt to make my question as clear as possible. I'm fairly unexperienced with SQL, only know the really basic queries. In order to have a better idea I'd been reading the MySQL manual for the past few days, but I couldn't really find a concrete solution and my needs are quite specific. I've got 3 MySQL MyISAM tables: table...

SQL: joining multiples tables into one.

I have 4 tables. r1, r2, r3 and r4. The table columns are the following: rId | rName I want to have, in fine, an unique table - let's call it R. Obviously, R will have the following structure: rTableName | rId | rName I'm looking for a solution, and the more natural for me is to: add a single column to all rX insert this column...

How to use danvk re-orderable columns with dynamically created tables?

Hi, I'm trying to implement the danvk draggable table javascript, and while I've been successful using it for tables actually in the html source, when I try to use it with tables I'm creating in javascript code, it isn't applied to those tables. Has anyone had the same issue? Many thanks. ...

xsl - exclude <td> from <div>

is there any way to have a div around an entire table, but exclude one <td>? TIA ...

SQL help - find the table that has 'somefieldId' as the primary key?

Hello All, How can I search my sql database for a table that contains a field 'tiEntityId'. This field is referenced in a stored procedure, but I am unable to identify which table this id is a primary key for? Any suggestions? I currently look through stored procedure definitions for references to text by using something like this Decla...

Truncate all tables in postgres database

I regularly need to delete all the data from my postgresql database before a rebuild. How would I do this directly in SQL? At the moment I've managed to come up with a SQL statement that returns all the commands I need to execute: SELECT 'TRUNCATE TABLE ' || tablename || ';' FROM pg_tables WHERE tableowner='MYUSER'; but I cant see ...

Update Table in Asp.Net MVC

I have table [HTML Table] on page i want to delete record from table and also update table after deletion record. <%= Ajax.ActionLink("Delete Ajax", "PostTypeDelete",new { id = item.int_PostTypeId }, new AjaxOptions{LoadingElementId="status"}) %> I used above code its working fine (it delete record) but it doesn't update table. ...

Freeze Table Header with Microsoft Expression

I am using the below code to achieve the results. The scenario is working fine with single DIV on the page. But when i am adding one more DIV to the page, then problem comes into picture. Find my HTMLcode @ http://docs.google.com/Doc?docid=0Adbmqz8tzPkZZGQ3cjQ5YnJfM2c2NTZkc2Nk&amp;hl=en When i scroll first DIV, the header of second DIV...

how best to set text alignment in a table

Does anyone know of a jquery plugin or snippet that will auto-text-align cells in a table based on content? Specifically, all table cells would be right justified unless there is a visible non-number related character in the cell, then it would be left justified. I'd like to use something like this regular expression to identify non-nu...