Browse by Tags

All Tags › help (RSS)

Re: SUM with multiple condition

Dave, I would have never thought of using QUANTIZE, I'm getting the exact and perfect output with little tweaks here and there. With expert advise like yours, you make LP possible for anything and everything. Really appreciate your expert advise and time. Regards, - Winson

Posted to Forum by wlau on 08-05-2008, 4:18 AM
HELP! IIS7 website problem...

Sorry if I sound pretty thick, but I've only just stumbled on IIS7, and have only used other people's free ftp hosting before. Let me explain... I am trying to set up an ASP website using IIS on my home pc. I've made the website, installed IIS7, created the website in IIS manager, and pointed...

Posted to Forum by jamesn010 on 08-04-2008, 1:35 PM
Re: SUM with multiple condition

Dave, Sorry! I couldn't figure out how to use GROUPING with condition either. Can you show an example. Or anyone reading this post. - Thanks in advance!!!!!

Posted to Forum by wlau on 08-02-2008, 1:04 AM
Re: SUM with multiple condition

Dave, thanks to your reply. I guess I didn't properly give my example, and I have already done exactly what you describe in your example. This is where I'm stuck, using HAVING would not solve my problem since it will only return one condition. I need to get the TOTAL of the SUM if Integer is...

Posted to Forum by wlau on 07-31-2008, 8:13 PM
SUM with multiple condition

Hi, I'm new using LP, need help to get SUM with multiple condition. Example: Column1(Text), Column2(Integer), Column3(Integer) If condition match Column1 and Column2 then get SUM of Column3 as Result1. I have many different combination, looking for query that can give me Result1, 2, 3, 4.... Then...

Posted to Forum by wlau on 07-31-2008, 6:25 PM
connecting outside

Hello, I am running server 2003 and php together. I am very new with IIS and its giving me some trouble. What I am looking to do is let outside computers connect to this one as an http server. I have the port set up in my router. howevere when i type my global ip into an outside computer it doesnt connect...

Posted to Forum by SneakyDoughnut on 07-28-2008, 3:03 PM
hide columns in output

I need to write a query that reads in a CSV file, does some magic, and then write an output CSV file. Specifically, I am merging two Blue Coat proxy server usage reports, removing duplicates, and cutting up some strings. Afterwards, I use a perl script to convert it to an Excel spreadsheet. My problem...

Posted to Forum by jrdepriest on 07-24-2008, 2:45 PM
First Time User: How to parse a downloaded file?

I have a website on a shared hosting plan. I have been downloading the log files daily. I then import them to excel workbook. I'm mainly looking for errors and post methods. This has been time consuming. So I have been looking for a better way. I found out about logparser (ver. 2.2) and have downloaded...

Posted to Forum by Photo_Joe on 07-20-2008, 6:22 PM
Multi query SELECT

The content of my sql file: SELECT count(*) as QUANTITY1 FROM SYSTEM, SECURITY, APPLICATION WHERE ( EventType = 1 ) and TimeGenerated >= TO_LOCALTIME( SUB( SYSTEM_TIMESTAMP(), TIMESTAMP('4', 'd') ) ) SELECT count(*) as QUANTITY2 FROM SYSTEM, SECURITY, APPLICATION WHERE ( EventType...

Posted to Forum by sshd.root on 05-14-2008, 5:25 PM
Need help!

Can't install thanks to websense... any ideas? if so email me captaincata@yahoo.com

Posted to Forum by captaincata on 04-24-2008, 1:37 PM

Page 1 of 2 (15 items) 1 2 Next >