Search results for query: *

Hi, I have a 4 step form (4 pages). Step 1 Identifies the customer by querying a customer dB using a variable passed in the url, posts the contact information is several form fields and asks them to update the information. Step 2 basically asks the customer if they will or will not be storing...

Hello - I have the need to deselect one check box if another is selected. Here's an example: <table width="400" border="0"> <tr> <td COLSPAN="3"><font color="#000066" size="2" face="Verdana, Arial, Helvetica, sans-serif"> <strong><u>Hull...

I am trying to insert records from a csv file and one of the fields is zipcode. The issue I am having is that zip codes that start with a leading zero, end up inserting with the zero removed. How can I maintain the zero?

Hi, I have a client that is going to pass me form data for insertion into a dB table. The problem is, although many of the form fields are static, they will also pass several dynamic option fields in the process. All of the option field names are prefaced with option_ so I need to understand...

Ok, here's my question. I want to use cffile to upload a pipe delimited text file, but in the process, I want to dedupe the file and then save it to the server as csv. Can this be accomplished?

Hi, I suspect this is a simple function, but I can not find anything to explain how it's done. I simply want to go to a new page once my flash movie completes playing. So, my flash is embedded into page.html and I want to go to page2.html once it is finished. Thanks

Hi! Is there a way in CF to either validate the an email address posted in a form submission is valid or at the minimum validate that the domian exists? I am aware of an ASP solution, but can't find anything around doing the check in CF. Thanks.

Hi, I have ONCHANGE="location = this.options[this.selectedIndex].value;" working for my select box, but I need it to open a new window instead of opening the url in the current window. Although I would think it would be an easy task for anyone who knows java script (obviously I don't), I've...

Hi, I am generating a bulleted list from a field containing comma separated values. I want to split the list in half and display it in 2 columns but am note sure how to accomplish it. Here's what I have now: <td align="left" valign="top"> <UL> <CFLOOP index="counter" From="1"...

First let me prefice my questions with; I was asked by a friend to help (for free) create a music player for his sister's website and I agreed to help not having a clue what I was getting myself into. I have played with Flash one other time in my life and have no other training...what was I...

I know this is so easy, but I don't remember how to do it and can't find an explanation. I want to display the first 15 characters of a given field. It seems to me I used the trim function, but don't remember how to do it. ie. #dealershipname# Currently displays as Munson Marine of Squaw Creek...

I am having a problem calling a custom tag with cfmodule. Here's the code: <cfmodule template="terraform" formname="newusedboats"> Here's the error: Could not find the included template terraform. Note: If you wish to use an absolute template path (e.g. TEMPLATE="/mypath/index.cfm") with...

Hi, I am trying to populate my cfmail body by pulling the info from a MSSQL text field. cfmail looks like this: <cfmail to="#Email#" from="#specemail#" subject="Your specs file" type="html"> #getspecfilemessage.emailtext# </cfmail> The data in the text field looks like: <table width="600"...

I have a view that has a date field named DateLastLeadSent. The function that I am trying to accieve via ColdFusion is to email a lead to a sales rep who has waited the longest to receive a new lead. I am just not sure how to say where the time between NOW and DateLastLeadSent is the greatest...

The other day I was trying to figure out how to dynamically convert my varchar field to a datetime field. I was able to do it in my view by using CAST(dbo.Entries.CreatedDate AS DATETIME) AS CreatedDate. The data now looks like 8/31/2005 1:11:40 PM. The problem is, my query doesn't return any...

I have a problem with a varchar field that has been used to store dates. This was not originally my project and I have no idea what problems converting the field would cause. My problem is, I need to query between 2 dates. Here's my current query: <CFQUERY name="Betweendates"...

I have a table called events and am displaying past, present and upcoming events to site visitors. I also have a table called entries where coaches can post play by play commentary about a particular event. Up until today, I was only listing the event name for future events as opposed to linking...

Hello, I am trying to sum up several columns to create a subtotal. When I execute my query I get an error that says: " is not a valid name. Make sure that it does not include invalid chareters or punctuation and that it is not too long. Here's my query: SELECT DISTINCTROW Rentals.Rental_ID...

We have an append query in access that we use to archive data to another table. Is there a method to run this query from CF?

I'm lost. All I need to do is put a button in a form that opens a Word doc and populates the contacts name and address information in the Word doc like: FirstName LastName Address City, State Zip I can get word to open, but that's about it. My questions are: Can I do this right from the form...