Re: [WebDNA] WebDNA autosuggest
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105708
interpreted = N
texte = SorryIt wasn't written by me, I think that Chris has inadvertently credited =it to me.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 17/08/2010, at 12:17 PM, Diane Blackmore (Cohesion) wrote:> Hi>=20> 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.>=20> 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'.>=20>=20> Thanks,>=20>=20> on 18/3/10 11:13 PM, christophe.billiottet@webdna.us at> christophe.billiottet@webdna.us wrote:>=20>> There is an autosuggest in the site resources download. It as been =written 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 =ajax>>> tool to allow an =91atuosuggest=92 function (like Google has to make =suggestions>>> after a few letters/words have been typed). Found one (and a good =one) but 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=92m 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=92ll be =2500 schools>>> so we don=92t 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=92t seem to be getting the opportunity to =91clean=92 =the result of>>> stuff that I don=92t want =96 like the opening =93=94= which the js>>> above won=92t want to see at all, and maybe some line-feeds or other =characters>>> 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 =91_findSchools.csn=92 is the page doing the WebDNA =processing as>>> follows;>>>=20>>>=20>>>> >>>> [search=20>>>> =db=3D../db/schools.db&geschooliddatarq=3D1&eqsch_livedatarq=3DT&asschool_n=amesort=3D>>>> 1][founditems]{value: "[schoolid]", name: "[school_name]"}[hideif>>>> [index]=3D[numfound]],[/hideif][/founditems][/search]>>>=20>>> However this doesn=92t come back with a valid format even when the =results are>>> pasted straight in to the =93_findSchools.csn=94 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 =91example=92 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 format>>> it needs, without the extra WebDNA stuff that it doesn=92t 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=3D288>>=20>>=20>=20>=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> Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
SorryIt wasn't written by me, I think that Chris has inadvertently credited =it to me.RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 17/08/2010, at 12:17 PM, Diane Blackmore (Cohesion) wrote:> Hi>=20> 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.>=20> 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'.>=20>=20> Thanks,>=20>=20> on 18/3/10 11:13 PM, christophe.billiottet@webdna.us at> christophe.billiottet@webdna.us wrote:>=20>> There is an autosuggest in the site resources download. It as been =written 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 =ajax>>> tool to allow an =91atuosuggest=92 function (like Google has to make =suggestions>>> after a few letters/words have been typed). Found one (and a good =one) but 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=92m 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=92ll be =2500 schools>>> so we don=92t 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=92t seem to be getting the opportunity to =91clean=92 =the result of>>> stuff that I don=92t want =96 like the opening =93=94= which the js>>> above won=92t want to see at all, and maybe some line-feeds or other =characters>>> 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 =91_findSchools.csn=92 is the page doing the WebDNA =processing as>>> follows;>>>=20>>>=20>>>> >>>> [search=20>>>> =db=3D../db/schools.db&geschooliddatarq=3D1&eqsch_livedatarq=3DT&asschool_n=amesort=3D>>>> 1][founditems]{value: "[schoolid]", name: "[school_name]"}[hideif>>>> [index]=3D[numfound]],[/hideif][/founditems][/search]>>>=20>>> However this doesn=92t come back with a valid format even when the =results are>>> pasted straight in to the =93_findSchools.csn=94 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 =91example=92 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 format>>> it needs, without the extra WebDNA stuff that it doesn=92t 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=3D288>>=20>>=20>=20>=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> Bug Reporting: support@webdna.us
Stuart Tremain
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:
Cookies and webcat (1997)
Set Cookie for Multiple Domain Extensions (2005)
Forumulas.db & Variables (2002)
[WebDNA] Sort Direction matches the written to file order (2015)
[subtotal] and others (1997)
NTbeta18 corrupted? (1997)
resorting found set (2005)
default value from Lookup (was Grant, please help me) (1997)
WebCatalog can't find database (1997)
nslookup (2000)
OT Spell Check (2003)
help testing quicktime delivery (1997)
Looping control (1997)
blank page from template (1997)
WebCat for Site Search? (1997)
Search for dates greater than [date] (1997)
[HTML*] (a proposition) (1997)
AAAH: stupid sendmail (2001)
Duplicate emails being sent - only since last night (2002)
WebCat chatroom (1997)