Re: Sorting

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18227
interpreted = N
texte = I have tried removing NEWITEMsort=1&NEWITEMsdir=as and my results still do not appear as I would like them to. Ideally I would like to have all items that have YES in the NEWITEM field to be returned alphabetically at the top of the list, then all other items returned alphabetically at the bottom of the list this way the new books are listed at the top of the page. PCS Technical Support wrote:> >I am trying to return a search in a specific order. Within the context > >of a hyperlink I would like to have all items that have the value YES > >in the NEWITEM field of a database listed at the top of the founditems, > >then all others that meet the search criteria would follow. I have > >tried the following syntax with no luck: > > > > >HREF=/cgi-bin/items.tpl?command=search&db=../products.db&eqSTORE1datarq=golf&w > >sTYPE1datarq=Books&eqPRONAMEdatarq=[url][PRONAME][/url]&cart=[cart]&searchPRONAM > >E=[url][PRONAME][/url]&eqNEWITEMdata=YES&NEWITEMsort=1&NEWITEMsdir=as&max=150 > > > >target=body>[PRONAME] > > Try removing NEWITEMsort=1&NEWITEMsdir=as > > Sounds like you want the default ranking, which means better matches are > at the top of the list. You get this ranking by *not* specifying any > particular field to sort on (because if you tell it to sort by NEWITEM, you > are forcing that to be the sort field, which undoes the nice ranking). The > default ranking puts records at the top of the list that have more field > matches, which in your case puts NEWITEM=YES above all others, followed by > records that do not have NEWITEM=YES. > > Technical Support | ==== eCommerce and Beyond ==== > Pacific Coast Software | WebCatalog, WebMerchant, > 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, > San Diego, CA 92128 | Typhoon > 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search not sorting (Stuart Tremain 2017)
  2. Re: [WebDNA] Search not sorting (Stuart Tremain 2017)
  3. Re: [WebDNA] Search not sorting (Kenneth Grome 2017)
  4. Re: [WebDNA] Search not sorting (Lawrence Banahan 2017)
  5. [WebDNA] Search not sorting (Stuart Tremain 2017)
  6. [WebDNA] sorting files (Stephen Braun 2016)
  7. Re: [WebDNA] Sorting [ListFiles] (WebDNA Solutions 2013)
  8. [WebDNA] Sorting [ListFiles] (Steve Craig 2013)
  9. Re: [WebDNA] problems sorting when using multiple words in the search (Olin Lagon 2011)
  10. Re: [WebDNA] problems sorting when using multiple words in the search field (Grant Hulbert 2011)
  11. Re: [WebDNA] problems sorting when using multiple words in the search field (Govinda 2011)
  12. [WebDNA] problems sorting when using multiple words in the search field (Olin Lagon 2011)
  13. Re: [WebDNA] Sorting questions (Stuart Tremain 2009)
  14. Re: [WebDNA] Sorting questions (Stuart Tremain 2009)
  15. Re: [WebDNA] Sorting questions (Tony Miller 2009)
  16. Re: [WebDNA] Sorting questions (Tony Miller 2009)
  17. Re: [WebDNA] Sorting questions (Donovan Brooke 2009)
  18. [WebDNA] Sorting questions (Tony Miller 2009)
  19. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  20. Re: [WebDNA] Sorting -- Dealing with Blanks (Matthew Bohne 2008)
  21. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  22. Re: [WebDNA] Sorting -- Dealing with Blanks (Donovan Brooke 2008)
  23. Re: [WebDNA] Sorting -- Dealing with Blanks (Donovan Brooke 2008)
  24. Re: [WebDNA] Sorting -- Dealing with Blanks (Charles Kline 2008)
  25. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  26. Re: [WebDNA] Sorting -- Dealing with Blanks (Gary Krockover 2008)
  27. [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  28. Re: Sorting... stumped. ( "Dan Strong" 2006)
  29. Re: Sorting... stumped. ( Frank Nordberg 2006)
  30. Re: Sorting... stumped. ( "Dan Strong" 2006)
  31. Re: Sorting... stumped. ( Alex McCombie 2006)
  32. Re: Sorting... stumped. ( "Dan Strong" 2006)
  33. Re: Sorting... stumped. ( Alex McCombie 2006)
  34. Re: Sorting... stumped. ( "Dan Strong" 2006)
  35. Re: Sorting... stumped. ( "Dan Strong" 2006)
  36. Re: Sorting... stumped. ( "Dan Strong" 2006)
  37. Sorting... stumped. ( "Dan Strong" 2006)
  38. Re: Sorting ( "paul" 2005)
  39. Re: Sorting ( Gary Krockover 2005)
  40. Re: Sorting ( "paul" 2005)
  41. Re: Sorting ( "paul" 2005)
  42. Re: resorting found set ( "Steve Chun" 2005)
  43. Re: resorting found set ( John Peacock 2005)
  44. Re: resorting found set ( Steve Chun 2005)
  45. Re: resorting found set ( "Nitai @ ComputerOil" 2005)
  46. Re: resorting found set ( Steve Chun 2005)
  47. Re: resorting found set ( "Nitai @ ComputerOil" 2005)
  48. Re: resorting found set ( Brian Fries 2005)
  49. Re: resorting found set ( "Nitai @ ComputerOil" 2005)
  50. resorting found set ( Steve Chun 2005)
  51. Re: sorting month by month ( Kenneth Grome 2004)
  52. Re: sorting month by month ( Gary Krockover 2004)
  53. sorting month by month ( Chris 2004)
  54. Re: Sorting Date ( Alan White 2004)
  55. Re: Sorting Date ( "Nitai @ ComputerOil" 2004)
  56. Re: Sorting Date ( Alan White 2004)
  57. Re: Sorting Date ( "Erol Guneri" 2004)
  58. Re: Sorting Date ( Matthew A Perosi 2004)
  59. Re: Sorting Date ( Alan White 2004)
  60. Re: Sorting Date ( "Nitai @ ComputerOil" 2004)
  61. Sorting Date ( Alan White 2004)
  62. Re: Table sorting by selected category then others -SOLUTION ( Gary Krockover 2004)
  63. Re: Table sorting by selected category then others ( Gary Krockover 2004)
  64. Re: Table sorting by selected category then others ( "Jesse Crofoot" 2004)
  65. Re: Table sorting by selected category then others ( "Jesse Crofoot" 2004)
  66. Table sorting by selected category then others ( Gary Krockover 2004)
  67. Re: Date sorting ( charles kline 2004)
  68. Re: Date sorting ( Tim Robinson 2004)
  69. Re: Date sorting ( Jesse Proudman 2004)
  70. Date sorting ( charles kline 2004)
  71. Re: Sorting Problems ( Toby Cox 2004)
  72. Re: Sorting Problems ( Brian Fries 2004)
  73. Re: Sorting Problems ( Glenn Busbin 2004)
  74. Re: Sorting Problems ( Pat Holliday 2004)
  75. Re: Sorting Problems ( Glenn Busbin 2004)
  76. Re: Sorting Problems ( Brian Fries 2004)
  77. Re: Sorting Problems ( Joe D'Andrea 2004)
  78. Re: Sorting Problems ( Gary Krockover 2004)
  79. Sorting Problems ( Pat Holliday 2004)
  80. Re: oddball sorting problem ( Terry Wilson 2003)
  81. Re: oddball sorting problem [feature request] ( Donovan Brooke 2003)
  82. Re: oddball sorting problem ( Brian Fries 2003)
  83. Re: oddball sorting problem ( Terry Wilson 2003)
  84. Re: oddball sorting problem ( Donovan Brooke 2003)
  85. oddball sorting problem -- almost okay now ( Terry Wilson 2003)
  86. Re: oddball sorting problem ( Tim Robinson 2003)
  87. Re: oddball sorting problem ( "WebDna @" 2003)
  88. oddball sorting problem ( Terry Wilson 2003)
  89. Re: Sorting like UBB ( "Gary Krockover" 2003)
  90. Sorting like UBB ( "Gary Krockover" 2003)
  91. Re: sorting... ( Tim Robinson 2003)
  92. Re: sorting... ( Brian Fries 2003)
  93. Re: sorting... ( "Andrew Simpson" 2003)
  94. sorting... ( Alan White 2003)
  95. Re: Sorting by highest number of matches unique to a field ( Alain Russell 2003)
  96. Re: Sorting by highest number of matches unique to a field ( Glenn Busbin 2003)
  97. Re: Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  98. Re: Sorting by highest number of matches unique to a field ( Glenn Busbin 2003)
  99. Re: Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  100. Re: Sorting by highest number of matches unique to a field ( Brian Fries 2003)
  101. Re: Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  102. Re: Sorting by highest number of matches unique to a field ( "WebDna @" 2003)
  103. Re: Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  104. Re: Sorting by highest number of matches unique to a field ( Kenneth Grome 2003)
  105. Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  106. Re: Sorting alphabetical ( Rob Marquardt 2003)
  107. Re: Sorting alphabetical ( Steve Dannaway 2003)
  108. Re: Sorting by multiple fields ( Brian Fries 2003)
  109. Re: Sorting by multiple fields ( "Justin Carroll" 2003)
  110. Re: Sorting by multiple fields ( "Gary Krockover" 2003)
  111. Sorting by multiple fields ( Justin Carroll 2003)
  112. Re: Sorting alphabetical ( Christer Olsson 2003)
  113. Re: Sorting alphabetical ( Frank Nordberg 2003)
  114. Sorting alphabetical ( "Nitai @ ComputerOil" 2003)
  115. Re: sorting... (Kalin Mintchev 2003)
  116. Re: sorting... (Brian Fries 2003)
  117. sorting... (Kalin Mintchev 2003)
  118. Archives not sorting properly (Gary Krockover 2003)
  119. Re: Sorting Various Sizes (Daryl Mitchell 2003)
  120. Sorting Various Sizes (Kimberly D. Walls 2003)
  121. Re: Sorting nested search (Alain Russell 2003)
  122. Re: Sorting nested search (WJ Starck 2003)
  123. Re: Sorting nested search (Alain Russell 2003)
  124. Re: Sorting nested search (WJ Starck 2003)
  125. Re: Sorting nested search (WJ Starck 2003)
  126. Re: Sorting nested search (Donovan home EHG 2003)
  127. Re: Sorting nested search (WJ Starck 2003)
  128. Re: Sorting nested search (Donovan home EHG 2003)
  129. Re: Sorting nested search (Tim Robinson 2003)
  130. Sorting nested search (WJ Starck 2003)
  131. Re: Sorting a [listfiles] (Jay Van Vark 2003)
  132. Re: Sorting a [listfiles] (Nitai @ ComputerOil 2003)
  133. Re: Sorting a [listfiles] (Brian Fries 2003)
  134. Re: Sorting a [listfiles] (Nitai @ ComputerOil 2003)
  135. Sorting a [listfiles] (Erol Guneri 2003)
  136. Re: Sorting a [listdatabases] (Donovan 2003)
  137. Sorting a [listdatabases] (Matthew Bohne 2003)
  138. Re: Quick Data sorting questions (Jeff Logan 2002)
  139. Re: Quick Data sorting questions (Charles Kline 2002)
  140. Quick Data sorting questions (Jeff Logan 2002)
  141. Re: Sorting when searching with grouped fields (Myron Hintz 2002)
  142. Re: Sorting when searching with grouped fields (Brian Fries 2002)
  143. Re: Sorting when searching with grouped fields (Myron Hintz 2002)
  144. Re: Sorting when searching with grouped fields (Brian Fries 2002)
  145. Re: Sorting when searching with grouped fields (Myron Hintz 2002)
  146. Re: Sorting when searching with grouped fields (Brian Fries 2002)
  147. Re: Sorting when searching with grouped fields (Myron Hintz 2002)
  148. Re: Sorting when searching with grouped fields (Alain Russell 2002)
  149. Sorting when searching with grouped fields (Myron Hintz 2002)
  150. Re: re-sorting founditems (Kenneth Grome 2002)
  151. Re: re-sorting founditems (Alex McCombie 2002)
  152. Re: re-sorting founditems (Brian Fries 2002)
  153. Re: re-sorting founditems (charles kline 2002)
  154. re-sorting founditems (Yariv Nachshon 2002)
  155. Re: Sorting ip addresses (Dale Therio 2002)
  156. Re: Sorting ip addresses (Gary Krockover 2002)
  157. Re: Sorting ip addresses (Andrew Simpson 2002)
  158. Re: Sorting ip addresses (Glenn Busbin 2002)
  159. Sorting ip addresses (Gary Krockover 2002)
  160. Re: Sorting problem (Don 2002)
  161. Re: Sorting problem (Don 2002)
  162. Re: Sorting problem (Brian Fries 2002)
  163. Re: Sorting problem (Don 2002)
  164. Re: Sorting problem (Don 2002)
  165. Re: Sorting problem (Anup Setty 2002)
  166. Re: Sorting problem (Kenneth Grome 2002)
  167. Re: Sorting problem (Brian Fries 2002)
  168. Re: Sorting problem (Glenn Busbin 2002)
  169. Re: Sorting problem (Don 2002)
  170. Re: Sorting problem (Don 2002)
  171. Re: Sorting problem (Kenneth Grome 2002)
  172. Re: Sorting problem (Glenn Busbin 2002)
  173. Re: Sorting problem (Don 2002)
  174. Re: Sorting problem (Gary Krockover 2002)
  175. Re: Sorting problem (Don 2002)
  176. Re: Sorting problem (Glenn Busbin 2002)
  177. Re: Sorting problem (Don 2002)
  178. Re: Sorting problem (Don 2002)
  179. Re: Sorting problem (Brian Fries 2002)
  180. Re: Sorting problem (Glenn Busbin 2002)
  181. Re: Sorting problem (Glenn Busbin 2002)
  182. Re: Sorting problem (Don 2002)
  183. Re: Sorting problem (Glenn Busbin 2002)
  184. Re: Sorting problem (Glenn Busbin 2002)
  185. Sorting problem (Don 2002)
  186. Re: Sorting via date (Kenneth Grome 2002)
  187. Re: Sorting via date (Jeff Logan 2002)
  188. Re: Sorting via date (Matthew Bohne 2002)
  189. Re: Sorting via date (Jeff Logan 2002)
  190. Re: Sorting via date (Matthew Bohne 2002)
  191. Sorting via date (Jeff Logan 2002)
  192. Re: Sorting Number with commas (John Peacock 2001)
  193. Re: Sorting Number with commas (Brian Fries 2001)
  194. Sorting Number with commas (Joseph Sullivan 2001)
  195. Re: Help: sorting in found set. (Marc M. 2001)
  196. Re: sorting in found set. (Marc M. 2001)
  197. Re: Help: sorting in found set. (Brian Fries 2001)
  198. Re: Help: sorting in found set. (Brian Fries 2001)
  199. Help: sorting in found set. (Marc M. 2001)
  200. Re: sorting in found set. (Bob McPeak 2001)
  201. Re: (random sorting) (Brian Fries 2001)
  202. Re: Sorting by number (Clint Davis 2001)
  203. Re: Sorting by number (Jeff Logan 2001)
  204. Re: Sorting by number (Clint Davis 2001)
  205. Re: Sorting by number (Paul Fowler 2001)
  206. Sorting by number (Jeff Logan 2001)
  207. Re: Sorting by sku (Glenn Busbin 2001)
  208. Sorting by sku (Craig Forest 2001)
  209. Re: sorting question... (Clayton Randall 2001)
  210. Re: sorting question... (Glenn Busbin 2001)
  211. Re: sorting question... (Parker 2001)
  212. Re: sorting question... (Clayton Randall 2001)
  213. sorting question... (Parker 2001)
  214. Re: advanced sorting (Alain Russell 2001)
  215. advanced sorting (Andrew Simpson 2001)
  216. numeric sorting (Celeste Paul 2001)
  217. Re: numeric sorting (Will Starck 2001)
  218. Re: ListFiles Sorting (WebDNA Support 2000)
  219. Re: ListFiles Sorting (Gary Krockover 2000)
  220. Re: ListFiles Sorting (Kenneth Grome 2000)
  221. Re: ListFiles Sorting (Gary Krockover 2000)
  222. ListFiles Sorting (Bob Minor 2000)
  223. Re: Sorting a summary (Joseph D'Andrea 2000)
  224. Sorting a summary (Jeff Grady 2000)
  225. Re: Sorting (Paul Berman 2000)
  226. Re: Sorting (John Butler 2000)
  227. Re: Sorting (Paul Berman 2000)
  228. Re: Sorting (John Butler 2000)
  229. Re: Sorting (Paul Berman 2000)
  230. Re: numeric sorting (Nicolas Verhaeghe 2000)
  231. Re: numeric sorting (WebDNA Support 2000)
  232. Re: numeric sorting (Brian Boegershausen 2000)
  233. numeric sorting (Max Utter 2000)
  234. Re: Sorting problems (Kenneth Grome 2000)
  235. Sorting problems (Marc 2000)
  236. sorting [listwords] feature request (Peter Ostry 2000)
  237. Re: breaking & sorting (Rodolfo de la Garza 2000)
  238. Re: breaking & sorting (Rodolfo de la Garza 2000)
  239. Re: breaking & sorting (Rodolfo de la Garza 2000)
  240. Re: breaking & sorting (Jaishankar Jayaram 2000)
  241. Re: breaking & sorting (Jaishankar Jayaram 2000)
  242. Re: breaking & sorting (Kenneth Grome 2000)
  243. breaking & sorting (Rodolfo de la Garza 2000)
  244. Re: breaking & sorting (Jaishankar Jayaram 2000)
  245. Re: Sorting (Anup Setty 2000)
  246. Re: Sorting (dale@gmr.dresdner.net 2000)
  247. Sorting (Rónán 2000)
  248. Re: Sorting search by date. (Wilkins, John 2000)
  249. Re: Sorting search by date. (Mark Derrick 2000)
  250. Re: Sorting search by date. (Kenneth Grome 2000)
  251. Sorting search by date. (Mark Derrick 2000)
  252. Re: Sorting Dates in a search (Nico 2000)
  253. Sorting Dates in a search (Eric Palhof 2000)
  254. Re: sorting on date in search (Kenneth Grome 2000)
  255. sorting on date in search (Jimmi Kristensen 2000)
  256. Sorting Dates (Eric palhof 2000)
  257. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (Christopher Feyrer 2000)
  258. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (John Butler 2000)
  259. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (John Butler 2000)
  260. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (Dale LaFountain 2000)
  261. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (John Hill 2000)
  262. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (John Butler 2000)
  263. random sorting broken (was Re: Re[2]: php vs WebCatalog) (Dale LaFountain 2000)
  264. Re: Date sorting (Kenneth Grome 2000)
  265. Date sorting (Bjřrn Are Solstad 2000)
  266. Featured results and sorting. (Christopher Feyrer 2000)
  267. Re: sorting by date Y2K mix up (Brian B. Burton 2000)
  268. Re: sorting by date Y2K mix up (Kenneth Grome 2000)
  269. sorting by date Y2K mix up (Laurent Pladys 2000)
  270. Re: Does summarizing found records require sorting on that samefield? (Smith Micro Support 1999)
  271. Re: Does summarizing found records require sorting on that same field? (John Butler 1999)
  272. Does summarizing found records require sorting on that same field? (John Butler 1999)
  273. Re: Sorting by type=date (webcat 1999)
  274. Re: Sorting by type=date (Kenneth Grome 1999)
  275. Sorting by type=date (webcat 1999)
  276. Re: Sorting Results (Howard Wolosky 1999)
  277. Re: Sorting Results (RH Prouty 1999)
  278. Re: Sorting Results (Arthur Frischman 1999)
  279. Re: Sorting Results (PCS Technical Support 1999)
  280. Sorting Results (Arthur Frischman 1999)
  281. Re: sorting by date (PCS Technical Support 1999)
  282. Re: sorting by date (Kenneth Grome 1999)
  283. Re: sorting by date (Kenneth Grome 1999)
  284. sorting by date (Richard 1999)
  285. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  286. Re: Dates - Search and Sorting (Mike_Davis 1999)
  287. Re: Dates - Search and Sorting (PCS Technical Support 1999)
  288. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  289. Re: Dates - Search and Sorting (RH Prouty 1999)
  290. Re: Dates - Search and Sorting (RH Prouty 1999)
  291. Re: Dates - Search and Sorting (RH Prouty 1999)
  292. Re: Dates - Search and Sorting (Howard Wolosky 1999)
  293. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  294. Re: Dates - Search and Sorting (RH Prouty 1999)
  295. Re: Dates - Search and Sorting (RH Prouty 1999)
  296. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  297. Dates - Search and Sorting (RH Prouty 1999)
  298. Re: Crazy dates (was: Re: sorting dates) (Christer Olsson 1999)
  299. Re: Crazy dates (was: Re: sorting dates) (Martin Bech 1999)
  300. Re: Crazy dates (was: Re: sorting dates) (John Hill 1999)
  301. Crazy dates (was: Re: sorting dates) (Christer Olsson 1999)
  302. Re: sorting dates (Kenneth Grome 1999)
  303. Re: sorting dates (bradeisenberg@iname.com 1999)
  304. Re: sorting dates (Bill Heissenbuttel 1999)
  305. Re: sorting dates (Bill Heissenbuttel 1999)
  306. Re: sorting dates (PCS Technical Support 1999)
  307. Re: sorting dates (bradeisenberg@iname.com 1999)
  308. Re: sorting dates (PCS Technical Support 1999)
  309. sorting dates (bradeisenberg@iname.com 1999)
  310. sorting dates (bradeisenberg@iname.com 1999)
  311. sorting dates (bradeisenberg@iname.com 1999)
  312. sorting problem for sku=0? (Olin Lagon 1998)
  313. Re: Sorting by SKU Not Working (Martin Gertz Bech 1998)
  314. Re: Sorting by SKU Not Working (charles kline 1998)
  315. Re: Sorting by SKU Not Working (PCS Technical Support 1998)
  316. Sorting by SKU Not Working (charles kline 1998)
  317. Re: Goofy Date Sorting (Michael Winston 1998)
  318. Re: Goofy Date Sorting (Peter Ostry 1998)
  319. Goofy Date Sorting (The Mooseman 1998)
  320. Re: Sorting search results (Will Starck 1998)
  321. Re: Sorting search results (Kenneth Grome 1998)
  322. Sorting search results (Will Starck 1998)
  323. Re: Help with sorting search results sorting (Will Starck 1998)
  324. Re: Help with sorting search results sorting (Gary Richter 1998)
  325. Help with sorting search results sorting (Will Starck 1998)
  326. Re: Sorting (Dave MacLeay 1998)
  327. Sorting (Mícheál O Sé 1998)
  328. Re: sorting and grouping (Michael Winston 1998)
  329. Re: sorting and grouping (bob 1998)
  330. sorting and grouping (Joe Wilkins 1998)
  331. Re: sorting and grouping (Dave MacLeay 1998)
  332. Re: sorting and summarizing (Terry Wilson 1998)
  333. Re: sorting and summarizing (John Hill 1998)
  334. re: sorting and summarizing (Terry Wilson 1998)
  335. sorting and summarizing (Terry Wilson 1998)
  336. Re: Sorting Round 2 plus (Gil Poulsen 1998)
  337. Sorting Round 2 plus (The Mooseman 1998)
  338. Re: Sorting a Search... (Laurent Pladys 1998)
  339. Re: Sorting a Search... (Kenneth Grome 1998)
  340. Sorting a Search... (eVenture Communications 1998)
  341. Re: Sorting (Kenneth Grome 1998)
  342. Re: Sorting (jgrady@totalsports.net (Jeff Grady) 1998)
  343. Re: Sorting (PCS Technical Support 1998)
  344. Re: Sorting (Gary Richter 1998)
  345. Sorting (jgrady@totalsports.net (Jeff Grady) 1998)
  346. Re: Quick Question About Sorting (Kenneth Grome 1997)
  347. Re: Quick Question About Sorting (John Hill 1997)
  348. Quick Question About Sorting (Trevor Crist 1997)
  349. Re: Sorting problem (Kenneth Grome 1997)
  350. Sorting problem (kmuelle3@ix.netcom.com 1997)
  351. Re: User Defined Sorting (Kenneth Grome 1997)
  352. User Defined Sorting (Mark Anderson 1997)
  353. Re: date sorting and 'template (Grant Hulbert 1997)
  354. date sorting and 'template (Dan Keldsen 1997)
  355. Re: item sorting (Grant Hulbert 1997)
  356. Re: item sorting (Kenneth Grome 1997)
  357. item sorting (Eddie Lutz 1997)
  358. Re: Searching/sorting dates (Grant Hulbert 1997)
  359. Searching/sorting dates (Christer Olsson 1997)
  360. Re: Sorting Orders (Grant Hulbert 1997)
  361. Sorting Orders (John Benn/PetsForum Grp <76703.4256@CompuServe.COM> 1997)
  362. Re: Date Sorting (Kenneth Grome 1997)
  363. Date Sorting (Tim Rignold 1997)
  364. Re: Sorting LISTFILES (Grant Hulbert 1997)
  365. Sorting LISTFILES (John Benn/PetsForum Grp <76703.4256@CompuServe.COM> 1997)
  366. Re: Sorting error (John Hill 1997)
  367. Re: Sorting error (Kenneth Grome 1997)
  368. Re: Sorting error (Michael Winston 1997)
  369. RE: Sorting error (Marc Eagle 1997)
  370. Re: Sorting error (Michael Winston 1997)
  371. Re: Sorting error (Michael Winston 1997)
  372. Re: Sorting error (John Hill 1997)
  373. Sorting error (Michael Winston 1997)
  374. Re: Sorting error (Kenneth Grome 1997)
  375. Re: Sorting error (Kenneth Grome 1997)
  376. Re: Sorting error (John Hill 1997)
  377. Re: Date sorting (Kenneth Grome 1997)
  378. Re: Date sorting (Britt T. 1997)
  379. Date sorting (Britt T. 1997)
  380. Re: Date Sorting (Grant Hulbert 1997)
  381. Re: Date Sorting (Glenn Davis 1997)
  382. Date Range Sorting (w curt eggemeyer 1997)
  383. Re: Date Sorting (Grant Hulbert 1997)
  384. Date Sorting (Glenn Davis 1997)
  385. Re: Sorting Numbers (John Hill 1997)
  386. Re: Sorting Numbers (Kenneth Grome 1997)
  387. Re: Sorting Numbers (Kenneth Grome 1997)
  388. Sorting Numbers (Mick Matousek 1997)
  389. Re: Sorting by date (Trevor Crist 1997)
  390. Re: Sorting by date (Trevor Crist 1997)
  391. Re: Sorting by date (Trevor Crist 1997)
  392. Re: Sorting by date (marty@artwerks.com (Marty Schmid) 1997)
  393. Re: Sorting by date (Grant Hulbert 1997)
  394. Re: Sorting by date (Marty Schmid 1997)
  395. Sorting by date (Trevor Crist 1997)
  396. Re: Sorting by date (Grant Hulbert 1997)
  397. Searching and Sorting (WebDNA Team [Sea)
I have tried removing NEWITEMsort=1&NEWITEMsdir=as and my results still do not appear as I would like them to. Ideally I would like to have all items that have YES in the NEWITEM field to be returned alphabetically at the top of the list, then all other items returned alphabetically at the bottom of the list this way the new books are listed at the top of the page. PCS Technical Support wrote:> >I am trying to return a search in a specific order. Within the context > >of a hyperlink I would like to have all items that have the value YES > >in the NEWITEM field of a database listed at the top of the founditems, > >then all others that meet the search criteria would follow. I have > >tried the following syntax with no luck: > > > > >HREF=/cgi-bin/items.tpl?command=search&db=../products.db&eqSTORE1datarq=golf&w > >sTYPE1datarq=Books&eqPRONAMEdatarq=[url][PRONAME][/url]&cart=[cart]&searchPRONAM > >E=[url][PRONAME][/url]&eqNEWITEMdata=YES&NEWITEMsort=1&NEWITEMsdir=as&max=150 > > > >target=body>[PRONAME] > > Try removing NEWITEMsort=1&NEWITEMsdir=as > > Sounds like you want the default ranking, which means better matches are > at the top of the list. You get this ranking by *not* specifying any > particular field to sort on (because if you tell it to sort by NEWITEM, you > are forcing that to be the sort field, which undoes the nice ranking). The > default ranking puts records at the top of the list that have more field > matches, which in your case puts NEWITEM=YES above all others, followed by > records that do not have NEWITEM=YES. > > Technical Support | ==== eCommerce and Beyond ==== > Pacific Coast Software | WebCatalog, WebMerchant, > 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, > San Diego, CA 92128 | Typhoon > 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ jgrady@totalsports.net (Jeff Grady)

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:

Cart passing in URL.. (2004) WebCatalog 4.0 has been released! (2000) synching databases on multiple servers (1997) [WebDNA] WebDNA app (2013) 4.51 Triggers (2003) Integration with SQL (1997) Plugin or CGI or both (1997) InternetWeek E-Commerce article (1998) Question (2001) adding up in a db (1997) WebCat2.0b15-to many nested [xx] tags (1997) 5.0 Pricing (2003) [WebDNA] need decoded url in sendmail (2015) Bulk Email >>>>Any ideas? (2001) Multiple cart additions (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Bug Report, maybe (1997) SetMIMEHeader ATTN:John P. (2001) View order not right (1997) Too Much Rootbeer Free Offer (1997)