Condition loop

Closed Posted Jan 7, 2003 Paid on delivery
Closed Paid on delivery

The code below is a section of an ASP page. The page when loaded should along with other functions send an ASPMail email when the var "NewInv" is less then var "Threshold". The page works, except it sends an email everytime(condition true or not). The values are correct as they are sent with the email and I have checked them. Here is the code that performs the loop. <% [url removed, login to view] CurrentRecord = 0 Do While NOT [url removed, login to view] Threshold = RSOrder("THRESHOLD") Inv = CInt(RSOrder("Inv")) Qnty = CInt(RSOrder("Quantity")) NewInv = ((Inv)-(Qnty)) Set Mailer = [url removed, login to view]("[url removed, login to view]") [url removed, login to view] = "ROS PrintShop" [url removed, login to view] = "email" [url removed, login to view] = "server" [url removed, login to view] "ROS Inc", "email" [url removed, login to view] = "ROS CP Printshop Order" [url removed, login to view] = "A new order has been made. Order details are listed below" & vbcrlf [url removed, login to view] = "---------------------------------------------------------" & vbcrlf [url removed, login to view] = "SKU: " &RSOrder("PRODUCT_ID") [url removed, login to view] = "Current Inventory: " &NewInv [url removed, login to view] = "Threshold Value: " &Threshold [url removed, login to view] = "-------------------------------------------------------------------------" & vbcrlf [url removed, login to view] = "Login to manage this order. [url removed, login to view]" If NewInv < Threshold Then [url removed, login to view] Set Mailer = Nothing End If AttA = RSOrder("AttributeA") AttB = RSOrder("AttributeB") AttC = RSOrder("AttributeC") If AttA <> "" Then ATTResponse = AttA End If If AttB <> "" Then ATTResponse = AttResponse&", "&AttB End If If AttC <> "" Then ATTResponse = AttResponse&", "&AttC End If ATTResponse = ATTResponse&" " %>

| **<%= RSOrder("PRODUCT_ID") %>** | |

ASP Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #2896819

About the project

14 proposals Remote project Active Jan 16, 2003

14 freelancers are bidding on average $37 for this job

amsterdamd

See private message.

$3.4 USD in 14 days
(99 Reviews)
5.8
DiegoCalp

See private message.

$5.1 USD in 14 days
(51 Reviews)
5.6
hsedidin

See private message.

$17 USD in 14 days
(36 Reviews)
4.6
sarderhasnut

See private message.

$42.5 USD in 14 days
(54 Reviews)
4.8
omiossec

See private message.

$29.75 USD in 14 days
(15 Reviews)
4.7
javabeevw

See private message.

$17 USD in 14 days
(18 Reviews)
3.9
bemasvw

See private message.

$17 USD in 14 days
(45 Reviews)
3.7
visiontechvw

See private message.

$68 USD in 14 days
(3 Reviews)
3.4
amitabhkant

See private message.

$4.25 USD in 14 days
(7 Reviews)
1.9
techmarkvw

See private message.

$61.2 USD in 14 days
(0 Reviews)
0.0
psinfosys

See private message.

$170 USD in 14 days
(0 Reviews)
0.0
codestrom

See private message.

$63.75 USD in 14 days
(0 Reviews)
0.0
expertcoder

See private message.

$4.25 USD in 14 days
(0 Reviews)
0.0
vw666434vw

See private message.

$8.5 USD in 14 days
(0 Reviews)
0.0