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:
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:
t or f (1997)
WebCat hosting providers? (1997)
[Sum] function? (1997)
SMITH MICRO: FW: Emailer stops on Win 2000 (2002)
Not really WebCat - need HTML Grider (1997)
Country & Ship-to address & other fields ? (1997)
RE: [isfolder] and [filename] (1997)
New commands in Final candidate (1997)
[WebDNA] [OT] thanks. (2009)
[WebDNA] UTF-8 encoding issues (2010)
shipping with weigth (1998)
webcatalog [date] bug (1999)
3.08 has trouble keeping the serial # ?? (2000)
Overriding default mime headers (2003)
sorting question... (2001)
Sort Order on a page search (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
no global [username] or [password] displayed ... (1997)
WC 2.0 frames feature (1997)
Redirect to anchor (2001)