.
-Leigh
From: DURETTE, STEVEN J sd1...@att.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Friday, September 6, 2013 10:37 AM
Subject: RE: CreateODBCDate()
Are you sure that you aren't adding that twenty thousand years by accident?
It is for a dues expire
Here's the message it sent me:
Detail: [Macromedia][SequeLink
JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]
Syntax error (missing operator) in query expression 'd '20141-04-30'}'
It shows the query: ..., DuesExpire = {d '20141-04-30'}, ...
What is the complete error
Access will not process 20141 as a valid year in a date field.
Yep, but if the error message is to be believed, it suggests a different
problem like an empty variable, bad quotes, etcetera. So I would be interested
in seeing the full error and sql.
-Leig
IsDefined does not accept array notation. You need to rewrite it using dot
notation:
IsDefined(form.rel_#ar#)
or
IsDefined(form.rel_ ar)
The other option is to use StructKeyExists, which is generally preferred
because it is a little more precise than
Hey thanks, changing my javacast from float to double fixed it.
Rick
Good. According to that thread, using double will not eliminate the issue
entirely .. but will reduce it at least.
-Leigh
~|
Order the Adobe Coldfusion
I'm guessing this is coming from casting it to float, but I'm not
sure what else to do here.
Maybe not just that, but POI's handling of it? Since Excel does not support
precise types, POI uses doubles (and auto casts floats to doubles). Since both
are approximate types that may be what is
coldfusion.server.ServiceFactory
No, that undocumented class still exists in CF10. Perhaps it is a permissions
issue. What is the exact code and error message?
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http
Ed - Try using the code in this blog entry to find the source jar (The entry
is very old, but still relevant)
http://www.bpurcell.org/blog/index.cfm?mode=entryentry=982
-Lei
~|
Order the Adobe Coldfusion Anthology now!
.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354786
This is the code that was used for the encryption:
What is the code for RijndaelDecrypt/RijndaelEncrypt?
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155
-16LE in CF.
http://pastebin.com/fZtdeQ2e
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk
/exchange/index.cfm?event=extensionDetailextid=1007043
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com
What is the datatype and length of the column in the Access database?
Also, which datasource type? I remember someone mentioning problems with Memo
fields when using the unicode driver a ways back. They suggested using *_clob
instead of *_longvarchar.
-Leigh
Well MySQL has very different data types (and unlike Access, it uses a pure
jdbc driver). So this probably does not apply to MySQL.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion
Can you ask why on Earth client say no cookies? That's sort of crazy.
I do not think they are saying no cookies, rather that they be optional
instead of mandatory.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http
A very fitting eulogy :)
Reply from 206.180.224.36: bytes=32 time=21ms TTL=119
Request timed out.
Request timed out.
I shut down a very faithful
NT 4
Oriellys Website Pro
Cold Fusion 4.01
MS SQL 7.0
server today..its been amazingly rock solid and moving large amounts of
data without
Without testing anything, that sounds like DNN hashing. See if this helps:
http://stackoverflow.com/a/12539088/104223
-Leigh
Subject: Re: Porting password hash mechanism from C#
To: cf-talk cf-talk@houseoffusion.com
Date: Monday, February 4, 2013, 8:55 PM
http://pastebin.com/htcPsqpG
http://stackoverflow.com/a/12539088/104223
Okay, I just tested your values and it is the same algorithm. So that link
should do the trick.
-Leigh
Subject: Re: Porting password hash mechanism from C#
To: cf-talk cf-talk@houseoffusion.com
Date: Monday, February 4, 2013, 8:59 PM
Without
Bert - Great, glad I could help :)
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk
Adobe should work on integrating the 64 BIT jIntegra
http://j-integra.intrinsyc.com/ .
I could be wrong, but was under the impression the 64bit version only worked in
DCOM mode and maybe that is why they avoided it.
-Leigh
protect against sql injection
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f6f.html
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp
FYI, they just released a patch:
http://www.oracle.com/technetwork/java/javase/7u11-relnotes-1896856.html
(Here is the security alert which jives with what Dave said)
http://www.oracle.com/technetwork/topics/security/alert-cve-2013-0422-1896849.html
-Leigh
--- On Sat, 1/12/13, Nick Gleason
://www.petefreitag.com/item/701.cfm
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm
Search the HOF archives. I remember there is a thread about this topic. In
brief, error handlers only capture runtime exceptions. That is a compile error,
which happens before the code ever executes. So standard cfm error handlers
cannot capture it.
-Leigh
IIRC I think site wide error handlers can catch it. However, compile errors in
prod applications is not the norm, since it would mean the code was never
tested.
-Leigh
--- On Thu, 12/6/12, DURETTE, STEVEN J sd1...@att.com wrote:
From: DURETTE, STEVEN J sd1...@att.com
Subject: RE: CFERROR
These links have the build numbers for most versions:
http://bigmadkev.com/blog/post.cfm/jrun-build-numbers-updaters
http://www.talkingtree.com/blog/index.cfm/2005/2/17/BuildNumbers
-Leigh
~|
Order the Adobe Coldfusion
.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353163
Subscription
Yep, there is always more than one way to skin a cat. (Ouch... poor cats)
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http
You need to provide the scale attribute (ie Number of decimal places). The
default is zero (0). That is why the value is rounded.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion
Does the GenerateSecretKey function account for both the key
and the algorithm?
No - not the way you are thinking. You need to supply the algorithm twice. Once
when generating the key _and_ once when performing the encryption. To better
illustrate:
!--- generate a key suitable
My response got cut off.. Here is the full snippet... assuming it goes through
;-)
http://pastebin.com/fPLcU3Kd
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp
Any idea what the The UU algorithm is not supported error is about?
You skipped the algorithm again ;-) The third argument is the encryption
algorithm ie AES. Encoding (ie UU) is the fourth argument.
Encrypt(yourString, yourKey, theAlgorithm, theEncoding)
-
.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352920
Subscription
I don't think CFMX 9 has a SpellCheck engine
You may need to add it to the toolbar:
http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7a01.html
-Leigh
~|
Order the Adobe Coldfusion
Never mind. I just checked and think you are about the engine itself.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http
group=Client_Code
It should work as long as its contained without a nested cfoutput as Dave
mentioned. Also, notice he is grouping by Client_Name instead of the code.
Be sure the query results are sorted by that column too.
-Leigh
Ah, I did not realize they finally got around to certifying 1.6. IIRC I tried
1.6 under CF8 once and it would not even start. But that must have been a while
ago.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http
oops, i missed to an opportunity to plug ICU4J ;-) i
Man I cannot believe it... I was going to recommend that first :) I think CF8
uses 1.4, btw.
-L
~|
Order the Adobe Coldfusion Anthology now!
Has anyone else run into this?
metadata.functions is a java array rather than a CF array (ie java.util.List).
Java arrays are immutable. You cannot change its dimensions by adding or
removing elements. You must create your own copy manually.
(FWIW CF10 will duplicate it, but the
May be worth mentioning that this works on Railo.
Yep. It is because Railo stores the functions in a mutable object
railo.runtime.type.ArrayImpl. But Adobe CF uses an immutable java.lang.Object[]
array.
-Leigh
~|
Order
http://ultrahttp.riaforge.org/
FYI, that one uses cfhttp
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http
One word (well, ok, two words) - dump them.
I do not think he can .. CFDUMP is on the disabled list ;-)
~|
Order the Adobe Coldfusion Anthology now!
I do not have the URL handy but take a look at Raymond Camden's blog. He wrote
an entry on extracting text from MS Office documents using POI.
For PDF, use cfpf's extract text option.
-Leigh
~|
Order the Adobe Coldfusion
the arrays are set into session:
cfset session.ceuAppModules1A = [] /
To access the element dynamically, use structure notation, ie:
session[ceuAppModules theDynamicSuffixHere
~|
Order the Adobe Coldfusion
-
Leigh
some extra text here just to see where the message is cut off .
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http
CellRangeAddress cellRangeAddress = sheet.getMergedRegion(i);
Just drop the data type declarations in front of the variable names. Then
instantiate classes with init() instead of new ClassName( ...). You may also
want to break it up for better readability. I am heading out and cannot test
See http://pastebin.com/M5CNshBp . Looks like my post got cut off again ...
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http
ArrayFind() is case senstive, that is why there is an ArrayFindNoCase().
Yes but the indexOf(..) method is _always_ case sensitive. Also, unlike
arrayFind/FindNoCase it is data type sensitive as well. ie indexOf(15) does not
produce the same results as indexOf(15). So it is good to be aware
Not sure how you tested this
Define a variable representing a number as a double:
cfset y = val(15)
cfset arr = [y]
Now run indexOf(15). The value is not found because unlike CF functions, java
lists also consider data type when determining element equality.
15
Grr.. my responses keep getting cut off. Anyway, the very last sentence was:
Honestly, I do not see the benefit of down to the java level for this.
If you are going to end up looping anyway, may as well use a native
cfloop array= It is simpler and is less code.
-Leigh
The point is that it is still possible...
{tap, tap} Is this thing on?
-Leig
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351001
Subscription
Ever since ColdFusion 6, ColdFusion has always had the feature to do
anArrayFind()
True. Though indexOf() has a few additional nuances over arrayFind. It is both
case and data type sensitive.
-Leig
~|
Order the Adobe
but fails when used inline
Can you elaborate on fails? Is the cfquery is throwing an error? If so post
the full error message
~|
Order the Adobe Coldfusion Anthology now!
Did you verify the column name is correct?
Any difference if you use single quotes instead of double?
ie datePart( 'q' , theColumnName
~|
Order the Adobe Coldfusion Anthology now!
I think that is a mistake. The CF9 docs say 40 characters or 160-bit as hex
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c52.htm
~|
Order the Adobe Coldfusion Anthology now!
According to the comments here, 28 is the size in base64 (not the default
encoding hex)
http://cfquickdocs.com/cf7/?newVersion=1getDoc=Hash#Hash
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com
Yeah unfortunately IsValid(integer) ignores non-numeric characters. (I wish
they offered a setting for that behavior) Anyway, you might try a range or
regex match instead. I believe those comparisons are more strict.
-Lei
It seems more complex than that, as some it will ignore and others it
won't. Dollar signs and commas appear to be ignored but others are
not (results as run on ColdFusion 9).
Yeah, I do not know all of the rules. But the internal class for integer
validation has a boolean setting that
but a range validator (ie using -2147483648 / 2147483647) seems to produce
results more in
line with that I would expect
I spoke to soon. range has better handling for non-numeric characters and the
overall range. But does not validate they are whole numbers .. (doh).
-Leigh
But, that gets me just a list of the pages, sorted in no particular order:
It may be doable with a grouped output. First, restrict the the results to the
top level. Then order the results by the sort number: parent, child then
grandchild.
SELECT
p.PageID AS PageIDLevel1
Hard to believe an entomologist caused all this.
http://en.m.wikipedia.org/wiki/George_Vernon_Hudson
Wait .. we are stuck in timezone hell because some guy wanted extra time to
collect insects?
-Leigh
~|
Order the Adobe
he was responsible for DST not timezones.
That was my tired brain lumping all time related annoyances together.
DST was probably a good idea once but
now its there to remind developers how cruel the world really is.
The decision to change it, over several years, .. now that was cruel
The vulnerability they are describing seems to be the one described here
From the comment below, I think it is the same issue
http://forums.adobe.com/message/4264032#4264032
-Leigh
~|
Order the Adobe Coldfusion Anthology
Judah - I was wondering the same thing. When it was first announced, I could
not seem to find any CF specific details. I just assumed it was applicable
because java was vulnerable.
-Leigh
From: Judah McAuley
Sent: Tuesday, March 13, 2012 3:36 PM
Subject: Re: hash collision
Thanks, Leigh
CFSQLType ='CF_SQL_VARCHAR'
Also for date columns use a date/time type instead of varchar. If the column
contains dates (only) you can use cf_sql_date, which truncates the time portion.
WHERE EXPIRATIONDATE = cfqueryparam value = #now()#
CFSQLType
I used the same source with CF 8 and 9 and it works properly in CF 9.
Good to hear! I guess some of the changes between poi v2.5 (CF8) and v3.5
(CF9) must have involved unicode :)
Guess updating few with the new versions will solve the issue.
If they are compatible with CF8, yes. (I do
Are you sure it is a problem with the cfc? The first thing to check is whether
your data is stored properly as unicode. If you output the characters on
screen, do they display properly?
I have never used cfHSSF, but all three (cfHSSF, POUtitlity and cfspreadsheet)
use POI internally. So the
Did you forget to modify reFind so it returns subexpressions (ie a structure
not a number)?
ie found = REFind(url.terms, DocContents, startAt, TRUE );
-Le
~|
Order the Adobe Coldfusion Anthology now!
ie found = REFind(url.terms, DocContents, startAt, TRUE );
-Le
lol.. Even my name is being truncated ;
~|
Order the Adobe Coldfusion Anthology now!
It sounds like something else is missing. Can you post your current code?
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http
inserts the number in the wrong spot.
Insert adds the string *after* the given position, not before. So you need to
deduct 1 from the result of reFind()
~|
Order the Adobe Coldfusion Anthology now!
REFind( url.terms, DocContents, ...)
Also the code probably will not behave as expected if you are searching for
partial words. Since you are searching starting from the beginning of the
string each time, rather than the last occurrence.
A lot depends on the search pattern. But as you loop keep track of where the
previous occurrence was found. Then start searching *after* that position.
Otherwise, refind will just return the first occurrence over and over again.
You can use the fourth parameter of reFind to get the position
Looks like my last reply was truncated. (Out of curiosity, I am resending a
cfscript version to see if the lack of tags makes a difference.)
cfscript
startAt = 1;
for (i = 1; i = ArrayLen(getMatches); i++) {
found = REFind(url.terms, DocContents, startAt, true);
//
Have you tried a regex replace of \x1a ? It *might* work. Worth a shot anyway.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive
of just getArt(). Try the
code in the Basic Example section. That should work for you.
http://www.codecurry.com/2009/12/introducing-wordart-for-coldfusion.html
-Leigh-
~|
Order the Adobe Coldfusion Anthology now!
http
{font=LinLibertine, fontstyle=bolditalic, fontSize=30}
Terry - Works perfectly with CF9. Any chance you are using CF8? I do not think
implicit structures were supported in function calls until CF9.
~|
Order the Adobe
Are you using POI directly or through some kind of wrapper (ie cfspreadsheet,
poiUtility.cfc, etcetera..)?
Can you post your code?
~|
Order the Adobe Coldfusion Anthology now!
No worries. It was a fun question .. and I learned something new myself. While
perusing the cfc source I figured out how to create the outer stroke effect :)
So this cfc will not work using CF8
I think it should work if you get rid of the CF9 specific syntax. But you would
have to try it
and the png images with superlong filenames are there.
I then hand typed the url to the images and they displayed perfectly.
The url in the generated image tags is probably pointing to the wrong location.
You can change the defaults for the various paths in the init() function: ie
init(
Terry - Sorry, I have no clue about a cause. But the error sounds vaguely
familiar. Check the CF bug database.
~|
Order the Adobe Coldfusion Anthology now!
Terry,
I do not see anything obviously wrong. Other than the very last line, it looks
the same. Here is the complete test code I used on CF8/CF9. The result is
green text with a purple-ish border
-Leigh
cfscript
width = 330;
height = 150;
text = Crossfade;
// Create
You are missing the code that draws the actual border.
// create a thin border
stroke = createObject(java, java.awt.BasicStroke).init( 1 );
graphics.setStroke( stroke ); // ** this line is missing
graphics.setColor( Color.decode(##80) ); //** this line is missing
I finally got it all pieced together and it works as you said it would.
Well the code may have gotten a bit garbled somewhere, adding to the confusion.
Sorry about that.
maybe make the stroke go outside instead of inside?
What do you mean by outside?
The font and stroke width can be
Is that a better explanation?
Yep. If you think about how the border effect is created, the behavior makes
sense. Basically you are working with a glyph, or a shape of the text. Stroking
affects how that shape is filled. It does not change the shape itself. So the
thickness has to move
Check out the Alagad Image Component
Yeah, I was going to suggest taking a look at existing image components. Do you
know if it supports text borders? Nothing jumped out at me from a brief look at
the documentation.
-Leigh
I just sent a request asking if his wordart.cfc is
still active and open source.
Great. I would be curious if there are any updates.
BTW: Did you try using the non-cfwheels syntax ie wordArt.getArt()?
Because that worked fine for me.
-Lei
This is the site with some docs and demos:
Wow .. that is very cool! I was about to post a simple example from an old blog
entry, but that totally blows mine out of the water.
Three cheers for the digital pack rat ;-)
-Leigh
Post it anyways. I am curious.
I skimmed the cfc and it is essentially doing the same things internally. Just
more and a lot fancier :) It grabs the underlying graphics and uses draw(),
setStroke(), etcetera to fill in the text, create borders, etcetera.
Here is an old entry on creating a
With a few small changes, it could fill in the text shape with one color and
use setStroke to create a border of another color:
ie Change these two lines:
graphics.setColor(textColor);
graphics.draw(shape);
... to something like this
// color in the text
Color =
What issue are you having with your code?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
MySQL does support dateDiff. But you could also use a simple date comparison
instead. Return one (1) if the item is on offer today, or zero (0) if it is
not.
SELECT
CASE WHEN offerStart = curDate() AND offerEnd = curDate() THEN 1 ELSE 0 END
AS IsOnOffer
It was successful, but hope there is a simple way to do it.
Unfortunately, I think that is as simple as it gets. AFAIK, CF does not let you
specify the formatting of query values. It always uses the cell format
information.
-Lei
where currentDate between offerStartDate and offerEndDate
Hm .. I may have misunderstood. If the goal is to retrieve *only* items that
are on special, go with Rick's suggestion.
-Leigh
~|
Order the Adobe Coldfusion
something like this (I think) after your cfsrpeeadsheet tag.
cfset spreadSheetFormatColumn(qryResult, {dataformat=mm/dd/yyy}, 1) /
Yep, essentially. But it needs to be applied before reading the sheet into a
query.
-Leig
Yeah, the solution is the same. You have to apply a format.
I also have a download function, in there I have formatted the column with
spreadSheetFormatColumn. If I use the downloaded file to upload, it reads
4 digits year.
But if I create a new spreadsheet to upload.
It only reads the
If I manually format the column, it still reads yy.
I am betting Excel is still registering the cell format as m/d/yy. Try using
m/d/;@
How can I programmatically format it before it reads the spreadsheet?
I do not think you can convert a spreadsheet object into a query directly. If
All you need is a reference to the POI workbook object. Just remember the sheet
index is zero based. ie 0 - first sheet, 1 - second sheet, etcetera.
cfset workbookObject.removeSheetAt( javacast(int, 0) )
~|
Order the Adobe
Is your class publically accessible? Are you using the full namespace with dot
notation ie If the namspace is COM and class name is Batch use
COM.Batch? Might also check the {cf_root}\jnbridge error logs. Depending on
the real error, it sometimes has more detailed error information
1 - 100 of 557 matches
Mail list logo
