group

grouping , based on similarity in percentage ( Oracle Query)

Hi I have a table that look like this : username | privilges user1 privilge1 user1 privilge2 user1 privilge3 user2 privilge1 user2 privilge5 user2 privilge3 etc ...... i would like to group privliges based on similarity in percentage to other user . for example in the table : user1 and user2 has...

.NET Publisher Certificates

I'm using a book for studying for .NET certification, and I'm stumped on the issue of publisher certificates. Background: Windows Vista Home Basic SP2 Visual Studio 2008 .NET 3.5 SP1 Goal: Write a simple C# console application that has its permission to read from a specific text file determined by the application's certificate. Symp...

Documenting components effectively by Doxygen

How can you document components of your code such as the following effectively when the source codes of the components are in different locations? Example of my components in my first database project homepage - user_bar, check_login_status ask_question - form_ask_question login - form_login question_id - (form_login), form...

What ASP.NET MVC project files should be kept in a repository?

background:Me and my coworkers are working on asp.net mvc project ... we have a computer that works as a server which is where the project will be stored on... each of us has a copy of the project and we got tortoise cvs set up. questions: when you want to commit something, what files exactly do you commit?.. asp.net reports many dll fi...

how to filter list items by user/group column in sharepoint?

i have a list that have a user/group column that i want to filter by (the column name is: USERS). how do i get only the items in the list where the current user exists in the USERS column? ...

How to Store "Nested groups of checkboxes" ?

Hi I have a form (form1) which should gather information from user and save them into DB. In form1, I have 4 different groups: Group1: Operational Costs(Material, Salary, Maintenance) Group2: Selling Costs(Advertisement, Transport, Operational Costs) Group3: Financial Costs (Benefit, Penalty) Every option like Material, Salary, Mainte...

Grouping with operands question

I have a table: mysql> desc kursy_bid; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | datetime | datetime | NO | PRI | NULL | | | currency | varchar(6) | NO | PRI | NULL | | | va...

PHP regex extract/replace values from xml-like tags via named (sub)groups

Trying to create a simple text-translator in PHP. It shoult match something like: Bla bla {translator id="TEST" language="de"/} The language can be optional Blabla <translator id="TEST"/> Here is the code: $result = preg_replace_callback( '#{translator(\s+(?\'attribute\'\w+)="(?\'value\'\w+)")+/}#i', array($this, 'translateTe...

Group date as month

I have an SQL timestamp field and I need to group it by month like Jan, Feb, Mar, ... but in numbers (01, 02, 03, ...) I've tried GROUP BY DATE_FORMAT(i.push_date, '%Y-%m') But it's not working. ...

Grouping records with or without a foreign key constraint

I have a table containing objects, something like this: PK ObjectId FK ObjectTypeId Description etc The objects need to be grouped. I have been given a number of suggestions, all of which 'work' and some I like more than others. None of them are perfect so I'm struggling to settle on any particular model. 1/ Add a self-referential ...

ASP.NET like ValidationGroup using JQuery validate plugin?

Hello, We're trying to get the JQuery validate plugin working on our site but we've stumbled across a problem here. On our site we have a login form available for the user on every page where we'd like to use the plugin to validate that the user has entered a username and password. We also have a couple of pages showing for instanc...

jQuery Table Plugin with Group By

I need a jQuery Plugin that makes a Sortable and Groupable List of my Data. My Data is a Tasklist with a duedate, and i would like to have them grouped by date, and sortable. Is there a plugin that can handle that? I'm actually using dataTables, but it has some strange behavoir and bugs... Like: 16-10-2009 - Task 1 - Task 2 17-10-2009 ...

Mysql group by substring

I have a table with the following structure: id bigNumber text 1 1200321030011010233 "an item with some text" 2 1200321030011014563 "another item with some more text" 3 3120323434432211133 "more...." ... ... The table contains approximately 50.000 records. I want to do the following query but it is slow: SELECT COUNT(*), ...

SVG onmouseover for group with overlapping elements occurs twice

When attaching a function to the onmouseover event for an SVG group <g>...</g>, the event occurs once, each time the pointer enters to an element in the group. This occurs even if two elements in the group appears one inside another. For example: +-----+ |A ___| | |B | |__|__| When the pointer enters the A rectangle, and from ther...

How to write subquery in Criteria

Hi there, I have a SQL like this: Select tbl.id, tbl.name From (select table1.id, table1.name from table1 inner join table2 on table1.id = table2.id order by table2.priority ) tbl group by table1.id order by table1.name What I'm tring to archieve is to first sort (order by table2.priority), and then get the record with table1.i...

How to count group by rows in rails?

When i use User.count(:all, :group => "name"), i got multi rows, but it's not i want, what i want is the count of the rows, how can I do it? ...

How to solve this missing update() on custom image to org.eclipse.swt.widgets.Group?

I have an interesting aspect to submit to your attention. I am pretty sure the solution to this will prove to be very easy, and yet... i am unable to find it. Here it is what i did : i've drawed a Group on top of a Shell, and i've used this code : String message = "My message"; Image img = ....//some image group.addListener(SWT.P...

Advance grouping of List Items - Jquery

I have a list like <ul> <li> hgh55jjj </li> <li> abc99xyz </li> <li> hgf88hjk </li> <li> ........ </li> <li> ........ </li> <li> def99bnb </li> <li> gjj77hkj </li> <li> hgh55fhj </li> </ul> I want this to be formatted to a grouped list based on the two digits inside the text in such a way that all 99 items come together. And I also w...

how to structure an index for group by in Sql Server.

Hi, The following simple query takes a very long time (several minutes) to execute. I have an index: create index IX on [fctWMAUA] (SourceSystemKey, AsAtDateKey) SELECT MAX([t0].[AsAtDateKey]) AS [Date], [t0].[SourceSystemKey] AS [SourceSystem] FROM [fctWMAUA] (NOLOCK) AS [t0] WHERE SourceSystemKey in (1,2,3,4,5,6,7,8,9) GROUP BY [t0...

How can I insert page breaks between groups in Crystal Reports with two-sided printing?

In group expert options I have set Keep Group Together, which makes sure a new page is set. With two-sided printing enabled, how can I make sure that a new group always forms on a new sheet of paper? Can this be done in the formula expert? Is there some way of checking if the page I'm on is even or odd and insert a page from there? Just...