FrontPage DB Edit Error

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

FrontPage DB Edit Error

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> FrontPage DB Edit Error

Page: [1]


markfay Posts: 19 Joined: 7/14/2005 From: Naperville IL Status: offline	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 Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: FrontPage DB Edit Error - 4/21/2008 15:45:22 What does the update SQl look like? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to markfay)

markfay

Posts: 19
Joined: 7/14/2005
From: Naperville IL
Status: offline

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
%>

(in reply to markfay)


Spooky Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	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 _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to markfay)


markfay Posts: 19 Joined: 7/14/2005 From: Naperville IL Status: offline	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 (in reply to markfay)

Page: [1]

All Forums >> Web Development >> ASP and Database >> FrontPage DB Edit Error

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts