table

Table Design For SystemSettings, Best Model

Someone suggested moving a table full of settings, where each column is a setting name(or type) and the rows are the customers & their respective settings for each setting. ID | IsAdmin | ImagePath ------------------------------ 12 | 1          | \path\to\images 34 | 0          | \path\to\images The downside to this is every time we wa...

HTML colspan in CSS

Hi, I'm trying to construct a two row table similar to following: --- - where the bottom is filling the space of the upper row. Is this possible using CSS? In HTML I can do things like colspan. ...

Prototype: Form.serialize missing some inputs (due to table?)

I'm using JavaScript Prototype (through Ruby on Rails) to handle some Ajax calls; but in one particular case I'm missing a field from the form. I have a layout like this: +---------+---------+ | Thing 1 | Thing 2 | +---------+---------+-----------+ | o Opt 1 | o Opt 1 | <Confirm> | | o Opt 2 | o Opt 2 | | +---------+---------...

jQuery table drag and drop plugin within iFrame

I am using the latest version (0.5) of Table Drag and Drop plugin (http://www.isocra.com/2008/02/table-drag-and-drop-jquery-plugin/) for jQuery. I have a problem when the table with the draggable rows is inside an iframe. When I drag a row and take it to the top, the page will not scroll (even after explicitly setting scrollAmount to a p...

Creating landscape page-spanning tables in LaTeX

I have a large table I want to include in a LaTeX document. It is too wide for a page, so I want to rotate it 90 degrees and have it landscape. Then it will be too tall for the page, so I want it to span multiple pages. I have managed to get it landscape with: \begin{landscape} \begin{table}[htdp] \begin{center} \begin{tabular}{c|l|c|l...

MySQL: Select Random Entry, but Weight Towards Certain Entries

I'm sick of waiting for my developers to fix this, so I decided to ask you guys. I'm trying to modify what they've already given me, so sorry if the setup doesn't make a whole lot of sense. I could probably change it but want to keep as much of the existing table setup as possible. I've got a MySQL table with a bunch of entries in it, a...

Representing relations in C++

I am trying to represent a relation (table) in C++ code: The columns of the relation are integers. The number of columns in the relation is fixed at runtime. No duplicates should be allowed (this is the major source of cost). I want to have a map from names to relations. Any ideas for an efficient implementation, the main issue here ...

Change entire db's collation and solve illegal mix of collations

Hi I'm having a problem when doing LIKE '' queries in mySQL These are my variables character_set_client utf8 character_set_connection utf8 character_set_database latin1 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8 character_sets_dir C:\xampp\mysql\share\charsets\ 1...

Need to iterate through SQL table rows, one at a time (table too big to use adapter.Fill)

It's easy enough for me to read through a small SQL Server 2005 table like this: string cmdText = "select * from myTable"; SqlDataAdapter adapter = new SqlDataAdapter(cmdText, connection); DataTable table = new DataTable(); adapter.Fill(table); Unfortunately, this method appears to load the entire table into memory, which simply isn't...

SQL query to retrieve from three inter related tables

I have three tables specifying important columns below Users(Id, username) Groups(Id, groupname, creator) (creator is the creator of the group) Association(Id, UserId, GroupId) (entries in this table include which user is in which group) Association.UserID =Users.Id, Association.GroupId = Groups.id and also Groups.creator = Users.Id....

Update Table, Where Column Name is selected dynamically - DropDown.SelectedValue, C#, VB.NET

Hi, I want to Update Column of a Table where ColumnName will be DropDown.SelectedValue. Example: A set of RECORDS will be displayed from a Customer Table where CUstNo ='1234' and City= 'Chicago' and Grade ='B' Once displayed I want to Update the grade to 'A' of all those customers from the above criteria. In My case I have like 100...

Unable to change UITableViewController color background

TitlesViewController : UITableViewController I have the above code on iPhone development. This is associated to a xib (or nib) file. In this property file I change its background color. The problem is it does not reflect my new background color. Should I be manually loading the xib file to reflect it to my TitlesViewController? ...

Get latest update from two tables

I have read so many posts and tried so many alternatives but I just can't work out the best way to achieve the following : I have four tables, issues, issuestatus, customers and customerupdates Issues IssueID StatusID CustomerID IssueDetails IssueStatus StatusID Status Customers CustomerID CustomerName CustomerUpdates Update...

SQL Server 2008, join or no join?

Just a small question regarding joins. I have a table with around 30 fields and i was thinking about making a second table to store 10 of those fields. Then i would just join them in with the main data. The 10 fields that i was planning to store in a second table does not get queried directly, it's just some settings for the data in the ...

Python: PSP & HTML tables

I have a python psp page code is shown below. Currently it only prints out the characters in single rows of 60, with the character count in the left column. <table> <% s = ''.join(aa[i] for i in table if i in aa) for i in range(0, len(s), 60): req.write('<tr><td><TT>%04d</td><td><TT>%s</TT></td></tr>' % (i+1, s[i:i+60])); #end %> </...

Focus traversal between two tables in a Panel.

I have two (5 * 1) tables to be shown as a single table on UI. How can I get a focus traversal mechanism for the two components(table) which mimicks the behavior of single ( 5 * 2 ) table. ...

Python server pages, tables and lists

Hi, I am using MySQL and python server pages to show the data in a database. In the db I have selected this data: a list x =[1, 61, 121, 181, 241, 301] and a list of lists z = (['a','b'],['c','d'],['e','f'],['g','h'],['i','j'],['k','l']) and I would like to put these in a table to look like: 001 a b 061 c d 121 e f 181 g h 241 ...

Programmatically creating linked tables in access

Hi all, We need to find a way to programatically *link all the tables* in a SQL Server database to an access db. We will be invoking this access database from a program that uses .net/SQL Server 2008. While invoking the application we would like to add the linked tables so that the users can just run the reports/modules from access with...

Subquery using derived table in Hibernate HQL

I have a Hibernate HQL question. I'd like to write a subquery as a derived table (for performance reasons). Is it possible to do that in HQL? Example: FROM Customer WHERE country.id in (SELECT id FROM (SELECT id FROM Country where type='GREEN') derivedTable) (btw, this is just a sample query so don't give advices on rewriting it, is j...

MySQL multidimensional arrays...

What is the best way to store data that is dynamic in nature using MySQL? Let's say I have a table in which one item is "dynamic". For some entries I need to store one value, but for others it could be one hundred values. For example let's say I have the following simple table: CREATE TABLE manager ( name char(50), worker_1_name(50)...