Sign in to follow this  
Followers 0
faustf

sqlite syntax problem questions

3 posts in this topic

#1 ·  Posted (edited)

hi guys  i  must insert  in db sqlite3  this  code

INSERT INTO eBayTemp4MultyUserList (utente,eva_location,mail,password,token,valuta) VALUES ( _SQLite_FastEscape(yyydydyi) & "," & _SQLite_FastEscape(eva_Italia) & "," & _SQLite_FastEscape(YYYYYYY) & "," & _SQLite_FastEscape(XXXXxxxx) & "," & _SQLite_FastEscape(AgAAAA**AQgghhA**aAAAAA**ObY4Vw**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wBmIumDpWGoQydj6x9nY+seQ**UUYDAA**AAMAAA**DVf73y1LdrHHGBMLmSeFzBIEp4UhpVZoOdOyKvkSTd1ZVRsyLn8feS2sDGesVM5SCr0CqpAYfaeu/Kd/J7VqEbuy2cMig4ULghbx6HUebLjRFOVGKHESxugjUmDqRAIU5QpxCjCabCrdssutfxA4WLaUg+rUJCSv9z96dRxg8CdkY9EK/DDMaWsTQ6OgVIh5sNnNk0hCZGC5e0QwLmXFlYKTETzVOlvlykfB9N3/lo3j6jtFqzqtoaXVq/IO37RPtaAuCW1IclzrU/CkQfZXPUqIMRvac10d438dGXFXjL7tyA0VI76W1QrsL1dDFx18t6SS0SIlBfDQzlcV/rZ4ulcHlDJP/PNb62RNM7JbtGl9bEAMMG51QcwL07u+zqSWW2u5ZmYHJYnjhQ7Mkvtf/nP1Q1FtkdRGOcUF/CmTkQERVWOqG4noRCA/OeLGCUX/K5QeomDoreAxbSc0LAbkLEiJFb9PkYh85l2Nj5SLdnBdjOdBkxHE686jbBYRaWYe6jH9zPNyNGD3XYK5zQXz++wlRcnpNMGhQXIUxy+bektu9ImJDqYiC0PCh42s7CDV/zkJthXa7gwmKQVRKxxxxxxxxxxxxxHn1F94QHiYQPwm3xkTSLNLZJqI6EWT+90me1GtXfdro86s8VHLSlTKZqC/8F7FVXwkRXhvsk1gRQmABFXq3URgAiCryYGHo48evpMl9IM9RRDONYGct2UP96zuYaf/AAlu5qEUmcTwGm+5bfq1rVksQUWI3eqZDYfEKDvokBalD) & "," & _SQLite_FastEscape(EUR)) ;!   SQLite.au3 Error

but have this error , how is possible to fix them???

near "*": syntax error

 

 

Edited by faustf

Share this post


Link to post
Share on other sites



try like that:

$utente = ""
$eva_location = ""
$$mail = ""
$password = ""
$token = ""
$valuta = ""

$sQuery = "INSERT INTO eBayTemp4MultyUserList (utente,eva_location,mail,password,token,valuta) VALUES ('" _SQLite_FastEscape($utente) & "','" & _SQLite_FastEscape($eva_location) & "','" & _SQLite_FastEscape($$mail) & "','" & _SQLite_FastEscape($password) & "','" & _SQLite_FastEscape($token) & "','" & _SQLite_FastEscape($valuta) & "';"

 

Share this post


Link to post
Share on other sites

thankz  i find  a  error  the problem is _SQLite_FastEscape  i remove  them  and insert like this  only with '

'cbbbxxbi'  ,  'ggggggg'  ,  'bbbbbbb'  ,  'vvvvvvv'  ,  'AgAAAA**AssAA**aAA'

 

and now work :D

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0