{"id":804,"date":"2010-02-05T09:18:36","date_gmt":"2010-02-05T13:18:36","guid":{"rendered":"http:\/\/wehuberconsultingllc.com\/wordpress\/2010\/02\/05\/jeditable-and-classic-asp\/"},"modified":"2010-02-05T09:27:32","modified_gmt":"2010-02-05T13:27:32","slug":"jeditable-and-classic-asp","status":"publish","type":"post","link":"https:\/\/wehuberconsultingllc.com\/wordpress\/2010\/02\/05\/jeditable-and-classic-asp\/","title":{"rendered":"Jeditable and Classic ASP"},"content":{"rendered":"<p>This week I implemented a grid style application using Classic ASP and <a title=\"Jeditable - Edit In Place Plugin For jQuery\" href=\"http:\/\/www.appelsiini.net\/projects\/jeditable\">Jeditable<\/a>. 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.<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\"> \r\n&lt;% \r\ndim sID, sValue,errorcode dim field1,field2,field3,field4 \r\n'The sID is a spreadsheet style ID \r\n'As an example B3 would be the second editable field \r\n'for DB ID field = 3\r\nsID = request(&quot;id&quot;) \r\nsValue = request(&quot;value&quot;) \r\nsType = mid(sID,1,1) \r\nsDataID = mid(sID,2)  \r\n'We have four editable fields \r\n'The changed field will not be null \r\nfield1 = null \r\nfield2 = null \r\nfield3 = null \r\nfield4 = null \r\nerrorcode = 0  \r\nselect case sType \r\ncase &quot;A&quot; \t\r\nfield1 = sValue \r\ncase &quot;B&quot; \t\r\nfield2 = sValue \r\ncase &quot;C&quot; \t\r\nfield3 = sValue \r\ncase &quot;D&quot; \t\r\nfield4 = sValue \r\ncase else \t\r\nerrorcode = 1 \r\nend select \r\nif errorcode = 0 then \r\n'Validate and update the data base \r\nend if \r\nif errorcode = 0 then \r\n'Send back the value field \r\nResponse.Write sValue \r\nelse  \r\nResponse.Write &quot;&lt;b&gt;!Error &quot; &amp; errorcode &amp; &quot;&lt;\/b&gt;&quot; \r\nend if \r\n%&gt; <\/pre>\n","protected":false},"excerpt":{"rendered":"<p>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. &lt;% dim sID, sValue,errorcode dim field1,field2,field3,field4 &#8216;The sID is a spreadsheet style ID &#8216;As an example &hellip; <a href=\"https:\/\/wehuberconsultingllc.com\/wordpress\/2010\/02\/05\/jeditable-and-classic-asp\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Jeditable and Classic ASP&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2,30],"tags":[134,16],"class_list":["post-804","post","type-post","status-publish","format-standard","hentry","category-css","category-jquery","tag-jquery","tag-webdesign"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4iN3d-cY","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/804","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/comments?post=804"}],"version-history":[{"count":4,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/804\/revisions"}],"predecessor-version":[{"id":808,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/804\/revisions\/808"}],"wp:attachment":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/media?parent=804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/categories?post=804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/tags?post=804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}