Search results for query: *

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...

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...

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 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...

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/

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/

Dear all, From my web app. I am trying to cascade delete entries that are in a self referencing table. This cte brings back the id's I need -------------------------------------- declare @idx int set @idx=1; -- need to pass in the variable here WITH OrganisationChart (Id, parentid) AS...

Hi all, On the development machine - xp pro sp2 iis 5.1 - all works as expected. On the live site - server 2003 - I am losing a session variable on an event click [or a double refresh??] - I have found that it only occurs when I include my global.asax file which has the folllowing routine in...

Dear all, I am building a databased build your own website sort of system. There is nothing to send or download. When (if??) a user signs up they should be able at some point to go to a secure payment page, pay the small fee, then come back to my site with confimation. To accept payments in...

Dear all, I am trying to search my database of families by passing in the first letter as @choice using:- where (familyname like + @Choice + '%') order by familyname asc This works as it should except when the names are Scottish such as McGarva or McIntosh etc. All help most appreciated...

Hi all, I am trying to import from the live hosts DB (sql server 2005) to my local dev server (2005). However I get Error 0xc02020f4: Data Flow Task: The column "imagePath" cannot be processed because more than one code page (1252 and 874) are specified for it. (SQL Server Import and Export...

Hi, I am trying to select only the first 200 character from an NText field. I read from sqlDennis that we should use 'substring' Select SUBSTRING(fieldname,1,200) from tablename This works but not when i need more than 1 field?? I have this SELECT substring(eventdesc,1,200), eventtitle...

Hi, I'd like to reuse some stored procedures and just pass a variable to them as the table name from code. I've read up but cannot find the answer unfortunately. Something like: create PROCEDURE [dbo].[KB_GetIDByNodeText] ( @NodeText nvarchar(50), @xTable varchar (50) ) AS select id from...

Dear all, Using screen scraping is it possible to scrape the URL and then produce a jpeg of the screen? I'n not sure where to start with this one. All help most appreciated. Cheers, J www.iSkool.net

Hi all, I installed SQL server 2005 MSDN developer edition on my xp pro sp2 laptop. The intsall is somehow corrupted and I am getting all sorts of WMI, win32 invalid memory location errors. In add/remove programmes clicking remove or change does nothing.(Nothing happens) How can I unistall...

Hi all, How can I take a query string such as:- ?Folder=Folder1/Folder2/Folder3 and split it into ?Folder=Folder1/Folder2 Just taking off the last part of the querystring? Thanks in advance, j www.bst.ac.jp

Hi all, I have enabled Profiles in the web.config as so; <profile enabled="true" defaultProvider="JBSqlProfileProvider"> <providers> <remove name="AspNetSqlProvider"/> <add name="JBSqlProfileProvider" connectionStringName="jbData" applicationName="/jbxel_iskool"...

Hi, IIS 6 on Windows Server 2003 Suddenly IIS has decided not serve up any content anymore and all sites display the page not found message. There is nothing in the error logs of IIS or the server that explains this - it just stopped overnight. I have restarted everything many times but no...