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

Tue, 20 May 2003 09:08:31 +0200

This is a cryptographically signed message in MIME format.

--------------ms080909000603050407000409
Content-Type: text/html; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv=3D"Content-Type"
 content=3D"text/html;charset=3DISO-8859-15">
  <title></title>
</head>
<body>
hello,<br>
<br>
the select-statement for mysql i used in a "Z SQL Method"-object<br>
<br>
=A0 select gruppe as art from test order by gruppe limit 0, 1<br>
<br>
produce the following errormessage<br>
<br>
<strong>=A0 Error Value: (1064, "You have an error in your SQL syntax
near 'LIMIT 1000' at line 1")</strong><br>
<br>
why?<br>
<br>
thanks...patrick<br>
<br>
</body>
</html>

--------------ms080909000603050407000409
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
AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDMwNTIwMDcwODMxWjAjBgkqhkiG
9w0BCQQxFgQUoxiA0eLE8cCD2wKy3B9kHQjfde8wUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG
9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcN
AwICASgwgeAGCSsGAQQBgjcQBDGB0jCBzzCBvDELMAkGA1UEBhMCREUxEDAOBgNVBAgTB0hh
bWJ1cmcxEDAOBgNVBAcTB0hhbWJ1cmcxOjA4BgNVBAoTMVRDIFRydXN0Q2VudGVyIGZvciBT
ZWN1cml0eSBpbiBEYXRhIE5ldHdvcmtzIEdtYkgxIjAgBgNVBAsTGVRDIFRydXN0Q2VudGVy
IENsYXNzIDEgQ0ExKTAnBgkqhkiG9w0BCQEWGmNlcnRpZmljYXRlQHRydXN0Y2VudGVyLmRl
Ag56oQAAAAKkbR6HzjQJ/TCB4gYLKoZIhvcNAQkQAgsxgdKggc8wgbwxCzAJBgNVBAYTAkRF
MRAwDgYDVQQIEwdIYW1idXJnMRAwDgYDVQQHEwdIYW1idXJnMTowOAYDVQQKEzFUQyBUcnVz
dENlbnRlciBmb3IgU2VjdXJpdHkgaW4gRGF0YSBOZXR3b3JrcyBHbWJIMSIwIAYDVQQLExlU
QyBUcnVzdENlbnRlciBDbGFzcyAxIENBMSkwJwYJKoZIhvcNAQkBFhpjZXJ0aWZpY2F0ZUB0
cnVzdGNlbnRlci5kZQIOeqEAAAACpG0eh840Cf0wDQYJKoZIhvcNAQEBBQAEggEAfIxS9yfA
rT5EN5BAkIyl0aSbQEg1Bvs1IL1+x5GPpyqtvJZ9yiURA3WD4Fn+kOYthvo4pJ95Epz1dXEo
CjaPw7N77HruLXsjf66u7liSMY8IOjOgGn/YAVMAT8f4KxU9wpME09HNmO5G8j3KrLj+nfYN
c86JJ2W9MtvnZYnqEXrFlDR8gL8Gt5wSiO+gJjB8HVcq54z2HJLfxXn377KZXUt0Eb1GnMSl
Yxqk7o+Tu7VDbSOXvuiL1L10OinAZNmdwMONQmtbyag7sbl8o5PFOeDjIMAttPKgTA1a3CGF
olaDGa6BMa56sM1hUzBYHygH8MhSX9ojO+ID+eDaMkaW4QAAAAAAAA==
--------------ms080909000603050407000409--