|
| |
|
|
pkohl
Posts: 15
Joined: 5/13/2002
From: Overland Park Kansas USA
Status: offline
 |
Update form with radio buttons - 5/13/2002 17:37:24
HELP! I am trying to create an update form that contains radio buttons. I am recieving a error that states: "Syntax error in UPDATE statement" Here is my code for the custom query:
UPDATE EMPLOYEE_DATA
SET
JOB_GRADE='::JOB_GRADE::',
JOB_TITLE='::JOB_TITLE::',
SUPERVISOR_NAME='::SUPERVISOR_NAME::',
DIR_GROUP='::DIR_GROUP::',
DEPARTMENT='::DEPARTMENT::',
JOB_START_DATE='::JOB_START_DATE::',
GROUP_Name='::GROUP_Name::',
LOCATION='::LOCATION::',
LEADERSHIP=::LEADERSHIP::,
COMMUNICATION=::COMMUNICATION::,
MANAGEMENT=::MANAGEMENT::,
PERSONAL_EFFECTIVENESS=::PERSONAL_EFFECTIVENESS::,
Professional_Knowledge=::Professional_Knowledge::,
CUSTOMER_FOCUS=::CUSTOMER_FOCUS::,
TEAM_APPROACH=::TEAM_APPROACH::,
MIP=::MIP::,
SKILLS_AND_BEHAVIOR=::SLILLS_AND_BEHAVIOR::,
TOTAL_JOB_REQUIREMENTS_RATING=::TOTAL_JOB_REQUIREMENTS_RATING::,
RATED_BY_SUPERVISOR=::RATED_BY_SUPERVISOR::,
RATED_BY_MANAGER=::RATED_BY_MANAGER::,
RATED_BY_DIRECTOR=::RATED_BY_DIRECTOR::,
Final=::Final::,
REVIEW='::REVIEW::',
COMMENTS='::COMMENTS::',
WHERE EMP_NAME='::EMP_NAME::'
The fields from Leadership through Final are radio buttons.
Thank you for your assisstance.
Edited by - pkohl on 05/13/2002 17:38:49
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Update form with radio buttons - 5/14/2002 1:43:20
Does it point to a specific part of that sql string or show the partially populated string in the error page?
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
pkohl
Posts: 15
Joined: 5/13/2002
From: Overland Park Kansas USA
Status: offline
|
RE: Update form with radio buttons - 5/14/2002 12:03:04
I am recieving this error in the DRW. If I cancel out of the DRW and try the page, I recieve a Database Results error: Syntax error in UPDATE statement.
Number -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers
One or more fields were empty. You should provide default values for all form fields that are used in the query.
I added default values to all fields and am still at a loss!
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Update form with radio buttons - 5/14/2002 19:46:40
What field types are the database colums that you are inserting into?
I assumed they were t/f fields, but perhaps you are putting the values of radio buttons into a text field? If so, all the inputs in the SQL string need to be in quotes.
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
pkohl
Posts: 15
Joined: 5/13/2002
From: Overland Park Kansas USA
Status: offline
|
RE: Update form with radio buttons - 5/14/2002 20:13:47
YOU ARE AWESOME!!! Yes, I am using radio buttons to update text fields.
Now I have to figure out that Spooky Login for my site and I'll be set!
Thanks again!
| |
|
 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 
