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!

Register Log in
  • 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!

Search results for query: *

  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#"...
  16. joepeacock

    extra commas

    Also, why do you have... <input type="text" name="name" value="#FORM.name#" size="75"> ...the "#form.name#" variable indicates that you are filling this field with the value of the "name" field from a form that was submitted to this page.
  17. joepeacock

    extra commas

    Here's what it looks to me like you are trying to do: PAGE A: A form that submits to page B, and includes a field called "name" PAGE B: Another form, which includes the data submitted from the form on page A, plus another field called "name" PAGE C: the action page, where the from from page B...
  18. joepeacock

    input field

    Here's a much less sophisticated, but equally reliable solution: <script language="javascript"> function chars(string,Chars) { var returnstring = ''; for (var i = 0; i < string.length; i++) { if (Chars.indexOf(string.charAt(i)) > -1) returnstring = returnstring + string.charAt(i); }...
  19. joepeacock

    extra commas

    You are entering the "name" field twice on your form. Once in your loop from the previous form submission and also once by itself (highlighted below) <!--- Exerpt from form page ---> <cfloop collection="#FORM#" item="whichField"> <cfoutput> <input type="hidden" name="#whichField#"...
  20. joepeacock

    Verity Stemming

    I've done a little more research and found that, in fact, Verity will not stem three letter words. Apparently, this also means that Verity will not stem words with three letter roots (e.g. "Dogs"). So, I added a little bit of code, but I'm not sure I like it. Feels like spackling a stucco...

Part and Inventory Search

Back
Top