Hei!
Can anyone type in the right syntax on this one for me;

MyConn4.Execute "UPDATE Produkt SET ProduktBilde = '" & <img src = C:/Documents and Settings/a/b/c/d/ '" & '" & File.FileName & '" WHERE ProduktNavn = '" & session("Navn") & "'"

Thanks a lot!

Mvh
grstad

__________________
Internet has become favorable with that tool...thank you Tim Berners-Lee!

  It looks like you're just missing some quotes.
You needed the apostrophes in double quotes or the code thinks you remarked half of the line.
Try this.

MyConn4.Execute "UPDATE Produkt SET ProduktBilde = "'" & <img src = C:/Documents and Settings/a/b/c/d/ "'" & "'" & File.FileName & "'" WHERE ProduktNavn = "'" & session("Navn") & "'"

..thank you for your reply to my inquiry, chucky. I'll try the sql as next ting this morning. Is there any "roules in hand" regarding the use of ' and " in an sql-sentence?

Mvh
grstad :)

...no, there is still syntax-err;

MyConn4.Execute "UPDATE Produkt SET ProduktBilde = "'" & <img src = C:/Documents and Settings/WebMaster/Mine dokumenter/Ny mappe/brukerfotos/ "'" & "'" & File.FileName & "'" & "'" > "'" WHERE ProduktNavn = "'" & session("Navn") & "'"


...but I have added an "'" > "'" before the WHERE!

Mvh
grstad :)

hi there..

after reading your sql string several times i realize something.. I don't know what are you trying to achieve!!!

please... if you are so kind, paste an example of the final sql and maybe we can help you better...

The problem I have is with the set clause.. you are trying to put that field equal to..????

and after you add the > you finish confusing me...

HTH

Gonzalo

================================================== =========
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 dparsons signature and he Took that from planoie's profile
================================================== =========

  I kinda see what he's trying to do;
grstad,
I was in a hurry and put a few quotes in the wrong place as well, try this:

MyConn4.Execute "UPDATE Produkt SET ProduktBilde = '<img src = C:/Documents and Settings/WebMaster/Mine dokumenter/Ny mappe/brukerfotos/" & File.FileName & "' WHERE ProduktNavn = '" & session("Navn") & "'"

By the way, this looks like you might be coding in ASP, I would highly recommend you get PrimalScript or some debugging tool, because all your problem was is putting the quotes in the proper place.

If this doesn't work then you will need to do like gbianchi says and give us some more details on what you are trying to accomplish.

in that case.. you have the > missing ;)

... & File.FileName & ">' WHERE....

HTH

Gonzalo

================================================== =========
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 dparsons signature and he Took that from planoie's profile
================================================== =========

...yes it is all aboat putting the quotes in the right place. I try to update my recordfield setting it equal;

<img src="c:/dir_a/dir_b/image_name.gif">

I am so grateful for your attention. By the way; are there any roules for me to follow concerning these quotes? What are the logic?

I will try your suggestion first ting this evening!

Mvh
grstad :)

mm.. how to put quotes is standard SQL.. every string (fixed text) has to be rounded by them...



HTH

Gonzalo

================================================== =========
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 dparsons signature and he Took that from planoie's profile
================================================== =========

...it went ok, exept from the last ">" did not show up in the db-field. The field should be;

<img src = "C:/some_dir/some_dir/some_photo.gif" height = "125" width = "100">

The quotes...yes, the fixed text. And the & binding parts together? And a " followed by a " is wrong; that is why it'll be '" or "' ?

MVH
grstad :)