Re: [WebDNA] WebDNA autosuggest

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105707
interpreted = N
texte = Hi I've had this in use with a few development sites, and have only just realised that it doesn't work in IE... Eeeeek. Kinda important stuff. Since it's a great autosuggest, could Stuart or someone get this working please - Javascript isn't my strength but the syntax is apparently out at char 13 on line 42 of 'remotesuggestion.js'. 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:

    
  1. Re: [WebDNA] WebDNA autosuggest ("Diane Blackmore (Cohesion)" 2010)
  2. RE: [WebDNA] WebDNA autosuggest ("Olin Lagon" 2010)
  3. Re: [WebDNA] WebDNA autosuggest (christophe.billiottet@webdna.us 2010)
  4. Re: [WebDNA] WebDNA autosuggest (Govinda 2010)
  5. Re: [WebDNA] WebDNA autosuggest (Stuart Tremain 2010)
  6. Re: [WebDNA] WebDNA autosuggest ("Diane Blackmore (Cohesion)" 2010)
Hi I've had this in use with a few development sites, and have only just realised that it doesn't work in IE... Eeeeek. Kinda important stuff. Since it's a great autosuggest, could Stuart or someone get this working please - Javascript isn't my strength but the syntax is apparently out at char 13 on line 42 of 'remotesuggestion.js'. 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:

Internet Advancement (2003) WebCatalog for guestbook ? (1997) Beta 18 (1997) Server crash (1997) Variable prices and Formulas.db (1997) [WebDNA] Emailer breaking format (2015) Shopping cart now good (fixed it) (1997) Guestbook (2000) WebCat2: Items xx to xx shown, etc. (1997) New Webcatalog for Mac (1997) inconsistent webcat calculation? (1997) no template caching (1997) WriteFile Command (1998) European Convention (2004) WebDNA Solutions ... sorry! (1997) Nesting format tags (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) [OT] Bad Hard Drive? (2003) Harvesting invalid email addresses from bounced emails??? (2000) Security Hole - NetCloak Update (1998)