I've got about 400 Billion (slight exaggeration) towns listed in a table of an Access db. Client wants to be able to sort them alphabetically by town name. Small problem - a significant number of them are prefixed by "Town of " or "City of ." So, for example, "City of Zanzibar" would be incorrectly listed before "Dansville" and "Town of Abernathy" would be incorrectly listed after "Smithtown."
How can I phrase the SQL query to ignore those prefixes when sorting them? They still need to keep the prefix when they are displayed, however. What I think I need is some sort of conditional statement that says if the town name starts with Town of or City of, trim off those first 8 characters (includes the spaces) before sorting, otherwise, just sort as usual.
What should happen is if the record has terms_req=no the the go link will do as its doing now. If however the record has terms_req=yes then the go link should go to the terms.asp as it does now.
Client then reads the terms and either agrees or declines. If they agree the "agree" button/link should forward them on to their original request.
As of now have not been able to get the original url request to carry through to the terms.asp page.
Have listed the request.server.variables available to the terms page just in case it helps anyone figure this out.
We have an ASP application running on Windows Server 2003 that is not functioning correctly. The original page for the application is login.asp. I have login.asp configured as one of the default pages for the application. As long as I bring up the site http://sitename/appname , the login.asp page loads fine.
If I call http://sitename/appname/login.asp, I get a "The system cannot find the file specified. " error. If I use the http://sitename/appname call to bring up the site, the login.asp page loads fine the first time but fails when I submit the login form back to itself. Very strange behavior!
Any ideas which may cause the page to load when used as the default page but not when it is explicitly called?
It displays the following User name: Cable/rmirto7777. Now I would like to remove the Cable/ part and just keep rmirto7777 only. Keep in mind that Cable/ part doesn't change only what comes after it and everyone has a different User name. Therefore it changes constantly! I tried alot of ways by using the function but came unsuccessful. Does anyone have any ideas on how I can achieve this goal by getting what comes after Cable/ to display on my page.
This is a follow up to a question I asked two weeks ago which I thought was solved but on further inspection I realised it wasn't working fully. I have an ORDER BY on my search results page, the search uses two dropdown menus, the first one is start character (A-Z), and the other is grade.
The problem I have is that the ORDER BY work perfectly when I leave the start character dropdown blank, and when I use the grade selection dropdown, but when I select a start character I get this error message:
An ASP page outputs data from the query "Select ThisAndThat from comments WHERE pageURL='" & pageURL & "' ORDER BY threadID, datesent" (Access mdb) threadID is a string (OK, I know!), which means that 103 displays before 99. Is there a way to write the SQL query to order them numerically? This would be much easier for me than changing the data type and hunting down every page that INSERTS or UPDATES the db.
I am extremely confused about how i should go about doing this: I have puled out current orders and have displayed in a table .These orders have their own order numbers.
Once the person clicks on first order,the order is displayed in a form,where the user can edit the order details and hit submit.
Now when he hits submit ,I want his to go the previous page where the orders are displayed in table ,so that he can click on the next order and process it/OR may be whent he user hits submit ,i want the next order directly to be displayed in the form.
I have a table in my database with several numbers.(2, 5, 8, 0, 9, 0).Now i retrieve the numbers to my page using "order by numbers", and my page look like this.
0 0 2 5 8 9
I want the lowest number to be first, but if the number is 0 (zero) I want it to go to the bottom.Can that be done
I have one table wich has a unique ID feild for each record and other feilds, and another table that has one field that is a number that contains the an ID from the other table and another field that contains some text.
I want to open with sql the first table, but order its records alphabetically by the text in the second table. is it possible? Code:
When I have the recordset in the order as follows, all works well: (Recordset2.Fields.Item("ProductName").Value) (Recordset2.Fields.Item("ShortDescription").Value) (Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does'nt show.
I've got a site with PayPal and Google Checkout payment options. The checkout page formats two HTML forms, containing bespoke cart code - one posts to PayPal, the other to Google Checkout.When an order is placed, it needs to be updated back on my site, so that the order is marked as 'paid' in the database. When this is done with PayPal, I just provide a hidden field in the form called 'invoice' containing my id number for that transaction. This is returned in my IPN, and I update the database accordingly. However, I can't find a similar field in Google. Their example code all seems to be in XML and is WAAAAAAAAY more complicated than I need it to be. I just need to send a value with my cart code to Google Checkout, and have that value returned after the transaction has completed. I've set up Google Callback, and the page is being called and the order is being written to my google log txt file, I just need this to contain my order id number for the transaction so I can just add the logic to update the database based on this id number.
I've written the following piece of code which is embedded in HTML. For some reason when the script is processed the last response.write statment is displayed before the information in the while loop. I can't seem to figure out why this is happenming.
I'm working on a list of members.In my db I have two columns lastName and marriedName lastName is the member name before they got married and legLastName is their lastname after they got married.
Now I need to display theese two columns in alphabetical order in one list. If I for example have theese members: lastName, marriedName Anderson, Johnson Petersson, Svensson Nilsson, Persson Lindgren, Johnson
I want this result: Anderson Johnson (look for Andersson) Johnson(look for Lindgren) Nilsson Persson(look for Nilsson) Petersson Svensson(look for Petersson)
I am processing the variables from a form submission with a for/next loop. The problem is that the order of the variables are NOT written IN ORDER.
Form field 1 prints fine but then it jumps to Form field 9 and then back to Form field 4 then to Form field 2, etc. IS there a way to process the form variables in a loop in ORDER? field 1, field 2, field 3, etc? Code:
And one clicks on the form, and a SQL statement is executed. However, when I create the SQL statement,
INSERT INTO table1 (FormId,AdvantageId,SortOrder) VALUES (<call from form ID>,<advantages>,<advantsort>)
Then it loops to allow the next phrase to be entered. The statement also takes the value from every other sort order value including that ones that are in different lines. Which in result, gives me an error, saying the insert columns exceed that of the available columns in the table.
how to display search results on my web site in an order that I specify. at the moment there ordered by the primary key which means there all over the place.I know what the code is but I'm not sure how to use it, can anyone give me a quick lesson, does the code need to be on the search page or the results page?
I have a small webadministration system that allow the users to create new menu items in the website´s menu.But when new record is inserted the new menu item allways comes first in the menu (becouse I sort it that way).How can I allow the users to change the menu item order like "home - about - contact". So when new record is created the user could add the new category between "about and contact"?I have Access database and the category table has sort field.
I have a table that is comprised of numbers, and infinity is -1.How can I use descending ORDER BY with -1 coming first?For example, I'd like to have results like this:
I am making my site using MySQL and asp scripting. I have a field in the database with Text as for property. It contains greek letters. My problem is that I cant ORDER them in the page. The ORDER is wrong.I have make this db using phpMyAdmin cp.Is there something I am doing wrong? I am using the statement as I did for Access.
I am trying to use an order by statement where it displays all records with the newest ones first, I have a database value called SDate which is formatted DD/MM/YYYY and my statement is as follows:Code:
sql = "Select * from news SORT BY SDate DESC
The error im getting is:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. /index.asp, line 104
I've tried adding a ; on the end of DESC but still no luck.
