Artikel in Ihrem Warenkorb

java.sql.SQLException: Syntaxfehler: Encountered "search" at line 27, column 4.
SELECT
PRODUCT.ID,
PRODUCT.NAME,
PRODUCT.MANUFACTURER_ID,
PRODUCT.PRODUCT_NO,
PRODUCT.WEIGHT,
PRODUCT.COLI,
PRODUCT.VOLUME,
PRODUCT.PRICE_PURCHASE,
PRODUCT.TAX,
PRODUCT.DATE_ADDED,
STORE.AMOUNT,
'prod' as NAMESPACE,
PRODUCT.MODIFIED_AT,
PRODUCT.MODIFIED_COLUMNS,
PRODUCT.CREATED_BY,
STORE.NAMESPACE,
STORE.FOREIGN_ID,
STORE.ID,
STORE.MODIFIED_AT,
STORE.MODIFIED_COLUMNS,
STORE.CREATED_BY
FROM
PRODUCT left join STORE on STORE.NAMESPACE='prod' and STORE.FOREIGN_ID=PRODUCT.ID
WHERE
(PRODUCT.CREATED_BY like 'JQ.ameis.%' or PRODUCT.CREATED_BY like 'JQ.all') and
({search}) and
1=1
ORDER BY
PRODUCT.PRODUCT_NO
at jq.io.DBAccess.executeInternal(DBAccess.java:358)
at jq.io.DBAccess.executeQuery(DBAccess.java:277)
at jq.edc.task.DBSelect.execute(DBSelect.java:828)
at jq.task.AbstractTask.run(AbstractTask.java:63)
at jq.edc.io.PersistorEDC.getData(PersistorEDC.java:265)
at jq.edc.server.http.ContextEDC.getData(ContextEDC.java:225)
at jq.edc.server.http.HTMLProcessorEDC.processProfile(HTMLProcessorEDC.java:385)
at jq.edc.server.http.HTMLProcessorEDC.process(HTMLProcessorEDC.java:288)
at jq.edc.server.http.ContextEDC.deliverContent(ContextEDC.java:833)
at jq.edc.server.http.EDCServlet.service(EDCServlet.java:148)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)

Nettosumme

Lieferkosten

19% Mehrwertsteuer

Gesamtbetrag der Bestellung

Ab einem Bestellwert von 150 EUR entfallen die Lieferkosten

Vorname

Name

Firma

Straße

PLZ / Stadt

Land

Telefon bei eventuellen Rückfragen

Rechnungsadresse

Lieferadresse

Ich habe die allgemeinen Geschäftsbedingungen gelesen und stimme ihnen hiermit zu.