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!

  • Congratulations SkipVought 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. gbrian

    Access bread crumb values

    How can I access the current bread cumb values with JavaScript? I'm looking to populate some variables with these values to group content. Any ideas? I'm new to SharePoint sorry if this isn't enough detail.
  2. gbrian

    Capturing the document download events

    I used to capture downloads with event handlers on URLs that had extensions matching things like "pdf,doc" on my website for additional event processing. With SharePoint, it seems the web part acts independently from the DOM events and this no longer works. How can I capture the click event on...
  3. gbrian

    Daily logs contain 2 days of data?

    Hello, I'm looking at a set of IIS 6 log files and am seeing the following: #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2008-10-02 04:00:00 The data starts and ends at 4am. Why is this? It means the log file for October 2nd will contain data from 4am October...
  4. gbrian

    Display information about any object on click

    Well, specifically, I just want to trap each MouseUp and MouseDown event, for all objects that exist on the page. This is possible? Where would you start, captureEvents? Ultimately, I would want to be able to record when and where a user clicks/releases the mouse, the timestamps, and whether...
  5. gbrian

    Display information about any object on click

    Is it possible to create a script that would return the information about an object that was clicked? IE - an alert that could return information such as ("Mouse Down on DIV NAME="test" OR "Mouse Up on IMG ALT="test image") without implementing events on each object? Just looking for a high...
  6. gbrian

    Deleted database, logs?

    Hello, Someone deleted one of our databases. Is there any way to find out when it was deleted and/or what host was connected to the server? Thanks, Brian
  7. gbrian

    My stored procedure is creating 20,000+ tempdb extent locks

    IDX_PAGELOGSID nonclustered, unique located on PRIMARY PageLogsID PK_PageLogs clustered, unique, primary key located on PRIMARY PageLogsID IDX_SESSIONID nonclustered, unique located on PRIMARY SessionID PK_SessionLogs clustered, unique, primary key located on PRIMARY SessionID
  8. gbrian

    My stored procedure is creating 20,000+ tempdb extent locks

    George, To show you a troublesome query that uses this non-indexed table: select count(distinct(userid)), 'ZOOM: get specs' from [mazda_at_logging_stats].dbo.sessionlogs WITH (NOLOCK) where sessionid in (select sessionid from [mazda_at_logging_stats].dbo.pagelogs WITH (NOLOCK)...
  9. gbrian

    My stored procedure is creating 20,000+ tempdb extent locks

    George, Thanks so much - I will try these things you have suggested. As far as indexing goes, the majority of the queries are searching a field [querystring] for a string. This field can be 100s of characters long and is searched using wildcards or specific substrings. This table has...
  10. gbrian

    My stored procedure is creating 20,000+ tempdb extent locks

    Hello...this is a nightmare, please help! I have a stored procedure that is a combination of 15 separate queries which each return a result in the form of 'description', count(some_field), and I am using UNION ALL to combine all of these. The result is something that might look like this...
  11. gbrian

    website tracking, server/client side

    Wasn't sure where to ask this but it's a pretty general question.. Obviously with web analytics you have IIS log analyzers (server-side tracking) and Javascript tagging (client-side tracking). However, if a company uses a "server-side" script to process details about your session and stores...
  12. gbrian

    regex, return all <a....> .... </a> from html

    Thanks for this, for some reason it is giving me an error: Unknown modifier 'a' in ... Any ideas?
  13. gbrian

    regex, return all <a....> .... </a> from html

    Hello, I need to create a regular expression so that I can replace anything in an html source file with blank if it does not match the criteria <a *> *</a> Example, <html> <strong><a href="asdf.com"> test1 </a></strong> <strong><a href="asdf.com"> test2 </a></strong> </html> would return: <a...
  14. gbrian

    read uncommitted / nolock, locks still showing up!

    Hello, I have a stored procedure that contains 30 queries all combined with UNION ALL (each query has the same columns and I could use UNION, but anyways..) It takes FOREVER (5 hours?). This data is input into the database monthly and is then never changed (no insert/update/delete going on)...
  15. gbrian

    Array/Largest value, help!

    Sorry I forgot to add, I want to return the description and not the count value.
  16. gbrian

    Array/Largest value, help!

    Hello, I have two columns, description and count. I need to search for the largest count value where description contains a specified string. Example, the largest count (column B) where column A contains 'Testing 1' Seems somewhat simple but I am having excel block! Thanks.
  17. gbrian

    Concat multiple database tables

    LOL, I love the name too--I think I'll use it! Thanks everyone. I'll let you know what worked best.
  18. gbrian

    Concat multiple database tables

    I have 25 databases that all contain the same "Table X" What I would like to do is create some sort of view that shows the data from all of these tables in one listing. What are my options for doing this directly in MS SQL Server?
  19. gbrian

    Cannot access newly created item with getElementById

    Dan, that is how I originally had it. I tried using setAttribute thinking .id wasn't working properly. Still no luck..

Part and Inventory Search

Back
Top