...and this is the err;

Feiltype:
Microsoft VBScript-kompileringsfeil (0x800A0401)
Forventet slutt på setning expected end
/MyHyperF/bilde_sjekk.asp, line 68, column 59

MyConn4.Execute "UPDATE Produkt SET ProduktBilde = '" <img src = C:/dir/ '" & "' & File.FileName & '" & "' & ">" & '" WHERE ProduktNavn = "' & session("Navn") & '"'
----------------------------------------------------------^

Mvh
grstad

There is no need to store the '<img src = C:/dir/' in the database. Even if you wanted to how do you know youre host is going to place your web site on its c drive? This is just one of the many things wrong with storing this type of path. Have another read of this entire post for one of the several ways to achieve your 'what do I place in the database for an image reference' I even gave you examples including code on what to store, and how to render your image on the page. If you done it the way I suggested you SQL syntax would be:

"UPDATE Produkt SET ProduktBilde = '" & File.FileName & "' WHERE ProduktNavn = '" & session("Navn") & "';"

FYI There are many things wrong with your sql syntax. Do you have a color coded code editor? If so you should know this already, if not perhaps you should get one.

;;;Sending an email from within the app
XP does not ship the CDONTS.dll it has been depreciated by MS. A couple of options:
1..Download and register the .dll
2..Ask google for the 'CDOSYS syntax' - this is the reccomended mail method and the one I suggest you use

;;;A clients uploading of an image and the apps displaying of that image,
You have been given this link erlier in the post, search this forum for pure ASP upload

;;paging when requesting a recordset
There are so many code examples within this forum and all around the net. Have a go, when you run into problems post the problematic code and error details for help. No one will write this for you, we would all be out of a job if it was tht easy.

Additionaly your 'expected end' error indicated you have not closed out an if or a loop or the like. Is your SQL statement on line 68? I believe your problem is above the statement you have posted.

Wind is your friend
Matt

I agree with matt here and, by and large, most web hosts do NOT store websites on the C:\ drive since this is the default system drive. (If you can exploit the server and the site is on the C drive it potentially allows you access system files and the like)

Regarding CDONTS, why bother downloading it? CDOSYS works just as well and does the same thing, there is no need to be plugging over CDONTS especially when it isnt even installed on the server.

In so far as your Syntax, almost every Database server out there provides some tool to edit Syntax and is color coded as Matt said.
(MySQL has Query Browser, MS SQL has Query Analyzer, etc etc etc)
If your having a problem with your syntax, place it in one of these tools to nail down your problem.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

...I have now read through this topic and I will limit my posting to the upload-affair.

I have;

      File.SaveToDisk "C:/Inetpub/wwwroot/Ny mappe/brukerfotos/"

and

      MyConn4.Execute "UPDATE Produkt SET ProduktBilde = '" &
      File.FileName & "' WHERE ProduktNavn = '" & session("Navn")
      & "'"

and for displaying the image;

      ...<td width="100"><img src="brukerfotos/<%=trim(Objrs1
      ("ProduktBilde"))%>"></td>...

There are no error-messages, but the image is not displaying, only the common square with a red cross! Let's assume the image-size is within the limitations of IIS. The images are known to be in the dir; I have seen it!

Mvh
grstad

I use absolute paths myself and believe this is a better option. To do this I define several constants in a global file which is called on every page. EG:

some of my global.asp file contents:

const URLBase = "http://localhost/webSiteRootdirName/"
const DocBase = "http://localhost/webSiteRootdirName/uploaded/"
const IUSER = "someUserName"
const PWORD = "somePassword"
const DBNAME = "myDataBaseName"
const DBSERVER = "myPCName"

This is a good practice for many reasons, here are a couple:
1 - IUSER, PWORD, DBNAME and the DBSEVER constants are for my connection string. Once change in one file allows us a global change to my connection string.

2 - URLBase. I use this for all my paths in anchor tags, image tags etc for the same reasons as above. EG:
<a href="<%= URLBase %>admin/somePageName.asp">

Which means you use the DOCBase in the path for your images. EG:
<img src="<%= DocBase %>specials/<%= trim(getInfo(5)) %>"

So if your DOCBase was:
const DocBase = "http://localhost/Ny mappe/brukerfotos/" (why do you have a space? get rid of it)
You would render your image like so:
<img src="<%= DocBase & trim(Objrs1("ProduktBilde")) %>">

Or you could take the easy way out and use a relative path:
<img src="/Ny mappe/brukerfotos/<%= trim(getInfo(3)) %>"

Notice the leading forward slash. Do you make it a hibbit of placing spaces in your dir names for web sites? Why make things harder for your self...

BTW: If you need to ask a new question within an existing post which is not logical according to the title of the post, think about starting a new one - It helps others find answers. You have some useful replies in this post others could benefit from, however they would never expect them based on the post's title.

Wind is your friend
Matt