table

Can Tables completely replace any CSS design?

Can this be done? This site wants to.. http://giveupandusetables.com/ The site doesn't set a good example though.. ...

Creating Dynamic Tables in Word by C#.NET

I have a C# application where i want to implement a logic for a programm which will open the word document and go to a certain place in the page and create a Table and put values in that. Can any one tell me how to implement this. I am using Visual studio 2005 ...

CSS Table Styling

I need to style a table to have rounded corners, and look like the screenshot: I'm just looking at how best to go about it: Normally when I style a div to have rounded corners, I use 2 divs with empty comments at the top and bottom, and apply sizing & background image CSS to them. The table, however, has internal borders, so I'd ha...

Paged table with ASP.NET MVC and AJAX

I'm looking for good patterns for implementing a paged table of results in ASP.NET MVC with sorting, filtering, and paging provided via AJAX. It seems to me that I should have my controller actions provide only the data and not mark up to maintain the separation of concerns -- so the Ajax callback would provide new table data and pager ...

F# Beginner: retrieving an array of data from a server

I'm trying to grab data from a MySQL database. Approach 2 - apply/map style I'm using the MySQL ADO Reference to try to build this system. In particular, the example found at 21.2.3.1.7. (using a pseudo code) let table = build_sequence(query.read) Where query.read returns a row in the table(Or rather, a list of elements that happen...

MySQL inserting data only if table doesn't exist

Using strictly SQL (no PHP or anything else), is it possible to create a table and insert default data into that table only if that table doesn't exist? ...

Deleting all tables in HTML with JavaScript

How can I delete all the tables in a web page? The tables don't have any ids associated with them. ...

How can I lock the first row and first column of a table when scrolling, possibly using javascript and CSS?

How can I create a table that has its first row and first column both locked, as in Excel, when you activate 'freeze panes'? I need the table to both scroll horizontally and vertically (a lot of solutions for this exist, but only allow vertical scrolling). So, when you scroll down in the table, the first row will stay put, since it wil...

How to place text in the clipboard so that it pastes as a table in Word?

Using VBA in MS Office, how do I add text to the Windows clipboard so that it will paste into Word as a table? ...

What is the difference between a schema and a table and a database?

This is probably a n00blike (or worse) question. But I've always viewed a schema as a table definition in a database. This is wrong or not entirely correct. I don't remember much from my database courses. ...

Cross table join using MYSQL rather than MSSQL

Is it possible to do a cross table join in mysql spaning different tables? in different databases. This seem to be easily possible in MSSQL, and greatly speeds up data transfer? How about mysql, do you need to use a powerful IDE to achieve this? or do you have to write a program to do something like this? UPDATE tblUser SET tblUser.R...

CSS way to horizontally align table

I want to show a table of fixed width at the center of browser window. Now I use <table width="200" align="center"> But Visual Studio 2008 gives warning on this line: Attribute 'align' is considered outdated. A newer construct is recommended. What CSS style should I apply to the table to obtain the same layout? ...

displaytag table column totals

Hi, I'm using the displaytag JSP tag library to generate tables that show column totals. For example in the JSP code below, only those columns with the attribute total="true" will have totals generated. <display:table name="myTable" id="myTable" decorator="org.displaytag.decorator.TotalTableDecorator"> <display:column property="na...

Oracle Populate backup table from primary table

The program that I am currently assigned to has a requirement that I copy the contents of a table to a backup table, prior to the real processing. During code review, a coworker pointed out that INSERT INTO BACKUP_TABLE SELECT * FROM PRIMARY_TABLE is unduly risky, as it is possible for the tables to have different columns, and differ...

Modifying the style attributes of selected table cells with jQuery?

I'm building a pretty basic HTML table creator/editor (based on a designMode iframe) at work, using direct DOM manipulation. It's a pain, obviously due to Internet Explorer. When in designMode, a table inserted into the editing area iframe is resizable and the contents of the cells can be freely edited. In Firefox, rows and columns can ...

jQuery draggable table elements

jQuery's draggable functionality doesn't seem to work on tables (in FF3 or Safari). It's kind of difficult to envision how this would work, so it's not really surprising that it doesn't. <html> <style type='text/css'> div.table { display: table; } div.row { display: table-row; } div.cell { display: table-cell; } </style>...

Hierarchical table column in Java

Dear All, Is there any Java library that supports hierarchical column? For example (the first three row are columns) : 2008 | January | February | Week1 | Week2 | Week3 | Week 1 | Week2 | Week3 | 10 | 20 | 14 | 12 | 15 | 3 | Thanks ...

MySQL Multi-Table Join

I need to modify the following MySQL statement to include information from a third table... but I suck at joins. select ss.*, se.name as engine, ss.last_run_at + interval ss.refresh_frequency day as next_run_at, se.logo_name from searches ss join search_engines se on ss.engine_id = se.id where ss.user_id='.$user_id.' group by ss...

displaytag: suppress zeros in HTML table

Hi, I have a HTML table that's generated in a JSP by the displaytag tag library. I would like to suppress any zeros that appear in the table, i.e. they should be replaced by a blank cell. Is there any straightforward way to achieve this? Cheers, Don ...

SQL: How to append IDs to the rows with duplicate values

I have a table with some duplicate rows. I want to modify only the duplicate rows as follows. Before: id col1 ------------ 1 vvvv 2 vvvv 3 vvvv After: id col1 ------------ 1 vvvv 2 vvvv-2 3 vvvv-3 Col1 is appended with a hyphen and the value of id column. ...