[thelist] VBScript/ASP string concatenation problem

Brian Cummiskey Brian at hondaswap.com
Wed Jul 27 12:24:42 CDT 2005

Pringle, Ron wrote:

> fsPath= "documents/aldermen/agendas/" &
> Year(DetailsRecordSet.Fields.Item("eventDate").Value) & "/" &
> Details.RecordSet.Fields.Item("committeeCode").Value &
> fncFmtDate((DetailsRecordSet.Fields.Item("eventDate").Value), "%b%d%Y") &
> "agd.pdf"
> The above returns an Object required: " error.
> I understand why its generating the error but not how to properly
> contatenate the strings and values together. Any help or pointers to
> documentation or how-tos on the web would be greatly appreciated.

Ron, break it out.  it will make life much easier.


dim eventDate, eventYear, comitteeCode

eventDate = 
fncFmtDate((DetailsRecordSet.Fields.Item("eventDate").Value), "%b%d%Y")
eventYear = Year(DetailsRecordSet.Fields.Item("eventDate").Value)
comitteeCode = Details.RecordSet.Fields.Item("committeeCode").Value

fsPath= "documents/aldermen/agendas/" & eventYear & "/" &
committeeCode & eventDate & "agd.pdf"

so, upon easy looking...  is there supposed to be a / between the 
comitteeCode and the eventDate:

fsPath= "documents/aldermen/agendas/" & eventYear & "/" &
committeeCode & "/" & eventDate & "agd.pdf"

basicaly, the error means it can't find the path, thus can't open the 
file (assuming the file exists)...  so make sure the path does exist, 
and that the rst executes properly, thus leaving you a proper path.  try 
printing out the variables as well...  make sure that they populate what 
they are supposed to in order to create the proper URI


More information about the thelist mailing list