Pep Johnsonn
|
| Posted: 12/01/2004, 2:37 AM |
|
Hello guys, I am using CCstudio (latest) with access and asp.
I have a working page uploaded to the web with a previous version of CCS.
Now, some months later, I want to edit the site in CCS, with the new version
installed.
I have a link in one page
http://localhost/matrici/FMTRProducts.asp?category_id=&s_keyword=Tórica
Roscada
where this points to a grid populated from access db, where the keyword are
Tórica and Roscada (two hardware tool clasifications, in spanish)
This works ok in the page I have online (the old one), but once the project
is "reloaded" in the new version of CCS, I have to save all the common
files...etc, and republish it.
Then, I have this error:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be
displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the localhost home page, and then look for links to the information you
want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Connection.EscapeChars'
/matrici/Classes.asp, line 367
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:
GET /matrici/FMPLANProducts.asp
Time:
Wednesday, December 01, 2004, 11:22:27 AM
More information:
Microsoft Support
The only thing that I have changed, apart from the changes that CCS does
"automatically" when the project is "updated" to the newest version, are:
- change the connection path (not the name)
-change the publishing path
These changes are ok, because I can populate all kinds of grids, login,
....etc.
What is wrong with EscapeChars???
Any help is welcome, as I am very stuck with this....
Thanks
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 12/01/2004, 2:47 AM |
|
This looks to me like you might've manually modify Common.asp in the past, (possibly the connection section) therefore it is not re-generated properly.
Try deleting Common.asp from your project, then press F9 to regenerate and republish everything.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Pep Johnsonn
|
| Posted: 12/01/2004, 3:51 AM |
|
Thanks, I have tried that with the same result...the error comes from
classes.asp, as it says in the error message, doesn´t it?
Thanks for your help
|
|
|
|
Pep Johnsonn
|
| Posted: 12/01/2004, 4:30 AM |
|
Hello again, I have downloaded the classes.asp from the web (works ok) and
it does not have inside anything like "escapechars" while the classes.asp of
the new project has it.
How is that possible? does ccs put it automatically?
new classes.asp below
---
Result = CCFormatNumber(Value, MaskFormat)
Case ccsText, ccsMemo
Result = CStr(Value)
If CStr(Result) <> "" Then Result = Connection.EscapeChars(Result)
End Select
GetFormattedValue = Result
End Function
----
old (working) classes.asp below
----
Result = CCFormatNumber(Value, MaskFormat)
Case ccsText, ccsMemo
Result = CStr(Value)
If CStr(Result) <> "" Then Result = Replace(Result, "'", "''")
End Select
GetFormattedValue = Result
End Function
------
and I have not changed anything, I think...
Thanks
|
|
|
|
Pep Johnsonn
|
| Posted: 12/01/2004, 7:34 AM |
|
Hello Again!!
Well, I have found out that CCS automatically adds some lines of code as I
just open the document in the new version.
Please, people from CodeCharge, do you know if there is a workaround on
this? This "If CStr(Result) <> "" Then Result =
Connection.EscapeChars(Result)" makes the page not to work.
There is no way I can avoid saving the new common files...
Heeeeeeeeeeeellllllpppppp !!!!!!!
Thanks
|
|
|
|
DonB
|
| Posted: 12/01/2004, 9:14 AM |
|
From version 2.2 to 2.3, there was a change, "Replace()" function changing
to "EscapeChars()" method in the Connection class.
You may be having trouble because you (a) are running CCS v 2.2 with a newer
version of the Common files or (b) have not republished your project
completely after upgrading to v 2.3.
Since you say "CCS automatically adds some lines", I suppose you are in
situation (b).
--
DonB
http://www.gotodon.com/ccbth
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/01/2004, 12:15 PM |
|
Try deleteing Classes.asp and all other common files as well, then regenerate and republish them.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 12/01/2004, 12:38 PM |
|
BTW, if this is true:
Quote :This "If CStr(Result) <> "" Then Result = Connection.EscapeChars(Result)" makes the page not to work.
then likely some of your Web pages were manually modified and they cannot be re-generated properly. Usually such modifications can prevent you from upgrading.
Please backup your project, delete all your .asp files except the *_events.asp, then press F9 to regenerate everything.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Pep Johnsonn
|
| Posted: 12/02/2004, 1:21 PM |
|
Thanks Peter, DonB and everyone!!
I deleted the files except the *events and regenerated the project. Tested
in IIS and works ok!!!!
I would have NEVER dare to delete any of those files by myself, I thought
they were not automatically generated by CCS.
Thanks again, chalk up an A !!!!
Regards
"peterr" <peterr@forum.codecharge> wrote in message
news:641ae2bded0237@news.codecharge.com...
> BTW, if this is true:
> Quote :This "If CStr(Result) <> "" Then Result =
> Connection.EscapeChars(Result)" makes the page not to work.
>
>
> then likely some of your Web pages were manually modified and they cannot
> be
> re-generated properly. Usually such modifications can prevent you from
> upgrading properly.
> Please backup your project, delete all your .asp files except the
> *_events.asp,
> then press F9 to regenerate everything.
> _________________
> Peter R.
> YesSoftware Support Representative
> http://support.yessoftware.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
>
|
|
|
|
|
