 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
September 11th, 2008, 01:39 AM
|
|
Registered User
|
|
Join Date: Sep 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
How to update Recordset using oledb.command
Hi All
Now I am using the following code to update.
sql = "SELECT * FROM customers WHERE CustomerID=" + custID;
recordSet.Open(sql, connection, 1, 2);
recordSet("Password") = newPassword;
recordSet("lastUpdated") = sqlDate(new Date());
recordSet.Update();
recordSet.Close();
But I want to pass custID using adodb.command can you please tell me how to pass custID parameter using ADODB.COMMAND?
Thanks in Advance
|
|
September 11th, 2008, 02:11 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
|
|
I answered this TWO DAYS AGO.
http://p2p.wrox.com/topic.asp?TOPIC_ID=73937
Don't you bother to go check for answers to your questions????
Apologies to jmhemadri. The problem appears to be in the forum code.
|
|
September 11th, 2008, 03:38 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
|
|
Oh, wow! Looks like a bug in the forum code!
If you got to his User Profile from *either* post, you find they are identical and both say his last post was 09/09/2008 04:31:22 AM (or whatever for your timezone?).
And yet this thread says his post is from
Posted - 09/10/2008 : 11:39:18 PM
So... Apologies to you "jmhemadri". It would appear that the forum reposted your message for you.
Ah, well, what do you expect from an ASP-based forum as old and creaky as this thing.
|
|
|
