I'm in a position of doing some work in PHP that integrates with Miva Merchant and another system. The system adds product information to the Miva database tables, but I'd like to wrap the SQL statements in a transaction so that failures will rollback the entire product if anything of the SQL statements fail.

To do so, as I understand it, requires InnoDB tables instead of MyISAM. Does anyone know if Miva Merchant will still run if I convert its tables to InnoDB?

Are there any cons to consider?

Should I convert ALL tables or just those I'm affecting? I'd like to do all of them in case I need to add code to the script later on (given that I might forget to change any newly-affected tables).

I have a routine which is called via mvcall from another server that looks up a given item in the database and sends back the results to the calling program. My problem is that it echos in the browser what is being sent back. I want to process the data at the calling end without echoing the data. How do I send back the search result without it being displayed in the browser. Here is the code that is called via mvcall.

Thanks.
DonB

<MIVA STANDARDOUTPUTLEVEL="html,text,compresswhitespace" >
<MvASSIGN NAME = "itemAcct" VALUE = "{ arg2 }">
<MvASSIGN NAME = "itemOptn" VALUE = "{ arg3 }">
<MvASSIGN NAME = "datadir" VALUE = "{ 'db2/' }">
<MvOPEN NAME="itemoptn" DATABASE="{ datadir $ 'itemoptn.dbf'}" INDEXES="{ datadir $ 'itemoptn.idx'}">
<MvASSIGN NAME = "SkuValue" VALUE = "{ itemAcct $ ' '$ glosub(itemOptn,'~','')}">
<MvASSIGN NAME = "findOption" VALUE = "{ itemAcct $ itemOptn}">
<MvFIND NAME="itemoptn" VALUE = "{findOption}">
<MvASSIGN NAME = "ovFlag" VALUE = "{0}">
<MvIF EXPR="{findOption EQ ( itemoptn.d.op_acctid $ itemoptn.d.op_itemid)}">
RETStaus=0<BR>
RETtitle=<MvEVAL EXPR="{itemoptn.d.op_title}"><BR>
RETretail=<MvEVAL EXPR="{itemoptn.d.op_retail}"><BR>
RETpkcost=<MvEVAL EXPR="{itemoptn.d.op_pkcost}"><BR>
<MvELSE>
ReturnStaus=-1<BR>
</MvIF>
<MvCLOSE NAME="itemoptn">

Hi all,

are there any news / docs etc. regarding the installation of Empresa on Windows 2008 R2?

Thanks,

Markus

Hello.

I am quite new to Miva(Script) and basically spent the last couple days crash coursing over the documentation.

I would like to use the Decrypt_Order() function located in your API but I am struggling to understand how to call this function from within my module.

When I call the function via an <MvEVAL> tag I get an error to the effect that the function is undefined or does not exist.

After some additional research I stumbled upon the Limited Source Kit and discovered the function is located under 5.00/lib/crypto_public.mv, but from here I am not sure how to continue.

Do I compile crypto_public.mv and "include" it somehow within my module and reference it that way?

Any help would be greatly appreciated.

Thank you!

Hi folks --

I'm working on a product-export module, and I need to deal with variants. If the product has variants by attribute, e.g. 4 sizes and 6 colors yielding 24 separate products, then I need to export each one as a separate product. But if the product is a kit, e.g. a video game and two game cartridges which are all separate products in the store, then I just want to export the kit, since the other items will be exported separately as their own "masters."

So I need to know how to tell one type from the other. From a quick test, it looks to me like the ProductVariants table only has data for attribute variants, not for kit parts. Is that a good way to go? Are there any other things I need to watch out for?

I haven't even started dealing with ProductKits, or with ProductVariantPricing ... if anyone has any tips on how to decode those, I'd appreciate the info.

Thanks --

I use MvCall a lot but I have not been able to make it work when calling the sears portal with post. I ended up writing a php script to get around the problem but it is really cumbersome and would like to replace the php with mvcall. I have tried every combination I can think of but they don't recognize the post. I can do gets just fine but no posts.

Has anyone had any success interfacing to sears.

Thanks

Donb

I'm sending some xml with a url. In the browsers address bar the url works perfectly. I send the url in MvCall and I get no response. How do I simulate the same browser environment?

I've tried a number of things. This is my most recent.

results is SSL read error. Still don't know if a connect is occurring. And, I am sure I am forgetting something basic.

Thanks,

Scott

In the documentation for (tm_isdst) it says that this will let you know if daylight savings time is in affect for your current time zone and this is based on system time. But what if you want to find out if daylight savings time is in affect for another time zone. For instance I'm in MST and this is the time zone for my system however we do not observe daylight savings so (tm_isdst) would always be false. Is there a way to use (tm_isdst) to check another time zone?

Thanks

I would like to pre-fill a form with the customer's first and last name like this:
I have tried to populate it with the toolkit concat code
but it returns nothing.

Do I need to save that toolkit code to a new variable in order to put it in the value of the input? If so, how can I write that line?

Thanks for any help,
Maxanne