[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