Simple Form

[PoshSpur]

Hi guy's,

I am completely new to ColdFusion.

I have created a mini-site ([url]www.wealthmasterylive.co.uk[/url]). I have a form in it
that has the following fields;

First_Name
Last_Name
Email

I also have created an access database with those 3 fields.

I want the user to enter their info into the fields and upon submitting it,
the details will be inserted into the access database.

I tried using ASP but I am having problems with the hosting guy's, so I
thought I would try ColdFusion instead.

Does anyone have set code for this that they can give me?


Regards

[jdeline]

You first need to create a data source on the box on which ColdFusion server is
running. This is done by going to
x:\inetpub\wwwroot\cfide\administrator\index.cfm. You may not have privedges
to get to this page, so you may have to have the sysadmin of the box do it for
you.

Once you get there, go to the ODBC datasource section and follow the
instructions.

Assume you create a datasource named "foo". The concept code below shows you
what to do.



<CFQUERY NAME="myQuery" DATASOURCE="foo">
INSERT INTO myTable (First_Name, Last_Name, Email)
VALUES ('#First_Name#', '#Last_Name#', '#Email#')
</CFQUERY>

[Dan Bracuk]

You might consider buying this book and doing all the tutorials.
[url]http://www.amazon.com/gp/product/0672317966/104-4379955-8412739?v=glance&n=283155[/url]

[PoshSpur]

Hi,

I just downloaded the video tutorial on Learning Coldfusion MX from Lynda.com and so I will check that out. Thanx!

[jimhoy]

I have been trying for a month to build a very simple dynamic form that can be
filled in by a person visting a web site, and then for that information to be
e mailed back to me. I do not want a data base to store information on the
server, I just want the information to be forwarded back to me by e mail.. (For
example, "Name", "Address" etc.)
I use Dreamweaver 8, on a Macintosh computer, and have found Dreamweaver
almost useless in this department.
I have built web site for years, but have never dealt with dynamic pages. Any
pointers will be greatly appreciated
Jim

[Murray *ACE*]

There are only two ways to process form data -

1. Use mailto:name@domain.com as the action of the form
2. Use a server-side scripting method to a) harvest the form's data, b)
process it in some manner, e.g., enter it into a database, c) formulate and
send an email to one or more email recipients, and d) redirect the visitor
to some ending page

Method 1 is quite simple, and is also the least reliable. It depends both
on your visitor having an email client already installed on their computer -
this eliminates public computers, or home users without email clients
installed (more and more it seems) - and on the installed email client
responding to
the mailto call. It is not possible to use this method *and* send the
visitor to a
thank you page as well.

Method 2 is the preferred method, since it eliminates the problems of method
1, but it means that you have to grapple with server-scripting somehow (ASP,
CF, PHP, perl, etc.).

You would have to decide which of these methods is best for your needs,
but if it's Method 2, then start by asking your host what they provide for
form
processing.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================


"jimhoy" <webforumsuser@macromedia.com> wrote in message
news:dvqmkf$ou1$1@forums.macromedia.com...

>I have been trying for a month to build a very simple dynamic form that can
>be
> filled in by a person visting a web site, and then for that information
> to be
> e mailed back to me. I do not want a data base to store information on the
> server, I just want the information to be forwarded back to me by e mail..
> (For
> example, "Name", "Address" etc.)
> I use Dreamweaver 8, on a Macintosh computer, and have found Dreamweaver
> almost useless in this department.
> I have built web site for years, but have never dealt with dynamic pages.
> Any
> pointers will be greatly appreciated
> Jim
>

[jimhoy]

OK, method 2 is the way to go.
My Host provides for all form processing. So PHP would probably be my most
likely choice.
I cannot find directions, or a tutorial in Dreamweaver 8 to accomplish this. I
have gone through the tutorial several times, and it really leads nowhere. This
should be the most basic of basics of forms to work with. When I got DW 8, I
was under the impression that I would be guided through most of the simple
tasks anyway. I am not a programmer.
Thanks so far,
Jim Hoyhtya

[Judy]

Take a look at NateMail at
[url]http://www.mindpalette.com/formprocessing/index.php[/url]

very simple to set up with Dreamweaver. print out the 10 page guide and
follow closely

Judy
"jimhoy" <webforumsuser@macromedia.com> wrote in message
news:dvqmkf$ou1$1@forums.macromedia.com...

> I have been trying for a month to build a very simple dynamic form that

can be

> filled in by a person visting a web site, and then for that information

to be

> e mailed back to me. I do not want a data base to store information on the
> server, I just want the information to be forwarded back to me by e mail..

(For

> example, "Name", "Address" etc.)
> I use Dreamweaver 8, on a Macintosh computer, and have found Dreamweaver
> almost useless in this department.
> I have built web site for years, but have never dealt with dynamic pages.

Any

> pointers will be greatly appreciated
> Jim
>

[jimhoy]

This is exactly the answer I was looking for. I was up and running with the
forms in just an hour.
It was so easy to follow the directions. Dreamweaver could learn something
from these directions.
Thanks again,
Jim