| Author |
Problem with parameters in SQL commands on ASPs
|
|
| Jonathan Blitz 2004-09-22, 9:49 pm |
| I seem to be having a major problem with my site.
I have many asps which are invoked from another page and receive input
values for the SQL command either from the request or from session
variables.
These are then included in the SQL statements using ::xxx::
They are all failing with SQL error but no details of the error.
If I remove the parameters then all is ok.
What has happened?
--
Jonathan Blitz
AnyKey Limited
Israel
Tel: (972) 8 9790365
"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
| |
| Kathleen Anderson [MVP - FrontPage] 2004-09-22, 9:49 pm |
| Jonathan:
What version of FrontPage? Are you using the FrontPage Database Results
Wizard to create the .asp pages?
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Jonathan Blitz <((jb))@anykey.co.il (remove brackets)> wrote:
> I seem to be having a major problem with my site.
>
> I have many asps which are invoked from another page and receive input
> values for the SQL command either from the request or from session
> variables.
>
> These are then included in the SQL statements using ::xxx::
>
> They are all failing with SQL error but no details of the error.
>
> If I remove the parameters then all is ok.
>
> What has happened?
| |
| Jonathan Blitz 2004-09-22, 9:49 pm |
| Oops - should have stated that.
FP version 2002 SP3.
I am using the Wizard.
A few extra notes (that I should have put in to start with):
1. The "source" and "target" asp are not the same one.
2. I am not invoking by using the target form as the action on the source
form. I am using "onclick" in one case and "href=" in the other.
3. The source and target as in differant frames.
The problem could be in any of these but it all worked ok until 2 days ago.
Now it suddenly stopped working.
It occurs on our actual server. To check it I also downloaded it to my
computer (which is a 2000 server in itself) and ran it there. It also fails.
The only thing I can think that I have changed on my computer recently is
that I have installed Office update.
--
Jonathan Blitz
AnyKey Limited
Israel
Tel: (972) 8 9790365
"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
message news:%23aPrH78nEHA.592@TK2MSFTNGP11.phx.gbl...
> Jonathan:
> What version of FrontPage? Are you using the FrontPage Database Results
> Wizard to create the .asp pages?
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Jonathan Blitz <((jb))@anykey.co.il (remove brackets)> wrote:
>
|
|
|
|