Subject | Another one |
---|---|
Author | Francisco Antonio Vieira Souza |
Post date | 2004-05-27T12:46:25Z |
IsnĀ“t possible to execute a query like this using Jaybird?
nome = "MA";
sql = "SELECT * FROM CLIENTES cli WHERE FANTASIA LIKE "+nome+"%";
Statement stm = c.createStatement();
ResultSet rs = stm.executeQuery(sql);
GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 283
%
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
nome = "MA";
sql = "SELECT * FROM CLIENTES cli WHERE FANTASIA LIKE "+nome+"%";
Statement stm = c.createStatement();
ResultSet rs = stm.executeQuery(sql);
GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 283
%
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004