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

Question

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?

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 website — svandragt, Oct 21 '08 at 11:43

score 10 · Accepted Answer · answered Oct 21 '08 at 12:05

10

Found the answer, use the + character:

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

answered Oct 21 '08 at 12:05

svandragt

1,672
20
38

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

1 Answers1