Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [Andy] Format of alter_col

Quote Reply
Re: [Andy] Format of alter_col In reply to
haha - I'm answering my own question again :P

Heres a solution that worked for me :

Code:
my $editor = $DB->editor('Links');
$editor->alter_col('PartOfAffiliate', {
type => 'CHAR',
size => '255',
form_names => 'test
test2
test3',
form_values => 'test
test2
test3'
}) || die $GT::SQL::error;

Basically, the "type" and "size" had to be passed in too, rather than only the changes I wanted done.

Just thought I would share, in case anyone else comes across the same problems in the future Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread Format of alter_col Andy 7555 Jul 14, 2008, 1:27 AM
Thread Re: [Andy] Format of alter_col
Andy 7422 Jul 14, 2008, 1:42 AM
Post Re: [Andy] Format of alter_col
Andy 7367 Jul 14, 2008, 6:46 AM
Thread Re: [Andy] Format of alter_col
Andy 7370 Jul 14, 2008, 7:46 AM
Thread Re: [Andy] Format of alter_col
brewt 7381 Jul 14, 2008, 3:01 PM
Thread Re: [brewt] Format of alter_col
Andy 7375 Jul 14, 2008, 11:42 PM
Thread Re: [Andy] Format of alter_col
brewt 7358 Jul 14, 2008, 11:55 PM
Thread Re: [brewt] Format of alter_col
Andy 7375 Jul 15, 2008, 12:00 AM
Thread Re: [Andy] Format of alter_col
brewt 7367 Jul 15, 2008, 12:03 AM
Thread Re: [brewt] Format of alter_col
Andy 7381 Jul 15, 2008, 12:09 AM
Post Re: [Andy] Format of alter_col
Wychwood 7333 Jul 15, 2008, 2:15 AM