homepage Welcome to WebmasterWorld Guest from 54.196.105.130
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Sql Wildcards In Batch File
%whatever% isn't passing when the batch is ran.
doubleJ




msg:4290167
 2:53 pm on Mar 31, 2011 (gmt 0)

I have a sql statement that works well when run from the command line. It returns 60 records (or whatever the amount at that time is).

"C:\Program Files (x86)\Log Parser 2.2\LogParser.exe" "SELECT COUNT(cs-uri-stem) FROM c:\inetpub\logs\logfiles\w3svc1\u_ex1104*.log WHERE sc-status=200 AND cs-uri-stem LIKE '%music%.mp3' AND sc-bytes >= 1377915" -i:W3C -o:W3C

If I put it in a .bat and run it, though, it returns 0 records. I think it's because the batch file is expecting %music% to be a variable and not a wildcard.
I tried *music* but it returned 0 records, too.
Is there a way to escape the % or use a different character, so both the batch and statement work?
JJ

 

coopster




msg:4290209
 3:56 pm on Mar 31, 2011 (gmt 0)

Try the escape from shell backslash (\) in front of the percent signs. I'm not a Windows pro so I am uncertain if that will work, but it's worth a shot.

doubleJ




msg:4290259
 5:46 pm on Mar 31, 2011 (gmt 0)

Nope.
Thanks for the thought, though.
JJ

coopster




msg:4290282
 6:20 pm on Mar 31, 2011 (gmt 0)

Try 2 percents characters?
[support.microsoft.com...]

And here is the full Command shell overview [microsoft.com].

doubleJ




msg:4290305
 7:13 pm on Mar 31, 2011 (gmt 0)

Whoohoo!
That works, perfectly.
Thanks...
JJ

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved