Jeditable and Classic ASP

This week I implemented a grid style application using Classic ASP and Jeditable. The hardest part of implementing this application was trying to figure out what a save.asp version of save.php would look like. Here the template I created.

 
<% 
dim sID, sValue,errorcode dim field1,field2,field3,field4 
'The sID is a spreadsheet style ID 
'As an example B3 would be the second editable field 
'for DB ID field = 3
sID = request("id") 
sValue = request("value") 
sType = mid(sID,1,1) 
sDataID = mid(sID,2)  
'We have four editable fields 
'The changed field will not be null 
field1 = null 
field2 = null 
field3 = null 
field4 = null 
errorcode = 0  
select case sType 
case "A" 	
field1 = sValue 
case "B" 	
field2 = sValue 
case "C" 	
field3 = sValue 
case "D" 	
field4 = sValue 
case else 	
errorcode = 1 
end select 
if errorcode = 0 then 
'Validate and update the data base 
end if 
if errorcode = 0 then 
'Send back the value field 
Response.Write sValue 
else  
Response.Write "<b>!Error " & errorcode & "</b>" 
end if 
%> 

3 thoughts on “Jeditable and Classic ASP”

  1. I’m having this very same nightmare! I’m having trouble getting the values and ID’s from the form. Could you possibly post the form source code as well please?

  2. 1. I added an ID to the input elements of the jeditable source (i.e doubeclick)

    doubleclick

    2. I put two more parameters to the dblclick-editable-javascript (id and name)

    $(“.dblclick”).editable(“save.asp”, {
    indicator : “”,
    tooltip : “Doubleclick to edit…”,
    event : “dblclick”,
    style : “inherit”,
    id : ‘elementid’,
    name : this.elementid
    });

    3. Then I changed the save.asp to:

    <%
    sID = request.form("elementid")
    sValue = request.form("value")

    errorcode = 0

    if errorcode = 0 then
    sql = " insert into test(test1, test2) values ('" & sID & "', '" & sValue & "')"
    cn.execute(sql)
    end if
    if errorcode = 0 then
    'Send back the value field
    Response.Write sValue
    else
    Response.Write "!Error: ” & request.form & ” ” & “
    end if
    %>

    Hope this helps out.

    – Erik

  3. can u share the source code of Classic ASP and Jeditable?
    i find php but there is no asp code. can u share the codes and we will download it
    thanks

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.