table

Draggable <td> content using jQuery

Hi, I would like to use jQuery and its drag-and-drop function, such as: http://jqueryui.com/demos/draggable/ In my case, I would like to enable drag-and-droping on content of an HTML table. For instance with a table of 20x20, in order to move a tag from a cell to an other cell. Is that hard to do? I don't see any example after sear...

Is any complete example for merge or split table cells in javascript ?

Hey folks, I am working on a web project ,One of the features include user can desgin a html Table and allow user split or merge cells feel free,(i am using jquery for my project).any one can help me? Thanks! ...

Not able to move DIV around

Dear Sir, I have the following code:  Stock Update  Update Paper There is a TD inside which there is a DIV and inside DIV there is a Table. DIV's default style is display:none. On mouseover TD, the div should appear like a popup in a given position. But it is not happening. DIV is appearing in the same TD. ...

Treating nils in sort function

Hello, I don't know how to handle nils my sort function gets. When I have this checking in it, table.sort crashes after some calls. if a == nil then return false elseif b == nil then return true end With this error:invalid order function for sorting. But according to the documenatiton, sort function should return false, if a ...

Editable HTML tables

Lots of WYSIWYG editor implements HTML table functionalities, however I noticed that such functionalities were not spread evenly accross browsers.. And by editable table, I mean the ability to add/remove rows and columns and resize the table with controls like these: However if I edit a table in another WYSIWYG editor I get this: No...

Excel VBA - Insert a Row to a Specific Set of Columns

Hi all, I'm working on a spreadsheet to act as a master copy for some important information that will be kept track of for a project. On the main sheet I have a table for notes and a table for contacts set up seperated by several columns and some VB code to insert new notes or new contacts. However, when I insert a new note I want it to...

How do you know when you need separate tables?

How do you know when to create a new table for very similar object types? Example: To learn mysql I'm building a model solar system. For the purposes of my project, planets have many similar attributes to dwarf planets, centaurs, and comets. Dwarf planets are almost completely identical to planets. Centaurs and comets are only different...

Table decoration in Qooxdoo

Hi All, Is it possible to set the background color of one Row in a Table? I need to highlight a row when a condition applies. Something to the effect of < tr font="...">...< /tr> where I can specify the "font" attributes. (I need the whole row to be highlighted) Thanks in advance :) ...

sql server fields with most usage

is there an sql query that can give me the fields that are used in most stored procedures or updated, selected most in a given table. I am asking this cause i want to figure out which fields to put indexes on. thanks ...

Attendance table in sql server 2005

Hai guys, My web application stores attendance of employees daily.. How to design an attendance table in sql server 2005? I tried to figure it like this, Attendance table will contain columns EmpId,MonthId,1,2,3,4.....31.. Is this ok enough to hold attendance? Any siggestions.... ...

Is there a decent HTML-table-generator class in PHP?

I'm looking for a decent class in PHP which will generate complex HTML tables, i.e. it should support colspan/rowspan and individual CSS classes for rows, columns and cells. ...

Transfer SQL Server Objects Task (SMO) fails 'Truncate data failed for Table' in SSIS

Hi I am getting below error in ssis package. Package contains Transfer SQL Server Object Task which Replace Data in destination table. I have source dimension table from which I am replacing data in destination dimension table.There is no FK constraint present on source & destination dimension table which may not allow truncate table. ...

How do I add data to different tables but keep the same id?

What I am trying to do is to add data for a product into a database with MySQL 5.1 and PHP 5.2.12. I have a table for general fields: name, description, price, number of times purchased, and also I have a table for the images that are associated with that product. The goal is to have the same id for every image that corresponds to its...

Does column order matter in your MySQL tables?

While learning mysql, I read that you can perform the following statement when adding a column to a mysql table: ALTER TABLE contacts ADD email VARCHAR(60) AFTER name; or ALTER TABLE contacts ADD email VARCHAR(60) FIRST; When would you want to do this? Can column order be utilized for query optimization purposes? Should longblobs b...

jQuery load html - how to get last table returned

I am somewhat new to jQuery but have been having fun trying learn about all the cool tricks it can do. One of the current things I am trying to use is the load function to get a weather report from one the sites we use for daily reporting. The code I am using is $(document).ready(function() { $("#table").load("weather_url table"); }); ...

Set maximum displayed rows count for HTML table

Have JSP page with dynamically generated HTML table with unknown number of rows. Have property on backend, that sets maximum number of rows, e.g: max_rows=15. How to limit number of rows for HTML table to max_rows value? Other part of table should be accessible by vertical scroll,it means that user see 15 rows and if to scroll down, th...

foxpro cursor size

This seems like such an easy problem, but I can't seem to find a solution anywhere. My co-worker and I are working on an application that makes use of the Foxpro xml dump facilities. It works great, but we're wishing to split the table into multiple files based on some size constraints. This seems like it should be the easy part: How...

How to get an excerpt of a table in Excel in a different table?

I have got an Excel document that is used as patient database for a practice. In the first table there is a complete list of all patients with the date of their first appointment and (if applicable) the date of their final appointment. In the second table, I would like to have a list of all current patients (no final appointment). In th...

CSS Reset question

I have a reset.css file that includes the following declaration: border:0 none; So when I make a table like this: <table border="1"> The border does not show up. How do I get the border to show up without removing the border:0 none; property? The code must be <table border="1">. Is there a way to make the table "ignore" the reset....

Classes that mimic the behavior of iPhone Application Settings...but within an app?

Has anyone written iPhone classes that mimic the behavior of the Application Settings? It would be nice to be able to define settings tables for use within my app using exactly the same XML structure, etc. ...