I am storing a datetime into SQL Server 2000 field in datetime format. For single-digit months and dates, it is leaving the 0 off, like this:
11/6/2003
1/5/2003
For reasons having to do with technical requirements, I need to have it put the 0 in when needed, and not do it when it already has 2 digits:
11/06/2003
01/05/2003
How can this be done? When I get the value of the date in the first place, it is using the Now() function. For some fields, I only need the date, not time, so I do a DateValue around the result of the Now. Is this solved with ASP? Or do I need to do something in SQL Server?
I've got a little shopping cart app which when you use all of the links on the pages, and buttons etc, things are good, the "shopping basket" on the left navigation updates and shows a sum of items and cost.
However, if you arrive at the home page for example, proceed to the products page, add an item and then click "back", you get a cached page.
I appreciate there are some lines of code I can use, both ASP and html to prevent the cachine, but what I dont want to incur instead is that error IE (and other browsers too I guess - how very Microsoft of me - shows when the page has expired, I think that would probably be worse than the cart not showing any items (or not showing the update) until a link was pressed.
I am trying to force the last option selected in a drop down!, I basically have a page with a drop down box in which sends to itselfs when selected, the idea is the selected value updates a postage amount depending on the country selected from the dropdown.
However when it returns to the page it defaults back to 'select country' and I would really like it to be able to display the option selected as this is part of the address form.
the relevant country is correct, and i am putting that into a request.querystring so this variable (destination) is available to test/compare against and maybe force select this way, but i just don;t know how to write the asp/html to make the select value go to either this variable or the last one selected. Code:
First the brief: I'm currently developing an intranet at work. We have approximately 3000 users and they keep forgetting their passwords. We have 3 Tech-Support guys who keep having to reset them. The idea was to build a function in to the intranet to allow department heads to be able to reset other users passwords via asp.
All well and good. After a fair bit of reading, I've acquainted myself with the basics of talking to Active Directory and retrieving various objects, properties and values.
My problem is that when I try to update any of the objects (i'm focusing on the .description property at the moment 'cos when I break it - that's not gonna matter so much) But when I try and SetInfo, I get a General Access Error. My ServerVariables("LOGON_NAME") is empty. I was wondering if there was a way to force an asp page to run as the server administrator 'cos obviously when department heads login, we don't want all of them to be AD Admins. All they should be able to do is run my script to reset a password.
I'm not actually the server admin, and don't really know the specifics of IIS, but can I just tell it to run specific scripts as domainadmin? Or can I pass something in the asp headers to force it to authenticate as admin?
This is probably an easy answer, however my mind seems to have gone blank about scanning a barcode in, and taking the 1st 4 digits of the number and storing it into a session variable to be referenced later in this application. This session variable will then be checked against an ACCESS database to see if the product exists. I assume I use the LEN function? LEN(VariableName, 4)?
I saw in SPF an ASP code that was usable to hide the first digits of a credit card number and replace them by a "*". I'm really sorry to post such a thread, but I can't find it back. Does anyone have the link? I've tried to check it in the funky functions and sections like that. Maybe just missed it but well. tried to see many times.
when I calculate a Digits for example: 101.12 * 1.21 the resilt is 122.3552 This one should be 122.36 and if it is 122.3549 to be 122.35 How can I make this thing works?
I have the following code at the top of my page. Is there a way to force Excel to open the spreadsheet? Presently, it opens within the browser window. I know it can be saved etc., but I would rather have Excel receive the data.
if i have a link that allow user to download an application from an server, is like Code:
<a href="wss1/daemon tools.exe"></a>
after i clicked this link, i will be link to an pop up windows to specified the save path location.How do i set the save path location to a dedicated destination or file?is like when i click on the link then it will automatic without pop up and then save into that dedicated location?
I have an access database with a table called jobs with a field called 'jobnumber'. I have this set up with a format mask of "0000" so that "1" becomes "0001" etc. However when pulling this data out in Dreamweaver the formatting is lost.
Does anyone know how I can set this in Dreamweaver?
I am trying to convert the date in DD/MM/YYYY format so it is always displayed as 01/01/2004 instead of 1/1/2004.The script I am trying to embed this into has similar attributes to the Calendar on this site located at http://www.asp101.com/samples/calendar.asp.and the objects that require to be double digits are iCurrent and Month(dDate).
I am using Ms Access database and I have set 3 digits (e.g. 000) for an autonumber field of my table.Its working fine in Access and incrementing automatically like this (001, 002, 003 ...), but when I call the data on a web page using ASP its displaying these numbers like this (1, 2, 3, 4 ...) I dont understand why is it not displaying the numbers as it is in the table.
in my asp form i would like to have a field which can ONLY accept digits BUT can accept special characters as well such as: &,$$,##. i.e: if the user enters :
147hhh, or P44556HH or QSSPE$% ---> this will be invalid ##123,45SS---> this is invalid 125&125#10$---> this is valid 12456--> this is valid too
I currently am using a script which submits full state names to a payment processor. However, the payment processor only accepts 2 digit state names. Does anyone have a premade code for asp that converts state names into 2 digit ones.
example:
If statename = "New York" Then statename = "NY" End If
I output a list of towns from a database via a normal recordset loop into a normal paragraph with links - BUT for some reason it is totally pushing the page out... is there any reason for this? I also placed trim() on the town name in case there were lots of mistaken spaces, etc. Code:
i have a form for users to enter their name password and e-mail,i am currently using javascript to check that all details have been filled,
if(myForm.fname.value=='') { alert("Plz enter a first name") return false }
This works if the field is left blank however if the user enters numbers(1,2) or spaces i.e.(" ") how do i deal with these,i also need to check that the e-mail contains "@" and "."
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
i'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.
I am trying to compare two dates. My problem is no matter what the value of mydate, it is still fall in the first IF statement condition (even if mydate is 10/10/2004). Any advise for this matter?
mydate = "6/6/"&year(date) IF date() <= mydate THEN response.write "first half of the year" ELSE response.write "second half of the year" END IF
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
