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 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply