Printing 11x17 Reports
I am tasked with converting to ColdFusion a set of reports currently produced in MS Access. These report needs to be printed on 11 x 17 paper with headers, footers and other features that a web browser doesn't do. What product can I use, and where do I begin? Please explain everything, assume I know nothing other than how to use ColdFusion. Thanks, Joy ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 4.01 Keeps Crashing
ColdFusion 4.01 has started crashing on my development machine several times a day, producing the following message: CFSERVER caused an invalid page fault in module MSRD3X40.DLL I reinstalled CF but that didn't solve the problem. Can anyone help me figure out what is broken and how to fix it? I am running Win 98 SE, 256 MB Ram, PIII-650, Access 97. TIA, Joy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTML Form Submit button troubles
Chris, Leave out "NAME="SubmitForm" in your INPUT TYPE="submit" tag. Or, better yet, don't use CFINSERT at all... write your own CFQUERY to add records to the database. Joy At 04:40 PM 4/11/00 +0100, you wrote: Hi I'm new to ColdFusion and although I'm finding it generally easy going I'm having some troubles using CFINSERT to populate an Access database table. The trouble is that ColdFusion seems to be interpreting my Submit button as another form field in which it should be entering a value in the database table. Since I don't have a column in my database called 'SubmitForm' I'm getting the following error: Field name not found in the specified table. Table = 'DETAILS' Field = 'SUBMITFORM' The error occurred while processing an element with a general identifier of (CFINSERT). When I create a column for the sumbit button the actionpage works just fine. Does anyone know what I'm doing wrong? Chris Spencer Chris Spencer Learning Support Technician Cheltenham Gloucester College of H.E Pallas Villa, Park Campus Cheltenham, UK 01242 532967. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What goes on the faster machine?
--=_4750==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Michael, Thank you for taking the time to write such a helpful response. Based on what you said, I think we should put SQL Server on the new machine, but take 128 megs of memory from the current machine and put it in the new one. We have only a handful of people who access the website, but we have some rather large tables that I join together and loop through the results, grouping and calculating. NEW MACHINE: - Dual Pentium MB, PIII 600's - 128 PC 100 SDRAM - 8.4 Western Digital Hard drive - 10\100 Mbps, 3COM PCI NIC CURRENT MACHINE: - Dual Pentium MB, PII 300's - 256 PC 100 SDRAM - 8.4 Western Digital Hard drive - 10\100 Mbps, 3COM PCI NIC I'm not real sure where to draw the line between what gets processed by the database and what gets processed by ColdFusion. Tell me if I have this correct: Whatever I put in a CFQUERY will be performed by the the database; calculations that I put in CFSET will be performed by CF, along with any other CF processes like CFLOOP and CFOUTPUT. So, if I have aggregate functions being calculated in a CFQUERY, that's the database doing it; if I have CFOUTPUT GROUP=fieldname, that's CF doing it. Is this correct? Thanks, Joy At 10:39 PM 4/8/00 -0700, you wrote: A lot depends on how hard you flex your database. If you're doing complex queries, stored procedures, triggers and such, I'd put SQL on the faster machine. Web serving is fairly I/O intensive, but not extremely processor intensive unless you're doing some serious calculations in your templates. What is definite is that the SQL server will want more memory. The more you give it, the better it will perform. Overall, web apps are not horribly processor intensive. If you have plenty of memory, and fast disk systems (Ultra-Wide SCSI with hardware RAID 5 controllers that have lots of cache), it will perform quite well, even with older, slower processors. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message----- From: Joy Bedell [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 08, 2000 20:31 To: [EMAIL PROTECTED] Subject: What goes on the faster machine? We are finally making the move from Access to SQL Server. Right now we have both Access and ColdFusion running on the same machine. However, with our upgrade we are going to put SQL Server on one machine and ColdFusion on another. My question is, which one should go on the faster machine, CF or SQL Server? Any other advice anyone would care to offer would be appreciated. Thanks. Joy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_4750==_.ALT Content-Type: text/html; charset="us-ascii" html Michael,br br Thank you for taking the time to write such a helpful response.nbsp; Based on what you said, I think we should put SQL Server on the new machine, but take 128 megs of memory from the current machine and put it in the new one.nbsp; We have only a handful of people who access the website, but we have some rather large tables that I join together and loop through the results, grouping and calculating.br br NEW MACHINE: br - Dual Pentium MB, PIII 600's br - 128 PC 100 SDRAM br - 8.4 Western Digital Hard drive br - 10\100 Mbps, 3COM PCI NIC br br CURRENT MACHINE: br - Dual Pentium MB, PII 300's br - 256 PC 100 SDRAM br - 8.4 Western Digital Hard drive br - 10\100 Mbps, 3COM PCI NIC br br I'm not real sure where to draw the line between what gets processed by the database and what gets processed by ColdFusion.nbsp; Tell me if I have this correct:nbsp; Whatever I put in a CFQUERY will be performed by the the database; calculations that I put in CFSET will be performed by CF, along with any other CF processes like CFLOOP and CFOUTPUT.nbsp;nbsp; So, if I have aggregate functions being calculated in a CFQUERY, that's the database doing it; if I have CFOUTPUT GROUP=fieldname, that's CF doing it.nbsp; Is this correct?br br Thanks,br br Joybr br At 10:39 PM 4/8/00 -0700, you wrote:br blockquote type=cite citeA lot depends on how hard you flex your database. If you're doing complexbr queries, stored procedures, triggers and such, I'd put SQL on the fasterbr machine. Web serving is fairly I/O intensive, but not extremely processorbr intensive unless you're doing some serious calculations
Re: Cf-mail formatting
Ian, You can nest CFOUTPUT for queries this way: Don't specify the query name in any CFOUTPUT except the outermost one. Use the GROUP attribute in all the CFOUTPUTs except the innermost one. Here is one way to do it, grouping by the orderID field (or any field that has the same value for every record returned by your query) Joy CFMAIL TO="#Client.email#" FROM="[EMAIL PROTECTED]" SUBJECT="Your latest Order" THIS SITE IS NOT LIVE. THE ORDER YOU PLACED WILL NOT BE PROCESSED. CFOUTPUT QUERY="getCompleteOrder" GROUP="orderID" Order No. #orderID#: Item Qty Net Price --- CFOUTPUT #LJustify(Title, 40)# #RJustify(itemQuantity, 3)# #RJustify(NumberFormat((itemPrice * itemQuantity), "999,999.99"), 6)# /CFOUTPUT Subtotal: #netCost# Tax: #tax# Shipping: #shipping# - Total: #total# /CFOUTPUT /CFMAIL At 06:55 AM 4/9/00 -0700, you wrote: Thanks for the suggestions. Here is what happens: If I put the Query attribute in the CFOUTPUT tag and remove it completely from CFMAIL, I get an error message that I am nesting queries which I can't do because only the top level can specify the query name. Since I am not even using the query attribute in CFMAIL this doesn't make sense. If I put the query attribute in a CFLOOP tag I get an error message that I have tried to use CFOUTPUT without a query attribute. Ian CFMAIL TO="#Client.email#" FROM="[EMAIL PROTECTED]" SUBJECT="Your latest Order" THIS SITE IS NOT LIVE. THE ORDER YOU PLACED WILL NOT BE PROCESSED. CFLOOP QUERY="getCompleteOrder" CFOUTPUT QUERY="getCompleteOrder" Item Qty Net Price --- #LJustify(Title, 40)# #RJustify(itemQuantity, 3)# #RJustify(NumberFormat((itemPrice * itemQuantity), "999,999.99"), 6)# /CFOUTPUT /CFLOOP CFOUTPUT Subtotal: #getCompleteOrder.netCost# Tax: #getCompleteOrder.tax# Shipping: #getCompleteOrder.shipping# - Total:#total# /CFOUTPUT /CFMAIL Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Cf-Mail formatting
Ian, Sorry, I misunderstood what the problem was. Remove the CFOUTPUT tags altogether from within the CFMAIL tag, as below. Joy CFMAIL TO="#Client.email#" FROM="[EMAIL PROTECTED]" SUBJECT="Your latest Order" THIS SITE IS NOT LIVE. THE ORDER YOU PLACED WILL NOT BE PROCESSED. CFLOOP QUERY="getCompleteOrder" Item Qty Net Price --- #LJustify(Title, 40)# #RJustify(itemQuantity, 3)# #RJustify(NumberFormat((itemPrice * itemQuantity), "999,999.99"), 6)# /CFLOOP Subtotal: #getCompleteOrder.netCost# Tax: #getCompleteOrder.tax# Shipping: #getCompleteOrder.shipping# - Total: #total# /CFMAIL At 05:09 PM 4/9/00 -0700, you wrote: Thanks for the advice Joy. However, I am still having the same problem. Even though I don't have Query= in the CFMAIL tag, I am getting an error saying that a CFMAIL tag which contains a Query attribute cannot contain a CFOUTPUT tag which also contains a QUERY attribute. This is getting absurd. Surely someone has used CFMAIL to send order receipts to customers? Ian Get your own FREE, personal Netscape WebMail account today at http://webmail.netscape.com. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
What goes on the faster machine?
We are finally making the move from Access to SQL Server. Right now we have both Access and ColdFusion running on the same machine. However, with our upgrade we are going to put SQL Server on one machine and ColdFusion on another. My question is, which one should go on the faster machine, CF or SQL Server? Any other advice anyone would care to offer would be appreciated. Thanks. Joy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.