weixin_33716941 2017-01-16 20:19 采纳率: 0%
浏览 39

Querybuilder使用变量

I'm trying to use the http://querybuilder.js.org/index.html plugin with coldfusion. I'm stuck on this part:

$('.parse-sql').on('click', function() {
var target = $(this).data('target');
var result = $('#builder-'+target).queryBuilder('getSQL',$(this).data('stmt'));

if (result.sql.length) {
var test =result.sql;
alert(test);
$('#debugDiv').empty().append('waarde'+ test + '</div>');
bootbox.alert({
  title: $(this).text(),
  message: '<pre class="code-popup">' + format4popup(result.sql) + (result.params ? '

' + format4popup(result.params) : '') + '</pre>'
});

}
});

What I'm trying to do is use the sql query in the result page. I have try some things like putting the result.sql in a variable test. Then display the TEST variable to a debugdiv, and that is working. The output is like "name LIKE('%Johnny%') AND ( category = 2 OR in_stock = 1 )".

Now the question: how can I use this in a result page? Must I export the variable with an AJAX request? Can someone help me a bit on this?

Thanks!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 安卓adb backup备份应用数据失败
    • ¥15 eclipse运行项目时遇到的问题
    • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
    • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
    • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
    • ¥50 成都蓉城足球俱乐部小程序抢票
    • ¥15 yolov7训练自己的数据集
    • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
    • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
    • ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)