KathleenJ
|
| Posted: 11/21/2002, 7:57 AM |
|
When going live on the record I get the following error:
Source: Record vendor / Insert Operation
Command Text: INSERT INTO [vendor]([vendor_name], [Phone], [email]) VALUES ('ABC Testing', Null, Null)
Error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'email'. (Microsoft OLE DB Provider for ODBC Drivers)
INSERT INTO [vendor]([vendor_name], [Phone], [email]) VALUES ('ABC Testing', Null, Null)
I have email in my table so I don't know why its not accepting it. Under data the input validation field says: ^[\w\.-]{1,}\@([\da-zA-Z-]{1,}\.){1,}[\da-zA-Z-]+$. Is that correct for email?
Thanks.
|
|
|
 |
GreggB
|
| Posted: 11/21/2002, 12:11 PM |
|
Note the "Error description:" line in your error message. The "Invalid column name 'email'" is your clue that the 'email' column may not exist in you table. Check to make sure you are looking at the correct table. Many developers use a development server and database and find that they forgot to update the production servers and tables with columns and are publishing to the production servers..
Let me know what you find as I'm sure the table is missing the 'email' column. You may want to check with your boss : )
GreggB
|
|
|
|
|
