Re: How to do path with spaces
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sat, 20 Mar 2010 23:29:23 +1100
Message-ID: <ho2eq3$8kh$2_at_news.eternal-september.org>
sjsean wrote,on my timestamp of 20/03/2010 9:04 AM:
> I've been given a script with two variable spots for a path. However,
> the path I would like to use includes spaces. Can someone advise how
> I could do this using below as my example? If I take all spaces out
> then the update in my database occurs...but with spaces it does not.
>
> define control_file_path = C:\Documents and Settings\something
> \Desktop\this folder
>
> but if I do:
>
> define control_file_path = C:thisfolder
>
> it will work. thanks!
Date: Sat, 20 Mar 2010 23:29:23 +1100
Message-ID: <ho2eq3$8kh$2_at_news.eternal-september.org>
sjsean wrote,on my timestamp of 20/03/2010 9:04 AM:
> I've been given a script with two variable spots for a path. However,
> the path I would like to use includes spaces. Can someone advise how
> I could do this using below as my example? If I take all spaces out
> then the update in my database occurs...but with spaces it does not.
>
> define control_file_path = C:\Documents and Settings\something
> \Desktop\this folder
>
> but if I do:
>
> define control_file_path = C:thisfolder
>
> it will work. thanks!
from a vague memory, I think you need to put "s around the terms with spaces.
with your example above, like this:
define control_file_path = C:\"Documents and Settings"\something\Desktop\"this
folder"
HTH
Received on Sat Mar 20 2010 - 07:29:23 CDT