Andrew Baltino wrote: > > In certain parts of the log_transaction script the query tag is > attempting reference the local database! In other parts of the script > it gives me this error: > > > 192.168.100.31 V5BfHpCv:192.168.100.31 - [07/September/2006:23:27:07 > -0400] store_devel /cgi-bin/store_devel/process.html ERRORS on ORDER > L000003028: >> Error during creation of order routing log: >> Route log failed. at /home/store/interchange/lib/Vend/Order.pm line 1577. >> > > Any suggestions? I put the code in a usertag and received the same error. > > I am running Interchange 4.8.5. > > Could I write a PERLscript that excepts arguments that I would pass to > an SQL query and call this PERL script from IC? Hi, Andy! I think it would be helpful if you clarified - how do you know that the query is happening on the local table? Does a table by that name exist in both local and remote databases? Are you seeing other errors? Can you post the code you are using for this query? As to running the query in a Perl script, the best way to do this in IC is to turn that script into a usertag, which it seems you have tried. We just need to figure out what's really happening with the database connection/query. JT _______________________________________________ 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.