Бизнес-робот
Бизнес
робот

Темы:

Архив:

Каталог рекламы и объявлений

Ящик для предложений: sales@blogslov.ru

WiX-devs Digest, Vol 14, Issue 2

Send WiX-devs mailing list submissions to


To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/wix-devs
or, via email, send a message with subject or body 'help' to


You can reach the person managing the list at


When replying, please edit your Subject line so it is more specific
than "Re: Contents of WiX-devs digest..."


Today's Topics:

1. Re: using WcaExecuteView to join tables (Bob Arnson)
2. Re: using WcaExecuteView to join tables (Adam Langley)
3. Re: using WcaExecuteView to join tables (Adam Langley)
4. Re: using WcaExecuteView to join tables (Adam Langley)


----------------------------------------------------------------------

Message: 1
Date: Sun, 01 Jul 2007 22:43:10 -0700
From: Bob Arnson
Subject: Re: [WiX-devs] using WcaExecuteView to join tables
To: Adam Langley
Cc:
Message-ID:
Content-Type: text/plain; charset="iso-8859-1"

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:
>
> LPCWSTR vcsSqlBinaryScriptQuery = L"SELECT `Data` FROM `Binary` WHERE
> `Name`=?";
>
>
>
> Then line 233 appears to open the Binary table view and retrieve a
> row, using a row from the SQLScript table to populate the `Name` of
> the binary...
>
> I cant see anywhere that the '?' is replaced with a the name of the
> SQLScript Binary entry, so Im assuming this is happening automatically...
>

The WcaExecuteView call passes in the same hRec that it just fetched
from the SqlScript table. The first field in vcsSqlScriptQuery is
ScriptBinary_. There's only one ? parameter in vcsSqlBinaryScriptQuery
so that's the field value used in vcsSqlScriptQuery.

No magic, just a lack of comments.

--
sig://boB
http://joyofsetup.com/

-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 2
Date: Mon, 02 Jul 2007 17:51:51 +1200
From: Adam Langley
Subject: Re: [WiX-devs] using WcaExecuteView to join tables
To:
Message-ID:
Content-Type: text/plain; charset="us-ascii"

I thought it might be something like that... so if there were 2 '?' in the
query, it would use the first 2 columns in the hRec argument?



From: Bob Arnson [mailto:]
Sent: Monday, 2 July 2007 5:43 p.m.
To: Adam Langley
Cc:
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 '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:

LPCWSTR vcsSqlBinaryScriptQuery = L"SELECT `Data` FROM `Binary` WHERE
`Name`=?";



Then line 233 appears to open the Binary table view and retrieve a row,
using a row from the SQLScript table to populate the `Name` of the binary...

I cant see anywhere that the '?' is replaced with a the name of the
SQLScript Binary entry, so Im assuming this is happening automatically...


The WcaExecuteView call passes in the same hRec that it just fetched from
the SqlScript table. The first field in vcsSqlScriptQuery is ScriptBinary_.
There's only one ? parameter in vcsSqlBinaryScriptQuery so that's the field
value used in vcsSqlScriptQuery.

No magic, just a lack of comments.




--
sig://boB
http://joyofsetup.com/
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 3
Date: Mon, 02 Jul 2007 18:04:34 +1200
From: Adam Langley
Subject: Re: [WiX-devs] using WcaExecuteView to join tables
To:
Message-ID:
Content-Type: text/plain; charset="us-ascii"

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 not in any
PMSIHANDLE... theyre just LPWSTR strings...



From: Bob Arnson [mailto:]
Sent: Monday, 2 July 2007 5:43 p.m.
To: Adam Langley
Cc:
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 '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:

LPCWSTR vcsSqlBinaryScriptQuery = L"SELECT `Data` FROM `Binary` WHERE
`Name`=?";



Then line 233 appears to open the Binary table view and retrieve a row,
using a row from the SQLScript table to populate the `Name` of the binary...

I cant see anywhere that the '?' is replaced with a the name of the
SQLScript Binary entry, so Im assuming this is happening automatically...


The WcaExecuteView call passes in the same hRec that it just fetched from
the SqlScript table. The first field in vcsSqlScriptQuery is ScriptBinary_.
There's only one ? parameter in vcsSqlBinaryScriptQuery so that's the field
value used in vcsSqlScriptQuery.

No magic, just a lack of comments.




--
sig://boB
http://joyofsetup.com/
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 4
Date: Mon, 02 Jul 2007 18:55:25 +1200
From: Adam Langley
Subject: Re: [WiX-devs] using WcaExecuteView to join tables
To:
Message-ID:
Content-Type: text/plain; charset="us-ascii"

Got it...



PMSIHANDLE hParamRec = MsiCreateRecord(1);

WcaSetRecordString(hParamRec, 1, pwzData);

hr = WcaExecuteView(hViewServer, hParamRec);



From:
[mailto:] On Behalf Of Adam Langley
Sent: Monday, 2 July 2007 6:05 p.m.
To:
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 not in any
PMSIHANDLE... theyre just LPWSTR strings...



From: Bob Arnson [mailto:]
Sent: Monday, 2 July 2007 5:43 p.m.
To: Adam Langley
Cc:
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 '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:

LPCWSTR vcsSqlBinaryScriptQuery = L"SELECT `Data` FROM `Binary` WHERE
`Name`=?";



Then line 233 appears to open the Binary table view and retrieve a row,
using a row from the SQLScript table to populate the `Name` of the binary...

I cant see anywhere that the '?' is replaced with a the name of the
SQLScript Binary entry, so Im assuming this is happening automatically...


The WcaExecuteView call passes in the same hRec that it just fetched from
the SqlScript table. The first field in vcsSqlScriptQuery is ScriptBinary_.
There's only one ? parameter in vcsSqlBinaryScriptQuery so that's the field
value used in vcsSqlScriptQuery.

No magic, just a lack of comments.



--
sig://boB
http://joyofsetup.com/
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/

------------------------------

_______________________________________________
WiX-devs mailing list

https://lists.sourceforge.net/lists/listinfo/wix-devs


End of WiX-devs Digest, Vol 14, Issue 2
***************************************

2007 2 июля