I get the following error, and maybe I’m blind but I just don’t see what’s causing it
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 ‘OR,TABCOUNT,CID) VALUES (“ORMISA10009”,“1”,"fontsel = Arial,fontsize = 8,Line1 =’ at line 1
this is the SQL query
Insert into tabs (OID,TABSETNO,T1,T2,T3,T4,T5,T6,T7,T8,OR,TABCOUNT,CID) VALUES
("ORMISA10009",
"1",
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Yellow,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = ",
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Clear,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = ",
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Clear,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = ",
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Clear,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = ",
"",
"",
"",
"",
"LR",
"4",
"CID10005")
The SQL query is automatically generated and works with my other DB Queries, cept for this one, the only difference between this one and the other queries is that I don’t have these lines
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Clear,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = "
Appreciate any help…
P.S. The code does not originally break up into lines, I did that so it could be easier to read…
