[WebDNA] WebDNA jQuery JSON javascript stuff

This WebDNA talk-list message is from

2010

It keeps the original formatting. numero = 105068
interpreted = N
texte = > This message is in MIME format. Since your mail reader does not understandthis format, some or all of this message may not be legible.--B_3351772916_9011752Content-type: multipart/alternative;boundary="B_3351772916_9020144"--B_3351772916_9020144Content-type: text/plain;charset="ISO-8859-1"Content-transfer-encoding: quoted-printableHiMy experience with ajax is limited but I have done some. I needed an ajaxtool to allow an =8Catuosuggest=B9 function (like Google has to make suggestion=safter a few letters/words have been typed). Found one (and a good one) but =Icannot get it to work when using a URL to gather the data object rather tha=njust using a string in the js itself.Jquery tool is AutoSuggest: Docs found athttp://code.drewwilson.com/entry/autosuggest-jquery-pluginI=B9m using it under jQuery 1.3.2.Here is the code that works;> Or in raw format;> Looks fine, except that when db is actually complete there=B9ll be 2500schools so we don=B9t want that listed on the page. Therefore we need to callthe search on another page... Which is what I usually do, however in thisinstance I don=B9t seem to be getting the opportunity to =8Cclean=B9 the result o=fstuff that I don=B9t want =AD like the opening =B3=B2 which the j=sabove won=B9t want to see at all, and maybe some line-feeds or othercharacters also.=20Usually clean data with replace(/\s*/, "")Code to use a URL rather than a data string as above is;>=20> ... Where =8C_findSchools.csn=B9 is the page doing the WebDNA processing asfollows;> > [search=20> db=3D../db/schools.db&geschooliddatarq=3D1&eqsch_livedatarq=3DT&asschool_nameso=rt=3D1]> [founditems]{value: "[schoolid]", name: "[school_name]"}[hideif> [index]=3D[numfound]],[/hideif][/founditems][/search]However this doesn=B9t come back with a valid format even when the results ar=epasted straight in to the =B3_findSchools.csn=B2 page. Tried adding[SETMIMEHEADER name=3DContent-type&value=3Dapplication/json] since the PHPexample had a similar thing but no luck there either.PHP =8Cexample=B9 provided by plugin app developer reads;> =A0=A0=A0=A0$input =3D $_GET["q"];> =A0=A0=A0=A0$data =3D array();> =A0=A0=A0=A0// query your DataBase here looking for a match to $input> =A0=A0=A0=A0$query =3D mysql_query("SELECT * FROM my_table WHERE my_field LIKE> '%$input%'");> =A0=A0=A0=A0while ($row =3D mysql_fetch_assoc($query)) {> =A0=A0=A0=A0=A0=A0=A0=A0$json =3D array();> =A0=A0=A0=A0=A0=A0=A0=A0$json['value'] =3D $row['id'];> =A0=A0=A0=A0=A0=A0=A0=A0$json['name'] =3D $row['username'];> =A0=A0=A0=A0=A0=A0=A0=A0$json['image'] =3D $row['user_photo'];> =A0=A0=A0=A0=A0=A0=A0=A0$data[] =3D $json;> =A0=A0=A0=A0}> =A0=A0=A0=A0header("Content-type: application/json");> =A0=A0=A0=A0echo json_encode($data);> ?>Basically, can anyone tell me how I can get the data back in the JSON forma=tit needs, without the extra WebDNA stuff that it doesn=B9t need.Thanks heaps if you can help,--B_3351772916_9020144Content-type: text/html;charset="ISO-8859-1"Content-transfer-encoding: quoted-printableWebDNA jQuery JSON javascript stuffHi
My experience with ajax is limited but I have done some. I needed an ajax t=ool to allow an ‘atuosuggest’ function (like Google has to make =suggestions after a few letters/words have been typed). Found one (and a goo=d one) but I cannot get it to work when using a URL to gather the data objec=t rather than just using a string in the js itself.

Jquery tool is AutoSuggest: Docs found at http://code.drewwilson.com/entry/autosug=gest-jquery-plugin
I’m using it under jQuery 1.3.2.

Here is the code that works;

<script type=3D"text/javasc=ript">
$().ready(function(){

    var data =3D {items: [
    [search db=3D../db/schools.db&geschooliddatarq=3D1&=amp;eqsch_livedatarq=3DT&asschool_namesort=3D1][founditems]{value: "[sc=hoolid]", name: "[school_name]"}[hideif [index]=3D[numfound]],<=BR>    [/hideif][/founditems][/search]
    ]};

    $("#schoolFind input").autoSuggest(data.i=tems, {selectedItemProp: "name", searchObjProps: "name",= minChars: 2, matchCase: false});

});
</script>

Or in raw format;

<script type=3D"text/javasc=ript">
$().ready(function(){

var data =3D {items: [
{value: "13324553", name: "Tauranga Boys' College"=;},
{value: "13324554", name: "Tauranga Intermediate"=},
{value: "13324549", name: "Selwyn Ridge School"},=
...
{value: "13324551", name: "Oropi School"}
]};

$("#schoolFind input").autoSuggest(data.items, {selectedIte=mProp: "name", searchObjProps: "name", minChars: 2, matc=hCase: false});

});
</script>

Looks fine, except that when db is actually complete there’ll be 2500= schools so we don’t want that listed on the page. Therefore we need t=o call the search on another page... Which is what I usually do, however in =this instance I don’t seem to be getting the opportunity to ‘cle=an’ the result of stuff that I don’t want – like the openi=ng “<!HAS_WEBDNA_TAGS>” which the js above won’t wan=t to see at all, and maybe some line-feeds or other characters also.

Usually clean data with replace(/<!HAS_WEBDNA_TAGS=>\s*/, "")

Code to use a URL rather than a data string as above is;

<script type=3D"text/javascript">
$().ready(function(){

$("#schoolFind input").autoSuggest("=../ajax/_findSchools.csn", {selectedItemProp: "name", searchO=bjProps: "name", minChars: 2, matchCase: false});

});
</script>

... Where ‘_findSchools.csn’ is the page doing the WebDNA proce=ssing as follows;

<!HAS_WEBDNA_TAGS>
[search db=3D../db/schools.db&geschooliddatarq=3D1&eqsch_livedatarq=3DT&a=mp;asschool_namesort=3D1][founditems]{value: "[schoolid]", name: "[school_name]&q=uot;}[hideif [index]=3D[numfound]],[/hideif][/founditems][/search]

However this doesn’t come back with a valid format even when the resu=lts are pasted straight in to the “_findSchools.csn” page. Tried= adding [SETMIMEHEADER name=3DContent-type&value=3Dapplication/json] since t=he PHP example had a similar thing but no luck there either.

PHP ‘example’ provided by plugin app developer reads;

<?
=A0=A0=A0=A0$input =3D $_GET["q"];
=A0=A0=A0=A0$data =3D array();
=A0=A0=A0=A0// query your DataBase here looking for a match to $input
=A0=A0=A0=A0$query =3D mysql_query("SELECT * FROM my_table WHERE my_field LIKE '=%$input%'");
=A0=A0=A0=A0while ($row =3D mysql_fetch_assoc($query)) {
=A0=A0=A0=A0=A0=A0=A0=A0$json =3D array();
=A0=A0=A0=A0=A0=A0=A0=A0$json['value'] =3D $row['id'];
=A0=A0=A0=A0=A0=A0=A0=A0$json['name'] =3D $row['username'];
=A0=A0=A0=A0=A0=A0=A0=A0$json['image'] =3D $row['user_photo'];
=A0=A0=A0=A0=A0=A0=A0=A0$data[] =3D $json;
=A0=A0=A0=A0}
=A0=A0=A0=A0header("Content-type: application/json");
=A0=A0=A0=A0echo json_encode($data);
?>

Basically, can anyone tell me how I can get the data back in the JSON forma=t it needs, without the extra WebDNA stuff that it doesn’t need.

Thanks heaps if you can help,

--B_3351772916_9020144----B_3351772916_9011752Content-Type: image/gif; name="image.gif"Content-ID: <3351772915_9000011>Content-Transfer-Encoding: base64R0lGODlhowJOAPcAAP///9D1AGJnbVxdYm9vdGhobXt7gI2NkYuLj4mJjX9/g5eXm5SUmJKSlpaWmbq6vbW1uLOztrKytbGxtK6usa2tsKysr6urrqmprKenqqWlqKSkp6KipaCgo56eoZubns/P0cvLzcnJy8jIysfHycbGyMXFx8LCxLy8vrm5u7e3ufz8/ff3+PX19vLy8/Dw8e/v8O7u7+3t7unp6ufn6Obm5+Xl5uTk5ePj5OLi49/f4N7e393d3tzc3dvb3Nra29nZ2tjY2dfX2NXV1tTU1dLS09DQ0c3NzmBhZl9gZV5fZF1eY2ZnbGVma2RlamNkaWJjaGFiZ3BxdmtscWprcGlqb2hpbnJzeGRlaW9wdG5vc21ucmxtcWdobGZna3t8gHp7f3l6fnh5fXd4fHZ3e3V2enR1eXN0eHJzd3FydnBxdYmKjoeIjIaHi4SFiYOEiIKDh4GChoCBhX+AhH1+gnx9gYuMkI6Pko2OkYeIi4WGiaKjpqChpJ+go56fop2eoZydoJucn5manZiZnJeYm5WWmZOUl5GSlZCRlI+Qk6eoq72+wLu8vrm6vLW2uLS1t7Cxs6+wsq2usKusrqqrramqrKipq6anqaOkpqGipNXW2MvMzsXGyMDBw76/wcDCxba4u2xxd3d7gIGFioyQlJaanqGkp6uuserr7ODh4tna29fY2dXW19LT1NDR0svMzcnKy8fIyfP09Ozt7eXm5uDh4f7+/vv7+/n5+fj4+Pf39/X19evr6+np6f///wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAEAAL4ALAAAAACjAk4AAAj/AAMIHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmypMmTKFOqXMmypcuXMGPKnIkRgM2bOHPq3Mmzp8+fQIMKHUq0qNGjSJMqXcq0qdOnUKNKnUq1qtWrWLNq3cq1q9evYMOKHUu2rNmzaNOqXcu2rdu3cOPKnUu3rt27ePPq3cu3r9+/gAMLHky4sOHDiBMrXsy4sePHkCNLnky5suXLmDNr3sy5s+fPoEOLHk06agCqp0hNJSUgqADVl0+Xnk27NlXZSkUJEBCqVCqbrJnq3j3qd3CgrzHjzpp8KKlTVoOnXt0a6HPmsG1rx7scqW5QpnZr/3r6PbwoAMd/NrfcPekuU7pFbeK53nV2oppYv/7NM3j6oaiwFsp8O/2Xkyaf2FTfUbrhlAooOi243YRxtWdUgwBoklxwu5ASigCl7ALAa6MIMAoqAHwSSm8i3tQgKiui11oqJbIIwCkfmjIiKbuIEkqAopQigCif+JjgjfFBSEqQ56loI3dN9fgaeOPtJKFUGoZyCo4C8KeTgUSxdoopVX5ZnZX3LYUhcGfedCWFcK5lYVFrfigjALuU8gkoAkC325YCkAkin9C5uBtvxrWmiSl79sknKZ/M9xpr47FWCp8COHkjiJ+w1umQmmh4aZ95zVnUKQJAiBMoSSooio8EOv8ZIo1/7mgTjloCF6SJKN5EqU0aqrakkCfe6d+uoVQZXiiquhlKTrgW6l91rKFyqADWqsbqkIWSyCutpBpq6G6bdPjam3Gma5apQ9XZGoelfBjoiKMoSIqQob6Kk26foKpjcKnoF2iJLY64m6qsiWjinTHiaWK1AOCrib5QMkUwTp+89mmCB4dynqiElghKpLaiCih0lvqLU8M2xZjyvNPKqOeQm4InQJkR86aqySYbS21rGRO5Y8aQCulnn/6KTLK4Nm3Cb4B9CpmmulSXxa5QGAZ7Z3iapDJvc5Ne2yaGDQb3atcDC1DwkAvfaWtwDe/y8M/XltqUbgUDcLHc9S7/HJzErxJ7isKqNeyy2rbexDIAhxPus4wimi1KqPOu+mEpjD+b+eNug03KxZu3/Zrgea/pdoxyT23XLamsoooOMbgQw+w4CGHEEDRU/djVQZUn3p1CgiKkjp5nfMqeBNr0ndQMEzn8o59wTAqf/1a3YWuo6unpccYjbzdT4R1p094LXy9j3ZsIeV5yhj97XH2s8ee1sNbTz3lwYqtuZ/ucl2ivvaCLkecAkD6aMY1NLXtW6vKyixEM4gAS8AQgGHCBXgFgBbhAxSswkYAOFAEXulMM74AynN7wJzioKBEp7pW45GxLPvs6FClQFJyJaQlEN7qcrUq0iffZL4dDUtKZ/16YPLuMECgwGpQpNkG0jb0NaH1C3shA4TFbhQdQ1fvfTbK0pRUl6n8xO87fmNUvL0VsTMm5osqCo8bdJPATqWui0Vo4vT1V0VCgyKO5QAG1UzDPLj74ABOoEIkY6CALA0hkFX6wExz4AQpbwMANQniYI1JSK5b8CSrgw5v5vFBV5gMAEcNjot80xxQr0lHn0pSf3ZDihPV7nBhb854PFesm8XpNr1AZClWiUIXc+1C2RKmbXNGRlMWJ4aFQkQp+mYs1qnNLEfKQyEG84IJfSKQ263ALnuCADQNIwiBycMnBZLKcVjknOi9DAwYkEgsmuEkOlqDNRC6hBj2xhSQSGf+FS+QNLS7ogQlQ0M11AkWdBjVNQknTCSsk0gpAwMk86zmAJdjgJ51AQiLFIAS12GIOieyCLNBCA1e0ADIIzcluLPghnCUlY0U5lCialSmifMKCfknpQhuzAg5o0ws+yMktslnPOKwAKCfQJhIekBZboCGRWRipWUDQhAGEIQa7Y8rBbOK1mjIFFeITSp8e1Eub3JQoXv2LTnGyixKRSkWg8tXNehKu8I1vajWd601gusXdGBOtLi3nCgyhzSWEYCdBqEI9DyEUC9SzAmixhRmgKtWytEGbTHXMWl11HgCYokQJamZcTdRJAIh2cngqUYkol6FzFWpi58KJVzOGopv/ach/tBrFLsw1IBnmaTch2pFe57JZm+wCjpsQwCa61qHOauJDYc1JKTqrGx3JLbopqm1YwYqxLvEpsOrBLiVX4E5tYqInvaAEExLJBBgExRaX1aYEziJZyp5lAdocQVaXkqouMS5jCYpentbHI1SmCI7TRY9uwwfTjIFCQ7/pZVvb5NXrjih6fRKRKEzRoVKU4kS9qumHUZFCzL3mnxWCioVtwifl8Sm08SlTcncLoiap7bTjmStpU9Xa7ioIQrn9DY4BkMJziTeElKjnGXTxEwlo8wRCucET6ikCs9R3AFE9CyrsIIVLHFWzWv3EKE7x3BU3rTU15euZRzSf6zYY/3GZ0pCIkivbI1k4UxkTkddQtIkPFTGvR4JpWulS3FUhjsijqBerLnzgAd9EbptIrtd2cYp6CTjBeT0RbdWcIu9ii3EcNvClzzMKHqHqyFUzAj21Gc+ftEAKiVwDTnLxgEacVCcbqKcVcAqUFwRhBIuARApKIIRZ2GInK6CBETrxCAl04gipAGFOrpzlyEamuJmiYilUU1OnHYrRMPW2G5XrMAx3WkGfkDMBKXwkSV+YrxkT2585RiA6D5q4T/HakYajCWtJKqx0vskoTDEd5Y4ZJ/bm2JHw3KZ481jdcpMxmtt87xCyYLLaHENBf7KId87iJh6o5k544YR6IiIoLv9gBBscStEBeKEOF8idTWZAiTBAoeVJuAIfdoATat9aBkRYxAQmEAESTLInvCjCAyYgbBDgsyeyCEInJAAJFZDAB9d8NC16QYMv42QFOQiBCiABiQeAQOY5cQEseoCTGAzBE0x/BCzQfhZsw5FcjA4UpdEcYDRzGFV6MzXDz31huQ3uP2NVEebeXR1rgWIXzBxxKhTGxxGXmNFGdEoqyvro6Tp8peJu0ylEMQolCek3oc/7ws2919Z8uLUiinjqyW3mS6qAohEQyi3EkEhG3EQOiRwDT8qrzY76ZBEEaLny5WCTSHhB+RRNAgdYYJMrp0EWrzgAFnB+gI/nRARrKDn/RZEQh04cGycz6MMWlE+FNrDCJhRIAhKgUAScyMACvG95FOKwiC/bQhFcMABMIAO4YALa13JQIAhMVndaVSmaM1eoEltzpSGbElu04ikUSIEjMh59RlqytRuiUCgbqIEENByPJySfhio8goLBNVyE1hSbp0oZsltCUmcj8ndt0lXjwScPiIOqh26cBlNeMx4b9h7r44MrtHeoli64gHGJhAS0MBQjkEh6cBOC4HKLwBMhQFENkE98gHNjEAcKsH6J5AVCsAKF0HJUMAdxgEgU5QYicmVeEAaJVAB5MAiD0ABkOABs4HUugAfaNAd74AiRsAB7iACVpQpTkEhJ0AZ+/3AJCyAH6zUAjAQAiqBNsHATJBCAiaQAgGAJGnAHLDcAb9ALNgEB2qQHZQBVd4CHBxAF2sQBaFFo+fYbfMJrB4IKjgYahfZ5qUEcOAOBrtQmjFMdonIrw7iByjiCbaKBS2JaqvUbEfhL57IomhNCrUBRdXB+7xUHAwAFpogDSHABMtATL/B82tQE5bgTE9ByDZAK3WQLLcAKC3AFIAAAk9ByFpB1urAIsFhPhgAAV5ZICRALLoATL1AH9kROACALIDUAVlBEAPACHaBNfQgALLCKAyAFPJATL/AKxgcAGKBNhwUAJqBNZUAE3AgAMlCRiWQG1+QCk5hICyAE0mYTPv9QAInEBbOIFlQ0JBKpEyiYTLwIGht2SZdAUR4AFDzQAIjQkdk4AI4AAHBAABu3E7YAfPVEAjvRCzdXT22wkjdBfTTwj9oUkDlBAS1HBACAcUzAljsRAdp0jwDgB/ZUkjqBAKxmWtrUAUAxkol0WLyAjlNgijvxB9oECBeUBolEBWy3E+UVBT25U19Bi4WxC6FgRlXjBhTVCD+hCxhnBjaRCAPQBSDVaj6BX/WkATuhlhRVfz0hl6+pEzTwldpECG2ZSFJwlThxe4l0jzPwlQrQE0KwaglAZEmQSGdAdzsBmAPwCvioTZBgjjo5AFiAVXQ4AGLQE4gZTpNJmV1hmeD/2Re4cAYUpV8+MQvJmUhs4Al6qU2PABSVQFEnpxPx9VNY1ROIMH6GiRO3oAUUFQa3QAb2tROOMJcA4AnalAg6wAMO+qA8sAOvoFEDgAYg5JxVgAGqwJs34ZzzoQD29Jg8YQfaNB/ZSQYcahOAwIjfmRSHkkwuGBU/eY2/4iZ184ErJTbQOCRmJFqL12lV4qMG823r0hQaojNNUyMiCCyH0ixCwVs2oT78kTHgFYGHAl5YAVeoZRPhgRO/IqSFIQt7mEit8BMrcIUDkAiDQKHaRAVHdQtEAAIHmZYU9QY6MaAUlQUohhNaqU1YkHU9l53aJAUtMAYFqhMH+psAkJTQ/wd9T+BeCWqeKNkHcpoTzgkCtuCGTsALPtGdUgkAJ5qiALCi3smA/EVmo7A+S6gUKjIfVfJcFRcx9WKD0lUvolBg1whqmAkd8XYkEvZXr1ekTJExqYAqqaAhppAKiudjEBYmPDIeOFJLnRaru1CsXaKZW8Fcz5gzZwKrCfKrS8oXByAH5CoHCpAEYQACR7Cuc+oTK7AJIXBsKdBygtAJ3jgAaRAEdFpPcHCnTphIBLCnNwEHFPUEgHoTK6CR2pQGumCoWFZZOZGoA2AEANAH2jQFY5CxGquxYhAGHpsAt4aRJIAIiqVNXOABtdChc7kCyedynNoTIZdI0xmqPEGqSf/QokhRUy1GWgOCJyyoMDXSZqxxSzhRJge3Ly+mE3LjpJj3aDzGY17DH80KH0Smb631G1TrMEwrFr1oPaBQajfhbmZlPaEVjYyjGqPwoxHnIjoyhMwUq2Pbeg9njGhGKUPGs22mWnMVb1srSsaoZjMVZ/6VtX4xplSoFD6gBI2aSGRwkwBwARSVCDphCyBaT1iwjjwxCBSlBEeHE7qwiPWkACtAoA/LExJ7j5CgTUuJFDCwCX7wVIkEBbknktp0BLbAmOHEkMP3ZKDKuKJqszh7FH2iCam6I9JqeWlrvAb2YR2WE17jJsMBHYtWcXmmUls1thqmGqcWt37rJn3HYtX/Ub3CuhTEyide0yxmFm6II2EGhqyhUDBZ8jWgtHo9oWbJmmfwVrciMmrK6z4LVlP3e2g3kUKzSnjTy3ot9heVW08apxR6UFiXkAirxogXdROaW0+yqBMuWU+Z2BNJRVGcoBM8sJ7alAG5WboGiqBEoE1m4HVI0QKLMJP66pzQCU6JhJo6Mbr29Bs0uxPAa6pK8aKm9L2zxXfnFgoJ0mcOImmmxCMARm4Vl7zO67f8IcWwtVrcm8DgVh0JLMXjy6p+BSE8Zlxp5XCigAoQN1dCElYApiEaMr/oVr/EuIH527RrlmYTV26yhTP6IT4w5W+MB76AQXzaVADtahQ1QAUD/2AAfwCXCwyRh0yw9QRlOgEELScGB2sTuWCKLYC72qQAjgsAqqlNUJA7GFdtiIqgt+CwA5BZS1EB2pR7znlYHZdIbdATRbBqcWALttDDOvHDX5yzYYXHbHbHRHyjrXUtMAJKmCI21TGECuJGbgJkMapuV+tZncVoU3se0AzEYIwTYHtmXgJTA5bG41EiMmha/pUqR9nNcEt4FTh45+ZVs0fEFJcgVopdVBq3n5cpg5vNfSGxhcVzSHEAA4AET9c0E0wBOOECozgAUYCLNhEILXcGEMADvdALQFABZOAEPAcCLQcHm0ADM9AKhEVR80VtEIsTp2sTRLBqUWB+O4ELRP/gfSwpqhc8AJk4yxgpqAytE6hAukmgryvgyzkBzFYTZjYIU8hrYt9bhMzkvGfCvObrvTlBuI+2g59GuJN3eYrDYSFo1boa1lid1MPaJsl1CqnQZz96br8FAEVItVRErCsDCpI2etIaxzzBV26sb9ZyU/7jVXoHeMRcakrY12kV1ckVK8RYUxIW1n9RC4pLUZ2AFCSQSHigE61ACIVAyTdhBBRlBz2BCw0AfVFglgOgACe1CGyqVLZZT5ZQfae80jfR0jbRCWb5Bo1ABDiQA0EnCJM1Btc0BF5ABoDQCUCACi8QA6xACJ9MfTwNADkAoImUCEcwC7LgArUQAWSIBJT/XNS+W7Ms6s05G4zjQYG/BSIKc94z4lZMay2PJiBOGqPhghNJBEMjIoIRGFw3AaYKEqS6sXj1HcxIQYJNU0zpnMxAuaPFsbToAdCwqipS6ibKkqs9xiZYjCn4UyXTiGbsvaOeIiNYfGa8IYIGroxCqsV7YQsKSVGDcBSy0LJ0GRQUXU8Um08p4MmNigQE/QP32ah1kDy2QIYFQNs24WSJdAQ40QM2vLhkQE5oWlhJMNmJhAhZl2uJhJ5E1gATvARWMGXalAeqgLCwa5U8McrBO55XIZ5pcZRZkQq2+GmrEU138QAttwUhOxSZEHwu7BMw0AX1xAZiuRO7EAuD8AVc//CVSEAFYYAIKmADKxkEGSAHW/CVUTAFdeABRuDCtgAJf/AHFSCqmvAHfuABnXsTP2ABbUAGW9AFUyAFdFAIKsADX5YLPJAChDAHV8AFXUAFaPAGlrAKOAECpN4Hpw4APFABbWAGU+AEU3AGekAJEdVzE/DpkdDnN8EJf+AB50Xear7mhIGZ2EoVP4nfU2HufLELLVtP0EkUP7CeKjAUrhm7uisULjADN3ADNPAC2J52+H4DvZDJU3ELsgADLrCAPoELBe8CuYAUuCA7LhDKfcHm3+4TFF/xc1HL9XScQ7ECD9kFAs8TqFCdiYQCGO8W2LZM7iEgj2YnOMobL78+h//yLD/JIzgx4VzaJl1qWgGeeSfvGCvwBhS1BNMeFL45AKsbFKWtTaz582yBbWo97s7xrDcRgf3R1rF6L+fbVj8arQbGrbgkzeBaF4WmNRdOFPLyO+qBpXTF9uBJAyRPkEExC0UwiUpA0EBh5+bl9G1hd/0dY2erN22dIU6LM443x0Q2aBX31wlMRWyrzuetZgiiKP9M9k0Rb+PBaULBTKkQLwJLq0PxzuO5CROcSCGMXg0A6NrE8UBxBGxqAZEBCKowCxkg8UbhAg1w7DZxC0eV7P2eYqeaCijCv+77T/7VWjkCHDOzEzhivaVU9c+iIXCUHmNcxD7GVyoO/OQLIpb/RktDGyCq4TW8SoxWa1orMh53C2OjFbSIZmR8bxN6b7KYmxO8AGsUNZ2t/5Vb0MGFARCzUK0AsGIFLl6yAABAU8KFiBW3AMCYtbAgrxgWF8pKuHAWL4kynqiKuPAWLhcHOrVAtckWgFy8YJi05WLgQpu6NO7k2dPnT6AWAwQlCkDAUQEaNyUFUErAJ42pUgnYlArAp6eaBGjaFAoV1p6hTu20mmqUKItiF546KoqpUVALny4EaxFsXVBvi+7l21fjUL89saKiCrbUqF2kSoHNO6ppqZ2jHC8MBepTqKufdpVCO/eTZs5GSe0yhXnUaLZQA69m3dr1a9gaUywZUHtA/x6CPBnY5q3GRVBPSWo7qBjb+HGLtRIQAvRG1Y0wDDooeABgzKYbenARcpOpwRpdPg4ochAI18IUcTTE4nWAgR83rlxUwQHJz0IOgSo1cbPIFR5bOmmjg0QWYEGCOvoARAEaIGlDAxCQgw0w1+ZaaBO3jlpoFAFMsYgwpLaayioBQHEqRKQuFAAVozS0KC8VWdTolMkAEMXDqTShSy+wtLLKFLQkFHInCl0D65RQwEoSgK522WqUvHYJZRON8pJxql2ctEpFo1Tj0rOkqALASS+HNPNMNFnjBAveAOEJBi944y2Wn2JYoLYEhkhzT6Js+aKDhSYwYxUorFokDQDCOP/ChyZyqWOBgqYY4Y0vUqBkgAgB0ICMldg4ZCFPqLiBCxv8uGOhRAYBgA46TzBDBySAKEgMSTRQgCAFKOigjhJa4JOvIlmz0ChTdmELAFCSFGBLi5ZNC5SlmK1LI1JI2WkXHc2arFqLdOzKy1NEIQ2zHTWqK5RiRRnrV+OCZQ0sKTlsMcVR2NpFXQF2+bAyu0LkKsMwocIwRTCNopJMdhNWGE0fxuDtkp1qkZO3FHp6IRImoFhAiIU7tkWPQQiqBAxN0jjviCsAMOMVH7DIJYwIALAFjU4SeKMVH4p4wSQd9JCjgTskUkENWpjAgRIFAGjBjA8AIGMRADpBIwcnXFH/2gwJ+HATgAMuWQGIMNjo+Cd3A9vKIrYEICXfEgEgJchmZQRAk1Da7lYvAAgrM++6BShFX73TEoBfjZwShVmtNEocgFTcgmzs1soOrC6skrpxF1SsagwAtqy1iJRQpEoFc6qwJdbYgE8/tuBqUd8bcthjJ2qXTGir7Q+JFkIliolrO8EiW14YgoIEEDlhJtnZnaWQQT5IxIYbEDlPCAYAKGSVGxLAZZDfV2jAlV4QAUQDRXJDYY9DIHHhgwUAwaOHFhKoARU2BuHjAAgAiECPR1xBBIAjIMADhtDALSQggYVcYhGN2AAeKpa8hUgOghOkYORiszgbJcUsR4nLVMai/5UyoUhgdbNW2tZmFB2ZMEw6ShwqOLQ2HVVQhskjQhxsk4BeLGQFb+jdE2jgglnUYhWbgAUP9DVDPrlgZzJ7CRNltpCX2KKJUsTJC3IHAFy8wFcbWaIUm/iC8zRxFwqZohahOEUswiAXFZQgEt34xgjCUY5zpONOVjACOdSmCr8DgCqQMDFJMJGKdSRkIZHTRkMmkl2IVGQjHTmkFYAAEbyTQxEAsAqH1aYLFGjiIz35SZ8wcmFqAyUFRfnGE/aFFOsqZSt7wotFtKEKbuhEKkBwghBkxJW79OQpgQIwuFXIc8cpDb8SM7jRICsU6LJIMePCE6dYa21HGeZCNMGhJf8tJJo7uebgvLTN2PgSiankCyl5eU6LuOAItXoAEXoRAxbcIjfopKccxekTt4DCMrExp3HycgqnbMIpp8hLKZZiClO07Z8B5SY13faUT8TQmgJQ1yliqJV+zo2ip7DoRDPqmnvKkJz1JGlJTerKkPLELRpR2yg8lFDCXSYUfxPNC/UlgNPglEWgcIu65EIKDo2CRTKlqUVGgRknKWZZhDGFU/QVCsccdUwfFcULHwoKiWpzK59gVlUz6hRNcNUiXq0mSGMjCnLVTUeGS+vZ2EoZt+plXG0LF0XjsjanCHUhMO0gNuNCSp5uVC5nmdJOkNQhZPWUlQt5W15ZFKJgnlT/spM1aUp3AjAPHQUxbAFFQjWhlVL8s0UcJeVRSGsKrJDiEwMdLVtMAVrRNitIFEVF3UIhrpVm0CizDWZepiJNpJQJYApdVkaHGxffftSCsGHLZwU70+ZqxafQ3Yp0xzJTjSQUtZpgy2LW9gm8upZzJfIshyyjI7WldrUCGAsHb1ul9G5Cvaz9nN/EK1+8Ula/+0WnZTWST6zudiGiEIVzm1pdAhtlMstU8E85dEQG4/SnYNVEgmUrF1Es5Szsze1KKYrhD/lNNHlj3OD+u9TBEQYyxkWxV0SsXNb4NyodohGQQDgVU9S4wE/BsY5BqBEGU4ZcTsrpTa1FYAPn9RRG/36wkBs80iYDIMpBZmy+RqxRcfFXy1vuJWxy+1O5hKhaKGowACLsuZZa2cyYMafappkioyI1zU9Vm5WhKmU5D7NySBlm3ajFFLTu2aFVHrCyxBxO45ylXktZm74UfQpGW/nRkT6iky1N5FSW9tDrtdacnUxKKKt5yuQi9Ihr6xUup1rVhJTxgPVizlJU5hOnSAVWTvEJaLUIFN29cnrTy9o2q5a9uKbSi9ibUIGytzFYyTFxT4HsD30GKwUuBUBF3C+C+u0rn6GoRG1d0G1PO6vLhU1eSjdoc2/CSeZM97o99zYAJHQxm+gueJ+SaWvF2jK0tkxeOi1s1QIbuAMmhf+/pf1r9tpo4KK5V4c+UexVR1zipvTyqz03V70GNsO7dUsyg53Ywa3r4xqH+F4HF5fNkHCny/SQyQnHE1APrlg7SZbfKn3lF9WtqGBGdGxA5Gi7/VzKQT8K0J+50rmO5bCiuCtTSIlxVCRUbY+1VmDVMuJMo+WwkLG6yNGCbxDBeeJjJ3vHWg0bGJed3Gpne9vd/sazvybtbwcW3e1+d7wrLO55X9je+f53wAde8IMnfOENf3jEJ17xi2d84x3/eMhHXvKTp3zlLX95zGde85vnfOc9/3nQh37iASB96U1/etSnXvWrZ33rXf962Mde9rOnfe1tf3vc5173u+d9730j/3vgB1/4wyd+8Y1/fOQnX/nLZ37znf986Edf+tOnfvV1HxAAOw==--B_3351772916_9011752-- Associated Messages, from the most recent to the oldest:

Re: [WebDNA] WebDNA jQuery JSON javascript stuff ("Diane Blackmore (Cohesion)" 2010)
Re: [WebDNA] WebDNA jQuery JSON javascript stuff (Donovan Brooke 2010)
Re: [WebDNA] WebDNA jQuery JSON javascript stuff (christophe.billiottet@webdna.us 2010)
Re: [WebDNA] WebDNA jQuery JSON javascript stuff (Tom Duke 2010)
Re: [WebDNA] WebDNA jQuery JSON javascript stuff ("Terry Wilson" 2010)
Re: [WebDNA] WebDNA jQuery JSON javascript stuff (Donovan Brooke 2010)
[WebDNA] WebDNA jQuery JSON javascript stuff ("Diane Blackmore (Cohesion)" 2010)

> This message is in MIME format. Since your mail reader does not understandthis format, some or all of this message may not be legible.--B_3351772916_9011752Content-type: multipart/alternative;boundary="B_3351772916_9020144"--B_3351772916_9020144Content-type: text/plain;charset="ISO-8859-1"Content-transfer-encoding: quoted-printableHiMy experience with ajax is limited but I have done some. I needed an ajaxtool to allow an =8Catuosuggest=B9 function (like Google has to make suggestion=safter a few letters/words have been typed). Found one (and a good one) but =Icannot get it to work when using a URL to gather the data object rather tha=njust using a string in the js itself.Jquery tool is AutoSuggest: Docs found athttp://code.drewwilson.com/entry/autosuggest-jquery-pluginI=B9m using it under jQuery 1.3.2.Here is the code that works;> Or in raw format;> Looks fine, except that when db is actually complete there=B9ll be 2500schools so we don=B9t want that listed on the page. Therefore we need to callthe search on another page... Which is what I usually do, however in thisinstance I don=B9t seem to be getting the opportunity to =8Cclean=B9 the result o=fstuff that I don=B9t want =AD like the opening =B3=B2 which the j=sabove won=B9t want to see at all, and maybe some line-feeds or othercharacters also.=20Usually clean data with replace(/\s*/, "")Code to use a URL rather than a data string as above is;>=20> ... Where =8C_findSchools.csn=B9 is the page doing the WebDNA processing asfollows;> > [search=20> db=3D../db/schools.db&geschooliddatarq=3D1&eqsch_livedatarq=3DT&asschool_nameso=rt=3D1]> [founditems]{value: "[schoolid]", name: "[school_name]"}[hideif> [index]=3D[numfound]],[/hideif][/founditems][/search]However this doesn=B9t come back with a valid format even when the results ar=epasted straight in to the =B3_findSchools.csn=B2 page. Tried adding[SETMIMEHEADER name=3DContent-type&value=3Dapplication/json] since the PHPexample had a similar thing but no luck there either.PHP =8Cexample=B9 provided by plugin app developer reads;> =A0=A0=A0=A0$input =3D $_GET["q"];> =A0=A0=A0=A0$data =3D array();> =A0=A0=A0=A0// query your DataBase here looking for a match to $input> =A0=A0=A0=A0$query =3D mysql_query("SELECT * FROM my_table WHERE my_field LIKE> '%$input%'");> =A0=A0=A0=A0while ($row =3D mysql_fetch_assoc($query)) {> =A0=A0=A0=A0=A0=A0=A0=A0$json =3D array();> =A0=A0=A0=A0=A0=A0=A0=A0$json['value'] =3D $row['id'];> =A0=A0=A0=A0=A0=A0=A0=A0$json['name'] =3D $row['username'];> =A0=A0=A0=A0=A0=A0=A0=A0$json['image'] =3D $row['user_photo'];> =A0=A0=A0=A0=A0=A0=A0=A0$data[] =3D $json;> =A0=A0=A0=A0}> =A0=A0=A0=A0header("Content-type: application/json");> =A0=A0=A0=A0echo json_encode($data);> ?>Basically, can anyone tell me how I can get the data back in the JSON forma=tit needs, without the extra WebDNA stuff that it doesn=B9t need.Thanks heaps if you can help,--B_3351772916_9020144Content-type: text/html;charset="ISO-8859-1"Content-transfer-encoding: quoted-printableWebDNA jQuery JSON javascript stuffHi
My experience with ajax is limited but I have done some. I needed an ajax t=ool to allow an ‘atuosuggest’ function (like Google has to make =suggestions after a few letters/words have been typed). Found one (and a goo=d one) but I cannot get it to work when using a URL to gather the data objec=t rather than just using a string in the js itself.

Jquery tool is AutoSuggest: Docs found at http://code.drewwilson.com/entry/autosug=gest-jquery-plugin
I’m using it under jQuery 1.3.2.

Here is the code that works;