Radio Buttons

Results 1 to 2 of 2

Thread: Radio Buttons

  1. #1
    Juliet Loughman Guest

    Default Radio Buttons

    I am creating a 10 question multi-choice help desk questionnaire.<BR><BR>I have created and connected correctly to an SQL database, the problem that I am having is that:-<BR><BR>I can not send the radio button value to the database. When I just use this SQL query:-<BR><BR>strQuery = "INSERT INTO tQuestions (Q1_Customer_Service_Level) VALUES (&#039" & nbsp &"&#039)"<BR><BR>The value gets inserted into the first field of the table within the database.<BR><BR>But when I try this one:-<BR><BR>strQuery = "INSERT INTO tQuestions (Q1_Customer_Service_Level,Q2_WAS_PROBLEM_RESOLVED ) VALUES (&#039" & nbsp & "&#039,&#039" & nbsp &"&#039)"<BR><BR>no values are sent to the table in the database.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Radio Buttons

    If you are trying to insert from a form post:<BR>strQuery = "INSERT INTO tQuestions (Q1_Customer_Service_Level,Q2_WAS_PROBLEM_RESOLVED ) VALUES (&#039" & request.form("Q1_Customer_Service_Level") & "&#039,&#039" & request.form("Q2_WAS_PROBLEM_RESOLVED").Value & "&#039)"<BR><BR>or<BR><BR>If you are trying to insert blank (whitespace) value<BR>strQuery = "INSERT INTO tQuestions (Q1_Customer_Service_Level,Q2_WAS_PROBLEM_RESOLVED ) VALUES (&#039 &#039,&#039 &#039)"<BR><BR>Hope this helps...Cheers!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts