[Catalyst] Re: How to insert from form to MySQL with autoincrement primary key?

[Martin Ellison]

T0ssIEkgaGF2ZSBjaGFuZ2VkIG15IGNvZGUgYSBiaXQsIHNvIHRoYXQgaXQgbm93IGhhcwoKICAg
ICAgICAgICAgJG9iaiA9ICRjLT5tb2RlbCggcXtNeUFwcERCOjpNeVRhYmxlfSktPmNyZWF0ZSgg
e30gKTsKICAgICAgICRvYmotPnBvcHVsYXRlX2Zyb21fd2lkZ2V0KCRyZXN1bHQpOwoKSW4gb3Ro
ZXIgd29yZHMsIEkgaGF2ZSByZXBsYWNlZCB0aGUgJ25ldycgaW4gdGhlIGZpcnN0IGxpbmUgYnkg
YSAnY3JlYXRlJy4KVGhlIHJlc3VsdCAoYXMgdmVyaWZpZWQgYnkgdGhlIERCSUMgdHJhY2UpIGlz
IGFuIGluc2VydCB3aXRoIG5vIGNvbHVtbnMKc3BlY2lmaWVkLCBmb2xsb3dlZCBieSBhbiB1cGRh
dGUgb2YgYWxsIHRoZSBmaWVsZHMuCgpUaGlzIGRvZXMgd29yayAodGhlIHByaW1hcnkga2V5IGlu
IHRoZSBtb2RlbCBpcyBzZXQgcHJvcGVybHksIGFuZAokb2JqLT5teXRhYmxlX2lkIHJldHVybnMg
dGhlIG5ldyBrZXkpLiBBcyBpdCBoYXBwZW5zLCBpbnNlcnRpb24gZWZmaWNpZW5jeQppcyBub3Qg
Y3J1Y2lhbCB0byBteSBjdXJyZW50IGFwcGxpY2F0aW9uLCBzbyBJIGNhbiBnbyB3aXRoIHRoZSB3
b3JrYXJvdW5kLgoKQnV0IGl0IGRvZXMgbG9vayBsaWtlIGEgYnVnIHRvIG1lLgoKCk9uIDEwLzEy
LzIwMDcsIE1hcnRpbiBFbGxpc29uIDxtLmVAYWNtLm9yZz4gd3JvdGU6Cj4KPiBNeSB0YWJsZSBj
bGFzcyBpcyBiYXNpY2FsbHk6Cj4KPiB1c2UgYmFzZSBxdy9EQkl4OjpDbGFzcy87Cj4KPiBfX1BB
Q0tBR0VfXy0+bG9hZF9jb21wb25lbnRzKHF3L1BLOjpBdXRvIENvcmUgSFRNTFdpZGdldC8pOwo+
Cj4gIyBTZXQgdGhlIHRhYmxlIG5hbWUKPiBfX1BBQ0tBR0VfXy0+dGFibGUoJ215dGFibGUnKTsK
Pgo+ICMgU2V0IGNvbHVtbnMgaW4gdGFibGUKPiBfX1BBQ0tBR0VfXy0+YWRkX2NvbHVtbnMoCj4g
ICAgIHF3L215dGFibGVfaWQgdGl0bGUgZGF0ZS8KPiApOwo+Cj4gIyBTZXQgdGhlIHByaW1hcnkg
a2V5IGZvciB0aGUgdGFibGUKPiBfX1BBQ0tBR0VfXy0+c2V0X3ByaW1hcnlfa2V5KHEvbXl0YWJs
ZV9pZC8pOwo+Cj4gVGhhdCBzaG91bGQgY292ZXIgb2ZmIFBhdWwncyBjb25jZXJucy4KPgo+IEl0
IHNlZW1zIHRoYXQgc2V0X3ByaW1hcnlfa2V5IGNhbiB0YWtlIGVpdGhlciBhIHNpbmdsZSBzdHJp
bmcgb3IgYQo+IHJlZmVyZW5jZSB0byBhbiBhcnJheSBvZiBzdHJpbmdzLCBidXQgbmVpdGhlciB3
b3JrIGZvciBtZS4gKE9yIHJhdGhlciwgdGhleQo+IHdvcmsgZm9yIHVwZGF0ZSBidXQgbm90IGlu
c2VydCkuCj4KPiBPbiAxMC8xMi8yMDA3LCBrZXZpbiBtb250dW9yaSA8bW9udHVvcmlAZ21haWwu
Y29tPiB3cm90ZToKPiA+Cj4gPiA+Pj4+PiAiUEgiID09IFBhdWwgSGVucmljaCA8cGF1bEB3b3Js
ZGhpdmUubmV0PiB3cml0ZXM6Cj4gPgo+ID4gUEg+IFlvdSBtaWdodCBjaGVjayB0byBtYWtlIHN1
cmUgdGhhdCB5b3UgYXJlIGxvYWRpbmcgUEs6OkF1dG8gaW4KPiA+IFBIPiBNeUFwcERCOjpNeVRh
YmxlOgo+ID4KPiA+IEkgYmVsaXZlIHRoYXQgd2l0aCBhIHJlY2VudCBEQkl4OjpDbGFzcyB0aGF0
J3Mgbm90IG5lY2Vzc2FyeTogcGVybGRvYwo+ID4gREJJeDo6Q2xhc3M6OlBLOjpBdXRvIGluZGlj
YXRlcyB0aGF0ICJQSzo6QXV0byBpcyBub3cgcGFydCBvZiBDb3JlLiIKPiA+Cj4gPgo+ID4gay4K
PiA+Cj4gPiAtLQo+ID4ga2V2aW4gbW9udHVvcmkKPiA+IG1vbnR1b3JpQGdtYWlsLmNvbQo+ID4K
PiA+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gPiBM
aXN0OiBDYXRhbHlzdEBsaXN0cy5zY3N5cy5jby51awo+ID4gTGlzdGluZm86IGh0dHA6Ly9saXN0
cy5zY3N5cy5jby51ay9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vY2F0YWx5c3QKPiA+IFNlYXJj
aGFibGUgYXJjaGl2ZToKPiA+IGh0dHA6Ly93d3cubWFpbC1hcmNoaXZlLmNvbS9jYXRhbHlzdEBs
aXN0cy5yYXdtb2RlLm9yZy8KPiA+IERldiBzaXRlOiBodHRwOi8vZGV2LmNhdGFseXN0LnBlcmwu
b3JnLwo+ID4KPgo+Cj4KPiAtLQo+IFJlZ2FyZHMsCj4gTWFydGluCj4gKG0uZUBhY20ub3JnKQo+
IElUOiBodHRwOi8vbWV0aG9kc3VwcG9ydC5jb20gUGVyc29uYWw6IGh0dHA6Ly90aGVyZWlzbm9l
bmQub3JnCj4KCgoKLS0gClJlZ2FyZHMsCk1hcnRpbgoobS5lQGFjbS5vcmcpCklUOiBodHRwOi8v
bWV0aG9kc3VwcG9ydC5jb20gUGVyc29uYWw6IGh0dHA6Ly90aGVyZWlzbm9lbmQub3JnCi0tLS0t
LS0tLS0tLS0tIG5leHQgcGFydCAtLS0tLS0tLS0tLS0tLQpBbiBIVE1MIGF0dGFjaG1lbnQgd2Fz
IHNjcnViYmVkLi4uClVSTDogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL3BpcGVybWFpbC9jYXRh
bHlzdC9hdHRhY2htZW50cy8yMDA3MTIxMC8yM2Q5YTcwNi9hdHRhY2htZW50Lmh0bQo=