Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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