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
