table

Loop through selected table rows with JavaScript

Hi, I have a table, containing a checkbox to select the whole row (or not). This selection is done through JavaScript (JQuery) by setting a class attribute on the row. function SelectRow(pRowID) { $("#"+pRowID).toggleClass("selected"); } Next step, I want to loop through all selected rows of the table (to extract data from it). A...

SQL Combine Columns into a string

Hello, I have a table with the following columns in table: id, t1, t2, t3, t4 All are of type bit (There are other columns as well, however I am only showing the relevant one) Now, I need to get the following string based on the ID: t1 t2 t3 t4 The best I thought of would be this: declare @t1 bit, @t2 bit... Select @t1 = t1, @t2 =...

Does jQuery's show() method work on tables in IE?

I have a table with some of the rows starting off hidden (display:none) and I'm using jQuery to show them. I've gathered from Firebug that jQuery detects that they're table rows and sets them to display:table-row rather than block. However, IE6 (and I think 7, too) doesn't support table-row, so does jQuery do something different for tho...

Run script in php for items not modified yet in mysql

I have db with column named "link" Links have redirect urls, which I want to change. I have php script, which would take the link and gives me out put as follows $redo = get_redirect('htp://www.mydomain.com/long/url/here&ID=123'); print_r($rez); this is the output: Array ( [0] => htp://www.otherdomain.com ) how do I loop all i...

How to map dynamically created table in Hibernate?

I am working on a web application. We are using Hibernate as ORM in our project. Actually, our application creates some tables dynamically based on user selection. The user can select table name, column name and then s/he can import data from a csv file. So my question is: how to map this dynamically created table with Hibernate and Java...

Find most occurring records. RoR

suppose there are 3 fields in a mysql table. id, word and date. the word field is not a unique field, so many records have the same word. so how do i find out which word is repeated in records the most? exactly. the most repeated 5 words.. thanks ...

SQL Server StoredProc vs UDF inline table

I have written a complex query that will return me a list of IDs. Now I want to re-use this query so that I join the results with another query. For that I plan to put this into a Stored Proc or an UDF and then use it to insert into a temp table. Something like below 1) Put the query in a Stored Proc and insert it into temp table INSE...

HTML: What I'm doing wrong in display this table?

Probably this is a stupid thing, but I don't see it. What is the problem? <html> <body> <form action="search" method="get"> <input> <input name="action" value="search" type="submit"> </form> <table border="1"> <thead> <th> <td>Name</td> </th> </thead> <tbody> <tr> <td>Smith <...

Table vs CSS-based layouts for web pages

Hi, I use HTML templates for my website from sites that sell templates as I'm not a designer and would like something ready, I use Rails for my development. I noticed that some sites design their templates as "Tableless" by using CSS and absolute posistioning of components in the page. I'm actually used to using tables in my pages. Wha...

asp.net dynamic insert rows into middle of table

I want to add a few dynamic rows right in the middle of a table which is otherwise defined in static markup. Unfortunately, Web.UI.Table has no exposed AddAt method. It looks like I can dynamically AddAt on a Web.UI.ControlCollection, and it looks like internally, Web.UI.WebControls.Table has a RowControlCollection.AddAt method, but MS...

min-width and max-wdith are ignored when element has display:table-cell

I'm trying to do simple fluid layout using CSS tables techniqe, but there is one big flow that I have found in it: min-width and max-width are ignored on elements with table-cell display. Do you know any workaround that would allow me to specify how far #sidebar element can stretch in the following example? XHTML: <div id="wrapper"> ...

Which is the better way of specifying HTML Fixed Column width (width or style attribute)

I would like to ask what is the better way of specifying HTML column width? the width attribute or the style attribute? Assuming I am using IE 6. Does IE render the width attribute better than style? By width attribute <table width="900"> <tr> <td width="450">A</td> <td colspan="2" width="450">B&C</td> </tr> ...

Problem with rowIndex in Javascript

Hi, i currently have a big problem with the rowIndex in the IE8. When i call the page i have an empty table element. With Javascript i now add Rows and Columns to this table. // Create Elements tr = document.createElement('tr'); td = document.createElement('td'); // Append Elements to existing Table tr.appendChild(td); table.appendChil...

Create table variable in MySQL

I need a table variable to store the particular rows from the table within the MySQL procedure. E.g. declare @tb table (id int,name varchar(200)) Is this possible? If yes how? ...

how to reduce growing size of an access file?

Hi, So, at my workplace, they have a huge access file (used with MS Access 2003 and 2007). The file size is about 1.2GB, so it takes a while to open the file. We cannot delete any of the records, and we have about 100+ tables (each month we create 4 more tables, dont ask!). How do i improve this, i.e. downsizing the file? thanks. ...

Wrong results in JavaScript table

Hi, I'm trying to create a matrix for 12-tone music. The numbers between 0-11 show the intervals between pitches. My script shows the matrix correctly as it runs initially with the page; but when we do another calculation with the button, it goes messy, even with the same pitch set. Here is my script: var exist = 0; function ex...

how to add NavigationBar with Editbutton on left to the Uitable In Iphone?

Hi, In my iphone application i have added the Uitable view.While launching the application the table is showing the No. of rows which i want.Now i want to add the Navigation bar to the UiTable,also i want to add the edit button on the left side of the navigation bar. How to add the Navigation bar in the UiTable view in iphone?I dont wa...

css border-bottom iexplorer

css: .item_fact{ border-bottom:#CCCCCC 1px solid; } html: <table> <tr class="item_fact"> <td> hello </td> <td> world </td> </tr> </table> IE7 does not display the border-bottom, but firefox and chrome does! how can I hack this css? =) thx. ...

Load a View before it's Seen.

I have a tabbed application which utilizes two main views. The first is to track the current run, and the second is a table of those which are saved. The default tab is the "current" tab. The problem is that if I try to add to the array in the second tab before I've literally 'seen' it, the table doesn't load correctly. I've managed to d...

Is there any table changes tracking tool for mysql which will log all changes into other table?

Hi, I am working on a Project management system on PHP (CodeIgniter framework), Mysql, AJAX, XAMPP, JQUERY. I need a customizable table changes tracking tool which will log all changes into another table in same database for mysql. Basically I need to have a table which will have log details of updates, inserts and deletes on a database...