Re: [Templates] Passing a list to DBI execute? (solved)

[prev] [thread] [next] [Date index for 2004/12/07]

--Apple-Mail-1--430547355
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed


On Dec 6, 2004, at 5:55 PM, Larry Leszczynski wrote:

> Thanks for the idea Harald!  I had previously tried using eval but 
> without
> success.  It now works using the following:
>
>    [%
>       sth  = DBI.prepare(query);
>       params_list = "'" _ bind_params.join("','") _ "'";
>       "[% rows = sth.execute($params_list) %" _ "]" FILTER eval;
>       FOREACH row IN rows;
>          ...do stuff...
>       END;
>    -%]

I hope your bind_params have no funky SQL characters in them, 
especially single quotes.  You really should call the DBI's quote() 
method on each value, then join that result with just a comma.

Vivek Khera, Ph.D.
+1-301-869-4449 x806


--Apple-Mail-1--430547355
Content-Transfer-Encoding: base64
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Disposition: attachment;
	filename=smime.p7s

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGhzCCAz8w
ggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0
ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcx
KDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0
ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxA
dGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpB
MSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUg
UGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA
xKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7d
yfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/
p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDow
OKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3Js
MAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgw
DQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A
9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYI
Tq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8wggNAMIICqaADAgECAgMMB/4wDQYJKoZI
hvcNAQEEBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkp
IEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA0
MDMzMDIwNDIxMVoXDTA1MDMzMDIwNDIxMVowgYoxHzAdBgNVBAMTFlRoYXd0ZSBGcmVlbWFpbCBN
ZW1iZXIxHjAcBgkqhkiG9w0BCQEWD3ZpdmVrQGtoZXJhLm9yZzEgMB4GCSqGSIb3DQEJARYRa2hl
cmFAa2NpbGluay5jb20xJTAjBgkqhkiG9w0BCQEWFnZpdmVrQG1haWxlcm1haWxlci5jb20wggEi
MA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDBSjHPUwN+eaM5uwCtKXo+khMQU4oD9GC4XhNN
rVzqx2Jgx/ep985wo5jxHZ2VJ9wKBt6MuKav8Q6H60oMRot3gW3FYPX5k7GkuMIoThjV0GzixL/u
tq5OacDiO8dupSH7CT13AxNfNGFSW3Q6O/PaJ0b2pupL7X+EHY3+lpzKV8+OMwcRUW71tI3sZghi
pVuiUeWZhrJQsuuxxZLM7IyGD0uepCQT3hCIiClpzJTGDygwW7nBPRuXI2tMAU4wFYZG34BH+JVR
YKfm4WH99/9IH7Fz55u0qNsvPL7FhZakIDA0QjEprv35zbO9uFSu/PY4Yj91Vaih8PtKkLi+rCVn
AgMBAAGjVzBVMEUGA1UdEQQ+MDyBD3ZpdmVrQGtoZXJhLm9yZ4ERa2hlcmFAa2NpbGluay5jb22B
FnZpdmVrQG1haWxlcm1haWxlci5jb20wDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQA6
96KzrXtGrERiiN3zJBHZxIox5mVn1Bt/RL6JO8PRw4CFuFvLI77Vf9yCiduWd+J7ijfhCmEj3m/W
9KmWP4XEArbhIBBO1lBa2lyHd7LUNnhUTzruAbHdyc4e25PpS3TM3YbFX7e+wdrcdZYWZgiYDb1l
x60aJ4MtJ5+msGQeazGCAucwggLjAgEBMGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0
ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFp
bCBJc3N1aW5nIENBAgMMB/4wCQYFKw4DAhoFAKCCAVMwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEH
ATAcBgkqhkiG9w0BCQUxDxcNMDQxMjA3MTQ0NTA0WjAjBgkqhkiG9w0BCQQxFgQUhyzakfzffoTY
ykVwZpJDkNFC+tcweAYJKwYBBAGCNxAEMWswaTBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0ECAwwH/jB6BgsqhkiG9w0BCRACCzFroGkwYjELMAkGA1UEBhMCWkExJTAj
BgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJz
b25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAgMMB/4wDQYJKoZIhvcNAQEBBQAEggEAF+LXm3uK1N3S
zwpthSh7LfbCTVYHwWGmFr8I0QZnRWW5Kl9mQ80UOnEEVAUrrIniGngZ9BwyP11BQvBxCY3FeyNp
+6ETbKAiFk43V6jhItMjRf0kNO8uipbzkhTRuckd5cGLYhwqWv4oolRVeGh1mBQbHKmxVOGNh9o3
KJ7uPtjklV1dyTJouHmAj7RlJFYZKZ24oIPOfWSer7pHJFSFY0FFSR8QDOh0jbh1FuVXSwlaHsTR
yM+l0K0LwKzub4o581xuG7Y0pZVAzDoOvZeSCgnn3ZBP6q8L1KdQbZ78WIwn6YU9vafSWhs+g1Ja
gJsng2unTTVoyxYScoGMFZqMPAAAAAAAAA==

--Apple-Mail-1--430547355--


_______________________________________________
templates mailing list
templates@xxxxxxxxxxxxxxxx.xxx
http://lists.template-toolkit.org/mailman/listinfo/templates