table

Hiding Rows Given A Certain Criteria (slow)

I'm trying to hide tr's within a html table if the inputs inside them match a certain criteria. The criteria is defined by a dropdown's selected value. I'm doing it like so: $(function () { $('body').find('#p_Selection').live('change', function () { var type = $('body').find('#p_Selection').attr('value'); var tableRow = $('....

join 2 tables in mysql, return rows that don't relate

I have 2 tables: table 1: questions (id, question, date) table 2: answers (id, question_id, answer, date) a question can have more than 1 answer, some questions don't have answers. I want to output only unanswered questions a query like "SELECT * FROM questions,answers WHERE questions.id!=answers.question_id group by questions.id" do...

Multiple thead/tbody design

I have a question about usability/design. I currently am using some JQuery to hide/show entire areas. Currently these are all in one big table with a thead at the very top as the main header, followed by a second thead which is the header of what would be displayed. Next is another thead which is the header of whatever is hidden which is...

Table: each cell links to url containing column and row data

I want each cell in my table (excluding headers and has to be a number) to link to a URL which is formed using the position of the cell, ie the cell number and column number of it. Eg a cell will link to example.com/hello.html?column=1&row=3 Ideally this would be done with jQuery...unless there is a better way? I can't easily alter the...

SybaseIQ cursor over atemporary table behaves as read-only even if 'for update' was specified

Hi, I'm attempting to update a temporary table using a cursor that was declared 'for update'. The update does not work: [Error Code: 7732, SQL State: 42W30] ASA Error -633: Update operation attempted on a read-only cursor The sybase iq 12.7 docs says that the cursor becomes read-only under some circumstances, like for example if aggreg...

Filter categories/sub-categories with jQuery

I have a table where each row has a category column and a sub-category column. I need to let the users chose a category to filter, and then only show the sub-categories that are related so they can filter further. I'm thinking it could be a select drop-down list and only show a second drop-down list when sub-categories exist. I've seen s...

Table Row Still taking up Space after calling JQuery Remove on it

Hi Everyone, I'm having a strange problem and haven't been able to find anything about it anywhere. I am using the JQuery remove method on a table row and while it is removing it, it is still leaving a small amount of space where the row used to be. It's hardly even noticeable if I only remove a row or two, but when I remove more you ...

How to store information about many people in java

Hi, my problem is to store details of people in java. I looked up at the oracle website topic How to Use Tables and found out that one can use object arrays(2 dimensional) to store details. But my interest is to make a dynamic object array so I can store any amount of data and also take input to store those details from the user. For i...

Scroll bar issue with safari browser.

I have encountered a problem with safari browser in displaying the scroll bar inside a table. The main issue is that I have defined a table with fixed height and also a overflow y in css so that if the content exceeds the limits the scroll bar comes in action.I have found that it works well with mozilla fire fox and all other browsers. ...

CSS table design not working

Hi, I have this table: <table style="width: 512px; border-collapse: collapse;" cellspacing="0"> <tbody> <tr> <td style="background: #00f; height: 9px; width: 9px;"></td> <td style="background: #0f0; height: 9px;"></td> <td style="background: #f00; height: 9px; width: 9px;"></td> </tr> </tbody> </table> Please no "do not use tables" k...

Trying to select all but the 1st TD'd in the last row in a table using JQuery

I have a table that contains totals at the end. I need to select all TD's in the last row except the 1st TD which says the word TOTAL. This does not seem to work, any idea's? $(".tableclass tbody tr:last(td:not(first-child))").css({'color':'#FF0000'}); Thanks ...

DataServiceRequestException was unhandled by user code. An error occurred while processing this request.

DataServiceRequestException was unhandled by user code. An error occurred while processing this request. This is in relation to the previous post I added public void AddEmailAddress(EmailAddressEntity emailAddressTobeAdded) { AddObject("EmailAddress", emailAddressTobeAdded); SaveChanges(); }...

Exception of type 'Microsoft.WindowsAzure.StorageClient.StorageClientException' was thrown.

Exception of type 'Microsoft.WindowsAzure.StorageClient.StorageClientException' was thrown. Sometimes even if we have the fabric running and the role manager is up, we get an exception of this sort. The code breaks at the line emailAddressClient.CreateTableIfNotExist("EmailAddress"); public EmailAddressDataContext(CloudStorageAccou...

Database: Multiple tables or just one table?

For example I have photos and videos tables, I can comment on these, but when I send it to database which way is better? To have 2 tables for comments: photo_comments and video_comments Or to have 1 table comments and create a row inside the table like type and put there if it's a photo_comment or video_comment I think the 1 is faste...

How to quickly prune large tables?

I currently have a MySQL table of about 20 million rows, and I'm in an urgent need to prune it. I'd like to remove every row whose updateTime (timestamp of insertion) was more than one month ago. I have not personally performed any alterations of the table's order, so the data should be in the order in which it was inserted, and there is...

C++: Force the order of functions in the virtual method table?

Hello, How can i control the order of virtual functions in the virtual table? Are they laid out in the same order that they are declared in? When inheriting a class with a virtual table, is the virtual table of the inherited class an extension of the base class, or is an entirely new virtual table created with only the inherited classe...

jQuery align table (number of rows/cells) based on screen resolution

I have a table like this (8 cells only for illustrative purposes, may be more or less): [1] [2] [3] [4] [5] [6] [7] [8] Each item in each cell is roughly 450px wide, so they fit comfortably next to each other on a 1920x1200 screen (which, incidentially, is mine). However, I need this configuration to change automatically and align the...

UI pattern for editing temporal tables

I'm writing a web interface to edit several values that change over time (for each employee, the changing attributes are role/division/workplace/type of contract/etc) and show the history of each change, and server-side validation. The user must be able to add new values, amend previous ones, change dates between periods, and so on. I a...

How to Add Columns to a Nested HTML Table

Good Morning All, I'm admittedly a DIV guy, but am working on a project that uses nested tables. I have a need to move some fields that already exist, and create new fields, into what I would describe as a grid (think gridview in .NET). What is the most painless way to add columns to the nested HTML tables? Alternatively, should I in...

Hide/Show Values Inside TD tags

How can I hide or show the value contained inside a TD tag? E.g: <td id="dateCell<%= i %>"> <%= Html.Encode(row.ActionOn.HasValue ? Html.FormatDateTime(row.ActionOn.Value) : Html.Encode("")) %> </td> How can I get the encoded value and hide or show it depending on a condition? ...