lafalot

Hi, Sadly, I use MS Access as the backend db for our Coldfusion website. Every once in awhile, I receive the following error: "Error Executing Database Query. Operation must use an updateable query" This is in reference to an insert query that I have running. This query works most of …

Hi all, We are migrating from Coldfusion MX to Coldfusion 9. Yesterday, we were able to access the cfadmin. Today, when I go to cfide/administrator/index.cfm, I get the following error: "Tag CFAuthenticate is not supported in ColdFusion" I don't use CFAuthenticate in any of my code. Can anyone help? Thank …

Hi, I am outputting a query into a table. I am listing titles of workshops, and dates and times. If there is more than one date/time for a workshop, I add a separate row for each date/time. I would like to have all the rows for each workshop be the …

Hi, I have a form that works fine, unless there is too much data in the textarea. This does not appear to be a problem with the database, as the form is getting stuck before it even submits to the action page. In fact, I commented out the entire action …

Hi, I would like to be able to schedule cfmail at random times, but I have the following issues: 1. Our hosting service will not allow cfschedule. However, I can schedule an event through their control panel but ... 2. The message portion of the e-mail changes, and is submitted …

Hi, I have created a pdf using cfdocument that displays the results of a submitted form. This works fine in IE and Firefox in Windows, but on the Mac & in Safari, it does not recognize the pdf because it is a cfm file. Any help is much appreciated.

Hi, I am getting the following error in my mail log: Exception reading response; nested exception is: java.net.SocketException: Connection reset I get this intermittently: sometimes it works and sometimes it doesn't. I've tested using my own email, so I know it's not a problem with the address. Is this a …

Hi, Please help! We have data that was input into SQL Server using activedit. This data has all kinds of inline styles, and it looks horrible. Is there a way to parse the data and get rid of all inline styles? Thank you for any help you can provide.

Hi, For a reservation system, I would like to be able to highlight those reservations where the dates and times are duplicates, so those confirming the reservations will easily see double-bookings. So, for the following list of dates & times Jan 1, 10-3 Jan 2, 4-5 Jan 1, 10-3 Jan …

Hi, I have a cferror type = "exception" exception="any" in my application.cfm file. This works great for most errors, but I recently found that it is not working for attribute validation errors. For example, if I misspell an attribute for the cfqueryparam tag, my custom error page is not called. …

Hi, I'm selecting email addresses to mail where the field emailsent is null. After I run the cfmail, I update the field to the date the email was sent. Is there a danger of the update query running before the cfmail is finished? Is there a solution for this? Many …

Hi, I have a calendar w/data stored in SQL Server. People can reserve multiple dates for an event. Before a reservation is confirmed, I want to be able to see if the dates have already been reserved. I first query the dates for the unconfirmed reservation. I then want to …

Hi, We have a form where people are able to upload a pdf. This works great. We also have an editing form, where they can edit their entry. However, when I try to call up the PDF file that they uploaded, I get nothing. Additionally, the file they uploaded disappears. …

Hi, I have time stored as an integer in sql server. The time is separated into fields of hour, minute and am/pm. I need to output the data and sort the time, but of course, 12 is coming after 1. Is there a way to sort my hour integers in …

I have a form on our Web site where visitors enter data. I use cfinsert to insert this data into an MS access table. Most of the time, this form works. However, I occassionally get the following error: Error Executing Database Query. Application uses a value of the wrong type …

Hi, I'm creating a customer database in MS ACCESS with the following 3 tables: Customer (with unique customer_id) Products (with unique product_id) Customer_Order(contains both customer_id and product_id). I want to be able to use a form to enter new information into both the customer table and the customer_order table. The …

Hi, I've set up a "Send Page to Friend" function using a script that I donwloaded. It works fine if I use my email as the recipient address, but I receive the following error when I try to send it to a Yahoo address: Invalid Addresses; nested exception is: class …

Hi all, I am running a query on an MS Access table that has some fields that are the same and some that aren't. For example, the customer number_field is the same, but the start_date field is different. I'd like to run through the query and when the customer_id is …