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 derfloh 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: *

  • Users: ShawnMolloy
  • Content: Threads
  • Order by date
  1. ShawnMolloy

    Help with a UNION!

    I am trying to determine what "Friends" a "User" has, based on a lookup table that holds a friends/user relationship information. The table looks like this: UserId | FriendId ----------------- 1 | 3 7 | 9 4 | 3 1 (Shawn) is friends with 3 (Ashlee), so therefore...
  2. ShawnMolloy

    Creating a Views table... worried about billions of records!!

    Hi Experts! While creating a table in a production SQL 2005 database to hold the "views" of a user profiles, I realized that this table will very quickly grow to such a scale that worries me a bit. I don't have exp w/database of this volume. Can anyone who is more weathered in the database...
  3. ShawnMolloy

    Problems using SQL 2005's ROW_NUMBER() function

    Why does this query return an error saying: "Invalid column name 'rowNum'." SELECT ROW_NUMBER() OVER (ORDER BY userid) as rowNum, userid, dateadded FROM Wisetopic_Friend WHERE rowNum > 3 Shawn Molloy Seattle, WA
  4. ShawnMolloy

    Select statements in one table

    how do i combine these select statements into one table? select count(*) from wt_message MessageCount where recipient=1 select count(*) from wtcomment commentCount where userid=1 Thanks, Shawn Molloy Seattle, WA
  5. ShawnMolloy

    Remove a DataItem from a list with the RepeaterItemEventHandler event

    How do I stop from adding this item while examing each item in a repeater control through the RepeaterItemEventHandler event handler? if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { // skip if the album is empty...
  6. ShawnMolloy

    Why does this location.href function not work in an iframe?

    Per the subject, this doesn't work in an iframe. function album_go(albId) { alert('Won't see this...'); location.href = 'tray_photos.aspx?albumId='+albId; } Shawn Molloy Seattle, WA
  7. ShawnMolloy

    How to get the top level querystring from within an IFRAME

    So if a page has a URL of http://mySite.com/thePage.aspx?id=4 and inside "thePage.aspx" there is an iframe with a url of http://mySite.com/theIframe.aspx how can theIframe.aspx see the "id" querystring parameter? -- shawn Shawn Molloy Seattle, WA
  8. ShawnMolloy

    Convert KB to MB

    Hello, How can I use C# to calculate a conversion from a value in kilobytes to Megabytes? -- shawn Shawn Molloy Seattle, WA
  9. ShawnMolloy

    Evaluating and comparing with the DataBinder.Eval statement

    Why can't I do something like this, or I should say "How" can I accomplish this kind of comparision withing a databound list control? <asp:Repeater ID="dl_Albums" runat="server"> <ItemTemplate> <div class="album">...
  10. ShawnMolloy

    Starting out with xmlHttp

    I wrote this fairly straightfoward ajax call, but the http.readyState never seems to reach 4 or http.status is never 200. There are two function calls, neither of them work: var http = createRequestObject(); function createRequestObject() { var xmlhttp; try...
  11. ShawnMolloy

    Using deterministic sql inserts

    Hello, I'd like to run a check on a table before I insert a new row. I want to check if the IP Address in this table exists before the insert: INSERT INTO views VALUES (@IpAddress, @VideoId) Would I just run a select for the ipaddress and then count the result set rows? Thanks, Shawn Molloy...
  12. ShawnMolloy

    Using COUNT(*) within a INNER JOIN

    Why does this query not work? select A.*, c.count(*) views, B.Username from video a inner join user b on a.userid = b.userid inner join video_view c on a.videoid = c.videoid It complains: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '*'. I also tried c.count(videoid) and...
  13. ShawnMolloy

    Working with XMLHttp objects

    I'm trying to learn to code "AJAX" types of functionality through javascript and the Microsoft.XMLHTTP object. I'm finding it terribly difficult to debug. Please take a look at the below code; this code never seems to get called: http.onreadystatechange = handleCommentResponse; When the...
  14. ShawnMolloy

    RegEx and ASP.NET

    I'm trying to create a reg ex expression for a URL rewriting .net handler that will find user names that precede a web url and redirect them based off their ID to a certain page. Example: http://MySite.com/SomeUser The regex expression should look for a string that doesn't have an extension I...
  15. ShawnMolloy

    Problems with subdomains

    I have created a subdomainin IIS 6.0 call "Video.MySite.com". I have an existing ASP.NET project in VisualStudio 2005 that is the "LocalHost" for this server. The root web (localhost) is pointing to d:\web. I created a new folder in d:\web\Video.MySite.com\ and pointed IIS to that folder for...
  16. ShawnMolloy

    IE positioning VS Firefox

    Hi, Why does the following code behave differently in ie vs firefox? <div class="movie_title"> <b>&quot;<%#Eval("VideoTitle")%>&quot;</b> <span style="font: 9px; color: #333333; float: right; position: relative; vertical-align: middle; top: -25; padding-right: 20px;"><a...
  17. ShawnMolloy

    Creating SubDomains in IIS

    Hello, I have a deticated server with IIS 6.0. I have created a sub domain in my host's control panel tool. The URL is http://Video.MyDomain.com. How in IIS do I assiagn a sub web or folder to that sub domain? Thanks, Shawn Molloy Seattle, WA
  18. ShawnMolloy

    Sub webs and web.config conflicts

    Hello, I have an IIS 6.0 server on windows 2K3. In the "Default" web site I have a web appliation with an HTTP module registeredd in the web.config like so: <httpModules> <add name="UploadHttpModule" type="UploadHttpModule,Web.Upload" /> </httpModules> So when I access http://myroot.com it...
  19. ShawnMolloy

    Creating a 'Photo Box' in CSS

    I'd like to create a CSS container to neatly display a photo, a caption, and some tool links for maintenace, like "Edit" end "Delete". The purpose of this photo box is to place within a repeating control, so that I can have any given number of boxes and they will wrap and flow seamlessly. I am...
  20. ShawnMolloy

    Making div content wrap.

    Ok, this may seem like a super noob question, but please bear with me. I have a tag as such: <div style="width:200px;"> A whole lot of content. </div Surprising, the content in this box will not wrap. I would like the box to behave so that when its filled with content the text will...

Part and Inventory Search

Back
Top