copying info from DB fields to send to email (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

wlp -> 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 -> 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 -> 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 -> 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 -> RE: copying info from DB fields to send to email (4/20/2001 20:17:00)

See, now you need a cart
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 ?

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!




wlp -> 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




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625