Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. whatsthehampton

    rows unbounded preceding in sql server 11

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

    Pass through login details to modal popup

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

    Remove output cache on a user control

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

    Reset Hashed Password

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

    .Net membership strange behaviour

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

    Get Users Logon name for intranet WindowsMac

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

    .Net membership tables

    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/
  8. whatsthehampton

    Get particular row using SPROC

    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/
  9. whatsthehampton

    Delete from self referencig table ?

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

    losing session variable conundrum?

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

    Online Payments for system not goods

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

    Searching by First letter?

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

    Code Page error

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

    Select Substring problem

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

    reuse a stored procedure

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

    Screen scrape to jpeg?

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

    Uninstall SQL server problems

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

    Split QueryString?

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

    'ProfileCommon is ambiguous

    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"...
  20. whatsthehampton

    Page not found error?

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

Part and Inventory Search

Back
Top