I have a table (readings) already connected by ODBC in Access that opens very quickly when I click on it. However, when I try to run this in VBA I it locks up and never displays anything: Dim strSql As String strSql = "SELECT readings.ids " & _ "INTO ids_temp " & _ "FROM readings " & _ "WHERE readings.ids > 12...
Have a table of data surrounded by form tags. At the bottom of the page have a footer that is fixed. When the table is empty (only table header displaying) the entire footer shifts half way off the screen, to the right. Any ideas? Thanks! <form action="/cgi-bin/Lib.exe" method=POST name="dd" ID="Form1"> <div id="yyy"> ...
Hi, I'm really trying to work with div's and I can't seem to get the equivalent to the following simple table layout: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>Table example</title> <me...
I'd like to add row highlighting on hover using on CSS that will work in Internet Explorer. I have tried the following: #tableId tr:hover td { background-color:#f00; } This seems to work in Opera, Firefox, and Safari, but not in IE. Is there a solution or is the only solution JavaScript? ...
I have an HTML editor widget that I want to appear within an absolutely positioned, fixed-size DIV. However, I don't know the absolute size of the DIV beforehand, and it may change, like if the user resizes the window. The editor, naturally, has controls and an editable area. Each has their own DIV. I want the controls to take up as ...
After several hours of frustration I finally turned to the internet for the answer. Imagine this extremely simple piece of code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html> <head> <title>AARRRRRRGH</title> </head> <body> <table> <tr> ...
Hi all, I was wondering if anyone knew of a way to access a hidden field (by client id) within a table row using jquery. $("#tblOne").find("tr").click(function() { var worker = $(this).find(":input").val(); }); I find that the above works for a row that has only one input, but i need some help figuring out a way t...
In some webpages that I have, I must join some datatables in memory and then use the result as a datasource for a gridview. This in-memory join is the only solution, and I have written a method that takes care of it. I was wondering if there is any library out there that can do such things and other table operations, like ordering and...
Alright, I'm trying to buy into the idea that html tables should not be used, and that divs should be. However, I often have code that resembles the following <table> <tr> <td>First Name:</td> <td colspan="2"><input id="txtFirstName"/></td> </tr> <tr> <td>Last Name:</td> <td colspan="2"><input type="text" id="txtLastName"/></td> <...
Hi, I have two tables poll and poll_answers, which represent a poll and the options to choose from to answer a question from the poll. EX: DO I suck at SQL? yes yes, you do change craft and the co-responding tables: poll pollID pollQuestion 1 | DO I suck at Sql? poll_answers pollAnswerID pollAnswerText pollID 1 | yes | 1 2 ...
Exact duplicate of http://stackoverflow.com/questions/30251/tables-instead-of-divs http://stackoverflow.com/questions/135826/for-tabular-data-what-renders-faster-css-or-table http://stackoverflow.com/questions/83073/why-not-use-tables-for-layout-in-html I have hired a programmer and a web designer to make a website similar to S...
Hi there In my database I have some tables and views. How can I export all the tables( and not the views ) from my database from command line? ...
I have an array of objects defined similarly to the below: $scores = array(); // Bob round 1 $s = new RoundScore(); $s->Round_Name = 'Round 1'; $s->Player_Name = 'Bob'; $s->Score = 10; $scores[0] = $s; // Bob round 2 $s = new RoundScore(); $s->Round_Name = 'Round 2'; $s->Player_Name = 'Bob'; $s->Score = 7; $scores[1] = $s; // Jack ro...
I need to create table on the fly in C#.net program. Task is to export excel file to SQL Database. How to write store procedure for creating table if column name and table name are passed as parameters? I tried to write following SP. ALTER PROCEDURE dbo.CreateTempTable @Param1 VarChar(50), @Param2 VarChar(50), @Param3 VarChar(50), @Par...
In my HTML document, I have a table with two columns and multiple rows. How can I increase the space in between the first and second column with css? I've tried applying "margin-right: 10px;" to each of the cells on the left hand side, but to no effect. ...
Is this how one would normally design classes? One class = 1 Table. How about tables that contain a foreign key to another table? Suppose I have the following: PersonTable --------------- person_id name PersonMapTable --------------- map_id type_id (fk) person_id PersonTypeTable ------------------- type_id description parent_type_id ...
Hey, I'm making an online tile based game and I have just finished scripting the piece of code that takes the coordinates of where you are standing and builds the surroundings (tiles) around you (the game is made using a table with many cells that hold the tiles). I need some help creating a bit of AJAX that can refresh my table every ...
I need to vary a table's width after a click event in jQuery. HTML: <table class="zebra" border=0> Case 1: $("table.zebra").css("width","600px"); Case 2: $("table.zebra").css("width","200px"); CSS: table.zebra{} table.zebra tr.even td, table.zebra tr.even th { background-color:#FDD017; } table.zebra tr.odd td { back...
I have a set of javascript functions I use with a table of input elements to enable navigation. Things like keeping track of the currently focused element, and overflowing from the end of one row to the start of the next. I have scrollbar support with a fixed first column by creating one table that is only one column wide as my fixed col...