Radio Buttons/Values 1

[mindeye]

Hello,

When creating radio buttons, you create a group. Only one item out of the group can be selected. What do you select the checked value as, and what do set it to in Insert Record Behavior to? How would you set it up in the Database? Say my fields are:

Yes 0
No 0

I am confused cause you can select only one field to pass out of each group. Any help would be appreciated. Thanks in advance.

Roger

 

[schase]

well database can be a simple text field

then in the form you may have
Question 1, do you like Tek-Tips?
<input type=&quot;radio&quot; name=&quot;txtChoose&quot; value=&quot;yes&quot;>
<input type=&quot;radio&quot; name=&quot;txtChoose&quot; value=&quot;no&quot;>
<input type=&quot;radio&quot; name=&quot;txtChoose&quot; value=&quot;maybe&quot;>
<input type=&quot;radio&quot; name=&quot;txtChoose&quot; value=&quot;say what&quot;>

When it is inserted, it will only pass one value for question one (the one checked) for say txt Choose. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

Stuart,

I am still having probs. I get an error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/survey/test4.asp, line 90
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
POST 41 bytes to /survey/test4.asp
POST Data:
answer=pos&sendform=Submit&MM_insert=true


This is my form code
<form ACTION=&quot;<%=MM_editAction%>&quot; METHOD=&quot;POST&quot; name=&quot;yesno&quot;>
<p>
<input type=&quot;radio&quot; name=&quot;answer&quot; value=&quot;pos&quot;>
yes</p>
<p>
<input type=&quot;radio&quot; name=&quot;answer&quot; value=&quot;neg&quot;>
no</p>
<p>
<input type=&quot;submit&quot; name=&quot;sendform&quot; value=&quot;Submit&quot;>
</p>
<input type=&quot;hidden&quot; name=&quot;MM_insert&quot; value=&quot;true&quot;>

I am setting my Insert Behavior as Text and my Database to Text. This is making me crazy. Thanks for your help...

Regards,
Roger

 

[schase]

your into naming conventions - or rather needing them. (reserved name fields)

in databases - I always start my databases with db

like dbSchase.mdb

tables are started with tbl like tblChase
and fields inside the table are fld like fldChase.

Queries begin with qry

and so on.

as far as the asp side - i name all text fields with txt

like txtChase

http://www.macromedia.com/support/ultradev/ts/documents/insert_into.htm

&quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[mindeye]

Stuart,

You-the-Man!! I don't know how you know all of this stuff, but I'm glad you do...Thanks...

Regards,
Roger

 

[schase]

lol cause i've been there done that more than once.

glad to help &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart