table

When you alter a table how do you detect the data type of columns?

I am running MySQL and I need to change the data type of certain columns from an enumeration to integer. However, there are a lot of columns. (If this exists) What is the syntax to alter all columns at the same time that are enumerations. Here is how I am updating a single column to make it integer data type: ALTER TABLE table_name CHAN...

Reordering tables nested rows

Hi, I am improving a CMS I have built and wish for the user to be able to reorder pages using drag and drop. I have table drag and drop for jquery: http://www.isocra.com/2008/02/table-drag-and-drop-jquery-plugin/ however I wish to be able to 'group' rows together and move them within only the group. In the CMS I have a list of top lev...

Displaying 'select' elements in a form table

I have a table inside a form. I'm trying to display a 'select' form element in one of the table columns, but it doesn't display; it keeps getting rendered outside of the table. However, if I change the form element to 'checkboxes' or 'radios', it displays without problem. I'm rendering like this: $output .= theme('table', $header, $rows...

Insert and select from a table/array in oracle

Hi everyone, I have a pretty big sql statement which returns a list of id's. I need this id-list as base for other statements. Like this: open crs_result1 for ' select * from ... where id in ( select <ids> from <base_statement> ) '; open crs_result2 for ' select * from ... where id in ( select <ids> from <base_statement> ) '; open crs_...

Regex for html parsing in php

Possible Duplicate: RegEx match open tags except XHTML self-contained tags Hello, i m stuck in weird regex problem, i m parsing some html table in php regex i m using : <td[^>]*>(h.*?)</td> <td>other data</td> <td>other data</td><td>Data_needed</td> <td>--</td> but its matching all other data too now i want to match it t...

jQuery Table Zebra Striping with hidden rows

I have been using the following with no problems: $("#tableid tr:even").addClass("evenClass"); But now I have rows in my table that are hidden which messes up the zebra striping styles. I have tried add 'is(":visible")' and things like that to no avail. Any ideas? Thanks ...

Is it possible to have a border around a table row in some way?

I'm trying to add borders around specific table rows which change it's colors when the mouse enters the row. However, I dont see a border at all unless using border-collapse:collapse; but I have to avoid border-collapse, since in some cases the border is visible left, right and at bottom but not on top (probably because I cannot have pad...

How to name sql table and its category in sql server?

I have table called Services and I want to make another table that have the Categories of services ( One-to-Many ) What's the best approach i can use to naming it is it one of the following ? ServiceCategoreis ServicesCategoreis Serviecs_Categories CategoriesOfServices ...

MySQL: select on a table with tablename from a recordset

I would like to do this in one step so I would like to know how can I: table a (documents) has: pk, document_id, template_id table b (templates) has: pk, template_id, template_table_name table c (template_table_name_1) has: pk, document_id, document_specific_columns so... I would like to query table a, get document_id and template_id...

generating reports using custom data (html table) not dataset

i read several articles on this site and many others recommending report generating tools of various kinds but all use dataset as there datasource this is not my requirement! i need some way to export the data which is displayed in the htmltable on mypage.aspx user clicks view record a pdf opens (it should contain the data of the htm...

centering cell entries in ctable (latex)

Dear all, Is there an easy way to center the cell entries in this table. The confidence interval look allright, but the estimate itself seems left-justified in the cell. //M \documentclass[14pt]{article} \usepackage{ctable} \usepackage{longtable} \begin{document} \ctable[ caption={compldich}, label=z, p...

Advanced css/html table styling

I'm trying to achieve table similar to this using css/html only. Is it possible ? http://img687.imageshack.us/img687/6139/11717002.png So the white area is the 'places' table. This is the HTML for the table : <table class="places"> <tr> <td class="solid">K</td> <td>&nbsp;</td> <td>&nbsp;</td> <td cl...

Urgent! Need help selecting IDs from a table if 2 conditions in other tables match

Sorry for the worst question title ever but I find it hard to explain in a sentence what im having trouble with. I am developing a user feedback system using ASP.NET and C#. I have multiple tables and am trying to populate dropdown lists so that the feedback can be filtered. My tables: CREATE TABLE tblModules ( Module_ID nvarchar(10) ...

How do I create an empty table with SQL?

This isn't much of an issue with MySQL per-se. The Full Story I'm writing a very small PHP framework. It isn't like existing frameworks where they force you to use a certain methodology. It isn't either like a CMS framework. Trust me, I've seen Zend framework and I've used CMSes like Joomla and WordPress extensively, none of them come ...

Pros / Cons of MySql JOINS

This is a question that has bugged more for a few weeks now and I haven't got around to asking it to you guys. When I'm selecting data from multiple tables I used to use JOINS a lot and recently I started to use another way but I'm unsure of the impact in the long run. Examples: SELECT * FROM table_1 LEFT JOIN table_2 ON (table_1.colu...

On a stats-system, should I save little bits of information about single visit on many tables or just one table?

Hello I've been wondering this for a while already. The title stands for my question. What do you prefer? I made a pic to make my question clearer. Why am I even thinking of this? Isn't one table the most obvious option? Well, kind of. It's the simpliest way, but let's think more practical. When there is a ton of data in one table a...

Html table width

I have code like this: <table width="625px"> <tr style="background-color:#CCC; font-size:14px;"> <td style="padding:8px; color:#333"><center><?=stripslashes($arr['signature']);?> </center></td> </tr> If $arr['signature'] is a long string, like this gjuytfdcrtrfdscvythgfvtfdgtrfdvbgfvcfgbdc the width doesn't help and it g...

How do I do 2 unique LEFT JOINs on the same table cell?

Hi, In mysql I'd like to do 2 unique LEFT JOINs on the same table cell. I have two tables. One table lists individual clients and has a clientNoteID and staffNoteID entry for each client. clientNoteID and staffNoteID are both integer references of a unique noteID for the note store in the notesTable. clientsTable: clientID | client...

In rails, how to destroy an 'join table item' with out delete the real record?

Hi guys: I get confuse now, I don't know how to delete/destroy a record in a join table: class Task < ActiveRecord::Base belongs_to :schema belongs_to :to_do end class Todo < ActiveRecord::Base belongs_to :schema has_many :tasks end class Shcema < AcitveRecord::Base has_many :todos has_many :tasks, :through => :todos e...

What are the best practices to display tables on mobile? (Web development)

I have to redesign a website that relies heavily on tables and I can't find a good way to display them, I'm mostly interested in displaying the tables correctly on Blackberry, iPhone and Android. ...