http://forum.salescart.com/forum/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 27 Jun 2026 23:26:05 +0000 Sun, 07 May 2006 01:25:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 forum.salescart.com/forum/RSS_post_feed.asp?TID=550 http://forum.salescart.com/forum/forum_images/web_wiz_forums.png http://forum.salescart.com/forum/ http://forum.salescart.com/forum/forum_posts.asp?TID=550&PID=1950&title=shipping1asp-not-updating-custom#1950 Author: jwstephens2002
Subject: 550
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]]> Sun, 07 May 2006 01:25:54 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=550&PID=1950&title=shipping1asp-not-updating-custom#1950