[ic] table-editor tag and item_id with autonumber table

JT Justman jt at airdelights.com
Tue Nov 8 11:23:10 EST 2005


Peter wrote:
> On 11/07/2005 01:38 PM, JT Justman wrote:
> 
>> I can create a new entry on an autonumber column with:
>>
>> [table-editor key="" table="site_content"]
>>
>> The problem is that the "Items" group uses $CGI->{item_id} to track the
>> current product sku, and if there is a value in $CGI->{item_id} then
>> [table-editor] treats that as the code to edit, and we end up creating a
>> row with the number of the current item sku when we thought we were
>> autonumbering.
> 
> 
> You should be able to force autonumbering with (untested and not sure):
> [table-editor key="[counter products/site_content.autonumber]"
> table="site_content"]

Well, [counter] does give me a unique number, but it's not related to
the mysql auto_increment. It may be a passable workaround for this
table, since it's only edited from the UI, but I may change that some day...

> You can also do: [cgi name=item_id set="" hide=1]
> 
> ...or (even better because it actually removes the cgi value rather than
> just setting it to the empty string)...
> 
> [perl]delete $CGI->{item_id}; '';[/perl]
> 
> To manually clear out the item_id if it helps.

Clearing item_id does fix the autonumber issue, but it breaks the Item menu.

JT


More information about the interchange-users mailing list