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 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 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'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
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?
I'm trying to build a sort of resource allocation form. I'd like to be able to print a table from a database, and then allow users to click on each cell that they would like to reserve. Also, being able to drag and select multiple cells. Then send all of this via $_POST to another php script.
Problem is, I have no idea where to start.
Any suggestions?
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 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?
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.
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?
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
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
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 !
i am doing this:
CREATETABLE 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 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
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
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 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
Hi,
Could somebody point out the necessary rights to do something like
ALTER TABLE myTable ADD myColumn int NOT NULL CONSTRAINT [Constraint_name] DEFAULT ((0))
?
I assumed
grant alter on myTable to [user]
was enough but I'm getting the error message
The UPDATE permission was denied on the object 'myTable', database 'x', schema 'dbo'.
Could UPDATE rights be needed because of the DEFAULT constraint?
Thanks.
Is it possible to log CREATE / ALTER statements issued on a MySQL server? I heard that it could be done with a trigger, but I can't seem to find suitable code anywhere. I would like to log these statements to a table, preferably with the timestamp of when they were issued. Can someone provide me with a sample trigger that would enable me to accomplish this?
I would like to log these statements so I can easily synchronize the changes with another MySQL server.
Is there anyway where I can create a trigger which will execute before the update/delete takes place( and then the actual update/delete takes place)? and how can I drop a trigger from a table?
Can anyone expalin me how to dynamically ger the Role from a DB table instead of hard coding it in the code.
ClaimsIdentity outputIdentity = new ClaimsIdentity();
outputIdentity.Claims.Add(new Claim(System.IdentityModel.Claims.ClaimTypes.Name, principal.Identity.Name));
outputIdentity.Claims.Add(new Claim(ClaimTypes.Role, "Manager"));
outputIdentity.Claims.Add(new Claim(ClaimTypes.Country, HttpUtilities.GetProgramIdentifierFromUrl()));
return outputIdentity;
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?