May 25, 2004 at 5:50 am
Hi all.======= ERROR MESSAGE ==================Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'Entry Level 1'. /learningcentres/questionnaire/updatequestionnaire.asp, line 279 =======END MESSAGE =====================I get the error message above when submitting to a stored procedure, from an asp page.The error occurs whether the text field has text in it or not, but that may be a red herring not sure, I am also not sure if it is relating to the contents of the field directly before the one which contains the (Entry Level 1) text, which is the contents of a combo box, or another field before it.I have checked the contents of the form and even if I leave it blank, as a test, I still get the same error message.Any help wopuld be appreciated.Gazzer
May 25, 2004 at 6:15 am
Can you put Stored procedure code on forum ?
May 25, 2004 at 6:20 am
The error indicates that you are using execite on a connection object and have a malformed query (possibly a missing quote). As above can you post the asp code that creates the sql and the parameters to the procedure. It may be better to use a command object.
Far away is close at hand in the images of elsewhere.
Anon.
May 25, 2004 at 7:00 am
Sorry not an expert at this yet.
============== CODE ===============
CREATE PROCEDURE UpdateORGDetails
@Contact_Person varchar(50),
@Managing_Organisation varchar(50),
@Name_of_Centre varchar(50),
@House_Name_No varchar(50),
@Street varchar(50),
@District varchar(50),
@Town varchar(100),
@PostCode varchar(15),
@Telephone varchar(20),
@Fax varchar(20),
@E_Mail varchar(100),
@Web_Site varchar(100),
@Centre_Type_School Bit,
@Centre_Type_Library Bit,
@Centre_Type_Youth Bit,
@Centre_Type_CollegeMain Bit,
@Centre_Type_College_Outreach Bit,
@Centre_Type_Women_s Bit,
@Centre_Type_Ethnic_Minority Bit,
@Centre_Type_Museum Bit,
@Centre_Type_Private_training_P Bit,
@Centre_Type_Community Bit,
@Centre_Type_Employer_Workplace Bit,
@Centre_Type_Early_years_Nursar Bit,
@Centre_Type_PlaceOfWorship Bit,
@Centre_Type_Health Bit,
@Centre_Type_Arts Bit,
@Centre_Type_Outreach Bit,
@Centre_Type_Other Bit,
@Centre_Type_Other_Details text,
@Opening_Times text,
@No_of_Hours_Open int,
@Age_groups_0_5 Bit,
@Age_groups_5_7 Bit,
@Age_groups_7_11 Bit,
@Age_groups_11_16 Bit,
@Age_groups_16_18 Bit,
@Age_groups_18_25 Bit,
@Age_groups_25_60 Bit,
@Age_groups_60 Bit,
@Age_groups_All Bit,
@TargetPhysicalDisability Bit,
@TargetLearningDifficulty Bit,
@TargetGenderSpecific Bit,
@TargetEthnicMinority Bit,
@TargetEmployers_staff Bit,
@TargetOther text,
@ICTProvision Bit,
@SecuredICTProvision Bit,
@PCs int,
@PCsOnLine int,
@MACs int,
@MacsOnLine int,
@MobileLaptops int,
@LaptopsOnline int,
@ConnectionMobile Bit,
@ConnectionMobileSpeed varchar(100),
@ConnectionDialUp Bit,
@ConnectionDialUpSpeed varchar(100),
@ConnectionISDN Bit,
@ConnectionISDNSpeed varchar(100),
@ConnectionADSL Bit,
@ConnectionIADSLSpeed varchar(100),
@ConnectionLeased Bit,
@ConnectionILeasedSpeed varchar(100),
@ConnectionCable Bit,
@ConnectionICableSpeed varchar(100),
@ConnectionXDSL Bit,
@ConnectionIXDSLSpeed varchar(100),
@ConnectionWireless Bit,
@ConnectionIWirelessSpeed varchar(100),
@ConnectionOther Bit,
@ConnectionOtherSpecify text,
@MobileProvider text,
@CAD Bit,
@VidEdit Bit,
@VidConf Bit,
@EquipOther text,
@TeachingSupportAssistant varchar(100),
@TeachingSupportGuidance varchar(100),
@BasicIT Bit,
@AdvancedIT Bit,
@OpenIT Bit,
@TrainingOther text,
@Ace_Project Bit,
@Ace_Project_Web varchar(200),
@Ace_Project_Email varchar(200),
@Ace_Project_Telephone varchar(20),
@Age_Concern Bit,
@Age_Concern_Web varchar(200),
@Age_Concern_Email varchar(200),
@Age_Concern_Telephone varchar(20),
@APWA Bit,
@APWA_Web varchar(200),
@APWA_Email varchar(200),
@APWA_Telephone varchar(20),
@Aston_Webgate Bit,
@Aston_Webgate_Web varchar(200),
@Aston_Webgate_Email varchar(200),
@Aston_Webgate_Telephone varchar(20),
@Barnsley_College Bit,
@Barnsley_College_Web varchar(200),
@Barnsley_College_Email varchar(200),
@Barnsley_College_Telephone varchar(20),
@Computer_Education Bit,
@Computer_Education_Web varchar(200),
@Computer_Education_Email varchar(200),
@Computer_Education_Telephone varchar(20),
@Dearne_Valley Bit,
@Dearne_Valley_Web varchar(200),
@Dearne_Valley_Email varchar(200),
@Dearne_Valley_Telephone varchar(20),
@GROW Bit,
@GROW_Web varchar(200),
@GROW_Email varchar(200),
@GROW_Telephone varchar(20),
@Heather_Court Bit,
@Heather_Court_Web varchar(200),
@Heather_Court_Email varchar(200),
@Heather_Court_Telephone varchar(20),
@Kiveton_CLOC Bit,
@Kiveton_CLOC_Web varchar(200),
@Kiveton_CLOC_Email varchar(200),
@Kiveton_CLOC_Telephone varchar(20),
@Learn_direct Bit,
@Learn_direct_Web varchar(200),
@Learn_direct_Email varchar(200),
@Learn_direct_Telephone varchar(20),
@Play_Learn_Bus Bit,
@Play_Learn_Bus_Web varchar(200),
@Play_Learn_Bus_Email varchar(200),
@Play_Learn_Bus_Telephone varchar(20),
@RCAT Bit,
@RCAT_Web varchar(200),
@RCAT_Email varchar(200),
@RCAT_Telephone varchar(20),
@RMBC_Libraries Bit,
@RMBC_Libraries_Web varchar(200),
@RMBC_Libraries_Email varchar(200),
@RMBC_Libraries_Telephone varchar(20),
@RMBC_Young Bit,
@RMBC_Young_Web varchar(200),
@RMBC_Young_Email varchar(200),
@RMBC_Young_Telephone varchar(20),
@ROCC Bit,
@ROCC_Web varchar(200),
@ROCC_Email varchar(200),
@ROCC_Telephone varchar(20),
@Rother_Valley Bit,
@Rother_Valley_Web varchar(200),
@Rother_Valley_Email varchar(200),
@Rother_Valley_Telephone varchar(20),
@Rotherham_Homeless Bit,
@Rotherham_Homeless_Web varchar(200),
@Rotherham_Homeless_Email varchar(200),
@Rotherham_Homeless_Telephone varchar(20),
@Routeways Bit,
@Routeways_Web varchar(200),
@Routeways_Email varchar(200),
@Routeways_Telephone varchar(200),
@Rotherham_Lifestyles Bit,
@Rotherham_Lifestyles_Web varchar(200),
@Rotherham_Lifestyles_Email varchar(200),
@Rotherham_Lifestyles_Telephone varchar(20),
@SOVA Bit,
@SOVA_Web varchar(200),
@SOVA_Email varchar(200),
@SOVA_Telephone varchar(20),
@Training_Exchange Bit,
@Training_Exchange_Web varchar(200),
@Training_Exchange_Email varchar(200),
@Training_Exchange_Telephone varchar(20),
@Thomas_Rotherham Bit,
@Thomas_Rotherham_Web varchar(200),
@Thomas_Rotherham_Email varchar(200),
@Thomas_Rotherham_Telephone varchar(20),
@UK_Online Bit,
@UK_Online_Web varchar(200),
@UK_Online_Email varchar(200),
@UK_Online_Telephone varchar(20),
@WEA Bit,
@WEA_Web varchar(200),
@WEA_Email varchar(200),
@WEA_Telephone varchar(20),
@Yorkshire_Trust Bit,
@Yorkshire_Trust_Web varchar(200),
@Yorkshire_Trust_Email varchar(200),
@Yorkshire_Trust_Telephone varchar(20),
@Course varchar(200),
@Level varchar(20),
@UKOnline Bit,
@CLC Bit,
@LearnDirect Bit,
@Other text,
@Document_Complete_By varchar(50),
@DocHouse_Name_No varchar(50),
@DocStreet varchar(50),
@DocDistrict varchar(50),
@DocTown varchar(50),
@DocPostCode varchar(10),
@DocTelephone varchar(50),
@DocFax varchar(50),
@DocE_Mail varchar(100),
@notes text,
@UpdatedOnline datetime,
@CenterID int
As
UPDATE TblLCLGCentres Set Contact_Person = @Contact_Person
,Managing_Organisation = @Managing_Organisation
,Name_of_Centre = @Name_of_Centre
,House_Name_No = @House_Name_No
,Street = @Street
,District = @District
,Town = @Town
,PostCode = @PostCode
,Telephone = @Telephone
,Fax = @Fax
,E_Mail = @E_Mail
,Web_Site = @Web_Site
,Centre_Type_School = @Centre_Type_School
,Centre_Type_Library = @Centre_Type_Library
,Centre_Type_Youth = @Centre_Type_Youth
,Centre_Type_CollegeMain = @Centre_Type_CollegeMain
,Centre_Type_College_Outreach = @Centre_Type_College_Outreach
,Centre_Type_Women_s = @Centre_Type_Women_s
,Centre_Type_Ethnic_Minority = @Centre_Type_Ethnic_Minority
,Centre_Type_Museum = @Centre_Type_Museum
,Centre_Type_Private_training_P = @Centre_Type_Private_training_P
,Centre_Type_Community = @Centre_Type_Community
,Centre_Type_Employer_Workplace = @Centre_Type_Employer_Workplace
,Centre_Type_Early_years_Nursar = @Centre_Type_Early_years_Nursar
,Centre_Type_PlaceOfWorship = @Centre_Type_PlaceOfWorship
,Centre_Type_Health = @Centre_Type_Health
,Centre_Type_Arts = @Centre_Type_Arts
,Centre_Type_Outreach = @Centre_Type_Outreach
,Centre_Type_Other = @Centre_Type_Other
,Centre_Type_Other_Details = @Centre_Type_Other_Details
,Opening_Times = @Opening_Times
,No_of_Hours_Open = @No_of_Hours_Open
,Age_groups_0_5 = @Age_groups_0_5
,Age_groups_5_7 = @Age_groups_5_7
,Age_groups_7_11 = @Age_groups_7_11
,Age_groups_11_16 = @Age_groups_11_16
,Age_groups_16_18 = @Age_groups_16_18
,Age_groups_18_25 = @Age_groups_18_25
,Age_groups_25_60 = @Age_groups_25_60
,Age_groups_60_ = @Age_groups_60
,Age_groups_All = @Age_groups_All
,TargetPhysicalDisability = @TargetPhysicalDisability
,TargetLearningDifficulty = @TargetLearningDifficulty
,TargetGenderSpecific = @TargetGenderSpecific
,TargetEthnicMinority = @TargetEthnicMinority
,TargetEmployers_staff = @TargetEmployers_staff
,TargetOther = @TargetOther
,ICTProvision = @ICTProvision
,SecuredICTProvision = @SecuredICTProvision
,PCs = CONVERT(int, @PCs)
,PCsOnLine = CONVERT(int, @PCsOnLine)
,MACs = CONVERT(int, @MACs)
,MacsOnLine = CONVERT(int, @MacsOnLine)
,MobileLaptops = CONVERT(int, @MobileLaptops)
,LaptopsOnline = CONVERT(int, @LaptopsOnline)
,ConnectionMobile = @ConnectionMobile
,ConnectionMobileSpeed = @ConnectionMobileSpeed
,ConnectionDialUp = @ConnectionDialUp
,ConnectionDialUpSpeed = @ConnectionDialUpSpeed
,ConnectionISDN = @ConnectionISDN
,ConnectionISDNSpeed = @ConnectionISDNSpeed
,ConnectionADSL = @ConnectionADSL
,ConnectionIADSLSpeed = @ConnectionIADSLSpeed
,ConnectionLeased = @ConnectionLeased
,ConnectionILeasedSpeed = @ConnectionILeasedSpeed
,ConnectionCable = @ConnectionCable
,ConnectionICableSpeed = @ConnectionICableSpeed
,ConnectionXDSL = @ConnectionXDSL
,ConnectionIXDSLSpeed = @ConnectionIXDSLSpeed
,ConnectionWireless = @ConnectionWireless
,ConnectionIWirelessSpeed = @ConnectionIWirelessSpeed
,ConnectionOther = @ConnectionOther
,ConnectionOtherSpecify = @ConnectionOtherSpecify
,MobileProvider = @MobileProvider
,CAD = @CAD
,VidEdit = @VidEdit
,VidConf = @VidConf
,EquipOther = @EquipOther
,TeachingSupportAssistant = CONVERT(int, @TeachingSupportAssistant)
,TeachingSupportGuidance = CONVERT(int, @TeachingSupportGuidance)
,BasicIT = @BasicIT
,AdvancedIT = @AdvancedIT
,OpenIT = @OpenIT
,TrainingOther = @TrainingOther
,Ace_Project = @Ace_Project
,Ace_Project_Web = @Ace_Project_Web
,Ace_Project_Email = @Ace_Project_Email
,Ace_Project_Telephone = @Ace_Project_Telephone
,Age_Concern = @Age_Concern
,Age_Concern_Web = @Age_Concern_Web
,Age_Concern_Email = @Age_Concern_Email
,Age_Concern_Telephone = @Age_Concern_Telephone
,APWA = @APWA
,APWA_Web = @APWA_Web
,APWA_Email = @APWA_Email
,APWA_Telephone = @APWA_Telephone
,Aston_Webgate = @Aston_Webgate
,Aston_Webgate_Web = @Aston_Webgate_Web
,Aston_Webgate_Email = @Aston_Webgate_Email
,Aston_Webgate_Telephone = @Aston_Webgate_Telephone
,Barnsley_College = @Barnsley_College
,Barnsley_College_Web = @Barnsley_College_Web
,Barnsley_College_Email = @Barnsley_College_Email
,Barnsley_College_Telephone = @Barnsley_College_Telephone
,Computer_Education = @Computer_Education
,Computer_Education_Web = @Computer_Education_Web
,Computer_Education_Email = @Computer_Education_Email
,Computer_Education_Telephone = @Computer_Education_Telephone
,Dearne_Valley = @Dearne_Valley
,Dearne_Valley_Web = @Dearne_Valley_Web
,Dearne_Valley_Email = @Dearne_Valley_Email
,Dearne_Valley_Telephone = @Dearne_Valley_Telephone
,GROW = @GROW
,GROW_Web = @GROW_Web
,GROW_Email = @GROW_Email
,GROW_Telephone = @GROW_Telephone
,Heather_Court = @Heather_Court
,Heather_Court_Web = @Heather_Court_Web
,Heather_Court_Email = @Heather_Court_Email
,Heather_Court_Telephone = @Heather_Court_Telephone
,Kiveton_CLOC = @Kiveton_CLOC
,Kiveton_CLOC_Web = @Kiveton_CLOC_Web
,Kiveton_CLOC_Email = @Kiveton_CLOC_Email
,Kiveton_CLOC_Telephone = @Kiveton_CLOC_Telephone
,Learn_direct = @Learn_direct
,Learn_direct_Web = @Learn_direct_Web
,Learn_direct_Email = @Learn_direct_Email
,Learn_direct_Telephone = @Learn_direct_Telephone
,Play_Learn_Bus = @Play_Learn_Bus
,Play_Learn_Bus_Web = @Play_Learn_Bus_Web
,Play_Learn_Bus_Email = @Play_Learn_Bus_Email
,Play_Learn_Bus_Telephone = @Play_Learn_Bus_Telephone
,RCAT = @RCAT
,RCAT_Web = @RCAT_Web
,RCAT_Email = @RCAT_Email
,RCAT_Telephone = @RCAT_Telephone
,RMBC_Libraries = @RMBC_Libraries
,RMBC_Libraries_Web = @RMBC_Libraries_Web
,RMBC_Libraries_Email = @RMBC_Libraries_Email
,RMBC_Libraries_Telephone = @RMBC_Libraries_Telephone
,RMBC_Young = @RMBC_Young
,RMBC_Young_Web = @RMBC_Young_Web
,RMBC_Young_Email = @RMBC_Young_Email
,RMBC_Young_Telephone = @RMBC_Young_Telephone
,ROCC = @ROCC
,ROCC_Web = @ROCC_Web
,ROCC_Email = @ROCC_Email
,ROCC_Telephone = @ROCC_Telephone
,Rother_Valley = @Rother_Valley
,Rother_Valley_Web = @Rother_Valley_Web
,Rother_Valley_Email = @Rother_Valley_Email
,Rother_Valley_Telephone = @Rother_Valley_Telephone
,Rotherham_Homeless = @Rotherham_Homeless
,Rotherham_Homeless_Web = @Rotherham_Homeless_Web
,Rotherham_Homeless_Email = @Rotherham_Homeless_Email
,Rotherham_Homeless_Telephone = @Rotherham_Homeless_Telephone
,Routeways = @Routeways
,Routeways_Web = @Routeways_Web
,Routeways_Email = @Routeways_Email
,Routeways_Telephone = @Routeways_Telephone
,Rotherham_Lifestyles = @Rotherham_Lifestyles
,Rotherham_Lifestyles_Web = @Rotherham_Lifestyles_Web
,Rotherham_Lifestyles_Email = @Rotherham_Lifestyles_Email
,Rotherham_Lifestyles_Telephone = @Rotherham_Lifestyles_Telephone
,SOVA = @SOVA
,SOVA_Web = @SOVA_Web
,SOVA_Email = @SOVA_Email
,SOVA_Telephone = @SOVA_Telephone
,Training_Exchange = @Training_Exchange
,Training_Exchange_Web = @Training_Exchange_Web
,Training_Exchange_Email = @Training_Exchange_Email
,Training_Exchange_Telephone = @Training_Exchange_Telephone
,Thomas_Rotherham = @Thomas_Rotherham
,Thomas_Rotherham_Web = @Thomas_Rotherham_Web
,Thomas_Rotherham_Email = @Thomas_Rotherham_Email
,Thomas_Rotherham_Telephone = @Thomas_Rotherham_Telephone
,UK_Online = @UK_Online
,UK_Online_Web = @UK_Online_Web
,UK_Online_Email = @UK_Online_Email
,UK_Online_Telephone = @UK_Online_Telephone
,WEA = @WEA
,WEA_Web = @WEA_Web
,WEA_Email = @WEA_Email
,WEA_Telephone = @WEA_Telephone
,Yorkshire_Trust = @Yorkshire_Trust
,Yorkshire_Trust_Web = @Yorkshire_Trust_Web
,Yorkshire_Trust_Email = @Yorkshire_Trust_Email
,Yorkshire_Trust_Telephone = @Yorkshire_Trust_Telephone
,Course = @Course
,EntryLevel = @Level
,UKOnline = @UKOnline
,CLC = @CLC
,LearnDirect = @LearnDirect
,Other = @Other
,Document_Complete_By = @Document_Complete_By
,DocHouse_Name_No = @DocHouse_Name_No
,DocStreet = @DocStreet
,DocDistrict = @DocDistrict
,DocTown = @DocTown
,DocPostCode = @DocPostCode
,DocTelephone = @DocTelephone
,DocFax = @DocFax
,DocE_Mail = @DocE_Mail
,notes = @notes
,UpdatedOnline = CONVERT(datetime, @UpdatedOnline, 103)
WHERE LCLG_ID = CONVERT(int, @CenterID)
GO
============== END CODE =================
Hope this helps you, I thought the error was on my web page?.
Cheers.
May 25, 2004 at 7:04 am
Can you post the asp code that creates the sql string
Far away is close at hand in the images of elsewhere.
Anon.
May 25, 2004 at 7:36 am
sqlstring= "EXECUTE UpdateORGDetails '" & Contact_Person & "', '" & Managing_Organisation & "', '" & Name_of_Centre & "', '" & House_Name_No & "', '" & Street & "', '" & District & "', '" & Town & "', '" & PostCode & "', '" & Telephone & "', '" & Fax & "', '" & E_Mail & "', '" & Web_Site & "', '" & Centre_Type_School & "', '" & Centre_Type_Library & "', '" & Centre_Type_Youth & "', '" & Centre_Type_CollegeMain & "', '" & Centre_Type_College_Outreach & "', '" & Centre_Type_Women_s & "', '" & Centre_Type_Ethnic_Minority & "', '" & Centre_Type_Museum & "', '" & Centre_Type_Private_training_P & "', '" & Centre_Type_Community & "', '" & Centre_Type_Employer_Workplace & "', '" & Centre_Type_Early_years_Nursar & "', '" & Centre_Type_PlaceOfWorship & "', '" & Centre_Type_Health & "', '" & Centre_Type_Arts & "', '" & Centre_Type_Outreach & "', '" & Centre_Type_Other & "', '" & Centre_Type_Other_Details & "', '" & Opening_Times & "', '" & No_of_Hours_Open & "', '" & Age_groups_0_5 & "', '" & Age_groups_5_7 & "', '" & Age_groups_7_11 & "', '" & Age_groups_11_16 & "', '" & Age_groups_16_18 & "', '" & Age_groups_18_25 & "', '" & Age_groups_25_60 & "', '" & Age_groups_60 & "', '" & Age_groups_All & "', '" & TargetPhysicalDisability & "', '" & TargetLearningDifficulty & "', '" & TargetGenderSpecific & "', '" & TargetEthnicMinority & "', '" & TargetEmployers_staff '" & , '" & TargetOther & "', '" & ICTProvision & "', '" & SecuredICTProvision & "', '" & PCs & "', '" & PCsOnLine & "', '" & MACs & "', '" & MacsOnLine & "', '" & MobileLaptops & "', '" & LaptopsOnline & "', '" & ConnectionMobile & "', '" & ConnectionMobileSpeed & "', '" & ConnectionDialUp & "', '" & ConnectionDialUpSpeed & "', '" & ConnectionISDN & "', '" & ConnectionISDNSpeed & "', '" & ConnectionADSL & "', '" & ConnectionIADSLSpeed & "', '" & ConnectionLeased & "', '" & ConnectionILeasedSpeed & "', '" & ConnectionCable & "', '" & ConnectionICableSpeed & "', '" & ConnectionXDSL & "', '" & ConnectionIXDSLSpeed & "', '" & ConnectionWireless & "', '" & ConnectionIWirelessSpeed & "', '" & ConnectionOther & "', '" & ConnectionOtherSpecify & "', '" & MobileProvider & "', '" & CAD & "', '" & VidEdit & "', '" & VidConf & "', '" & EquipOther & "', '" & TeachingSupportAssistant & "', '" & TeachingSupportGuidance & "', '" & BasicIT & "', '" & AdvancedIT & "', '" & OpenIT & "', '" & TrainingOther & "', '" & Ace_Project & "', '" & Ace_Project_Web & "', '" & Ace_Project_Email & "', '" & Ace_Project_Telephone & "', '" & Age_Concern & "', '" & Age_Concern_Web & "', '" & Age_Concern_Email & "', '" & Age_Concern_Telephone & "', '" & APWA & "', '" & APWA_Web & "', '" & APWA_Email & "', '" & APWA_Telephone & "', '" & Aston_Webgate & "', '" & Aston_Webgate_Web & "', '" & Aston_Webgate_Email & "', '" & Aston_Webgate_Telephone & "', '" & Barnsley_College & "', '" & Barnsley_College_Web & "', '" & Barnsley_College_Email & "', '" & Barnsley_College_Telephone & "', '" & Computer_Education & "', '" & Computer_Education_Web & "', '" & Computer_Education_Email & "', '" & Computer_Education_Telephone & "', '" & Dearne_Valley & "', '" & Dearne_Valley_Web & "', '" & Dearne_Valley_Email & "', '" & Dearne_Valley_Telephone & "', '" & GROW & "', '" & GROW_Web & "', '" & GROW_Email & "', '" & GROW_Telephone & "', '" & Heather_Court & "', '" & Heather_Court_Web & "', '" & Heather_Court_Email & "', '" & Heather_Court_Telephone & "', '" & Kiveton_CLOC & "', '" & Kiveton_CLOC_Web & "', '" & Kiveton_CLOC_Email & "', '" & Kiveton_CLOC_Telephone & "', '" & Learn_direct & "', '" & Learn_direct_Web & "', '" & Learn_direct_Email & "', '" & Learn_direct_Telephone & "', '" & Play_Learn_Bus & "', '" & Play_Learn_Bus_Web & "', '" & Play_Learn_Bus_Email & "', '" & Play_Learn_Bus_Telephone & "', '" & RCAT & "', '" & RCAT_Web & "', '" & RCAT_Email & "', '" & RCAT_Telephone & "', '" & RMBC_Libraries & "', '" & RMBC_Libraries_Web & "', '" & RMBC_Libraries_Email & "', '" & RMBC_Libraries_Telephone & "', '" & RMBC_Young & "', '" & RMBC_Young_Web & "', '" & RMBC_Young_Email & "', '" & RMBC_Young_Telephone & "', '" & ROCC & "', '" & ROCC_Web & "', '" & ROCC_Email & "', '" & ROCC_Telephone & "', '" & Rother_Valley & "', '" & Rother_Valley_Web & "', '" & Rother_Valley_Email & "', '" & Rother_Valley_Telephone & "', '" & Rotherham_Homeless & "', '" & Rotherham_Homeless_Web & "', '" & Rotherham_Homeless_Email & "', '" & Rotherham_Homeless_Telephone & "', '" & Routeways & "', '" & Routeways_Web & "', '" & Routeways_Email & "', '" & Routeways_Telephone & "', '" & Rotherham_Lifestyles & "', '" & Rotherham_Lifestyles_Web & "', '" & Rotherham_Lifestyles_Email & "', '" & Rotherham_Lifestyles_Telephone & "', '" & SOVA & "', '" & SOVA_Web & "', '" & SOVA_Email & "', '" & SOVA_Telephone & "', '" & Training_Exchange & "', '" & Training_Exchange_Web & "', '" & Training_Exchange_Email & "', '" & Training_Exchange_Telephone & "', '" & Thomas_Rotherham & "', '" & Thomas-Rotherham_Web & "', '" & Thomas_Rotherham_Email & "', '" & Thomas_Rotherham_Telephone & "', '" & UK_Online & "', '" & UK_Online_Web & "', '" & UK_Online_Email & "', '" & UK_Online_Telephone & "', '" & WEA & "', '" & WEA_Web & "', '" & WEA_Email & "', '" & WEA_Telephone & "', '" & Yorkshire_Trust & "', '" & Yorkshire_Trust_Web & "', '" & Yorkshire_Trust_Email & "', '" & Yorkshire_Trust_Telephone & "', '" & Course & "', '" & Level & "', '" & UKOnline & "', '" & CLC & "', '" & LearnDirect & "', '" & Other & "', '" & Document_Complete_By & "', '" & DocHouse_Name_No & "', '" & DocStreet & "', '" & DocDistrict & "', '" & DocTown & "', '" & DocPostCode & "', '" & DocTelephone & "', '" & DocFax & "', '" & DocE_Mail & "', '" & notes & "', '" & UpdatedOnline & "', '" & CenterID & "'"
db.execute sqlstring
May 25, 2004 at 8:03 am
You have incorrect code between TargetEmployers_staff and TargetOther
it should be
TargetEmployers_staff & "', '" & TargetOther
I think you have quotes around all your data including bit fields. I suggest you use a command object like this
Set Comm = CreateObject("ADODB.Command")
Comm.ActiveConnection = db
Comm.CommandType = 4 'adCmdStoredProc
Comm.CommandText = "UpdateORGDetails"
Comm.Parameters("@Contact_Person").Value = Contact_Person
Comm.Parameters("@Managing_Organisation").Value = Managing_Organisation
Comm.Parameters("@Name_of_Centre").Value = Name_of_Centre
Comm.Parameters("@House_Name_No").Value = House_Name_No
Comm.Parameters("@Street").Value = Street
Comm.Parameters("@District").Value = District
Comm.Parameters("@Town").Value = Town
Comm.Parameters("@PostCode").Value = PostCode
Comm.Parameters("@Telephone").Value = Telephone
Comm.Parameters("@Fax").Value = Fax
Comm.Parameters("@E_Mail").Value = E_Mail
Comm.Parameters("@Web_Site").Value = Web_Site
Comm.Parameters("@Centre_Type_School").Value = Centre_Type_School
Comm.Parameters("@Centre_Type_Library").Value = Centre_Type_Library
Comm.Parameters("@Centre_Type_Youth").Value = Centre_Type_Youth
Comm.Parameters("@Centre_Type_CollegeMain").Value = Centre_Type_CollegeMain
Comm.Parameters("@Centre_Type_College_Outreach").Value = Centre_Type_College_Outreach
Comm.Parameters("@Centre_Type_Women_s").Value = Centre_Type_Women_s
Comm.Parameters("@Centre_Type_Ethnic_Minority").Value = Centre_Type_Ethnic_Minority
Comm.Parameters("@Centre_Type_Museum").Value = Centre_Type_Museum
Comm.Parameters("@Centre_Type_Private_training_P").Value = Centre_Type_Private_training_P
Comm.Parameters("@Centre_Type_Community").Value = Centre_Type_Community
Comm.Parameters("@Centre_Type_Employer_Workplace").Value = Centre_Type_Employer_Workplace
Comm.Parameters("@Centre_Type_Early_years_Nursar").Value = Centre_Type_Early_years_Nursar
Comm.Parameters("@Centre_Type_PlaceOfWorship").Value = Centre_Type_PlaceOfWorship
Comm.Parameters("@Centre_Type_Health").Value = Centre_Type_Health
Comm.Parameters("@Centre_Type_Arts").Value = Centre_Type_Arts
Comm.Parameters("@Centre_Type_Outreach").Value = Centre_Type_Outreach
Comm.Parameters("@Centre_Type_Other").Value = Centre_Type_Other
Comm.Parameters("@Centre_Type_Other_Details").Value = Centre_Type_Other_Details
Comm.Parameters("@Opening_Times").Value = Opening_Times
Comm.Parameters("@No_of_Hours_Open").Value = No_of_Hours_Open
Comm.Parameters("@Age_groups_0_5").Value = Age_groups_0_5
Comm.Parameters("@Age_groups_5_7").Value = Age_groups_5_7
Comm.Parameters("@Age_groups_7_11").Value = Age_groups_7_11
Comm.Parameters("@Age_groups_11_16").Value = Age_groups_11_16
Comm.Parameters("@Age_groups_16_18").Value = Age_groups_16_18
Comm.Parameters("@Age_groups_18_25").Value = Age_groups_18_25
Comm.Parameters("@Age_groups_25_60").Value = Age_groups_25_60
Comm.Parameters("@Age_groups_60").Value = Age_groups_60
Comm.Parameters("@Age_groups_All").Value = Age_groups_All
Comm.Parameters("@TargetPhysicalDisability").Value = TargetPhysicalDisability
Comm.Parameters("@TargetLearningDifficulty").Value = TargetLearningDifficulty
Comm.Parameters("@TargetGenderSpecific").Value = TargetGenderSpecific
Comm.Parameters("@TargetEthnicMinority").Value = TargetEthnicMinority
Comm.Parameters("@TargetEmployers_staff").Value = TargetEmployers_staff
Comm.Parameters("@TargetOther").Value = TargetOther
Comm.Parameters("@ICTProvision").Value = ICTProvision
Comm.Parameters("@SecuredICTProvision").Value = SecuredICTProvision
Comm.Parameters("@PCs").Value = PCs
Comm.Parameters("@PCsOnLine").Value = PCsOnLine
Comm.Parameters("@MACs").Value = MACs
Comm.Parameters("@MacsOnLine").Value = MacsOnLine
Comm.Parameters("@MobileLaptops").Value = MobileLaptops
Comm.Parameters("@LaptopsOnline").Value = LaptopsOnline
Comm.Parameters("@ConnectionMobile").Value = ConnectionMobile
Comm.Parameters("@ConnectionMobileSpeed").Value = ConnectionMobileSpeed
Comm.Parameters("@ConnectionDialUp").Value = ConnectionDialUp
Comm.Parameters("@ConnectionDialUpSpeed").Value = ConnectionDialUpSpeed
Comm.Parameters("@ConnectionISDN").Value = ConnectionISDN
Comm.Parameters("@ConnectionISDNSpeed").Value = ConnectionISDNSpeed
Comm.Parameters("@ConnectionADSL").Value = ConnectionADSL
Comm.Parameters("@ConnectionIADSLSpeed").Value = ConnectionIADSLSpeed
Comm.Parameters("@ConnectionLeased").Value = ConnectionLeased
Comm.Parameters("@ConnectionILeasedSpeed").Value = ConnectionILeasedSpeed
Comm.Parameters("@ConnectionCable").Value = ConnectionCable
Comm.Parameters("@ConnectionICableSpeed").Value = ConnectionICableSpeed
Comm.Parameters("@ConnectionXDSL").Value = ConnectionXDSL
Comm.Parameters("@ConnectionIXDSLSpeed").Value = ConnectionIXDSLSpeed
Comm.Parameters("@ConnectionWireless").Value = ConnectionWireless
Comm.Parameters("@ConnectionIWirelessSpeed").Value = ConnectionIWirelessSpeed
Comm.Parameters("@ConnectionOther").Value = ConnectionOther
Comm.Parameters("@ConnectionOtherSpecify").Value = ConnectionOtherSpecify
Comm.Parameters("@MobileProvider").Value = MobileProvider
Comm.Parameters("@CAD").Value = CAD
Comm.Parameters("@VidEdit").Value = VidEdit
Comm.Parameters("@VidConf").Value = VidConf
Comm.Parameters("@EquipOther").Value = EquipOther
Comm.Parameters("@TeachingSupportAssistant").Value = TeachingSupportAssistant
Comm.Parameters("@TeachingSupportGuidance").Value = TeachingSupportGuidance
Comm.Parameters("@BasicIT").Value = BasicIT
Comm.Parameters("@AdvancedIT").Value = AdvancedIT
Comm.Parameters("@OpenIT").Value = OpenIT
Comm.Parameters("@TrainingOther").Value = TrainingOther
Comm.Parameters("@Ace_Project").Value = Ace_Project
Comm.Parameters("@Ace_Project_Web").Value = Ace_Project_Web
Comm.Parameters("@Ace_Project_Email").Value = Ace_Project_Email
Comm.Parameters("@Ace_Project_Telephone").Value = Ace_Project_Telephone
Comm.Parameters("@Age_Concern").Value = Age_Concern
Comm.Parameters("@Age_Concern_Web").Value = Age_Concern_Web
Comm.Parameters("@Age_Concern_Email").Value = Age_Concern_Email
Comm.Parameters("@Age_Concern_Telephone").Value = Age_Concern_Telephone
Comm.Parameters("@APWA").Value = APWA
Comm.Parameters("@APWA_Web").Value = APWA_Web
Comm.Parameters("@APWA_Email").Value = APWA_Email
Comm.Parameters("@APWA_Telephone").Value = APWA_Telephone
Comm.Parameters("@Aston_Webgate").Value = Aston_Webgate
Comm.Parameters("@Aston_Webgate_Web").Value = Aston_Webgate_Web
Comm.Parameters("@Aston_Webgate_Email").Value = Aston_Webgate_Email
Comm.Parameters("@Aston_Webgate_Telephone").Value = Aston_Webgate_Telephone
Comm.Parameters("@Barnsley_College").Value = Barnsley_College
Comm.Parameters("@Barnsley_College_Web").Value = Barnsley_College_Web
Comm.Parameters("@Barnsley_College_Email").Value = Barnsley_College_Email
Comm.Parameters("@Barnsley_College_Telephone").Value = Barnsley_College_Telephone
Comm.Parameters("@Computer_Education").Value = Computer_Education
Comm.Parameters("@Computer_Education_Web").Value = Computer_Education_Web
Comm.Parameters("@Computer_Education_Email").Value = Computer_Education_Email
Comm.Parameters("@Computer_Education_Telephone").Value = Computer_Education_Telephone
Comm.Parameters("@Dearne_Valley").Value = Dearne_Valley
Comm.Parameters("@Dearne_Valley_Web").Value = Dearne_Valley_Web
Comm.Parameters("@Dearne_Valley_Email").Value = Dearne_Valley_Email
Comm.Parameters("@Dearne_Valley_Telephone").Value = Dearne_Valley_Telephone
Comm.Parameters("@GROW").Value = GROW
Comm.Parameters("@GROW_Web").Value = GROW_Web
Comm.Parameters("@GROW_Email").Value = GROW_Email
Comm.Parameters("@GROW_Telephone").Value = GROW_Telephone
Comm.Parameters("@Heather_Court").Value = Heather_Court
Comm.Parameters("@Heather_Court_Web").Value = Heather_Court_Web
Comm.Parameters("@Heather_Court_Email").Value = Heather_Court_Email
Comm.Parameters("@Heather_Court_Telephone").Value = Heather_Court_Telephone
Comm.Parameters("@Kiveton_CLOC").Value = Kiveton_CLOC
Comm.Parameters("@Kiveton_CLOC_Web").Value = Kiveton_CLOC_Web
Comm.Parameters("@Kiveton_CLOC_Email").Value = Kiveton_CLOC_Email
Comm.Parameters("@Kiveton_CLOC_Telephone").Value = Kiveton_CLOC_Telephone
Comm.Parameters("@Learn_direct").Value = Learn_direct
Comm.Parameters("@Learn_direct_Web").Value = Learn_direct_Web
Comm.Parameters("@Learn_direct_Email").Value = Learn_direct_Email
Comm.Parameters("@Learn_direct_Telephone").Value = Learn_direct_Telephone
Comm.Parameters("@Play_Learn_Bus").Value = Play_Learn_Bus
Comm.Parameters("@Play_Learn_Bus_Web").Value = Play_Learn_Bus_Web
Comm.Parameters("@Play_Learn_Bus_Email").Value = Play_Learn_Bus_Email
Comm.Parameters("@Play_Learn_Bus_Telephone").Value = Play_Learn_Bus_Telephone
Comm.Parameters("@RCAT").Value = RCAT
Comm.Parameters("@RCAT_Web").Value = RCAT_Web
Comm.Parameters("@RCAT_Email").Value = RCAT_Email
Comm.Parameters("@RCAT_Telephone").Value = RCAT_Telephone
Comm.Parameters("@RMBC_Libraries").Value = RMBC_Libraries
Comm.Parameters("@RMBC_Libraries_Web").Value = RMBC_Libraries_Web
Comm.Parameters("@RMBC_Libraries_Email").Value = RMBC_Libraries_Email
Comm.Parameters("@RMBC_Libraries_Telephone").Value = RMBC_Libraries_Telephone
Comm.Parameters("@RMBC_Young").Value = RMBC_Young
Comm.Parameters("@RMBC_Young_Web").Value = RMBC_Young_Web
Comm.Parameters("@RMBC_Young_Email").Value = RMBC_Young_Email
Comm.Parameters("@RMBC_Young_Telephone").Value = RMBC_Young_Telephone
Comm.Parameters("@ROCC").Value = ROCC
Comm.Parameters("@ROCC_Web").Value = ROCC_Web
Comm.Parameters("@ROCC_Email").Value = ROCC_Email
Comm.Parameters("@ROCC_Telephone").Value = ROCC_Telephone
Comm.Parameters("@Rother_Valley").Value = Rother_Valley
Comm.Parameters("@Rother_Valley_Web").Value = Rother_Valley_Web
Comm.Parameters("@Rother_Valley_Email").Value = Rother_Valley_Email
Comm.Parameters("@Rother_Valley_Telephone").Value = Rother_Valley_Telephone
Comm.Parameters("@Rotherham_Homeless").Value = Rotherham_Homeless
Comm.Parameters("@Rotherham_Homeless_Web").Value = Rotherham_Homeless_Web
Comm.Parameters("@Rotherham_Homeless_Email").Value = Rotherham_Homeless_Email
Comm.Parameters("@Rotherham_Homeless_Telephone").Value = Rotherham_Homeless_Telephone
Comm.Parameters("@Routeways").Value = Routeways
Comm.Parameters("@Routeways_Web").Value = Routeways_Web
Comm.Parameters("@Routeways_Email").Value = Routeways_Email
Comm.Parameters("@Routeways_Telephone").Value = Routeways_Telephone
Comm.Parameters("@Rotherham_Lifestyles").Value = Rotherham_Lifestyles
Comm.Parameters("@Rotherham_Lifestyles_Web").Value = Rotherham_Lifestyles_Web
Comm.Parameters("@Rotherham_Lifestyles_Email").Value = Rotherham_Lifestyles_Email
Comm.Parameters("@Rotherham_Lifestyles_Telephone").Value = Rotherham_Lifestyles_Telephone
Comm.Parameters("@SOVA").Value = SOVA
Comm.Parameters("@SOVA_Web").Value = SOVA_Web
Comm.Parameters("@SOVA_Email").Value = SOVA_Email
Comm.Parameters("@SOVA_Telephone").Value = SOVA_Telephone
Comm.Parameters("@Training_Exchange").Value = Training_Exchange
Comm.Parameters("@Training_Exchange_Web").Value = Training_Exchange_Web
Comm.Parameters("@Training_Exchange_Email").Value = Training_Exchange_Email
Comm.Parameters("@Training_Exchange_Telephone").Value = Training_Exchange_Telephone
Comm.Parameters("@Thomas_Rotherham").Value = Thomas_Rotherham
Comm.Parameters("@Thomas_Rotherham_Web").Value = Thomas-Rotherham_Web
Comm.Parameters("@Thomas_Rotherham_Email").Value = Thomas_Rotherham_Email
Comm.Parameters("@Thomas_Rotherham_Telephone").Value = Thomas_Rotherham_Telephone
Comm.Parameters("@UK_Online").Value = UK_Online
Comm.Parameters("@UK_Online_Web").Value = UK_Online_Web
Comm.Parameters("@UK_Online_Email").Value = UK_Online_Email
Comm.Parameters("@UK_Online_Telephone").Value = UK_Online_Telephone
Comm.Parameters("@WEA").Value = WEA
Comm.Parameters("@WEA_Web").Value = WEA_Web
Comm.Parameters("@WEA_Email").Value = WEA_Email
Comm.Parameters("@WEA_Telephone").Value = WEA_Telephone
Comm.Parameters("@Yorkshire_Trust").Value = Yorkshire_Trust
Comm.Parameters("@Yorkshire_Trust_Web").Value = Yorkshire_Trust_Web
Comm.Parameters("@Yorkshire_Trust_Email").Value = Yorkshire_Trust_Email
Comm.Parameters("@Yorkshire_Trust_Telephone").Value = Yorkshire_Trust_Telephone
Comm.Parameters("@Course").Value = Course
Comm.Parameters("@Level").Value = Level
Comm.Parameters("@UKOnline").Value = UKOnline
Comm.Parameters("@CLC").Value = CLC
Comm.Parameters("@LearnDirect").Value = LearnDirect
Comm.Parameters("@Other").Value = Other
Comm.Parameters("@Document_Complete_By").Value = Document_Complete_By
Comm.Parameters("@DocHouse_Name_No").Value = DocHouse_Name_No
Comm.Parameters("@DocStreet").Value = DocStreet
Comm.Parameters("@DocDistrict").Value = DocDistrict
Comm.Parameters("@DocTown").Value = DocTown
Comm.Parameters("@DocPostCode").Value = DocPostCode
Comm.Parameters("@DocTelephone").Value = DocTelephone
Comm.Parameters("@DocFax").Value = DocFax
Comm.Parameters("@DocE_Mail").Value = DocE_Mail
Comm.Parameters("@notes").Value = notes
Comm.Parameters("@UpdatedOnline").Value = UpdatedOnline
Comm.Parameters("@CenterID").Value = CenterID
Comm.Execute
Far away is close at hand in the images of elsewhere.
Anon.
May 26, 2004 at 1:26 am
Hi again,
I used the code above and I now get the following error.
ADODB.Parameter error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/learningcentres/questionnaire/updatequestionnaire.asp, line 334
Which appears to be this line in the code.
Comm.Parameters("@TargetEmployers_staff").Value = TargetEmployers_staff
The field data type is Bit like all those previous.
I checked the database to make sure the data type was correct etc, and all seems ok.
Cheers
May 26, 2004 at 2:21 am
Check the contents of TargetEmployers_staff to make sure it contains a value and that it is valid.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy