|
mjmtravel -> 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.
|
|
|
|
