Updating a database with lots of fields

	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

Updating a database with lots of fields

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 >> Updating a database with lots of fields

Page: [1]


mjmtravel Posts: 189 Joined: 7/30/2006 Status: offline	Updating a database with lots of fields - 2/4/2008 19:50:11 Does anyone know if there is a limit to updating a database with the number of fields. I have this code with 36 fields to update, but it seems the farther out I stretch this code it stops updating? fp_sQry="UPDATE Customers SET Traveler1FirstName = '::Traveler1FirstName::', Traveler1LastName = '::Traveler1LastName::', Traveler2FirstName = '::Traveler2FirstName::', Traveler2LastName = '::Traveler2LastName::', HomeAddress = '::HomeAddress::', City = '::City::', StateOrProvince = '::StateOrProvince::', ZipCode = '::ZipCode::', HomePhone = '::HomePhone::', BusinessPhone = '::BusinessPhone::', MobilePhone = '::MobilePhone::', FaxNumber = '::FaxNumber::', EmailAddress = '::EmailAddress::', Passport1 = '::Passport1::', IssueDate = '::IssueDate::', ExpirationDate = '::ExpirationDate::', PlaceofIssue = '::PlaceofIssue::', Passport2 = '::Passport2::', IssueDate2 = '::IssueDate2::', ExpirationDate2 = '::ExpirationDate2::', PlaceofIssue2 = '::PlaceofIssue2::', CCType = '::CCType::', CCNumber = '::CCNumber::', ExpireDate = '::ExpireDate::', CSVNumber = '::CSVNumber::', FreqFlyer1 = '::FreqFlyer1::', FreqFlyer2 = '::FreqFlyer2::', AnniversaryDate = '::AnniversaryDate::', Birthdate1 = '::Birthdate1::' WHERE (UserName = '" & session("UserName") & "')" I check and recheck the dates and number fields but everything seems to be correct. If I take out some it seems to work again but then stops and I get this error Database Results Wizard Error The operation failed. If this continues, please contact your server administrator. Any help would be great, I'm starting to loose my hair.


Spooky Posts: 26597 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Updating a database with lots of fields - 2/4/2008 23:37:57 Perhaps check this post for some debugging info? _____________________________ 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 mjmtravel)


mjmtravel Posts: 189 Joined: 7/30/2006 Status: offline	RE: Updating a database with lots of fields - 2/5/2008 20:23:01 Thanks spooky, I used the quick patch and it worked for me. What a cluster to try and fix. Thanks again. (in reply to Spooky)

Page: [1]

All Forums >> Web Development >> ASP and Database >> Updating a database with lots of fields

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