DB wrote: [snip]
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] [/import]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 - -- --- --------------------------------------- --- -- _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.