Datablade List Forum

Re: WebExplode =?ISO-8859-1?Q?=A0?=

Posted By: Donald Payne
Date: Monday, 5 January 2004, at 9:43 a.m.

This is an S/MIME signed message.

---------z20432_boundary_sign
Content-Type: text/plain; charset="us-ascii"

Are you talking about executing WebExplode() from dbaccess? e.g., to
export your Web Blade application to a bunch of flat files?
The problem might be that WebExplode does not have all the info it needs
to fetch the tags. When Webdriver executes WebExplode(), it passes a set
of parameters in the second argument to WebExplode(). These parameters
are in the form of name=value pairs:
name1=value1&name2=value2...
This set includes some that are required for fetching dynamic tags:

Variable: MI_WEBTAGSTABLE
Mandatory? No
Desctiption: Specifies the database table that the WebExplode() function
searches for the body of a dynamic tag
This variable can be set to the following two values: webTags or
wbTags. The default value if this variable is not set is webTags.
[...]

Variable: MI_WEBTAGSSQL
Mandatory? No
Desctiption: Specifies a user-defined SELECT statement that the WebEx-plode()
function runs to retrieve the body of a dynamic tag
Never set the MI_WEBTAGSSQL variable in your Webdriver
configuration. The variable should only be set for Web applica-tions
that were developed with Version 1.1 or earlier of Data
Director for Web.
The MI_WEBTAGSTABLE variable takes precedence over the
MI_WEBTAGSSQL variable. This means that if you have both
variables set in your Webdriver configuration, the WebExplode()
function searches for the dynamic tag in the table specified by the
MI_WEBTAGSTABLE variable.

Variable: MI_WEBTAGSCACHE
Mandatory? No
Desctiption: Specifies whether the WebExplode() function should cache
dynamic tags or not
This varable should be set to on to turn on caching or off to turn
off caching.
The default value is on.

Webdriver gets the above params for dynamic tags from the webconfigs
table. (And I think that for "nested" WebExplode(), all variables in the
page containing the WebExplode() are inherited by the nested WebExplode()
call.) However, if you execute WebExplode() from dbaccess, you'll need to
include them manually in 2nd arg. I'm guessing that all you need to pass
is MI_WEBTAGSTABLE:

SELECT WebExplode(object,
'MI_WEBTAGSTABLE=wbtags&yourvariable1=value1...'
)

HTH,
- Don

Donald E. Payne -- Sr. IT Specialist
IBM, Software Group, Data Management Services, OLTP Practice





"anatoli levin" <levin@cbs.gov.il>
01/05/2004 05:37 AM


To: Donald Payne/New York/IBM@IBMUS
cc:
Subject: Re: WebExplode



when i work with "select webexplode(object,..." from wbpages it does not
activate the dynamic tags which are stored in wbtags so the whole complex
does not work
i would like to write somthig like
unload to file.file
select WebExplod(object,'') from wbpages where id = 'id_name'
any solution???
**************************************************************************************************
** eSafe (R) scanned this email for viruses, vandals and malicious content
**
**************************************************************************************************




---------z20432_boundary_sign
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAA
oIAwggMlMIICjqADAgECAgMBFDIwDQYJKoZIhvcNAQEEBQAwaTELMAkGA1UEBhMC
VVMxNDAyBgNVBAoTK0ludGVybmF0aW9uYWwgQnVzaW5lc3MgTWFjaGluZXMgQ29y
cG9yYXRpb24xJDAiBgNVBAMTG0lCTSBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eTAe
Fw0wMzExMjQxODI2NTRaFw0wNDEyMDcxODI2NTRaMIGFMQswCQYDVQQGEwJVUzEM
MAoGA1UEChMDSUJNMREwDwYDVQQLEwhFTVBMT1lFRTEYMBYGA1UEAxMPRG9uYWxk
IEUuIFBheW5lMRkwFwYKCZImiZPyLGQBARMJNUE4NTEwODk3MSAwHgYJKoZIhvcN
AQkBFhFwYXluZWRAdXMuaWJtLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkC
gYEAm8rENcZDh8vvK2tJKF6jTG0gWb4GEFKVanjzmUI2G+xz4K3vpmOzkWaDSRy+
2dPBwvgPyOiRbUxUpkc5MV/Sw+JvQmAmThcjLcsFQExyOinbuRhJEbfjIyUX7VfM
cHfKhhnETuMAS/i2kDkrWHtaRnhJyyOsreT6/9lfdo8ykBkCAwEAAaOBvTCBujAR
BglghkgBhvhCAQEEBAMCBaAwDgYDVR0PAQH/BAQDAgXgMB0GA1UdDgQWBBQ/fh5x
0wzpWEXd7SMDQ0u2PRkWxjAsBgNVHREEJTAjoCEGCisGAQQBgjcUAgOgEwwRcGF5
bmVkQHVzLmlibS5jb20wHwYDVR0jBBgwFoAUrlQOkuqoM6krJC3HyG8w3N7zSkAw
JwYDVR0lBCAwHgYIKwYBBQUHAwIGCCsGAQUFBwMDBggrBgEFBQcDBDANBgkqhkiG
9w0BAQQFAAOBgQCTqqC2OdEUtbFyAhi6RlOrPwKt5+pcOe30y8Ze+ue7XOL95aVi
5ACUuvL2vwnfmO+6M2kkFwqxKSA6PnCv6c7J8G7qERBA36GMIzhM+nlxhqVotknT
1BNYn/Ui9U8kLTN9hj4LmiTGmNnt+j5qWnvGkC6oEZ2WWYgfzoNmSZqmTTCCAtow
ggJDoAMCAQICAwMUtjANBgkqhkiG9w0BAQQFADBOMQswCQYDVQQGEwJVUzEQMA4G
A1UEChMHRXF1aWZheDEtMCsGA1UECxMkRXF1aWZheCBTZWN1cmUgQ2VydGlmaWNh
dGUgQXV0aG9yaXR5MB4XDTAyMDExNDIyMDcxMVoXDTExMTIzMTIyMDcxMVowaTEL
MAkGA1UEBhMCVVMxNDAyBgNVBAoTK0ludGVybmF0aW9uYWwgQnVzaW5lc3MgTWFj
aGluZXMgQ29ycG9yYXRpb24xJDAiBgNVBAMTG0lCTSBDZXJ0aWZpY2F0aW9uIEF1
dGhvcml0eTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA629xc49NpAPzcAsu
ShTImLRYMkyepDEkC1UrPbsFRyAFZKsv3pw0MGfW/+7glzJKgPkPzlTZZfznznGb
mAWVnNBQlyPasOtCjif603euRXReHcKfHMPLItKozibWIPHJuOnwNclOnnP2sKuf
uPzbTImQTTi5c8JZNZcMJ0YFzTcCAwEAAaOBqjCBpzARBglghkgBhvhCAQEEBAMC
AIcwDgYDVR0PAQH/BAQDAgHGMB0GA1UdDgQWBBSuVA6S6qgzqSskLcfIbzDc3vNK
QDAfBgNVHSMEGDAWgBRI5mj5K9KylddH2CMgEE8zmJCf1DAPBgNVHRMBAf8EBTAD
AQH/MDEGA1UdJQQqMCgGCCsGAQUFBwMBBggrBgEFBQcDAgYIKwYBBQUHAwMGCCsG
AQUFBwMEMA0GCSqGSIb3DQEBBAUAA4GBADJye3NmC8q2PzypRZfu7JvDRDX1rRca
nZvujQupk2oCScMd3FIHLE7hOfu8YffvxtLU3y8wNamQEORjTD175qAffryXypwt
iVjBUKSDlBCQ14keMcF9ViNdewEoBGiAycUq8R3Lrlf4TCDvW4GeguNTFFZnS0yg
YATiJk7iDyvEMIIDIDCCAomgAwIBAgIENd70zzANBgkqhkiG9w0BAQUFADBOMQsw
CQYDVQQGEwJVUzEQMA4GA1UEChMHRXF1aWZheDEtMCsGA1UECxMkRXF1aWZheCBT
ZWN1cmUgQ2VydGlmaWNhdGUgQXV0aG9yaXR5MB4XDTk4MDgyMjE2NDE1MVoXDTE4
MDgyMjE2NDE1MVowTjELMAkGA1UEBhMCVVMxEDAOBgNVBAoTB0VxdWlmYXgxLTAr
BgNVBAsTJEVxdWlmYXggU2VjdXJlIENlcnRpZmljYXRlIEF1dGhvcml0eTCBnzAN
BgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAwV2xWGcIYu6gmi0fCG2RFGiYCh7+2gRv
E4RiIcPRfM6fBeC4AfBONOziipUEZKzxa1NfBbPLZ4C/QgKO/t0BCezhABRP/Pvw
DN1Dulsr4R+AcJkVV5MW8Q+XarfCaCMczE1ZMKxRHjuvK9buY0V7xdlfUNLjUA86
iOe/FP3gx7kCAwEAAaOCAQkwggEFMHAGA1UdHwRpMGcwZaBjoGGkXzBdMQswCQYD
VQQGEwJVUzEQMA4GA1UEChMHRXF1aWZheDEtMCsGA1UECxMkRXF1aWZheCBTZWN1
cmUgQ2VydGlmaWNhdGUgQXV0aG9yaXR5MQ0wCwYDVQQDEwRDUkwxMBoGA1UdEAQT
MBGBDzIwMTgwODIyMTY0MTUxWjALBgNVHQ8EBAMCAQYwHwYDVR0jBBgwFoAUSOZo
+SvSspXXR9gjIBBPM5iQn9QwHQYDVR0OBBYEFEjmaPkr0rKV10fYIyAQTzOYkJ/U
MAwGA1UdEwQFMAMBAf8wGgYJKoZIhvZ9B0EABA0wCxsFVjMuMGMDAgbAMA0GCSqG
SIb3DQEBBQUAA4GBAFjOKer89961zgK5F7WF0bnj4JXMJTENAKaSbn+2kmOeUJXR
mm/kEd5jhW6Y7qj/WsjTVbJmcVfewCHrPSqnI0kBBIZCe/zuf6IWUrVnZ9NA2zsm
WLIodz2uFHdh1voqZiegDfqnc1zqcPGUIWVEX/r87yloqaKHee9570+sB3c4AAAx
gDCCAcACAQEwcDBpMQswCQYDVQQGEwJVUzE0MDIGA1UEChMrSW50ZXJuYXRpb25h
bCBCdXNpbmVzcyBNYWNoaW5lcyBDb3Jwb3JhdGlvbjEkMCIGA1UEAxMbSUJNIENl
cnRpZmljYXRpb24gQXV0aG9yaXR5AgMBFDIwCQYFKw4DAhoFAKCBqzAYBgkqhkiG
9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNDAxMDUxNDQzMDRa
MCMGCSqGSIb3DQEJBDEWBBTe+vQgdSaMAqWVUn25i9LMHFOmlzBMBgkqhkiG9w0B
CQ8xPzA9MAcGBSsOAwIdMA4GCCqGSIb3DQMCAgIAgDAKBggqhkiG9w0DBzAHBgUr
DgMCBzANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAASBgIydUhAaJAUrApst
cZ/S8jpWFvS5Scy2cmH1LCiTN9rQV76jlbkZ3KcqOR/zChumSNdL6JBH/G9KYYDL
WX2D33vlpNs0RlUvdr0LqB0AxKC32Q3GwdOHhYbgauzichByQzalPFCn5coBOFxR
cwmzrFKrHgjePi8hBzXe1VhxeXKuAAAAAAAAAAA=

---------z20432_boundary_sign--

Datablade List Forum is maintained by Administrator with WebBBS 5.12.