Loading a whole HTML document in a SQL 7.0 TEXT field

[Niels Diepeveen]

Alessandro Bottoni schreef:

> I'm using mxODBC. I put all the HTML document in a string variable with this
> instruction:
> Blob = SourceFile.read(-1)
> And I try to put all this stuff in the "Content" TEXT field of SQL70 DB in
> this way:
> SQLCommand = 'update ' + OutPutTable + ' set Content=\'' + Blob + '\' where
> SolutionNumber=' + SolutionNumber
> Cursor.execute(SQLCommand)

You would have to be very lucky for Blob not to contain something that
is illegal in an SQL string literal. Using an SQL parameter might work
better.

-- 
Niels Diepeveen
Endea automatisering