Hi Guys,
I'm using this sproc in sql server 12 locally.
CODE -->
ALTER PROCEDURE [dbo].[Admin_Metrics_GetApplicationsByJobID]
(
@JobID int
)
AS
SET NOCOUNT ON
select
uniqueappid,
cast(a.appdate as datetime) as xdate ,
sum(appcounter) over (order by appdate rows unbounded preceding) as...
The parents have to login to SharePoint first, where they will be presented with the password. It's just an idea to remove that step of having them login once more to the weebly.
Not really a case for the ICO.
Cheers,
Jeff
Thanks guys,
You're scaring me now!
There is nothing of any importance behind the scenes and of course some sites allow the login details to be passed through the querystring. I was thinking of these guys that post to forms automatically and wondered if that tech could be used for a good...
Hi all,
Our school uses 'weeblys' for the some of the kids websites, for example
http://toucanclass.weebly.com/
When our parents are logged into our SharePoint, I would like to somehow pass through the password (which we know of course) from a link to these sites and automatically login to the...
Yes, use stored procedures with SQL Server and SCOPE_IDENTITY
http://www.sql-server-performance.com/2003/stored-procedures-basics/
http://msdn.microsoft.com/en-us/library/ms190315.aspx
Cheers,
Jeff
Hi,
Been reading all day but just cannot find a solution to this one...
I have a userControl (header.ascx) which has an <ASP:Image> in it
<%@ OutputCache Duration="3600" VaryByParam="m" %>
m is a querystring values indicating the users username
I want to output cache this userControl...
Hi whosrdaddy!
Nice idea - Thanks!
I had to do a little tweak as the password hashes end in the '=' sign which caused the query string to baulk.
So I just matched on the first 10 characters of the QS and the Password hash; all good.
Great.
Cheers,
Jon
http://www.fluxii.com/
Hi all,
Passwords are hashed - on forgotten - users are asked to reset, they then get a link to the reset page with their UserID in the QueryString by email.
This works OK and they can reset their passwords but I would like to add another layer of protection to stop this link being reused.
I...
Thanks Jim,
I'm just curious that the login control (or from code) would log someone in with a leading space and actually capture that space - it should fail right?
Mad Jon
http://www.fluxii.com/
Hi there,
I'm either going mad or gone mad but if someone else could check this for me please.
A strange thing happened on one of my sites today and when I took a look it seems that when using either the membership logon control or even Membership.ValidateUser in code that; if you type a space...
Hi guys,
Trying to put up an intranet where we have mixed usage, windows and macs and authentication is either on Active Directory or Open Directory respectively.
I have read a load but it looks tricky. For windows users it's quite easy using windows authentication but for mac users?
So I...
Hi,
It's a long story but is anyone able to generate the .Net Mambership tables abd stored procedures for me as a script for an SQL Server 2008 Database?
Cheers,
Jeff
http://www.iews.co.uk/
Many thanks markros,
That led me to this Sproc which will work in SQL Server 2005 and did the trick nicely.
SELECT * FROM
(SELECT Row_Number() OVER (ORDER BY jobid desc) as rowid,
jobid, jobdesc, jobtitle
FROM tbl_jobs )
as a
where rowid = @rowid
Now, whatever the paging size is I...
HI,
I have a grid with paging - when the grid is paged I want to get the top row for each page - so for example if the paging is set at 10 records I need to get the 11th record, 21st record and so on.
How can I do this with a stored procedure please?
Cheers,
J
http://www.iews.co.uk/
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.