table

Python: Data Structure for Maintaing Tabular Data in Memory?

Hello, My scenario is as follows: I have a table of data (handful of fields, less than a hundred rows) that I use extensively in my program. I also need this data to be persistent, so I save it as a CSV and load it on start-up. I choose not to use a database because every option (even SQLite) is an overkill for my humble requirement (al...

Table-agnostic Foreign Keys?

So, a simple question. First, I did read this StackOverflow question, so no need to point me towards it. I'm working on a similar problem right now. Specifically, I have a database with an Auditing table that is used to store auditing info about other tables within the db. The basic form of this table is: ID, EntityID, EntityTypeID, Ac...

SAS Proc SQL Database Table Insert

Using SAS's Proc SQL, is there a way to insert records from a SAS Dataset into a table in the open SQL Server connection? Something like this (which doesn't work): proc sql exec; connect to sqlservr as DataSrc (server=my-db-srvr database=SasProcSqlTest); create table Items as select * from connection to DataSrc ( SELECT * FROM ...

Moving table rows in a particular pattern with jQuery

Hi All, I have a table with rows basically like this. Normal Row Normal Row Normal Row Summary Row Normal Row Summary Row Normal Row Normal Row Summary Row So basically X "normal rows", which will always be followed by a "summary row". The summary rows display aggregates of the data in the normal rows. I calculate the aggregates at ...

Possible to fill a table cell with a bg color?

I have a table cell that isn't entirely filled with text so the bg color doesnt cover the entire cell. I still wish to have the entire table cell filled with the same color without using a background color on the whole table. So is it possible to fill the entire cell with a color without using background color on the whole table? ...

Loop through multi dimension array to show grid in PHP

I have 3 tables. Apls, Hulls and AplsHulls. Apls consists of id, name, date Hulls consists of id, production_name AplsHulls is a join table and consists of id, apl_id, hull_id, status. Not every Hull is associated with each Apl. The ones that are are in the join table with a status (shipped,in production, etc.) I need to display a rep...

how to do lua table operations from C?

I need to perform operations on Lua tables from C where the tables are treated as lists or queues. Specifically I need to insert an element at the head, and remove the head element, and have the other elements move to accommodate the new element. This would be simple in straight lua, i'd use table.insert and table.remove. But in C? The...

Getting offsetTop of element in a table

Hello, I can't seem to figure out how to get the offsetTop of an element within a table. It works fine on elements outside tables, but all of the elements within a table return the same result, and it's usually at the top of the page. I tried this in firefox and chrome. How do I get the offsetTop of an element in a table? thanks! ...

fact tables (Analysis Services)

I was just wondering if there could be any fact table, the keys of which dont belong to any of the dim tables? However, the fact table seems to contain the dim data. The reason I came up with this question is that I was looking into a package which uses a dim table and fact table to pull data from, manipulate and them dump into the fac...

jQuery selector for every row except the first on every table except first

I want to apply right alignment on the last cell of every table row, skipping the first table on the page and skipping the first row of every table. I wrote the following: $("table:gt(0) tr:gt(0) td:last-child").css("text-align", "right"); The tables after the first are selected. GOOD. The last cell in each row is aligned right. GOOD...

nested tables: 1px border with css

Hi, I'm trying to create a table with a 1px black border. I have to nest a table in the main table, and get "thick" borders where the nexted table butts against its enclosing . I just want a 1px border everywhere. I have this, in effect: table.outer{border:1px black solid; border-collapse: collapse;} td{border:1px black solid; border...

How can I make a part of text bold in an MS Word table cell?

Hi all, I have C# application which uses an MS Word document. I have tables and I need to meed make some of the text in a cell bold. Is there a way to do it? Thanks all in advance. ...

HTML: CSS: Table column width increases inspite of setting it to a fixed value.

For the issue pls see the screenshot here. The above code has been generated by the html. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"&gt; <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" > <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> ...

Algorithm for Determining Tic Tac Toe Game Over (Java)

I've written a game of tic-tac-toe in Java, and my current method of determining the end of the game accounts for the following possible scenarios for the game being over: The board is full, and no winner has yet been declared: Game is a draw. Cross has won. Circle has won. Unfortunately, to do so, it reads through a predefined set o...

MySQL - Getting search results from table and referencing tables

Hey everyone, (Using MySQL and PHP) I have a search form that will allow my users to type in a string, and search that string on a particular criteria. My problem is that a user needs to be able to search for information that is "spread" across multiple tables. For example: -Table "users" contains fname, lname, role, username (PK) -...

HTML TD wrap text

Hi, I want to wrap a text that is added to the TD. I have tried with style="word-wrap: break-word;" width="15%". But the wrap is not happening. Is it mandatory to give 100% width ? But I have got other controls to display so only 15% width available. Need help. TIA. ...

How do I create control tables in DB2 UDB for setting up new replication

How do I create control tables in DB2 UDB for setting up new replication ...

HTML tables

<table cellspacing="0" cellpadding="0"> <textarea rows="5" cols="60" name="question"></textarea> <tr> <td><input type="text" readonly="1" value="127.0.0.1" /></td> <td><input type="submit" value="Skicka" /></td> </tr> </table> equals to http://i42.tinypic.com/14j18xz.jpg How can I do so that the submit button stays where i want i...

jQuery remove HTML table column

Hello. I have a HTML table like this: <table border="1"> <tbody> <tr> <td><a href="#" class="delete">DELETE ROW</a>COL 1</td> <td><a href="#" class="delete">DELETE COL</a>COL 2</td> <td><a href="#" class="delete">DELETE COL</a>COL 3</td> <td><a href="#" class="delete">DELETE COL</a>COL 4</td>...

dynamically hiding a portion of a HTML table

I have a table of data from mysql rendered on page via PHP into a HTML table. Within this table of data, I have a row of data that should be focussed on (let's call it) row X. I want the 2 rows above and below row X to be shown but all others hidden, as row X moves up and down, this would change (obviously) what was hidden, when row X...