Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating table information

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
I have tried numerous ways of updating my tables...the information is being pulled from a form...

I use:
conn.Execute("UPDATE tbl_Members SET Status='" & newstatus & "' WHERE MemberID=" & idnum & ";")

to update one piece of the information. The server seems to recognize this code, howeever it will not acknowledge it for every field. I need to update multiple fields in one record. What is the best way to do this?

Thanks
 
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
312
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
First execute an input command and only then proceed with displaying the next record of the table
Replies
0
Views
282
leifoet
leifoet
leifoet
  • Locked
  • Question
How to obtain a different table title on a continuation page ?
Replies
3
Views
162
leifoet
leifoet
leifoet
  • Locked
  • Question
Problem with updating database reords.
2
Replies
31
Views
404
leifoet
leifoet
PSchubert
  • Locked
  • Question
Data in DB table cell not displaying in asp page table cell
Replies
4
Views
153
Ed Mozley
Ed Mozley

Part and Inventory Search

Sponsor

Back
Top