# Search Results

• ### How do I average the difference between specific values in TSQL?

##### - by jvenema
Hey folks, sorry this is a bit of a longer question... I have a table with the following columns: [ChatID] [User] [LogID] [CreatedOn] [Text] What I need to find is the average response time for a given user id, to another specific user id. So, if my data looks like: [1] [john] [20] [1/1/11 3:00:00] [Hello] [1] [john] [21] [1/1/11 3:00:23] [Anyone there?] [1] [susan] [22] [1/1/11 3:00:43] [Hello!] [1] [susan] [23] [1/1/11 3:00:53] [What's up?] [1] [john] [24] [1/1/11 3:01:02] [Not much] [1] [susan] [25] [1/1/11 3:01:08] [Cool] ...then I need to see that Susan has an average response time of (20 + 6) / 2 = 13 seconds to John, and John has an average of (9 / 1) = 9 seconds to Susan. I'm not even sure this can be done in set-based logic, but if anyone has any ideas, they'd be much appreciated!

• ### Working with a database

##### - by Susan
I have an existing program for a bank account, the user can create an account then withdraw or deposit money to the account. As a transaction is processed, labels are being used to show the current information such as (Beginning Balance, Transaction Fee, Withdrawal Amount, and Ending Balance). Now, I need to be able to keep track of the transactions being processed in a SQL database. I know how to add a database to the project and then set it up to display all of the data from the table in a gridview. This is assuming that I manually entered data into the table; however, the table should be blank when the program starts and as I process transactions, then the data should be written to the table. How do I bind my existing fields (labels) to a datatable and send the text to the table. The book that I have is all related to just displaying the data that is already in the table and I have been through a couple of tutorial online and they seem to be about the same subject. I haven't found anything on how to do what I am looking for. Can someone help me out here. I don't mind references to other websites that might have the answer. Thanks, Susan

• ### How long do DDoS attacks last?

##### - by Susan
I realize the answer to this question will vary, which is why I'm asking it. If you've suffered a DDoS attack before - how long did it last? Just trying to get an idea of how long we'll have to continue to wage this battle (going on a couple weeks now).

• ### Win XP / Win 7 Compatability

##### - by Susan
I run Win XP and my mother is getting a new PC with Win 7. We go remote quite frequently using Windows Messenger Remote Assistance. Will we still be able to do this when she gets the new PC?

• ### Windows XP - Windows 7 remote assistance compatibility

##### - by Susan
I run Windows XP and my mother is getting a new PC with Windows 7. We go remote quite frequently using Windows Messenger Remote Assistance. Will we still be able to do this when she gets the new PC?

• ### tar a directory and only include certain file types

##### - by Susan
Following the instructions here: http://linuxdevcenter.com/pub/a/linux/lpt/20_08.html I'm aiming to tar up a directory but only want to include .php files from that directory. Given the aforementioned instructions, I've come up with this command. It creates a file called IncludeTheseFiles which lists all the .php files, then the tar is supposed to do it's job only using the files listed in IncludeTheseFiles find myProjectDirectory -type f -print | \ egrep '(\.[php]|[Mm]akefile)\$' > IncludeTheseFiles tar cvf myProjectTarName -I IncludeTheseFiles However, when I run this it doesn't like the I include option? tar: invalid option -- I

• ### How to turn on SMTP relaying? Getting error: "SMTP Error: The following recipients failed [address]"

##### - by Susan
Attempting to configure some software on our server to send email via SMTP. When testing it, get this SMTP Error: SMTP Error: The following recipients failed [address]" Based on my research and a reply from the software's support team this error usually occurs because relaying is not allowed on the SMTP server from the IP address of the web server. The solution is to "Go to the configuration of your SMTP server and turn relaying on for your IP address" My question is -- how do I do this? Is this done from WHM? cPanel?

##### - by Susan
I forgot windows 7 password on my new computer and i cant log into at all. I was the Administrator for the computer with that account. Now I have to use my old xp computer to ask for help! Anyone know how i can change my password to log into my admin account?

• ### Permission / owner issue with pushing to git when editing directly from repo?

##### - by Susan
I have a web interface for deploying scripts from our repo at Github to our live server. The web interface just triggers a bash script with some git commands. If I make changes locally, push to repo, then run the bash script to pull from repo to live it works fine. However, if I make changes directly in the repo (via Github's web interface), I'm running into fast-forward / lock issues. These are the steps I'm taking: Make a change on a file at Github repo Run a bash script (as apache) via web from live server that attempts a git push / pull. Get these problems: PUSH To [email protected]:name/name.git ! [rejected] master - master (non-fast-forward) error: failed to push some refs to '[email protected]:name/name.git' To prevent you from losing history, non-fast-forward updates were rejected Merge the remote changes before pushing again. See the 'Note about fast-forwards' section of 'git push --help' for details. PULL From github.com:name/name branch master - FETCH_HEAD error: unable to unlink old 'includes/footer.inc' (Permission denied) Updating 8f6d922..d1eba9d Updating 8f6d922..d1eba9d SSH in as root, attempt a push / pull and it works fine. Ideas on why would this method not work from apache?

• ### New computer WindowsXP on Server 2003 network will not connect to file server

##### - by Susan Otto
When we try to connect to our file server with the new computer, it denies access. The computer is joined to the domain and I can see it on active directory. We need to connect to the file server for printing and terminal services. We have had this happen before and found that reinstalling Windows will fix the problem but I would like a speedier solution. any help would be appreciated.

• ### Lightest Linux Desktop supporting Firefox/graphic browser

##### - by Susan Mayer
I am on Windows and I have a remote server with Ubuntu 10.10. I want to use Firefox or other graphic browser on that remote server. The problem is, the server's memory is only 512MB, so I can install larger desktop environment. I used to use XFCE and NoMachine NX, but they consume too much memory on that Ubuntu server. The only thing I want to use is a graphic browser (for example firefox) on that server. Nothing else. Do you have any good suggestions? Thanks a lot!

• ### Dual-monitor Windows XP, monitors are "identified wrong"

##### - by Susan
Trying to use a dual-monitor desktop system with Windows XP.... 1 graphics card... with digital/analog outputs. Picking: Desktop - Properties - Settings - Identify It shows "2" as my left monitor... and "1" as my right. How do I switch them around? Here's what I've tried so far: Switch the cables (I can't. I need the digital cable on the better monitor.) Switch the monitors (I can't. One has a few dead pixels.) Drag the 1+2 graphics around (That doesn't change the IDENTIFY numbers.) Pick "use as primary" or "extend" (That doesn't change the IDENTIFY numbers.) Anything else I can try? What exactly controls/switches the "IDENTIFY numbers" around? I know it can be done. For weeks I ran this exact set-up... with the CORRECT numbers appearing on the monitors.... then just recently... after a few reboots... they now appear "switched around".

• ### Compare 2 sets of data in Excel and returning a value when multiple columns match

##### - by Susan C
I have a data set for employees that contains name and 3 attributes (job function, job grade and location). I then have a data set for open positions that contains the requisition number and 3 attributes (job function, job grade and job location). For every employee, i would like the three attributes associated with them compared to the same three attributes of the open positions and have the cooresponding requisition numbers displayed for each employee where there is a match.

• ### nested Navigation Frame in Silverlight...

##### - by susan
I created one master page with navigation frame. In a child page also containing one navigation frame once Child page loaded the outer next prev buttons are not working...

• ### 500 - Internal server error

##### - by Susan
hi, I have created one test.aspx and my local machine it is working fine. once I upload the same to server the page is not working. Its showing " 500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed. " Please anyone give some solution. Thanks in Advance.

• ### How to do an IF statement based on the value of a MySQL table cell?

##### - by Susan
How can I do an if statement based on the value of a mysql table cell. For example, I have a table of people with a column called marital_status. This column has one of two values: yes or no. But this doesn't work: \$query = mysql_query("SELECT marital_status FROM people WHERE first_name = 'John'"); while (\$row = mysql_fetch_assoc(\$query)) { \$maritalStatus = \$row['marital_status']; } if (\$maritalStatus == "yes") { echo "This person is married."; } else { echo "This person is NOT married."; } \$maritalStatus == "yes" doesn't return as true even though that is exactly the value in that cell.

• ### Handling credit cards and IOS

##### - by Susan Jackie
I am using NSUrlConnection asyncronous request to transmit credit card information to a secure third party server. I do the following: I get the credit card number, cvv, etc from the uitextfields. Encode the credit card information into a json format. Set as httpd body of the nsurlconnection request as follows: NSURL * url = [[NSURL URLWithString: "https://www.example.com"]; NSMutableURLRequest * request = [[NSMutableURLRequest alloc] initWithURL: url]; [request setHTTPMethod: @"POST"]; [request setValue:@"application/json" forHTTPHeaderField:@"Accept"]; [request setValue:@"application/json" forHTTPHeaderField:@"Content-Type"]; [request setHTTPBody: [NSJSONSerialization dataWithJSONObject: params options: kNilOptions error: &parseError]]; Send this information via asynchronous request to a secure third party server: [NSURLConnection sendAsynchronousRequest:request queue: queue completionHandler:^(NSURLResponse *response, NSData *data, NSError * requestError) { What should I be considering to send user credit card information to a third party server using nsurlconnection asynchronous request?

• ### trying to build a web ui tree from scratch

##### - by Susan
I have seen yahoo ui using div for every node of the tree. Is this a good thing to do. Seems like every node including leaf node is heavily nested. I saw a div, table, tr, td being used for creating a node. Is this necessary. Is there a better way to do the same. I tried to us tr for every node. Are there any issues with this approach Thanks

• ### FireBug - inspect element problem -- showing different interface?

##### - by Susan
When I used to use Firebugs inspect elements feature it displayed the results like this below. Nice, nested tags on the left...css style on the right. Recently, however, when I try to inspect elements it always shows this: I've tried reverting to older versions of FireBug (can't remember if it started after an update?).. I've poked around the settings... Can't find why it's different. The interface it's showing now is completely useless for figuring out what's going on in the html / css.

• ### Using XSD to validate node count

##### - by heath
I don't think this is possible but I thought I'd throw it out there. Given this XML: <people count="3"> <person>Bill</person> <person>Joe</person> <person>Susan</person> </people> Is it possible in an XSD to force the @count attribute value to be the correct count of defined elements (in this case, the person element)? The above example would obviously be correct and the below example would not validate: <people count="5"> <person>Bill</person> <person>Joe</person> <person>Susan</person> </people>

• ### Cloud Data Protection Tips and Guidelines

Cloud Data Protection is an effective way to save and secure your data (must be less than 1 TB) for ultimate optimization of your PC health. But one may get bewildered to see hundreds of data backup ... [Author: Susan Brown - Computers and Internet - April 01, 2010]

• ### Tackle Wi-Fi Security Issues Proficiently

In today?s world, Wi-Fi has become a convention and as a matter of fact, many big business giants are coming forward for offering service and gadgets for wireless communication. As an immediate effec... [Author: Susan Brown - Computers and Internet - March 21, 2010]

• ### Set Up A Wii Internet Connection

If you have a Nintendo Wii Internet connection, it will allow you to play games with friends across the world, download games, update your system, send email to friends, and more. With these given st... [Author: Susan Brown - Computers and Internet - May 08, 2010]