Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

MYSQL error

I am getting this error:

SQL##f - SqlState: 37000, ErrorCode: 1064, ErrorMsg: [MySQL][ODBC 5.1 Driver][mysqld-5.5.27-enterprise-commercial-advanced-log]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 'FROM abcdsd.poiuytr where id > 612233' at line 10
Fs_new:

   
SQL SELECT id,
    pid,
    `b_time`,
    `a_time`,
    `b_sub`,
    `a_sub`,
    `b_error`,
    `a_error`,
    `dmsg`,
FROM abcdsd.poiuytr
where id > 612233

Can anybody suggest a solution??

5 Replies

Re: MYSQL error

HI

Try like this

SQL SELECT id,

    pid,

    b_time,

    a_time,

    b_sub,

    a_sub,

    b_error,

    a_error,

    dmsg,

FROM abcdsd.poiuytr

where id > 612233;

hope it helps

Not applicable

Re: MYSQL error

Not Working....

Also,

my script is:

 

SQL

SELECT id,
pid,
b_time,
a_time,
b_sub,
a_sub,
b_error,
a_error,
dmsg,
FROM abcdsd.poiuytr
where id >
$(maxid);

Re: MYSQL error

HI

Without where condition, it works or not? if works, check id is number or varchar. if varchar,

'$(maxid)' in where condition

Employee
Employee

Re: MYSQL error

Try this :

SQL SELECT `id`,

    pid,

    `b_time`,

    `a_time`,

    `b_sub`,

    `a_sub`,

    `b_error`,

    `a_error`,

    `dmsg`,

FROM abcdsd.poiuytr

where `id` >= '612234'


Do you also try the wizard , selecting preceding load ?

satyadev_j
Valued Contributor

Re: MYSQL error

Hi,

Try below,

LOAD

     *

WHERE id > 612233;

SQL SELECT id,

    pid,

    `b_time`,

    `a_time`,

    `b_sub`,

    `a_sub`,

    `b_error`,

    `a_error`,

    `dmsg`,

FROM abcdsd.poiuytr;

Community Browser