[Proto-Scripty] Re: Scriptaclous Problem
Thanks colin! On Nov 12, 4:16 am, ColinFine <[EMAIL PROTECTED]> wrote: > On Nov 11, 4:45 pm,alohaaaron<[EMAIL PROTECTED]> wrote: > > ... > > > I also can't get the results to show by just the first letter. Say if > > the list contains coffee and frank, I type f and just want frank to be > > found, not coffee. But it shows both frank and coffee. Here is the > > link > > > here is the php lookup > > > $sql = "SELECT UNIQUE_CUST_ID FROM test2 WHERE UNIQUE_CUST_ID LIKE > > '%" . $_POST['search'] . "%'"; > > $rs = mysql_query($sql); > > ?> > > That's because you're telling it in the SQL to match any string > containing (not just starting with) the search string. > > Change > '%" . $_POST['search'] . "%'"; > to > '" . $_POST['search'] . "%'"; > > Colin --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Prototype & script.aculo.us" group. To post to this group, send email to prototype-scriptaculous@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/prototype-scriptaculous?hl=en -~--~~~~--~~--~--~---
[Proto-Scripty] Re: Scriptaclous Problem
On Nov 11, 4:45 pm, alohaaaron <[EMAIL PROTECTED]> wrote: ... > I also can't get the results to show by just the first letter. Say if > the list contains coffee and frank, I type f and just want frank to be > found, not coffee. But it shows both frank and coffee. Here is the > link > > here is the php lookup > > $sql = "SELECT UNIQUE_CUST_ID FROM test2 WHERE UNIQUE_CUST_ID LIKE > '%" . $_POST['search'] . "%'"; > $rs = mysql_query($sql); > ?> That's because you're telling it in the SQL to match any string containing (not just starting with) the search string. Change '%" . $_POST['search'] . "%'"; to '" . $_POST['search'] . "%'"; Colin --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Prototype & script.aculo.us" group. To post to this group, send email to prototype-scriptaculous@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/prototype-scriptaculous?hl=en -~--~~~~--~~--~--~---
[Proto-Scripty] Re: Scriptaclous Problem
Thank you. I downloaded a demo of another site http://wiseguysonly.com/demos/scriptaculous/ajax-autocompletion/autocomplete.php using scriptaculous and it seems to work but I can't the arrow keys to work when I want to select one of the items from the result list. I also can't get the results to show by just the first letter. Say if the list contains coffee and frank, I type f and just want frank to be found, not coffee. But it shows both frank and coffee. Here is the link here is the php lookup $sql = "SELECT UNIQUE_CUST_ID FROM test2 WHERE UNIQUE_CUST_ID LIKE '%" . $_POST['search'] . "%'"; $rs = mysql_query($sql); ?> On Nov 5, 8:00 am, Walter Lee Davis <[EMAIL PROTECTED]> wrote: > This is great advice. Let me add one more bit: run your page through > the W3C validator. If it passes, but the page doesn't work as > expected, then that's one thing you can cross off the list while > debugging. But if your page doesn't validate, then fixing whatever is > broken is a valuable first step. Prototype and Scripty are not very > forgiving of "quirks mode" HTML. > > Walter > > On Nov 4, 2008, at 4:49 PM, bluezehn wrote: > > > Then slowly change each part of the demo until it's your code that you > > want. At some point it will break in IE! Post here what change it was > > that broke it and we'll see what we can do to help you out if you > > can't figure it out yourself. > > > On Nov 4, 12:32 am,alohaaaron<[EMAIL PROTECTED]> wrote: > >> Hi, For some reason the demo examples of scriptaculouos to do an > >> autocomplete drop down don't work on IE. > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Prototype & script.aculo.us" group. To post to this group, send email to prototype-scriptaculous@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/prototype-scriptaculous?hl=en -~--~~~~--~~--~--~---
[Proto-Scripty] Re: Scriptaclous Problem
This is great advice. Let me add one more bit: run your page through the W3C validator. If it passes, but the page doesn't work as expected, then that's one thing you can cross off the list while debugging. But if your page doesn't validate, then fixing whatever is broken is a valuable first step. Prototype and Scripty are not very forgiving of "quirks mode" HTML. Walter On Nov 4, 2008, at 4:49 PM, bluezehn wrote: > Then slowly change each part of the demo until it's your code that you > want. At some point it will break in IE! Post here what change it was > that broke it and we'll see what we can do to help you out if you > can't figure it out yourself. > > On Nov 4, 12:32 am, alohaaaron <[EMAIL PROTECTED]> wrote: >> Hi, For some reason the demo examples of scriptaculouos to do an >> autocomplete drop down don't work on IE. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Prototype & script.aculo.us" group. To post to this group, send email to prototype-scriptaculous@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/prototype-scriptaculous?hl=en -~--~~~~--~~--~--~---
[Proto-Scripty] Re: Scriptaclous Problem
Well if the demo works it clearly is compatible. A note for the future is versions of IE are different; try it in IE6, IE7. Google "multiple IE" if you have one but not the other. This is my advice though: Copy and paste the example on the scriptaculous site that works fine for you, onto your site. If you copy it EXACTLY (the source code is listed on the demo page) it will work in both IE and Firefox - if it doesn't then it's something else on your page that's screwing things up. Then slowly change each part of the demo until it's your code that you want. At some point it will break in IE! Post here what change it was that broke it and we'll see what we can do to help you out if you can't figure it out yourself. On Nov 4, 12:32 am, alohaaaron <[EMAIL PROTECTED]> wrote: > Hi, For some reason the demo examples of scriptaculouos to do an > autocomplete drop down don't work on IE. I download the latest > version of scriptaculous and run the ajax_autocompleter2_test and it > doesn't give me the dropdown lists in IE but it works fine in > firefox. But their example herehttp://demo.script.aculo.us/ajax/autocompleter > works fine in both IE and Firefox. Isn't it compatible with both > browswers? Thanks, Aaron --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Prototype & script.aculo.us" group. To post to this group, send email to prototype-scriptaculous@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/prototype-scriptaculous?hl=en -~--~~~~--~~--~--~---