close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Need Help with setting up recordset for downloads

Thread began 11/22/2009 12:40 am by bac4571381904 | Last modified 12/21/2009 2:25 pm by bac4571381904 | 3385 views | 29 replies

Eric Mittman

On the checkout success page you will want to have a query to display all of the files available to download. This would be based on the values in the order details and order tables and will be filtered on the order id that is in the session. You can see what this value is in your store order summary server behavior, it is the session variable listed here for the id.

So an example of this query might look like this:

SELECT * FROM orders
JOIN order_details ON orders.orderID = order_details.orderID
WHERE orders.orderID = <your session var value>

Your session var value should be equal to the session value that is set in the store order summary server behavior.

You can then use the bindings from this recordset in a repeat region to display all of the items the user has purchased. You would then want to make links to your download page from this list of items. This link should include a URL parameter for the item id.

Then on your download page you would have a recordset that is similar but it will also select from the files table based on the item id you have in the URL parameter.

SELECT * FROM orders
JOIN order_details ON orders.orderID = order_details.orderID
JOIN files ON files.itemID = order_details.itemID
WHERE orders.orderID = <your session var value>
AND files.itemID = <your URL parameter for the itemID>

For the download server behavior you would trigger it based on the recordset not being empty. For the file to download you can use the binding from this rs for the filename.

This is just an example of how you will need to have it, you will need to adapt this to your current implementation. I would suggest that you get started on this and if you run into problems let us know and post what you have and what you are getting with it.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...