Problem with DA Wizard
When i use DA Wizard and set my result page with filter
FORM PARAMETER the page give me NO RESULTS but
if i try to test my recordset in DW it give me some results
i don't understand what's the problem please help me
I use DA 2.0.8 - DWCS5 - XP PRO SP3
This is the results page URL
"rdm/fatture_Results.asp?S_ID_fornitore=2&Search.x=44&Search.y=11&Search=Search"
and code generate recordset
<%
Dim WADAfatture__GF_IDFornitore
WADAfatture__GF_IDFornitore = "-1"
If (request.form("ID_Fornitore") <> "") Then
WADAfatture__GF_IDFornitore = request.form("ID_Fornitore")
End If
%>
<%
Dim WADAfatture
Dim WADAfatture_cmd
Dim WADAfatture_numRows
Set WADAfatture_cmd = Server.CreateObject ("ADODB.Command")
WADAfatture_cmd.ActiveConnection = MM_RDM_STRING
WADAfatture_cmd.CommandText = "SELECT ID_fornitore, numerofatt FROM fatture WHERE ID_fornitore=?"
WADAfatture_cmd.Prepared = true
WADAfatture_cmd.Parameters.Append WADAfatture_cmd.CreateParameter("param1", 5, 1, -1, WADAfatture__GF_IDFornitore) ' adDouble
setQueryBuilderSource WADAfatture_cmd, WADbSearch1_whereClause, false
Set WADAfatture = WADAfatture_cmd.Execute
WADAfatture_numRows = 0
%>
bye Giaino