Re: [WebDNA] Data Type Bool
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103136
interpreted = N
texte = --Apple-Mail-5-596668561 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Terry & Ki, I don't think that will work because [instock] is only evaluated within the [founditems] loop You need: [search stuff...] [founditems] [hideif [instock]] [item fields] [/hideif] [/founditems] [/search] BOOL is a really cool part of WebDNA. Anything greater than zero is true and anything 0 or less is false. That means that even random strings of text are, technically true. You need to avoid bad code practice, but there are some really clever and graceful things you can do. Be aware that something like [showif [instock]=1] is the same as [showif [instock]] as long as [instock] is greater than zero when an item is actually in stock. It helps make the code a little bit more readable, too. On Aug 4, 2009, at 1:39 PM, Terry Wilson wrote: > So you would have two founditems loops within your search: > > [search stuff...] > > [hideif [instock]=0] > [founditems] > ... > [/founditems] > [/hideif] > > [showif [instock]=0] > [founditems] > ... > [/founditems] > [/showif] > > [/search] > > (sort by sku, not instock) > > Terry > > 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 <
>govinda.webdnatalk@gmail.com> 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 <talk@webdna.us>. > To unsubscribe, E-mail to: <talk-leave@webdna.us > > > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > > > -- > Terry Wilson | terry@terryfic.com | http://terryfic.com > http://WhosComing.com - a simplified, affordable online reservation > system > http://TightJacket.com -- stylish protection for your laptop > -------------------------------------------------------------------------- > Attitude is the only difference between ordeal and adventure. > --------------------------------------------------------- > 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/ --Apple-Mail-5-596668561 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIw ggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1 M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1A d2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/ qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pH NjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeI gIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q 9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppw yX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/ BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5 n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn 2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJ KoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNV BAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRp ZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVl bWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0w MzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3 dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjA dQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn 8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sC AwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9j cmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjAp BgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQAD gYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6 GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341Yh eILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU aGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJl ZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wOTA4MDUxNTQwMDhaMCMGCSqGSIb3 DQEJBDEWBBSDAsr0g10z6Nw9oSCFvawrNU7+YDCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqG SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EC EBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAVGV8wER0gHhU3VC0KXWcXAb8nJJG HMSmGtWck+ZJaF0XMAqm6oNPYiD8kKzmc1FqEY+yqP7EJ9dEex9F544oHQ7U0kfIiSlL5VuC19Tg pKbytmzNEIaf4QzkR8Lq1seQ+RO1GS0gd2h1swaE7f45bnS4elJAY7yZgp6eH9hc94HWdzzI0pyR 7cjwVheaRrgQ/3ph/7nVVzWsqD2YmRzwtkeNBm2dxfEgLNRmwqZ3x8w+FHjxr9yDDKyHlTpt3G0x Bnf83YmleUC97FcLRRrcVTyrxoLvVNDOhPzUDpDnWlLfG9SFRwIgHr59L/2LCP5DASOXYthRXb1C bXXv9NqyDgAAAAAAAA== --Apple-Mail-5-596668561--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-5-596668561 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Terry & Ki, I don't think that will work because [instock] is only evaluated within the [founditems] loop You need: [search stuff...] [founditems] [hideif [instock]] [item fields] [/hideif] [/founditems] [/search] BOOL is a really cool part of WebDNA. Anything greater than zero is true and anything 0 or less is false. That means that even random strings of text are, technically true. You need to avoid bad code practice, but there are some really clever and graceful things you can do. Be aware that something like [showif [instock]=1] is the same as [showif [instock]] as long as [instock] is greater than zero when an item is actually in stock. It helps make the code a little bit more readable, too. On Aug 4, 2009, at 1:39 PM, Terry Wilson wrote: > So you would have two founditems loops within your search: > > [search stuff...] > > [hideif [instock]=0] > [founditems] > ... > [/founditems] > [/hideif] > > [showif [instock]=0] > [founditems] > ... > [/founditems] > [/showif] > > [/search] > > (sort by sku, not instock) > > Terry > > 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 < >govinda.webdnatalk@gmail.com> 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 <talk@webdna.us>. > To unsubscribe, E-mail to: <talk-leave@webdna.us > > > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > > > -- > Terry Wilson | terry@terryfic.com | http://terryfic.com > http://WhosComing.com - a simplified, affordable online reservation > system > http://TightJacket.com -- stylish protection for your laptop > -------------------------------------------------------------------------- > Attitude is the only difference between ordeal and adventure. > --------------------------------------------------------- > 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/ --Apple-Mail-5-596668561 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIw ggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1 M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1A d2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/ qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pH NjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeI gIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q 9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppw yX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/ BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5 n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn 2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJ KoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNV BAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRp ZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVl bWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0w MzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3 dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjA dQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn 8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sC AwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9j cmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjAp BgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQAD gYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6 GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341Yh eILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU aGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJl ZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wOTA4MDUxNTQwMDhaMCMGCSqGSIb3 DQEJBDEWBBSDAsr0g10z6Nw9oSCFvawrNU7+YDCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqG SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EC EBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAVGV8wER0gHhU3VC0KXWcXAb8nJJG HMSmGtWck+ZJaF0XMAqm6oNPYiD8kKzmc1FqEY+yqP7EJ9dEex9F544oHQ7U0kfIiSlL5VuC19Tg pKbytmzNEIaf4QzkR8Lq1seQ+RO1GS0gd2h1swaE7f45bnS4elJAY7yZgp6eH9hc94HWdzzI0pyR 7cjwVheaRrgQ/3ph/7nVVzWsqD2YmRzwtkeNBm2dxfEgLNRmwqZ3x8w+FHjxr9yDDKyHlTpt3G0x Bnf83YmleUC97FcLRRrcVTyrxoLvVNDOhPzUDpDnWlLfG9SFRwIgHr59L/2LCP5DASOXYthRXb1C bXXv9NqyDgAAAAAAAA== --Apple-Mail-5-596668561--
Patrick McCormick
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:
Webcat causing crashes left and right! (1997)
Message Board (again:-) (2000)
Authenticate (1997)
Open Databases on Restart (1999)
Sitebuilder (2004)
Webcat Manual and TeaRoom Examples Uses Different Examples. (1997)
sendmail error (1997)
Browser Resolution (1999)
WebMerchant does anybody really understand the process? (2000)
all records returned. (1997)
Server capacity (2003)
Frames and WebCat (1997)
Single Link browsing (1997)
WebCat2 - many [carts] on one template page? (1997)
searchable list archive (1997)
Mac v. NT (1998)
PC Auth Hub+Merchant (1998)
search results not sorted with 'cl' (1998)
How to Display text in empty fields (1997)
WebCat2 several catalogs? (1997)