[ic] record created, but cant retrieve autonumber value on next page

Aaron Hazelton interchange-users@icdevgroup.org
Thu Aug 22 17:38:00 2002


Hi all,

on a form-to-table page, I have the following (copied from
the UI pages) that will grab the autonumber:

[if cgi new]
[perl tables="quote"]
	my $db = $Db{$CGI->{quote}} or return;
	unless ($db->config('AUTO_SEQUENCE')) {
		$db->config('AUTO_NUMBER', '000001')
			unless $db->config('AUTO_NUMBER');
		$CGI->{item_id} = $db->autonumber();
	}
	return;
[/perl]
[/if]

[set update_database]... etc. etc.
<form ..etc. etc..>
<input type=hidden name=code value="[cgi code]">

the record is created just fine!

but on the next page all of my values carry through except the
"code" - I tried [cgi code] and [value code] and either one
returns a blank even though the record was already created
by this point.  How do you grab that value??

thanks
Aaron
Hazenet.net