xmrchndize
06-05-2007, 10:01 PM
Here it goes....
I have some receipt logs that are written by my POS software. At the same time the log is written there is an entry made in my database (Access) with the path and receipt ID for the entry. The entry in the database for example looks like this; each item is a column in the database.
Trans Number: D2073
Log File: Logs\DRLog032005I.log
Receipt: D38592207362963
The receipt log file that corresponds to this is located in the Logs directory and is file name DRLog032005I.log
Ok now the fun stuff
Here is a clipping from one of my receipt logs this is actually two receipts one of them corresponds to the above mentioned receipt the other is the sequential log entry. As you can see there is a lead in and lead out for each receipt.
What I am trying to do is display a single receipt from the log on a page for the purpose of printing. I already have the database connection established and I know how to get the information from the database to the fields that I need to. What I do not know is how to call in the information from the log files. Any help will be greatly appreciated
Ex. lead in "<RECEIPT>D38592207362963"
Ex. lead out "D38592207362963</RECEIPT>"
<++++++++++++++++++++++++++++++++++++++>
<RECEIPT>D38592207362963
RETURNS, EXCHANGES, AND CREDITS
WARRANTED WITHIN 10 DAYS OF SALE,
AND ONLY IF RECEIPT IS PRESENTED!
THANK YOU!
Transaction#: D2073
CLERK: CORY
Date: 08/28/2005 Time: 08:18:45 AM
Due Date: 09/10/2005
*** SALE ***
Bill To:
Customer # ****
CORY *****
P O BOX ***
GRAY, LA *****
***-***-****
____________________________________
5109WB 6V UTILITY LANTERN
6373518
2.00 EA @ $5.99 T $11.98
074196003077
11863 6 GAL WATER CAN
6559165
2.00 EA @ $10.15 T $20.30
Subtotal: $32.28
4% Louisiana State Tax: $1.29
4.5% Terrebonne Parish Tax: $1.45
TOTAL: $35.02
INVOICE: $35.02
CHANGE: $0.00
(X)__________________________________
Authorized Signature
A Finance Charge of 1.5% per month
applies to all past due invoices
.-----------------------------------.
HOURS = 7-6 M-F, 8-5 SAT, 8-3 SUN
***-***-****
*************** HOUMA, LA *****
D38592207362963</RECEIPT>
<++++++++++++++++++++++++++++++++++++++>
<RECEIPT>D38592208775926
RETURNS, EXCHANGES, AND CREDITS
WARRANTED WITHIN 10 DAYS OF SALE,
AND ONLY IF RECEIPT IS PRESENTED!
THANK YOU!
Transaction#: D2087
CLERK: CODY
Date: 08/28/2005 Time: 10:55:58 AM
Due Date: 09/10/2005
*** SALE ***
Bill To:
Customer # ****
AMERICAN MACHINE & MFG., LLC
P O BOX ****
HOUMA, LA *****
***-***-****
____________________________________
5109WB 6V UTILITY LANTERN
6373518
3.00 EA @ $5.99 T $17.97
074196003077
ONE PRO CELL C BATTERY
PCCB
24.00 EA @ $1.014 T $24.34
Subtotal: $42.31
4% Louisiana State Tax: $1.69
4.5% Terrebonne Parish Tax: $1.90
TOTAL: $45.90
INVOICE: $45.90
CHANGE: $0.00
(X)__________________________________
Authorized Signature
A Finance Charge of 1.5% per month
applies to all past due invoices
.-----------------------------------.
HOURS = 7-6 M-F, 8-5 SAT, 8-3 SUN
***-***-****
***************** HOUMA, LA *****
D38592208775926</RECEIPT>
I have some receipt logs that are written by my POS software. At the same time the log is written there is an entry made in my database (Access) with the path and receipt ID for the entry. The entry in the database for example looks like this; each item is a column in the database.
Trans Number: D2073
Log File: Logs\DRLog032005I.log
Receipt: D38592207362963
The receipt log file that corresponds to this is located in the Logs directory and is file name DRLog032005I.log
Ok now the fun stuff
Here is a clipping from one of my receipt logs this is actually two receipts one of them corresponds to the above mentioned receipt the other is the sequential log entry. As you can see there is a lead in and lead out for each receipt.
What I am trying to do is display a single receipt from the log on a page for the purpose of printing. I already have the database connection established and I know how to get the information from the database to the fields that I need to. What I do not know is how to call in the information from the log files. Any help will be greatly appreciated
Ex. lead in "<RECEIPT>D38592207362963"
Ex. lead out "D38592207362963</RECEIPT>"
<++++++++++++++++++++++++++++++++++++++>
<RECEIPT>D38592207362963
RETURNS, EXCHANGES, AND CREDITS
WARRANTED WITHIN 10 DAYS OF SALE,
AND ONLY IF RECEIPT IS PRESENTED!
THANK YOU!
Transaction#: D2073
CLERK: CORY
Date: 08/28/2005 Time: 08:18:45 AM
Due Date: 09/10/2005
*** SALE ***
Bill To:
Customer # ****
CORY *****
P O BOX ***
GRAY, LA *****
***-***-****
____________________________________
5109WB 6V UTILITY LANTERN
6373518
2.00 EA @ $5.99 T $11.98
074196003077
11863 6 GAL WATER CAN
6559165
2.00 EA @ $10.15 T $20.30
Subtotal: $32.28
4% Louisiana State Tax: $1.29
4.5% Terrebonne Parish Tax: $1.45
TOTAL: $35.02
INVOICE: $35.02
CHANGE: $0.00
(X)__________________________________
Authorized Signature
A Finance Charge of 1.5% per month
applies to all past due invoices
.-----------------------------------.
HOURS = 7-6 M-F, 8-5 SAT, 8-3 SUN
***-***-****
*************** HOUMA, LA *****
D38592207362963</RECEIPT>
<++++++++++++++++++++++++++++++++++++++>
<RECEIPT>D38592208775926
RETURNS, EXCHANGES, AND CREDITS
WARRANTED WITHIN 10 DAYS OF SALE,
AND ONLY IF RECEIPT IS PRESENTED!
THANK YOU!
Transaction#: D2087
CLERK: CODY
Date: 08/28/2005 Time: 10:55:58 AM
Due Date: 09/10/2005
*** SALE ***
Bill To:
Customer # ****
AMERICAN MACHINE & MFG., LLC
P O BOX ****
HOUMA, LA *****
***-***-****
____________________________________
5109WB 6V UTILITY LANTERN
6373518
3.00 EA @ $5.99 T $17.97
074196003077
ONE PRO CELL C BATTERY
PCCB
24.00 EA @ $1.014 T $24.34
Subtotal: $42.31
4% Louisiana State Tax: $1.69
4.5% Terrebonne Parish Tax: $1.90
TOTAL: $45.90
INVOICE: $45.90
CHANGE: $0.00
(X)__________________________________
Authorized Signature
A Finance Charge of 1.5% per month
applies to all past due invoices
.-----------------------------------.
HOURS = 7-6 M-F, 8-5 SAT, 8-3 SUN
***-***-****
***************** HOUMA, LA *****
D38592208775926</RECEIPT>