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...

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...

Oh, I was hoping someone knew some way to do this with replace. I'll try other forums. Thank you!

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...

Hi again,

I figured out a way to do this, but it seems like such a long-winded way to go about it. If anyone has any way to make this neater, please let me know.


I. First, I concatenate the...

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...

Thank you, mellamokb. That was helpful. I just wanted to make sure I was doing everything possible. I do always check before I publish a page, but I've inherited this site, and there are a lot of...

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. ...

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...

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...

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...

Thanks for your advice, hinde. I think your solution is probably more sound than the one I came up with. I'm just not that comfortable w/sql server, so what I did was create a table with 3 columns:...

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....

Thank you so much! This works perfectly.

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...

So that worked great...until my coworker tried to open the link with Lotus Notes! Apparently, the body turns up in the subject line. Any other alternatives that you know of?

Thanks you!

Hi,

Thanks for all your good advice. I've given up on the query string part. We're just going to email from pages without query strings.

Here's the code:
<CFSET pagename = cgi.script_name> ...

I agree with you, CFAllie. But now I have another problem! When I try to include the URL, including a query string, in the body of the message, it won't include anything with ? or &. I tried...

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...

Yep, that worked! Thank you, CFAllie!

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...

Yes! I'm being spammed. Any solutions to stopping spam during form submission?

Hi CfAllie! The mystery is solved, sort of. I found the offending form submission. Have you ever heard of autohitsite.info? Somehow, they are filling out my form with a bunch of weird data.
...

I meant before the form was inserted in the database, not before it was submitted!

I have tried entering long values, but since I've set the MAXLENGTH, it stops me. What I've decided to do is have the form fields emailed to me before the form is submitted, so that mayble I can find...

Thank you so much for trying to help me!

Nope, no memo fields. And I've tried the form myself, entering all kinds of values of varying sizes, and everything works. Is there a way to get the...

It's MS Access with Unicode. The table is huge, so I don't know if I'll post the structure. However, I did put a MAXLENGTH on all form fields to make sure that they couldn't enter too much data. I...

Thank you, cfAllie. I'm using MX7.

I'm not sure if I want to use the insert statement, because none of my form fields are required, and if they are not filled out, I get Element formfield is...

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...