memotype Parameter Help

[aco636]

Hi All
As always, any help gratefully received.

I am writing a vbScript to insert jobs in to a jobs table.
For the most part, the valuse to be entered are static.
However, as you would expect I have a few variables I need to change with each insert.

I have never worked out how to set the value of a pareter for a memo type. I have a text file I read in to a variable (contains instructions for the job on multiple lines)

I cant work out how to set this into a parameter.

Ideally, I would like to name it @Serviceremarks and insert it like so;
strRemark = read content of file. I have no problem here.

strSQL = "INSERT INTO Jobs(SiteID, CustomerNo, JobDate, ServiceRemarks, EnteredBy)
VALUES(@SiteID, 'ABC123', CURDATE(), @ServiceRemarks, 'ACO')"

Set param = cmd.CreateParameter
param.Append Cmd.CreateParameter("@ServiceRemarks",adMemo,adParamInput)

All gets hazey here setting value

cmd.CommandText = strSQL
Regards ACO

 

[markdmac]

I did a little searching on the net and believe the problem is your single quotes. If that doesn't solve your problem you may want to post in the ASP forum if nobody else here has a suggestion.

I hope you find this post helpful.

Regards,

Mark