Register | Log In
Store Download Support Blogs Forums Contact
Resources > Forums
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsStoreStoreDNN Store SQL helpDNN Store SQL help
Previous
 
Next
New Post
11/18/2007 9:45 PM
 
User is offline hazen wilson


Joined: 6/8/2007
Posts: 27

Need some help with DNN store 2.0 SQL.

Not the best at Sql and looking for help.

I need a sql statement that will update the 'store_cartitems' table (the shopping cart) with a product from the 'store_products' table directly,  where Product ID = input by user.

Any ideas?

www.hazeninteractive.com www.planetsocialsports.com www.rentalpropertyfind.com www.freeusedcartrader.com www.losangeles-activities.comwww.planetsportsgear.com
 
New Post
11/19/2007 8:18 AM
 
User is offline Eric MacKenzie


www.r2integrated.com
Joined: 11/27/2006
Posts: 7

You will have to have the cart id (cookie), or be able to get the cart Id of a current session with the user Id and portal Id out of the 'store_cart' table.

Once you have the cart Id you only need product Id and quantity.

 

 

Eric MacKenzie
 
New Post
11/19/2007 11:08 AM
 
User is offline hazen wilson


Joined: 6/8/2007
Posts: 27

Can you suggest any sample code that shows how to do this?

www.hazeninteractive.com www.planetsocialsports.com www.rentalpropertyfind.com www.freeusedcartrader.com www.losangeles-activities.comwww.planetsportsgear.com
 
New Post
11/19/2007 12:49 PM
 
User is offline hazen wilson


Joined: 6/8/2007
Posts: 27

Can you give me an example script that does this?

www.hazeninteractive.com www.planetsocialsports.com www.rentalpropertyfind.com www.freeusedcartrader.com www.losangeles-activities.comwww.planetsportsgear.com
 
New Post
11/20/2007 9:04 AM
 
User is offline Gilles Le Pigocher


Gilles Le Pigocher's Avatar

Joined: 10/11/2003
Posts: 1845

Hi,

Could you give more details on what you want to do? Do you modify the code?

If you modify the code, then you can use the CurrentCart class like this:

CurrentCart.AddItem(PortalId, productID, Quantity);

Look inside ProductDetails.ascx.cs the AddToCart method use this class for adding product to cart.

Gilles

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After 3 years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsStoreStoreDNN Store SQL helpDNN Store SQL help


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
Attend A Webinar
Free Demo Site
Download DotNetNuke Professional Edition Trial
Have Someone Contact Me
Have Someone Contact Me
Charlotte DoDNN

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

PowerDNN
r2integrated
Telerik JustCode Free

DotNetNuke Scoop!

Sponsors

DotNetNuke Corporation

DotNetNuke Corp. is the steward of the DotNetNuke open source project, the most widely adopted Web Content Management Platform for building web sites and web applications on Microsoft. Organizations use DotNetNuke to quickly develop and deploy interactive and dynamic web sites, intranets, extranets and web applications. The DotNetNuke platform is available in a free Community and subscription-based Professional and Enterprise Editions with an Elite Support option. DotNetNuke Corp. also operates the DotNetNuke Store where users purchase third party apps for the platform.
Copyright © 2002-2012 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP