adding access record with hebrew in asp coming through with ???

[esthera]

I'm trying to add hebrew to my access db through a form.

when I do a regular form it works but when i switch the form to a enctype="multipart/form-data" type so that I can upload an image then when the sql is added to the db it is added as ????? instead of the hebrew.

Does anyone know what could be causing this?

[Bullschmidt]

You'll want to check the documentation of your particular file uploading component or class about how to refer to regular form fields as the usual syntax would not work (as you already found out). Usually there is a syntax that can be used instead of the usual Request.Form(...). And this assumes that you already have this added into the form tag: enctype="multipart/form-data"

So for example instead of something like this:
LName = Request.Form("LName")

With the ASP File Upload Using VBScript by John R. Lewis you'd want to use syntax like this:
LName = objFileUpload.Form.Item("LName")

And this is a pure ASP (i.e. no components) resource for letting the user upload one or more files which is something that was unfortunately not built into ASP:

ASP File Upload Using VBScript by John R. Lewis - 7/10/2000
http://aspzone.com/articles/160.aspx

The above free code has worked well for me and you can copy and paste the code sample which is white on gray (what were they thinking?) or just highlight it and it becomes black on white.