|
 |
asp_databases thread: turn the recordset into edit mode
Message #1 by "Jimmy Ho" <jimmyyl@h...> on Thu, 28 Dec 2000 18:31:00 +0800
|
|
I have got a recordset from conn.execute(sql command for Access database)
and i need to modify it and update the table.
I have check the recordSet.editmode. It is 0.
How to turn the recordset into edit mode and do the modification?
Then how to update the table?
Thanx
---
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS? Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development,
Web Development, Networking & Communications, and Hardware & Systems.
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #2 by Gregory_Griffiths@c... on Thu, 28 Dec 2000 11:25:11 +0000
|
|
try
conn.execute("UPDATE <table name> SET <column name>=<value>,<column
name>=<value> WHERE <key field>=<keyfield value>")
where <table name> is your Table name, <column name> is the name of the
column/field you are trying to update, <value> is value you are trying
to insert (remembering to use quotes etc as required) and the WHERE
clause identifies a unique row (as per SELECT statements).
> -----Original Message-----
> From: jimmyyl@h... [mailto:jimmyyl@h...]
> Sent: 28 December 2000 10:31
> To: asp_databases@p...
> Cc: jimmyyl@h...
> Subject: [asp_databases] turn the recordset into edit mode
>
>
> I have got a recordset from conn.execute(sql command for
> Access database)
> and i need to modify it and update the table.
> I have check the recordSet.editmode. It is 0.
> How to turn the recordset into edit mode and do the modification?
> Then how to update the table?
> Thanx
>
>
>
---
FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS
IN YOUR INBOX!
Get the latest and best HTML, XML, and JavaScript tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb's
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
|
|
|
View Cart
