table

Alternative to Windows Azure tables out of the cloud

Hi :) I'm developing a .NET app, which needs to run both on Azure and on regular Windows Servers(2003). It needs to store a few GB of data and SQL Azure is too expensive for me, so I'll use Azure tables in the cloud version. Can you recommend a storage solution, which will run on standalone servers and have an API and behavior similar t...

Adding a second table in a database

Hi everyone. This is my first post! I hope you can help me out! :-) I used the code provided by the NotePadExample from the developers doc to create a database. Now I want to add a second table to store different data. I can add notes without a problem, and the notes table is created in a similar way as my routes table is. I simply "co...

Delete ONE SPECIFIC table of a database - leave the rest intact

Hi, I have a database where I store two different kinds of data. One table is for favorite routes, the other stores the retrieved routes from a server. I can retrieve the routes etc just fine. But after retrieving the first Route, pressing back or HOME, and then retrieving another route, the routes table is filled with all the old route...

Understanding syntax in c#

I am hoping someone can help me understand what is going on in the code line below: Table t = (Table)Page.FindControl("Panel1").FindControl("tbl"); I understand Page.FindControl("Panel1").FindControl("tbl"); Why is there a (Table) before the Page.FindControl? ...

MSAccess database with Basic - accessing fields

Hello, First time I'm touching both access and basic, but I'm doing a favor for my sister. I have to retrieve data from a table and some headings have a % character in them and changing the headings is not and option. what does msaccess replace % with? Let Entitlement = rc![Entitlement% pozitia 1] rc is the recordset :P ...

Table column width as narrow as contained data?

I have three columns. The last two I want to make as narrow as the their contained data and the first column can take the rest of the width (table has 100% width). How can you do this using css? Right now the columns on the right look silly with extra space. Ideas? ...

MySQL syntax: can't create table

mysql> create table balance_sheet( -> Cash_and_cash_equivalents VARCHAR(20), -> Trading_financial_assets VARCHAR(20), -> Note_receivable VARCHAR(20), -> Account_receivable VARCHAR(20), -> Advance_money VARCHAR(20), -> Interest_receivable VARCHAR(20), -> Dividend_receivable VARCHAR(20), -> Other_note...

Jquery add table row after the row which calling the jquery.

Hello! I've got a table. <table id="servers" ...> ... {section name=i loop=$ownsites} <tr id="site_id_{$ownsites[i].id}"> ... <td>{$ownsites[i].phone}</td> <td class="icon"><a id="{$ownsites[i].id}" onClick="return makedeleterow(this.getAttribute('id'));" ...></a></td> </tr> {/section} <tbody> </table> And this java script. <...

SQL query to return data from two separate rows in a table joined to a master table

I have a TWO tables of data with following fields table1=(ITTAG,ITCODE,ITDESC,SUPcode) table2=(ACCODE,ACNAME,ROUTE,SALMAN) This is my customer master table that contains my customer data such as customer code, customer name and so on... Every Route has a supervisor (table1=supcode) and I need to know the supervisor name in my t...

MySql insert data in multiple table at a time

hi, i have a query regarding to insert data in multiple table.. i have a two tables. one is item table and second is field table. itemid from item table reference in the field table. i want to insert data in both table with one query at a time. any idea about it. ...

MySQL: Can the table comment length be increased?

I read the MySQL comment length questions on StackOverflow here: http://stackoverflow.com/questions/391323/table-comment-length-in-mysql http://stackoverflow.com/questions/2473934/how-to-increase-mysql-table-comments-length The first link suggests that it can be done and the second suggests it cannot. I don't know why there is this...

as.data.frame of table() to summarize frequencies

In R, I'm looking for a memory-efficient way to create a summary of tabular data as follows. Take for example the data.frame foo which I've used table() to summarize, followed by as.data.frame() to obtain the frequency counts. foo <- data.frame(x= c('a', 'a', 'a', 'b', 'b', 'b'), y=c('ab', 'ac', 'ad', 'ae', 'fx', 'fy')) bar <- as.data....

How to draw diagonal table borders in latex, like in excel ?

Is it possible to draw diagonal (parallelogram) cells in LaTeX: the cell content is diagonal, and the cell's originally vertical borders are also diagonal. Here is what I managed to do using the rotating package: \begin{tabular}{|r|c|c|} \hline \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ & \begin{rotate}{45}Trying to save some horizontal space\end{...

Maximum number of records in a MySQL database table

What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to handle this kind of situations? Thx! ...

How can I optimize the import of this dataset in mysql?

I've got the following table schema: CREATE TABLE `alexa` ( `id` int(10) unsigned NOT NULL, `rank` int(10) unsigned NOT NULL, `domain` varchar(63) NOT NULL, `domainStatus` varchar(6) DEFAULT NULL, PRIMARY KEY (`rank`), KEY `domain` (`domain`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 It takes several minute...

jquery build table

menuOrder is an empty div $("#menuOrder").append('<table>'); $(menus).each(function(i, menu) { $("#menuOrder").append('<tr><td>'); $("#menuOrder").append(menu.text); $("#menuOrder").append('</td><td>'); if (i > 0) { ...

CSS IDs and nesting tags with Haml

I have the following code in my CSS file, which isn't working. #home table th td { border:1px solid black; padding:2px; } In my index.haml file, I have: %div{:id => "home"} %table %tr %th Your Account %tr %td #{link_to 'View my profile', @profile} %br #{link_to 'Edit my profil...

Need some tips on create table.

Hi I plan to create a tale to store the race result like this, Place RaceNumber Gender 　　Name 　Result 12 0112 Male Mike　Ｌｅｅ 1:32:40 16 0117 Female Rose Ｍａｒｒｙ 2:20:40 Ｉ　ｃｏｎｆｕｓｅｄ　ａｔ　ｔｈｅ　ｉｔｅｍｓ　ｔｙｐｅ　ｄｅｆｉｎｉａｔｉｏｎ． Ｑ１．I am not sure the result can ...

Resize TD. (Noob question)

I am currently re-building a table display page, just wanted to know if it's possible to resize a TD without inline styles, like add a class with width and height? Example: <td class="Td_class">Blah</td> .Td_class { height:30px; width:80px; } Probably can, just wanted to make sure for when I make this table. Thanks. ...

Rotate Windows.Documents.Table

I need to rotate a table clockwise up to 90 degrees. It's one of the blocks of a FlowDocument. Is there a way to apply some kind of rotation to a Table? The possible solution of creating TextEffect like this: var table = new Table(); ... // fill the table here var effect = new TextEffect { ...