Datablade List Forum

Re: How to search argument into webpages table.

Posted By: Donald Payne
Date: Wednesday, 21 April 2004, at 6:04 p.m.

In Response To: How to search argument into webpages table. (AQUILES LORANCA SANCHEZ)

This is an S/MIME signed message.

---------z54136_boundary_sign
Content-Type: text/plain; charset="US-ASCII"

Do you mean, how to search for web pages that contain a given string?
Here's how I do it [from memory, untested]:

SELECT id
FROM webPages
WHERE object :: LVARCHAR MATCHES '*searchstring*'
;

ummm ... I think there are two casts there; either
WHERE object :: HTML :: LVARCHAR MATCHES '*searchstring*'
or
WHERE object :: CLOB :: LVARCHAR MATCHES '*searchstring*'

Beware: depending on your version of IDS, LVARCHAR's might be truncated at
32KB or some other number. Try searching for string that appears only at
end of a long page, to make sure it MATCHES on the whole page.

Thanks and Regards,
- Don

Donald E. Payne -- Sr. IT Specialist
IBM, Software Group, Data Management Services, OLTP Practice
phone / fax 1-212-745-4380 (internal 243-4380) (during day, fwds. to cust.
site, cell)
cell 631-379-2672
mobile office (no mail): 590 Madison Ave, New York, NY
Certified IBM Informix Professional
http://www.ibm.com/software/data

forum.subscriber@iiug.org wrote on 04/21/2004 12:00:36 PM:

> Hi guys,
>
> IHAC that wants to know what is the easiest way to search an
> argument into the object field from the webpages table.
>
> Any idea?
>
> Thanks in advance.
>
> Aquiles.
>
>


---------z54136_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

MIAGCSqGSIb3DQEHAqCAMIIUNgIBATELMAkGBSsOAwIaBQAwCwYJKoZIhvcNAQcBoIISVjCCAtow
ggJDoAMCAQICAwMUtjANBgkqhkiG9w0BAQQFADBOMQswCQYDVQQGEwJVUzEQMA4GA1UEChMHRXF1
aWZheDEtMCsGA1UECxMkRXF1aWZheCBTZWN1cmUgQ2VydGlmaWNhdGUgQXV0aG9yaXR5MB4XDTAy
MDExNDIyMDcxMVoXDTExMTIzMTIyMDcxMVowaTELMAkGA1UEBhMCVVMxNDAyBgNVBAoTK0ludGVy
bmF0aW9uYWwgQnVzaW5lc3MgTWFjaGluZXMgQ29ycG9yYXRpb24xJDAiBgNVBAMTG0lCTSBDZXJ0
aWZpY2F0aW9uIEF1dGhvcml0eTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA629xc49NpAPz
cAsuShTImLRYMkyepDEkC1UrPbsFRyAFZKsv3pw0MGfW/+7glzJKgPkPzlTZZfznznGbmAWVnNBQ
lyPasOtCjif603euRXReHcKfHMPLItKozibWIPHJuOnwNclOnnP2sKufuPzbTImQTTi5c8JZNZcM
J0YFzTcCAwEAAaOBqjCBpzARBglghkgBhvhCAQEEBAMCAIcwDgYDVR0PAQH/BAQDAgHGMB0GA1Ud
DgQWBBSuVA6S6qgzqSskLcfIbzDc3vNKQDAfBgNVHSMEGDAWgBRI5mj5K9KylddH2CMgEE8zmJCf
1DAPBgNVHRMBAf8EBTADAQH/MDEGA1UdJQQqMCgGCCsGAQUFBwMBBggrBgEFBQcDAgYIKwYBBQUH
AwMGCCsGAQUFBwMEMA0GCSqGSIb3DQEBBAUAA4GBADJye3NmC8q2PzypRZfu7JvDRDX1rRcanZvu
jQupk2oCScMd3FIHLE7hOfu8YffvxtLU3y8wNamQEORjTD175qAffryXypwtiVjBUKSDlBCQ14ke
McF9ViNdewEoBGiAycUq8R3Lrlf4TCDvW4GeguNTFFZnS0ygYATiJk7iDyvEMIIC2jCCAkOgAwIB
AgIDAxS2MA0GCSqGSIb3DQEBBAUAME4xCzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0w
KwYDVQQLEyRFcXVpZmF4IFNlY3VyZSBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkwHhcNMDIwMTE0MjIw
NzExWhcNMTExMjMxMjIwNzExWjBpMQswCQYDVQQGEwJVUzE0MDIGA1UEChMrSW50ZXJuYXRpb25h
bCBCdXNpbmVzcyBNYWNoaW5lcyBDb3Jwb3JhdGlvbjEkMCIGA1UEAxMbSUJNIENlcnRpZmljYXRp
b24gQXV0aG9yaXR5MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDrb3Fzj02kA/NwCy5KFMiY
tFgyTJ6kMSQLVSs9uwVHIAVkqy/enDQwZ9b/7uCXMkqA+Q/OVNll/OfOcZuYBZWc0FCXI9qw60KO
J/rTd65FdF4dwp8cw8si0qjOJtYg8cm46fA1yU6ec/awq5+4/NtMiZBNOLlzwlk1lwwnRgXNNwID
AQABo4GqMIGnMBEGCWCGSAGG+EIBAQQEAwIAhzAOBgNVHQ8BAf8EBAMCAcYwHQYDVR0OBBYEFK5U
DpLqqDOpKyQtx8hvMNze80pAMB8GA1UdIwQYMBaAFEjmaPkr0rKV10fYIyAQTzOYkJ/UMA8GA1Ud
EwEB/wQFMAMBAf8wMQYDVR0lBCowKAYIKwYBBQUHAwEGCCsGAQUFBwMCBggrBgEFBQcDAwYIKwYB
BQUHAwQwDQYJKoZIhvcNAQEEBQADgYEAMnJ7c2YLyrY/PKlFl+7sm8NENfWtFxqdm+6NC6mTagJJ
wx3cUgcsTuE5+7xh9+/G0tTfLzA1qZAQ5GNMPXvmoB9+vJfKnC2JWMFQpIOUEJDXiR4xwX1WI117
ASgEaIDJxSrxHcuuV/hMIO9bgZ6C41MUVmdLTKBgBOImTuIPK8QwggMgMIICiaADAgECAgQ13vTP
MA0GCSqGSIb3DQEBBQUAME4xCzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0wKwYDVQQL
EyRFcXVpZmF4IFNlY3VyZSBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkwHhcNOTgwODIyMTY0MTUxWhcN
MTgwODIyMTY0MTUxWjBOMQswCQYDVQQGEwJVUzEQMA4GA1UEChMHRXF1aWZheDEtMCsGA1UECxMk
RXF1aWZheCBTZWN1cmUgQ2VydGlmaWNhdGUgQXV0aG9yaXR5MIGfMA0GCSqGSIb3DQEBAQUAA4GN
ADCBiQKBgQDBXbFYZwhi7qCaLR8IbZEUaJgKHv7aBG8ThGIhw9F8zp8F4LgB8E407OKKlQRkrPFr
U18Fs8tngL9CAo7+3QEJ7OEAFE/8+/AM3UO6WyvhH4BwmRVXkxbxD5dqt8JoIxzMTVkwrFEeO68r
1u5jRXvF2V9Q0uNQDzqI578U/eDHuQIDAQABo4IBCTCCAQUwcAYDVR0fBGkwZzBloGOgYaRfMF0x
CzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0wKwYDVQQLEyRFcXVpZmF4IFNlY3VyZSBD
ZXJ0aWZpY2F0ZSBBdXRob3JpdHkxDTALBgNVBAMTBENSTDEwGgYDVR0QBBMwEYEPMjAxODA4MjIx
NjQxNTFaMAsGA1UdDwQEAwIBBjAfBgNVHSMEGDAWgBRI5mj5K9KylddH2CMgEE8zmJCf1DAdBgNV
HQ4EFgQUSOZo+SvSspXXR9gjIBBPM5iQn9QwDAYDVR0TBAUwAwEB/zAaBgkqhkiG9n0HQQAEDTAL
GwVWMy4wYwMCBsAwDQYJKoZIhvcNAQEFBQADgYEAWM4p6vz33rXOArkXtYXRuePglcwlMQ0AppJu
f7aSY55QldGab+QR3mOFbpjuqP9ayNNVsmZxV97AIes9KqcjSQEEhkJ7/O5/ohZStWdn00DbOyZY
sih3Pa4Ud2HW+ipmJ6AN+qdzXOpw8ZQhZURf+vzvKWipood573nvT6wHdzgwggMgMIICiaADAgEC
AgQ13vTPMA0GCSqGSIb3DQEBBQUAME4xCzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0w
KwYDVQQLEyRFcXVpZmF4IFNlY3VyZSBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkwHhcNOTgwODIyMTY0
MTUxWhcNMTgwODIyMTY0MTUxWjBOMQswCQYDVQQGEwJVUzEQMA4GA1UEChMHRXF1aWZheDEtMCsG
A1UECxMkRXF1aWZheCBTZWN1cmUgQ2VydGlmaWNhdGUgQXV0aG9yaXR5MIGfMA0GCSqGSIb3DQEB
AQUAA4GNADCBiQKBgQDBXbFYZwhi7qCaLR8IbZEUaJgKHv7aBG8ThGIhw9F8zp8F4LgB8E407OKK
lQRkrPFrU18Fs8tngL9CAo7+3QEJ7OEAFE/8+/AM3UO6WyvhH4BwmRVXkxbxD5dqt8JoIxzMTVkw
rFEeO68r1u5jRXvF2V9Q0uNQDzqI578U/eDHuQIDAQABo4IBCTCCAQUwcAYDVR0fBGkwZzBloGOg
YaRfMF0xCzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0wKwYDVQQLEyRFcXVpZmF4IFNl
Y3VyZSBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkxDTALBgNVBAMTBENSTDEwGgYDVR0QBBMwEYEPMjAx
ODA4MjIxNjQxNTFaMAsGA1UdDwQEAwIBBjAfBgNVHSMEGDAWgBRI5mj5K9KylddH2CMgEE8zmJCf
1DAdBgNVHQ4EFgQUSOZo+SvSspXXR9gjIBBPM5iQn9QwDAYDVR0TBAUwAwEB/zAaBgkqhkiG9n0H
QQAEDTALGwVWMy4wYwMCBsAwDQYJKoZIhvcNAQEFBQADgYEAWM4p6vz33rXOArkXtYXRuePglcwl
MQ0AppJuf7aSY55QldGab+QR3mOFbpjuqP9ayNNVsmZxV97AIes9KqcjSQEEhkJ7/O5/ohZStWdn
00DbOyZYsih3Pa4Ud2HW+ipmJ6AN+qdzXOpw8ZQhZURf+vzvKWipood573nvT6wHdzgwggMlMIIC
jqADAgECAgMBFDIwDQYJKoZIhvcNAQEEBQAwaTELMAkGA1UEBhMCVVMxNDAyBgNVBAoTK0ludGVy
bmF0aW9uYWwgQnVzaW5lc3MgTWFjaGluZXMgQ29ycG9yYXRpb24xJDAiBgNVBAMTG0lCTSBDZXJ0
aWZpY2F0aW9uIEF1dGhvcml0eTAeFw0wMzExMjQxODI2NTRaFw0wNDEyMDcxODI2NTRaMIGFMQsw
CQYDVQQGEwJVUzEMMAoGA1UEChMDSUJNMREwDwYDVQQLEwhFTVBMT1lFRTEYMBYGA1UEAxMPRG9u
YWxkIEUuIFBheW5lMRkwFwYKCZImiZPyLGQBARMJNUE4NTEwODk3MSAwHgYJKoZIhvcNAQkBFhFw
YXluZWRAdXMuaWJtLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAm8rENcZDh8vvK2tJ
KF6jTG0gWb4GEFKVanjzmUI2G+xz4K3vpmOzkWaDSRy+2dPBwvgPyOiRbUxUpkc5MV/Sw+JvQmAm
ThcjLcsFQExyOinbuRhJEbfjIyUX7VfMcHfKhhnETuMAS/i2kDkrWHtaRnhJyyOsreT6/9lfdo8y
kBkCAwEAAaOBvTCBujARBglghkgBhvhCAQEEBAMCBaAwDgYDVR0PAQH/BAQDAgXgMB0GA1UdDgQW
BBQ/fh5x0wzpWEXd7SMDQ0u2PRkWxjAsBgNVHREEJTAjoCEGCisGAQQBgjcUAgOgEwwRcGF5bmVk
QHVzLmlibS5jb20wHwYDVR0jBBgwFoAUrlQOkuqoM6krJC3HyG8w3N7zSkAwJwYDVR0lBCAwHgYI
KwYBBQUHAwIGCCsGAQUFBwMDBggrBgEFBQcDBDANBgkqhkiG9w0BAQQFAAOBgQCTqqC2OdEUtbFy
Ahi6RlOrPwKt5+pcOe30y8Ze+ue7XOL95aVi5ACUuvL2vwnfmO+6M2kkFwqxKSA6PnCv6c7J8G7q
ERBA36GMIzhM+nlxhqVotknT1BNYn/Ui9U8kLTN9hj4LmiTGmNnt+j5qWnvGkC6oEZ2WWYgfzoNm
SZqmTTCCAyUwggKOoAMCAQICAwEUMjANBgkqhkiG9w0BAQQFADBpMQswCQYDVQQGEwJVUzE0MDIG
A1UEChMrSW50ZXJuYXRpb25hbCBCdXNpbmVzcyBNYWNoaW5lcyBDb3Jwb3JhdGlvbjEkMCIGA1UE
AxMbSUJNIENlcnRpZmljYXRpb24gQXV0aG9yaXR5MB4XDTAzMTEyNDE4MjY1NFoXDTA0MTIwNzE4
MjY1NFowgYUxCzAJBgNVBAYTAlVTMQwwCgYDVQQKEwNJQk0xETAPBgNVBAsTCEVNUExPWUVFMRgw
FgYDVQQDEw9Eb25hbGQgRS4gUGF5bmUxGTAXBgoJkiaJk/IsZAEBEwk1QTg1MTA4OTcxIDAeBgkq
hkiG9w0BCQEWEXBheW5lZEB1cy5pYm0uY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCb
ysQ1xkOHy+8ra0koXqNMbSBZvgYQUpVqePOZQjYb7HPgre+mY7ORZoNJHL7Z08HC+A/I6JFtTFSm
RzkxX9LD4m9CYCZOFyMtywVATHI6Kdu5GEkRt+MjJRftV8xwd8qGGcRO4wBL+LaQOStYe1pGeEnL
I6yt5Pr/2V92jzKQGQIDAQABo4G9MIG6MBEGCWCGSAGG+EIBAQQEAwIFoDAOBgNVHQ8BAf8EBAMC
BeAwHQYDVR0OBBYEFD9+HnHTDOlYRd3tIwNDS7Y9GRbGMCwGA1UdEQQlMCOgIQYKKwYBBAGCNxQC
A6ATDBFwYXluZWRAdXMuaWJtLmNvbTAfBgNVHSMEGDAWgBSuVA6S6qgzqSskLcfIbzDc3vNKQDAn
BgNVHSUEIDAeBggrBgEFBQcDAgYIKwYBBQUHAwMGCCsGAQUFBwMEMA0GCSqGSIb3DQEBBAUAA4GB
AJOqoLY50RS1sXICGLpGU6s/Aq3n6lw57fTLxl7657tc4v3lpWLkAJS68va/Cd+Y77ozaSQXCrEp
IDo+cK/pzsnwbuoREEDfoYwjOEz6eXGGpWi2SdPUE1if9SL1TyQtM32GPguaJMaY2e36Pmpae8aQ
LqgRnZZZiB/Og2ZJmqZNMYIBuzCCAbcCAQEwcDBpMQswCQYDVQQGEwJVUzE0MDIGA1UEChMrSW50
ZXJuYXRpb25hbCBCdXNpbmVzcyBNYWNoaW5lcyBDb3Jwb3JhdGlvbjEkMCIGA1UEAxMbSUJNIENl
cnRpZmljYXRpb24gQXV0aG9yaXR5AgMBFDIwCQYFKw4DAhoFAKCBojAYBgkqhkiG9w0BCQMxCwYJ
KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNDA0MjEyMjAyMDNaMCMGCSqGSIb3DQEJBDEWBBRv
ZvnR7aKQn7//oaU+hAkY38YYGTBDBgkqhkiG9w0BCQ8xNjA0MAcGBSsOAwIdMA4GCCqGSIb3DQMC
AgIAgDAKBggqhkiG9w0DBzANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAASBgETXDgNykplh
1sN5MGqncX2SkE1aHjyfhkU9kjxXtpwN4E+SVAHBRU1Wu6EVf1GqAfQ4RhQtgfZwl6prKDEgBwXB
SFs90R2cQ+p+nqNcV2hUnu4feXTs0dwyQlx3ssRze9fP+xjL519mCg8E15CqAYOfEAPvSE77uWEI
2tTtoZxWAAAAAA==

---------z54136_boundary_sign--

Messages In This Thread

• How to search argument into webpages table.
  AQUILES LORANCA SANCHEZ -- Wednesday, 21 April 2004, at 12:00 p.m.
  • Re: How to search argument into webpages table.
    Donald Payne -- Wednesday, 21 April 2004, at 6:04 p.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.