Discuss "Syntax Error with Arrays" in the ASP Development forum.

BLaaaaaaaaaarche · #1 August 18th, 2008, 11:49 AM

Okay, I am trying to create a very large array. The first array stores strings, the second, stores values from variables. What is the proper syntax for these two:

Code:

		arrFields = Array( & _
			"int_JobID","int_JobDepartmentID","int_JobDivisionID","int_ResumeUpload","ResumeDateSubmitted", & _
			"ResumeFirstName","ResumeMiddleInitial","ResumeLastName","ResumeAddress1","ResumeAddress2","ResumeCity","ResumeState","ResumePostalCode","ResumeCountry","ResumeEmailAddress","ResumePhoneNumber", & _
			"ResumeUSAuthorized","ResumeMinimumAge","ResumePreviousEmployee","ResumePreviousEmployeeDate","ResumePreviousEmployeeDepartment","ResumePreviousEmployeeJobTitle", & _
			"ResumeFelonyConviction","ResumeFelonyConvictionExplanation","ResumeFelonyConvictionAlias", & _
			"ResumeHighSchoolName","ResumeHighSchoolLocation","ResumeHighSchoolGraduate","ResumeHighSchoolGED", & _
			"ResumeEducationSchoolName1","ResumeEducationLocation1","ResumeEducationMajor1","ResumeEducationDegree1", & _
			"ResumeEducationSchoolName2","ResumeEducationLocation2","ResumeEducationMajor2","ResumeEducationDegree2", & _
			"ResumeMilitaryServed","ResumeMilitaryBranch","ResumeMilitaryDateEntered","ResumeMilitaryDateDischarged","ResumeMilitaryRank","ResumeMilitaryReserveStatus","ResumeMilitarySpecialTraining", & _
			"ResumeExperienceCompanyName1","ResumeExperienceCompanyAddress1","ResumeExperienceCompanyPhoneNumber1","ResumeExperienceEmploymentDate1","ResumeExperienceJobTitle1","ResumeExperienceSupervisor1","ResumeExperienceJobDuties1","ResumeExperienceSalary1","ResumeExperienceReasonLeave1", & _
			"ResumeExperienceCompanyName2","ResumeExperienceCompanyAddress2","ResumeExperienceCompanyPhoneNumber2","ResumeExperienceEmploymentDate2","ResumeExperienceJobTitle2","ResumeExperienceSupervisor2","ResumeExperienceJobDuties2","ResumeExperienceSalary2","ResumeExperienceReasonLeave2", & _
			"ResumeExperienceCompanyName3","ResumeExperienceCompanyAddress3","ResumeExperienceCompanyPhoneNumber3","ResumeExperienceEmploymentDate3","ResumeExperienceJobTitle3","ResumeExperienceSupervisor3","ResumeExperienceJobDuties3","ResumeExperienceSalary3","ResumeExperienceReasonLeave3" & _
			)
		arrValues = Array( & _
			JobID,JobDepartmentID,JobDivisionID,0,addDate(Now()), & _
			ResumeFirstName,ResumeMiddleInitial,ResumeLastName,ResumeAddress1,ResumeAddress2,ResumeCity,ResumeState,ResumePostalCode,ResumeCountry,ResumeEmailAddress,ResumePhoneNumber, & _
			ResumeUSAuthorized,ResumeMinimumAge,ResumePreviousEmployee,ResumePreviousEmployeeDate,ResumePreviousEmployeeDepartment,ResumePreviousEmployeeJobTitle, & _
			ResumeFelonyConviction,ResumeFelonyConvictionExplanation,ResumeFelonyConvictionAlias, & _
			ResumeHighSchoolName,ResumeHighSchoolLocation,ResumeHighSchoolGraduate,ResumeHighSchoolGED, & _
			ResumeEducationSchoolName1,ResumeEducationLocation1,ResumeEducationMajor1,ResumeEducationDegree1, & _
			ResumeEducationSchoolName2,ResumeEducationLocation2,ResumeEducationMajor2,ResumeEducationDegree2, & _
			ResumeMilitaryServed,ResumeMilitaryBranch,ResumeMilitaryDateEntered,ResumeMilitaryDateDischarged,ResumeMilitaryRank,ResumeMilitaryReserveStatus,ResumeMilitarySpecialTraining, & _
			ResumeExperienceCompanyName1,ResumeExperienceCompanyAddress1,ResumeExperienceCompanyPhoneNumber1,ResumeExperienceEmploymentDate1,ResumeExperienceJobTitle1,ResumeExperienceSupervisor1,ResumeExperienceJobDuties1,ResumeExperienceSalary1,ResumeExperienceReasonLeave1, & _
			ResumeExperienceCompanyName2,ResumeExperienceCompanyAddress2,ResumeExperienceCompanyPhoneNumber2,ResumeExperienceEmploymentDate2,ResumeExperienceJobTitle2,ResumeExperienceSupervisor2,ResumeExperienceJobDuties2,ResumeExperienceSalary2,ResumeExperienceReasonLeave2, & _
			ResumeExperienceCompanyName3,ResumeExperienceCompanyAddress3,ResumeExperienceCompanyPhoneNumber3,ResumeExperienceEmploymentDate3,ResumeExperienceJobTitle3,ResumeExperienceSupervisor3,ResumeExperienceJobDuties3,ResumeExperienceSalary3,ResumeExperienceReasonLeave3 & _
			)

jmurrayhead · #2 August 18th, 2008, 12:14 PM

The syntax looks fine to me, what's the exact error you get?

BLaaaaaaaaaarche · #3 August 18th, 2008, 12:53 PM

Here is the error:

Code:

ASP Error occurred 8/18/2008 9:52:59 AM in Microsoft VBScript compilation 
Error number: -2146827286 (0x800A03EA)
File: /contact/employment/online-resume/submit-resume/default.asp, line 154, column 19
arrFields = Array( & _
------------------^
Syntax error

jmurrayhead · #4 August 18th, 2008, 02:20 PM

Ahh...remove the ampersand at the beginning. The underscore is for line continuation. You only need the ampersand for when you're concatenating to something.

BLaaaaaaaaaarche · #5 August 18th, 2008, 03:14 PM

Yep, I actually had to remove all ampersands since I was not dealing with strings. Thanks for the info. I definately overlooked that one...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OleDbException: Syntax error (missing operator)	richyrich	SQL Development	2	July 24th, 2008 06:37 AM
syntax	Shem	.Net Development	1	July 9th, 2008 05:11 AM

The Following 2 Users Say Thank You to jmurrayhead For This Useful Post:
BLaaaaaaaaaarche (August 18th, 2008), Rebelle (August 18th, 2008)

Discuss "Syntax Error with Arrays" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.