Re: [WebDNA] WebDNA autosuggest
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105708
interpreted = N
texte = Sorry It wasn't written by me, I think that Chris has inadvertently credited = it to me. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 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:
Sorry It wasn't written by me, I think that Chris has inadvertently credited = it to me. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 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:
Cookie woes with Mac IE4 (1998)
User Defined Sorting (1997)
vs (1997)
Limiting user access to .tmpl files (1997)
Searching multiple fields (1997)
Web Catalog 2 demo (1997)
How big can WebCat go? (1999)
Searching multiple fields (1997)
Performance Issue (2000)
New Command prefs ... (1997)
Insert Line Feed Character (2004)
Re[2]: Support suggestions - long (was politeness, et al) (2000)
need help with textA field (1998)
RE: WebDNA-Talk searchable? (1997)
Price and Formula.db (2002)
[WebDNA] Convert Math Date in Excel (2010)
splitting numbers in webDNA? (1997)
Emailer setup (1997)
[ReturnRaw] and hiding FORM data (2003)
[searchstring] (1998)