FAQ Database Discussion Community


for-loop add columns using SQL in MS Access

sql,ms-access,table,for-loop,iteration
I am trying to add n columns to a table, like in this example of code where n = 10: Sub toto() Dim db As Database, i As Integer Set db = CurrentDb() For i = 1 To i = 10 db.Execute " ALTER TABLE time_series " _ & "ADD...

Table goes max height when screen is resized

javascript,html,css,ajax,table
I have a table that is generated with a min-height of 300px and a max-heigh of 650px which is perfect. The only problem is when i resize the window the table will stretch all the way down until all its values are shown. Its supposed to have a scroll bar...

MySQL split a column out with ID

mysql,table,split
I'm looking to split one of my MySQL columns out as it is made of words separated via , (commas). I need to split the data on the (,) and also collect the corresponding ID so I can place it into anther table. What the easiest way to go about...

How to parse table of numbers in C++

c++,parsing,table,numbers
I need to parse a table of numbers formatted as ascii text. There are 36 space delimited signed integers per line of text and about 3000 lines in the file. The input file is generated by me in Matlab so I could modify the format. On the other hand, I...

How can I capture the value of a variable in a for loop using an event handler?

php,jquery,table,for-loop
I'm new to the site and gotta admit, a bit noob coding but I'm having an issue I really don't know how to tackle. I'm generating this table using a for loop, and after it's generated, I want to be able to click each generated row individually so it can...

I need help displaying an Xml file with php in table form

php,xml,table,attributes
So all-knowing community, once more I seek your help. I have been working on something for the past few days and it is starting to drive me insane. I need to grab the contents of an xml file and display it in a table. Since it has various levels I...

Execute multiple queries at once in Mysql using PHP

php,mysql,database,table
I want to insert information of a big registration form into a Mysql database. I use multiple tables and use multiple mysql_query commands. The problem is : If an error occur in one of queries, the process stops but previous queries have changes the tables! I want to alter all...

filtering firstname and lastname using datatable.js

javascript,jquery,table,datatable,filtering
I have created a application with dataTable for filtering firstname and lastname, I am having a firstname and lastname text-field through which I would filter firstname and lastname. The filtering is working but the issue is that firstname and lastname filtering is doing from both the textfield, Actually I need...

Php Mysql: Retrieving 2 usernames via 2 user id

php,mysql,table,join
Hi all i have one problem that i cant solve. I am doing pair generator for tournament. I have two tables. The first table contains the usernames and userids. The second table contains match_id, round, user1_id, user2_id Table 1 user_id username 21 John 22 Peter 23 Ana 24 Dan Table...

Deleting specific article from database with PHP

php,html,mysql,database,table
I'm creating a blog site and I got stuck in this phase where I want to allow authors to delete their own posts, they can already see the delete button below each of their posts. In the DB table I have an author, content and ID of the article. Now...

Implementing find node on torrent kademlia routing table

table,routing,bittorrent,dht,kademlia
I, already, reviewed a number of documents on this topic but there is something not exactly clear. For example bit torrent document (http://www.bittorrent.org/beps/bep_0005.html) states The routing table is subdivided into "buckets" that each cover a portion of the space. An empty table has one bucket with an ID space range...

filtering not working from select

jquery,table,datatable,filtering,html-select
I have created a application with dataTable with fixed headers and sorting, the application is working fine but the issue is that I am having a name filtering through a drop-down, which is not working when I select a particular name. My code is given below. Can anyone please tell...

Is it wise or acceptable to create a table with a different number of columns (td) for each row (tr)

html,table,html-table,tr
I was wondering if it is wise or acceptable to create a table with a different number of columns (td) for each row (tr) using html. For example: <table> <tr> <td>title</td> </tr> <tr> <td>text</td> <td>and more text</td> </tr> </table> Do I have to include the colspan? ...

How to get value of checkbox in table?

javascript,jquery,table,checkbox
How i can get value of checkbox in table , I want use for in this case in order get parameter.Now , please see html table <table id="div_func" class="table table-bordered" style="width: 100%"> <thead> <tr> <th> <input type="checkbox" id="chk_all" /></th> <th>Name</th> </tr> </thead> <tbody> <tr> <td> <input type="checkbox" class="checkbox1" id="chk" name="check[]"...

Formatting long-form survey data in R

r,table,formatting,reshape,long-form
We asked 3 people two or three yes-no questions. Let me denote these 3 people by 101,102,103 the questions by "A", "B","C" and the responses by 0, 1. The result is q<-data.frame(response=c(0,0,1,0,0,1,1), qstn=c("A","B","A","B","A","B","C"), person=c(101,101,102,102,103,103,103)) We need to convert this table to the following format person|qustionA|questionB|questionC 101 | 0 | 0...

error creating table in sql [closed]

mysql,sql,table,phpmyadmin
i keep getting errors when running this query in phpmyadmin bto create a customers table for my database this is the query i am trying to use... CREATE TABLE customers ( cust_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Name character(30), phone character(15), ); any help would greatly appreciated :) thank...

How do I print a list of strings into a table in python? [on hold]

python,string,list,table,printing
This is the list tableData = [['apples', 'oranges', 'cherries', 'banana'], ['Alice', 'Bob', 'Carol', 'David'], ['dogs', 'cats', 'moose', 'goose']] This is how I want it to look like apples Alice dogs oranges Bob cats cherries Carol moose banana David goose ...

How to show mysql multi row / mysql_fetch_array results in a table?

php,mysql,arrays,table,while-loop
I am trying to show mysql_fetch_array() results in a table. I want to show guests name,their country and their agreed time who are traveling on a same date. Following code works fine. The code fetches the row values and prints it. $select_guests = mysql_query('SELECT name FROM van_sharing WHERE date =...

Show and hide column in a table using drop down

javascript,jquery,html,table,drop-down-menu
I have a table, which looks exactly like this one: https://www.datatables.net/examples/api/show_hide.html I now want to replace the headers (the th things) with a drop down. I want to hide and show columns thanks to those drop downs (they can click and show what they want). I was also wandering if...

How to insert data into sql server database when the primary key column already set default identity(1, 1)

c#,table,insert
I'm trying to insert two data columns into my SQL Server database but I get an error at the code line -> cmd.ExecuteNonQuery(); Cannot insert the value NULL into column OrderID, table RestaurantApp.dbo.Junc_Order; column does not allow nulls. INSERT fails. The OrderID column is actually the primary key in my...

Event on dynamically created checkbox asp.net

c#,jquery,asp.net,table,checkbox
I started to programming with asp.net, I have a table with some checkboxses. The problem is, I can't create static tables, because this action is linked with some parameters. Anyway.. When I click on the First checkbox I want to invert the other checkboxes in this table. How can i...

Pass array on to sql and insert it in link table with one value

sql,sql-server,table,select,insert
I've found ways to pass an array to a stored procedure and ways to insert a table into another table. But I want to insert my array in a table as column2 with one other value I have as the value for column1: INSERT INTO Table1 (column1, column2) VALUES (SELECT...

fill an html table by column instead of row?

html,css,table
'<table> <tr> <th>' .$varProduct[$x][0]. '</th>'. //this is a title '<th>' .$varProduct[$x][2] . $varProduct[$x][11] . ' </th> // this is a price </tr> </table>' this code makes a table that fills out like this Title Price Title Price Title Price but I want to fill it Title Title Title Price Price...

Pivot SQL table (Rows into Columns)

sql,sql-server,table,pivot,pivot-table
I am currently returning data into a table in my SQL stored procedure. I am trying to pivot the rows into columns, and the columns into rows, but I am struggling to do so as a lot of the tutorials I am following to do this have laid out they're...

How to identify the class of an Object which is in a cell of webtable

object,table,web,qtp
I have a webtable which MIGHT have a weblink object in it's Row 2, Column 1 cell (also Index of this object is 0). If it indeed is a link I would like to click it else ignore it. Is there a way to identify the class of this object...

How to Click All Inputs with the Same Class on Page Load

javascript,jquery,table,input,click
I have a table with multiple rows (hundreds) on my web page. Each table row has an input with the class name of act_inv. I am trying to get JavaScript/JQuery to click each input with the class name of act_inv. Is this possible? And if so, how may I do...

PL/SQL: Join between two tables error [on hold]

sql,table,join,plsql
I have got a task in which I have to display information from two different tables using a cursor. I tried doing it with an example we did before, but it doesn't seem to work! Below mentioned are the two tables that I have to take records from and display...

jquery draggable/droppable div in multiple divs

jquery,table,draggable,droppable
I want to create a table where each cell can contain an element (div) that can be dragged and dropped in other cells. It seems that the element can be dropped only the origin div. I don't understand why it doesn't work. <style> .over { border: solid 4px #ACFA58; }...

How to print a database table in html (simple) [closed]

php,mysql,database,table
This may be a simple question however I would appreciate the help as I am new to php and mysql. How do I print one of the tables from my phpmyAdmin database into my site, what is the code to do so ?. The database table is constantly updating with...

HTML Table with 2 (two) rows set beside a 4 (four) row set

html,table
How would I achieve this table layout?

Refreshing SQL view after adding a default constraint to one of its tables

sql,table,view,refresh
How exactly can I refresh the view after adding a default constraint to one of the tables that makes up the view? I tried to use the sp_refreshview stored procedure but that didn't actually update the view. Here is the code I wrote to update one of columns with a...

Table Widths Strangely Shrinking on Mobile

html,css,table,media-queries
I'm having an odd error with a website I'm designing where the mobile version/size has tables getting progressively smaller. I've checked and it's not an issue of tags being unclosed or malformed html; the code validates in html5. I don't get this error in the desktop or tablet versions, but...

Update table if two columns exist in table and insert if one of the two columns are different

mysql,table,insert
I have a table computer, which has the following columns: computer(computer_id(pk), office_id, computer_name, login, date, time) I am trying to create a mysql statement that will update a row if the office_id and the computer_name already exist and will insert a new row if it does not exist. I want...

Why doesn't table resize work here? jsfiddle url inserted

jquery,html,table,jquery-ui-resizable
How can I make my table resizable like a textarea element and not individual rows/columns? I seem to be fundamentally missing something simple. https://jsfiddle.net/o0Ldf0us/ <table id="example"> <thead> <tr> <th>Heading1</th> <th>Heading2</th> <th>Heading3</th> </tr> </thead> <tbody> <tr> <td>Data1.1</td> <td>Data1.2</td> <td>Data1.3</td> </tr> <tr> <td>Data2.1</td> <td>Data2.2</td>...

Extracting Numbers From a Table on a Website

python,table,website,beautifulsoup
I am new to this website and programming in general, so bare with me please as my formatting for the question may be incorrect. I am trying to extract data from a website for personal use. I only want the precipitation at the top of the hour. I am nearly...

Html Table Error

php,html,table
This codes shows Title for every line. What is my mistake? foreach($db->query('SELECT * FROM uyeler') as $row) { echo "<table> <tr> <th>ID</th> <th>Username</th> <th>Sex</th> <th>Country</th> <th>Age</th> <th>Twitter</th> <th>Instagram</th> <th>Snapchat</th> </tr>"; echo "<tr><td>" .$row['id'] . "</td>"; echo "<td>" .$row['username'] . "</td>"; echo "<td>" .$row['sex'] . "</td>";...

Break table in two lines

css,table
How to break the table td in two lines using media-querie? jsfiddle @media only screen and (max-width : 768px) { .table > tbody > tr > td { width: 100%; max-width: 100%; } } ...

transpose table with jquery or php

jquery,table,transpose
I have a table with this structure, in a PHP page, showed with an echo: <table id="transpose"> <thead> <tr> <th>Event</th> <th>Monday</th> <th>Tuesday</th> <th>Wednesday</th> <th>Thursday</th> <th>Friday</th> <th>Saturday</th> <th>Sunday</th> </tr> </thead> <tbody> <tr> <td>One</td> <td>text11</td> <td>text12</td> <td>text13</td>...

R text manipulation

r,table,data.frame
I have a dataframe as below. I want to take ww1 column and create a new column newww1 as follows: my excel formula is =2012&TEXT((LEFT(201438,4)-2012)*53+RIGHT(201438,2),"0000") where instead of 201438 I will have a value from column ww1 the explanation of my formula is: take left 4 characters of ww1 subtract...

SQLAlchemy: querying on all subclasses of a class

python,database,table,sqlalchemy
I have the following code in which two classes inherit from a common parent class (which is not a table). I want to query on parent name so that it will also query in all the subclasses and give a result. class Parent(Base): __abstract__ = True id = Column(Integer, primary_key=True)...

Send selected row data in table to next page (Vaadin)

java,table,vaadin
How can I send selected row data in table to next page and write each column in TextField there?

Mysql optimize to avoid table scan

mysql,sql,table,optimization,scan
Please consider the following table: _____________________ | sentence_word | |---------|---------| | sent_id | word_id | |---------|---------| | 1 | 1 | | 1 | 2 | | ... | ... | | 2 | 4 | | 2 | 1 | | ... | ... | With this table structure...

For each `pop` get frequencies of the elements of `id`

r,table,data.table
Consider this data: m = data.frame(pop=c(1,1,1,1,2,2,2,2,2,3,3,3,3,3,4,4), id=c(0,1,1,1,1,1,0,2,1,1,1,2,1,2,2,2)) > m pop id 1 1 0 2 1 1 3 1 1 4 1 1 5 2 1 6 2 1 7 2 0 8 2 2 9 2 1 10 3 1 11 3 1 12 3 2 13 3 1...

c - Parallelising a function

c,multithreading,table,rainbowtable
I'm trying to implement parallelism to this function I want it to take as many threads as possible, and write the results to a file. The results need to be written in the file in the incrementing order so the first result needs to be written first the second second...

Prevent tables from relocating

html,table
I have 5 tables in a row in HTML document. I would like them to stay in a row when I change zoom. Currently, if I zoom they start to move and ultimately can transform from one row to one column. I do not mind to have very big horizontal...

Appending rows into table from dictionary

jquery,table,dictionary
I have a dictionary with (key,value) inside my jquery success function, $.each(myDictioary, function (key, value) { alert(key + ' is ' + value); } I want all the Dictionary values in a var So I can append it my table..I have tried this so far, which didn't help.. var row...

R table manipulation

r,table,data.frame,row
I have a data.frame as below PRODUCT=c(rep("A",4),rep("B",2)) ww1=c(201438,201440,201444,201446,201411,201412) ww2=ww1-6 DIFF=rep(6,6) DEMAND=rep(100,6) df=data.frame(PRODUCT,ww1,ww2,DIFF,DEMAND) df<- df[with(df,order(PRODUCT, ww1)),] df PRODUCT ww1 ww2 DIFF DEMAND 1 A 201438 201432 6 100 2 A 201440 201434 6 100 3 A 201444 201438 6 100 4 A 201446 201440 6 100 5 B 201411 201405 6...

Row names in tableGrob are cut off when using row.just = "left

r,table,rowname,grob
Can anyone solve why the cutoff of row names occurs for me? It is independent of the length of the string wrap. Specifying row.just = "center" does not cut off the row names. x <- data.frame(row.names=paste("Very very name goes in here somewhere yep it is a looooonnngggg name! phew that...

How can I render this irregular table with ng-repeat?

html,angularjs,table,angularjs-ng-repeat,ng-repeat
Here I have a json data as below: [ {"teacher":"Tom","student":[{"name":"stuA","project":"projectA"},{"name":"stuB","project":"projectB"}]}, {"teacher":"Jerry","student":[{"name":"stuC","project":"projectC"},{"name":"stuD","project":"projectD"},{"name":"stuE","project":"projectE"}]}, {"teacher":"Lee","student":[{"name":"stuF","project":"projectF"}]} ] And now I wanna render it into an irregular table like the picture: So how can I make it possible by using ng-repeat?It's really a confusing problem. here is the html code that makes the table...

How to build this table optimally, skills per user based on another table

mysql,table,normalization
I have a question which I have "writers" block on. I am building a database for a web-app in Mysql. I have two tables, we'll call them users and jobs. I want to have another table , lets call it skills. Now what I'm wanting is a way to link...

CSS text color in table cells

html,css,table
I have some (actually a lot) of tabular data. In HTML 3.2, I use HTML FONT tags to color the text within table cells (multiple colors in one cell at times) and it works fine. Under HTML 4.01 strict, I can't (shouldn't) use FONT, because it's no longer supported. Supposed...

How I can bind my List to a TableView in JavaFX?

java,table,javafx,tableview,observablecollection
i want to use TableView with a List in javaFX. It work to 90%. My Problem is that if I load my data to TableView the second row i the same how the first...I think I have a Problem in my foreach :/ Here My Code: @FXML private TableView<Ticket> tblTicket...

Displaying table columns below of each other for small displays (responsive layout)

html,css,table,responsive-design
I have a table with two columns: ------------- | A | B | ------------- I the browser width is too small for this layout, it should switch to this layout: ------------- | A | ------------- | B | ------------- I got this to work with fixed column width and "float:left":...

Displaying data in tables depending on group

php,mysql,table
I have a question in relation to displaying php tables that should be straight forward but I cannot get my head around it at the moment so any help would be appreciated, Basically what I want to do is display a team of players in a table , but display...

Count the number of consecutive pairs in a vector

r,table,count,split,categories
Suppose that I have the following vector: V<-c(-1,-1,-1,-1,-1,-1,-1,-1,1,1) and I want to count the number of CONSECUTIVE pairs in the following categories: (1,1), (-1,1), (1,-1), and (-1,-1). In my example, there are seven consecutive pairs of (-1,-1), one pair of (-1,1), and 1 pair of (1,1). I am trying to...

Table with AngularJS using different jsons

javascript,angularjs,table
I am new with AngularJS and I've created a table to show information from two different JSONs. To do that, I "mixed" them to get one. My code: test.html <!doctype html> <html ng-app="App"> <head> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.0-rc.2/angular.min.js"></script> <script type="text/javascript" src="script.js"></script> </head> <body ng-controller="myCtrl" ng-init="init()"> <table border=1> <thead> <tr>...

Print MySQL table in php (simple) [closed]

php,mysql,table,phpmyadmin
I am having problems printing my MySQL database table into my PHP code. I want the MySQL table to be printed in my website as an actual table, not just the database values. Everything I do doesn't seem to work and I have looked at similar questions to this but...

Awk Script to process data from a trace file

table,awk,rows,trace
I have a table (.tr file) with different rows (events). **Event** **Time** **PacketLength** PacketId sent 1 100 1 dropped 2 100 1 sent 3 100 2 sent 4.5 100 3 dropped 5 100 2 sent 6 100 4 sent 7 100 5 sent 8 100 6 sent 10 100 7...

How do I put this jQuery code in an external .js file?

javascript,html5,table
I have this jQuery code that works fine when placed between the <body> and </body> tags of the .HTML file. I want to use this JavaScript as external JavaScript instead of internal. Bit it works only if place the JavaScript at the end before the </body> tag. If I place...

Taking cell values in a table

javascript,jquery,html,table
I want to take some of the cell values in a table . How to take All at a strech. Can i assign a class name to those cells and take the values for each of them

MySQL 4 Table Join

mysql,table,join
I've been trying to get the proper data for this 4-table join for awhile and I can't seem to pin it down. I'm trying to grab a list of ids from songs based on who I am following in follows, and show the song id if my followers are the...

Form inside javascript not working

javascript,forms,table
I am using javascript to show a sort of menu box with clickable links but I changed my mind and want to use links as forms now. <script type="text/javascript"> $('.mouseon-examples div').data('powertipjq', $( [ '<table class="tabulkajazyku"><form id="myformen" action="member" method="POST"><input type="hidden" name="jazyk" value="en"><tr><td><a class="odkaz_cerveny odkaz_cerveny_block" href="#" id="mylinken"><img src="/images/flag_en.jpg" class="vlajky"><div...

Create Json in PHP using database

php,json,database,table
Hello Everyone, I have this query that I have run to gather data from three tables. I want to create Json from this data gathered. I have written the following script to create it. Please guide me if there is any quick or smart workaround to do this. This is...

Calculated column in SQL with IF-ELIF-ELSE condition

sql,sql-server,table,if-statement,calculated-columns
Dear Stackoverflow users, I need help on how to calculate this calculated column in SQL-code. I have seen earlier in the forum how you calculate based on adding columns together, or just giving a standard value. But in my case, I would like to add a column that could show...

CSS: div with display:table; within a list element no auto height?

html,css,table
I have an unordered list ul li where each li is floated but has a height value due to setting overflow:hidden; to the list-item. So when hovering the element in the webinspector the list-item clearly has a height value of 288px. Within each li i also have a div.caption with...

Joining tables and LEFT JOIN as new Columns in tsql

sql,sql-server,tsql,table,row
In this sample I have two tables containing data for my Customer and Products that a office supply shop has. which is seen below: The Above tables primarily functions to supply the required data for the third table which is the Orders table Using the orders table, I can get...

How do I display my mysql table column headers in my php/html output?

php,html,mysql,table,data
2 Questions... Scenario: I would like to query my database table via a form and then display the results that occur(if there are results) and my current situation is that it does work but it clears the form completely and leaves my to an empty page with just the results...

PL/SQL can't put value into index by table

table,indexing,plsql,insert,value
I can't put my value of v_emp into my emp_table. It is all going wrong at this line: emp_table(counter) := v_emp; The error that i get is: invalid use of type name of subtype name I can't see what the problem is.. CREATE OR REPLACE PROCEDURE laatste_emp IS v_emp employees%ROWTYPE;...

access python member from object without dict

python,arrays,table,dictionary
This is a small piece of an application I'm having some issues with at the moment. import csv with open('eggs.csv', 'rb') as csvfile: reader = csv.DictReader(csvfile) for row in reader: print(row['first_name'], row['cat']) print(row[1]) The application section runs fine with no issues, But I wanted to access each value from 'row'...

Drupal module development, custom database tables, pages for managing those data

table,module,drupal-7
I'm completely new to Drupal development I want to learn how to create basic module with such functionality: Create module with custom database tables Create one or several new pages as logical section of the site Manage data from database tables on those newly created pages For example, i want...

Python Beautiful Soup Table Data Scraping Specific TD Tags

python,table,web-scraping,beautifulsoup,html-table
This webpage... http://www.nfl.com/player/tombrady/2504211/gamelogs has multiple tables on it. Within the HTML all of the tables are labeled the exact same: <table class="data-table1" width="100%" border="0" summary="Game Logs For Tom Brady In 2014"> I can scrape data from only the first table (Preseason table) but I do not know how to skip...

Create a text file table with java with padding

java,arrays,table,text-files,padding
Ok since my last text aand question was very vague here is my source as of now and a clearer question. It is all about the padding now. Here is my code up to now: import java.io.BufferedWriter; import java.io.FileWriter; import java.io.IOException; import java.util.ArrayList; import java.util.Arrays; public class makeTable { static...

Calculate total for selected items in a table

javascript,jquery,table
I have a 3 tables each with multiple rows. I need to find a way to calculate the total of certain columns. Each row has a checkbox, so basically when this is checked, i need to be able to add that rows values to the total. I currently have this,...

How can i make my cells align text to the left?

html,css,table
I'm making a table with HTML and CSS and I cant seem to get specific cells to align the text to the left. here is my table <table> <tr class="l0"> <th rowspan="2">Employer/Employee Group</th> <th colspan="2">Duty</th> <th rowspan="2">Experience (Years)</th> <th rowspan="2">No. Of People</th> <th colspan="5">Responsibilities</th> </tr> <tr class="l0"> <th>Permanent Duty</th> <th>As...

How to get a mysql query to use a specific index?

mysql,database,table,indexing
SELECT * FROM orders WITH (INDEX(idx)); When i fired above query i got the error mysql #1064 - You have an error in your SQL syntax I have created index as below create index idx on orders(date,status); Can anybody tell me the correct syntax?...

Backbone checkbox value in tr view

jquery,table,backbone.js,checkbox,collections
I'm currently programming the web interface for a mvc web application and I need to get the models which have their checkbox checked. At the moment this is the template i use to generate a single table row: <td><span class="userintern"><%= intern %></span></td> <td><span class="username"><%= name %></span></td> <td><input id="add" class="add" type="checkbox"...

Multiple Json response to html Table format

php,mysql,json,table,response
I want to fetch data from different servers Database and i need to shown in one Centralised server. So i have written a SELECT query in different locations and i am trying to fetch in one Centralised Server. I am getting a JSON Array response. But i tried displaying it...

R - How to split all the varaibles from a dataframe?

r,table,split
I have a table like: $V1 $V2 $V3 toto|380 peper|728A tomato|I765 toto|458 peper|798A ognion|L965 toto|3L0 ginger|2R8A lemon|I765 And I would like to split it by the "|" and finally get : $V1 $V2 $V3 toto peper tomato toto peper ognion toto ginger lemon I tried with: split(data, sep="|") but it's...

Qt5: How to replace numeric values of a column of a SQL table view with text aliases?

sql,qt,table,view,alias
I am using Qt5. I managed to connect to a sql database and using QtCreator I have now a QTableView that is nicely populated using "SELECT * ..." from a test table I previously defined with MS SQL Manager... Only one thing I would like to change: ...One column named...

Excel- update table with another table based on cell value

excel,table,copy,cell
after searching, I understand I can copy data into a table one at a time using VLOOKUP. However, is it possible to replace an entire table with another if a cell contains a certain value? for example, I have a table1. I want to replace table1 with table2 if cell...

Export HTML table from an iframe to CSV

javascript,jquery,html,table,iframe
I'm trying to look for a script (with no progess) that could export an HTML table that I am able to get from an iframe. The table is inside the iframe and I can get and display its contents on my parent document. <script type="text/javascript"> function myFunction() { var myIFrame...

Convert table HTML to JSON

javascript,html,json,table
I have this: <table> <tr> <th>Name:</th> <td>Carlos</td> </tr> <tr> <th>Age:</th> <td>22</td> </tr> </table> And I need a json format. {"Name":"Carlos","Age": 22} I've tried with https://github.com/lightswitch05/table-to-json but it doesn't work for the headings in every row :( EDIT: http://jsfiddle.net/Crw2C/773/...

KDB+ / Q Table creation with dynamic number of columns

list,table,q,kdb
I am doing stuff like this q)seed:5 q)numvals:3 q)id:`u#1+til seed; q)vals:numvals cut (seed*numvals)?`8 q)1!([]id;vals) Now i am getting a table like this id| vals --| -------------------------- 1 | bhlkdkfd ghmjjepm gphfcddd 2 | jnloahej ipbcbnop heokehhg 3 | eijocfod nbbeopjo ddhiffmp 4 | cndelncn cmcmkckd aelpmccp 5 | nhjdlned cbkgpggg...

Instead of dataGridView in C# windows application, what should I use for console application to display a table from sql server?

c#,sql,table,console
Question as above. I was told to use list<> to do so. But I still have no clue about how to do it exactly. I am a C# newbie. Thanks for help.

JavaScript manually re-arrange rows in HTML table

javascript,html,table
Here is how I get the table: var table = document.getElementById(tableId); and here is only table rows without header and footer, basically table body only: var tableBodyRowsONLY = table.getElementsByTagName('tbody').item(0).getElementsByTagName('tr'); Here is the code to get a row and then insert it back into a table: var tempSaveRow; for (var x...

Bootstrap table's styles messed up when used with Ember.js

html,css,table,ember.js,bootstrap
I work with bootstrap. When I create a table in plain HTML, bootstrap's table styles are applied as expected. But, when I insert the same HTML into an Ember.js template, the bootstrap's table styles don't seem to apply (e.g. table borders, paddings and stripes are not present). Fiddle: http://jsfiddle.net/5evymbou/ Plain...

Add a new table row every 24 hours

php,html,table,row,add
my question is fairly simple as I am quite new to dynamic coding languages. Basically, I want to add a new table row to my table, every 24 hours. The new table row should be added at 00:00 every day and the table data is going to be a pre...

Apply class to

javascript,table,html-table
How can I find the class name of the <p> element contained within each <td> element then add that class to the <td> element's class list? <table> <tr> <td colspan="1"> <p class="Hello_blue">Hello Stack Overflow1</p> </td> <td rowspan="1" colspan="2"> <p class="Hello_red">Hello Stack Overflow2</p> <p class="Hello_red">defines red color,that class want to apply...

How to get value of one of from several using jQuery?

jquery,html5,table,tr
I have got the next code: <tr> <td id='type'> Type name </td> <td id='number'> 102030 </td> <td id='software'> 1.0-Alpha </td> </tr> I need to get value of td with id 'number'. I use the next code right now and it works: $('tbody tr').click(function() { var tdNumber = $(this).find('td:nth-child(2)').html(); }); But...

how to Select data from multiple tables with several conditions?

sql,oracle,table,select
There are tables FACULTIES (F_NUMB, F_NAME, F_TELEF) and STUDENTS (S_NUM, SURNAME, SPECIALITY, GROUP, FACULTY_NUMB). Please write SQL query to achieve faculties names in which the count of students are greater than in faculty “Computer science”. This is what i'm doing: select faculties.f_name, count(STUDENTS.S_NUM) from STUDENTS, FACULTIES where students.fac_num=FACULTIES.F_NUMB group by...

c - Implementation of Rainbow table

c,table,cryptography,rainbowtable
Ok, so I'm trying to implement the online phase of a rainbow table attack on the GSM networks KASUMI cipher. Im not using the full 128 bit keyspace only 32 bit. Below is my implementation. I have generated a single rainbow table with 2^25 rows and 2^7.88 chains links for...

Table click function called twice

javascript,jquery,html,table
I am performing some operation on the event of any td cell click in the table I call the below function. $('#tablename').on('click', 'td', function(e) { var column = delegateTarget.tHead.rows[0].cells[this.cellIndex], row = this.parentNode.cells[1]; if ($(row).text().trim() == "") { row = this.parentNode.cells[0]; } var rowvalue = $(row).text(); var columnvalue = $(column).text(); alert(rowvalue,...

How can i put several paragraphs in a cell in Rtf 1

table,rtf,paragraph
I can use a paragraph in a cell with this code: \trowd\cellx3000\pard\intbl\ltrpar\cf1\f0\fs24 aaaaa \cell\row But using 2 or more paragraphs is a problem for me. how can i do that?...

R - Contingency table once against multiple table

r,table,contingency
I have a table like the following: V1 V2 V3 V4 V5 V6 V7 V8 V9 V10 fve fve fve fve fve fve fve fve mdm mdm mdm fve fve fve fve fve fve fve fve fve fve fve fve fve fve fve fve fve fve fve mdm fve fve...

KDB+ / Q table creation with foreign key

database,table,foreign-keys,q,kdb
My question is about creating a table with q and using foreign keys. I know how to do it the following way q)T1:([id:1 2 3 4 5]d1:"acbde") q)T2:([id:1 2 3 4 5]f1:`T1$2 2 2 4 4) But now lets say I want to create the table with the ! operator...

Retaining original table formatting after a 'pagebreak'

excel,excel-vba,table,formatting,page-break
So here's the finished product, a statement of accounts with a working statement table, and an ageing analysis: Everything works great. It basically populates itself row by row with data from another table. Here is the sample code: j = 21 'First row on the statement of accounts workbook For...

SWT - show multiple table items

java,table,swt,tableviewer
Could anybody help me? I have a table in SWT and simply I want to show some table items but the table only shows one item and the others with vertical scroll. I want to show everything, without scrolling. I tried with the option SWT_NO_SCROLL but is not working. I...

FPDF + associative array key value column

php,arrays,table,pdf,fpdf
I'm trying to create a PDF with the FPDF library. I have an array like this: array (size=27) 'JobTitle' => string 'test-job' (length=8) 'lastName' => string 'zaezaeza' (length=8) 'firstName' => string 'zaezaeaz' (length=8) 'street' => string 'azezaeza' (length=8) 'streetNr' => string '54' (length=2) 'place' => string 'zaezaeza' (length=8) 'postalCode' =>...

swap table via select box option

javascript,jquery,twitter-bootstrap,table,swap
Hi there guys and girls, Looking to swap multiple tables with a javascript function, each one I try breaks horribly. I'd like the first table to show on page load, and then the rest to load as a different option is selected. Any help would be greatly appreciated! Here's the...

How to reduce table border thickness?

table,border,thickness
I am drawing one table with border=1 but it looks quite prominent as i am enclosing one image inside it so i want to make it thinner for better look and feel. <table border=1 cellpadding=50 cellspacing=0><tr><td></td></tr></table> How can i reduce border thickness? ...