Hallo ihr alle, SEHR DRINGEND!!!!
wer kann mir bitte schnell helfen?? Bitte helft mir... WER KANN DAS???????
LG
gebe euch meine private e-mail manowhe@web.de oder manowhe@yahoo.de
<h3>Transaction Reports</h3>--------------------------------------------This is where my problem is, how I get the select query statement to work in my purchase_report page to get the report from my Database----
<form action="purchase_report.cfm" method="post">
StartYear
<Select name="StartYear" size="1">
<option value="0" selected>All</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
</select>
<select name="StartMonth" size="1">
<cfloop index="idx" from="1" to="12"><cfoutput><option value="#idx#">#MonthAsString(idx)#</option></cfoutput></cfloop>
</select>
<select name="txtStartDay" size="1">
<cfloop index="idx" from="1" to="31"><cfoutput><option value="#idx#">#idx#</option></cfoutput></cfloop>
</select>
EndYear:
<select name="EndYear" size="1">
<option value="0" selected>All</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
</select>
EndMonth
<select name="EndMonth" size="1">
<cfloop index="idx" from="1" to="12"><cfoutput><option value="#idx#">#MonthAsString(idx)#</option></cfoutput></cfloop>
</select>
<select name="txtEndDay" size="1">
<cfloop index="idx" from="1" to="31"><cfoutput><option value="#idx#">#idx#</option></cfoutput></cfloop>
</select>
Create Transaction Report 
<select name="customers" size="1">
<option value="0">Select Supplier</option>
<cfoutput query="Getcustomers"><option value="#Getcustomers.customersCode#">#qryGetcustomers.customersName#</option></cfoutput>
</select>
<input type="submit" name="btnR" value="Go" />
</form>
</body>
</html>
Action Page
<!---Transaction start here--->--------------------------------The coding starts here, I really don't now what I'm doing wrong, I have no idea how to get a report with a date selection from the admin form--
<cftransaction action="begin">
<!--- get list of Purchase Order --->
<cfquery name="Getcustomers" datasource="report">
SELECT PurchaseOrderID,SupplierName,PlannedDelivery,PurchaseDate,Description,PurchaseLineID,COUNT(Quantity) AS Count_Quantity
From Suppliers, PurchaseOrders, PurchaseLines
Where PurchaseOrderIDfk = PurchaseLineID
AND (PurchaseDate BETWEEN '#FORM.StartYear#' AND '#FORM.EndYear#')
AND (SupplierName ='#FORM.customers#')
GROUP BY PurchaseOrderIDfk
ORDER BY PurchaseDate
</cfquery>
</cftransaction>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Purchase Order</title>
<link rel="STYLESHEET" type="text/css" href="abpans.css" />
</head>
<body>
<cfif qryGetSuppliers.RecordCount IS 0>
<h3>No matches found</h3>
<cfelse>
<h3>Guest Search Result</h3>
<ul>
<cfoutput query="qryGetSuppliers">
<li>
<b>Purchase ID:</b> #PurchaseOrderID#</li>
<li><b>Supplier Name:</b> #SupplierName#</li>
<li><b>Planned Delivery:</b> #PlannedDelivery#</li>
<li><b>Description:</b> #Description#</li>
<li><b>Quantity Count:</b> #Count_Quantity#</li>
<li><b>Purchase Date:</b> #PurchaseDate#</li>
</cfoutput>
</ul>
</cfif>
</div>
</body>
</html>
Danke
