table

Finding table values in watij using xpath

Hi, I am using watij to automate my UI testing. I have many tables in a webpage. I need to find a table which has a width 95%. It contains many rows. I have to find each row with different text say "running first UI test on local" as below adn need to get the td value "Complete". I am not ble to get the value but I get the watij address...

Connect to a linked table with code

Connect to a linked table with code I have some linked tables from a SQL-server; they are linked with an ODBC connection. The password is not saved with the connection. When I am double clicking on the table in Access table-view I get a prompt for username and password. After entering the password I can view the data in the table. My p...

MySQL search multiple tables for information

Hi all!, I'm building a searchfunctionallity where a user can select the different libraries to search in with the provided keywords. Also the AND operator is supported. My problem is that when I try to search for information it gets somehow multiplied or it gets increased exponential?? I'm using a MySQL database and PHP to process the...

Genshi table loop

What is wrong with this Genshi template: <html xmlns:py="http://genshi.edgewall.org/"&gt; <head> <title py:content="title"></title> </head> <body> <left> <table py: for="i in range(1, len(ctabl))"> <li py: for="e in ctabl[i]"> ${e} </li> </table> </body> </html> I get this er...

query to check index on a table

i need a query to see if a table already has any indexes on it. ...

table join where

Table1 t10 (id) id --- 1 2 table t11(a1,a2,a3) a1 a2 a3 ---------- 1 10 a 1 10 b 1 11 b 1 12 c 2 20 d 2 21 e select * from t10 a,t11 b where a.id = b.a1 how to display id a1 a2 a3 -------------- 1 1 10 a 1 1 10 b //(not display this row) 1 1 11 b //(not display this row) 1 1 12 c /...

How to export a single table from phpmyadmin to a comma delimited text file?

Hi, I need to export a table from phpmyadmin to a comma delimited text file. I think there is a code but can't seem to find it. I found one but it doesnt work. I need to export this table because I need to organize it and sort it and add another column so I can add data to this column. How can I do this please? Many thanks ...

css: fix row height

hi all, i'm having this markup: <style> table { border:1px solid black; width:400px; height:300px; border-collapse:collapse; } table tbody { border:1px solid red; } table td { background:yellow; padding:10px; border-bottom:1px solid green; height:20px; } <...

Transaction : Delete related records from multiple tables using subsonic T4 templates?

Hi, Using templates, how can I delete related records from multiple tables in a transaction? Please advise. Thanks Pankaj ...

jquery - change table-like items order

Hi, I have a set of divs table-like (with rows and cols), to display a soccer table. Now, I need to be able to order that table according to the key chosen, without refreshing the page and avoiding using ajax. Being more specific, I need to catch the values inside each "columm" refeering to the key chosen and re-order the table. I us...

How to format text in flex TextArea?

TextArea in flex doesn't render <TABLE></TABLE>. I want to display text in textarea in two columns. Column1 Column2 Row1: Data, data, data row1 Row2 longer: Data, data, data row2 Depending on text width in Column1 text in Column2 will be shifted. So all rows in Column2 are going to be aligned. How can I do...

JQuery and Live Table Updates

Hiya i was wondering if anyone can point me in the direction of examples or sample code for a few things regarding table minipulation i'm trying to achive but haven't been able to crack yet. I currently have a table of data being produced that is sorted and displayed using Tablesorter plugin for Jquery. I would like to add these extr...

Database column naming question

Let's suppose there is a table called AIRPORT and I have to choose between two naming conventions: to name attributes like AP_CODE, AP_NAME and so on or to name them just like CODE, NAME The question is whether it is more efficient to follow the first way or to use synonym (i.e. AP) and reference attributes like AP.CODE? Thanks in adva...

how to get value of first column in current row in html table using jquery

i have the following Delete confirmation code using jquery. The issue is that it assume the location of the name column. I now have name in the first row. Instead of using .prev('td'), is there anyway to get the value from the first column in the current row using jquery <script type='text/javascript'> $(document).ready(function(...

C#: How can I create a header in a table for each new page with Word interop?

I am trying to create a table with a header. I want this header to be repeated for each new page that the table takes. How can I do this in C# with Word 2007 Interop? ...

Interactive table

I need a interactive table. By word interactive I mean "I should be able to add rows and delete them from table". Above table I have input fields. So script should take value of each input field and add to table. But in the table should be a cross (for deleting rows), and once i click on it row gets deleted. Also I ust somehow pass all...

should nested tables have any horizontal space in between them

i think i have set all padding, margin, border-spacing, etc to 0 but i have a nested table within another table and there is a very tiny (but visible) horizontal space. I know this as the backcolor of the nested table is blue and the backcolor of the top table is white and i can see a line of white to the right and left of the table. I...

TSQL table based function returning different tables

Hi, I am triyng to write a table based fuction so it returns a different results depending of the value. I have: CREATE FUNCTION [dbo].[tblfn_GetAnyDataSet_As_View] (@DataType as varchar(50)) returns table asreturn select * from (select * from table1 UNION select * from table2) DATA where DATA.DataType=@DataType and I want to up...

Limit the # of rows being housed in a SQL table

This is a table design issue. I have a table that stores IP addresses. The data in the table is queried very heavily. The IPs can have different flags such as "unblocked", "temporarily blocked" and "permanently blocked". 95% - 99% of the IP addresses do not have any type of block on them. Is there a way to limit the # of rows in t...

Setting proportional column width with <col width="x*" />

I am trying to set proportional column width with <col width="x*" />: <table width="600px"> <col width="1*" /> <col width="2*" /> <col width="3*" /> <tbody> <tr> <td style="border: 1px solid black;">AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA AAA...