I put the same code into a simple test document to verify, except for mine has Response.Write. All my numbers came out negative. If I reverse their positions, I get positive numbers. Is the example above wrong or is there something going on with my PC?
IN an ASP page I am using the following number formatting for currency, Code:
<%=FormatCurrency(RS("increvhigh"), 2, -1, -1)%>
When I put in my data as a negative number, it is saved to the Access database with parenthesis around the negative number. When I go to the ASP page to display records as line items, the record with the negative value will not display.
Static.htm Contains a form with two text boxes, called text_1 and text_2 and some other info that is irrelevant for my question.
Dynamic.asp Need some code to check that the text boxes only contain values greater than 0 and only numbers. Thus if any of the textboxes for example contain -3 or the letter m I want to cancel the form submission and display some kind of error message.
I have seen a code to populate a list box from a data base table. Earlier I gave my own values using HTML coding like :
<Option Value="P-159">P-159</Select>. It was working fine but not after using code to build a list box, it is not coming in form value as input and next redirecting page retutns with error:
two codes pages are attached : profile page and search page. Profile page sends input to search page and search pages returns the output.
i created a global.asa file with notepad and put it in the root directory
<SCRIPT LANGUAGE="VBScript" RUNAT="Server"> Sub Session_onStart() session("mary") = "mary" End Sub
</SCRIPT> now in my asp code i put <%=session("mary")%>
and restarted my machine, and check the value of mary and there was none whats wrong here? I didnt put a reference in my asp page to the global.asa file. I assume asp looks for it itself ?
I can't figure out why all of a sudden my variable s1 doesnt have a value once I hit the submit button. Here's my long extensive code. The important bits are the part where I response.write the s1 and s2 and s3 values, they show up on the first page but when I hit the submit button for some reason, they have no value anymore.
I'm showing page contents text coming from database, normally the contents are plain text or in html formatting... it works fine.. but I want to add ASP code within page contents, as well... i did try but it dispalys ASP code as it is in the output...
is there any way to execute those asp code lines coming from database...?
A few days ago all my Request.ServerVariables began coming up empty. I was using Request.ServerVariables("AUTH_USER") for basic authentication but now its useless. Our server administrator tells me he installed some "patches" last week but doesn't think he caused the problem. All I can say is that before the patch they worked fine. Anyone have any ideas on where to look for a solution?
I run a site and one of our services is a "free online quote" .I've made the whole form, including the .asp backbone to send it off (the file itself is .asp, but im pretty sure the language is in VB). It was working fine, but now the forms will come back blank most of the time. I know they cannot be submitted blank, because I have required feilds there.
The weird thing is, it was working flawlessly, then it started to crap out once or twice, now it rarely submits a real one.It might not be my coding, but I am really lost at this point.I'm using godaddy for a host btw.
This is my first asp form so please be gentle with me It's a publications ordering form. I've got the form and the asp code setup, when the form is sent the name of the publication comes through but not the amount ordered - i'm sure i've made a simple mistake somewhere - can anyone spot why the order amount isn't coming through. Code:
I am trying to replicate the Ebay Time Left on Auction. 1 Day, 1 hour, 12 minutes. I would like to calculate this from the current time and date. How do I get this result?
I'm creating a Help Desk Call Track System... one of the fields we want to store is the length of time the call was "Open." When the call is logged, the Now function is used to pull the date in vbGeneralDate format. When the call is closed, Now is again used to pull the date in the same format.
Our current system uses hours to track calls To give an example of what is making it to the database...
The value stored in the database is... Duration = 14
I'm assuming that it is reading back to 12:00 AM and counting the hours up till 2:00 PM. I'd like to be able to do fractions of hours (displayed in decimals).
i have an if else satemement and this part here checks to see if today's date is eactly two weeks away from the expirydate in the database.... however nothing happens so when i did a resopopnse.write i got the datediff difference of 223 ??!! how do i solve this problem?
i have an if else satemement and this part here checks to see if today's date is eactly two weeks away from the expirydate in the database.... however nothing happens so when i did a resopopnse.write i got the datediff difference of 223 ??!! how do i solve this problem?
I have a calendar that I am trying to make users fill out a form if their entry is inside the current week. Is there a datediff code that anyone knows of that can do this?
I want to be able to pull all the records from a table "Accounts" which are more than 7 days old. The attribute "DateCreated" stores the date the account was created.
I've tried "SELECT * FROM Accounts WHERE DateDiff('dd', DateCreated, Now()) > 7" but this is coming up with an error (I'm using MS Access db by the way)
i need select statements that counts records from my access database where the time difference is worked out between two fields (datein;dateclosed). Less than 24 hours, >3 days, >5 days, >10 days, >15 days, >30 days, >60 days, >90 days
i am not sure how to construct the statement. If i can just get one, i can hopefully do the rest.
i have now:
strSQL2 = "SELECT Count(*) As Total FROM ptqr WHERE DateDiff('d','" & datein_now & "','" & dateclosed &"')< 1 "
but i get an error: Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression.
/asp/ford_tsb/pscs/reports/charts/Chart5.asp, line 40
I have a datediff comparision value on my form. Since one of the dates inside the datediff is: now(), I'd like to know if there's a way to show the result dinamically (without reloading the page..). I can't see how to do it from server side...It's possible to use js to fill the field or reload only the field value? detail: I'll need to submit the current diftime value along the other input values on my form at the end of process.
I'm having trouble working out the best way of calculating the time difference between two times on the same day. The example I have found des return the hours (in this case 8) but forgets the minutes. I am looking to return the hour & the minute but i've had a look at the dateDiff format and this doesn't seem possible ?
