syntax sql insert mysql problem

[faustf]

hi guy  i  try to insert in db  this  string  

 

Local $syntax = "INSERT INTO ge_anagrafica_clienti ($sLeg_ragion_social,sop_via,sop_citta,sop_prov)VALUES('"&$sLeg_ragion_social&"','"&$sLeg_via&"','"&$sLeg_citta&"','"&$sLeg_prov&"');"

with  Ado by @mLipok 

but have  problem woth syntax   but i think  is  good 

###############################
ADO.au3 v.2.1.13 BETA (1155) : ==> COM Error intercepted !
$oADO_Error.description is:     [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.28]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEMADE', ',''', ',''', ',''', ')' at line 1
$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:     80020009
$oADO_Error.lastdllerror is:     0
$oADO_Error.scriptline is:     1155
$oADO_Error.source is:     Microsoft OLE DB Provider for ODBC Drivers
$oADO_Error.helpfile is:     
$oADO_Error.helpcontext is:     0
###############################
 

syntax 

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');

[faustf]

sorry i  answer me  

the problem is  

($sLeg_ragion_social

thankz at all and  sorry for the post 

 

 

[mLipok]

Just now, faustf said:

sop_prov)VALUES('"&$sLeg_ragion_social

Also remember to add space before VALUES

 

[faustf]

ups

[faustf]

i  use  this  syntax but not   work  

Local $syntax = "INSERT INTO ge_anagrafica_clienti (sop_ragion_social,sop_via,sop_citta,sop_prov)VALUES(' "&$sLeg_ragion_social&"','"&$sLeg_via&"','"&$sLeg_citta&"','"&$sLeg_prov&"')"

 

[mLipok]

9 hours ago, mLipok said:

Also remember to add space before VALUES

; Try like this following example:
Local $sQUERY = ""
$sQUERY &= "INSERT INTO ge_anagrafica_clienti (sop_ragion_social, sop_via, sop_citta, sop_prov)" & @CRLF
$sQUERY &= "VALUES('%s','%s','%s','%s')" & @CRLF

$sQUERY = StringFormat($sQUERY, 'String1', 'String2', 'String3', 'String4')
ConsoleWrite($sQUERY & @CRLF)

[faustf]

i dont understund your  example  sorry

 

[faustf]

VALUES (' "&$

i insert a space  after value   and also 

VALUES(' "&$

VALUES (' "&$

but  do the same

 

[mLipok]

I said BEFORE not AFTER

btw.

Here is your new example:

Local $sQUERY = ""
$sQUERY &= "INSERT INTO ge_anagrafica_clienti (sop_ragion_social, sop_via, sop_citta, sop_prov)" & @CRLF
$sQUERY &= "VALUES('%s','%s','%s','%s')" & @CRLF

;~ $sQUERY = StringFormat($sQUERY, 'String1', 'String2', 'String3', 'String4')
$sQUERY = StringFormat($sQUERY, $sLeg_ragion_social, $sLeg_via, $sLeg_citta, $sLeg_prov)
ConsoleWrite($sQUERY & @CRLF)

This is how I recently prefer to create SQL Queries in my projects.

 

[faustf]

and  i  find  another  bug  ,  (i think ) but  i think is  scite   bug  ,    in my   program , in a  function i have  comment  with tag  #ce #cs  a part , after  3  run   showme   all green  after #cs ,  not consider a #ce , but  program work properly  , i think scite , not  work perfect , for resolv  uncomment and recoment  o_O

 

[mLipok]

Yes this is know issue that SciTE lexer not always properly colors Syntax (EDIT: with #CS #CE - it happend to me few times per week, but still I can not isolate repro)

Just TIDY your code by CTRL+T

edit: you can also just press some more ENTERs in different place then , SciTE will refresh colors.

Edited March 23, 2016 by mLipok

[faustf]

other  questions about  insert  , when i insert  , and  syntax  is correct ,  the  database tell me  

Local $sOPA_ragion_social = "'" & GUICtrlRead($ANAC_Input1) & "', "
    Local $sOPA_Cognome = "'" & GUICtrlRead($ANAC_Input2) & "', "
    Local $sOPA_via = "'" & GUICtrlRead($ANAC_Input3) & "', "
    Local $sOPA_citta = "'" & GUICtrlRead($ANAC_Input4) & "', "
    Local $sOPA_provincia = "'" & GUICtrlRead($ANAC_Input5) & "', "
    Local $sOPA_stato = "'" & GUICtrlRead($ANAC_Input6) & "', "
    Local $sOPA_piva = "'" & GUICtrlRead($ANAC_Input7) & "', "
    Local $sOPA_codfi = "'" & GUICtrlRead($ANAC_Input8) & "', "
    Local $sOPA_tel = "'" & GUICtrlRead($ANAC_Input9) & "', "
    Local $sOPA_cell = "'" & GUICtrlRead($ANAC_Input10) & "', "
    Local $sOPA_mail = "'" & GUICtrlRead($ANAC_Input23) & "', "
    Local $sOPA_cap = "'" & GUICtrlRead($ANAC_Input11) & "'"


    Local $syntax = "INSERT INTO ge_anagrafica_clienti (sop_ragion_social,sop_cognome,sop_stato,sop_via,sop_citta,sop_prov,sop_mail,sop_cell,sop_piva,sop_codfi,sop_tel,sop_cap)" & _
    " VALUES ("& $sOPA_ragion_social &  $sOPA_Cognome &  $sOPA_via & $sOPA_citta & $sOPA_provincia & $sOPA_stato & $sOPA_piva & $sOPA_codfi & $sOPA_tel & $sOPA_cell & $sOPA_mail & $sOPA_cap &")"
    ;Local $syntax = "INSERT INTO ge_anagrafica_clienti (sop_ragion_social,sop_via,sop_citta,sop_prov) VALUES (" & $sLeg_ragion_social & "'viamia','city','where')"
    GUICtrlDelete($ANAC_List1)
    _listwiev_anagrafica_clienti()

    Local $queryde = _Mysql_Query($syntax)

 

###############################
ADO.au3 v.2.1.13 BETA (1155) : ==> COM Error intercepted !
$oADO_Error.description is:     [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.28]Duplicate entry '0' for key 'PRIMARY'
$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:     80020009
$oADO_Error.lastdllerror is:     0
$oADO_Error.scriptline is:     1155
$oADO_Error.source is:     Microsoft OLE DB Provider for ODBC Drivers
$oADO_Error.helpfile is:     
$oADO_Error.helpcontext is:     0
###############################

off course because  the  row 0  exist, but if i want   continue  to insert  , and  start again at  8 number or ...

how can i do?? 

 

[mLipok]

Which column is PrimaryKEY ? Is it autoincrement ?

 

[faustf]

yes

[faustf]

i think i control one second 

 

[mLipok]

I ask about two different things - you answer to the second one .
Answer also to the first one.

 

[faustf]

yes  is primary key  but not  autoincrement   i think is autoincrement a problem 

 

[mLipok]

ok

which column name have currenty set autoincrement ?

[faustf]

id   the  first  colum 

 but  tell me not  can change  in   autoincrement 

 

[faustf]

ok  i clean the  table  , empty , and  now  work good  , thankz  Bro for support