Ordering Records With Blank Fields Last
I've written an ASP page that pulls all records from a table. My query
is 'SELECT * FROM teacher ORDER by Class'
It is working fine... sorta. The table has about 20 records, but only
5 have an entry in the 'Class' field. The 15 records with the blank
class field show up first, then the other 5 records. Is it possible to
have the blank one show after the ones with an entry. Here's how my
results look, IOW. Code:
View Replies
ADVERTISEMENT
All my fields give that error when I try to leave it blank when inserting a new record. The field is not required in the database, so what do I have to do to insert it as blank?
SQL:
Code:
INSERT INTO Tablename (REQUIRED, NOTREQUIRED) VALUES ('tag', '')
Error:
Code:
[Microsoft][ODBC Microsoft Access Driver] Field 'Tablename.NOTREQUIRED' cannot be a zero-length string.
View Replies
View Related
I am writing an application which when the code first loads there is a form which all the fields are blank. I then need to test some date fields to check if the end date is before the start date etc. The form fails to work. So I then wrote a test asp page which has a single box I then use an If...
Else statement if it is Blank then do nothing if it has data in the text box then display a message. The form works ok until I input text and then it does not detect any input text in it and therefore does not display the message. This is totally the oppoisite of the original application which does not detect the form is empty. Code:
View Replies
View Related
I'm using ASP FormMail to collect user info, but now I'm trying to figure out how to modify the code so that any blank fields from the form will not be displayed on the confirmation page/email. I tried to modify the code below in bold, but it gave me a syntax error. Code:
View Replies
View Related
I have created a database were you submit a job by entering the fields which is fine if it is a site visit but if it is a phone call or remote help not all the fields need to be filled in but if there not filled in it wont submit the values to the database i get data mismatch error code is below.
I either need to be able to send them blank values to the database or ideally i wont to create a option box with Phone call, Site visit and remote help which when selected takes you to the correct page which have different values in the form to fill in.
View Replies
View Related
I have entries in the database that have spaces (Todd's Place) but when I try to get the info into an input box it only shows the first part of the string before the space (Todd's) Here is my code
strSQL = "SELECT ID, memname FROM tblMembers WHERE ID =" & numID
Set rsEdit = adoCon.Execute (strSQL)
<input type=text value=<%= rsEdit.Fields("memname").Value %>>
The funny thing is I can see the whole string when I view the source on the page (<input type=text value=Todd's Place>) but why can't I see it in the form.
View Replies
View Related
I created a feedback form for my website that has only 2 required fields. When you submit the form it calls my asp page which puts the information in a database and then sends me n email with the information that was entered into the form. The problem is that the form only has two required fileds, and if the remaining non required fields are left empty when the asp page is called it does write to the data base, but does not send me any email. However if I go back in and put somethng in every field in the form then when I submit the form and my asp page is called it writes to the data base and sends me an email with the all the information I entered in the feedback form. Is there a way to tell my asp page that it is ok to send the email even if the non required fields are left empty? I really do not want to have to go back through the form and put default values in for each area of the form? Also is there a way to have an error displayed if the email is not sent? My asp code is below....
View Replies
View Related
I want to display the contents of a field with a label if there is data in that field. If there isn't then I don't want the label to appear.
I tried this:
<%If Venueinfo("email") = "" Then
Else%>Email: <a href="mailto:<%=Venueinfo("email")%>">Click to
email</a><br><%End If%>
But it doesn't seem to work. It seems to always display the label and link even though there is no data in that field.
View Replies
View Related
i need to open a recordset, then from the records that i get i need to put one field into a string. i'm not sure how to go about this hope i explained this properly, shout if i didn't .
View Replies
View Related
I've got 4 records in my lovely database table. The table contains 5 fields, lets say: id, number, name, age and sex. All I want to do is to get all the values (form all 4 records) of the "number" field and put all 4 of the values in to one variable.
The output have to look something like this : numbers: 001, 002, 003, 004.
I tired, honestly, I really did. But didn't find a solution.
View Replies
View Related
i need to oredr a set of numbers. the numbers are "06/9","95/1","95/6","06/3" and so on. the thing is that these need to be ordered form the second number, so it shoudl be ordered thus: "95/1","06/3","95/6","06/9". how can i do this? at the moment just as an attempt im splitting the number either side of the "/" like this:
var regNo = "12/09"
var yearStart = 0
var yearEnd = regNo.indexOf("/")
var year = regNo.substring(yearStart, yearEnd)
var itemStart = regNo.indexOf("/") + 1
var itemEnd = regNo.length
var itemNo = regNo.substring(itemStart, itemEnd)
but where do i go form here?
View Replies
View Related
what is an easy way to go about sorting my search results through links, you know, like clicking the link at the top of a column. i know how to pass the order by in a querystring:
http://www.example.com?lastname=smith&firstname=john&state=GA&orderlast=desc
where orderlast is the order querystring.
but what about all the other links? what do I do with the previous querystring entries like lastname, firstname, and state? i find if i add orderlast to my lastname column and i click on it, i will have 2 orderlast querystrings
View Replies
View Related
I have an ordering form w/c user can input their information It is about an online ordering of niche(for cremated) and user can select their NicheLevel(1-8) and their LotLocation(Lot1-Lot20).
I have a NicheLevel and NicheLocation in my DB table named CustomerInfo now i want to happen is: if the customer select their NicheLevel and LotLocation the DB validate the NicheLevel and LotLocation and if its already reserved it will not send to my DB and a
response message telling that it was already reserved. Im using ASP & JavaScript.
View Replies
View Related
I have a database with 3 fields in it ... photoname, price, job. I'm hoping to set up a drop down menu, which changes the "ORDER BY" part of the SQL query line, to one of those field names. That would enable a user to order the records (being served from an access database), by either name, price or job.
I know that it's got something to do with "request.form", but I don't know how to get the variable from the form to the SQL query. It would be 100% perfect, if the drop down menu automatically posted, when it was changed, so that it didn't need a submit button. But I think I might need to figure that out myself .
View Replies
View Related
I have an application that rips data from an SQL server and displays it in
columnar form on an ASP page, using a Do until RS.EOF loop.
I wish to add 2 arrows to each column (up and down) and when clicked, orders
the data on the page by that column (up - A-Z and down Z-A etc.....)
Is this possible in ASP or would i need some Javascript/Client side code to
do this?
The problem is the ASP SELECT statement orders the data initially, i just
need to know how the user can re-order the data after it is on the page?
View Replies
View Related
i have a price field that i want to order the prices from smallest to greatest
Set rsProducts = Server.CreateObject("ADODB.recordset")
SQLProducts = "SELECT * FROM tblProducts Where pr_Cat='" & Request.QueryString("Cat") & "' AND pr_SubCat1='" & rsSubcat1("pr_SubCat1") & "' AND pr_SubCat2='" & rsSubcat2("pr_SubCat2") & "' Order By pr_Price Desc"
rsProducts.open SQLProducts, Conn
thats what i have.but it prints out.
$899.00
$1975.00
$1655.00
$1425.00
Can anyone figure this out?
View Replies
View Related
Does anyone know of a good script that already exists to do the following? Allow a user to enter a sort orderIf the order exists replace the existing one with the new and bump the old up or down accordinglyIf it doesn't exist add as newMake sure there are no gaps in numbering.
View Replies
View Related
I'm just wondering if there is ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? I really need that feature for one of my customer.
If it is not available could you please suggest a product that has this feature?
View Replies
View Related
We’re just wondering if there is an ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? We really need that feature for one of our customer.
If it is not available could you please suggest a product that has this feature?
View Replies
View Related
I'm just wondering if there is ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? I really need that feature for one of my customer.
If it is not available could you please suggest a product that has this feature?
View Replies
View Related
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
View Replies
View Related
What I need to know is how to click on a button that is labeled NEW, as in new record, and have the current form open to data input. That is a blank record. After the user then inputs the data to all the fields on the screen and hits the SAVE button the record will then be placed into the database table.
View Replies
View Related
I am trying to use AUTH_USER from request.servervariables but the field is
blank. I am using Windoze server 2003 with IIS5. I know there is a fix
because I did it a long time ago with our old NT server running IIS4 but I
cant remember how I got it to work. We are all authenticated users on our
Domain so this is available, I am able to get IP info and such. I seem to
remember some kind of ASP code that did the fix by altering the way the web
server displays info.
View Replies
View Related
The host Im useing is useing plesk as its control panel if anyone has ever heard of that...I hadnt until this site.
when I try to load a asp page on my site it just loads a blank page.
The page is a data base editor page that I had built useing fp 2002
all my other asp pages load fine.
But this one just loads a blank white page
No errors no nothing. Code:
View Replies
View Related
I had a problem for a while where data was added on its own, and BLANK data. I found out it was because i was opening the processPage.asp to see if it was working, so that was inputting data out of the form that wasnt there. So i get blank data. Is there anyway i can make the process work ONLY if there is data in the form?? Code:
View Replies
View Related
I am creating a directory of suppliers.I have a form that collects data - business name, address1, address2, town, city, county, country, postcode.
The data is stored in separate fields in an Access database. Another page is used to display the data, one field per line. However, if some of the fields are blank, I want to suppress the blank liens as at the moment I am getting:
My Business Name
1 High Street
Any Town
Any County
Postcode
United Kingdom
View Replies
View Related
I have a drop down list, values coming from a db, when I come into the form I want it to have no value - how do I do this? Also, if I want to capture the value that a person selects from the drop down list do I need to use a session variable if I want to print it to the screen after they select it?
View Replies
View Related
I want to clear the date in a field in an access table by entering a blank. Does anyone know the syntax for that in the select statement? This is via an asp page
The select statement I am trying to use
<code>
strQ ="Update Inquiries set ShutOffDate= 00/00/0000 WHERE CustomerID = "&CustomerID&""
</code>
View Replies
View Related
I'm getting some errors in my .asp code somewhere but I can't seem to figure them out because all I get is a blank 500 error screen. I don't get any description of the error, just a blank screen so I don't know what the problem is.
Just wondering if there's a way to get the results easily because I do not have admin rights to the server so I can't make a custom 500 error page or i would.
View Replies
View Related
We use Vignette V5.6 to display our site. In our CMA site, we have a page which has FRAMESET and in one of the frames we call a ASP page. There seems to be some problem that the frame shows the ASP page is blank. When we restart the IIS it works fine. But after some time it again shows the blank.
If we get one blank page, all the asp pages under the same virtual directory, called in the Frame shows blank. FYI. The Vignette template which contains the frame is marked for NO caching & For itnernal use only.
View Replies
View Related
I want to know how I can check if a querystring exists, whether it has a value or not.
Basically I would like to use test.asp?login without having to use ?Login=blah.
View Replies
View Related
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
View Replies
View Related
I have an online application made up of ASP pages (IIS 5.0 on Windows 2000 Server) drawing data from a SQL Server database. Most of the time, everything works exactly as it should. Connections are opened to the database, queries are run and data is returned and writen out, connections are closed, etc.
However, every so often a page simply won't load. It isn't trying to load and then timing out or anything, it's like it's ignoring the page entirely. It shows the correct URL in the address bar of IE, but there's nothing but a blank white page displayed. Viewing the source of the blank page reveals that instead of the correct code for the page, we get this: Code:
View Replies
View Related