table

MySQL: Select multiple tables

I want to select multiple tables with MySQL. But I don't know exactly the name of them, but they have all the same structure. For example: table_345: id || row_1 || row_2 || row_3 I want to have something like that: SELECT `id` FROM table_* ...

many-to-many relationship INSERT question

i am trying to create a many to many relationship between 2 tables. ive got 3 tables for that. it follows TOXY model. table a: a.id (primary key) table ab: ab.a_id (foreign key) ab.b_id (foreign key) table b: b.id (primary key) how should i insert the data so it will be all linked up? like this? "INSERT INTO a ('name') VALUES ('my nam...

Ö (O with double dots) in Mysql record?

Hi, I have a row in a MySQL table with "ö". The whole word is "företag". How do I select that word in a sql query? I've tried with fretag but it didn't work. The table is using utf8. ...

wild expressions in mysql IN statement

i want to use a WILDCARD for everything in the statement beneath: "SELECT threads.* FROM thread_tag_map, threads, tags WHERE thread_tag_map.thread_id = threads.id AND thread_tag_map.tag_id = tags.id AND (tags.name IN ('WILDCARD'))"; What should I replace the WILDCARD with to be able to select every entry? I have tried...

merge similar data together

i am trying to merge similar data together but choosen data. for example the table has 5 rows and i want 3 rows which have similar data to merge. other 2 rows, even though it contains similar data, i dont want it to merge. is there a way to do this? here is my current code: protected void DataBoundModuleGV(object sender, Even...

Query Caching in MySQL

Ok, I am building a fairly large statistics system, which needs to allow users to requests statistics for a given set of filters (e.g. a date range). e.g. This is a simple query that returns 10 results, including the player_id and amount of kills each player has made: SELECT player_id, SUM(kills) as kills FROM `player_cache` GROUP BY p...

How do you specify table padding in CSS? ( table, not cell padding )

Hi, I have a table with a colored background and I need to specify the padding between the table and it's content, I.E. cells. The table tag doesn't seem to accept a padding value. Firebug shows the table and tbody's layout with padding 0 but doesn't accept any value entered for them, so I guess they just don't have the padding property....

jquery: simple table plugin with add/remove

I am looking for a jQuery plugin that manages tables. I need the capability to programmatically add/remove rows easily. Lastly, I need a "row level" "onclick" event. A nice associated stylesheet would be appreciated :-) NOTE: I know about plugins.jquery.com but I am pretty "newbie" when it comes to jQuery... I need your help guys, plea...

retrieving data needed for ajax call for multiple lines

Hi, I have a table with many rows. When u click on these rows they open up more detail about the row you click in. This could be based on an int or string. I have wired jQuery up to anchor tags on each row which the user will click on. However previously when using javascript inline you would pass something like this: <a href="javascr...

How to fix the table height?

Hi guys, I want to fix the table height to 600px, eve if the content goes long. Thanks for your help... ...

How to create a absolute element overlapping several rows in a calendar (table) design?

Hi Im trying to create a calendar in an HTML table design with css element div elements as appointment blocks in absolute positioning which is working fine. But since the block is absolute, which makes me able to overlap as many rows as I want to create appointments, it dosnt stretch horizontally which is what I want. How can I make the...

How to remove a lua table entry by its key ?

I have a lua table that I use as a hashmap, ie with string keys : local map = { foo = 1, bar = 2 } I would like to "pop" an element of this table identified by its key. There is a table.remove() method, but it only takes the index of the element to remove (ie a number) and not a generic key. I would like to be able to do table.remove(...

How to switch from table to div for FORM layout?

I'm noticing most folks are talking about using DIVs and CSS for label, textbox pairs. How would one convert a table such as: <table> <tr> <td><some Label1> </td> <td><some TextBox1> </td> </tr> <tr> <td><some Label2> </td> <td><some TextBox2> </td> </tr> ... </table> From using a table into say a div with CSS, a sample would be help...

Javascript update to HTML table cell (from thousands to millions)

I need to create some javascript on my web report which converts table values to thousands or millions (eg divides or multiplies by 1000). The trouble is that each value is 'clickable' (ie it is wrapped in an anchor tag). Is this possible? <table class="Table" > <thead><tr> <th class="l Header" scope="col">£000s</th> <th class="l ...

PostgreSQL create table if not exists

In a MySQL script you can write: CREATE TABLE IF NOT EXISTS foo ...; ... other stuff ... and then you can run the script many times without re-creating the table. How do you do this in PostgreSQL? ...

How do I select a group of child elements from a parent element of a particular class?

If I have a table as in this example: <table class="detailView"> <tr> <td>Value1</td> <td>value2</td> </tr> </table> How do I style the <tr> and <td> elements only if the table is of class="detailView"? ...

Why isn't the table centered in Explorer?

This is a HTML email. I have 2 tables inside each other. 1 set to 100% and another inside 700px wide. This is the HTML: <table width="100%" border="0" align="center" cellspacing="0"> <tr> <td width="700"> <table width="700" border="0" align="center" cellspacing="0"> <tr> <td colspan="2" align="center"><img ...

html table problem with doctype

I am trying to allign a table with an input so that the table creates a google-like drop-down. I am using jquery to retrieve the position and dimensions of the input element and then css to position the table. Things work pretty smooth when I don't use DOCTYPE. Now, when ANY DOCTYPE is included on the page things go wrong (weirdly not i...

Can I change the number of titles in Table??

Table has 4 title but I want to use just 2 of them how can i do that ?? ...

DataSet StoreProcedure Table names

Hi, I am calling a stored procedure to return two tables. I am getting it as a dataset in my console application. The table names in the dataset are something like TABLE,TABLE1. Is there anyway to change this to a meaningful names from stored procedure?? Thanks, Mahesh ...