|
| |
|
|
Guest
 |
Update Access Database - 5/15/2001 20:33:00
I have been using FrontPage wizard for database connections. Unfortunatly it does not allow you to update a record with the wizard. I looked on the Microsoft site and they said to use this SQL statement: UPDATE DISTINCTROW
Records
SET Response='::Response::'
WHERE ID='::ID::' This does not work. Could you please help?
|
|
|
|
Bnugent
Posts: 257
From: Tampa Florida Tampa, FL USA
Status: offline
|
RE: Update Access Database - 5/15/2001 20:57:00
Take out the (') around the id so that it reads:
UPDATE DISTINCTROW
Records
SET Response='::Response::'
WHERE ID=::ID::
------------------
Brian---
| |
|
|
|
Guest
|
RE: Update Access Database - 5/16/2001 20:11:00
Thanks Brian, that worked great. ![]("http://www.frontpagewebmaster.com/ubb/redface.gif") )
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
