James,
Try deleting the first "unload record".
Pip pip
David Wright
On 5 Jun 2006, at 17:48, James C Baxter wrote:
Sorry to bug you with I know is a simple beginners question. I am
trying to
query a table using the following logic. I get no results, however the
data
is in the records to result in a match. If I use the same code with
only 1
search variable (either searching for fedex or the ticket number) I get
matches. Any advice. Below is the code, temp ID in this case is a 6
digit
number.
<%
read only([PackingSlip])
QUERY([PackingSlip];[PackingSlip]TicketID= num($temp_id);*)
QUERY([PackingSlip]; & ; [PackingSlip]Ship_Via= "Fedex")
order by([PackingSlip];[PackingSlip]ID;<)
unload record([PackingSlip])
for($j; 1; records in selection ([PackingSlip]))
goto selected record([PackingSlip]; $j)
%>
<% write([PackingSlip]Ship_Date) %> <BR>
<% end for
unload record([PackingSlip])
%>
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
