table

jQuery UI Resizable in TH

Hello. I'm traying to make a table with the th's of the header resizable. Here you can see an example where I first try de resize with a div and then with a table (it works great). Then I try the resize with the th's of another table. Nothing happens. http://jsfiddle.net/UVsKp/ Can the th's be resized using jquery UI?? Thanks in adv...

Create a SQL table with a varying number of columns

I have two tables, say teacher and student. I want to build a third table called class. The class table will have one column for the teacher of the class. But I want too see if their is an elegant way to represent the students. My first thought is to have say 30 columns.. student1, student2 and have quids for each of these that tie back ...

Perl - If table does not exist

I'm currently using the following which works but throws an error every time the table is created (as it is first trying to insert into a db which does not exist and returning false). $result = $dbh->prepare("INSERT INTO `". $host ."` (URL) VALUES ('$href')"); if( ! $result->execute() ){ $result = $dbh->prepare("CREATE TABLE `" . $h...

2 tables 1 view ASP MVC

Hi, I need some help. What I am trying to do is show the locations of a device belonging to a specific project. On the projects page I have a button which goes to the google map. For projects I have a Projects model and controller. Ive got 2 tables, a table containing the location of a device and a project table. I want to display all...

Programmatically create table, enter values in it, retrieve the entire contents

When I go to parse through the table, all the stuff I created programmatically is missing... I must be forgetting something so that it's losing all the stuff that I built programmatically (I am only getting the shell of the table). Any ideas? If I put the table in a Session object after I programmatically create it then it works exc...

Versioning in SQL Tables - how to handle it?

Here's a fictional scenario with some populated data. For tax purposes, my fictional company must retain records of historical data. For this reason, I've included a version column to the table. TABLE EMPLOYEE: (with personal commentary) |ID | VERSION | NAME | Position | PAY | +---+---------+------------+----------+-----+ | 1 | ...

Replacing td tags with td and attributes

My Problem is for particular case occuring in my project. in my Html document, i want to replace <td> with <td class=”right”> for all tds except first one in a <tr> tag. (if there is <tr> inside a <tr> tag then that also needs to be handled). if input is like <tr> <td>1</td> <td>2</td> <td>3</td> <tr> output should be like ...

JQuery Navigation Table. Showing and hiding every other row?

I have a table layout that I am using as a navigation bar. It's like a tree-menu where some rows are headers for the ones below it. It goes a little like this (some tags removed for readability): <table id = "QLM"> <tbody> <tr id = "QLM0"> <tr style = "display: table-row"> <tr id = "QLM2"> <tr style = "display: table-row"> <tr id = "QL...

Connecting Tables in Rails

Table City Model class TableCity < ActiveRecord::Base has_many :near_cities, :foreign_key => "nearcity_id" end NearCity Model class NearCity < ActiveRecord::Base belongs_to :table_city end Controller @table_cities = TableCity.find(:all, :conditions=>{:state => params[:gm], :language => params[:sp]}, :include => :near_cities)...

How do i reduce the width of the cell which is longer

Iam Generating the Html in excel sheet and entire table is fine and except the two cells are much wider How do i reduce the width of those cells .I treid changing the width and everything but no use .:It works fine on Html table .On excel spread sheet it looks different ...

How to convert an array into MySQL Table?

What I want to do is: $array_data = array( "a" => array(1, 2, 3), "b" => array( 1, 2, 3 ) ); $table_converted = CONVERT_TO_MYSQL_TABLE( $array_data ); while ($row = mysql_fetch_assoc( $table_converted )) { echo $row['a'] . " union " . $row['b']; } Thanks! ...

using MAX aggregate between two tables

I have two tables, employer and position: Employer eID eName Position eID salary I need to match my eID between the two tables, determine what the max salary is, and print only the eName. Any suggestions as to how I can do this? I have tried multiple ways, but nothing seems to work. I am not sure where to put in the max(salary) ...

Table and Body with two separate background colors.

Hey all, simple question I'm sure, but I would like to have the body of a page be one color and to have the table in the center a separate color. I tried specifying body color and table color, but body always overrides it. I'm attempting this in css, and I have a feeling I need to use a "not" excluder to make this happen? Such as specify...

how to use css to style a descendant (not a direct child) of an element?

Hi, I am trying to override the style of a descendant(not the direct child) of an element using css. Say, I am working on: <table id="z_d__h3-real" class="z-hbox"> <tbody> <tr valign="top"> ----- </tr> </tbody> </table> I want to override the style to set the valign of the tr element to "center". I tried doing: table....

How to update multiple tables with one SQL statement in DB2

psudo-code as follows: update TABLEA a, TABLEB b set a.addr = 'aaa', b.name = 'bbb' from TABLEA a, TABLEB b where a.id = b.id and a.id = 1 ...

Zend Form Decorators Error in Table

I am using the next decorators for my input. I want to make this as table. $this->setDecorators(array('ViewHelper','Errors', array(array('data'=>'HtmlTag'), array('tag' => 'td')), array('Label', array('tag' => 'td')), array(array('row'=>'HtmlTag'),array('tag'=>'tr')) )); But after form validation Er...

Table Value Parameter missing data table data

I'm new to TVP in SQL Server and trying to understand the basics. I created a sample TVP in the Northwind database in SQL Express. My code from VB.NET is fairly simple (see below). The TVP parameter is empty in the procedure. I've tested the TVP in SQL Server and it works fine. Any ideas? Does SQL Express fully support table value parame...

How to check if a database exists in Hsqldb/Derby?

I am looking for information how to check if a database exists -- from Java code -- in hsqldb and in apache derby. In Mysql it is quite easy, because I can query a system table -- INFORMATION_SCHEMA.SCHEMATA -- but these two databases seem not to have such a table. What is an alternative to mysql query: SELECT SCHEMA_NAME FROM INFORM...

Powerpoint Table, rows and cells...

Hello, I have this table in PPT and I go to check cells dimensions in this way: foreach (Row r in table.Rows) { //loop rows in table foreach (Cell c in r.Cells) { //loop cells in row String cellText = c.Shape.TextFrame.TextRange.Text; float cellWidth = c.Shape.Width; Cons...

How to find when a table was last accessed/updated for SQL Server 2000 sp4

I need to find if a certain table has had any activity(update/query). Is there are way to find this information in SQL Server 2000 (sp4 to be specific) There is a helpful query using sys.dm_db_index_usage_stats, but it is supported only post SQL Server 2005. I am looking for something similar on SQL Server 2000. Thank You for your time...