| |
| 1. | Discounting by price
Posted by the_swarve_mongoose on 9/15/2004 8:12:07 AM
Hi Julian,
Is there a way to discount by cost of order? E.g. over £50, 10% discount. Discounting by quantity wouldn't really work in my situation.
Thanks,
Swarve |
| 2. | Re: add image to cart
Posted by the_swarve_mongoose on 9/24/2003 6:59:29 AM
Hi,
One way I know of displaying images related to the database, is to create an extra field in your database called "Image ID" or "Image URL." In this field you store a hyperlink to the image in your image folder. i.e. ./images/product1.jpg
Now, in Dreamweaver insert a picture, and when it asks you for the source, click on 'Data Sources' (at the top near the title bar). Provided you've got a Product based recordset; you can choose the ... |
| 3. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 12/1/2003 8:30:37 AM
This is my script:
<%
SendEmail 'This line calls the function below and sends the email
function SendEmail
on error resume next 'This code will only work on a Win2k server.
Dim iMsg,iConf,Flds
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
Set Flds = iConf.Fields
With Flds
' assume constants are defined within script file
... |
| 4. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 12/4/2003 7:29:35 AM
Hi Julian,
Nothing really happened - I've deleted that line as you recommended; I still just get a blank email. I don't get any error messages at all. It works great, apart from the email. I receive it but it's blank.
Swarve Mangoose |
| 5. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 12/5/2003 4:57:26 AM
Hi Julian,
Thanks for your patience with this, I've sorted the problem - it was looking for something that wasn't in the database - an error with the shoppingcart query.
It now sends the confirmation email from the site; looks lovely. The only problem I have is that for some reason the Sub Total, and Grand Total are both *10 more than they should be.
E.g. an order for £2.50 would appear in the sub and grand totals as £25.00
|
| 6. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 12/9/2003 5:46:11 AM
Looks like the error has originated from the database.
Any ideas how?
Swarve. |
| 7. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 12/10/2003 6:53:15 AM
The Sub Total, and Grand Total are both stored *10 or *100 more than they should be.
The UnitPrice column in some orders is the same.
E.g. an order for £2.50 would appear in the sub and grand totals as £25.00 or £250.00
Swarve. |
| 8. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 1/14/2004 9:43:13 AM
Any ideas on this Julian?
Many Thanks,
Swarve. |
| 9. | Uploading the Cart
Posted by the_swarve_mongoose on 11/26/2003 6:03:48 AM
Hi,
I have finished the cart, and uploaded it onto my web space. I know my web server supports asp and access database connections, and the testing DSN I have set up on my computer works a treat. However, when I host the site, nothing happens - the main page works, but any page in the site which uses a recordset doesn't work. I just get a 500 error, indicating my scripting is wrong. I don't know what to, since it all seems to work on my computer. I think I have to change ... |
| 10. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 11/27/2003 8:04:47 AM
That's Brill - I've got most of it working now.
I can't seem to add a new user though - It says I need an updateable query. I'm sure my permissions are correct. Is it scripting again?
The Swarve Mongoose |
| 11. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 11/28/2003 2:57:03 AM
Many Thanks Jules,
I'll sort it out.
Get Well Soon
Swarve |
| 12. | Re: Uploading the Cart
Posted by the_swarve_mongoose on 11/28/2003 3:59:42 AM
It all works beautifully now Jules - thanks.
There's just one thing - Any ideas why my confirmation emails are blank?
I've got the HTML body tag pointing to the right place.
Many Thanks,
Swarve Mongoose |
| 13. | Updating the Cart
Posted by the_swarve_mongoose on 9/22/2003 5:13:22 AM
Greetings,
First of all, I'd like to thankyou for the cart extension - it's really good.
I am, however having one problem.
I have set up the cart columns, using a layout table, and have created form tags on either side of the table script (the whole table is form'd). I then dragged across the cart fields, and set the cart's repeatable region. All was fine and I added a checkbox, and a quantity field. I have set the quantity field as ... |
| 14. | Re: Updating the Cart
Posted by the_swarve_mongoose on 11/3/2003 3:52:32 AM
Hi Asas,
My cart works perfectly now.
I was just wondering if you had done the same as I did.
I copied all of the head, and pasted it in replace of my head, and I copied the table from the body of the demo version, and pasted that into mine.
I then went through the server behaviours correcting any which brought up errors of exlcamation marks.
This is all I did; apart from deleting the duplicated line:
|
| 15. | Re: Updating the Cart
Posted by the_swarve_mongoose on 9/26/2003 3:26:00 AM
Hi Julian,
Thanks for answering.
I'm using the Charon Cart Suite 2.0.2; and the Dreamweaver MX server behaviours 1.0.0; but I'm using the server behaviours really.
The cart works fine until I update it. It doesn't show the cart contents anymore.
The URL it directs you to is: http://localhost/a1_new/viewCart.asp?UpdateNumber=1
Then update number 2,3,4 etc.
I've checked it against your code, and can't ... |
| 16. | Re: Updating the Cart
Posted by the_swarve_mongoose on 10/3/2003 8:16:57 AM
Hi,
Many, Many thanks for you help on this matter.
'Tis a mistery to me.
I've copied the source from the demo file and this works like magic now.
Thanks again,
The Swarve Mongoose. |
| 17. | Re: Updating the Cart
Posted by the_swarve_mongoose on 10/13/2003 4:32:13 AM
Hi,
I copied the blue outlined layout box from the demo, and pasted it into mine.
I then copied all the head section from the demo, pasted it in replace of mine, and debugged the application toolbox. (Anything with a red exclamation mark is an error)
Is this what you did?
The Swarve Mongoose. |
| 18. | Re: save cart to database and email simultaneously
Posted by the_swarve_mongoose on 11/5/2003 11:04:33 AM
You need to copy the section of script concerning emailing from the head of OrderConfirmed.asp; and paste it into the head of the page that saves the Cart to the database. This will send out an email of Email.asp as the body to the Customer provided that the server you upload to supports the email thingy.
You can send a copy to yourself by adding a .Cc line; and you could change the body from Email.asp to whichever page you like; providing you at the correct string.
|
| 19. | Emailing customers
Posted by the_swarve_mongoose on 10/27/2003 3:32:26 AM
Hi Julian,
Many thanks for your help so far, it's much appreciated.
On the OrderConfirmed.asp page, the script for sending emails has the Customer's email from the recordset. Is there any reason why I can't put a comma, and add our email address, or is there another command I need to use to send a default email to us everytime someone orders?
Thanks again,
The Swarve Mongoose.
|
| 20. | Saving the Cart
Posted by the_swarve_mongoose on 10/13/2003 4:42:36 AM
Hi Julian,
I'm struggling with the checkout facility. I've copied the main elements from the demo, but have an error with the retrieve OrderID function; and don't know how to solve it. I think my OrderRS is wrong.
I have a form on another page I would like to use for credit card data also. What steps do I need to go through to save all the info to the database, and forward to my credit card page?
Many, Many Thanks for all your help;
|
| 21. | Re: Saving the Cart
Posted by the_swarve_mongoose on 10/14/2003 3:50:55 AM
Hi Julian,
I don't get an error - the page will display; and all the user login stuff works aswell.
I just don't know how to save the database. What's the Order ID thing all about!?
My OrderRS just searches for everything in the Order Table. Has to be wrong.
I want to save everything to the database; and have a link to another of my pages, with a credit card form.
Many Thanks,
The Mongoose of ... |
| 22. | Re: Saving the Cart
Posted by the_swarve_mongoose on 10/14/2003 5:41:05 AM
Ok,
Getting there. I think I've sorted out the Order ID behaviour, and I'm using the "Save cart to Database" thing.
Trouble I'm getting now is it adds two orders. Also, if I process any items I get the following error message:
Error Type:
Provider (0x80020005)
Type mismatch.
/a1_new/CheckOut.asp, line 107
Any ideas?
Many Thanks,
The Swarve Mongoose
|
| 23. | Re: Saving the Cart
Posted by the_swarve_mongoose on 10/15/2003 3:58:24 AM
I've solved it Jules.
It's because the ProductID field should have been text (I'm using a text based ID).
Any ideas why all my orders produce two orders on the database?!
The Swarve Mongoose |
| 24. | Re: Saving the Cart
Posted by the_swarve_mongoose on 10/15/2003 3:59:52 AM
...Oooh
-And are there any email facilities I could use to send a confirmation email to the customer?
Many Thanks,
Swarve Mongoose |
| 25. | Re: Saving the Cart
Posted by the_swarve_mongoose on 10/15/2003 4:50:17 AM
Lovely.
Have you any ideas why I get two orders in the database, every time I confirm an order?
Many Thanks,
Swarve Mongoose |
|
|
|
|