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

Martin Ellison m.e at acm.org
Sun Dec 9 17:03:33 GMT 2007


SSB0cmllZCAgbXkgJG5ld2lkID0gJGMtPm1vZGVsKCBxe015QXBwREI6Ok15VGFibGV9CiktPnJl
c3VsdF9zb3VyY2UtPnN0b3JhZ2UtPmxhc3RfaW5zZXJ0X2lkKCk7ICBhbmQgaXQgZ2F2ZSBtZSB6
ZXJvLCBzbyBJJ20Kbm90IHN1cmUgaG93IHRvIHByb2NlZWQuCgpPbiAxMC8xMi8yMDA3LCBNYXJ0
aW4gRWxsaXNvbiA8bS5lQGFjbS5vcmc+IHdyb3RlOgo+Cj4gWWVzLCBJIGhhZCBhIGZvcm0gZmll
bGQgd2l0aCB0aGUgc2FtZSBuYW1lIGFzIHRoZSB0YWJsZSBrZXksIGJlY2F1c2UsIHdoZW4KPiBJ
IGRvIGFuIHVwZGF0ZSBvbiBhbiBleGlzdGluZyBvYmplY3QsIEkgd2FudCB0byBzYXZlIGl0cyBr
ZXkgdmFsdWUKPiBzb21ld2hlcmUuIC4uLkkndmUgcHV0IGluIGEgdGVzdCwgc28gaXQgb25seSBp
bmNsdWRlcyB0aGUgZmllbGQgd2hlbiBJIHdhbnQKPiB0byBkIGFuIHVwZGF0ZS4gU28gbm93IGl0
IGlzIGZvcm11bGF0aW5nIHRoZSBJTlNFUlQgd2l0aG91dCB0aGUga2V5IGZpZWxkLAo+IHdoaWNo
IGlzIGdvb2QuIEhvd2V2ZXIgJG9iai0+aWQgaXMgcmV0dXJuaW5nIHplcm8sIGltcGx5aW5nIHRo
YXQgdGhlIG1vZGVsCj4gaXMgbm90IGJlaW5nIHVwZGF0ZWQgYWZ0ZXIgdGhlIGluc2VydC4KPgo+
IFNvIG5vdyBJIGFtIHRyeWluZyB0byB3b3JrIG91dCBob3cgdG8gZ2V0IHRoZSBsYXN0IGluc2Vy
dCBpZC4gSSB0aGluayBpZiBJCj4gY2FuIHJldHJpZXZlIHRoZSByZWxldmFudCBEQkl4OjpTY2hl
bWEgSSBzaG91bGQgYmUgYWJsZSB0byAgdXNlCj4gJHNjaGVtYS0+c3RvcmFnZS0+bGFzdF9pbnB1
dF9pZCwgYnV0IEknbSBzdGlsbCB0cnlpbmcgdG8gZmluZCBvdXQgIGhvdyB0bwo+IGdldCB0byB0
aGUgc2NoZW1hLgo+Cj4gQXMgdG8gdGhlIGxhdGVzdCBpbiBDYXRhbHlzdCBtb2R1bGVzLCBJIHdh
cyB1c2luZyB3aGF0IHRoZSBkb2N1bWVudGF0aW9uCj4gcmVjb21tZW5kZWQuIEkgZG9uJ3Qgd2Fu
dCB0byByZXdyaXRlIGV2ZXJ5dGhpbmcgaW4gYW5vdGhlciBtb2R1bGUgbm93Lgo+Cj4gT24gMDkv
MTIvMjAwNywgQ2FybCBGcmFua3MgPGZpcmVhcnRpc3RAZ21haWwuY29tPiB3cm90ZToKPiA+Cj4g
PiBPbiAwOS8xMi8yMDA3LCBNYXJ0aW4gRWxsaXNvbiA8bS5lQGFjbS5vcmc+IHdyb3RlOgo+ID4g
PiBTb3JycnksIHRoaXMgaXMgYW5vdGhlciBuZXdiaWUgcXVlc3Rpb24uCj4gPiA+Cj4gPiA+IEkg
YW0gdXNpbmcgSFRNTDo6V2lkZ2V0IGFuZCBEQkl4OjpDbGFzcyB0byBkbyBzaW1wbGUgQ1JVRCBv
biBzb21lCj4gPiBNeVNRTAo+ID4gPiB0YWJsZXMuIEkgaGF2ZSBkZWZpbmVkIGFuIGF1dG8taW5j
cmVtZW50IHByaW1hcnkga2V5IG9uIG9uZSBvZiBteQo+ID4gdGFibGVzLAo+ID4gPiBhbmQgSSB3
YW50IHRvIHVzZSBhbiBIVE1MIGZvcm0gdG8gcG9wdWxhdGUgYW5kIGNyZWF0ZSBhIG5ldyBvYmpl
Y3QuIEkKPiA+IHRoZW4KPiA+ID4gd2FudCB0byByZXRyaWV2ZSB0aGUgbmV3bHktZ2VuZXJhdGVk
IGtleS4KPiA+ID4KPiA+ID4gU3VwW3Bvc2UgdGhlIFNRTCBoYXM6Cj4gPiA+Cj4gPiA+IENSRUFU
RSBUQUJMRSBteXRhYmxlICgKPiA+ID4gICAgICAgICBteXRhYmxlX2lkIFNNQUxMSU5UIFVOU0lH
TkVEIE5PVCBOVUxMIEFVVE9fSU5DUkVNRU5ULAo+ID4gPiAgICAgICAgdGl0bGUgVkFSQ0hBUig2
NCkgTk9UIE5VTEwsCj4gPiA+ICAgICAgICAgZGF0ZSBWQVJDSEFSKDEwKSBOT1QgTlVMTCwKPiA+
ID4gICAgICAgIFBSSU1BUlkgS0VZIChteXRhYmxlX2lkKTsKPiA+ID4KPiA+ID4gSGF2aW5nIHJl
YWQgdGhlIGV4YW1wbGVzLCBJIHRob3VnaHQgdGhhdCBhbGwgSSBoYWQgdG8gZG8gaXM6Cj4gPiA+
Cj4gPiA+ICAgICAgICAgICAgIG15ICRvYmogPQo+ID4gPiAkYy0+bW9kZWwocXtNeUFwcERCOjpN
eVRhYmxlfSktPm5ldyh7fSk7Cj4gPiA+ICAgICAgICAgICAgICAkb2JqLT5wb3B1bGF0ZV9mcm9t
X3dpZGdldCgkcmVzdWx0KTsKPiA+ID4gICAgICAgICAgICAgbXkgJG5ld2lkID0gJG9iai0+bXl0
YWJsZV9pZDsKPiA+ID4KPiA+ID4gYnV0IEkgYW0gZmluZGluZyB0aGF0IHRoZSBnZW5lcmF0ZWQg
U1FMIGlzIGluIGZhY3Qgc2V0dGluZyB0aGUga2V5Cj4gPiBmaWVsZCB0bwo+ID4gPiB6ZXJvLCBh
bmQgdGhlbiB0aGUgbGFzdCBsaW5lIG9mIHRoZSBhYm92ZSBjb2RlIGlzIGdldHRpbmcgYW4gdW5k
ZWZpbmVkCj4gPiB2YWx1ZQo+ID4gPiBiYWNrLgo+ID4KPiA+IEkgY2FuJ3QgcmVtZW1iZXIgZm9y
IHN1cmUgaG93IHBvcHVsYXRlX2Zyb21fd2lkZ2V0KCkgd29ya3MsIGJ1dCBJCj4gPiBzdXNwZWN0
IHRoYXQgeW91J3ZlIGEgZmllbGQgaW4geW91ciBmb3JtIGNvcnJlc3BvbmRpbmcgdG8gdGhlIHRh
YmxlJ3MKPiA+ICdpZCcgY29sdW1uLiBJZiB0aGF0J3MgZW1wdHksIHBvcHVsYXRlX2Zyb21fZm9y
bWZ1KCkgbWF5IGJlIHRyeWluZyB0bwo+ID4gYmxhbmsgdGhhdCBjb2x1bW4gKCIiKSwgYW5kIG15
c3FsJ3MgY29udmVydGluZyBpdCB0byBhIHplcm8uCj4gPiBZb3UgY2FuIHNlZSB0aGF0IGV4YWN0
IFNRTCB0aGF0J3MgYmVpbmcgaXNzdWVkLCBieSBzZXR0aW5nIHRoZQo+ID4gZW52aXJvbm1lbnQg
dmFyaWFibGUgREJJQ19UUkFDRT0xCj4gPiBJZiB0aGlzIGlzIG5ldyBkZXZlbG9wbWVudCwgSFRN
TDo6V2lkZ2V0IGlzIGRlcHJlY2F0ZWQgaW4gZmF2b3VyIG9mCj4gPiBIVE1MOjpGb3JtRnUuCj4g
PiBJZiB5b3UgZGVjaWRlIHRvIGxvb2sgYXQgSFRNTDo6Rm9ybUZ1LCB0YWtlIG5vdGUgdGhhdAo+
ID4gREJJeDo6Q2xhc3M6OkhUTUw6OkZvcm1GdSBpcyBhYm91dCB0byBiZSByZXBsYWNlZCBieQo+
ID4gSFRNTDo6Rm9ybUZ1OjpNb2RlbDo6REJJQywgd2hpY2ggaXMgc3RpbGwgaW4gc3ZuLCBhbmQg
d2lsbCBiZSByZWxlYXNlZAo+ID4gdG8gY3BhbiBhdCBzb21lIHBvaW50IHRoaXMgbW9udGguCj4g
Pgo+ID4gQ2hlZXJzLAo+ID4gQ2FybAo+ID4KPiA+IF9fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fCj4gPiBMaXN0OiBDYXRhbHlzdEBsaXN0cy5zY3N5cy5jby51
awo+ID4gTGlzdGluZm86IGh0dHA6Ly9saXN0cy5zY3N5cy5jby51ay9jZ2ktYmluL21haWxtYW4v
bGlzdGluZm8vY2F0YWx5c3QKPiA+IFNlYXJjaGFibGUgYXJjaGl2ZToKPiA+IGh0dHA6Ly93d3cu
bWFpbC1hcmNoaXZlLmNvbS9jYXRhbHlzdEBsaXN0cy5yYXdtb2RlLm9yZy8KPiA+IERldiBzaXRl
OiBodHRwOi8vZGV2LmNhdGFseXN0LnBlcmwub3JnLwo+ID4KPgo+Cj4KPiAtLQo+IFJlZ2FyZHMs
Cj4gTWFydGluCj4gKG0uZUBhY20ub3JnKQo+IElUOiBodHRwOi8vbWV0aG9kc3VwcG9ydC5jb20g
UGVyc29uYWw6IGh0dHA6Ly90aGVyZWlzbm9lbmQub3JnCj4KCgoKLS0gClJlZ2FyZHMsCk1hcnRp
bgoobS5lQGFjbS5vcmcpCklUOiBodHRwOi8vbWV0aG9kc3VwcG9ydC5jb20gUGVyc29uYWw6IGh0
dHA6Ly90aGVyZWlzbm9lbmQub3JnCi0tLS0tLS0tLS0tLS0tIG5leHQgcGFydCAtLS0tLS0tLS0t
LS0tLQpBbiBIVE1MIGF0dGFjaG1lbnQgd2FzIHNjcnViYmVkLi4uClVSTDogaHR0cDovL2xpc3Rz
LnNjc3lzLmNvLnVrL3BpcGVybWFpbC9jYXRhbHlzdC9hdHRhY2htZW50cy8yMDA3MTIxMC81NTM2
NDY1MC9hdHRhY2htZW50Lmh0bQo=


More information about the Catalyst mailing list