[Zope-DB] Hello!

[Philip Kilner]

This is a cryptographically signed message in MIME format.

--------------ms070101000707030704060803
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi List,

Philip Kilner wrote:

> - How do I call the "insertBook" ZSQL method from within a ZPT?
> 
> - Do I have to do anything special to map my field names to the 
> parameters that the ZSQl expects?
> 
> (I've written this partly as a test of whether I understand it myself - 
> I'll fire the email off and go RTFM now!)
> 

OK - have now read up on Form Processing in AvZPT in the Zope book.

Looks like the answer to my first question is "Write a Pythion script to 
call the ZSQL, and call this script from the ZPT". I can suss the ZPT 
syntax from the Zope Book- can anyone point me to a good example of 
Python calling ZSQL?

Thanks!

-- 

Regards,

PhilK

Email: phil@xfr.co.uk / Voicemail & Facsimile: 07092 070518

"As we enjoy great advantages from inventions of others,
we should be glad of an opportunity to serve others by
any invention of ours; and this we should do freely and
generously." - Benjamin Franklin


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

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJODCC
AvowggJjoAMCAQICAwooUTANBgkqhkiG9w0BAQQFADCBkjELMAkGA1UEBhMCWkExFTATBgNV
BAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3dGUx
HTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBGcmVl
bWFpbCBSU0EgMjAwMC44LjMwMB4XDTAzMDYxNjA3MzkyM1oXDTA0MDYxNTA3MzkyM1owQDEf
MB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEdMBsGCSqGSIb3DQEJARYOcGhpbEB4
ZnIuY28udWswggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDw9rPq2LqjEfbjxtON
sAVT+eUpsxcgLrNFqXJ6VtxQQGe5rY92R0NVgMywHcuXmvYajhVaJeEBHbv+NxuiHXE0Boi7
oeY4VorWJcnq1ae7ovZQNG/+n3Q89uy3K8UrRcjuyqY33MN1KUsACTHOTnQK0UJ7SMOg8u+c
yEgHpeEbmCzDW8bAJhdGX9L/HBoaLZctGtNz5jAMiMnhaFSexYBPXGz6WM+MvOBza4ynLANo
b7gi1zUMv9IwvjU51XS79CKY+BE+HPulyGbJxwQzoaHsSZbeVNVupUbv/9Mf02uDs0Sol8tY
v9Yr67eVl4GWPFQpgK72IrUYdU5ETVj0g0drAgMBAAGjKzApMBkGA1UdEQQSMBCBDnBoaWxA
eGZyLmNvLnVrMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAEIN6bNl9y0cN2b2Z
br0Iyutbvzuu2sA+lR3tKITDdLq8/JCzYDTavzElClNLk9rP+Dwvw1DPBi6tXkQd3fuQMp0K
rFc7XwIpnPwJKkAF+woCcfTo5zm8xm3MqxvoTm40s3rBZt3D7Kfd73GfGf8l66iNM3ykCXya
TXYGOx0bvzswggL6MIICY6ADAgECAgMKKFEwDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYT
AlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UE
ChMGVGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVy
c29uYWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMDAeFw0wMzA2MTYwNzM5MjNaFw0wNDA2MTUw
NzM5MjNaMEAxHzAdBgNVBAMTFlRoYXd0ZSBGcmVlbWFpbCBNZW1iZXIxHTAbBgkqhkiG9w0B
CQEWDnBoaWxAeGZyLmNvLnVrMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA8Paz
6ti6oxH248bTjbAFU/nlKbMXIC6zRalyelbcUEBnua2PdkdDVYDMsB3Ll5r2Go4VWiXhAR27
/jcboh1xNAaIu6HmOFaK1iXJ6tWnu6L2UDRv/p90PPbstyvFK0XI7sqmN9zDdSlLAAkxzk50
CtFCe0jDoPLvnMhIB6XhG5gsw1vGwCYXRl/S/xwaGi2XLRrTc+YwDIjJ4WhUnsWAT1xs+ljP
jLzgc2uMpywDaG+4Itc1DL/SML41OdV0u/QimPgRPhz7pchmyccEM6Gh7EmW3lTVbqVG7//T
H9Nrg7NEqJfLWL/WK+u3lZeBljxUKYCu9iK1GHVORE1Y9INHawIDAQABoyswKTAZBgNVHREE
EjAQgQ5waGlsQHhmci5jby51azAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBAUAA4GBABCD
emzZfctHDdm9mW69CMrrW787rtrAPpUd7SiEw3S6vPyQs2A02r8xJQpTS5Paz/g8L8NQzwYu
rV5EHd37kDKdCqxXO18CKZz8CSpABfsKAnH06Oc5vMZtzKsb6E5uNLN6wWbdw+yn3e9xnxn/
JeuojTN8pAl8mk12BjsdG787MIIDODCCAqGgAwIBAgIQZkVyt8x09c9jdkWE0C6RATANBgkq
hkiG9w0BAQQFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAG
A1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMf
Q2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNv
bmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3
dGUuY29tMB4XDTAwMDgzMDAwMDAwMFoXDTA0MDgyNzIzNTk1OVowgZIxCzAJBgNVBAYTAlpB
MRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMG
VGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29u
YWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA
3jMypmPHCSVFPtJueCdngcXaiBmClw7jRCmKYzUqbXA8+tyu9+50bzC8M5B/+TRxoKNtmPHD
T6Jl2w36S/HW3WGl+YXNVZo1Gp2Sdagnrthy+boC9tewkd4c6avgGAOofENCUFGHgzzwObSb
VIoTh/+zm51JZgAtCYnslGvpoWkCAwEAAaNOMEwwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMT
EVByaXZhdGVMYWJlbDEtMjk3MBIGA1UdEwEB/wQIMAYBAf8CAQAwCwYDVR0PBAQDAgEGMA0G
CSqGSIb3DQEBBAUAA4GBADGxS0dd+QFx5fVTbF151j2YwCYTYoEipxL4IpXoG0m3J3sEObr8
5vIk65H6vewNKjj3UFWobPcNrUwbvAP0teuiR59sogxYjTFCCRFssBpp0SsSskBdavl50Oou
Jd2K5PzbDR+dAvNa28o89kTqJmmHf0iezqWf54TYyWJirQXGMYID1TCCA9ECAQEwgZowgZIx
CzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93
bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYG
A1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAIDCihRMAkGBSsOAwIaBQCg
ggIPMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAzMDcxODE3
MDk0N1owIwYJKoZIhvcNAQkEMRYEFJE2axfke+lnw9Ckdnv0+yvOCldLMFIGCSqGSIb3DQEJ
DzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsO
AwIHMA0GCCqGSIb3DQMCAgEoMIGrBgkrBgEEAYI3EAQxgZ0wgZowgZIxCzAJBgNVBAYTAlpB
MRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMG
VGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29u
YWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAIDCihRMIGtBgsqhkiG9w0BCRACCzGBnaCBmjCB
kjELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBU
b3duMQ8wDQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgw
JgYDVQQDEx9QZXJzb25hbCBGcmVlbWFpbCBSU0EgMjAwMC44LjMwAgMKKFEwDQYJKoZIhvcN
AQEBBQAEggEAREv8DiFcxgkH9VTSBH56JZoUdMV2CLSnYPvb/PQNsr21lBVa/e63gZbSaHSf
Oazp7oETG2sl8ZNTNajjpHFzDIuYKqgjI4Koc0GwALLAqFf9GhKlUcWQqyI+mg5+4yRs/6Ms
UeaCJV86MrOXCagUdPSqHZSKZphW5Ja03m8mitAKkzmJFuwqb7AU2YqvSmvYcEMlcDll2lbk
askL3Oet14ySD8wK0zrDA/FBro6jBSNj73nj7PR87C4rL+tZbGROdYQIM+KzQMzIJjl1mO75
YMfYue41XzIjG2K/irfPFPoJRqpUHZ88xzze7wI+nSf8aiMDrdDBj1k0ehx4H4bM4AAAAAAA
AA==
--------------ms070101000707030704060803--