FrontPage DB Edit Error

All Forums >> [Web Development] >> ASP and Database

Message

markfay -> FrontPage DB Edit Error (4/21/2008 12:45:34)
Hi: I have been struggling with this one. I have a series of pages that update a table. They all use the same FP update page. Most of them work fine; two of them throw the following error: Database Results Wizard Error Description: [Microsoft][ODBC SQL Server Driver]Invalid use of default parameter Number: -2147467259 (0x80004005) Source: Microsoft OLE DB Provider for ODBC Drivers One or more form fields were empty. You should provide default values for all form fields that are used in the query. This exact same code and exact same DB is working fine in another client's system running on the same hardware. What could I be missing?

Spooky -> RE: FrontPage DB Edit Error (4/21/2008 15:45:22)
What does the update SQl look like?

markfay -> RE: FrontPage DB Edit Error (4/21/2008 15:52:01)

Thanks very much for your help!

I hope this is what you are looking for...

fp_sQry="UPDATE ContentsInventory SET ToolkitID = ::ToolkitID:: , ActivityDate = ::ActivityDate:: , CompanyID = ::CompanyID:: , DateEntered = '::DateEntered::' , RevisedBy = ::RevisedBy:: , EnteredBy = ::EnteredBy:: , Quantity = '::Quantity::' , ItemName= '::ItemName::' , ItemDescription = '::ItemDescription::' , PurchaseLocation = '::PurchaseLocation::' , Make = '::Make::' , Model = '::Model::' , PurchaseDate = '::PurchaseDate::' , SerialNumber = '::SerialNumber::' , ReplacementValue = '::ReplacementValue::' , Age = '::Age::' , Receipt = '::Receipt::' , Betterment = ::Betterment:: , BettermentDescription = '::BettermentDescription::' , SalesTax ='::SalesTax::' , ExtendedValue = '::ExtendedValue::' , DepreciationCategoryID = ::DepreciationCategoryID:: , LimitCategoryID = ::LimitCategoryID:: , InitialValue = '::InitialValue::' , InitialValueEnteredBy = ::InitialValueEnteredBy:: , RevisedValue = '::RevisedValue::' , Location = ::Location:: , Status = '::Status::' , FirstYearDepreciation = '::FirstYearDepreciation::' , OtherYearsDepreciation = '::OtherYearsDepreciation::' , MaxDepreciation = '::MaxDepreciation::' , FlatRateDepreciation = '::FlatRateDepreciation::' , DepreciatedValue = '::DepreciatedValue::' , Shipping = '::Shipping::' , TMFShare = '::TMFShare::' , PaymentValue = '::PaymentValue::' , PayAsReplacement = ::PayAsReplacement:: , SalesTaxYesNo = ::SalesTaxYesNo:: , PaidAmount = '::PaidAmount::' , UpdateDepreciation = '::UpdateDepreciation::' , ItemDisposition = '::ItemDisposition::'  WHERE (InventoryID = ::InventoryID::)"
fp_sDefault="ToolkitID=0&CompanyID=0&DateEntered=&ActivityDate=&RevisedBy=0&EnteredBy=0&Quantity=&ItemName=&ItemDescription=&PurchaseLocation=&Make=&Model=&PurchaseDate=&SerialNumber=&ReplacementValue=&Age=&Receipt=&Betterment=&BettermentDescription=&SalesTax=&ExtendedValue=&DepreciationCategoryID=0&LimitCategoryID=0&InitialValue=&InitialValueEnteredBy=0&RevisedValue=&Location=0&Status=&FirstYearDepreciation=&OtherYearsDepreciation=&MaxDepreciation=&FlatRateDepreciation=&DepreciatedValue=&Shipping=&TMFShare=&PaymentValue=&PayAsReplacement=0&SalesTaxYesNo=0&PaidAmount=&UpdateDepreciation=&ItemDisposition=&InventoryID=0"
fp_sNoRecords=""
fp_sDataConn="claimtoolkit_allmerica"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&InventoryID=3&ToolkitID=3&CompanyID=3&DateEntered=135&ActivityDate=135&RevisedBy=3&EnteredBy=3&Quantity=202&ItemName=130&ItemDescription=203&PurchaseLocation=200&Make=202&Model=202&PurchaseDate=135&SerialNumber=202&ReplacementValue=6&Age=202&Receipt=202&Betterment=6&BettermentDescription=200&SalesTax=6&ExtendedValue=6&DepreciationCategoryID=3&LimitCategoryID=3&InitialValue=6&InitialValueEnteredBy=3&RevisedValue=6&Location=3&Status=202&FirstYearDepreciation=6&OtherYearsDepreciation=6&MaxDepreciation=6&FlatRateDepreciation=6&DepreciatedValue=6&Shipping=6&TMFShare=6&PaymentValue=6&PayAsReplacement=11&SalesTaxYesNo=11&PaidAmount=6&UpdateDepreciation=135&ItemDisposition=200&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

Spooky -> RE: FrontPage DB Edit Error (4/21/2008 15:59:52)
Because its such a long string, there are a couple of things you can do. Firstly, try reducing it too say a 1/3 of the size by removing some of the columns and values. Rerun the page query to see if the error still occurs. If it doesnt, add more columns back in and rerun the query - thus narrowing it down to certain columns. Also, check the inputs carefully in comparison with the DB design. Numeric fields have no apostrophes, text fields do

markfay -> RE: FrontPage DB Edit Error (4/21/2008 16:10:28)
Wow, great common sense suggestion. I did delete them one by one and found the problem and fixed it. Thanks for the help. I really should have been able to find this myself and I am sorry to have bothered you with this. Sincerely, Mark

Page: [1]

0.03125