How do I pass multiple parameters to a logparser sql query?
Asked Answered
H

1

6

Using logparser you can pass on parameters to the query you'd like to run such as:

logparser file:query.sql?logs=somewhere\*.log -o:Sql -server:databaseserver 
  -database:database  -createtable:ON -i:IISW3C 
  -iCheckPoint:somewhere\query.lpc -transactionRowCount:200

Now I want to pass a second parameter to the sql query but it doesn't seem possible.

logparser file:query.sql?a=1&b=2

is seen as: a = "1&b=2". Escaping the character with an accent doesn't work either. Is this a limitation of the logparser tool?

Hygrothermograph answered 21/10, 2008 at 11:40 Comment(1)
I'm working this way because i want to run the same query on a series of websites and then create a db table for each websiteHygrothermograph
H
10

Found the answer, use the + character:

logparser file:query.sql?a=1+b=2
Hygrothermograph answered 21/10, 2008 at 12:5 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.