Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Classic ASP - x-editable save to SQL

Posted on 2016-08-10
3
105 Views
1 Endorsement
Last Modified: 2016-08-16
Team - I have downloaded a x-editable script from stackoverflow and it seems they've used php to save the data to mysql.

Link: stackoverflow.com/questions/20070612/x-editable-backend-configuration

Can i do the same with save to SQL? I am using Classic asp page with backend as SQL. I'd like to display a row from SQL & allow user to edit by double clicking and to save in SQL. Any ideas?
1
Comment
Question by:Manju
3 Comments
 
LVL 25

Expert Comment

by:SStory
ID: 41750269
I don't know anything about x-editable, but if you can change the calls from those to mysql to use these to SQL Server, then yes.
http://php.net/manual/en/book.sqlsrv.php

Example from that page:
mixed sqlsrv_query ( resource $conn , string $sql [, array $params [, array $options ]] )

Open in new window

0
 
LVL 52

Accepted Solution

by:
Scott Fell,  EE MVE earned 500 total points
ID: 41751527
I think you may be puting the cart before the horse.

x-editable should be downloaed from thesource https://vitalets.github.io/x-editable/

x-editable is a jquery plug in that allows you to have a form field that can be updated without an html form. It uses jquery ajax to post data to a processing page to update the dat.

Your main page can be whatever you want.  asp, php, pure html or anything that will display in the browser.

Likewise, the processing page is your server side language of choice. It can be a asp/.net, php or perhaps you have a web service.

On your processing page, you will accept data and update/add/delete to your sql db as you normally do.  The difference is instead of getting posted by a form, x-editable posts data via jquery.

Don't look at stack overflow, look at the docs https://vitalets.github.io/x-editable/docs.html

Do you have a processing page set up now?  

I would start by setting up your processing page to accept variable field names.
0
 
LVL 2

Expert Comment

by:Charles
ID: 41752186
Hi Good day,

Hope you want the data edit option and save to db without submitting classic asp form , If so its possible using AJAX call with classic asp, Please let me know this what your requirement, So that i can reply with the solution
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
classic asp checkbox uncheck and check 2 69
JSON error 4 71
Connecting to multiple databases to create a Dashboard 5 47
Html Table looping 4 25
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question