Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pepper1425
Starting Member
5 Posts |
 Posted - 2010-12-17 : 11:06:44
|
| I changed the datatype from bit,not null to varchar(8), null and i get an unknown type error once i click on a product on my webpage. However, when i set a product to 1 or 0 it works fine. So something has not changed from bit to varchar(8)???? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-17 : 11:18:49
|
| What happens if you right-click the table and script it out?If you get an error, run DBCC CHECKDB and post the output. |
 |
|
|
Pepper1425
Starting Member
5 Posts |
Posted - 2010-12-17 : 11:24:43
|
| I am not sure what you mean by script it out. I right clicked it and it says script table as - create to, drop to, insert to, etc.... |
|
|
|
Pepper1425
Starting Member
5 Posts |
Posted - 2010-12-17 : 11:29:03
|
| there are constraints set on the field i changed. would that have anything to do with it? |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-12-17 : 11:51:40
|
| Are you getting a database error or a middle teir error or a front end error? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-17 : 11:53:27
|
quote:
Originally posted by Lamprey
Are you getting a database error or a middle teir error or a front end error?
Ahhh, I missed that he said it happens on the web page. Good call Lamprey. |
|
|
|
Pepper1425
Starting Member
5 Posts |
Posted - 2010-12-17 : 11:58:35
|
| [unknown type] - this is the error that displays. So i am assuming it is within the database? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-17 : 12:47:25
|
| sounds like an application error.If you can script the table as create, it isn't likely a database issue.Probably somewhere in the app you've defined a data type and now it doesn't match anymore. |
|
|
|
Pepper1425
Starting Member
5 Posts |
Posted - 2010-12-17 : 13:04:59
|
| thanks for the input.it works now. they didn't match. coldfusion size = 6 and the database was varchar 8. so i changed the code in coldfusion to 8. |
|
|
|
|
|
|
Unknown Type