[ic] Errors when trying to use state for shipping selection

Chris Bair interchange at tssphoto.com
Fri Dec 12 14:30:46 EST 2003

>Quoting Chris Bair (interchange at tssphoto.com):
>>  I'm running into some errors when I try to restrict different
>>  shipping modes based on the sate. I have the different shipping modes
>>  in the shipmode column in the state table using spaces to separate
>>  them, just like you do in the country table. The error I'm getting
>>  looks like this:
>>  Runtime error: Can't locate object method "single" via package
>>  "Vend::Table::GDBM" (perhaps you forgot to load "Vend::Table::GDBM"?)
>>  at /home/inkjet/interchange/lib/Vend/Ship.pm line 429.
>>  and the code for the shipping selection looks like this:
>>           <SELECT NAME=mv_shipmode>
>>            [shipping
>>              label=1
>>              mode=|[data table=state key='[default state UT]' col=shipmodes]|
>>            ]
>>            </SELECT>
>>  although I have also tried:
>>	<select name=mv_shipmode>
>>	[loop list="[shipping possible=1]"]
>>	  <option value="[loop-code]"> [shipping-desc mode="[loop-code]"]
>>	[/loop]
>>	</select>
>>  I started out on IC 4.8.7, tried it on 4.9.9 and my current test
>>  server is running 5.0.0 RC2 just for kicks and giggles. I even
>>  grabbed the current Bundle:Interchange and the kitchensink just in
>>  case.
>>  Has anyone out there been able to get this working or is it just a
>>  broken feature that isn't ready for use yet?
>You want SQL tables to do this, I think. As the number of GDBM users
>dwindles, things are not often fully tested using that table type.
>Any tag which uses SQL queries (as that one does).
>I think we have to start putting a "requires SQL" in some cases.

In case I run into issues with MySQL (I have a text file uploaded 
every 6 hours that syncs inventory and prices to our on-site order 
database - I'm not sure how I'm going to do this with MySQL yet) is 
there a way to make this work with GDBM?

More information about the interchange-users mailing list