[Zope-DB] Hello!

[Philip Kilner]

This is a cryptographically signed message in MIME format.

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

Hi Jim,

Jim Penny 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?
>>>
...[snip]...
> OK, suppose my_sql_method is a query having parameters foo, and bar and
> it lies in the current container.
> 
> Foo and bar can be in the request, or they can be passed as named
> parameters.  In the first case, the call would simply look like:
> 
> res=container.my_sql_method(request)
> 

res=container.insertBook(request)

...seems to be accepted, but inserts nothing.

> In the second, it would look like
> 
> res=container.my_sql_method(foo=foo_value, bar=bar_value)
> 

OK, well the 2nd looks like a better bet - more explicit!

However, I can't save even a ZPT with that syntax -

res=container.insertBook(ISBN=field_ISBN, Title=field_Title)


...gives me: -

Compilation failed
TAL.HTMLParser.HTMLParseError: junk characters in start tag: ', 
Title=field_Title)', at line 10, column 1

I actually can't se what I am doing wrong.

Since Friday I have learned about: -

<span tal:replace="structure request">info about the request 
namespace</span>

...so I know my data is there - just not why it neither inserts not 
gives me an error message!

Any clues? I'm stuck now and I can only take this level of frustration 
in 150 minute chunks so I'm going to take a break!!!

-- 

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


--------------ms070509090803080104070900
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
ggIPMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAzMDcyMTE1
NDQ0MlowIwYJKoZIhvcNAQkEMRYEFL/bxfAP3n//w4LgCWZZPCepXC1tMFIGCSqGSIb3DQEJ
DzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsO
AwIHMA0GCCqGSIb3DQMCAgEoMIGrBgkrBgEEAYI3EAQxgZ0wgZowgZIxCzAJBgNVBAYTAlpB
MRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMG
VGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29u
YWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAIDCihRMIGtBgsqhkiG9w0BCRACCzGBnaCBmjCB
kjELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBU
b3duMQ8wDQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgw
JgYDVQQDEx9QZXJzb25hbCBGcmVlbWFpbCBSU0EgMjAwMC44LjMwAgMKKFEwDQYJKoZIhvcN
AQEBBQAEggEAeneOIdCUKMkpPvygtSQXPrCFalKLvyxpVzQdc9RGu/2hEfnIq9DAotkigMBs
zSOE9orcuSl9052gU7jCsZWMeG6oI1TCbL8TWzppp4H1hP19iPu7VYula7QGEAINoY1sz6K9
wYl1u9q4YsytdUWYqrwaoKC1PsPQYsf9toPcYJ5uNZTReWKTwEp7oFlFCqD4sG1nE+T8rlIu
+cCaH2g7m3po0di+L5XC/9bwpEJ9sfLFkzAEUSTR1IgwHNZm+HjUEfOc2ddOdc9ug84QU7nc
tlty9MmYWEtwkLGKbj2vzSVFAL+hvZ7zEzcnzYV4EvQ/XVDCAJZEErevD412iOnmowAAAAAA
AA==
--------------ms070509090803080104070900--