WOW, that code looks like a maintenance nightmare. At one time long ago in
a land far far away called Oracle 7 I started to do something like this and
gave up quickly. Can you not use CF to validate this data? Besides the
usual validations, isDate(), isNumeric() etc..., cfqueryparam can be used
I see two things here worth paying attention to.
For the original poster, if you're getting value too large for column
type errors, you're not performing proper data validation of length,
range and type of data. This should be addressed. Of course you can
make mistakes in your data valida
Thank you all for your suggestions.
I should've given more info up front. I was hoping to find a more global
solution. Something to stick in the request_error.cfm page rather than
trying to cftry/cfcatch each query. Thanks.
mf
FWIW, I'll share my error.cfm template here:
You must be logge
I dont know if this is what you want but if you want to view the sql
statement that is causing the error, then the best option is . I usually mail this info to my email adrr and it really helps me
to understand what is going on with the query.
But if you want to show information to the user, I am
If you are also looking to trap the error in CF,
is generic to DB related issues.
If you are trying to cater to a particular error code, you will have to
parse the cfcatch structure.
cfcatch has a key for specific database features:
cfcatch.sql
cfcatch.queryError
The more generic keys are:
I think that you're going to find what you want in a CFTRY/CFCATCH
combo. You can drop TRY/CATCH blocks around your SQL operations and
catch different types of errors, handling them in different ways. In a
development environment, try the following and see if it gives what
you need:
bad SQL go
Does anyone know of a simple way to catch the SQL command which causes
an error?
For example, I have request_error.cfm that records the error.diagnostics
and the error.template as well as decodes most errors to let the user
know why they've been bad. But, I'd like to be able to see the statement
t
We ran into some other issue with the new JDBC drivers too that involved
using the WITH statement in SQL and a complex query. Other than that, we
have not seen anything else.
DK
On 6/18/07, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
If you are using **
Sent by: [EMAIL PROTECTED]
06/18/20
If you are using
Sent by: [EMAIL PROTECTED]
06/18/2007 12:28 PM
Please respond to
discussion@acfug.org
To
discussion@acfug.org
cc
Subject
Re: [ACFUG Discuss] EOLAS fix for ColdFusion Flash Forms
Ok, so I did this update to my development environment and it did indeed
fix the issue with
Ok, so I did this update to my development environment and it did indeed fix
the issue with Flash forms. I then approached my boss with the idea of
updating the production server and he was apprehensive and asked that I
research if this fix created any new issues and if so what they were.
So, I
Charlie,
Thanks, I actually started updating my CF about an hour or so after posting
this question. I had an error during the install so I'm doing it again
right now, but thanks for the response. Hopefully I get it worked out
today.
On 6/16/07, Charlie Arehart <[EMAIL PROTECTED]> wrote:
Je
11 matches
Mail list logo
