2. ASPRunnerPro General questions
  3. Edit problem
This topic is locked

Edit problem

 		11/29/2005 14:34:38
ASPRunnerPro General questions
Corinne author

I'm receiving the following error when the user tries to edit the data. Previous to now the user was able to edit the data just fine. I checked the data type in the table and it's nvarchar, which is fine for the value NAVY. The field is listed as : [Our Fabric Number] in the database.
Can anyone please tell me how to go about trouble shooting this problem??? How do I determine which "Fabric" in the code that this error message is referencing?????
Thanks,

Corinne
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Fabric'.
/fabricmaintenance/imFabric_edit.asp, line 2192
Table: Fabric Maintenance, Edit record [Our Fabric Number: Navy]
--------------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Navy'.
/fabricmaintenance/imFabric_edit.asp, line 2212
Corinne author 11/30/2005

ANyone have any ideas on how to trouble shoot this? How does everyone go about tracking hte error in the code????
Thanks
Sergey Kornilov admin 11/30/2005

Choice of key columns doesn't look correct. I would suggest to use INT IDENTITY field as a key column.
If this worked before there must be something that was changed. What exactly was changed?
Corinne author 12/1/2005

What was changed were three field names in the label column on step 8 and I added three new fields (none of which have the word fabric in them). Those were the only changes made. How can I trouble shoot this in the code?????
Thanks
Sergey Kornilov admin 12/1/2005

Send me your ASP files along with your sample database for investigation.
Corinne author 12/2/2005

Here are the .asp files. I'm not quite sure how to get you the database. Could you please let me know how to do that. The table in in SQL.
Thanks,

Corinne