Hi I was wondering if there was a simple solution in mysql to truncate mysql entries. i.e. if i want only a maximum of 100 entries in one table if a new entry is submitted, (101st entry) then it would delete lets say the last entry ( ordered by a time stamp ) and insert the new one (still only having 100 entries). Any help much apprec...
Hello, I have a ReportViewer which includes a table. This table is filled dynamically in the code using a stored procedure. Now I want to change the size of the ReportViewer according to the columns in that table. Is that somehow possible? Thanks :-) ...
i am using a table with alternate row color with this. css tr.d0 td { background-color: #CC9999; color: black; } tr.d1 td { background-color: #9999CC; color: black; } html <table> <tr class="d0"><td>One</td><td>one</td></tr> <tr class="d1"><td>Two</td><td>two</td></tr> </table> here i am using class for tr but i want to u...
I would like to make an sql query to compare two tables with identical columns, both names and types. Each table has a unique key. I want the query to return any rows that contain unequal values. I know could do something like this select * from table_1, table_2 where table_1.key = table_2.key and ( table_1.col1 != table_2.col1 OR t...
Hi, I need to be able to expand and collapse certain sections of a table individually by pressing that section's button but if a user wants to see all the data in the table, they hit one button at the top of the table to expand all the information. The use should then still be able to collapse sections they are not interested in and if...
Sorry about the length here. I'm using oscommerce and have a page with all our product specials laid out in a 3 column table. I need to align the price of each product so that all the prices align across the screen with one another. Visually, this is what I would like: |-----------------------| | Image | Image | Image | | Title | Long ...
Ok - I'm having a problem with CSS not displaying correctly between IE and Firefox... The big problem is that we have a ridiculous number of CSS files (and this isn't something that is currently scoped to fix), and I can't seem to find what style is being applied. Any way, here's what I'm looking at: On the shopping cart page for our s...
How could I number the tables in my article chapter based ? So I want all the tables in the fifth section to be numbered like "Table 5.1", ..., "Table 5.n". I tried \usepackage{chngcntr} \counterwithin{figure}{section} \counterwithin{table}{section} \counterwithin{equation}{section} but I am having some problems (missing package ...
What is the optimal / acceptable column count when you are designing a table that serves as a datastore for huge forms to be filled? ...
I'm searching for a way to swap table columns around By some parameters (We are talking about jQuery or what not) And sort of a more general question: is there some kind of good JS library to handle tables by columns? ...
Hello, another newbie mysql question I have a faculty table, and each faculty has a certain number of students under him/her. So there is a 'current' column, which is the number of students currently under them. However, I don't want to ++ and -- everytime I switch a student to another faculty. Is there a way to keep the column update...
I've got an HTML table, where some cells have dynamic content that will change height over time. Let's say I want to have one cell fill the bottom half with one color and the top half with another color. I'd like to do it with HTML/CSS such that as the other cells change height, the color cell will adjust to still be half-and-half (i.e...
Hi, I've got a table and when I remove a row it animates with slideUp. $(id).find("td div").slideUp I used this trick to use slideUp on a row : link text There is no problem when all columns are displayed, but when I have hidden columns, it just removes the row with no animation. I guess it is a normal behaviour from slideUp, but is...
hi just a quick question, is it better to use underscore whilst naming tables or is it better to use camelcase. example table_name or tableName which one is better? and if there is a reason to be using either what is it? many thanks. ...
Hello, I would like to click a button and have a VBScript called to write to a table's lower half eg: -------- |Top |------- |bottom (vbscript writes to here) -------- Is this possible? And how would I accomplish this? ...
I have a table, with a series of events, name of my class is Entry. Here is a picture of my table is in Spanish, but the basics are the same so it shouldn't be a problem. (the filter HTML code is not yet so its a mess but it works) and here are the results that I get when I look for the entry. Now my problem is that I need the resu...
This seems like a classic rails situation: I want to have a my index action display a sortable table of the items. I've looked at (and hacked at) some plugins, notably thoughbot's sortable_table and Michael Kovacs's sortable (the latter I have forked and improved). However, now I'm finding that sortable is somewhat incompatible with inhe...
Hi, I can't make a table I've 'embedded' in another div arbitrarily tall/short: #header table.rates { float: left; width: 210px; border: 1px solid black; border-collapse: collapse; padding:0; margin: 5px; font-family: Verdana, Helvetica, Arial; font-size: 10px; } #header { clear:both; float:left...
I have an abstract class User and 2 classes which inherit from it, namely BEUser and FEUser. Information about all users (FEUser and BEUser) is stored in a single table. Does Doctrine allows this kind of mapping? Any examples? Also if doctrine supports it which object does the table class return (FEUser or BEUser)? Thank You ...
Hi I am trying to create a .dbf table using visual c# because i need it to import data to another application. For that purpose I need the column order to be exactly right otherwise that application won't accept the table. It's been working fine so far, but recently I had to make some changes to the structure of the table, and I have ad...