DWCS6 [for] made a recordset query (fuzzy query), after open in web search box input "history" to display the correct content, but if the input "physical" jump out to 500 - internal server problem, what reason is this excuse me?
I am using DW connection access database, use the server behavior in the recordset (query) advanced Settings, in SQL code is:
Select *
The FROM km
WHERE [college code]=YXDM the OR... OR [preferred course demand]=SXKMYQ
Is the preferred course demand here we have a problem, the search physics has been an error,
Variable SXKMYQ is set values for the request. The form (the search text field ID), the default value of 1

Have bosses know what is going wrong, clearly is fine with my other search box, or a database where I wrong?

CodePudding user response:

The preferred course demand this field is string type or value type?

SXKMYQ variable is set values for the request. The form (the search text field ID), the default value of 1
It is ID, should be a numerical value, so you come through physical two words

CodePudding user response:

The

reference 1/f, February 16 response:

preferred course demand this field is string type or value type?

SXKMYQ variable is set values for the request. The form (the search text field ID), the default value of 1
It is ID, should be a numerical value, and so you physical two words not

request. The form in the parentheses () is the name of the TEXT field, is the specific request. The form (SXKM), SXKM is TEXT domain name word, as to the preferred subjects asked me to set in the database is short TEXT, variable SXKMYQ is set to return to the TEXT

CodePudding user response:

And I search "history" clearly what all have no, wrong can search out???

CodePudding user response:

reference weixin_45751301 reply: 3/f

and I search "history" clearly what all have no, wrong can search out???

Print of the generated SQL statements, and then in the database

CodePudding user response:

<%
Dim Recordset1_MMColParam
Recordset1_MMColParam="1"
If (Request Form (" SXKM ") & lt;> "") Then
Recordset1_MMColParam=Request Form (" SXKM ")
End the If
%>
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd=Server. CreateObject (" mand "ADODB.Com
Recordset1_cmd. ActiveConnection=MM_shujuku_STRING
Recordset1_cmd.Com mandText="SELECT * FROM km WHERE [the preferred course demand]=?"
Recordset1_cmd. Prepared=true
Recordset1_cmd. The Parameters. Append Recordset1_cmd. CreatParameter (" paramo, "200,1,255, Recordset1_MMColParam) 'adVarChar

The Set Recordset1=Recordset1_cmd. Execute
Recordset1_numRows=0
%>

CodePudding user response:

reference 5 floor weixin_45751301 reply:

& lt; %
Dim Recordset1_MMColParam
Recordset1_MMColParam="1"
If (Request Form (" SXKM ") & lt;> "") Then
Recordset1_MMColParam=Request Form (" SXKM ")
End the If
%>
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd=Server. CreateObject (" mand "ADODB.Com
Recordset1_cmd. ActiveConnection=MM_shujuku_STRING
Recordset1_cmd.Com mandText="SELECT * FROM km WHERE [the preferred course demand]=?"
Recordset1_cmd. Prepared=true
Recordset1_cmd. The Parameters. Append Recordset1_cmd. CreatParameter (" paramo, "200,1,255, Recordset1_MMColParam) 'adVarChar

The Set Recordset1=Recordset1_cmd. Execute
Recordset1_numRows=0
%>

this code is there a problem?

CodePudding user response:

From the empty set?

CodePudding user response:

Finally solved, the last mistake was not in the code is too much data in the database, a problem with the website, thank you for your help so long, really in trouble