AJAX Query Builder?

[Kenneth Baltrinic]

Our team needs an AJAX based query builder that ideally plays well with
..Net, something along the lines of the Microsoft Outlook Filter Dialog. We
found one item on CodeProject.com "SqlWhereBuilder" but we are hoping for a
more mature solution. Anybody know of anything out there?

 

[Joost Diepenmaat]

Our team needs an AJAX based query builder that ideally plays well with
.Net, something along the lines of the Microsoft Outlook Filter Dialog. We
found one item on CodeProject.com "SqlWhereBuilder" but we are hoping for a
more mature solution. Anybody know of anything out there?

You're not seriously considering building SQL on the client, right?

 

[Erwin Moller]

Joost Diepenmaat schreef:

You're not seriously considering building SQL on the client, right?

Why not?
Educational website, experienced users, etc.
There can be many reason to offer SQL-power to a client.

Regards,
Erwin Moller

--
============================
Erwin Moller
Now dropping all postings from googlegroups.
Why? http://improve-usenet.org/
============================

 

[slebetman]

Joost Diepenmaat schreef:



Why not?
Educational website, experienced users, etc.
There can be many reason to offer SQL-power to a client.

^^^^^^^^^^^^^^^^^^^^^^^

And throw away the extremely paranoid security/access model baked in
to all modern databases. Why not tell people your SQL username and
password while you're at it. Does "SQL injection" ring a bell?

Note: there is only one way of doing this that I'd consider "safe"
even if I recommend against it: expose a read-only SQL account for
client-side SQL queries.