Re: [WebDNA] WebDNA jQuery JSON javascript stuff
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105081
interpreted = N
texte = Hi Big thanks to both you (for pointing it out) and Stuart (for writing it). Works a treat and solves my issue, esp. given that Donovan confirmed I couldn't use the plugin I was trying to use since WebDNA can't handle the json encryption. Now just one request Stuart - Any chance you could have it handle a value and name separately? Ie. The search finds a state, but what if I needed it to display the state yet carry over an ID in the form post? Thanks, on 18/3/10 11:13 PM, christophe.billiottet@webdna.us at christophe.billiottet@webdna.us wrote: > There is an autosuggest in the site resources download. It as been writte= n by > Stuart and works quite well: http://www.webdna.us/page.dna?numero=3D5 >=20 > - chris >=20 >=20 > On Mar 18, 2010, at 0:01, Diane Blackmore (Cohesion) wrote: >=20 >> Hi >>=20 >> My experience with ajax is limited but I have done some. I needed an aja= x >> tool to allow an =8Catuosuggest=B9 function (like Google has to make suggest= ions >> after a few letters/words have been typed). Found one (and a good one) b= ut I >> cannot get it to work when using a URL to gather the data object rather = than >> just using a string in the js itself. >>=20 >> Jquery tool is AutoSuggest: Docs found at >> http://code.drewwilson.com/entry/autosuggest-jquery-plugin >> I=B9m using it under jQuery 1.3.2. >>=20 >> Here is the code that works; >>=20 >>> >>=20 >> Or in raw format; >>=20 >>> >>=20 >>=20 >>=20 >>=20 >> Looks fine, except that when db is actually complete there=B9ll be 2500 sc= hools >> so we don=B9t want that listed on the page. Therefore we need to call the >> search on another page... Which is what I usually do, however in this >> instance I don=B9t seem to be getting the opportunity to =8Cclean=B9 the resul= t of >> stuff that I don=B9t want =AD like the opening =B3=B2 which th= e js >> above won=B9t want to see at all, and maybe some line-feeds or other chara= cters >> also.=20 >>=20 >> Usually clean data with replace(/\s*/, "") >>=20 >> Code to use a URL rather than a data string as above is; >>>=20 >>> >>=20 >>=20 >> ... Where =8C_findSchools.csn=B9 is the page doing the WebDNA processing as >> follows; >>=20 >>=20 >>> >>> [search=20 >>> db=3D../db/schools.db&geschooliddatarq=3D1&eqsch_livedatarq=3DT&asschool_name= sort=3D >>> 1][founditems]{value: "[schoolid]", name: "[school_name]"}[hideif >>> [index]=3D[numfound]],[/hideif][/founditems][/search] >>=20 >> However this doesn=B9t come back with a valid format even when the results= are >> pasted straight in to the =B3_findSchools.csn=B2 page. Tried adding >> [SETMIMEHEADER name=3DContent-type&value=3Dapplication/json] since the PHP >> example had a similar thing but no luck there either. >>=20 >> PHP =8Cexample=B9 provided by plugin app developer reads; >>=20 >>> >> $input =3D $_GET["q"]; >>> $data =3D array(); >>> // query your DataBase here looking for a match to $input >>> $query =3D mysql_query("SELECT * FROM my_table WHERE my_field LIKE >>> '%$input%'"); >>> while ($row =3D mysql_fetch_assoc($query)) { >>> $json =3D array(); >>> $json['value'] =3D $row['id']; >>> $json['name'] =3D $row['username']; >>> $json['image'] =3D $row['user_photo']; >>> $data[] =3D $json; >>> } >>> header("Content-type: application/json"); >>> echo json_encode($data); >>> ?> >>=20 >>=20 >>=20 >> Basically, can anyone tell me how I can get the data back in the JSON fo= rmat >> it needs, without the extra WebDNA stuff that it doesn=B9t need. >>=20 >>=20 >> Thanks heaps if you can help, >>=20 >>=20 >>=20 >>
>=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D28= 8 >=20 >=20
Associated Messages, from the most recent to the oldest:
Hi Big thanks to both you (for pointing it out) and Stuart (for writing it). Works a treat and solves my issue, esp. given that Donovan confirmed I couldn't use the plugin I was trying to use since WebDNA can't handle the json encryption. Now just one request Stuart - Any chance you could have it handle a value and name separately? Ie. The search finds a state, but what if I needed it to display the state yet carry over an ID in the form post? Thanks, on 18/3/10 11:13 PM, christophe.billiottet@webdna.us at christophe.billiottet@webdna.us wrote: > There is an autosuggest in the site resources download. It as been writte= n by > Stuart and works quite well: http://www.webdna.us/page.dna?numero=3D5 >=20 > - chris >=20 >=20 > On Mar 18, 2010, at 0:01, Diane Blackmore (Cohesion) wrote: >=20 >> Hi >>=20 >> My experience with ajax is limited but I have done some. I needed an aja= x >> tool to allow an =8Catuosuggest=B9 function (like Google has to make suggest= ions >> after a few letters/words have been typed). Found one (and a good one) b= ut I >> cannot get it to work when using a URL to gather the data object rather = than >> just using a string in the js itself. >>=20 >> Jquery tool is AutoSuggest: Docs found at >> http://code.drewwilson.com/entry/autosuggest-jquery-plugin >> I=B9m using it under jQuery 1.3.2. >>=20 >> Here is the code that works; >>=20 >>> >>=20 >> Or in raw format; >>=20 >>> >>=20 >>=20 >>=20 >>=20 >> Looks fine, except that when db is actually complete there=B9ll be 2500 sc= hools >> so we don=B9t want that listed on the page. Therefore we need to call the >> search on another page... Which is what I usually do, however in this >> instance I don=B9t seem to be getting the opportunity to =8Cclean=B9 the resul= t of >> stuff that I don=B9t want =AD like the opening =B3=B2 which th= e js >> above won=B9t want to see at all, and maybe some line-feeds or other chara= cters >> also.=20 >>=20 >> Usually clean data with replace(/\s*/, "") >>=20 >> Code to use a URL rather than a data string as above is; >>>=20 >>> >>=20 >>=20 >> ... Where =8C_findSchools.csn=B9 is the page doing the WebDNA processing as >> follows; >>=20 >>=20 >>> >>> [search=20 >>> db=3D../db/schools.db&geschooliddatarq=3D1&eqsch_livedatarq=3DT&asschool_name= sort=3D >>> 1][founditems]{value: "[schoolid]", name: "[school_name]"}[hideif >>> [index]=3D[numfound]],[/hideif][/founditems][/search] >>=20 >> However this doesn=B9t come back with a valid format even when the results= are >> pasted straight in to the =B3_findSchools.csn=B2 page. Tried adding >> [SETMIMEHEADER name=3DContent-type&value=3Dapplication/json] since the PHP >> example had a similar thing but no luck there either. >>=20 >> PHP =8Cexample=B9 provided by plugin app developer reads; >>=20 >>> >> $input =3D $_GET["q"]; >>> $data =3D array(); >>> // query your DataBase here looking for a match to $input >>> $query =3D mysql_query("SELECT * FROM my_table WHERE my_field LIKE >>> '%$input%'"); >>> while ($row =3D mysql_fetch_assoc($query)) { >>> $json =3D array(); >>> $json['value'] =3D $row['id']; >>> $json['name'] =3D $row['username']; >>> $json['image'] =3D $row['user_photo']; >>> $data[] =3D $json; >>> } >>> header("Content-type: application/json"); >>> echo json_encode($data); >>> ?> >>=20 >>=20 >>=20 >> Basically, can anyone tell me how I can get the data back in the JSON fo= rmat >> it needs, without the extra WebDNA stuff that it doesn=B9t need. >>=20 >>=20 >> Thanks heaps if you can help, >>=20 >>=20 >>=20 >> >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D28= 8 >=20 >=20
"Diane Blackmore (Cohesion)"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Plugin or CGI or both (1997)
[showif] based on data from [tcpconnect][tcpsend]? (2000)
WebMerchant and Mac Auth Hub Help Please (1999)
Webcatalog acgi conflict? (1999)
Type 11 errors setting up WebCAt 2 (1997)
WebCatalog 4.0 has been released! (2000)
Last desperate attempt (1998)
[lineitems] (2000)
Is Webcatalog 2.1 NT Ready? (1998)
[WebDNA] Quick Grep question (2009)
Re:Remote stockroom ? (1998)
Narrowing NT Crashing error (2000)
First postarg not taking in $Commands (1997)
Calculating multiple shipping... (1997)
eCommerce Idea Patented? (2002)
Linux WebCatalog on Apache w/ Raven SSL (2000)
Some pointers please (2008)
Table Loop Hoops (2000)
Don'y know if this is a sily question... (2003)
Credit Card Number Stripping Digit (1997)