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 Chriss Miller 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 joepeacock

  1. joepeacock

    .NET C# Newb - Form fields not posting???

    Thank you for your replies. jmeckley, I did not mean to imply that I was opening the file through Windows Explorer. My development environment runs IIS7 and I am browsing these pages through both local (192.168...) and internet URIs (dev...com) with the same results. Like I said, I am new to...
  2. joepeacock

    .NET C# Newb - Form fields not posting???

    I'm having a strange problem with form fields not being available to my .aspx.cs pages after being POSTed from another page. In order to rule out any interference from other features, I created two simple pages "test.aspx" and "test2.aspx" -- test posts a form to test2. === test.aspx...
  3. joepeacock

    .NET C# Newb - Form fields not posting???

    I'm having a strange problem with form fields not being available to my .aspx.cs pages after being POSTed from another page. In order to rule out any interference from other features, I created two simple pages "test.aspx" and "test2.aspx" -- test posts a form to test2. === test.aspx...
  4. joepeacock

    date add in query issue

    My code above assumes you have a local variable called #datereceived# that you are comparing the database field against. I think what you actually want is this: select ponum, count(itemnum) as itemnum, count(invoicenum) as invoicenum from poreceiv where ponum = '#get_po_item.ponum#' and...
  5. joepeacock

    date add in query issue

    Just add createodbcdate() to your code and it's perfect: select ponum, count(itemnum) as itemnum, count(invoicenum) as invoicenum from poreceiv where ponum = '#get_po_item.ponum#' and itemnum = '#get_po_item.item#' and datereceived > #createodbcdate(dateadd("ww", -4, datereceived))#
  6. joepeacock

    Chinese Characters - UTF8

    I am attempting to store Chinese text in a table with UTF-8 encoding and utf8_general_ci collation. After being stored, they are retrieved and displayed on a web page. On that page, which is properly set to use the UTF-8 character set, about 95% of the characters are correct, but a few are...
  7. joepeacock

    cf_csv_to_file csv_query

    Sounds like maybe the relevant code is that CFM tag file you have. That's the code that is actually formatting your data. If it's encrypted, you may be SOL. What is the source database? If it is SQLServer, you may try something like this for your csv_query value: SELECT InvoiceNumber...
  8. joepeacock

    cf_csv_to_file csv_query

    We may not all be familiar with the custom tag you are using. Can you post the relevant code that generates the CSV file, or updates it?
  9. joepeacock

    how to make coldfusion dynamic pages SE friendly?

    On one site, we have over one million products listed on the site. We took to the task of creating index pages for search engines, with a series of menu pages getting more and more specific until finally landing on the individual product page after three links or so. We had a lot of difficulty...
  10. joepeacock

    loop over lists in a query to get a sum?

    It appears your "photo" field is a comma-separated list of "X" and you are running a query returning several records, and you want to find out how many total "X"es there are in the query results, so maybe, you have: Name | Photo ---------------------------- John | 33,87,97,12,10 Jack...
  11. joepeacock

    IsDefined() ?

    When an image is clicked to submit a form, the image field is not passed with the form, but two fields called "X" and "Y" are, if I recall correctly (maybe "delete.X"). If your "delete" image is the only image that can be used, you could try checking for those fields. However, what I have...
  12. joepeacock

    extra commas

    If the code is the same on your machine and the remote server, the debugging information should be more or less the same. If the commas are not there on your machine, I imagine it's a CF version difference that interprets duplicate form fields differently. So, you should be able to see the...
  13. joepeacock

    extra commas

    Take this field for instance: <input type="text" name="state" value="#FORM.state#" size="2"> If the form that posted to this page does not have a field called "state", this should throw an error. If it is not throwing an error and you are certain that the posted form does not have that field...
  14. joepeacock

    Adding Variables In CFOUTPUT

    <CFOUTPUT> #evaluate(variable1 + variable2)# </CFOUTPUT>
  15. joepeacock

    extra commas

    There must be a form posting data to your form page, otherwise you would be getting a bunch of error messages on your #form...# variables. The #form...# scope refers to variables that were passed to the page using a POSTed form. Your loop, (<cfloop collection="#FORM#"...

Part and Inventory Search

Back
Top