I've a <table> which has 10 column and 10 row i want to give different background to 1st and and 3rd column and another different background color to 8th row . is it possible without css class/id
I have an Entity Framework model using Table per Type Inheritance, but when I use a VS Data Generation Plan it produces duplicate keys in the child tables, which is a problem for EF. Does anyone know of a way to get this to work, so that the child tables do not have overlapping keys?
I'm working on a an PythonCE application, using the PocketPyGUI toolkit.
I'm using the gui.Table control to display a large list of choices
(addresses, codes and data associated), and I want to assign
a different color to the rows that have been completed.
Is there any way to colorize the rows given certain conditions?
TIA,
Pablo
i have a table with coloumn id , name and city
I want to fetch those rows where city is same and the number of rows are greater than 3. Is it possible in single sql query?
I have de-normalized table, something like
CODES
ID | VALUE
10 | A,B,C
11 | A,B
12 | A,B,C,D,E,F
13 | R,T,D,W,W,W,W,W,S,S
The job is to convert is where each token from VALUE will generate new record. Example:
CODES_TRANS
ID | VALUE_TRANS
10 | A
10 | B
10 | C
11 | A
11 | B
What is the best way to do it in PL/SQL without usage of custom pl/sql packages, ideally with pure SQL?
Obvious solution is to implement it via cursors. Any ideas?
is it possible to retrieve by using connection.getschema() the description item from a sql server table column, just like it's possible to retrieve the column name, data type, is nullable, column default value, etc?
$('#calendar').fullCalendar
(
{
editable: true,
events:
$.ajax
(
{
type: "POST",
url: "Calender.aspx/GetCDCatalog",
contentType: "application/json; charset=utf-8",
data: "{}",
dataType: "json"
}
)
}
)
calender.aspx is page and getcddialog is function which return type is array which doest not bind calender.
public CD[] GetCDCatalog()
{
XDocument docXML =
XDocument.Load(Server.MapPath("mydata.xml"));
var CDs =
from cd in docXML.Descendants("Table")
select new CD
{
title = cd.Element("title").Value,
star = cd.Element("star").Value,
endTime = cd.Element("endTime").Value,
};
return CDs.ToArray<CD>();
}
I am trying to get the value of a cell in a table view but it won't let me. If someone could help that would be great.
int numberOfChecks = -1;
numberOfChecks = numberOfChecks +1;
if ([objectsForTable count]-1 >= numberOfChecks) {
UITableViewCell *cell = [self.tableView cellForRowAtIndexPath:numberOfChecks];
NSString *cellTitle = cell.textLabel.text;
}
I have Table and i want to copy data from row to another and vice versa and i have the rows IDs.
is there any query to do that because i don't want make it by .net code i think sql query is easier than that.
thanks
I am trying to update records in an .mdb table with the number of records containing the same value
The sql below does not work but I think gives an indication of what I am trying to achieve.
UPDATE table1 AS A
INNER JOIN (SELECT PH_BSP , Count(PH_BSP) AS PHCOUNT FROM table1 GROUP BY PH_BSP) AS B
ON A.PH_BSP=B.PH_BSP
SET A.PH_SORT = B.PHCOUNT;
any ideas?
Hi
I am displaying all the users in the form using php where the data are fetched from db.
When i click on the icon all users data should be show in a pdf with a good table structure.
i am hereby using fpdf to generate it. i created pdf but the records are not in formatted structure.
How should this can be done.
kindly advice.
thanks in advance
strong text
How can i update bulk data in sql server 2005 by sending the data in XML form ?
i am able to insert bulk data into the table, but i am not getting idea to update the data.
Hey,
Am new to LINQ, and am trying to retrieve the top 50 rows of a particular table.
In SQL Server using an actual query i coudl say "Select TOP 50 from Transactions" , but not sure how i need to do that with LinQ
Any pointers that could help ?
Thanks !
Hello, I'd like to align text in right cell of table created below, to be vertically align to the top. How to do that ?
\begin{tabular}{l|p{3cm}}
\rule{2cm}{5cm} & Top align content ? \\
\end{tabular}
Regards
i have a java program executing 3 separate sqls with a same inline view - it takes about 20 minutes each time to build the inline view when the sqls are executed - is there a way to cache or reuse it ? - trying to avoid temporary table solution because it needs to be delegated to a plsql since the java program does not have rights to create schema objects.
ps: oracle 10g
Hi All,
I'm working on a development with over 700 tables. I need to see a listing of all related tables to a given table. Can you reccommed a app that is able to provide such a thing.
Many thanks
Gillian
hey, I downloaded the simple table storage sample on Cloudy in Seattle blog
It works perfect when aimed at local storage but when I change to point to azure storage i get the following error
Screenshot (on skydrive)
http://cid-00341536d0f91b53.skydrive.live.com/self.aspx/.Public/error.png
anyone see this before?
thanks guys
What is the syntax for an Update query for a table without a primary key?
Disclaimer: Frustratingly, adding a primary key is not an option. My program is a small program in a much larger system with poor data management. My development time does not include rewriting the other software.
Note: The database is Microsoft Access.
I am using Fluent NHibernate's (1.0 RTM) automapping feature to create my oracle database schema. My issue is that all the tables are using a single "hibernate-sequence", whereas I would prefer (and my boss would demand) a sequence generator for each table.
Any ideas?
I have Table and i want to copy data from row to another and vise versa and i have the rows IDs.
is there any query to do that because i don't want make it by .net code i think sql query is easier than that.
thanks
i am doing this:
CREATE TABLE person
(
num INT NOT NULL ,
firstname VARCHAR(20) NULL ,
lastname VARCHAR(30) NULL
);
sql server is just saying "debbuging" and it's not doing anything
is there a problem with the syntax or what?
Hi I am very new to both django and python... I have a html table with person information in each row...How do i get a particular row entry/id of the one i need to edit/delete to accordingly update/delete the row in database??
Hi,
In my table I have a date column which the date is displayed in the format "2009-11-18 10:55:28.370"
How can just get the date value of this field in a select statement. e.g.
select id from risks, where creation_date = getdate()
Ok SO, I have a user table and want to define groups of users together. The best solution I have for this is to create three database tables as follows:
UserTable
user_id
user_name
UserGroupLink
group_id
member_id
GroupInfo
group_id
group_name
This method keeps the member and group information separate. This is just my way of thinking. Is there a better way to do this? Also, what is a good naming convention for tables that link two other tables?
I have a table with a column called time, "HH:MM:SS". How can I do a batch update so that the value increment by 1 hour?
Is it something like:
update <table_name> set <time_column> = <time_column> + 3600 where ...