Hello Dear experts,
I have only done what I am about to ask in asp, not in access as front end tool.
We have a bunch of images stored on our server (folder).
We have built an access application which allows the display of images per record.
For instance, if you open an access form or...
I forgot to post the sql code I am getting after response.write:
SELECT S.* FROM tblShipping S INNER JOIN Zones Z ON S.Zone=Z.Zone WHERE Z.LowZip <= AND Z.HighZip >= AND S.fromWeight <= 8 AND S.toWeight >= 8
All I am trying to do is get shippingCharges where zipcode is between lowzip and...
hi Chopstick,
As embarrassed as I am to say this, it never occured to me to do response.write.
Thanks for the reminder.
I took the sql to an access database (that's what I am using) and ran it like this:
SELECT S.* FROM tblShipping S
INNER JOIN Zones Z ON S.Zone=Z.Zone
WHERE...
I beg of you experts for your patience and expertise in resolving this error.
I have been dealing with this now for 2 days.
It really is kicking my tail.
I have 3 segments of code.
I will post the one that is having the error but if you have questions that relate to other pages, I will...
Hello gurus,
Can I ask for a big favor of you, please.
I created 2 tables:
One table is called shipping and another is called products.
The products table houses all of our products including shippingWeight of each product.
The shipping table is a lookup table for shippingWeight.
It has...
I am not sure if I am in the right forum for this question but please direct me if I am not.
I upgraded my hard drive from 4 gigs to 80 gigs and re-installed windows 2k professional, everything seems to work fine.
I even downloaded and installed critical updates and patches from microsoft...
thanks much for the response.
I am more worried about how to automatically add this total to the cost of customer's purchase during checkout.
For instance, the below code will add tax to total customer purchase:
global.asa
Sub Application_OnStart
'Tax percentage to add to order total...
hi Chris,
Thanks for the response and sorry for my late response.
Ok, as indicated in my first post, stateCode, zip, fromWeight, toWeight, shippingCharges are from a table called shipping while shippingWeight is from a table called products.
Can someone, please assist me one more time?
I have a page called checkout.asp as part of an ecommerce site we are building.
The way we have it written so far, it calculates tax and adds the tax to customer's total purchase based on a 5% tax.
Right now, we are trying to change that; we don't...
mwolf00, thanks so much for your assistance on this and I am sorry for late response.
A couple of follow-ups, please.
One, we really didn't want to enter blockname;
in other words, we have a page that contains 2 windows:
routeName | Blockname
If you click on routeName, all blocknames...
Dear experts,
I have a table structure with following attributes:
route_Name, blockNmae, blockID, route_ID
RouteID is a unique id but blockID is not.
A route_Name is associated with blockName.
This means that route_name can have one blockName or many blockNames.
So, you could have a...
Please forgive me for this cheap question.
Please take a look at the code below:
<table width='100%' border=1 cellspacing=0 cellpadding=0 bordercolor="aqua">
<tr>
<td class=bodytextcolor width='33%' align=center nowrap>
<img src="Images/dress_search.jpg" align="center"...
hi SantaMufasa,
Thanks very much for your kind response.
How would I use the If statement here?
I guess my confusion is where to use the IF statement?
Should I use it after record has already been inserted (with the insert statement above)?
oR Should it be used before the insert statement...
hello Oracle gurus,
It's been quite awhile since I have worked with Oracle.
Today, I have been asked to modify an existing code but I am stumped as to how to proceed.
Per code below, The changes that I am asked to make says that there is a parameter called new_fresh.
If new_fresh = 'R' ( R...
Sorry Chris, I had to give God Thanks - I went to church.
Chris said:
>Best bet is allow the processor to collect the CC >numbers. up to them to do all the validity and anti-fraud >checks then.
Well, I did try to get them to process the CC while we collect contact information but they said no...
Thanks Tarwn and Chris,
My client deals with UPS and according to him, it is *not* the carrier that puts restrictions on maximum weight capacity that can go into certain states; it is the shipping law of that state.
I must add here that UPS has a link that allows customers to weigh their items...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.