Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.javascript > #15046

Re: Accessing SQL Server from Browser Safely and Portably

Show all headers | View raw

On Fri, 13 Jul 2012 14:21:23 -0700, Gene Wirchenko wrote:

>[...]
>Browser-Side:
>         Get the results.
>           ??? What format?  And how do I access the data?

Depends on how you want to deal with it.

JSON -- you get an object that you can directly manipulate in
JavaScript.

HTML -- you can just replace an element (and its children) with a new
one (and its children).

text -- if all you want is new text for contents of an element, or even
a simple yes/no true/false type response.

There's also XML, but then you need to deal with that in your script,
and unless there's other consumers of your AJAX interface, I'd go with
JSON instead.

>[...]
>     I thought it should be easy to find some basic code for this, but
>no such luck.

http://google.com/search?hl=en&q=php%20mysql%20ajax%20tutorial

Those are for PHP, and for MySQL, but the essence is the same in
whichever server-side scripting language.

>[...]
>     The above use case implies changing the data and updating the row
>and naturally, I want to be able to do more.  Being able to do the
>above would be a good start.  My opposite number is unlikely to allow
>adding additional software (Node.js, for example) on the server.

So, what is your server, and what is available to run on it without
upsetting your opposite number? e.g. Linux/Unix vs Windows, Classic ASP
and .NET vs PHP, Ruby, Python... these things change your approach, so
tell us more.
-- 
Ross McKay, Toronto, NSW Australia
Man's Prayer:
"I'm a man, but I can change.
 If I have to.
 I guess." - Red Green

Back to comp.lang.javascript | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Accessing SQL Server from Browser Safely and Portably Gene Wirchenko <genew@ocis.net> - 2012-07-13 14:21 -0700
  Re: Accessing SQL Server from Browser Safely and Portably Ross McKay <au.org.zeta.at.rosko@invalid.invalid> - 2012-07-14 09:27 +1000
    Re: Accessing SQL Server from Browser Safely and Portably Gene Wirchenko <genew@ocis.net> - 2012-07-13 21:18 -0700
      Re: Accessing SQL Server from Browser Safely and Portably Ross McKay <au.org.zeta.at.rosko@invalid.invalid> - 2012-07-14 21:40 +1000

csiph-web