launch a SQL query from the js file

Question

in my JS file I need to do a search on the DB (select * from table where condition) and store the result in an array(multidimensional) do you have an idea how to do it ? thank you in advance

Write SQL in a Javascript is bad idea. You should use Ajax to send data to server. Then server file will execute the appropriate SQL. Then Server file will response your output. — Sajitha Rathnayake
– Sajitha Rathnayake, Commented Apr 30, 2014 at 9:17

SBarney · Accepted Answer · 2014-06-18 09:36:12Z

2

the best solution is to use the dataSource files using the <customSQL> tag , here is an example:

  <operationBindings>
      <operationBinding operationType="fetch">
         <customSQL>
         SELECT  Name, Adress, Phone, Age                       
        FROM tableName
            where Age >20

           </customSQL>
     </operationBinding>
  </operationBindings>

answered Jun 18, 2014 at 9:36

SBarney

391 gold badge1 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:28:35Z

1

Don't write any code in your JavaScript related to Database.

In Smart GWT always access database using DataSource

You can use GWT JSNI to call Java method from JavaScript and vice-verse.

Find a sample code on Calling GWT Java function from JavaScript

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Apr 30, 2014 at 9:55

Braj

46.9k5 gold badges63 silver badges77 bronze badges

1 Comment

Braj Over a year ago

I never suggest you to use it but still you can look at Is it possible to retrieve data from SQL Server using jQuery?

Collectives™ on Stack Overflow

launch a SQL query from the js file

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related