Blank space in Folder Name causes web service error

Hello,
When I try to pull a report via the RS web service from a folder
with a space in the name (i.e. "My Folder"), an error stating the
report cannot be found is thrown. If I rename the folder to "MyFolder"
then it works fine. I tried using %20 instead of the space in the path
setting but this does not work. Is there a way to allow having a space
in the folder name? We have many folders and need the ability to name
them with multiple words seperated by spaces.
Thank youTry using a '+' in place of spaces
ie. My+Folder
On Aug 22, 11:19 am, daves...@.hotmail.com wrote:
> Hello,
> When I try to pull a report via the RS web service from a folder
> with a space in the name (i.e. "My Folder"), an error stating the
> report cannot be found is thrown. If I rename the folder to "MyFolder"
> then it works fine. I tried using %20 instead of the space in the path
> setting but this does not work. Is there a way to allow having a space
> in the folder name? We have many folders and need the ability to name
> them with multiple words seperated by spaces.
> Thank you|||On Aug 23, 10:01 am, Jen <jlan...@.gmail.com> wrote:
> Try using a '+' in place of spaces
> ie. My+Folder
> On Aug 22, 11:19 am, daves...@.hotmail.com wrote:
>
> > Hello,
> > When I try to pull a report via the RS web service from a folder
> > with a space in the name (i.e. "My Folder"), an error stating the
> > report cannot be found is thrown. If I rename the folder to "MyFolder"
> > then it works fine. I tried using %20 instead of the space in the path
> > setting but this does not work. Is there a way to allow having a space
> > in the folder name? We have many folders and need the ability to name
> > them with multiple words seperated by spaces.
> > Thank you- Hide quoted text -
> - Show quoted text -
We tried using a + instead of space but still no joy.

Bit column in FoxPro GUI

I have to pull data from a SQL app for a WIN-Form app in .NET, where data is
stored in FoxPro. Seems that the bit data type is not casting properly
through the ODBC driver back to FoxPro'
Any way to cast or convert a bit column? When I did case when IsPrint = 0
then ' 0' else '1' end IsPrint but that barfed?
Any ideas?How about CAST(bitcol AS int)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Stephen Russell" <srussell@.lotmate.com> wrote in message
news:%23bEzNe6DFHA.328@.tk2msftngp13.phx.gbl...
>I have to pull data from a SQL app for a WIN-Form app in .NET, where data i
s
> stored in FoxPro. Seems that the bit data type is not casting properly
> through the ODBC driver back to FoxPro'
> Any way to cast or convert a bit column? When I did case when IsPrint = 0
> then ' 0' else '1' end IsPrint but that barfed?
> Any ideas?
>
>|||"Stephen Russell" <srussell@.lotmate.com> wrote in message
news:%23bEzNe6DFHA.328@.tk2msftngp13.phx.gbl...
> I have to pull data from a SQL app for a WIN-Form app in .NET, where data
is
> stored in FoxPro. Seems that the bit data type is not casting properly
> through the ODBC driver back to FoxPro'
cast (ap_noprint as int) ap_noprint
Worked fine.