table

top 3 records ordered by a field in rails

In ruby on rails how do I find the top 3 records of my table called notices ordered by a particular field, in my case I want to order by the position field which is an integer. so my notices table looks like this any help would be greatly appreciated, thanks ...

Javascript complex array "element reduction" - building an HTML table based on array elements

I have a project that requires the following. Four arrays will be declared in the code as such: var ROW1 = ['module1']; var ROW2 = ['module2', 'module3']; var ROW3 = ['module4', 'module5', 'module6']; var ROW4 = ['module7', 'module8']; Each element of these arrays represents a module in a configurable HTML widget. Based on what eleme...

Compound primary key in Table type variable

SQL Server 2008: DECLARE @MyTable TABLE( PersonID INT NOT NULL, Person2ID INT NOT NULL, Description NVARCHAR(100), CONSTRAINT PK PRIMARY KEY CLUSTERED (PersonID, Person2ID) ); Gives: Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'CONSTRAINT'. Is there any way to have compound Primary key in Table ...

Indexing varchars & Foreign Keys

I have two tables defined below. Create table tickets (id long not null, reseller long not null, constraint pk_lock primary key (id)); Create table ticketRegistrations (id long not null, customer long not null, constraint fkTicketRegistrationTicket foreign key (id) references tickets (id) on update cascade); The client can input ...

scrollable table with sorting

Hi, I want sortable table with scrolling with header fixed. I want these feature with jquery or normal javascript. I appreciate your suggestions. ...

Stacked images in HTML email template have a space between them

I'm building a template for an HTML email I'll being sending via .NET. I don't do this often and I know I have to stick to tables and inline CSS. I just sliced up some images and I have two that need to stack. I understand there are issues with this in terms of whitespace in the HTML code. As a result, I've tried it all on one line, e.g....

Editing table layouts in jQuery

So I'm building a CMS and for a given page, I want to let the client layout the page (not the site layout, the page layout, i.e. the content; headline, text, imageboxes, more links and such) with the given elements. Since table layouts are easy to understand for a client, I'm going to use that. Spare me the "always use CSS layouts" comme...

Are there any .NET libraries that draw a table in console (textmode)?

While writing a small C# application for myself I realized that it would be neat if I could easily draw tables in textmode. You know, like this: +-----------------+-----------------+ | Header 1 | Header 2 | +--------+--------+--------+--------+ | Data 1 | Data 2 | Data 3 | Data 4 | | Data 1 | Data 2 | Data 3 | Data 4 | | D...

How to style the each cell of Flex DataGrid..

I have a Flex DataGrid, which has some columns, i had put a item renderer, which makes all the elements in that column hyperlinked, i have a requirement, where i need to see the type of user, based on that i have to either enable or disable the hyper link. Is there any good way , where i can get the style properties at the cell level......

Lua bindings: table vs userdata

When making Lua bindings for C++ classes, should I return tables or userdata objects? Does anyone know any of the pros and cons for each method? ...

Table cell conditional formatting based on content using jQuery

I simply have a table with a bunch of ✔ X and a few other symbols, how can I change the class of a cell based on it's contents? jQuery example: $(function(){$("td:has('✔')").addClass("tick"); }); $(function(){$("td:has('X')").addClass("cross"); }); ...

Relative access to table cells using jQuery

I have a nested table 3x3 <table> <tr> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td id='myCell'></td> <td></td> </tr> <tr> <td></td> <td></td> <td></td> </tr> </table> So, i need to get cells closed to my '#myCell' - on the left, on the right, top, bottom. var myCell = $('#myC...

fastest sortable javascript html table

i have seen a number of javascript examples to throw on top of an html table to make them sortable. The issue is that everyone i have seen and tried are insanely slow. any suggestions or recommendation for a good performance solution. ...

How to add a <tbody> to the beginning of <table> with jQuery?

<table id="tab"> <tbody> ... </tbody> </table> Likve above,there is already <tbody> inside <table>, $.append will make it to the end of <table>,how to make it to the beginning? EDIT I need to add a callback once new added <tbody> is in DOM,how? ...

jQuery toggle changes element's width? I don't want it to! :(

Hi guys, I currently have a table that has a width of 94%, and the following toggle set to it: $(document).ready(function(){ $("#moreinfo").hide(); $("#toggleinfo").click(function () { $("#moreinfo").toggle('normal'); }); }); It toggles fine, but as soon as you toggle, the width goes really small and I have no idea why...

Should I use a separate table to store online users or should I just use additional fields in the extant members table?

I'm working on an online system that allows users to interact socially and of course it will be important to be able to identify users that are in fact online. I know about HTTP being stateless and I know about using sessions, so I'll need to accomplish this by comparing the last active time of a user to an arbitrary expiration time. M...

Need help with adding a row to a table

I am new to objective-C and I'm having a lot of trouble trying to add new rows to a table. The way it is suppose to work is, when the app loads an alert pops up asking the user if they would like to, start a new configuration, load a saved configuration, or resume the last configuration. Now if they select start a new configuration, th...

CSS: Two-element "table" aligned nicely

Hi This is a somewhat open-ended question, but I really want to understand this one so I don't care. I have a two-element "table" (CSS with spans). The left column always has an icon which is 20x20 pixels. The second column has a single line of text associated with the icon. I have gone through all sorts of ideas I could come up with ...

Table in Header with latex?

I need to create some work instructions in latex. Is there anyway to get a table in the header of a latex page? ...

Jquery Drag-Drop (Getting element being dropped into)

I am trying to detect which cell an object is being dropped into. <table> <tr> <td class="weekday">Sun</td> <td class="weekday">Mon</td> <td class="weekday">Tue</td> <td class="weekday">Wed</td> <td class="weekday">Thu</td> <td class="weekday">Fri</td> <td class="weekday">Sat</td> </tr> <tr> <td class="droppable">&nbsp;</td> <td class="...