table

Table per-subclass strategy when populating a large tree from a database using NHibernate

I am using NHibernate to load a large tree of objects of different types. Mapping is implemented using table-per-subclass strategy. I defined a base class "Node" that has only a few fields (NodeId, ParentId, NodeType) and several subclasses that inherit from Node and add their own fields. The implementation of this approach was straight...

Can't remove borders from tables in Word export

I'm having an issue when I export my html page to Word, I can't get rid of the borders on a table element. <table cellspacing="0" cellpadding="0"> <tr> <td class="title">Analyst</td> <td> <asp:Label ID="lblAnalyst" runat="server" CssClass="data" /> </td> <td class="title">Borrower</td> ...

Sorting a table in PHP

Hi, I have some difficulty sorting my array. It looks like this : [0] => Array ( [firstname] => Jnic [lastname] => Fortin [points] => Array ( [id] => 20453 [f] => 31 [r] => 7 [tota...

Enabling NSButton with bindings, based on NSTableView selection

I have a NSWindow containing an NSButton and an NSTableView. I'd like the button to be enabled if and only if the table contains at least one item, and exactly one item is selected. (The table does not allow multiple selection.) What can I bind the button's enabled binding to to make this happen? ...

Iterate through html table using jQuery, converting the data in the table into JSON

I came across a case where I have to convert html table data into json. In this process I have to iterate through table and convert one by one(row) into array and then convert the whole array into json? Need help in iterating through table(each ow and column)? ...

Copying a table from one SQL server and DB to another using SQL Server management studio

I have a website I have developed using a databse and I have created some security on the site. This ceates another DB called ASPNETDB.MDF. The main site database is on a server at the website host. At this time the aspnetdb is in the APP_DATA folder of my website. I want to copy the tables and their data from the aspnetdb to the main ...

JQuery tr add class after first 5 rows

Hi there... i have n-tables on a page. I need to go through every table on the page and within each table i need to add a class to the rows but NOT the first 5 rows. my current js: $('.selector').each(function(){ var trCount = $("tbody > tr", this).size(); alert(trCount); }); this goes through and tells me how many tr's i have...

Jquery - Implement extension to table sort

Ok..so some kind fellow helped me with how to identify the first 4 rows and then apply css to them alone.. $("table").each(function() { $("tr:gt(4)", this).addClass("hidden"); }); $("table").tablesorter(); (http://www.tablesorter.com) now i need to modify the tablesorter that comes with an extension so that when ever the sort is p...

JQuery: Given a Parent Element, Testing for Certain Child Elements

NOTE: QUESTION HAS BEEN EDITED FROM ORIGINAL FOR CLARITY Hi all, I have the following code: <table id="myTable"> <th>Date</th> <th>Action</th> </table> and var $table = $('#myTable'); There is a condition in my JS where I will be appending table rows (<tr>) to this table, but I want to write a function to check to see if ...

jQuery - Save Function Result Into a Variable

I have this function, which loads a select from a database. function Competition() { $(document).ready(function() { $.ajax({ url: "load-comp.php", cache: false, success : function(html) { // something here } }); EditRow(); }); } I need to put that select ins...

sql server field naming conventions

i have a database that has 50 tables and all the tables have primary key on a field named ID. so example, Employee.ID, Customer.ID, order.ID, every single table has ID as its primary key. should it not be Employee.Employee_ID, Customer.Customer_ID and so on? is there any drawback of using ID as name of every ID field in each table? if so...

advanced sql query help

i have a table with products and the user can choose which regions and cities he wants to let them be visible to. he can choose ALL REGIONS and ALL CITIES from a drop down menu and then i will put in the columns = 0. the the buyers can choose which city they want to watch products from so they aslo have a drop down menu to pick a region...

Alternative to JQuery hide show? or Jquery Update?

Hi there.. I have nearly finished a table which has hidden object and sorts.. $(".ICS_BlueTable").tablesorter(); $(".ICS_BlueTable").bind("sortStart",function() { $('.ICS_Artist_Hide',this).toggle(); $('tr',this).removeClass("ICS_Artist_Hide"); }).bind("sortEnd",function() { $("tr:gt(4...

Excel structured reference table syntax

I try to avoid using excel too much but when I do I like using structured references as they seem a lot cleaner to write. If I create a table called "table1" with columns "col1" and "col2" how would I reference the first row in "col1" using a structured reference in another table? I have tried the syntax =table1[[#this row],[col1]], and ...

MySQL structure help for joins ( large tables)

Hello I currently have 2 tables that are used for a select query with a simple join. The first table houses around 6-9 million rows, and this gets used as the join. The primary table is anywhere from 1mil to 300mil rows. However, I notice when I join above 10mil rows on the primary table the select query goes from instant to very slow (...

text-align not working as expected

I am attempting to make two elements on different sides of their container. In my actual code these two elements are to be on opposite sides of a div, but for the sake of example, lets say I want them on opposite sides of the browser window. So I did a simple <html> <head> </head> <body> <table> <tr> <td style="width: 50%;text-align: l...

Running 4 make table queries on a time schedule with no human interaction

I have four make table queries that need to be ran in a certain order and on a daily time schedule. I tried creating a macro that would open them in order but it required human interaction to exit out of the warnings and it failed to move on to the 2nd query. Any ideas? ...

Drupal theme_table... A way to theme nested tables?

Title pretty much explains what I want to do... I'm not a fan of using nested tables, so believe me, I'm unhappy and would so, so, so totally prefer something else... but, c'est la vie... Essentially, I'm trying to figure out how to create a nested table utilizing the theme_table function... I can't seem to find any information on ho...

Multiple users table VS 1 users table? (mysql and php)

I am in dilemma situation. I am not sure if its a good idea to separate the users table. I notice my game highscores table performances, as the numbers growing, the loading is getting slower and slower. My current users table store all users, which currently about 10k users. I am thinking of splitting the users table (for future) into l...

Javascript Tablemodel Widget

I am looking for a JavaScript MVC table widget similar to Java Swing TableModel I would also like to have two models, one totally local and one remote (XMLHttpRequest) I would also like the view to accept text columns (and maybe HTML columns) and have these text columns HTML or CSS formated depending the cell contents (just like you wo...