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:
shipcost (1997)
[WebDNA] [OT] the "Work in progress" thread. (2009)
Number searching/formats (1998)
[WebDNA] [ipaddress] - [RealIP] - Not working properly (2016)
Template Encrypt Speed (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
security (1997)
[OT] Flash conternt only in IE? (2006)
RE: E-mailer error codes (1997)
Pithy questions on webcommerce & siteedit (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
WebMerchant issues. [Resent] (2000)
Re[2]: when is failing to [URL]ize values in a comparison ri (1999)
[OT] Mac OSX and SSH Telnet (2000)
WebCatalog 2.0 b 15 mac (1997)
Quit revisited (1997)
WebCat chatroom (1997)
Search minus first found (1999)
Separate SSL Server (1997)
variables in or out of includes (2001)