Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    adjust joint query string wit &... (2000)

    whit this quesry have error of sintiax???!!!

    please adjust the joint of string:

    SQL1 = "INSERT INTO STAFF (MATR,NOMINATIVO,COD_GRADO,SETTORE,DATA_AGG,COD_AG ,DESCR_AG,COD_1,DESCR_COD_1,COD_2,DESCR_COD_2," _
    & "COD_3,DESCR_COD_3,COD_4,DESCR_COD_4,COD_5,DESCR_C OD_5,COD_6,DESCR_COD_6,REGIONE,UFFICIO,MANSIONE,RE GIONE_GEOGRAFICA,CELLULARE,DIREZIONE)VALUES('" & MATRICOLA & "','" & NOMINATIVO & "','" & COD_UFF & "','" & SETTORE_2 & "','" & DATA_FILE & "','" & AREA & "','" & DESCR_AREA & "','" & RAMO_3_BANCA & "','" & DESCR_RAMO_3_BANCA & "','" & RAMO_4_BANCA & "','_ &" & DESCR_RAMO_4_BANCA & "','" _
    & " '" &
    RAMO_5_BANCA & "','" & DESCR_RAMO_5_BANCA & "','" & RAMO_6_BANCA & "','" & DESCR_RAMO_6_BANCA & "','" & RAMO_7_BANCA & "','" & DESCR_RAMO_7_BANCA & "','" & RAMO_8_BANCA & "','" & DESCR_RAMO_8_BANCA & "','" & REGIONE & "','" & DESCR_COD_UFF & "','" & MANSIONE & "','" & REGIONE_GEO & "','" & CELL & "','" & DIREZIONE_1 & "')"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: adjust joint query string wit &... (2000)

    You have a superfluous <code>_ &</code> after RAMO_4_BANCA and a superfluous <code>& " '"</code> before RAMO_5_BANCA

Posting Permissions

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