[ic] Add record to table when order is placed

Marty Tennison marty at sediva.com
Fri Dec 9 11:17:04 EST 2005

DB wrote:


> Here is more detail about my failed attempts to have IC insert a record
> in the table order_info when an order is placed. In my
> ...etc/log_transaction file I changed the line
> [loop list="transactions orderline inventory userdb"]
> to
> [loop list="transactions orderline inventory userdb order_info"]
> I then added
> [import table=order_info]
> code: [value mv_order_number]
> [/import]
> just before the closing [/try] tag. But in my .../interchange/error.log
> I see entries like this when an order is placed, and no record is
> inserted into the order_info table.
> ...Error creating dummy database for icmenu: Can't call method "new" on
> an undefined value at /home/store/interchange/lib/Vend/Data.pm line 752.
> The key column for the order_info table is named order_number I'm hoping
> someone can provide a clue or a link to appropriate docs?

I usually move the code into a separate interchange page and test the 
imports there first.  Then you can eliminate a lot of variables before 
you move it into log_transactions file.   For instance, in a page named 
test.html you could put  (not tested)

[tmp test_order_number]1234[/tmp]

[import table=order_info]
   order_number: [scratch test_order_number]

Once you get a basic import working you can then add the loop and try 
blocks around it and see what happens.  Then, moving it into 
log_transactions should be fairly painless.

That's just the way I do things, YMMV.

-  - -- ----  ---------------------------- --- -- -   -
Marty Tennison
-  -- --- --------------------------------------- --- --

More information about the interchange-users mailing list