Turn Negative Number To 0

I am trying to turn negative numbers to dispaly the value of 0. I have a field called new_past_due I am looking for something like this >

**********************
<%IF new_past_due = >0 then new_past_due = "0"%>

Is there anybody out there that knows the anser to this one?

View Replies


ADVERTISEMENT

Negative In ASP

This is probably a simple one for you. How do I write the following

I want to say

if AcceptCancel=Accept and VStatus is not equal to X Then

If ((AcceptCancel = "Accept") AND (VStatus != "X")) Then

The mistake is probably the "!". Where do I put it?

View Replies View Related

Turn Recordset

I want to create two dynamically linked list boxes.Instead of hardcoding in the arrays to accomplish this, I want their contents to come from a Recordset.

What I need to know is how to turn the Recordset into a local array and then how to create the select lists from the array contents.

View Replies View Related

Turn Locahost

Is it possible for testing purposes turn a locahost into somename.com?

View Replies View Related

DateDiff Coming Up Negative

I was going to use the DateDiff function for something, so I looked up the syntax real quick at w3schools. Here's what they have:

document.write(Date & "<br />")
document.write(DateDiff("m",Date,"12/31/2002") & "<br />")
document.write(DateDiff("d",Date,"12/31/2002") & "<br />")
document.write(DateDiff("n",Date,"12/31/2002"))

Output:1/14/2002
11
351
505440

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?

View Replies View Related

Turn Calculated Field

I am trying to trun some numbers into currency using a calculated valuein a query.Although the result formats the results as currency, it sorts as a string would. Here is my statement:

Penalty:
IIf([datClaimPaidDate]-[datClaimLtrDate]>30,FormatCurrency(([datClaimPaidDate]-[datClaimLtrDate]-30)*50),"")

how to get this to return as actual currency that will sort like currency?

View Replies View Related

Turn Off Field With Radio Button

Im having a little trouble with a simple form request My form has a field for people to add the filename that they saved their document in. Once that is entered my submit page takes the filename and adds the hyperlink html and the mapped path to that directory That way even "less intelligent" people can add hyperlinks to the database The problem Im having is that i cant find the code to make it to where if the value of a radio button is true then not to request the hyperlink field.

Don't get me wrong I am very much a newb at this so I assume its really easy or there is something Im not grasping here. So I guess the question is, Is there a simple line of code to relate a radio button to another form field?

View Replies View Related

Fomat Currency - Negative Values

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.

View Replies View Related

Formatcurrency Puts ( ) For Negative Numbers

formatcurrency function puts ( ) for negative numbers(e.g. (111) ). How can I display the negative numbers with a minus sign infront like -111.

View Replies View Related

Turn Off Show Friendly HTTP Error

how can i turn off 'Show Friendly HTTP Error Messages' in IE Browser to get a better error message?

View Replies View Related

Need To Perform Form Validation For Negative Numbers And Letters In Textboxes

I have two URLs. Static.htm and dynamic.asp

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.

How can I achieve that?

View Replies View Related

Convert Real Number Into Text Number

I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?

View Replies View Related

Sequential Number After Batch Number

here is the scenerio

in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003

Now each master batch can have multiple final mixed batch like

200701-0001-01
200701-0001-02
200701-0001-03

and this record is inserted in to fmix table.

so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,

how to achieve this

so in short each master batch will have more than one final mixed batch.

pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.

View Replies View Related

Retrieve The Error Number In VB With Err.Number

I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.

How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?

View Replies View Related

Number

if I dispaly certain column data from database, how to make the auto numbering in front of each data?for example

1. ha
2. ho
3. hu

let say the ha, ho and hu is data that call from database column.

View Replies View Related

Whole Number

Can you help me with this? Is there any function that I can use in getting a
whole number

Example:

Input OutPut
12.3 12
1.63 1
21.1 21

Im using the function left(p1,p2) but it doesnt recognize the whole number

View Replies View Related

Err.number <>0

I have an error statement in place which i would like to catch when a problem aoccures and assign a value to Compensation.
Code:

If Err.number<>0 then

If iCount Mod 2 = 1 Then
objRS.Move ((iCount + 1)*0.9)-1
Compensation = Int(objRS(0))
Else
objRS.Move (iCount*0.9)-1
Compensation = objRS(0)
objRS.MoveNext
Compensation = (Compensation + objRS(0))/2
End If
Else
Compensation = 0
End If

at the moment,Compensation seems to always have the value of 0 even when an error is not evident. Have i got this the wrong way around?

View Replies View Related

Number

i m getting such number 3001/e-00084308/00/000
so each time i want to change 00 to 01 in above number

View Replies View Related

Number IP

I want to have the address IP of the client's machine. I have made this.

<b>Your IP address is:</b>
<%Response.Write(Request.ServerVariables("remote_addr"))%>
</p>

but It give me the address of my host I wish I have IP of the machine client.

View Replies View Related

Avg Number

I am using the code below to count the number of records and divide it by the sum of the records to get the average number. I get the error : Type mismatch: 'ubound' . I know I'm missing something obvious as my experience with arrays have rendered below.

<% PriceArray = Recordset1("TotalBidPrice") %>

<%
for x = 0 to ubound(PriceArray,2)
CountArray = CountArray + PriceArray(0,x)
next

ThePriceAvg = CountArray/(ubound(PriceArray,2) + 1)
%>

<%=ThePriceAvg%>

View Replies View Related

Not A Number

How do you check if a value is "not a number" in Visual Basic? Ie:

If textbox is not a number then
msgbox "Please enter a valid number"
Else
.............
End If

View Replies View Related

ID Number

I have a form on my site, in the form there is a field called ticketid, I want this field to be prepopulated everytime the user opens the form, Also would like to have it start with 1000 so if the it gets open second time its 1001, third time 1002 and so on. Code:

View Replies View Related

Null Number

Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'ContactID', table 'ka0506a.ka0506a.contacts'; column does not allow nulls. INSERT fails.
/submitcontact.asp, line 15

What happened is i used to used MS Access and ContactID is an Autonmuber field, and now my connection is set to MS SQL so it's giving me this error, what's causing this error to happen and how can i change it ?

View Replies View Related

Number In A Repeater

I have a repeater that pulls back informtion from a MySQL database. I was wondering how could I put a counter that increments as each row is returned and displays it in the repeater. For example where it says Day:, I want to make that Day: 1, Day: 2 etc as each row is returned.

The Day: 1++ is just a demonstration of what i want incremented.

<asp:Repeater ID="RepeaterUserReportSummary" runat="server">
<ItemTemplate>
<table style="width: 990px">
<tr>
<td style="width: 185px;height: 10px;"><b>Day: 1++ </b></td>
<td style="width: 35px;height: 10px;"><b>Total:</b><%# Eval("TotalReport")%>cal</td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>

View Replies View Related

Number Of Records

Any build in function that can calculate number of records in a table?

View Replies View Related

How To Round Up A Whole Number?

I've created a freight calculator that needs to know how many pallets I'm shipping. I'm using 1 pallet for 750lbs and an extra pallet for anything more than that.

If materialWeight <= 750 Then numPallets = 1 Else numPallets = Round(materialWeight / 750) End If

Now, let's say the materialWeight/750 ends up being 3.2. This is returning 3, but I need it to return 4 since we need an extra pallet.

How can I make it Round up to the next whole number? If it turned out to be an exact number without a decimal then it should stay where it is, but if it's over x.0 at all it should go up to the next whole number.

View Replies View Related

Number Truncation

Is there a command in asp to truncate a decimal? Currently I've got a number that's coming out with up to about 12 decimal places based on input fom the user and I'd like to force it to just display up to two decimal places. Is that possible?

View Replies View Related

How Can I Know My IIS Version Number?

I am using w2000+sp4 server with IIS running, how can I know my IIS version
number, is it iis5.0 or 5.1 or 6.0?

I must know this, since I want to download patches from MS web site,

View Replies View Related

Number Of Bytes

When we are using ENCTYPE="multipart/form-data" for file uploading, we can use Request.TotalBytes to get the total number of bytes sent by the user in http. Is it possible to get the bytes of a specific field from that form

View Replies View Related

Get Week Number

Does anybody know how I can get the week number. The week number we are currently on is 28 and I need to be able to reitrieve this number so that i can manipulate for loops to advance that number to 33 and 38.

View Replies View Related

Number Of Options

I have an ASP variable which is a certain number. I want to create a Select tag in a form, which will be populated up to this number. So, for example, if my number was 7, you would have a list of numbers between 0 and 7 to select.I'm not sure how to do loops, but I had an idea that the code would look something like this:
Code:

<select name="select2" id="select">

<%
for i=0 to i=varNumber
Response.Write ("<option value='"& i &"'>"& i &"</option>")
rsBooking.MoveNext
%>

</select>

but, as you might guess, this doesn't play!

View Replies View Related

Number Exponentiation

I want to trim a number and display the integer and decimals
separately, as such I'm trying to convert it to a string so I can
truncate it.
No matter what combination of int or CStr I try, VBScript displays
long numbers such as:

345332523545325425235255453.6789555

in its exponentiated form:

3.45332523545325E+26

How can I stop this?Alternatively is there a function that will separate the two for me?

View Replies View Related

Sum Of Number Records

I have a results page which retrieves a number. I am using "Repeat record" to get a list of all the number records of the database.

I would like to make a sum of all these records at the end of the result page.

record1 = 100 (repeat region)
record2 = 500
record3 = 100

and then, how can I make a sum of these records?

Total = 700

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved