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...
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...
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...
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_...
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...
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
...
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...
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
...
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...
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...
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...
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> </td>
<td> </td>
<td cl...
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) ...
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 ...
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...
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...
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...
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...
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...
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.
...