delimiters problem

Results 1 to 2 of 2

Thread: delimiters problem

  1. #1
    Join Date
    Dec 1969

    Default delimiters problem

    ======MY 2 QUESTIONS=========== <BR> <BR>Do I have the proper DELIMITERS set here, considering <BR>that the datatype in my Access database is YES/NO ? <BR><BR>With form values set as TRUE, does this mean an <BR>1. unchecked box passes a value of TRUE to database? <BR>2. checked box passes TRUE to database? <BR>3. unchecked box passes NULL to database? <BR><BR><BR>=====MY FORM========== <BR>What flavor(s) to search for? <BR>&#060;input type=checkbox name=Chocolate value="true"&#062; <BR>&#060;input type=checkbox name=Vanilla value="true"&#062; <BR><BR><BR><BR>======MY ASP PAGE======= <BR>&#039;leaving out unneccessary detail <BR><BR>&#060;% <BR>strChocolate=Request.Form("Chocolate") <BR>strVanilla=Request.Form("Vanilla") <BR>%&#062; <BR><BR>SQLquery="SELECT flavors FROM icecream WHERE <BR>chocolate = &#039;" & strChocolate & "&#039; AND <BR>vanilla = &#039;" & strVanilla & "&#039; " <BR><BR><BR>Thankyou for any help you can give. -f <BR> <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: delimiters problem

    leave the single quotes out (&#039;)<BR><BR>j

Posting Permissions

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