Re: update hyperlink through query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello again x-rays,
I tried it with double quotes first but someone told me single quotes
were more common in SQL. That's why I tried changing it. However both
ways, unfotunately, gave the same error message.

/Maria

PS. No worries... My name's common all over the world.

x-rays skrev:

Hello Maria,

I don't see how is that possible to fail either, eclose strings with
double quotes instead of single and tell me if works this way.

PS: oh ok, sorry for asking.


Maria wrote:
Hello x-ray,

Thankyou so much for the help. I thought your solution looked
absolutely perfect however I got an error message saying somehing like
"the expression contains a function with the wrong number of
arguments." I tried to look inte the help to understand this but I
couldn't see anything wrong.

Here's my new line of code:

UPDATE Bildoriginal
SET Bildfil = Replace(Bildfil, 'K:\', '\\Avantgrp\gemensam2\')

/Maria

Ps. No I'm not greek. I'm Swedish....


x-rays wrote:
Hello Maria,

I think you need something like that:

Lets say that the value of your column (in that case Field1) of a row
is "D:\Avant\blabla"

UPDATE YourTable
SET Field1 = Replace(Field1, "D:\", "C:\")

Now your value is C:\Avant\blabla

Is this works for you?

PS: are you greek?

Maria wrote:
Hello again,

I think I might be on may way to the answer but I would still need some
help:

I realize that my query has to look something like this

UPDATE MyTable
SET Bildoriginal = (Bildoriginal - "K:\Avant Structure\Avant
Intellectual Capital AIC\Produkt\Symboler\Bildoriginal\)" &
("#\\Avantgrp\gemensam2\Avant Structure\Avant Intellectual Capital
AIC\Produkt\Symboler\Bildoriginal\" & Bildoriginal)

although not quite like this at all.

/Maria


Maria wrote:
Hi,
I have created a table in a database that contains hyperlinks pointing
to various documents, all in the same folder but for some reason the
hyperlinks wouldn't work correctly unless I put the direct address in
the hyperlink.

Now the location of the document folder has changed and I need to
update the hyperlink addresses but I can't quite figure out how to do
that. I'm quite new to this... The filed shows the fliename. I need to
keep the filename and both in the visible field and at the end of the
adress but I ned to change the part of the address that points into the
folder. It's a few hundred files so it's not appealing having to do
this manualy and I'm sure it could be done through a query.

I would be very thankful for all directions.

/Maria

.

Relevant Pages

  • Re: How to quote multiple parts in direct speech?
    ... single quotes, ... American linguists use the single quotes for glosses. ... le quotation marks: a closing quotation mark then looks exactly the ... Alice said, "Wait, I'm followin' too!" ...
    (alt.usage.english)
  • Re: PHP scripts and IE
    ... > But it saves you having to think of whether to use single quotes or not. ... Single quotes mean that the content will be printed as-is. ... Thus single quoted strings are processed faster. ... would be the best solution IMO (although you might want to make it ...
    (alt.php)
  • Re: User dsquery to obtain lanid, name for all users in the domain.
    ... in quotes, it doesn't' hurt. ... valid characters in the Common Name. ... One problem character appears to be the quote, ...
    (microsoft.public.windows.server.active_directory)
  • Re: nesting JS in echos
    ... converted from html to php. ... syntax of the single quotes and double quotes needed in the ...
    (comp.lang.php)
  • Re: br html line breaks and htmlentitities
    ... when reading user-supplied input I use 'addslashes' ... display, and so single quotes are not visually escaped, ...
    (comp.lang.php)