Skip to content
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

search text '$0' replace with ? #676

Closed
skemnaik opened this issue Apr 11, 2018 · 3 comments
Closed

search text '$0' replace with ? #676

skemnaik opened this issue Apr 11, 2018 · 3 comments
Labels
bug Identified bug which needs a fix
Milestone

Comments

@skemnaik
Copy link

skemnaik commented Apr 11, 2018

Search text '$0' replace with '?' while executing getSQL() method. I am using IE 11.
Not sure if there are any other key combinations replace these but I have found this first one.

I am trying to search InstrumentDescription equal 'BHP BILLITON ORD $0.50'
But execution of getSQL() returns, InstrumentDescription = 'BHP BILLITON ORD ?.50'

@mistic100
Copy link
Owner

How do you use getSQL ? If you don't use statements, do not set the first parameter

@skemnaik
Copy link
Author

skemnaik commented Apr 11, 2018

Thanks for your quick reply. But sorry, I do not understand about first parameter that you suggested.

I am using following way to get sql text and display on my html page.

var result = $('#builder-widgets').queryBuilder('getSQL');
var retrunQuery = ''
if (result != null && result.sql.length) {
retrunQuery = result.sql;
}

$('#query').html(retrunQuery);

@skemnaik
Copy link
Author

skemnaik commented Apr 16, 2018

I can replicate issue on Demo pages of JQuery builder. Clicked on "SQL" button.
jquerybuilder_issue1

@mistic100 mistic100 added the bug Identified bug which needs a fix label Apr 21, 2018
@mistic100 mistic100 added this to the 2.5.2 milestone Apr 21, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Identified bug which needs a fix
Projects
None yet
Development

No branches or pull requests

2 participants