New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
htmlsql_select_page field is filtered problem #493
Comments
你应该调整代码为 htmlsql_select_page!(project_version_select_page(project_code: &str) -> ProjectVersionSelectPageDTO => r#"
<select id="project_version_select_page">
`select `
<if test="do_count == true">
` count(1) `
</if>
<if test="do_count == false">
` * `
</if>
`FROM project_version WHERE is_delete = 0 AND project_code = #{project_code} pv.id, pv.remarks, p.project_code, p.project_name, pv.version_name, pv.version_code, pv.version_number, pv.remarks, pv.create_at FROM project_version pv LEFT JOIN project p ON (pv.project_code = p.project_code) WHERE pv.is_delete = 0 AND p.project_code = #{project_code} `
<if test="do_count == false">
` LIMIT ${page_no},${page_size} `
</if>
</select>
"#); |
跟写法没关系 |
htmlsql_select_page!(project_version_select_page(project_code: &str) -> ProjectVersionSelectPageDTO => r#"
SELECT count(1) FROM project_version WHERE is_delete = 0 AND project_code = #{project_code} pv.id, pv.remarks, p.project_code, p.project_name, pv.version_name, pv.version_code, pv.version_number, pv.remarks, pv.create_at FROM project_version pv LEFT JOIN project p ON (pv.project_code = p.project_code) WHERE pv.is_delete = 0 AND p.project_code = #{project_code} LIMIT ${page_no},${page_size} `
"#);
create_at 被过滤
试了几次,调整了字段循序,最后一个字段会被过滤
The text was updated successfully, but these errors were encountered: