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
