Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by powella

  1. powella

    Performance issue

    Can you be more specific? They are getting a blue screen or what is meant by "goes down"? Are you running 8.0.1? CF 8 has not been out a couple of years so you must have upgraded and you were having problems in 7 too. ... ?
  2. powella

    Sanitizing user input

    HTMLEditFormat() will preserve the brackets and other characters that could be valid in comments (instead of removing them). Just make sure you handle these on the display end too. http://livedocs.adobe.com/coldfusion/8/htmldocs/functions_h-im_04.html And lets not forget the harmful sql code...
  3. powella

    adding line break after x number of characters

    If you want an html break you could add or replace with <br> <cfset lineFeed = "<br />"&chr(13)&chr(10)> ok and if you wanted it every 20 characters change to a mod function and use i <cfscript> for (i=1; i lte len(myString); i=i+1) { if (i mod lineBreakPos eq 0) {...
  4. powella

    debugging cfcs

    That would give you the most control. In our production environment we have all errors emailed to the support group and just dump the error object <cfdump var="#CFCATCH#"> with SQL and other code (line numbers) that are involved.
  5. powella

    one purchase per session?

    I wouldn't take it to mean a literal session (ie CF session). You don't want them to hit the back button and submit the payment again as that would almost never be intentional and you wouldn't want the hassle of a double charge. On the other hand you don't want to prevent the user from starting...
  6. powella

    Populating a Barcode field in a PDF

    The link to the PDF is absolute, like so C:\PDFComps\Dec\blankform.pdf The barcode field is a built in form field we have added with Acrobat 8 Pro. The field appears to work just fine if you open the PDF and some validation script runs, but if you don't open it and don't cause the script to...
  7. powella

    Populating a Barcode field in a PDF

    We are using cfpdfform tag to populate a PDF. The goal will be to print these as certificates in coldfusion without needing to open them and print. In the PDF we have a barcode form field that we want to have populated. The obvious answer is to tie the value to another text field that holds the...
  8. powella

    Using VBA to populate text fields with report statistics

    David, Have you considered opening a record set in your code? If you report is not to slow you could requery the data with a group by clasue and get your totals. Dim conn as String Dim rsQuery As dao.Recordset conn1 = "Slect * from talbe1" Set rsQuery =...
  9. powella

    Input Mask Textbox

    I don't see how "design view of the table" helps us hide a password in a text field.
  10. powella

    Alternating Shading between records

    >> " However i changed the "Const XorToggle = 4144959" to "Const XorToggle = VBYellow" and I get solid blue. Did i do somehting wrong or is it because i am still useing Access 97? " you are just one step off. To get any color you want just start with an XOR for your constant. For yellow try...
  11. powella

    Excel Template to Access Report

    oops, I was wrong. Here is an MSDN document on it: http://msdn.microsoft.com/library/en-us/olfm11/html/rerefPictureSizeModeProperty1_HV03077469.asp?frame=true 0 Crops any part of the picture that is larger than the form or page (default). 1 Stretches the picture to fill the form or page. This...
  12. powella

    Excel Template to Access Report

    I believe PictureSizeMode = 1 is the zoom mode. I should expand or shrink to fill the picture box, or page as a background image.
  13. powella

    Print modified copies of a report

    Thank you ProgramError. I am close to posting my code. I have figured out a way to get the copies to print to a different tray. I have some duplicate code in two places. so I need to narrow down which cod is actually doing the work and then I can post it
  14. powella

    Remembering page margins?

    RoyVidar, Can you please look at my question? http://www.tek-tips.com/viewthread.cfm?qid=1037629&page=1 I want to alternate printer bins. Basicaly everyother page (even vs odd). It is looking for this solution that I found the link above and this posting. I just thought it might be useful to...
  15. powella

    Print modified copies of a report

    well to answer some of my own question. I can get two copies with this code: If PrintCount < 2 Then Me.NextRecord = False Printer.PaperBin = acPRBNLower Else Printer.PaperBin = acPRBNMiddle Me.NextRecord = True End If I can insert a function call to add the "copy"...

Part and Inventory Search

Back
Top