|
| |
|
|
evansforsyth
Posts: 277
Joined: 12/11/2001
From: Grande Prairie, Alberta, Canada
Status: offline
 |
Updating with a Custom Query - 6/17/2002 2:45:06
Lacking some basic knowledge!
The following custom query won't update the database:
UPDATE Results SET Bathrooms '::Bathrooms::'
WHERE (ID = ::ID::)
1. In a custom query '::Bathrooms::' would use a text variable to update a text field. Right?
Suppose it was a number variable and a number field, then ::bathrooms:: would work. Right?
2. Does every field name have to be updated--or can just the fields with changes be updated.
In this case there are a dozen or so fields, but only the Bathroom field is being updated.
Thanks for helping out a rookie!
Evans
|
|
|
|
evansforsyth
Posts: 277
Joined: 12/11/2001
From: Grande Prairie, Alberta, Canada
Status: offline
|
RE: Updating with a Custom Query - 6/17/2002 11:30:30
Problem solved.
Error was on previous page--didn't pass the ID variable correctly.
Sorry for taking up your time.
Evans
| |
|
 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 
