It's just in the MSI log where I see the format. It's using WcaLog.
I was using the log to try to diagnose the problem and noticed it had that
behavior.> Date: Tue, 16 Dec 2008 19:09:42 -0500> From:
christopher.kar...@gmail.com> To: wix-users@lists.sourceforge.net> Subject: Re:
[WiX-users] Problems executing SQL script to insert data> > You're not using
SqlString items to do these? SqlScript doesn't format.> > Chris> > On Tue, Dec
16, 2008 at 6:40 PM, Kevin Fischer> <kevinfischer...@hotmail.com>wrote:> > >> >
I'm already using SqlScript elements to load them as a file.> >> > Kevin> Date:
Tue, 16 Dec 2008 18:23:30 -0500> From:> > christopher.kar...@gmail.com> To:
wix-users@lists.sourceforge.net>> > Subject: Re: [WiX-users] Problems executing
SQL script to insert data> > You> > either need to load them as SqlScript
elements from a file, or escape> the> > square brackets according to Formatted
String rules. I think it's [\[]> and> > [\]], but you'll want to double check
that.> > Or, you could always wing it,> > and just run without brackets. You
may find> it works just fine.> > Chris> >> > On Tue, Dec 16, 2008 at 6:15 PM,
Kevin Fischer> <> > kevinfischer...@hotmail.com>wrote:> > >> > I have an MSI
that's running a> > SQL script to insert data (using the> > SqlScript wix
element). The sql> > script looks like (simplified somewhat):> >> > /* table:
Version */> > /*> > some comment*/> > INSERT INTO [dbo].[Version]
([Object],[Version]) VALUES> > ('mytool',> > '2.0.12344.1234')GO> > /* some
comment*/> > INSERT INTO> > [dbo].[Version] ([Object],[Version]) VALUES
('foo',> > '2.0.0.1')GO> >> >> > When I run the MSI, my two records don't get
inserted into the table. I've>> > > enabled verbose logging and I don't see any
errors:> >> >> > ExecuteSqlStrings: Executing SQL string: INSERT INTO . (,)
VALUES> >> > ('mytool, '2.0.12344.1234')ExecuteSqlStrings: Executing SQL
string: INSERT>> > > INTO . (,) VALUES ('azApps', '2.0.0.1')> > I have
"ContinueOnError=no" in> > my wix file. I assume the table and column> > names
are disappearing in the> > log due to it being a formatted string. I'm> > also
assuming this isn't> > happening when actually executing the SQL. This is> > on
wix 3.0.4707.0. I> > have other MSIs with similar structure that> >
successfully insert data via> > SQL script.> >> > Any suggestions on tracking
this down?> >> > Thanks,> >> > Kevin> >
_________________________________________________________________>> > > You
live life online. So we put Windows on the web.> >> >
http://clk.atdmt.com/MRT/go/127032869/direct/01/> >> >> >
------------------------------------------------------------------------------>>
> > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,> >
Nevada.> > The future of the web can't happen without you. Join us at MIX09> >
to help> > pave the way to the Next Web now. Learn more and register at> >>> >
>> >
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/>>
> > _______________________________________________> > WiX-users mailing list>>
> > WiX-users@lists.sourceforge.net> >> >
https://lists.sourceforge.net/lists/listinfo/wix-users> >>> >
------------------------------------------------------------------------------>>
> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,
Nevada.>> > The future of the web can't happen without you. Join us at MIX09 to
help>> > pave the way to the Next Web now. Learn more and register at>> >
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/>>
> _______________________________________________> WiX-users mailing list>> >
WiX-users@lists.sourceforge.net>> >
https://lists.sourceforge.net/lists/listinfo/wix-users> >
_________________________________________________________________> > Suspicious
message? There's an alert for that.> >> >
http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad2_122008>
>> >
------------------------------------------------------------------------------>
> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.>
> The future of the web can't happen without you. Join us at MIX09 to help> >
pave the way to the Next Web now. Learn more and register at> >> >
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/> >
_______________________________________________> > WiX-users mailing list> >
WiX-users@lists.sourceforge.net> >
https://lists.sourceforge.net/lists/listinfo/wix-users> >>
------------------------------------------------------------------------------>
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.>
The future of the web can't happen without you. Join us at MIX09 to help> pave
the way to the Next Web now. Learn more and register at>
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/>
_______________________________________________> WiX-users mailing list>
WiX-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/wix-users
_________________________________________________________________
Suspicious message? There’s an alert for that.
http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad2_122008
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users