I surmise that it's going through printf (or family) at some point and the
%i is being interpreted as a formatted parameter. Double the % signs to fix
it.
I admit I can't see where this is happening in the current code. Which
version of WiX are you using (including the build, e.g. 3.0.3829)?
Are you aware that you can grant a SQL Server login to a Windows security
group? That might be a better option, using SqlStrings to create the login
to the group, and using User and Group elements to add the users to the
group.
--
Mike Dimmick
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert O'Brien
Sent: 12 April 2008 18:13
To: 'wix-users@lists.sourceforge.net'
Subject: [WiX-users] using for %i processing commands in custom actions
I have the following custom action I'm trying to make work and it seems the
%i parameter is getting dropped when command line gets executed. This same
statement works from a command prompt without any issues. Any insights as
to how I need to restructure this cmd.exe for loop %i parameter insertion to
get it working?
<CustomAction Id="QtExecCmdLineSet2" Property="QtExecCmdLineRun2"
Value=""[$(var.SystemFolder)]cmd.exe" /c for %i in
([DATABASELOGINS]) do ("[SQLBINDIR]sqlcmd.exe" /Q "create
login [\[]%i[\]] from windows")" />
/robert
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
