你好。麻烦问下,SELECT * FROM 订单 where 1=1
${if(type=="日报"," and date(订购日期)='"+ date +"'",
if(type=="月报"," and strftime('%m',订单.订购日期)='"+ month+"'"+" and strftime('%Y',订单.订购日期)='"+ year+"'"," and strftime('%Y',订单.订购日期)='"+ year+"'"))}
像这种,感觉不是通常的sql语句啊。想请教下finereport 中的sql,这种带函数的技巧
大神,我用了你开发的数据库迁移至mysql的插件,大部分表同步过去了,但是会报错:正常:建表错误!FR_WRITE_TEMP_DATA 错误信息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 'LONGVARCHAR NOT NULL ,PRIMARY KEY (`ID`) )ENGINE=InnoDB DEFAULT CHARSET=gbk' at line 1
2016-05-25 16:36:34
删除重新导入还是不行,是为啥?