>hi!
>Here I have a field "Status" in my insert form for which there are 3
radiobuttons
>1)Citizen
>2)Greencardholder
>3)Other
>The candidate can click on any of the radiobutton and that should be
inserted
>in the database after clicking the submit button.
>Can any one please help me,I know it must be easy but I am not able to do
it
>Shally
Shally,
This should work for you....
<input type="radio" name="status" value="Citizen">Citizen<br>
<input type="radio" name="status"
value="Greencardholder">Greencardholder<br>
<input type="radio" name="status" value="Other">Other<br>
This defines the value of the parameter form.status
Then the query would be something like....
<cfquery name="AddToDatabase" datasource="#ODBC#">
INSERT INTO tablename
(Status) <!--- this being the field name in the database --->
values ('#status#') <!--- this being the name of the variable to
insert --->
</cfquery>
I would recommend picking up a book on basic HTML that covers form design.
Ben Forta's books are also an excellant resource for learning how to do
various SQL queries. Hope this helps.
Steve
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
