HI, Im having a slight problem while importing text files to a database, Im
using the below code, but it displaying an error (The Value 2F cannot be
converted to a number)
How do i get it to ignore the F and just look at the 2 using code?
cfif len(i) gte 6
!--- Temp value of
val() will do that for you, but that's a rather course approach. If
you have a know format (e.g. one number then one letter), you'd be
better parsing it explicitly (e.g., left(value, 1)) rather than using
something like val().
cheers,
barneyb
On Fri, Oct 2, 2009 at 12:48 AM, Damo Drumm
Thanks for Replying Barney, but im afraid that doesnt seem to work for me, im
still getting the same error
val() will do that for you, but that's a rather course approach. If
you have a know format (e.g. one number then one letter), you'd be
better parsing it explicitly (e.g., left(value, 1))
Thanks for the link jason, we will try this out
i also should have mentioned that the scanned writing is handwritten.
a company is just becoming computerised and therefore wants all previous
handwritten forms to be transferred to digital.
we are sure many of you have faced the same problem
If it's handwritten, you are probably out of luck. OCR normally
requires a regular typeface.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/10/2 Richard White rich...@j7is.co.uk:
Thanks for the link jason, we will try this out
i also should have
Hi,
cfscript (ColdFusion 8) can I do the following entirety in script?
cfloop index=i list=#listToUpdate# DELIMITERS=,
value = #i#
/cfloop
Thanks
~|
Want to reach the ColdFusion community with something they want? Let
for(i=1;i lte listlen(listToUpdate,,);i++){
#listgetat(listToUpdate,i,,)#
}
Hi,
cfscript (ColdFusion 8) can I do the following entirety in script?
cfloop index=i list=#listToUpdate# DELIMITERS=,
value = #i#
/cfloop
Thanks
for(i=1;i lte listlen(listToUpdate,,);i++){
#listgetat(listToUpdate,i,,)#
}
sorry forgot WriteOutput(listgetat(listToUpdate,i,,))
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
For handwritten forms, you generally must use data entry to make them
electronic. There is too much variance in handwriting to ever make it
suitable for OCR. You should consider either having them all typed in,
or store them electronically and just create a database with enough
SELECT
employees.empID
employees.name,
employees_office.theORDER
office.office_name
areas.area_NAME
FROM employees
INNER JOIN employees_office ON employees.empID = employees_office.empID
INNER JOIN office ON employees_office.id_office = dbo.office.office_id
INNER JOIN areas ON
Les,
I think the query as is will do what you want. Instead of fixing the
query use the Grouping function of cfoutput to only display the employee
name once, but the other data as it is.
Steve
-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net]
Sent: Friday, October
Why not just
cfoutput query= group=name
b#name#/bbr
cfoutput
#area_name#, #office_name#br
/cfoutput
/cfoutput
On Fri, Oct 2, 2009 at 9:09 AM, Les Mizzell lesm...@bellsouth.net wrote:
SELECT
employees.empID
employees.name,
This isn't a list loop, it's an index loop into a list. There's is a
marked performance difference if you list is of any size, because you
have to do tokenization of the list at least twice per loop when you
use an index loop. I did some tests a few years ago and even a
10-item list is about
Agha Mehdi wrote:
Why not just
cfoutput query= group=name
b#name#/bbr
cfoutput
#area_name#, #office_name#br
/cfoutput
/cfoutput
I could - but it's way more complicated than that...
This single query (example was simplified) is responsible for a
Relational databases don't work that way.
Either you have to return all the columns and have data duplication or
you would have to have 2 result sets and match them up with ColdFusion.
It is easier to let the database to the extra heavy lifting and return
one data set with the duplicated
I am using CFIMAGE do resize images and use write to browser to view them I
have noticed that when I view the image the path is something like this...
/CFFileServlet/_cf_image/_cfimg-x
how long does it say in this directory for? does it delete them when its done?
I can still navigate to
Interceptors make requests in specific execution points in which it can
process, pre-process, post-process and redirect requests, perfect for security!
Think of interceptors as listeners to any request in your application.
Write to browser is similar to file upload. It stores the temporary file for
that one request then deletes it after. You can always write the image to a
file of your choice.
cfset src = expandpath(myjpg.jpg)
cfimage source=#Imageobj# action=write destination=#src# overwrite=yes
Then on your
Which database server are you using? Some allow you the ability to return
an aggregate of values in the form of a comma delimited list. You might be
able to get your result set to look like this:
EMPID NAME OFFICES
1 DaveBoston (NE), Dallas (SW), Miami (SE)
2 JohnSan
I have some code in application.cfm that is supposed to re-direct the user to a
non-ssl version of the page.
!--- redirect to non-SSL ---
cfif CGI.HTTPS eq on
cfif Len(CGI.QUERY_STRING)
cflocation
url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#;
My guess is you don't have a valid security certificate on the server. If
you have any cert installed, Firefox is first going to get that cert info
from the web server before your request ever gets to ColdFusion. What you
probably need to do is turn off the SSL on that site if you don't want
I remove the code and hit the web site with ssl and it works fine. I know the
certificate is good.
https://www.beeculture.com/
This one has me stumped.
-Original Message-
From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com]
Sent: Friday, October 02, 2009 2:58 PM
To:
How about a client side redirect?
cfif CGI.HTTPS eq on
cfif Len(CGI.QUERY_STRING)
scriptwindow.location =
'cfoutputhttp://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#/c
foutput';/script
cfabort
cfelse
If you just want to kick them out of https you can do that with Java script
on the appropriate pages.
script language=JavaScript
var loc = document.location.toString();
var index = loc.indexOf(:);
var url = loc.substring(index,loc.length);
I have some code in application.cfm that is supposed to re-direct the user to
a non-ssl version of the page.
!--- redirect to non-SSL ---
cfif CGI.HTTPS eq on
cfif Len(CGI.QUERY_STRING)
cflocation
url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#;
Agree with Alan here. If you need ancient handwritten docs to be databased
and/or search-ready, I would recommend finding a couple college types to do
some data entry for you at $10 / hour and get it done that way. OCR can't pick
up the possible variations among various handwriting forms.
I tried this code and it takes me to http://www.www.beeculture.com/
www. Should not be part of CGI.ServerName right?
-Original Message-
From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com]
Sent: Friday, October 02, 2009 3:16 PM
To: cf-talk
Subject: RE: ssl
How about
OH.. hang on it only errors in firefox. I tried IE and the certificate and my
original code work fine (after I remove the www.) CGI.ServerName does include
www. (DUH!).
Now I just have to figure out why the SSL cert does not work in FireFox.
-Original Message-
From: Chad Gray
Jason Fisher wrote:
Agree with Alan here. If you need ancient handwritten docs to be databased
and/or search-ready, I would recommend finding a couple college types to do
some data entry for you at $10 / hour and get it done that way. OCR can't
pick up the possible variations among
I think that simply translates what the user typed. If they typed in the
www, then it will be part of it. If not, it won't. The CGI doesn't look
into your web server to see what your actual domain name is. Do this:
cfdump var=#cgi#
This will give you all the CGI variables and you can figure
But you said the cert works fine in firefox when you go the
https://www.beeculture.com, right? That's why I think Firefox is trying to
recognize the server side redirect and thinks it might be a hacking attempt.
Microsoft probably would never be so thoughtful to put that into IE. ;-)
On the
Thanks Dave, it ends up FireFox is not compatible with this GoDaddy class 2
certificate for some reason.
I guess firefox does not have the CA chain in it.
Thanks for the help!
-Original Message-
From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com]
Sent: Friday, October
Are you sure it deletes it afterwards I.E
http://www.safe4sure.co.uk/CFFileServlet/_cf_image/_cfimg-7294859208909333435.PNG
its still there?
do you set how CF treats these files in CFadmin?
~|
Want to reach the ColdFusion
barneyb thats interesting thanks
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
O went back 5 mins later to that URL and got...
404
Not Found
so there must be some sort of time frame before its deleted, anyone know what
this is?
~|
Want to reach the ColdFusion community with something they want? Let
I've been trying unsuccessfully to create war file archives of our coldfusion 8
server. I end up with an empty directory. All we would like to do is create a
war file that can be deployed to multiple J2EE application servers preserving
the administrator settings - there is no application to
it's about 5 min :)
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 03/10/2009 04:04, Glyn Jackson wrote:
O went back 5 mins later to that URL and got...
404
Not Found
so there must be some sort of time frame before its deleted, anyone know what
this is?
LOL, set myself up for that one :)
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Maybe you need to install the intermediate certificate? Usually the
cert provider gives it to you with the cert. In apache httpd.conf it
goes in like this:
SSLCertificateFile /path/to/your.crt
SSLCertificateKeyFile /path/to/your.key
SSLCertificateChainFile /path/to/your/chainFile.crt
--
It
I've got an Ant build file for Railo that should be pretty editable
for Adobe CF...
I'm a little wary of making WARs with Adobe CF libs tho, as the engine
isn't free.
Theoretically, all you really need is the jars in the container's
classpath, and a WEB-INF/web.xml with the correct information
40 matches
Mail list logo