Amend database query in asp
Budget: £20 – £250 GBP
Please check the documents in the attachment.
I am looking for four corrections/additions to the attached database query (this can be viewed on the live site here: https://www.tour-tips.com/fpdb/mens.asp):
1/ There is an error when displaying page 2 (and later) of database results if the text entry in either the 'Event', 'Course' or 'Location' text box does not fully match the text entry in the database field.
Examples are:
https://www.tour-tips.com/fpdb/mensdisplay.asp?chkConfig=0&pgn=&Year=All&Month=All&Tour=All&Event=KLM&Course=&Location=&Firstname=&Surname=&chkEvent=&chkCourse=&radiobutton=on&chkLocation=&numrec=50&Submit=Search
https://www.tour-tips.com/fpdb/mensdisplay.asp?chkConfig=0&pgn=&Year=All&Month=All&Tour=All&Event=&Course=Whistling&Location=&Firstname=&Surname=&chkEvent=&chkCourse=&radiobutton=on&chkLocation=&numrec=50&Submit=Search
https://www.tour-tips.com/fpdb/mensdisplay.asp?chkConfig=0&pgn=&Year=All&Month=All&Tour=All&Event=&Course=&Location=Jersey&Firstname=&Surname=&chkEvent=&chkCourse=&radiobutton=on&chkLocation=&numrec=50&Submit=Search
Can you fix this?
2/ On the database results page, there is an option to display the results as a chart in Adobe Flash Player. Adobe have ended the Flash Player, so the chart cannot be displayed. Please remove the code relating to the chart on the mensdisplay.asp so that this option is no longer viewable on the page.
3/ With event, course and player names, my users often fail to spell them correctly on the database query page, so no results are displayed in the resulting database results page. Is there a way to EITHER display suggestions for close matching names in a resulting page so the user can correct the entry OR display the results using the closest match in the relevant field in the database, similar to a Google search when it shows the results for a close match as well as offering a link to 'Search instead for [the misspelt word]'?
4/ Is it possible to add an option to export the results within the database results table as a csv file for the user?
Thanks
Tony
I am looking for four corrections/additions to the attached database query (this can be viewed on the live site here: https://www.tour-tips.com/fpdb/mens.asp):
1/ There is an error when displaying page 2 (and later) of database results if the text entry in either the 'Event', 'Course' or 'Location' text box does not fully match the text entry in the database field.
Examples are:
https://www.tour-tips.com/fpdb/mensdisplay.asp?chkConfig=0&pgn=&Year=All&Month=All&Tour=All&Event=KLM&Course=&Location=&Firstname=&Surname=&chkEvent=&chkCourse=&radiobutton=on&chkLocation=&numrec=50&Submit=Search
https://www.tour-tips.com/fpdb/mensdisplay.asp?chkConfig=0&pgn=&Year=All&Month=All&Tour=All&Event=&Course=Whistling&Location=&Firstname=&Surname=&chkEvent=&chkCourse=&radiobutton=on&chkLocation=&numrec=50&Submit=Search
https://www.tour-tips.com/fpdb/mensdisplay.asp?chkConfig=0&pgn=&Year=All&Month=All&Tour=All&Event=&Course=&Location=Jersey&Firstname=&Surname=&chkEvent=&chkCourse=&radiobutton=on&chkLocation=&numrec=50&Submit=Search
Can you fix this?
2/ On the database results page, there is an option to display the results as a chart in Adobe Flash Player. Adobe have ended the Flash Player, so the chart cannot be displayed. Please remove the code relating to the chart on the mensdisplay.asp so that this option is no longer viewable on the page.
3/ With event, course and player names, my users often fail to spell them correctly on the database query page, so no results are displayed in the resulting database results page. Is there a way to EITHER display suggestions for close matching names in a resulting page so the user can correct the entry OR display the results using the closest match in the relevant field in the database, similar to a Google search when it shows the results for a close match as well as offering a link to 'Search instead for [the misspelt word]'?
4/ Is it possible to add an option to export the results within the database results table as a csv file for the user?
Thanks
Tony