table

Table Design Into Nested Datalist

I Use codes below to see a result like picture 1, but a result like picture 2 is coming. What should be done to solve it? aspx code: <asp:datalist id="dtlUrun" runat="server" RepeatDirection="Horizontal"> <ItemTemplate> <table class="dtlTable"> <tr> <td class="dtlHeader"></td> <td class="dtlHeader"><%#DataBinder...

Best relationships between one table and some other tables, each of them depending on n datasets of the first table?

I have one table that saves comments for a varied set of content types. These are saved in other tables (news, articles, users). I wonder what's the best way to connect these tables? In previous projects I used a second table for each kind of content. They held the id of the certain content mapped to ids of the comments table. So for ea...

table tags for form display are bad... but what about survey questions likert type?

Is it bad design to use table tags when displaying forms in html? The accepted answer to this question in short: YES... ...but what about something like this: I can't really think of an economic solution with CSS. But I'm not a CSS geek. The example is from LimeSurvey and uses tables. Is it still bad design to use table tags for su...

Even column heights without using a TABLE

Is there a way to have two columns, that match each other in height, without using table cells, fixed heights or Javascript? Using a TABLE <table> <tr> <td style="background:#F00;"> This is a column </td> <td style="background:#FF0;"> This is a column<br /> That isn't the ...

creating a sql table from a xls (Excel) file

I'm trying to convert an Excel document into a table in SQL 2005. I found the link below and am wondering if it looks like a solution. If so, what would the @excel_full_file_name syntax would be and where would the path be relative to.. http://www.siccolo.com/Articles/SQLScripts/how-to-create-sql-to-convert-Excel_to_table.html ...

Why are cellspacing and cellpadding not CSS styles

I don't know why this bothers me so much, but when I create websites, I always try to do all my styling with CSS. However one thing I always have to remember to do when I'm working with tables is add cellspacing="0" and cellpadding="0" Why is there not a CSS property to override these antiquated HTML 4 attributes? ...

Yet Another Divs vs Tables Question: Forms

[Meta-note:] I was browsing the question page, getting really tired of "DIVS vs Tables" "When to use tables vs DIVS" "Are Divs better than Tables" "Tables versus CSS" and all the questions that ask THE SAME THING OMG PEOPLE but I would like to see all the ways people tackle the translation of the canonical example of "why you should give...

How to set cellpadding & cellspacing in CSS?

How can I control cellpadding and cellspacing in a CSS stylesheet to obtain the same effect as when putting the attributes on the table tag? ...

How to grab control collection like the Table class does?

How do I grab the controls inside of a UserControl tag? So if this is on a Page: <ME:NewControl ID="tblCustomList" runat="server"> // ... these controls will be used in my UserControl.aspx </ME:NewControl> How do I access those controls in my UserControl? For instance, the Table class does this: <asp:Table ID="tblNormal" runat="ser...

basic php form help (2)

This is an extension of a question I had yesterday. I am trying to make a little php calculator that will show how much people can save on their phone bills if they switch to VoIP, and how much they can save with each service. I have a form that will spit out the right amount for a monthly bill here: http://www.nextadvisor.com/voip_se...

Big MySQL Tables

I'm working on a problem that requires caching paginated "search" results: http://stackoverflow.com/questions/347277/paginating-very-large-datasets The search works as follows: given an item_id, I find the matching item_ids and their rank. I'm willing to concede not showing my users any results past, say, 500. After 500, I'm going to...

How do you deal with discrete sets of non integer numbers?

I have a program that needs to do a *compile time checkable** map from one known set of values to another known set of values: in out ------------ 8 37 10 61 12 92 13 1/4 109 15 1/4 151 etc This would be easy if the inputs were either integers or evenly spaced. I'm going to be iterating over the rows but also w...

How does MS Access joins linked tables (linked to the same SQL server database)?

Hi, I've got MS Access database with linked tables, whever each table is linked to a table in the same SQL Server database. I have a query inside Access that joins 2 tables (in particular i'm updating a table based on another using a join). The question is does Access "download" all the table data before doing a join? Or is smart and j...

In PostgreSQL, Is It Faster To Include TEXT Columns In The Same Table, Rather Than A Separate Table?

Which design do you think runs faster on PostgreSQL? A. Making a 15 column table of varchars and the like, but putting all TEXT columns in a separate table with an fkey link back to this table. And let's imagine you want to search for the record with ID of "4" but then pull all the rows back, including the stuff from the TEXT columns in...

MySQL tool or query that suggests table structure

I used a query a few weeks ago in MySQL that described a table and suggested possible improvements to its structure. For example, if I have an int field but only the numbers 1-3 in that field, it will suggest set(1,2,3) as the type. I think I was using phpMyAdmin but I've been through all the functions I can find - Analyze, Describe, Ex...

How can I add column resizing to a MooTools sortable table?

I want a table similar to this one, but where the user can adjust the height of the table as well as sort it. How can I do this? ...

Space between two rows in a table?

Is this possible via CSS? I'm trying tr.classname {border-spacing:5em} to no avail. Maybe I'm doing something wrong ? ...

Does an ASP.NET SQL Library Exist for Managing Tables?

Does anyone know of a SQL library in ASP.NET that can be used to manage tables? Eg SQLTable table = new SQLTable(); table.AddColumn(“First name”, varchar, 100); table.AddColumn(“Last name”, varchar, 100); if(table.ColumnExists(“Company”)) table.RemoveColumn(“Company”); The operations I am looking for are adding, editing and deleti...

Insert default values in a column (access db)

How can I do for inserting a Default Value into a column of a table in Access? I use this instruction: ALTER TABLE Tabella ADD Campo Double DEFAULT 0 ALTER TABLE Tabella ADD Campo Double DEFAULT (0) ALTER TABLE Tabella ADD Campo DEFAULT 0 ALTER TABLE Tabella ADD Campo DEFAULT (0) ALTER TABLE Tabella ADD Campo SET DEFAULT 0 ALTER TABLE T...

In Reporting Services, the Table Details is not displaying in the preview

I put a table into my report with labels in the first column and mappings in the second column, but when I click on the preview (in the IDE) the table does not show up. The "Initial Visibility" is set to "Visible". I'm using VS 2005 Team Explorer Edition (Which is open from Sql Server 2005 BI) Here is an sample xml (code), if that m...