Insert number into access databases

Results 1 to 2 of 2

Thread: Insert number into access databases

  1. #1
    Join Date
    Dec 1969
    Posts
    5

    Default Insert number into access databases

    Iam trying to insert a number into datatype number OR text of access database.<BR>&#060;%<BR>info(1)=Request.form("NUMB ER")<BR>info(2)=1-CDBL(info(1))<BR>INSERT INTO Tbl(Quantity) VALUES("info(2)")<BR>%&#062;<BR>I&#039ve tried two hours worth of things and keep getting different errors.<BR>datatype mismatch, something function in info(2), <BR>please help

  2. #2
    blah Guest

    Default RE: Insert number into access databases

    since info(2) is a variable... unless you want to insert the text "info(1)",<BR><BR>for JScript:<BR>VALUES "+info(2)+";<BR><BR>for VBscript<BR>VALUES "&info(2)&"

Posting Permissions

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