problem with insert, sql server and classic asp
Posted on 2011-02-14
here is my problem: i have two classic asp pages on the same server on the same website, both perform an identical INSERT operation on the same db (MSSQL 2005 Express). however, one performs it perfectly and the other does not. the one that fails does not generate any errors, rather it does create the new row, but it does not populate the row with all the values specified in the query.
the query generated by the ASP pages is as follows:
INSERT INTO SomeTable (column1,column2,column3) VALUES (value1,'value2',value3)
column1 and column3 are integer and column 2 is varchar. on the failing operation, the integer columns work fine, but the varchar column shows up blank in the DB. not NULL, mind you, but blank.
why would a query (identical!!!) work on one page and not another? both use the same connection string...
anyway, any help would be greatly appreciated.