Solved

Classic ASP - x-editable save to SQL

Posted on 2016-08-10
3
81 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now