how to limit quantity in ecart?

Hello,
I don't know how to limit the quantity customers add to the cart. I have a certain quantity for each product in the database and it vary from 1 to 200. However right now customers can add any quantity and also change it in the cart. How to make the error message appear than customers set the quantity more than available in stock?

add a column in the cart object called maxQuantity

on the calculations tab, create a calculation as:

abs([Quantity] > [maxQuantity])?[Quantity] = [maxQuantity]:0

in the add to cart button behavior, bind the maxQuantity column to the stock column in your recordset.

This will prevent the user from being able to set the quantity above what is set in the Database. it wont show an error message, so On your product page, you should probably list the stock so they know the maximum that is available.

Thank you! You are the best! :)

I did like you said but it shows this right now:

Notice: Use of undefined constant maxQuantity - assumed 'maxQuantity' in C:\xampp\htdocs\BYZANTINO_BOSTON\WA_eCart\eCart_BYZANTINO_PHP.php on line 12

here is line 12:
$itmObj->QuantityAvailable = abs($itmObj->Quantity > [maxQuantity])?$itmObj->Quantity = [maxQuantity]:0;//t

that would mean you used a different name for the maxQuantity column in the cart object.

Note, the column names are case sensitive. Send a screen shot of the column tab showing the column names

yea, right now i noticed... my mistake...
i spelled it 'Quantiry'
Thank you again for your help!
It works! :)

glad to hear it is working.