Hello Everyone,
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])
%>
Thanks in advance.
James C. Baxter
Graphic Technology Specialist,
Clemson Graphic Communications Hub,
International Paper.
Email: [EMAIL PROTECTED]
Telephone: 864-633-6015
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
