table

Using Jquery to find the content of a TD

Hello I am trying to use Jquery to find TD's with X or Y content (text) inside. For example: http://sotkra.com/btol/index.php From left to right, the 7th COLUMN that reads 'TIPO MONEDA' displays either PESOS or DOLARES. I'd like to be able to do the following: 1.- Select TD's with the text 'DOLARES' or 'PESOS' and add a class to them...

Get all table names in a Django app

How to get all table names in a Django app? I use the following code but it doesn't get the tables created by ManyToManyField from django.db.models import get_app, get_models app = get_app(app_name) for model in get_models(app): print model._meta.db_table ...

nhibernate: how to map two tables to a single non-persistent class?

I have two similar tables: Table1: [ id ] | [ name ] Table2: [ id ] | [ name ] and I need to read/write data using only one class: public class TwinTable { public virtual int Id { get; set; } public virtual string Name1 { get; set; } public virtual string Name2 { get; set; } } Plus one of the tables may or may not have...

How to create calculated field in Access Database using SQL during runtime in Delphi

I am creating a table during runtime. This is how I do it: AdoCommand1.Connection:=AdoConnection1; cs:='CREATE TABLE '+edname.text+' (' + 'ID Integer IDENTITY(1,1) NOT NULL UNIQUE PRIMARY KEY,' + '[Date Added] DATETIME,'+ '[Name] TEXT(255))'; ADOCommand1.CommandText:=cs; ADOCommand1.Execute; I need to add a field "age" which should be...

loop through tr's with Jquery and compare contents with next row in series

I'm somewhat new to jQuery/javascript, and would like to compare the contents of row[i] in a table body with row[i+1]. Is this something I can do with jQuery or should I just use plain old JS and getElementByid and then loop that way? using the .each doesn't appear to give anyway of accessing the next element in the series easily. I a...

Export MS Access tables through VBA to an excel spreadsheet in same directory

I have two tables in my access database that I want to be able to export to excel. I can do it by opening the table and then doing File->Export... and then choosing the format and typing in the file name. However, this way the user actually has to type the name in so there is room for misnaming the file or for saving it as the wrong for...

Alpha Beta Searching and Transposition Tables

I have alpha beta search working and want to implement transposition tables to make it faster. The problem I'm having is the relationship between the entries in the table and the current position being evaluated. The literature I've read so far says you need to store the position type, the score, and some other information. Why do you h...

Django: several tables for one model.

I have a model "Messages" which i use to store messages throughout the site. These are messages in discussions, private messages and probably chat. They are all stored in 1 table. I wonder if it will be faster if i spread messages among several models and tables. 1 for chat, one for discussions and so on. So should i keep all message...

Using a single wiki table for multiple subject tables

Hello, I wonder to know if someone can help to understand if I'm doing well using a single table with wiki content for multiple subjects, so: TABLE wiki ==> wiki_id wiki_content wiki_language wiki_user_id TABLE houses house_id house_name house_year house_location ==> wiki_id TABLE architec...

How to find list of all tables in Access Database matching certaing format in Delphi

I need to compute a list of table names in a given database (MDB format), which have certain format (for example which containt DateTime field "Date Applied"). How can I do it? Note: I am using Delphi 7, ADO components, Microsoft JET 4.0 to connect to MDB type Database. ...

SQL Server and Calculated Fields?

So I'm creating an app that with users who can earn "points" in many different ways. Some of these point accruals occur because of their profile, actions they've taken, etc. (i.e. spread across multiple tables). I don't want to manually add points in a field when certain actions occur because I want to ensure number consistency. I would...

PHP mysql echo data

<?php // query db $sql = "SELECT category.id as category_pk, category_id, products.* from category, products WHERE products.id = category.category_id AND category.id = category_id"; // from category get id if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $row = mysql_fetch_assoc($result); ...

Adding text to a table data cell with jQuery

Why this code: row.append($("<td></td>").text("someText")); ...isn't working, and how can I fix it? Thanks. ...

How to read text containing bullets from a table row inside a word doc using POI

HI, I am trying to read a word doc that contains a table using POI. The requirement is to create rows in a Database Table with the information extracted from the table rows in the word document. For example, my word doc has a table like: Heading Description Heading1 summary related to heading1 Heading2 summary related to heading2 ........

How to know index of a <tr> inside a <table> with jQuery?

I'm now implementing something like this post, the effect takes place when the row is clicked, the problem is now:how do I know what the index of the row is inside the table? ...

Change specific column values in R

I have a table where there are "NA"s littered all over the place in one column in particular. I want to replace every instance of "NA" with something else -- say, the number 1. How should I do that? ...

select most popular tags from database?

i have 2 tables linked together through the 3rd table threads: id, name tags: id, name thread_tag_map: threads_id, tags_id its a many to many relationship. i want to select 30 tags that are most popular that is to say the first 30 tags with tags_id which occur the most in thread_tag_map. i think you understand my question (and sorry ...

Best way for smart-paginated-ajax tables in Rails

I'd like to be able to DRY-ly and intelligently set up my Rails controllers so that I can effortlessly use paginated tables of data on various pages. Let me clarify. I already use will_paginate + a custom plugin that I wrote which acts as a table-view creator. This combination works perfectly for "index" actions which simply show one ...

JQuery Help Needed for ID order given N Rows

Hi. I am trying to add a function that, when a user clicks "remove", 1) updates the numbers in the left-most column 2) updates the id order 3) updates the alternating color scheme I need help with 1) I am able to update the number row but it currently updates for all rows, even if there isn't anything there. Can somebody show me ho...

Table footer view buttons - iPhone

Hi Guys, I have some signup form that had email and login text fields as table cells and signup button as button in footer view. That all functioned superb, here is the code frame = CGRectMake(boundsX+85, 100, 150, 60); UIButton *signInButton = [[UIButton alloc] initWithFrame:frame]; [signInButton setImage:[UIImage imageNamed:@"butt...