SunQuest
           Database Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers Forums > Other Technologies > Database Help
Reload this Page

I need help urgently!

Discuss I need help urgently! in the Database Help forum on Codewalkers.
I need help urgently! General SQL help. Help with MySQL, MSSQL, Oracle, mSQL, PostgreSQL, etc.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old May 2nd, 2003, 12:17 AM
Gibran Gibran is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Location: Concord, NSW, Australia
Posts: 5 Gibran User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via ICQ to Gibran
I need help urgently!
Hi Everyone! I need someone to help me quickly...

I just bought a website (http://www.ihandicraft.com) and I am also completely new to SQL.

There is something I need to do on the website.

When you add an item to the cart the shipping cost on "viewcart.asp" is displayed in Indian Rupees. I want the shipping cost to be displayed in US$.

So can someone tell me or help me change the shipping cost on "viewcart.asp" from Indian Rupees to US$, and can you please do it step-by-step. I am new to SQL.

Thank you so much!!!

Gibran Selman
Reply With Quote
  #2  
Old May 2nd, 2003, 02:18 AM
wfactor wfactor is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 14 wfactor User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
RE: I need help urgently!
Hi,

You may want to paste the .asp file on here so we can see the code.

You could search through the asp file and find where it refers to currency.
Reply With Quote
  #3  
Old May 2nd, 2003, 02:35 AM
Gibran Gibran is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Location: Concord, NSW, Australia
Posts: 5 Gibran User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via ICQ to Gibran
RE: I need help urgently!
Hi There!

Thanks, here is the complete code. The SQL code is within the asp code I copy below:

<%Option Explicit%>
<%Response.Expires = 0%>
<%Response.CacheControl="Private"%>
<%Response.AddHeader "cache-control", "private"%>
<%Response.AddHeader "pragma", "no-cache"%>
<%
If Request.Form("CustID") <> "" Then

Session("CustID") = Request.Form("CustID")
Session("Ship") = Request.Form("Ship")
Session("ShipMethod") = Request.Form("ShipMethod")
Session("UPSZone") = Request.Form("UPSZone")

End If
%>
<%
Dim ele, intCount
intCount = 0
For each ele in Session("arrPIDList")
If ele <> "" Then
intCount = intCount + 1
End If
Next
%>
<%
If Request.Form("Sign-in-success") = "True" AND intCount = 1 Then
Response.Redirect "http://www.ihandicraft.com/default.asp"
End If
%>
<!--#include file="dataStore.asp"-->
<html>
<head>
<META NAME="ROBOTS" CONTENT="NOINDEX,NOFOLLOW">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<META http-equiv="Expires" content="0">
<META http-equiv="Pragma" content="no-cache">
<META http-equiv="Cache-Control" content="no-cache">
<title>iHandiCraft.com - Your Shopping Cart</title>
<LINK href="main.css" type=text/css rel=stylesheet>
</head>

<script LANGUAGE="JavaScript">
<!--
// script for popup window
var newWindow, URL
function openWindow(URL)
{
var windowArguments = "toolbar=0,menubar=0,scrollbars=1,resizable=1,statu s=0,copyhistory=no,height=400,width=450,top=0,left =0"
var windowName = "iHandiCraftPop"
newWindow = window.open(URL,windowName,windowArguments);
newWindow.focus();
}

function closeWindow()
{
if(newWindow) newWindow.close();
}

whitespace = " tnr";

function isDigit (c)
{
return ((c >= "0") && (c <= "9"))
}

function isNumeric(s)
{
// Search through characters one by one
// until we find a non-numeric character.
// When we do, return false; if we don't, return true.

for (i = 0; i < s.length; i++)
{
// Check that current character is number or letter.
c = s.charAt(i);

if (! isDigit(c) )
return false;
}

// All characters are numbers.
return true;
}

function isEmpty(s)
{
return ((s == null) || (s.length == 0))
}

function isWhitespace(s)
{
// Is s empty?
if (isEmpty(s)) return true;

// Search through string's characters one by one
// until we find a non-whitespace character.
// When we do, return false; if we don't, return true.

for (i = 0; i < s.length; i++)
{
// Check that current character isn't whitespace.
c = s.charAt(i);

if (whitespace.indexOf(c) == -1)
return false;
}

// All characters are whitespace.
return true;
}

function isGtZero(s)
{
if(s <= 0)
return false;
else
return true;
}

function isLtMOQ(s)
{
if(s >= 101)
return false;
else
return true;
}


function verifyData(theField)
{
if(!theField('Qty'))
{
alert("Invalid Data");
return false;
}


if(theField('Qty').length >0)
{
j = 0;

for(; j < theField('Qty').length;)
{

if(isWhitespace(theField('Qty')(j).value))
{
alert("Quantity Can't Be Empty");
theField('Qty')(j).select();
return false;
}
else
{
if(isNumeric(theField('Qty')(j).value))
{
if(isGtZero(theField('Qty')(j).value))
{
if(isLtMOQ(theField('Qty')(j).value))
{
j = j + 1;
continue;
}
else
{
alert("Quantity exceeds our Customer limit" + 'n' + "Please contact us for Vendor Sign-in");
theField('Qty')(j).select();
return false;
}
}
else
{
alert("Quantity Should Be Greater Than Zero" + 'n' + "You May Remove the Product By Unselecting Tick Mark");
theField('Qty')(j).select();
return false;
}
}
else
{
alert("Quantity Should Be A Valid Number");
theField('Qty')(j).select();
return false;
}
}

}

}
else
{
if(isWhitespace(theField('Qty').value))
{
alert("Quantity Can't Be Empty");
theField('Qty').select();
return false;
}
else
{
if(isNumeric(theField('Qty').value))
{
if(isGtZero(theField('Qty').value))
{
if(isLtMOQ(theField('Qty').value))
{
return true;
}
else
{
alert("Quantity exceeds our Customer limit" + 'n' + "Please contact us for Vendor Sign-in");
theField('Qty').select();
return false;
}
}
else
{
alert("Qunatity Should Be Greater Than Zero" + 'n' + "You May Remove the Product By Unselecting Tick Mark");
theField('Qty').select();
return false;
}
}
else
{
alert("Quantity Should Be A Valid Number");
theField('Qty').select();
return false;
}
}
}
}

function go()
{
document.frmCart.ProcessOrder.value="True"
document.frmCart.AutoUpdate.value="True"
document.frmCart.submit();
}
//-->
</script>

<body MARGINWIDTH="0" MARGINHEIGHT="0" topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" link="#9600FF" vlink="#9600FF" alink="#9600FF">

<!--#INCLUDE FILE="top_navi.htm"-->
<table name="top_bar_table" border="0" cellpadding="0" cellspacing="0" width="100%" height="20" valign="middle" bgcolor="#FFCCFF">
<tr valign="middle">
<td valign="middle" align="right" height="20" width="100%" bgcolor="#ffccff">
<table valign="middle" height="20" width="100%" bgcolor="#ffccff">
<tr>
<td class="TopNavBar" height="20" valign="middle" align="right" style="border-style: solid; border-width: thin; border-width: 1; padding: 0; border-color: #FFFFFF">
<p class="TopNavBar" align="right" valign="middle" style="word-spacing: 0; text-indent: 0; line-height: 100%; margin: 0">
<b><a class="TopNavBar" href="http://www.ihandicraft.com/default.asp"><font face="verdana" size="1">HOME</font></a><font face="verdana" size="1">&nbsp;|&nbsp;</font><a class="TopNavBar" href="https://secure19.activehost.com/ihandicraft/register.asp"><font face="verdana" size="1">REGISTER</font></a><font face="verdana" size="1">&nbsp;|&nbsp;</font><a class="TopNavBar" href="http://www.ihandicraft.com/sign.asp"><font face="verdana" size="1">SIGN-IN/OUT</font></a><font face="verdana" size="1">&nbsp;|
</font><a class="TopNavBar" href="http://www.ihandicraft.com/search.asp"><font face="verdana" size="1">SEARCH</a>&nbsp;|&nbsp;</font><a class="TopNavBar" href="http://www.ihandicraft.com/viewcart.asp"><font face="verdana" size="1">SHOPPING CART</a>&nbsp;|&nbsp;</font></a><a class="TopNavBar" href="http://www.ihandicraft.com/help_cart.asp"><font face="verdana" size="1">HELP</font></a><font face="verdana" size="1">&nbsp;</font></b>
</p>
</td>
</tr>
</table>
</td>
</tr>
</table>

<div align="center">
<center>

<table name="title_table" border="0" cellpadding="0" cellspacing="0" width="95%">
<%If intCount = 1 Then%>
<tr>
<td width="100%" colspan="3" height="20">
<p align="left">
<font face="garamond,georgia,verdana,sans-serif,serif" size="3" color="#FF0000"><b>
Your Shopping Cart is empty.</b></font></p>
</td>
</tr>
<%End If%>

<%If Session("MSG")="Invalid" Then%>
<tr>
<td width="100%" colspan="3" height="20">
<p align="left">
<font face="garamond,georgia,verdana,sans-serif,serif" size="3" color="#FF0000"><b>
Invalid Product.</b></font></p>
</td>
</tr>
<%ElseIf Session("MSG")="Added" Then%>
<tr>
<%If Session("CatPage") <> "" Then%>
<td width="100%" colspan="3" height="20">
<p align="left">
<font face="garamond,georgia,verdana,sans-serif,serif" size="3">
Product #<%=Session("PCode")%> added to your Cart. <a href="http://www.ihandicraft.com/<%=Session("CatPage")%>?ProdPage=<%=Session("ProdPage")%>" onblur="status='';return true" onclick="status='';return true" ondblclick="status='';return true" onfocus="status='';return true" onhelp="status='';return true" onkeydown="status='';return true" onkeypress="status='';return true" onkeyup="status='';return true" onmousedown="status='';return true" onmousemove="status='Return to Product Page';return true" onmouseout="status='';return true" onmouseover="status='Return to Product Page';return true" onmouseup="status='';return true" ondragstart="status='';return true" onselectstart="status='';return true">Continue Shopping</a></font></p>
</td>
<%Else%>
<td width="100%" colspan="3" height="20">
<p align="left">
<font face="garamond,georgia,verdana,sans-serif,serif" size="3">
Product #<%=Session("PCode")%> added to your Cart. <a href="http://www.ihandicraft.com/default.asp">Continue Shopping</a></font></p>
</td>
<%End If%>
</tr>
<%End If%>

<tr>
<td width="100%" colspan="3" height="20">&nbsp;</td>
</tr>
<%If intCount > 1 Then%>
<tr>
<td width="25%" colspan="1" height="20">&nbsp;</td>
<td width="50%" height="40" valign="middle" align="center" style="border-style: double; border-width: thin; border-width: 3; padding: 0" bgcolor="#FFFFFF" align="center">
<p align="center"><font face="georgia,garamond,verdana,sans-serif,serif" size="4"><b>&nbsp;SHOPPING
CART</b></font>
</td>
<td width="25%" colspan="1" height="20">&nbsp;</td>
</tr>
<%End If%>
</table>

</center>
</div>

<div align="center">
<center>

<%If intCount > 1 Then%>

<table name="cart_table" border="0" cellpadding="0" cellspacing="0" width="95%">
<form action="updateCart.asp" name="frmCart" method="POST">

<tr>
<td width="100%" colspan="8" height="15" valign="middle" align="center" style="padding: 0">
</td>
</tr>

<tr>
<td width="100%" colspan="8" height="10" valign="middle" align="center" style="padding: 0">
</td>
</tr>

<tr bgcolor="#9999FF">
<td bgcolor="#ededed" height="15" width="3%" colspan="1" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000"><img border="0" src="images/delete.gif" width="9" height="10"></font></b></td>
<td bgColor="#ededed" height="15" width="5%" colspan="1" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">#</font></b></td>
<td bgColor="#ededed" height="15" width="35%" colspan="1" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">NAME</font></b></td>
<td bgColor="#ededed" height="15" width="15%" colspan="1" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">SIZE</font></b></td>
<td bgColor="#ededed" height="15" width="10%" colspan="1" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">PRICE</font></b></td>
<td bgColor="#ededed" height="15" width="7%" colspan="1" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">QTY</font></b></td>
<td bgColor="#ededed" height="15" width="7%" colspan="1" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">WEIGHT</font></b></td>
<td bgColor="#ededed" height="15" width="18%" colspan="1" valign="middle" align="center" style="border-style: solid; border-width: thin; border-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">AMOUNT</font></b></td>
</tr>

<%
Dim element, intProdCount, i, j, k, intPID, strPSize, strSQL, totalWeight, totalOrderAmount
Dim rsProd, rsProdName, rsProdSize, strPName

totalWeight = 0
totalOrderAmount = 0

Set rsProd = Server.CreateObject("ADODB.Recordset")

For each element in Session("arrPIDList")
intProdCount = intProdCount + 1
Next

For i=0 to intProdCount-1

intPID = cInt(Session.Contents("arrPIDList")(i))
strPSize = Session.Contents("arrPSizeList")(i)

If intPID <> 0 Then

strSQL = "Select * from dbo.ProductDet Where ProdID = "&intPID&" AND ProdSize = '"&strPSize&"'"
rsProd.Open strSQL, strConnect, adOpenStatic, adLockReadOnly, adCmdText
If NOT rsProd.EOF Then

Set rsProdName = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT ProdName from dbo.Product WHERE ProdID = "&intPID&";"
rsProdName.Open strSQL, strConnect, adOpenStatic, adLockReadOnly, adCmdText
If Not rsProdName.EOF Then
strPName = rsProdName("ProdName")
End If
rsProdName.Close
Set rsProdName = Nothing

Set rsProdSize = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * from dbo.ProductDet Where ProdID = "&intPID&" ORDER BY ProdPrice"
rsProdSize.Open strSQL, strConnect, adOpenStatic, adLockReadOnly, adCmdText

Dim sizecounter
sizecounter = 0

While NOT rsProdSize.EOF
If Not rsProdSize("ProdSize") = strPSize Then
sizecounter = sizecounter + 1
Session(sizecounter) = rsProdSize("ProdSize")
End If
rsProdSize.MoveNext
Wend

rsProdSize.Close
Set rsProdSize = Nothing
%>

<tr>
<td bgcolor="#FFFFFF" height="20" width="3%" colspan="1" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2"><INPUT TYPE="CheckBox" NAME="chkPID" VALUE=<%=i%> style="font-family: Verdana; font-size: 10pt" OnClick="go()"></font></td>
<td bgcolor="#FFFFFF" height="20" width="5%" colspan="1" valign="middle" align="left" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2"><%=rsProd("ProdID")%></font></td>
<td bgcolor="#FFFFFF" height="20" width="35%" colspan="1" valign="middle" align="left" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2"><a href="http://www.ihandicraft.com/detail.asp?PCode=<%=rsProd("ProdID")%>&PName=<%=strPName%>"><font color="#000000"><%=strPName%></font></a></font></td>
<td bgcolor="#FFFFFF" height="20" width="15%" colspan="1" valign="middle" align="left" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2"></font>
<SELECT NAME="ProdSize" SIZE="1" style="font-family: Verdana; font-size: 10pt" OnChange="go()">
<OPTION SELECTED VALUE="<%=strPSize%>"><%=strPSize%>
<%For j = 1 to sizecounter%>
<OPTION VALUE="<%=Session(j)%>"><%=Session(j)%>
<%Next%>
</SELECT>
</td>

<td bgcolor="#FFFFFF" height="20" width="10%" colspan="1" valign="middle" align="right" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2">$<%=FormatNumber( rsProd("ProdPrice") )%></font></td>
<td bgcolor="#FFFFFF" height="20" width="7%" colspan="1" valign="middle" align="middle" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0">
<SELECT Name="Qty" SIZE="1" style="font-family: Verdana,garamond,georgia,sans-serif,serif; font-size: 10pt" OnChange="go()">
<OPTION SELECTED VALUE="<%=Session.Contents("arrPQtyList")(i)%>"><%=Session.Contents("arrPQtyList")(i)%>
<%For k = 1 to 25%>
<%If cInt(k) <> cInt(Session.Contents("arrPQtyList")(i)) Then%>
<OPTION VALUE="<%=k%>"><%=k%>
<%End If%>
<%Next%>
</SELECT>
</td>

<td bgcolor="#FFFFFF" height="20" width="7%" colspan="1" valign="middle" align="right" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2"><%=FormatNumber(cDbl(rsProd("ProdWeight")) * cDbl(Session.Contents("arrPQtyList")(i)))%></font></td>
<%totalWeight = cDbl(totalWeight) + (cDbl(rsProd("ProdWeight")) * cDbl(Session.Contents("arrPQtyList")(i)))%>

<td bgcolor="#FFFFFF" height="20" width="18%" colspan="1" valign="middle" align="right" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-right-style: solid; border-right-width: thin; border-right-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2">$<%=FormatNumber( ( rsProd("ProdPrice") ) * Session.Contents("arrPQtyList")(i))%></td>
<%totalOrderAmount = totalOrderAmount + ( ( rsProd("ProdPrice") ) * Session.Contents("arrPQtyList")(i))%>
</tr>

<%
End If
rsProd.Close
End If
Next
set rsProd=Nothing
%>

<%
Dim rsShip, strShipMethod, intShipAmount, shipSQL, intShipWeight, intShipZone
Set rsShip = Server.CreateObject("ADODB.RecordSet")
strShipMethod = Session("ShipMethod")
intShipZone = Session("UPSZone")
intShipAmount = 0

If totalWeight > 0 Then
shipSQL= "SELECT * FROM dbo.Shipper WHERE dbo.Shipper.Method = '" & strShipMethod & "' AND dbo.Shipper.Zone = '" & intShipZone & "' AND dbo.Shipper.Weight >= '" & totalWeight & "' AND dbo.Shipper.EffDate <= GETDATE() ORDER BY dbo.Shipper.Weight"
rsShip.Open shipSQL, strConnect, adOpenStatic, adLockReadOnly, adCmdText

If NOT rsShip.EOF OR NOT rsShip.BOF Then
rsShip.MoveFirst
intShipWeight = rsShip("Weight")
rsShip.Close
shipSQL = "SELECT * FROM dbo.Shipper WHERE dbo.Shipper.Method = '" & strShipMethod & "' AND dbo.Shipper.Zone = '" & intShipZone & "' AND dbo.Shipper.Weight = '" & intShipWeight & "' AND dbo.Shipper.EffDate <= GETDATE() ORDER BY dbo.Shipper.EffDate"
rsShip.Open shipSQL, strConnect, adOpenStatic, adLockReadOnly, adCmdText
If NOT rsShip.EOF OR NOT rsShip.BOF Then
rsShip.MoveLast
intShipAmount = (rsShip("Amount"))
Else
intShipAmount = 0
End If
Else
intShipAmount = 0
End If
Else
intShipAmount = 0
End If
%>
<%totalOrderAmount = totalOrderAmount + intShipAmount%>

<tr>
<td height="20" bgcolor="#FFFFFF" style="padding: 0" colspan="7" align="left" valign="middle" width="82%">
<p align="right"><b><a href="http://www.ihandicraft.com/help_shipment.asp#Shipping Cost"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">SHIPPING
COST</font></a><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">:</font>
</b>
</td>
<td bgcolor="#FFFFFF" height="20" width="18%" valign="bottom" align="right" colspan="1" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-right-style: solid; border-right-width: thin; border-right-width: 1; border-bottom-style: solid; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2">$<%=FormatNumber(intShipAmount)%></font></td>
</tr>

<tr>
<td height="20" bgcolor="#FFFFFF" style="padding: 0" colspan="7" align="left" valign="middle" width="82%">
<p align="right"><a color="#FF0000" href="#instant help"><font color="#FF0000">*</font></a>
<b>
<a href="http://www.ihandicraft.com/help_cart.asp#Grand Total"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">GRAND TOTAL</font></a><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">:</font>
</b>
</td>
<td bgcolor="#FFFFFF" height="20" width="18%" valign="bottom" algin="right" colspan="1" align="right" style="border-style: solid; border-width: thin; border-width: 1; padding: 0"><font face="verdana,garamond,georgia,sans-serif,serif" size="2">$<%=FormatNumber(totalOrderAmount)%></font></td>
</tr>

</center>

<div align="left">
<tr>
<table name="select_table" border="0" cellpadding="0" cellspacing="0" width="95%">
<tr>
<td border="1" style="padding: 0" width="30%" align="center" height="10" valign="middle">&nbsp;</td>
<td border="1" style="padding: 0" width="20%" align="center" height="10" valign="middle">&nbsp;</td>
<td border="1" style="padding: 0" width="10%" align="center" height="10" valign="middle">&nbsp;</td>
<td style="padding: 0" width="50%" height="10" align="center" valign="middle">&nbsp;</td>
</tr>
<tr>
<td border="1" style="padding: 0" width="30%" align="center" height="10" valign="middle">&nbsp;</td>
<td border="1" style="padding: 0" width="20%" align="center" height="10" valign="middle">&nbsp;</td>
<td border="1" style="padding: 0" width="10%" align="center" height="10" valign="middle">&nbsp;</td>
<td style="padding: 0" width="50%" height="10" align="center" valign="middle">&nbsp;</td>
</tr>
<tr>
<%If Session("CustID") = "" Then%>
<td bgcolor="#ededed" height="15" width="30%" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">SHIPPING COUNTRY</font><b></td>
<%End If%>
<td bgcolor="#ededed" height="15" width="20%" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-right-style: solid; border-right-width: thin; border-right-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; border-top-style: solid; border-top-width: thin; border-top-width: 1; padding: 0"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">SHIPPING METHOD</font><b></td>
<%If Session("CustID") = "" Then%>
<td bgcolor="#FFFFFF" height="15" width="50%" valign="middle" align="center">&nbsp;</td>
<%Else%>
<td bgcolor="#FFFFFF" height="15" width="80%" valign="middle" align="center">&nbsp;</td>
<%End If%>
</tr>
<tr>
<%If Session("CustID") = "" Then%>
<td bgcolor="#FFFFFF" width="30%" height="15" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0">
<select name="CustShipCountry" SIZE=1 tabindex="13" style="font-family: Verdana; font-size: 10pt" OnChange="go()">
<option SELECTED value="<%=Session("CustShipCountry")%>"><%=Session("CustShipCountry")%>
<option value="Afghanistan">Afghanistan
<option value="Albania">Albania
<option value="Algeria">Algeria
<option value="American Samoa">American Samoa
<option value="Andorra">Andorra
<option value="Angola">Angola
<option value="Anguilla">Anguilla
<option value="Antarctica">Antarctica
<option value="Antigua and Barbuda">Antigua and Barbuda
<option value="Argentina">Argentina
<option value="Armenia">Armenia
<option value="Aruba">Aruba
<option value="Australia">Australia
<option value="Austria">Austria
<option value="Azerbaijan">Azerbaijan
<option value="Bahamas">Bahamas
<option value="Bahrain">Bahrain
<option value="Bangladesh">Bangladesh
<option value="Barbados">Barbados
<option value="Belarus">Belarus
<option value="Belgium">Belgium
<option value="Belize">Belize
<option value="Benin">Benin
<option value="Bermuda">Bermuda
<option value="Bhutan">Bhutan
<option value="Bolivia">Bolivia
<option value="Bosnia and Herzegovina">Bosnia and Herzegovina
<option value="Botswana">Botswana
<option value="Bouvet Island">Bouvet Island
<option value="Brazil">Brazil
<option value="British Indian Ocean Territory">British Indian Ocean Territory
<option value="British Virgin Islands">British Virgin Islands
<option value="Brunei">Brunei
<option value="Bulgaria">Bulgaria
<option value="Burkina Faso">Burkina Faso
<option value="Burundi">Burundi
<option value="Cambodia">Cambodia
<option value="Cameroon">Cameroon
<option value="Canada">Canada
<option value="Cape Verde">Cape Verde
<option value="Cayman Islands">Cayman Islands
<option value="Central African Republic">Central African Republic
<option value="Chad">Chad
<option value="Channel Islands">Channel Islands
<option value="Chile">Chile
<option value="China">China
<option value="Christmas Island">Christmas Island
<option value="Cocos Islands">Cocos Islands
<option value="Colombia">Colombia
<option value="Comoros">Comoros
<option value="Congo">Congo
<option value="Cook Islands">Cook Islands
<option value="Costa Rica">Costa Rica
<option value="Croatia">Croatia
<option value="Cuba">Cuba
<option value="Cyprus">Cyprus
<option value="Czech Republic">Czech Republic
<option value="Denmark">Denmark
<option value="Djibouti">Djibouti
<option value="Dominica">Dominica
<option value="Dominican Republic">Dominican Republic
<option value="East Timor">East Timor
<option value="Ecuador">Ecuador
<option value="Egypt">Egypt
<option value="El Salvador">El Salvador
<option value="Equatorial Guinea">Equatorial Guinea
<option value="Eritrea">Eritrea
<option value="Estonia">Estonia
<option value="Ethiopia">Ethiopia
<option value="Falkland Islands">Falkland Islands
<option value="Faroe Islands">Faroe Islands
<option value="Fiji">Fiji
<option value="Finland">Finland
<option value="France">France
<option value="French Guiana">French Guiana
<option value="French Polynesia">French Polynesia
<option value="French Southern Territories">French Southern Territories
<option value="Gabon">Gabon
<option value="Gambia">Gambia
<option value="Georgia">Georgia
<option value="Germany">Germany
<option value="Ghana">Ghana
<option value="Gibraltar">Gibraltar
<option value="Greece">Greece
<option value="Greenland">Greenland
<option value="Grenada">Grenada
<option value="Guadeloupe">Guadeloupe
<option value="Guam">Guam
<option value="Guatemala">Guatemala
<option value="Guinea">Guinea
<option value="Guinea-Bissau">Guinea-Bissau
<option value="Guyana">Guyana
<option value="Haiti">Haiti
<option value="Heard and McDonald Islands">Heard and McDonald Islands
<option value="Honduras">Honduras
<option value="Hong Kong">Hong Kong
<option value="Hungary">Hungary
<option value="Iceland">Iceland
<option value="India">India
<option value="Indonesia">Indonesia
<option value="Iran">Iran
<option value="Iraq">Iraq
<option value="Ireland">Ireland
<option value="Israel">Israel
<option value="Italy">Italy
<option value="Ivory Coast">Ivory Coast
<option value="Jamaica">Jamaica
<option value="Japan">Japan
<option value="Jordan">Jordan
<option value="Kazakhstan">Kazakhstan
<option value="Kenya">Kenya
<option value="Kirghizia">Kirghizia
<option value="Kiribati">Kiribati
<option value="Korea, North">Korea, North
<option value="Korea, South">Korea, South
<option value="Kuwait">Kuwait
<option value="Laos">Laos
<option value="Latvia">Latvia
<option value="Lebanon">Lebanon
<option value="Lesotho">Lesotho
<option value="Liberia">Liberia
<option value="Libya">Libya
<option value="Liechtenstein">Liechtenstein
<option value="Lithuania">Lithuania
<option value="Luxembourg">Luxembourg
<option value="Macau">Macau
<option value="Macedonia, Republic of">Macedonia, Republic of
<option value="Madagascar">Madagascar
<option value="Malawi">Malawi
<option value="Malaysia">Malaysia
<option value="Maldives">Maldives
<option value="Mali">Mali
<option value="Malta">Malta
<option value="Marshall Islands">Marshall Islands
<option value="Martinique">Martinique
<option value="Mauritania">Mauritania
<option value="Mauritius">Mauritius
<option value="Mayotte">Mayotte
<option value="Mexico">Mexico
<option value="Micronesia, Federated States of">Micronesia, Federated States of
<option value="Moldova">Moldova
<option value="Monaco">Monaco
<option value="Mongolia">Mongolia
<option value="Montserrat">Montserrat
<option value="Morocco">Morocco
<option value="Mozambique">Mozambique
<option value="Myanmar">Myanmar
<option value="Namibia">Namibia
<option value="Nauru">Nauru
<option value="Nepal">Nepal
<option value="Netherlands">Netherlands
<option value="Netherlands Antilles">Netherlands Antilles
<option value="New Caledonia">New Caledonia
<option value="New Zealand">New Zealand
<option value="Nicaragua">Nicaragua
<option value="Niger">Niger
<option value="Nigeria">Nigeria
<option value="Niue">Niue
<option value="Norfolk Island">Norfolk Island
<option value="Northern Mariana Islands">Northern Mariana Islands
<option value="Norway">Norway
<option value="Oman">Oman
<option value="Pakistan">Pakistan
<option value="Palau">Palau
<option value="Panama">Panama
<option value="Papua New Guinea">Papua New Guinea
<option value="Paraguay">Paraguay
<option value="Peru">Peru
<option value="Philippines">Philippines
<option value="Pitcairn Island">Pitcairn Island
<option value="Poland">Poland
<option value="Portugal">Portugal
<option value="Puerto Rico">Puerto Rico
<option value="Qatar">Qatar
<option value="Reunion">Reunion Island
<option value="Romania">Romania
<option value="Russia">Russia
<option value="Rwanda">Rwanda
<option value="S. Georgia and S. Sandwich Isls.">S. Georgia and S. Sandwich Isls.
<option value="Saint Kitts and Nevis">Saint Kitts and Nevis
<option value="Saint Lucia">Saint Lucia
<option value="Saint Vincent and The Grenadines">Saint Vincent and The Grenadines
<option value="Samoa">Samoa
<option value="San Marino">San Marino
<option value="Sao Tome and Principe">Sao Tome and Principe
<option value="Saudi Arabia">Saudi Arabia
<option value="Senegal">Senegal
<option value="Seychelles">Seychelles
<option value="Sierra Leone">Sierra Leone
<option value="Singapore">Singapore
<option value="Slovakia">Slovakia
<option value="Slovenia">Slovenia
<option value="Solomon Islands">Solomon Islands
<option value="Somalia">Somalia
<option value="South Africa">South Africa
<option value="Spain">Spain
<option value="Sri Lanka">Sri Lanka
<option value="St. Helena">St. Helena
<option value="St. Pierre and Miquelon">St. Pierre and Miquelon
<option value="Sudan">Sudan
<option value="Suriname">Suriname
<option value="Svalbard and Jan Mayen Islands">Svalbard and Jan Mayen Islands
<option value="Swaziland">Swaziland
<option value="Sweden">Sweden
<option value="Switzerland">Switzerland
<option value="Syria">Syria
<option value="Taiwan">Taiwan
<option value="Tajikistan">Tajikistan
<option value="Tanzania">Tanzania
<option value="Thailand">Thailand
<option value="Togo">Togo
<option value="Tokelau">Tokelau
<option value="Tonga">Tonga
<option value="Trinidad and Tobago">Trinidad and Tobago
<option value="Tunisia">Tunisia
<option value="Turkey">Turkey
<option value="Turkmenistan">Turkmenistan
<option value="Turks and Caicos Islands">Turks and Caicos Islands
<option value="Tuvalu">Tuvalu
<option value="U.S. Minor Outlying Islands">U.S. Minor Outlying Islands
<option value="U.S. Virgin Islands">U.S. Virgin Islands
<option value="Uganda">Uganda
<option value="Ukraine">Ukraine
<option value="United Arab Emirates">United Arab Emirates
<option value="United Kingdom">United Kingdom
<option value="United States of America">United States of America
<option value="Uruguay">Uruguay
<option value="Uzbekistan">Uzbekistan
<option value="Vanuatu">Vanuatu
<option value="Vatican City">Vatican City
<option value="Venezuela">Venezuela
<option value="Vietnam">Vietnam
<option value="Wallis and Futuna Islands">Wallis and Futuna Islands
<option value="Western Sahara">Western Sahara
<option value="Yemen">Yemen
<option value="Yugoslavia">Yugoslavia
<option value="Zaire">Zaire
<option value="Zambia">Zambia
<option value="Zimbabwe">Zimbabwe
</select>
</td>
<%End If%>
<td bgcolor="#FFFFFF" width="20%" height="15" valign="middle" align="center" style="border-left-style: solid; border-left-width: thin; border-left-width: 1; border-right-style: solid; border-right-width: thin; border-right-width: 1; border-bottom-style: solid; border-bottom-width: thin; border-bottom-width: 1; padding: 0">
<%If Session("Ship") = "InternationalUnlimited" AND Session("ShipMethod") = "Expedited" Then%>
<SELECT NAME="ShipMethod" SIZE="1" style="font-family: Verdana; font-size: 10pt" OnChange="go()">
<OPTION SELECTED VALUE="Expedited">UPS Worldwide Expedited
<OPTION VALUE="Express">UPS Worldwide Express
</SELECT>
<%ElseIf Session("Ship") = "InternationalUnlimited" AND Session("ShipMethod") = "Express" Then%>
<SELECT NAME="ShipMethod" SIZE="1" style="font-family: Verdana; font-size: 10pt" OnChange="go()">
<OPTION VALUE="Expedited">UPS Worldwide Expedited
<OPTION SELECTED VALUE="Express">UPS Worldwide Express
</SELECT>
<%ElseIf Session("Ship") = "InternationalLimited" Then%>
<SELECT NAME="ShipMethod" SIZE="1" style="font-family: Verdana; font-size: 10pt" OnChange="go()">
<OPTION SELECTED VALUE="Express">UPS Worldwide Express
</SELECT>
<%ElseIf Session("Ship") = "Internal" AND Session("ShipMethod") = "IPSpeed" Then%>
<SELECT NAME="ShipMethod" SIZE="1" style="font-family: Verdana; font-size: 10pt" OnChange="go()">
<OPTION VALUE="PCOrdinary">Professional Courier
<OPTION SELECTED VALUE="IPSpeed">India Post
</SELECT>
<%ElseIf Session("Ship") = "Internal" AND Session("ShipMethod") = "PCOrdinary" Then%>
<SELECT NAME="ShipMethod" SIZE="1" style="font-family: Verdana; font-size: 10pt" OnChange="go()">
<OPTION SELECTED VALUE="PCOrdinary">Professional Courier
<OPTION VALUE="IPSpeed">India Post
</SELECT>
<%ElseIf Session("Ship") = "Other" Then%>
<SELECT NAME="ShipMethod" SIZE="1" style="font-family: Verdana; font-size: 10pt" OnChange="go()">
<OPTION SELECTED VALUE="Other">International Shipment
</SELECT>
<%End If%>
</td>
<%If Session("CustID")="" Then%>
<td width="50%" height="15" align="center" valign="middle">&nbsp; </td>
<%Else%>
<td width="80%" height="15" align="center" valign="middle">&nbsp; </td>
<%End If%>
</tr>
</table>
</tr>


<div align="center">
<center>

<table name="cart_submit_table" border="0" cellpadding="0" cellspacing="0" width="95%">
<center>
<%If totalWeight > 70 Then%>
<tr>
<td width="100%" height="20" colspan="3" align="center" style="padding: 0" valign="middle">
<b><font face="Garamond" color="#FF0000" size="3">
Your total Order weight exceeds 70 KG, please break-up your Order or contact
us.</font></b>
</td>
</tr>
<%Else%>
<tr>
<td width="100%" height="20" colspan="3" align="center" style="padding: 0" valign="middle">
&nbsp;
</td>
</tr>
<%End If%>
<tr>
<td width="100%" height="20" colspan="3" align="center" style="padding: 0" valign="middle">
&nbsp;
</td>
</tr>
<tr>
<td width="33%" height="27" colspan="1" align="left" style="padding: 0" valign="middle">
<INPUT TYPE="hidden" NAME="ProcessOrder" VALUE="True">
<INPUT TYPE="hidden" NAME="AutoUpdate">
<input type="submit" value="Update Cart" Name="btnUpdate" style="font-family: Verdana; font-size: 10pt; font-weight: bold">
</td>
</form>
<td width="34%" height="27" colspan="1" align="center" style="font-family: Comic Sans MS; font-size: 10pt; font-weight: bold; padding: 0" valign="bottom">
<p align="center"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings 3; font-size: 10.0pt; font-family: Wingdings 3; mso-ascii-font-family: Times New Roman; mso-fareast-font-family: Times New Roman; mso-hansi-font-family: Times New Roman; mso-bidi-font-family: Times New Roman; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><a href="#instant help"><span style="mso-char-type: symbol; mso-symbol-font-family: Monotype Sorts; font-size: 10.0pt; font-family: Monotype Sorts; mso-ascii-font-family: Times New Roman; mso-fareast-font-family: Times New Roman; mso-hansi-font-family: Times New Roman; mso-bidi-font-family: Times New Roman; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">t</span></a></span>
</td>
<form action="action.asp" name="frmCartAction" method="POST">
<INPUT TYPE="hidden" NAME="ProcessOrder" VALUE="True">
<td width="34%" height="27" colspan="1" align="right" style="padding: 0" valign="middle">
<input type="submit" value="Process Cart" Name="btnProcess" style="font-family: Verdana; font-size: 10pt; font-weight: bold">
</td>
</form>
</tr>

<tr>
<td width="100%" colspan="3" height="25" align="center" style="padding: 0" valign="middle">&nbsp;
</td>
</tr>

</center>

<%If intCount > 1 Then%>
<tr>
<td width="100%" colspan="3" height="25" align="center" style="padding: 0" valign="middle">
</td>
</tr>

</center>

<tr>
<td width="100%" colspan="3" height="20" align="center" style="border-style: solid; border-width: 1; padding: 0" valign="middle" bgcolor="#EDEDED">
<p align="left"><font face="Verdana" size="2">&nbsp;<b>Instant Help</b></font>
</td>
</tr>

<center>

<tr>
<td width="100%" colspan="3" height="15" align="center" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding: 0" valign="middle">
<p align="left"><font face="garamond,georgia,verdana,sans-serif,serif" size="3" color="#000000"><a name="instant help">*</a>
To remove a product from your Cart, click the box near to the ID column.
</font>
</td>
</tr>
<%End If%>

<%If Session("Ship") <> "" AND intCount > 1 Then%>
<tr>
<td width="100%" colspan="3" height="15" align="center" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1; padding: 0" valign="middle">
<p align="left"><font color="#FF0000" size="3" face="garamond,georgia,verdana,sans-serif,serif">*
</font>
<font size="3" face="garamond,georgia,verdana,sans-serif,serif">
Duties and/or Taxes should be paid by Customer at the time of delivery, if
applicable</font><font color="#FF0000" size="3" face="garamond,georgia,verdana,sans-serif,serif">.
</font>
</td>
</tr>
<%End If%>
<%If intCount > 1 Then%>
<tr>
<td width="100%" colspan="3" height="15" align="center" style="padding: 0" valign="middle">
&nbsp;</td>
</tr>
<tr>
<td width="100%" colspan="3" height="15" align="center" style="padding: 0" valign="middle">
&nbsp;
<div align="center">
<table border="0" cellspacing="0" width="100%" cellpadding="0">
<tr>
<td width="100%" style="border-style: solid; border-width: 1; padding: 0" bgcolor="#EDEDED" colspan="3" height="20"><font face="Verdana" size="2"><font color="#000000"><b>&nbsp;</b></font><a href="http://www.ihandicraft.com/help.asp"><b><font color="#000000">Help</font></b></a>
</font>
</td>
</tr>
<tr>
<td width="33%" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding: 0"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/help_cart.asp">Cart</a></font>
</td>
<td width="34%" style="border-right-style: solid; border-right-width: 1; padding: 1"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/help_order.asp#warranty">Warranty</a></font>
</td>
<td width="33%" style="border-right-style: solid; border-right-width: 1; padding: 1"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/FAQ.asp#Gift">Gift</a></font></td>
</tr>
<tr>
<td width="33%" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding: 0"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/help_shipment.asp">Shipment
</a></font>
</td>
<td width="34%" style="border-right-style: solid; border-right-width: 1; padding: 1"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/help_order.asp#Order Cancellation">Cancellation</a>
</font>
</td>
<td width="33%" style="border-right-style: solid; border-right-width: 1; padding: 1"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/help_shipment.asp#custom">Duties
& Taxes</a>
</font></td>
</tr>
<tr>
<td width="33%" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; padding: 0"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/help_payment.asp">Payment</a> </font>
</td>
<td width="34%" style="border-right-style: solid; border-right-width: 1; padding: 1"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/help_order.asp#Return Policy">Return
Policy</a> </font>
</td>
<td width="33%" style="border-right-style: solid; border-right-width: 1; padding: 1"><font face="Verdana" size="2">&nbsp;
</font></td>
</tr>
<tr>
<td width="33%" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1; padding: 0"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/help_security.asp">Security</a>
</font>
</td>
<td width="34%" style="border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1; padding: 1"><font face="Verdana" size="2">&nbsp;<a href="http://www.ihandicraft.com/track.asp">Track
Order</a> </font>
</td>
<td width="33%" style="border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1; padding: 1">&nbsp;</td>
</tr>
</table>
</div>
</td>
</tr>
<%End If%>



<center>

<tr>
<td width="100%" colspan="3" height="15" align="center" style="padding: 0" valign="middle">
</td>
</tr>

<tr>
<td width="100%" colspan="3" height="15" align="center" style="padding: 0" valign="middle">
<font color="#808080" size="2" face="Times New Roman">© 2002-2003
iHandiCraft.com. All rights reserved.</font>
</td>
</tr>

<tr>
<td width="100%" colspan="3" height="15" align="center" style="padding: 0" valign="middle">
</td>
</tr>

</table>

<%End If%>
<!-- big end if-->
</center>
</div>

</table>

</body>
</html>
<%Session("totalShipAmount")=intshipamount%>
<%Session("totalOrderWeight")=totalweight%>
<%Session("totalOrderAmount")=totalOrderAmount%>
<%Session("Step1")="True"%>
<%Session("MSG")=""%>

_________
I appreciate this so much!! Thank you!
Reply With Quote
  #4  
Old May 2nd, 2003, 08:58 PM
Blindeddie Blindeddie is offline
Codewalkers Regular (2000 - 2499 posts)
  
Join Date: Apr 2007
Location: NJ - USA
Posts: 2,152 Blindeddie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 4
RE: I need help urgently!
It looks like the shipping amounts are in the shipper table in the database. You will need to update the shipper table amount row to us currency instead of rupees. The shipping cost is not calculated in the code.
Reply With Quote
  #5  
Old May 2nd, 2003, 10:27 PM
Gibran Gibran is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Location: Concord, NSW, Australia
Posts: 5 Gibran User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via ICQ to Gibran
RE: I need help urgently!
How do I open the shipper table. I am completely new to SQL. What do I need to do to access the info in the shipper table.

Thanks!

Gibran Selman
Reply With Quote
  #6  
Old May 3rd, 2003, 12:27 AM
Blindeddie Blindeddie is offline
Codewalkers Regular (2000 - 2499 posts)
  
Join Date: Apr 2007
Location: NJ - USA
Posts: 2,152 Blindeddie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 4
RE: I need help urgently!
Since your application is using MSSQL, there should be a SQL Server Management tool on the server. I don't know if you have access to the server or not, but it would help to be able to get to it. Unfortunatly, it would be very difficult for me to explain how to use it via this forum. I would suggest finding a Programmer or DBA (Database Admin) in your area that could help you get things straightened out. Sorry I can't be of more help.
Reply With Quote