User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 391,668 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,939 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ColdFusion advertiser:
Views: 5426 | Replies: 17
Reply
Join Date: Apr 2007
Posts: 28
Reputation: lafalot is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
lafalot lafalot is offline Offline
Light Poster

Re: MS Access Error - sometimes

  #11  
Apr 12th, 2007
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 which field is causing the error. Thank you so much for all your help!
Reply With Quote  
Join Date: Apr 2007
Posts: 28
Reputation: lafalot is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
lafalot lafalot is offline Offline
Light Poster

Re: MS Access Error - sometimes

  #12  
Apr 12th, 2007
I meant before the form was inserted in the database, not before it was submitted!
Reply With Quote  
Join Date: Mar 2007
Posts: 28
Reputation: cfAllie is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
cfAllie cfAllie is offline Offline
Light Poster

Re: MS Access Error - sometimes

  #13  
Apr 12th, 2007
Originally Posted by lafalot View Post
I meant before the form was inserted in the database, not before it was submitted!


I understood what you meant That sounds like a good plan. Once you have identified the problematic values you can determine whether the cfinsert can be fixed or if you need to convert it to a regular insert. I'm curious what the problem is so when you figure it out please post back. Good Luck!
Reply With Quote  
Join Date: Apr 2007
Posts: 28
Reputation: lafalot is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
lafalot lafalot is offline Offline
Light Poster

Re: MS Access Error - sometimes

  #14  
Apr 16th, 2007
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.

Additionally, they have answers for select box fields that are not part of the select box answers.

Also, the URL that they are coming from is not the one that calls our form.

I'm relieved that my form works, but not sure how they are submitting this strange data.

Thank you for all your help!
Reply With Quote  
Join Date: Mar 2007
Posts: 28
Reputation: cfAllie is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
cfAllie cfAllie is offline Offline
Light Poster

Re: MS Access Error - sometimes

  #15  
Apr 16th, 2007
Originally Posted by lafalot View Post
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.

Additionally, they have answers for select box fields that are not part of the select box answers.

Also, the URL that they are coming from is not the one that calls our form.

I'm relieved that my form works, but not sure how they are submitting this strange data.

Thank you for all your help!


Never heard of it. Is it possible you're being spammed?
Reply With Quote  
Join Date: Apr 2007
Posts: 28
Reputation: lafalot is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
lafalot lafalot is offline Offline
Light Poster

Re: MS Access Error - sometimes

  #16  
Apr 16th, 2007
Yes! I'm being spammed. Any solutions to stopping spam during form submission?
Reply With Quote  
Join Date: Mar 2007
Posts: 28
Reputation: cfAllie is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
cfAllie cfAllie is offline Offline
Light Poster

Re: MS Access Error - sometimes

  #17  
Apr 16th, 2007
Try adding a captcha image to the form submission. They're not fool-proof but they help minimize spam.

http://lyla.maestropublishing.com/
Reply With Quote  
Join Date: Jun 2007
Posts: 1
Reputation: blairr is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
blairr blairr is offline Offline
Newbie Poster

Re: MS Access Error - sometimes

  #18  
Jun 10th, 2007
This is sort of related: So if you use Access w/unicode then memo field length is limited?
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb ColdFusion Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the ColdFusion Forum

All times are GMT -4. The time now is 1:59 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC