[Zope] Z SQL Method: Error in select with limit (mysql)

Tue, 20 May 2003 11:03:10 +0200

This is a cryptographically signed message in MIME format.

--------------ms090006040807060902060707
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type"
 content="text/html;charset=ISO-8859-15">
  <title></title>
</head>
<body>
<div class="moz-text-html" lang="x-western"> hello,<br>
<br>
<blockquote type="cite" cite="mid3EC9D46F.7070302@truckport.de"><strong>Error
Value: (1064, "You have an error in your SQL syntax near 'LIMIT 1000'
at line 1")</strong></blockquote>
<br>
set maximum rows to retrieve = 0.<br>
<br>
ciao...Patrick<br>
<br>
</div>
</body>
</html>

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

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIHsjCC
A9UwggM+oAMCAQICDnqhAAAAAqRtHofONAn9MA0GCSqGSIb3DQEBBAUAMIG8MQswCQYDVQQG
EwJERTEQMA4GA1UECBMHSGFtYnVyZzEQMA4GA1UEBxMHSGFtYnVyZzE6MDgGA1UEChMxVEMg
VHJ1c3RDZW50ZXIgZm9yIFNlY3VyaXR5IGluIERhdGEgTmV0d29ya3MgR21iSDEiMCAGA1UE
CxMZVEMgVHJ1c3RDZW50ZXIgQ2xhc3MgMSBDQTEpMCcGCSqGSIb3DQEJARYaY2VydGlmaWNh
dGVAdHJ1c3RjZW50ZXIuZGUwHhcNMDMwNTEyMTM0MDUxWhcNMDQwNTEyMTM0MDUxWjBIMQsw
CQYDVQQGEwJERTEWMBQGA1UEAxMNUGF0cmljayBVbG1lcjEhMB8GCSqGSIb3DQEJARYSdWxt
ZXJAdHJ1Y2twb3J0LmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0Nv9wkem
Bs1Ri/OZBAoDDHDq4DwoUBUqXsyoSiGBJEZwaG8BHW3Pl75qZmb1b/9oMcUevbw9CnKFAJB0
ujInSUhHnXH4ncnc/Zkispq3ra90TtgsUXpA7NEc0uut4dnI28LlH21rtYB53/1UHQAAZkk3
aK2EvMS0RYLshMLTOLLI5kbZjjMYaILIKRLHsLCPRTV7wQYHaQTp4M2RHFy6NWgWzaaY35PP
2hlOC3/QfycSsh0Hkh297rZytI71CvVklxQ5HHsluawRnUsB/uh98NZ57qTa32+4eZatbqfy
NEYsGSdlSdnrg4lnBg07Eq+6XXkb8H/YKWm47t6NBahZSwIDAQABo4HIMIHFMAwGA1UdEwEB
/wQCMAAwDgYDVR0PAQH/BAQDAgXgMDMGCWCGSAGG+EIBCAQmFiRodHRwOi8vd3d3LnRydXN0
Y2VudGVyLmRlL2d1aWRlbGluZXMwEQYJYIZIAYb4QgEBBAQDAgWgMF0GCWCGSAGG+EIBAwRQ
Fk5odHRwczovL3d3dy50cnVzdGNlbnRlci5kZS9jZ2ktYmluL2NoZWNrLXJldi5jZ2kvN0FB
MTAwMDAwMDAyQTQ2RDFFODdDRTM0MDlGRD8wDQYJKoZIhvcNAQEEBQADgYEAI2PbLf0Vnmo0
bmNAVEbw6G5wSjyBoL742nU7L/Yst0u128Qedmwi7GDVIkfZmVrQNDecsXgaJKbUyw1ucolj
fG1mwmTXhd26WaZyD2ZaCbg+hlbOgFiS+diFtq3NFGvhV/QCJxdtrUUr17I5WMK/IgniIoiG
4N7pQiY1JS2UZrEwggPVMIIDPqADAgECAg56oQAAAAKkbR6HzjQJ/TANBgkqhkiG9w0BAQQF
ADCBvDELMAkGA1UEBhMCREUxEDAOBgNVBAgTB0hhbWJ1cmcxEDAOBgNVBAcTB0hhbWJ1cmcx
OjA4BgNVBAoTMVRDIFRydXN0Q2VudGVyIGZvciBTZWN1cml0eSBpbiBEYXRhIE5ldHdvcmtz
IEdtYkgxIjAgBgNVBAsTGVRDIFRydXN0Q2VudGVyIENsYXNzIDEgQ0ExKTAnBgkqhkiG9w0B
CQEWGmNlcnRpZmljYXRlQHRydXN0Y2VudGVyLmRlMB4XDTAzMDUxMjEzNDA1MVoXDTA0MDUx
MjEzNDA1MVowSDELMAkGA1UEBhMCREUxFjAUBgNVBAMTDVBhdHJpY2sgVWxtZXIxITAfBgkq
hkiG9w0BCQEWEnVsbWVyQHRydWNrcG9ydC5kZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCC
AQoCggEBANDb/cJHpgbNUYvzmQQKAwxw6uA8KFAVKl7MqEohgSRGcGhvAR1tz5e+amZm9W//
aDHFHr28PQpyhQCQdLoyJ0lIR51x+J3J3P2ZIrKat62vdE7YLFF6QOzRHNLrreHZyNvC5R9t
a7WAed/9VB0AAGZJN2ithLzEtEWC7ITC0ziyyOZG2Y4zGGiCyCkSx7Cwj0U1e8EGB2kE6eDN
kRxcujVoFs2mmN+Tz9oZTgt/0H8nErIdB5Idve62crSO9Qr1ZJcUORx7JbmsEZ1LAf7offDW
ee6k2t9vuHmWrW6n8jRGLBknZUnZ64OJZwYNOxKvul15G/B/2ClpuO7ejQWoWUsCAwEAAaOB
yDCBxTAMBgNVHRMBAf8EAjAAMA4GA1UdDwEB/wQEAwIF4DAzBglghkgBhvhCAQgEJhYkaHR0
cDovL3d3dy50cnVzdGNlbnRlci5kZS9ndWlkZWxpbmVzMBEGCWCGSAGG+EIBAQQEAwIFoDBd
BglghkgBhvhCAQMEUBZOaHR0cHM6Ly93d3cudHJ1c3RjZW50ZXIuZGUvY2dpLWJpbi9jaGVj
ay1yZXYuY2dpLzdBQTEwMDAwMDAwMkE0NkQxRTg3Q0UzNDA5RkQ/MA0GCSqGSIb3DQEBBAUA
A4GBACNj2y39FZ5qNG5jQFRG8OhucEo8gaC++Np1Oy/2LLdLtdvEHnZsIuxg1SJH2Zla0DQ3
nLF4GiSm1MsNbnKJY3xtZsJk14Xdulmmcg9mWgm4PoZWzoBYkvnYhbatzRRr4Vf0AicXba1F
K9eyOVjCvyIJ4iKIhuDe6UImNSUtlGaxMYIEdDCCBHACAQEwgc8wgbwxCzAJBgNVBAYTAkRF
MRAwDgYDVQQIEwdIYW1idXJnMRAwDgYDVQQHEwdIYW1idXJnMTowOAYDVQQKEzFUQyBUcnVz
dENlbnRlciBmb3IgU2VjdXJpdHkgaW4gRGF0YSBOZXR3b3JrcyBHbWJIMSIwIAYDVQQLExlU
QyBUcnVzdENlbnRlciBDbGFzcyAxIENBMSkwJwYJKoZIhvcNAQkBFhpjZXJ0aWZpY2F0ZUB0
cnVzdGNlbnRlci5kZQIOeqEAAAACpG0eh840Cf0wCQYFKw4DAhoFAKCCAnkwGAYJKoZIhvcN
AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDMwNTIwMDkwMzEwWjAjBgkqhkiG
9w0BCQQxFgQUL6Yit1+lZORVWHAKC4KUOa9gKe4wUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG
9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcN
AwICASgwgeAGCSsGAQQBgjcQBDGB0jCBzzCBvDELMAkGA1UEBhMCREUxEDAOBgNVBAgTB0hh
bWJ1cmcxEDAOBgNVBAcTB0hhbWJ1cmcxOjA4BgNVBAoTMVRDIFRydXN0Q2VudGVyIGZvciBT
ZWN1cml0eSBpbiBEYXRhIE5ldHdvcmtzIEdtYkgxIjAgBgNVBAsTGVRDIFRydXN0Q2VudGVy
IENsYXNzIDEgQ0ExKTAnBgkqhkiG9w0BCQEWGmNlcnRpZmljYXRlQHRydXN0Y2VudGVyLmRl
Ag56oQAAAAKkbR6HzjQJ/TCB4gYLKoZIhvcNAQkQAgsxgdKggc8wgbwxCzAJBgNVBAYTAkRF
MRAwDgYDVQQIEwdIYW1idXJnMRAwDgYDVQQHEwdIYW1idXJnMTowOAYDVQQKEzFUQyBUcnVz
dENlbnRlciBmb3IgU2VjdXJpdHkgaW4gRGF0YSBOZXR3b3JrcyBHbWJIMSIwIAYDVQQLExlU
QyBUcnVzdENlbnRlciBDbGFzcyAxIENBMSkwJwYJKoZIhvcNAQkBFhpjZXJ0aWZpY2F0ZUB0
cnVzdGNlbnRlci5kZQIOeqEAAAACpG0eh840Cf0wDQYJKoZIhvcNAQEBBQAEggEAKuSlstX7
tk+a1W9VSy4PTSL/avQ8TclRUDp9QMNd/Vsn1cCj2uhtOp0UmxM9Hbd4JHAkhttvNVMC7gm8
X/HxuTAUBrNlj61hqVw38nF9x/oWvGBLIxD0geQSaeZwKMuCpX1f9Xp8kTYl4fHdS5LC3xQM
dPxr6yIeOVI0A+FGl81DfjT7KbugmkqSeEsU6RKjTmjqmyYjAiLR1s1QFPP8lhfjuZ3+0Ade
WDAfNDRrsa17yb2c6eOCFoNtaelrW7hU8musSW3xqWO/MkwukFLvGlPPOdEJgqOfm4weoDjT
VaCx+CperSp1+AziCC7XLO/3AmwIcXzzhv9BVRAUnS2jWwAAAAAAAA==
--------------ms090006040807060902060707--