I already use something similar to this, but since I cannot be sure of the range I am looking for, this solution won't work for me. This is actually pretty much what I am trying to replace with something better.
Lets see if I can explain better what I am trying to solve. I have a page that lists items for sale it. Is is paginated, 25 per page. The page also has filters on it so that you can reduce the page count. I want to link to a specific product and highlight it -which is super simple, until you need to figure out all the filters and the specific page that product shows up on. I currently do not have a separate "detail" page for the products, instead, click the product and you get a modal window with the detail (and additional add to cart button). Using javascript and a hash and URL params isn't working well in all browsers. page.cfm/?f1=A&f2=B&f3=C#hashforsku or even page.cfm#hashforsku/?f1=A&f2=B&f3=C Params load page correctly, capture the hash to open the modal with javascript I could just add another param page.cfm/?f1=A&f2=B&f3=C&product=sku But that opens a whole other can of worms with my security module (I only use integers in url params and a module to deal with non-integers) working alone sometimes sucks - once in a while I need a sounding board.. Thanks again, M M On Thursday, March 22, 2018 at 7:08:36 PM UTC-5, [email protected] wrote: > > This might help: > https://stackoverflow.com/questions/30068252/mysql-query-to-return-the-range-of-coordinates > > > > *James E. Thomas* > *Enterprise Practice Support Systems Manager* > > Baker Botts L.L.P. > [email protected] <javascript:> > T +1.713.229.2196 > F +1.713.229.8130 > M +1.832.373.8117 > > 910 Louisiana Street > Houston, Texas 77002 > USA > > [image: bblogo] <http://www.bakerbotts.com/> > [image: linkedin] > <https://www.linkedin.com/company/baker-botts-llp?trk=hb_tab_compy_id_8300> > [image: > youtube] <https://www.youtube.com/channel/UCgys2C8DwRY-BVN079QNnwQ> [image: > facebook] <https://www.facebook.com/BakerBottsLLP/> [image: instagram] > <https://www.instagram.com/bakerbotts/> [image: twitter] > <https://twitter.com/bakerbotts> > > > > *From:* [email protected] <javascript:> [mailto: > [email protected] <javascript:>] *On Behalf Of *Mike Gillespie > *Sent:* 22 March, 2018 7:05 PM > *To:* Houston ColdFusion Users' Group <[email protected] > <javascript:>> > *Subject:* [houcfug] SQL Query help > > > > Hey y'all, > > > > Sure hope you can help with this one. > > > > Is there a way to write a sql query for MySQL such that it returns > recordset of say 100 rows with my target recordset in the center from a > table of 1000 rows? > > > > I need it to load a page of items on an ecomm site, but want to provide > not only the target item, but 100 other choices as well. > > > > The number 100 and 100 are arbitrary. > > > > Basically, pull all records with a price range between .99 and 9.99 with > the 4.99 target row in the center of the resultset. ( and yeah, the example > is horrible, but it gets the point across) > > > > TIA, > > > > M > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] <javascript:> > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > > > *Confidentiality Notice:* > > The information contained in this email and any attachments is intended > only for the recipient[s] listed above and may be privileged and > confidential. Any dissemination, copying, or use of or reliance upon such > information by or to anyone other than the recipient[s] listed above is > prohibited. If you have received this message in error, please notify the > sender immediately at the email address above and destroy any and all > copies of this message. > -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
