Comments (2)
- The fix will involve changing how SELECT statements will reference the bind variables.
- Current use has the '?' in the SELECT matching bind data in the order listed in the gsSQL() function.
- The bind variable will be changed so that the bind ? will use a specific variable in the list. This will be done by also including the position number on the bind variable.
- The added benefit to this is when one bind data point is needed more than once in the SELECT statement. Currently, you would have to add the bind data as many times as needed in the select.
- The new format will be like:
=gsSQL("select * from table where fldName = ?1 and amountFld < ?2 and otherAmount > ?2", {{"table", "A1:I20", 60}}, true, "Fred", 100)
- You can see in this example, we would only need to list TWO bind data items since we can reference one bind data point more than once, where the current use would require 3 bind data items.
- The ?1 would reference the first bind data point listed and ?2 would reference the second.
from gssql.
- Changed how bind variables are reference in SELECT.
- Now first bind variable is reference as ?1, the second is referenced as ?2 and so on.
from gssql.
Related Issues (20)
- Select from SUBQUERY that contains JOIN fails.
- charIndex Function fails when data starts with digits.
- max(date_column) fails.
- Select * (wildcard) fields incorrect on JOIN.
- Join on multiple conditions fails.
- Where NOT LIKE fails when field is NULL.
- LEFT/RIGHT Join using condition to select left/right table. HOT 1
- Complex JOIN on Conditions not working.
- Refresh result when data changes.
- Data with single quotes AND calculated fields.
- GROUP BY with Calculated Field Fails.
- select ORDER BY expression
- Sonarcloud and REGEX use.
- Misleading error message for invalid ORDER BY
- Where LIKE is not filtering properly.
- Select FROM sub-query that uses LIKE may fail.
- Select from SUB-QUERY and no table alias.
- SQL function parameter with quoted comma.
- dateDiff() works in morning, not in afternoon.
- where NOT LIKE excluding some it shouldn't.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gssql.