|
| |
|
|
wlp
Posts: 54
From: None
Status: offline
 |
copying info from DB fields to send to email - 4/17/2001 22:02:00
Here is a challange I think. I have a large amount of products (catalog) which customers search through and order via email. right now they must note the product # and description and enter in to a form I provide which sends us the emaoil. Is there a script I can write to (when pressing order button) copy certai fields returned from that specific record and place it in the awaiting fields of the form which the customer then would complete with shipping info. my answer to no cost shopping cart functionality. the site is http://www.un-point-cest-tout.atfreeweb.com access shopping/kits/ and you will see what I meant if you want to send an order to try do not hesitate I will pick it up before anyone else.Thanks John
|
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: copying info from DB fields to send to email - 4/18/2001 20:05:00
Is your server able to do asp?eg an order button could carry a querystring : order.asp?Product=xxxx&Description=Description Now on order.asp you would add this code to the form default value : <%=Request.Querystring("Product")%> and <%=Request.Querystring("Description")%> ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
RE: copying info from DB fields to send to email - 4/18/2001 20:06:00
Yes my isp handles asp. I am not a coder but I will spend some time trying this. I was sure it could be done just doidn't know how to do it.Thanks you help and response time is really the best in the world. John
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
RE: copying info from DB fields to send to email - 4/19/2001 22:27:00
On the button how do I target the specific record when I am retrieving 20 records at one time? Does the button need to be a hyperlink in the data base?Sorry for my ignorance
| |
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: copying info from DB fields to send to email - 4/20/2001 20:17:00
See, now you need a cart ![]("http://www.frontpagewebmaster.com/ubb/smile.gif")
You need to run some sort of subroutine to save each item to a cookie, for example.
Each cookie or key would contain the required information that you would then return when the user is ready to email.One product is relatively easy, after that it gets more difficult. I hope you didnt think step 1 was difficult ? ![]("http://www.frontpagewebmaster.com/ubb/biggrin.gif") ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
RE: copying info from DB fields to send to email - 4/22/2001 23:04:00
Pasting the info from the one product of the db results works great but now I cannot send the form info to an email using the ASP. Sending to the email works fine when visitor fills the form hinmself on an htm page, but when I create a asp to recieve the info from the db and the vistor comletes the page with name address etc. and submits(frontpage_form1) the email does not get sent, the confirmation page does not appear, where when using the htm page it all works fine. Is it related to the form validation file it is using? (I know nothing about that)Thanks Spooky
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
