Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-10 : 08:16:35
|
| Art writes "Through Microsoft FP 2002, I have an asp page that trying to run the following very basic query:SELECT * FROM mminet_fn WHERE (f_docnumber = ::f_docnumber::)I know that the table is OK because I have 40 other queries against the table that work fine and many of them return the field f_docnumber although it is not a searched upon field. In the table f_docnumber is set up as numeric.When this query is run, the following error appears:Database Results ErrorThe operation failed. If this continues, please contact your server administratorIf I change the query to :SELECT * FROM mminet_fn WHERE (f_docnumber = "2004563')the query runs fine. It is only when I add the search feature that the query craps out.Is there some formatting issue in my basic query that I am missing? I have populated the search field with an initial default value and that has had no positive result.I find nothing in FP that says fields with f_ are reserved.Thanks" |
|
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
Posted - 2004-06-10 : 12:32:27
|
| looking at the frontpage code again, your syntax seems fine.maybe no value is being passed and this is causing the crash??see:http://support.microsoft.com/default.aspx?scid=kb;en-us;828905 |
 |
|
|
|
|
|
SQL search form throiugh Front Page