After creating a new list in SharePoint, I can add other types of fields, but not lookup fields or person or group fields.
When creating a new column... as soon as I change the column type radio to one of these two types of fields, I get a 403 forbidden error.
Any ideas why that might be happening? Is it a setting in Central Administration or…
I'm using ASP.NET MVC 2, DataAnnotation and MicrosoftMvcValidation.js for validation. I have two forms in my view..is there a way to use Validation Group for client side validation (like in ASP.NET Webforms).
thanks
Question:
I have a website where I gather browser statistics.
I have an SQL table (T_Visits), with the following columns:
uniqueidentifier Visit_UID,
uniqueidentifier User_UID,
datetime Visit_DateTime,
float Screen_w,
float Screen_h,
float Resolution = Screen_w * Screen_h
varchar resolutionstring = screen_w + ' x ' + screen_h
Now I…
I want to be able to add a parent column header to each pair of columns shown below.
So I want it to look like this:
Grand Total
OnHand Available
Anyone know a way to do this? I know you can group columns together but I'm wondering how I can apply a label to those groups.
Alternatively, if theres no way to do that, I…
Is that possible that MySQL can handle grouping of data according to age bracket?
In my users table, age value is their actual age. I want to group them according to age bracket. For example:
ages below 1 year old as age1, 1-4 yrs as age2, 5-9 yrs. old as age3 and so on.
hi
i want to know how to search and display string from group of string like google display the word which we search...
the following example from google
search word is google books
result
Search and preview millions of books from libraries and publishers worldwide using Google Book Search. Discover a new favorite or unearth an old…
Hi
in mysql how to write a sql like this, to get the amount of X 20 and <20
select date, numberOfXMoreThan20,numberOfXLessThan20, otherValues
from table
group by (date, X20 and X<20)
thanks
Hi,
I have a radio group which is validated for required. It works fine except when in certain cases I need to disabled first radio button leaving user to select one from remaining. Even in this case radios are validated but error message is not displayed. I believe its due to error message's association with first radio. Disabling…
select count(a),b,c
from APPLE
join MANGO on (APPLE.link=MANGO.link)
join ORANGE on (APPLE.link=ORANGE.link)
where id='camel'
group by b,c;
the column b gives values like
1.0
1.0,R
1.0,B
2.0
2.0,B
2.0,R
3.0,C
3.0,R
is there a way to modify the above quer so that all 1.0 and 1.0,R and 1.0,B are merged as 1.0
and 2.0,2.0,B…
I already create properties and add them to property group.Then I assign to my new product.But django show me
TypeError at /manage/update-product-properties/1
save() got an unexpected keyword argument 'using'
hi
i hve an sqlite db which contain transactions each transaction has an price
and has an transDate
i want to retrieve the sum of the transaction group by month
so the retrieved records should be like the following
Price month
230 2
500 3
400 4
pleas any help
I have group of stored procedures with names like 'somename_%'. Are there any way to delete that SP with one query, forexample
DROP PROCEDURE where name like
'somename_%'
.
Consider this data
PK field1 field2
1 a b
2 a (null)
3 x y
4 x z
5 q w
I need to get this data
select all columns from all rows where field1 has count 1
i tried and finally settled for
select * from mytable where field1 in
(select field1 from mytable group by field1 having count(field1)>1…
Hi all, currently I'm trying to retrieve all the groups that is in my sharepoint site. After which, I need to know which users are in the group and the level of site permission for each user. I'm using WSS 3.0 , developing in C# (visual studio 2008).
Help really needed as I'm still new in this area. Thanks in advance!
I am trying something like this:
result = db.GqlQuery("SELECT * FROM myDataMode COUNT(Employee) GROUP BY(Department) WHERE Salary > :1"10000)
And I am getting error :
BadQueryError: Parse Error: Expected no additional symbols at symbol count
Can any one please help me.
I want to do a class that have properties like font, which will have other properties, such as name, size, unit,bold.I had tried a solution but it isn't working for me.(http://stackoverflow.com/questions/755391/group-properties-in-a-custom-control)
Anyone can help? Any help will be appreciated.
…
I got the group names by using
ContactList clist=(ContactList)pim.openPIMList(PIM.CONTACT_LIST, PIM.READ_WRITE);
String[] s=clist.getCategories();
and now i want the groupid like i am getting the contact id using Contact.uid
After trying to find a reference to an API/tutorial to such thing, I have come here.
I would like to scan a specific group wall, pulling all posts from it, with PHP or C#.
In the end, I would like to have a nested-array containing each posts, with the next details:
An array of the related…
We have 40K+ groups in our active directory and we are increasingly facing problem of circular nested groups which are creating problems for some applications.
Does anyone know how to list down the full route through which a circular group membership exists ?
e.g.
G1 --> G2 --> G3…
Im having two tables
TableA
Custid prodid Amt1
1 10 200
2 20 300
3 10 400
4 30 300
5 20 400
6 30 200
TableB
prodid Amt2
10 100
20 200
30 300
and i want sum of all amount group by prodid. can any one give me both ansi and Tsql quries.
Hi,
I've got table Articles
ID identity autoincement, IDArticle: nvarchar(100) ,IDCar nvarchar(100), createddate
How to convert this:
SELECT IDCar , MAX(createddate)
FROM Articles
GROUP BY IDCar
to get IDArticle
eg:
1 art1 BWM 5-21-2010
2 art2 BMW 5-24-2010
3 art3 BMW 5-31-2010
4…
The goal of this query is to get a total of unique records (by IP) per ref ID.
SELECT COUNT(DISTINCT ip), GROUP_CONCAT(ref.id)
FROM `sess` sess
JOIN `ref` USING(row_id)
WHERE sess.time BETWEEN '2010-04-21 00:00:00' AND '2010-04-21 23:59:59'
GROUP BY ref.id
ORDER BY sess.time DESC
The…