Forum Home Forum Home > Legacy Products > SalesCart Standard / PRO / SQL
  New Posts New Posts RSS Feed - shipping1.asp not updating custom
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum Lockedshipping1.asp not updating custom

 Post Reply Post Reply
jwstephens2002 View Drop Down

Joined: May/07/06
Location: United States
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote jwstephens2002 Quote  Post ReplyReply Direct Link To This Post Topic: shipping1.asp not updating custom
    Posted: May/07/06 at 1:25am
I have isolated the code that is not updating the customer table. Does anyone ever seen this issue?

The following is a code example followed by the results:

<%@ LANGUAGE="VBScript.Encode" %>
<!--#include file="codepage.asp"-->
<!--#include file=""-->
<!--#include file="IASUtil.asp"-->
     order = Session("orderid")

'WRITE STUFF to Database
     Dim objSimpleAdo, rstRS, SQLStmt, SQLStmt2

     SQLStmt = "UPDATE [customer] "
     SQLStmt = SQLStmt & "SET shipfname='tttt', "
     SQLStmt = SQLStmt & "password='tttt', "
     SQLStmt = SQLStmt & "shiplname='tttt', "
     SQLStmt = SQLStmt & "shipemail='tttt', "
     SQLStmt = SQLStmt & "shipcompany='tttt', "
     SQLStmt = SQLStmt & "shipaddress='tttt', "
     SQLStmt = SQLStmt & "shipcity='tttt', "
     SQLStmt = SQLStmt & "shipstate='tttt' "
     SQLStmt = SQLStmt & "WHERE Orderid = 2; "

     Set SimpleAdo = New CSimpleAdo
     SimpleAdo.setConnectionString = Session("ConnectionString")
     Success = SimpleAdo.ExecuteInsertUpdate(SQLStmt)
     Set SimpleAdo = Nothing
'READ STUFF to Database

     SQLStmt2 = "SELECT * FROM [customer] "
     SQLStmt2 = SQLStmt2 & "WHERE orderid=2;"
     Set SimpleAdo = New CSimpleAdo
     SimpleAdo.setConnectionString = Session("ConnectionString")
     Set RS = SimpleAdo.getRecordSet(SQLStmt2)

Here are the results:

Session Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\hosting\admin2bapps\supremedarts\fpdb\shop.mdb
SQLStmt UPDATE [customer] SET shipfname='tttt', password='tttt', shiplname='tttt', shipemail='tttt', shipcompany='tttt', shipaddress='tttt', shipcity='tttt', shipstate='tttt' WHERE Orderid = 2;
Success True
shipfname =
SQLStmt2 SELECT * FROM [customer] WHERE orderid=2;

Any help would be appreciated.


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.04
Copyright ©2001-2015 Web Wiz Ltd.

Copyright 2015 by ComCity® LLC and SalesCart™.  All Rights Reserved