[QUOTE User="LogParser User : juasebsto"]Quote: Try combining Date and Time into a full timestamp the way the help file shows then do your comparison against that.[/QUOTE] Hi Daniel, Thanks for you answer. I really don't understand what is going on with this, it seems that Logparser ingnore the information...

Very glad to hear you got it working. I'm working on a Linux desktop now and haven't run LP in a while. Einspanjer is an old low dialect of German. It was a work name that means "one horse carriage" Looks like one of the literal Dutch definitions for enspænder is one-horse as well. I really like the...

Try combining Date and Time into a full timestamp the way the help file shows then do your comparison against that.

Hi there: I'm having a problem with a query. I'm trying to tranfer data from a log file with W3C format to a MsSQL database, I'm doing it with Visual Basic. I need to get all the records after a specific date and time, for instance after the "10-02-2007 00:17:40". I wrote the query below, the log parser...

FIXED: There was two minor things.. the 3rd row name "TotalHits" didnt match the one in the script, "TotalHitCount", second.. i guess the value of EXTRACT_VALUE(cs-uri-query, 'nf_hitCount') comes back as a string.. atleast it worked when i added the quotes ' ' so, working script: (changes made, are in...

Thank you SO much for the reply, the script wont execute tho, it gives me following error: C:\Program Files\Log Parser 2.2>LogParser file:script6.sql -i:W3C -o:NAT Error: SELECT clause: Semantic Error: arguments of the WHEN statements must all be of the same type as the argument of the CASE statement...

I think this query is along the lines of what you are looking for: SELECT TitleID, UniqueHitCount, TotalHits USING TO_LOWERCASE(EXTRACT_VALUE(cs-uri-query, 'nf_tID')) AS TitleID , EXTRACT_VALUE(cs-uri-query, 'nf_hitCount') AS hitCount , SUM(CASE hitCount WHEN 0 THEN 1 ELSE 0 END) AS UniqueHitCount ,...

Damn, i just tried to edit my former post, but when i pressed submit, i lost almost an hour of writing i need help on this one, what i miss is how you count more than one event, for an example, i want to count querystrings.. one row for querystrings containing a surtain value " &nf_visits=0 ", the...

edit: deleted cause it was TOO noob tried to edit it..but first time i messed it up and lost alot of writing... made new post here: http://www.logparser.com/instantforum33/shwmessage.aspx?ForumID=13&MessageID=5280 sorry

[QUOTE User="LogParser User : SkylarB"]Quote: One other advatange of like over = is like is case insensitive. The () were fine, your problem was the lack the the single quote, required to specify a string. [/QUOTE] Jeff, One of the responses to Loz_d was meant for you. Obviously as a newbie I am still...