A partner firm needs to pass me some xml information and I need to get that info and run queries with the UserID in the passed info. They pass me this xml <Request> <Header> <UserId>phutch</UserId> <Token>08012011T1149034</Token> </Header> </Request> I am trying to retrieve the UserId from the xml file using <cfdump var="#GetHttpRequestData()#"> I was hoping that I could get the xml info from the GetHttpRequestData() tag but I get an error message "The markup in the document following the root element must be well-formed. Nested exception: The markup in the document following the root element must be  well-formed." I think the error might be because this line of code is not at the beginning of the xml passed to me. <?xml version="1.0" encoding="iso-8859-1"?>  or  <?xml version="1.0" encoding="utf-8"?> Anyway.  Does anyone have any ideas on how I could extract the UserId from the above xml? ... View more

I am using an application.cfc file for the first time ands I cant seem to get it to work. Do I need to register the application.cfc in the CF administrator in order for it to work? I actually have  2 cfc files application.cfc and mylist.cfc Do I need to register both of these in the CF administrator? ... View more

I have a form that I need to post the info to 2 different places like this STEP 1 <form action="enroll1.cfm" method="POST" id="1"> 10 Form Fields </form> >>>>> Do Database insert STEP 2 Now I need to take that same form info and post it to another url  so that it can be inserted in another database at another company. Like this <form action="enroll2.cfm" method="POST" id="1"> 10 Form  Fields </form> >>>>> Do Database insert I get the first form posted and the data gets inserted into the database but now how do I pass the 10 form fields to the other url (Step 2)? ... View more

I am trying to add some style to a CFCHART Bar Chart. I have found an.xml file that I can add style. Is there a style to set the widths of a bar in a bar chart? Right now the bar width is to much and an 8 bar horizonntal chart takes up the entire page. Is there a way to make the bar chart width smaller. AND is there a place wher I can change other styles? ... View more

I have an insert query that parses a large text file into a query object and then loops through it and inserts it into a data table. However sometimes there are bad values are in the text file...like a text value  where a date should be etc.  or a nonnumeric value where a numeric should be.....  This causes the loo/ insert query to STOP. If I get all good values I want the data to be inserted and have processing continue. However If I get a bad value in the file I want all processing to stop and all of the prior inserted rows to be deleted and I want to get an error message emailed to me How do I do this? Here is the Cfloop and the insert query below..again the problem is that if I get a bad value I want processing to stop and the data table to rollback to the initial state prior to any processing.....and I want an email alerting me there was an issue ( I know how to use CFMAIL) <cftransaction> <cfloop query="stocks">     <CFQUERY name="load_the_data" datasource="abc" >     INSERT INTO portfolios_new (portfolio , portfolio_ID , load_date , ticker , cusip,BC1, BC1_ID , BC2 , BC2_ID , BC3 , BC3_ID, Load_ID) VALUES ('#Portfolio#'     ,'#PORTFOLIOID#','#loadDate#','#Ticker#','#Cusip#','#BC1#','#BC1Id#','#BC2#','#BC2Id#','#BC3#','#BC3Id#', '#next_load_id#' );     </CFQUERY>   </cfloop> </cftransaction> ... View more

I have 2 strings  --String A and String B String A  (1,2,3,4,5,6,7,8) String B (1,2,3,4,9,10,11,12) I need to compare the 2 strings and find the values that ARE IN BOTH strings. So the answer I need to get is 1,2,3,4 as 1,2,3,4 is in BOTH strings. I cant find anything in the CF String Functions. Any Ideas? ... View more

I have a form with 50 fields. Sometimes when my users submit the form, if the field value is zero, they delete the input box completely. So when the form is submitted and they get to the processing page ; the form field value for the field they deleted is  "". This is causing problems as the form value is "", where it should be 0.00 I have CFPARAM's at the processing page. But I guess since the value is defined ("") they are not being used. Is there a way to code the form processing page so that if any of the form fields are "" that they default to a 0.00 value? Pat ... View more

How do I replace an ampersand (&) in my string with the word ' and ' How do I make? Mike&Pat into MikeandPat ... View more

I have a table with 4 columns I want to sort and not sure how. I can sort by 1 column but I need the sort to be on 2 columns. Here are the 4 columns City1 City2 Rate1 Rate2 Dallas Mentor 100 65 Richmond New York 95 60 Miame Houston 125 116 Enid Denver 40 38 I want to sort them using the UNION of the values in the RATE1 and RATE2 columns So I want them sorted like this Miame 125 Houston 116 Dallas  100 Richmond 95 Mentor 65 New York 60 Enid  40 Denver 38 Any Help ... View more

I have a website that people vote for the coolest helmets here http://www.vhsl-reference.com/helmet_1.cfm When they click the vote button at the above page they go to a 2nd page that does an insert into an access db and then redirects them back to the voting page to vote again. Its easy for users to vote numerous times quickly and during the day I have gotten up to 10,000 + votes and I know I will get more. The problem is when there is heavy usage(voting) the access db locks up, the site becomes unavailable, and usually I get the dreaded .ldb file and then I need to call my host and get them to reboot the server. My question is, is there any code that I can put around my INSERT statement code that will make the database to wait(hesitate or hold)  until one INSERT is done before doing another? OR Is there any other strategy to deal with this issue. I have thought of inserting into multiple data tables or databases based on the time of the vote to allay the problem. But ideally I would like to somehow code the insert page to hesitate until the database is not in use. CFLOCK maybe?? ... View more

How would I extract everything before and after the LAST - (dash)? Example: mt-st-marys-fl............................ Everything before last dash: mt-smarys Everything after last dash: fl ... View more

How would I query a directory and delete all files from that directory that are more than 1 hour old? I have used CFDIRECTORY before to post pages to the directory and to get directory info but I cant figure out how to query a directory and delete all files more than 1 hour old from that directory. 1 hour old means that the time NOW is more than an hour from the file's date/time on the server. ... View more