Re: [WiX-devs] using WcaExecuteView to join tables

2007-07-02 Thread Bob Arnson
Adam Langley wrote: Got it... PMSIHANDLE hParamRec = MsiCreateRecord(1); WcaSetRecordString(hParamRec, 1, pwzData); hr = WcaExecuteView(hViewServer, hParamRec); Yep. You need a record to pass values to parameterized queries. -- sig://boB http://joyofsetup.com/ ---

Re: [WiX-devs] using WcaExecuteView to join tables

2007-07-01 Thread Adam Langley
Subject: Re: [WiX-devs] using WcaExecuteView to join tables Or, I suppose a better question is, How do I pass arguments of my own to WcaExecuteView? I would essentially like to pass 2 arguments to ExecuteView for substitution with multiple '?' in the query, but my arguments are

Re: [WiX-devs] using WcaExecuteView to join tables

2007-07-01 Thread Adam Langley
Bob Arnson [mailto:[EMAIL PROTECTED] Sent: Monday, 2 July 2007 5:43 p.m. To: Adam Langley Cc: wix-devs@lists.sourceforge.net Subject: Re: [WiX-devs] using WcaExecuteView to join tables Adam Langley wrote: (sorry for sending these emails directly to your address all the time, I just click 

Re: [WiX-devs] using WcaExecuteView to join tables

2007-07-01 Thread Adam Langley
[WiX-devs] using WcaExecuteView to join tables Adam Langley wrote: (sorry for sending these emails directly to your address all the time, I just click 'reply', as Im used to mailing lists having the posting address as the reply address (on behalf of...)) It's one of those thin

Re: [WiX-devs] using WcaExecuteView to join tables

2007-07-01 Thread Bob Arnson
Adam Langley wrote: (sorry for sending these emails directly to your address all the time, I just click 'reply', as Im used to mailing lists having the posting address as the reply address (on behalf of...)) It's one of those things guaranteed to annoy 50% of the population. line 30 has:

Re: [WiX-devs] using WcaExecuteView to join tables

2007-07-01 Thread Adam Langley
SQLScript Binary entry, so Im assuming this is happening automatically... From: Bob Arnson [mailto:[EMAIL PROTECTED] Sent: Monday, 2 July 2007 4:32 p.m. To: Adam Langley Cc: wix-devs@lists.sourceforge.net Subject: Re: [WiX-devs] using WcaExecuteView to join tables Adam Langley wrote

Re: [WiX-devs] using WcaExecuteView to join tables

2007-07-01 Thread Bob Arnson
Adam Langley wrote: Can anyone give me a quick rundown on how to use WcaExecuteView to join between tables? I've noticed some queries using "where `Name`=?" type parameters, and there seems to be some sort of convention for Wca automatically populating this parameter based upon the table sc

[WiX-devs] using WcaExecuteView to join tables

2007-07-01 Thread Adam Langley
Can anyone give me a quick rundown on how to use WcaExecuteView to join between tables? I've noticed some queries using "where `Name`=?" type parameters, and there seems to be some sort of convention for Wca automatically populating this parameter based upon the table schema. But I cant get it to