gimx Posted January 26, 2008 Share Posted January 26, 2008 Hello, I have this error but i don't know why Thx for help _SQLite_Exec(-1, "Insert into partant values(" & $numero & "," & $cheval & "," & $chevalmus & "," & $driver & "," & $drivermus & "," & $trainer & "," & $trainermus & ");") --> Function: _SQLite_Exec --> Query: Insert into partant values(101,Quelia du Buisson,0m(07)2m2m6mDa2a,M.N. Henry,0a1m7m8mDm0mDm2m,B. Desmontils,[0a0a]8m0m0mDm2aDm); --> Error: near "du": syntax error Link to comment Share on other sites More sharing options...
The Kandie Man Posted January 27, 2008 Share Posted January 27, 2008 (edited) You don't have quotes in your actual string. SQLite needs quotes around each entry in the string itself. _SQLite_Exec(-1, "Insert into partant values('" & $numero & "','" & $cheval & "','" & $chevalmus & "','" & $driver & "','" & $drivermus & "','" & $trainer & "','" & $trainermus & "');") This should work as long as none of your values have single quotes in them. The only time that it doesn't require quotes is when the data value has been declared as an integer. This is probably the case and why it didn't error out at $numero. If it is declared as an integer, it should still work with quotes around it. - The Kandie Man ;-) Edited January 27, 2008 by The Kandie Man "So man has sown the wind and reaped the world. Perhaps in the next few hours there will no remembrance of the past and no hope for the future that might have been." & _"All the works of man will be consumed in the great fire after which he was created." & _"And if there is a future for man, insensitive as he is, proud and defiant in his pursuit of power, let him resolve to live it lovingly, for he knows well how to do so." & _"Then he may say once more, 'Truly the light is sweet, and what a pleasant thing it is for the eyes to see the sun.'" - The Day the Earth Caught Fire Link to comment Share on other sites More sharing options...
gimx Posted January 27, 2008 Author Share Posted January 27, 2008 Yes it's an integer. Thx Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now