Re: [WebDNA] Data Type Bool
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103139
interpreted = N
texte = This is a cryptographically signed message in MIME format.--------------ms060608070609020008090000Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: 7bitOr like so:
[search [instock] stuff sorted by SKU] [founditems] - [item fields]
[/founditems][/search][search NOT [instock] stuff sorted by something else] [founditems] - [item fields]
[/founditems][/search]
Marc Thompson wrote:> Ki,> Since what you want is essentially 2 different result sets, why not> break it into 2 separate searches? That way you can control the sorting> on each individually...> > Marc> > Ki Song - Knifecenter.com wrote:>> Essentially, we want our product listing page to do the following:>>>> Group all the items that are in stock first, out of stock second.>> Within the in stock items, we want to sort by SKU.>>>> Right now, since in stock is the actual number in stock, it is sorting>> by actual number, not just by what is in stock and not in stock.>>>> ----------->> Ki Song>>>> On Tue, Aug 4, 2009 at 2:13 PM, Govinda
> > wrote:>>>> Ki,>>>> I don't think so.>>>> But with webdna you don't need it either. If you are not able to do>> what you want, then post the problem, someone will surely guide you>> to the solution.>>>>>> On Aug 4, 2009, at 12:07 PM, Ki Song - Knifecenter.com wrote:>>>> Is something like this possible in a search context:>>>> &asSKUsort=2&deON HANDsort=1&ON HANDtype=bool>>>> Can a data type be type boolean in a search context?>>>> ----------->> Ki Song>>>>>> ------------>> John Butler (Govinda)>> govinda.webdnatalk@gmail.com >>>>>>>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list >.>> To unsubscribe, E-mail to: > >>> archives: http://mail.webdna.us/list/talk@webdna.us>> old archives: http://dev.webdna.us/TalkListArchive/>>>>> -- -------------------------------------------Marc ThompsonSoftware EngineerOffice of Information TechnologyUniversity of Utah801.585.9264marc.thompson@utah.edu---------------------------------------------------------ms060608070609020008090000Content-Type: application/x-pkcs7-signature; name="smime.p7s"Content-Transfer-Encoding: base64Content-Disposition: attachment; filename="smime.p7s"Content-Description: S/MIME Cryptographic SignatureMIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIyTCCAr8wggIooAMCAQICEBsJjtdroK6bD6QFOjpu3bIwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDIyMzE5MzkyNVoXDTEwMDIyMzE5MzkyNVowgYoxETAPBgNVBAQTCFRob21wc29uMQ0wCwYDVQQqEwRNYXJjMRYwFAYDVQQDEw1NYXJjIFRob21wc29uMScwJQYJKoZIhvcNAQkBFhhtdGhvbXBzb25AbWVkaWEudXRhaC5lZHUxJTAjBgkqhkiG9w0BCQEWFm1hcmMudGhvbXBzb25AdXRhaC5lZHUwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAM59JRdQxO5rxD9dkmKAk/FobjsVKTA+u4e8lYfiMt3ZRIpBx5JX3h9h7j2JCZDPbB5s/jxg+DoL4oyL8nRZ5WI03nkWsizq4LzvPCudQjos5hflS+7sQNBUHJoUtQ+hX0vp4QmRs7qDlZ+zB3SgBz8YGOcQm1uDf++BS7wv89VFAgMBAAGjTTBLMDsGA1UdEQQ0MDKBGG10aG9tcHNvbkBtZWRpYS51dGFoLmVkdYEWbWFyYy50aG9tcHNvbkB1dGFoLmVkdTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAC8toPH9c2T1yBdVk/3XP3xeXtECE1Kin0w50pjBajicub5R6pz9jc+NhlpNPmcqVj3VVimTyFeFY97p3BrcjW3qPFp/KM5OabdIz4gLDT0aMzdjI0qo59DolQGSlPxRPU6RqMJRIJ0X75EhDhCgpDWy7UtVPInv5T4rAkLPskeBMIICvzCCAiigAwIBAgIQGwmO12ugrpsPpAU6Om7dsjANBgkqhkiG9w0BAQUFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDkwMjIzMTkzOTI1WhcNMTAwMjIzMTkzOTI1WjCBijERMA8GA1UEBBMIVGhvbXBzb24xDTALBgNVBCoTBE1hcmMxFjAUBgNVBAMTDU1hcmMgVGhvbXBzb24xJzAlBgkqhkiG9w0BCQEWGG10aG9tcHNvbkBtZWRpYS51dGFoLmVkdTElMCMGCSqGSIb3DQEJARYWbWFyYy50aG9tcHNvbkB1dGFoLmVkdTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAzn0lF1DE7mvEP12SYoCT8WhuOxUpMD67h7yVh+Iy3dlEikHHklfeH2HuPYkJkM9sHmz+PGD4OgvijIvydFnlYjTeeRayLOrgvO88K51COizmF+VL7uxA0FQcmhS1D6FfS+nhCZGzuoOVn7MHdKAHPxgY5xCbW4N/74FLvC/z1UUCAwEAAaNNMEswOwYDVR0RBDQwMoEYbXRob21wc29uQG1lZGlhLnV0YWguZWR1gRZtYXJjLnRob21wc29uQHV0YWguZWR1MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEALy2g8f1zZPXIF1WT/dc/fF5e0QITUqKfTDnSmMFqOJy5vlHqnP2Nz42GWk0+ZypWPdVWKZPIV4Vj3uncGtyNbeo8Wn8ozk5pt0jPiAsNPRozN2MjSqjn0OiVAZKU/FE9TpGowlEgnRfvkSEOEKCkNbLtS1U8ie/lPisCQs+yR4EwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIC4zCCAt8CAQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBsJjtdroK6bD6QFOjpu3bIwCQYFKw4DAhoFAKCCAcMwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDkwODA1MTYzNDEyWjAjBgkqhkiG9w0BCQQxFgQU1qm4Y+Fz5RHVirtC1GgC3HUkpZswUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAbCY7Xa6Cumw+kBTo6bt2yMIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAbCY7Xa6Cumw+kBTo6bt2yMA0GCSqGSIb3DQEBAQUABIGAmZlNWR2Wuc0gYe6XZJuc6LgOXnRar/Jmux9ptrWfJet6M8r94waMGaBcldxUS9hijlxzkjUvolNT6PCVSv/TCssavQpe8ItGII4MlUSF17kaxRHmqyoppTsrTABk93G6sQhVG9l8VSfj1vpsI2fK5pDJbp38ViQ/yc0EGvby1f0AAAAAAAA=--------------ms060608070609020008090000--
Associated Messages, from the most recent to the oldest:
This is a cryptographically signed message in MIME format.--------------ms060608070609020008090000Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: 7bitOr like so: [search [instock] stuff sorted by SKU] [founditems] - [item fields]
[/founditems][/search][search NOT [instock] stuff sorted by something else] [founditems] - [item fields]
[/founditems][/search]
Marc Thompson wrote:> Ki,> Since what you want is essentially 2 different result sets, why not> break it into 2 separate searches? That way you can control the sorting> on each individually...> > Marc> > Ki Song - Knifecenter.com wrote:>> Essentially, we want our product listing page to do the following:>>>> Group all the items that are in stock first, out of stock second.>> Within the in stock items, we want to sort by SKU.>>>> Right now, since in stock is the actual number in stock, it is sorting>> by actual number, not just by what is in stock and not in stock.>>>> ----------->> Ki Song>>>> On Tue, Aug 4, 2009 at 2:13 PM, Govinda > > wrote:>>>> Ki,>>>> I don't think so.>>>> But with webdna you don't need it either. If you are not able to do>> what you want, then post the problem, someone will surely guide you>> to the solution.>>>>>> On Aug 4, 2009, at 12:07 PM, Ki Song - Knifecenter.com wrote:>>>> Is something like this possible in a search context:>>>> &asSKUsort=2&deON HANDsort=1&ON HANDtype=bool>>>> Can a data type be type boolean in a search context?>>>> ----------->> Ki Song>>>>>> ------------>> John Butler (Govinda)>> govinda.webdnatalk@gmail.com >>>>>>>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list >.>> To unsubscribe, E-mail to: > >>> archives: http://mail.webdna.us/list/talk@webdna.us>> old archives: http://dev.webdna.us/TalkListArchive/>>>>> -- -------------------------------------------Marc ThompsonSoftware EngineerOffice of Information TechnologyUniversity of Utah801.585.9264marc.thompson@utah.edu---------------------------------------------------------ms060608070609020008090000Content-Type: application/x-pkcs7-signature; name="smime.p7s"Content-Transfer-Encoding: base64Content-Disposition: attachment; filename="smime.p7s"Content-Description: S/MIME Cryptographic SignatureMIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIyTCCAr8wggIooAMCAQICEBsJjtdroK6bD6QFOjpu3bIwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA5MDIyMzE5MzkyNVoXDTEwMDIyMzE5MzkyNVowgYoxETAPBgNVBAQTCFRob21wc29uMQ0wCwYDVQQqEwRNYXJjMRYwFAYDVQQDEw1NYXJjIFRob21wc29uMScwJQYJKoZIhvcNAQkBFhhtdGhvbXBzb25AbWVkaWEudXRhaC5lZHUxJTAjBgkqhkiG9w0BCQEWFm1hcmMudGhvbXBzb25AdXRhaC5lZHUwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAM59JRdQxO5rxD9dkmKAk/FobjsVKTA+u4e8lYfiMt3ZRIpBx5JX3h9h7j2JCZDPbB5s/jxg+DoL4oyL8nRZ5WI03nkWsizq4LzvPCudQjos5hflS+7sQNBUHJoUtQ+hX0vp4QmRs7qDlZ+zB3SgBz8YGOcQm1uDf++BS7wv89VFAgMBAAGjTTBLMDsGA1UdEQQ0MDKBGG10aG9tcHNvbkBtZWRpYS51dGFoLmVkdYEWbWFyYy50aG9tcHNvbkB1dGFoLmVkdTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAC8toPH9c2T1yBdVk/3XP3xeXtECE1Kin0w50pjBajicub5R6pz9jc+NhlpNPmcqVj3VVimTyFeFY97p3BrcjW3qPFp/KM5OabdIz4gLDT0aMzdjI0qo59DolQGSlPxRPU6RqMJRIJ0X75EhDhCgpDWy7UtVPInv5T4rAkLPskeBMIICvzCCAiigAwIBAgIQGwmO12ugrpsPpAU6Om7dsjANBgkqhkiG9w0BAQUFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDkwMjIzMTkzOTI1WhcNMTAwMjIzMTkzOTI1WjCBijERMA8GA1UEBBMIVGhvbXBzb24xDTALBgNVBCoTBE1hcmMxFjAUBgNVBAMTDU1hcmMgVGhvbXBzb24xJzAlBgkqhkiG9w0BCQEWGG10aG9tcHNvbkBtZWRpYS51dGFoLmVkdTElMCMGCSqGSIb3DQEJARYWbWFyYy50aG9tcHNvbkB1dGFoLmVkdTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAzn0lF1DE7mvEP12SYoCT8WhuOxUpMD67h7yVh+Iy3dlEikHHklfeH2HuPYkJkM9sHmz+PGD4OgvijIvydFnlYjTeeRayLOrgvO88K51COizmF+VL7uxA0FQcmhS1D6FfS+nhCZGzuoOVn7MHdKAHPxgY5xCbW4N/74FLvC/z1UUCAwEAAaNNMEswOwYDVR0RBDQwMoEYbXRob21wc29uQG1lZGlhLnV0YWguZWR1gRZtYXJjLnRob21wc29uQHV0YWguZWR1MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEALy2g8f1zZPXIF1WT/dc/fF5e0QITUqKfTDnSmMFqOJy5vlHqnP2Nz42GWk0+ZypWPdVWKZPIV4Vj3uncGtyNbeo8Wn8ozk5pt0jPiAsNPRozN2MjSqjn0OiVAZKU/FE9TpGowlEgnRfvkSEOEKCkNbLtS1U8ie/lPisCQs+yR4EwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIC4zCCAt8CAQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBsJjtdroK6bD6QFOjpu3bIwCQYFKw4DAhoFAKCCAcMwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDkwODA1MTYzNDEyWjAjBgkqhkiG9w0BCQQxFgQU1qm4Y+Fz5RHVirtC1GgC3HUkpZswUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAbCY7Xa6Cumw+kBTo6bt2yMIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAbCY7Xa6Cumw+kBTo6bt2yMA0GCSqGSIb3DQEBAQUABIGAmZlNWR2Wuc0gYe6XZJuc6LgOXnRar/Jmux9ptrWfJet6M8r94waMGaBcldxUS9hijlxzkjUvolNT6PCVSv/TCssavQpe8ItGII4MlUSF17kaxRHmqyoppTsrTABk93G6sQhVG9l8VSfj1vpsI2fK5pDJbp38ViQ/yc0EGvby1f0AAAAAAAA=--------------ms060608070609020008090000--
Marc Thompson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCat2.0 [format thousands .0f] no go (1997)
PSC recommends what date format yr 2000??? (1997)
WebDNA Windows 5.0 sendmail bug (2003)
Problem (1997)
RE: ShowNext Command (1997)
[subTotal] pricefield in another database It#180#s not working!? (1998)
FW: Answer this JCPenney survey for $ 500 ... . : : (2006)
problems with 2 tags (1997)
PCS Frames (1997)
RE: type 2 errors with ssl server (1997)
IRC Channel (2003)
[sqlexecute] and ; (2005)
Repeating Fields (1997)
WebCat2 several catalogs? (1997)
BIAP relay (1999)
Timeout question .. (2003)
[WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016)
Running 2 two WebCatalog.acgi's (1996)
Execute Applescript (1997)
Showif for mulitple variations (1997)