ColdFusion/MSSQL - unable to add records 1

[soapdad]

I have an MSSQL database that I restored from a backup from my ISP's server onto my own local test server. When I attempt to run a ColdFusion script to add a record to a table it will not add the record, nor does it generate an error. I have the full debugging on in CF and it just says:

(Records=0, Time=0ms)
SQL = INSERT INTO OrderHist .....blah blah blah

The only thing that I can see that might be unique about the database is that it had a full text index on the ISP's server. When I look at the properties of the index, it says the status is idle. I am also able to run any kind of select statements, so CF is seeing the database.
I know I'm not giving a lot of info, but I'm a little lost as to where to start because it's not giving me an error. Does anyone have any thoughts as to what I might try?

Thanks

 

[mrdenny]

Fire up SQL Profiler, Tell it that you want to see the errors, then have CF run the insert statement.

The actual errors will be shown in the SQL Profiler.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[soapdad]

Ahhhh....a new tool to learn. I tried it with the same result, but Profiler shows some of the field entries in red, so I've got to figure out what that means. I might be adding unneeded quotes because those are the fields in red. This is what it showed:

INSERT INTO Aff_Mgr_Sales_Tbl
( AffiliateID, SalesOrderNum, SalesIP, SalesAmount, SalesEmail, SalesPend,CampaignId,LinkId, ProductID)
VALUES (2003127298,'99999999999', '192.168.0.100', 61.56, 'Test@emailaddress.com','N',0,0,0)


Thanks for the help! I think I'm at least on the right track now.