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
Author
Message
jwstephens2002 View Drop Down
Newbie
Newbie


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="ADOVBS.inc"-->
<!--#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)
     SimpleAdo.
     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.

Thanks

John
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