Hi:
Due to some privacy issues I need to delete some of my posts and the replies to
them in House of fusion but the option is not available as a default one. Is it
a way? Please help me because the privacy issue is very important
All posts that go there also get sent out on the mailing list and
google tends to be pretty quick archiving them.
Even if you delete the post, it's likely that it's out there on the
net for good.
On Thu, May 27, 2010 at 10:34 AM, C S cortical...@yahoo.com wrote:
Hi:
Due to some
If you have a list of posts, I'll look at them for deletion and/or
editing. As stated by others, I can only do this 'locally' and it
will
not effect the various mirrors and archives of the lists.
I'm at a client and will not be able to address this until later
tonight or tomorrow. Sorry.
On Thu, May 27, 2010 at 11:55 AM, C S cortical...@yahoo.com wrote:
That's great. This is the best news for me. Even if it doesn't mean
it will be deleted from other copies, your effort means a world to me.
Tomorrow is just fine. I really really appreciate your effort and
can't thank you
Not the best option
What's a better option then?
I think it depends on what they actually need to do with the image. If they
just need to display it, reading the header bytes seems a bit awkward. So
something more dynamic would be better. (I posted one option in another
response)
Unable to find a constructor for class org.apache.axis.types.
NonNegativeInteger that accepts parameters of type ( java.lang.Integer
).
NonNegativeInteger is expecting a string (ie java.lang.String). Apparently
listLen(..) returns a java.lang.Integer:
cfoutput
ListLen() object type =
As for that link...oh my gosh...sql injection anyone?
+1
The estimation using LIMIT and FOUND_ROWS() seems okay. But I would re-write
the where clause logic to make it safer, and definitely use cfqueryparam.
~|
Want to
I'm using the following code to read an excel file. But it only runs
once and I have to restart coldfusion before it will be successful again,
...
rs.close();
I do not use dynamic odbc excel connections much. But one thing that jumps out
at me is you are closing the resultset, but not
What cfsqltype in a cfqueryparam should I use to insert now() into a
mySql database (datetime data type) so it keeps the date and time?
cf_sql_timestamp. You might double check your syntax and the data type. It
works fine for me.
INSERT INTO Table (DateTimeColumn)
VALUES ( cfqueryparam
Dumping the available methods on AudioFileFormat and putting around
the javadocs seems to imply that Type.WAVE is a static property,
which I understand CF can have problems accessing??
Type is an inner class. You can use $ to reference it:
cfset AudioFileFormatType = createObject(java,
My advice would be don't use CF to do this. DTS (or SSIS) is quite capable
of doing this in about 1/30 the time that CF is able to do this. One of our
DTS packages consumes a file of over 300k rows in less than 15 seconds every
few minutes. You can't get that with CF no matter how hard you try :)
At first they were talking about doing a CSV download and upload, to
which I replied hell no.
O.M.G. You may as well display names and SSN's randomly on the home page as an
ad banner. But it sounds like you will need some social security numbers for
testing. I am sure the clients would
What is the equivalent for columns ?
Could I output the Table's schema details ...
(column name, data type, size, format, NULL allowed ?, PrimaryKey, Indexes)
...ie: like a DUMP, without the data ?
Use information_schema to access database metadata
I am trying to trap an error when someone uploads a file that is 0
length. I get this error now
There may be a better option, but have you tried catching a specific exception
type? Look at the top of the stack trace. Then try and catch that exception
type.
cfcatch
...
cfcatch
But it is odd, indeed, why return anything at all.
It depends on the class. Some use it and some do not
http://java.sun.com/j2se/1.4.2/docs/api/java/util/AbstractCollection.html#add(java.lang.Object)
I don't believe that it ever does return false and the docs do not
indicate that it does.
Trying to resize a PNG with the following code and the image linked below
and it's coming out all screwy. Any ideas as to why this is happening?
Unfortunately, I do not know the cause. But are you sure it is the resize
operation? I get the same results just doing a simple read.
It may not be due to the java link. I found a reference that says
ArrayAppend returned a boolean back in the days of CF 4.5. So it may
just be a carry over.
This would suggest that it *would* be to do with the java link;
ColdFusion 4.5 was written in C++ ;)
No, I just meant that the
Ah, we are at cross wires!
Well that makes a lot more sense. That is what I get for only reading half of
the thread ...
Anyways, I wonder if the OP has found his solution yet ;)
Wait .. there was an OP? ;-)
~|
Adobe®
FROM
tableA p LEFT OUTER JOIN
tableB e ON (p.use_no = e.use_no AND p.year = e.year and
e.duplicate_set is not null) LEFT OUTER JOIN
tableB d ON (e.duplicate_set = d.duplicate_set AND e.year =
d.year)
Yes, I think that would work. There is probably a more elegant method, but
Maybe I need glasses, but I missing something here. The first three report
columns look like a count(*) from tableA by use_no and county. What is the
tie-in with TableB and the record_with_dups column?
county rec_type records record_with_dups
1 X 2 3
1
I think something like ((A join B on use_no) join A on county) union A
will effectively merge both table so you have all records full
complete in the result. Then you can window / partition that for yout
record_with_dups column.
Jochem
I am still wrapping my head around it. But from what I
cfimage's write to browser
function only used the png format which my system does not support.
The default is png, but you can specify another format like jpg. I do not
think gif is supported.
~|
Adobe® ColdFusion® 8
cfset PhotoLocation = http://mls.northernweb.net/images/Photo;
..
Any idea of what I am doing wrong? Is there a better way to test to see if a
file exists in order to avoid broken pictures on the page?
FileExists expects an absolute path, not a url
ie cfset PhotoLocation =
cfset PhotoLocation = http://mls.northernweb.net/images/Photo;
IIRC, FileExists expects an absolute path, not a url.
ie
cfset PhotoPath = c:\ColdFusion8\wwwroot\yoursite\yourImage.jpg
cfif FileExists(PhotoPath)
found
cfelse
not found
/cfif
Hi! Does anyone know which version of Axis (used by CF to consume
webservices) is shipped with CF8?
Version 1.2.1
cfset axis = createObject(java, org.apache.axis.Version)
cfoutput
version #axis.getVersion()#br
version text #axis.getVersionText()#br
/cfoutput
500 Event Handler Exception. That's all it says. I've turned on
debugging but it doesn't display any debugging information either.
What do your log files say?
Leigh
~|
Adobe® ColdFusion® 8 software 8 is the most important
Are you calling it with cfexecute or the commandline?
I've had ffmpeg do that to me with a precompiled version. Where did you get
your's from? Or did you build the latest?
Adrian
Adrian,
Did that happen with cfexecute, at the command line or both and what o/s? I am
wondering if this is a
I seem to remember a recent update that addressed an issue w/ ffmpeg
and cfexecute. Have you checked the hotfixes @ Adobe?
Yes, the issue was ffmpeg would hang. It was because ffmpeg writes to stdout
and stderr, but cfexecute was only capturing stdout. The pre-fix work-around
(for windows)
I found some javascript, but am not sure how I can implement it into a
CFFORM. I need twenty of these. Could anyone offer some advice on how
I can either do a ranked selection box or how I might be able to
implement this code?
The javascript is hardcoded to work with a single selected
In MS SQL Server it's ISNULL(), but can't speak for other platforms.
Can't recall what it is in Oracle, might just be NULL().
IIRC in Oracle it is NVL. There is also COALESCE, which is usually a safe bet
with most databases.
John Skrotzki wrote:
I want to use a java class for extracting email sections from .eml file
Just curious, what benefits does that jar offer you over plain javamail?
http://java.sun.com/products/javamail/
get yourself the latest version of eclipse, make sure you have the same JRE
installed on
You can also use the JDT compiler via JavaLoader, and compile and then
load the classes on the fly, within CF.
I like that a lot, personally. A fast way to do Java + CF.
I've got some code that does it, been meaning to wrap it up into a
little project or something.
Sounds interesting. Do have
In case anyone is interested, my brute force solution is below. She
aint pretty, but she works.
Mike,
That is not bad. But you could improve it even more if you looped by year,
instead of day. That would eliminate most of the iterations. Not highly tested,
but something like this.
Don't forget the one for CF9 as well.
http://labs.adobe.com/wiki/index.php/Centaur
What features are in Centaur?
Language Enhancements ... CFFINALLY and CFCONTINUE
Finally.. cffinally. It is about time ;-)
~|
Adobe®
Well I had other workarounds, but my intent was to findout what should
we do in cases like this.. How should I handle large integers?
It sounds like MOD only works with 32 bit integers. If that is the case, then
you will have to use another method, like the ones suggested or
Do I need to do some kind of a loop to get the subtotals for each
account? Thanks.
There are a few ways to do it. One option is to use a variable to accumulate
the subtotals within your inner cfoutput.
cfoutput query=GetCostSum group=Acct
strong#Acct#-6405/strongbr /
As a follow up here is what I have been currently trying but getting and
Exception occured in JPG processing. segment size would extend beyond file
stream length
Exception occured in JPG processing. segment size would extend beyond file
stream length
That may be an issue that was resolved in one
Darn, I forgot to post the second link:
http://www.garyrgilbert.com/blog/index.cfm/2007/9/28/CFIMAGE-Bug
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Thanks for the link to the House of Fusion archive. I found the solution in
the thread.
Just curious, what version are you using? I wondering if the problem was
resolved in later hotfixes, because the code worked for me.
Leigh
Leigh,
I'm using the same version that you are 8,0,1,195765.
Local is the Developers Edition on Vista 32 bit and on the server is
Enterprise Edition Windows Server 2003 R2 Standard 32 bit.
I could not get the code to work on either.
Okay. I thought it might be a version difference. But at
Have looked at the adminapi's datasoure.cfc, according to it, one
method named DeleteDatasource would require only one parameter of
dsnname to delete a current cf8 datasource but it didn't.
Did you login first?
cfscript
admin = createObject(component,cfide.adminapi.administrator);
I have a date represented as 993124800 in my database that php's
date() function is able understand and format. I'm running into dead
ends trying to have ColdFusion parse this date correctly. That date
should work out to...
That looks like an epoch time. Try
I'm trying to figure out if there's a way to programmatically
determine if a computer (with Windows OS including XP home/pro, Vista)
has .NET Framework 2.0 installed with DOS/Window's batch/utility
programming.
(Purely from a quick google..) what about checking the folder structure
I'm trying to figure out if there's a way to programmatically
Yeah, that's one approach, I now have some other ideas as well, thanks.
Let us know what you end up with. In case I ever need to do this in the future
;-)
~|
Check the registry.
Unfortunately, I did not know how to read registry from dos with xp. Thanks for
that. Learn something new every day ..
C:\reg query HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP
~|
Adobe®
Bobby is right and your approach is nice as well. And if I need to
check multiple programs, I may try the following:
regedit -e installedprograms.log
H KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
then try to find them in the extracted/exported file.
This approach
A small thing. When you click Profiles the menu disappears. So you can no
longer navigate unless you use the browser's back button.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get
Max((DateDiff('d',queryname.columnname,now( AS Age
Sum(IIf(DateDiff('d',queryname.columnname,now())=90,1,0)) AS Response
I do not think so. AFAIK, QoQ only support basic aggregate functions like MAX
and SUM, not DateDiff or IIF.
I've never really used the admin api until today. I'm having a problem
catching a bad login. I tried wrapping the instantiation/login in a
try catch, but it seems to be ignoring the catch. Is there any easy
way to catch a bad admin api login? I'm not seeing anything in the
docs or
Hi everybody !
I'm running Coldfusion 6.1
I would like to know if it si possible to display the value of a bar
above this bar?
It is possible with MX7. You can create a custom style, with a dataLabel
pattern $(value)%.
http://livedocs.adobe.com/coldfusion/7/htmldocs/1431.htm
But I
Think you'll have to force the download of the resized image but can't
you use cfcontent to delete it with deletefile=true ?
You could also try extracting the image bytes and using cfcontent's variable
attribute.
Leigh
~|
using your code on CF8 (8,0,0,176276), i get the structs returned in the
same order (alpha by key name) each time. neither arbitrary nor random.
With 8,0,1,195765 I get a different order each time. Unless I drop the
argument names.
cfset doStuff( 'first' , 'second' , 'third' ) /
That's pretty funky (the difference in behavior between hotfixes). Altho i
don't believe structs are inherently meant to be 'ordered'.
Yes, that is my understanding too. Interesting that it does seem to return the
correct order if you do not use named arguments.
cffunction name=doStuff
Well it has to really - unnamed arguments in a random order would be
impossible to use.
But it'd be handy if they made named arguments work in the right order
too.
{Smack} Of course the reason it works has nothing to do with arguments object
itself. Talk about Friday density ;-)
My
cfset active_photos = #replace(active_photos,
That just gave me a file with the text, active_photos, and a return
symbol after it...
Remove the quotes from active_photos so CF knows it is a variable to be
evaluated ;-)
cfset active_photos = #replace(active_photos,
#chr(10)chr(13)##chr(10)chr(13)#, , All)#
Also, check Barney's suggestion:
replace sequential newlines with a single newline and such.
~|
Adobe® ColdFusion® 8 software 8 is
I need to get rid of the column headers in the first line,
and then get rid of any linefeeds after the last piece of data.
This seemed fairly straightforward when I started...
...and it should still be fairly straightforward:
cfset data = listRest(data, chr(10)) /
cfset data = trim(data) /
When there are records with duplicate
emails addresses, I need to include one of them.
So you are trying to display one record for each email address?
You could try something like this. Not tested, but the idea is to select a
single PK for each email. Then use a JOIN to display the details
You could try something like this. Not tested, but the idea is to
select a single PK for each email. Then use a JOIN to display the
details for those PK's.
Note, the previous query assumes it does not matter which record is returned.
I need to get a record set used to pick a winner, including just one
of the records from the duplicate email entries.
If it does not matter which one, try the query I posted in my first response.
The syntax is not tested, but it has the right concept.
It also begs the question, if they were only supposed to have one
entry
per e-mail address, why wasn't there error checking or a constraint on
the table to force this in the first place?
True enough. I was thinking the same thing myself ;-)
I don't think it's a case issue. I tried it with mixed, all lower and
all upper and continue to get the same response.
Do any of these apply?
http://www.bennadel.com/blog/80-ColdFusion-SQL-Error-Table-Is-Not-Indexable-By-Name.htm
Any ideas anyone. :)
William
It depends on which driver you are using. Something like this should work with
ColdFusion 8. I have no clue if there any differences for remote databases ;-)
cfscript
Class =
createObject(java,java.lang.Class).forName(com.mysql.jdbc.Driver);
I've tried and got it all plugged in with no success and it would be
just my luck that the How To Use link would be broken on the website.
I have been working on it for about 4 hours. Time to ask for help.
Client is coming at 11 tomorrow and I have to have something for them
to look at.
I think I have everything correct, but the background of my
dynamically created image is black. Nothing I do will change that.
..
cfset myImage=ImageNew(,500,20)
Not to rule out other options, but try setting the background color when the
image object is created:
cfset
Yep, you are right. Works with jpg but not with gif or png.
It may have to do with the color pallete of the gif you are using. For example
if you run the following code, the text appears red on the Google logo.
Presumably because the logo's color palette contains red, or a very similar
color.
Perhaps it has to do with the color palette that the .gif
is created with?
Yes, I think so too.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Just to follow up: From what I can tell you cannot use special characters with
the find + replace option in the Studio Express _editor_. I ended up using
another editor.
Thanks for the response Sonny. I know my original question was about as clear
as .. mud ;-)
OT: SQL 2005 Studio Express - find and replace with newline character
Does anyone know how to find and a character and replace it _with_ a newline
using SQL Server 2005 Studio Express? For example, I would like to replace all
|'s in the following string
one|two|three|four|five|six
So
CHAR(13) + CHAR(10)
Thanks, but I mean using Studio Express's find + replace option. It is such a
simple thing, but it has me stumped. I have tried every combination I can think
of. No joy.
~|
Adobe® ColdFusion® 8 software 8
You're doing a code search? I assumed you were trying to format data being
returned by a query.
Sort of. I am working with some ad-hoc sql scripts. Sorry, if I was not clear.
I know this is OT. I posted in the hopes that someone else using Express Studio
might know the magical character(s).
cfprocparam dbvarname=@affiliateID
variable=#val(arguments.affiliateID)# cfsqltype=CF_SQL_INTEGER /
I think the attribute should be value not variable. Also, I thought
dbvarname was deprecated ?
~|
Adobe® ColdFusion®
Keep in mind I am reading this with only half a brain today ..
Here is what I have now.
cfoutputcfsavecontent variable=querytouselogparser select *
from C:\ColdFusion8\logs\application.log
-i:csv/cfsavecontent/cfoutput
It looks like you have the .exe (logparser) in the arguments. If that
ie. ditch the logparser command
Yes .. what he said ;-)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
Just remember to add 1 to the result.
And remember java will perform a case sensitive search. So indexOf(XYZ) may
return different results than indexOf(xyz).
cfset myArray = [ apple, xyz, orange, pear]
cfset index1 = myArray.indexOf(XYZ) + 1
cfset index2 = myArray.indexOf(xyz) + 1
cfoutput
therefore how would you translate this formatting stated above
cfscript
outFile = createObject(java, java.io.File).init( e:\temp\excel\test.xls
);
workBook=createObject(java,jxl.Workbook).createWorkbook(outFile);
labelObj=createObject(java,jxl.write.Label);
Here is a down-and-dirty example.
I realized the snippet above does not account for lines broken across the
grabBytes barrier. So that alteration is needed. But the code snippet should
give the basic idea at least.
~|
I haven't tried it myself, but Java does have a tail command that
should do exactly what you want.
m!ke
That sounds very promising. I will take a look at that. Thanks.
~|
Adobe® ColdFusion® 8 software 8 is the most important
I haven't tried it myself, but Java does have a tail command that
should do exactly what you want.
m!ke
Michael,
I have done some searching, but I am still unclear on the tail command. I may
be overlooking the obvious, as I have not had my full measure of coffee yet ;-)
Can you tell me a
Sorry for the confusion. I meant OS rather than Java. It's been a
long week for me. ;^)
If it helps, you are not the only one .. ;-)
If you are on *nix, there is a built-in tail command.
Yes, it has been a while, but *nix tail was my first thought. But I guess I
was still hoping there was
You could shell out (CFEXECUTE) the tail command to get those lines.
Michael,
Good suggestion. Tail works very well. Cheers.
cfset numOfLines = 10
cfset logFilePath = server.coldFusion.rootDir /logs/exception.log
cfexecute name=c:\program files\Windows Resource Kits\tools\tail.exe
I have a log file that I'm looking to parse. I only care about the
last entry. Is it possible to read in the file, then loop over it from
the end, rather than the beginning? Here's the code I've got right now.
It works well, but why loop over parts that aren't needed right?
I do not think
Actually, to answer my own question, I think that if I call the close()
method for the passed JDBC recordset after I've done with using it in other
methods then this should do the trick. Am I right?
Actually, to answer my own question, I think that if I call the close()
method for the passed
Yes, I can convert it into a cfquery object, and a lot of the time I will,
but I also want to be able to insert the data into another table in another
db which I can do directly rather than converting it to a query first.
Hence the reason to split it into separate methods.
Personally I would
select *, exists (
select *
from orders
where date between #date1# and #date2#
) as hasOrdered
from customers
order by name, id
Use CFQUERYPARAM, of course.
Another variation is a left join. Ditto on using cfqueryparam.
SELECT
c.ID,
c.Name,
c.Email,
SUM(CASE WHEN o.Date IS NULL THEN 0
I dont believe this is working with Access DB
SUM(CASE WHEN o.Date IS NULL THEN 0 ELSE 1 END) ordersFound
I think Access's version of CASE is IIF(..). Try using IIF instead and also try
the query Barney suggested. One of them should work.
It is like sox
isn't closing and leaving memory like it should be, but if I run it
directly from the command line, I don't have that problem.
Try Ben Forta's tip of adding /c as an argument. This tells the command
interpreter to run and terminate upon completion. I had a similar problem
Just curious, what is the method signature? I would have expected
ArrayList, Vector, etcetera to work, since they all implement java.
util.List.
Also, what does your java wrapper look like?
~|
Adobe® ColdFusion® 8
i'm working with an incredibly picky java lib. one key method requires a java
List (really, it barfs on ArrayList, etc.).
Just curious, what is the method signature? I would have expected ArrayList,
Vector, etcetera to work, since they all implement java.util.List.
me too but as i said it's incredibly picky (it being jfreechart). it wants a
java.util.List nothing else. it's signature:
You are not kidding. It does seem to be picky.
Can you psych-it-out by using java.util.Arrays.asList(...)?
A List is a List. There has to be some other explanation for the
weirdness.
Duh! I was accidentally calling init(). Obviously that does not work with an
abstract class ;)
This seems to work:
cfscript
cfArray = [ javacast(double, 15.0), javacast(double, 22.5) ];
Box = createObject(java,
Paul, what exactly is the error? Is CF not finding it?
Can we see the code you're attempting at least?
Yes, please. Because I am able to pass in a CF array without problem. Granted,
I am using an abstract class.
~|
Adobe®
cfheader name=content-length value=#ArrayLen(ExcelByteData)#/
cfheader name=content-disposition value=attachment; filename=#xls_file#
..
Obviously this is because 6 doesn't have this attribute.
Assuming you do not wish to write the bytes to disk, you could write to the
response outputstream.
I can create this class with CreateObject(Java,
coldfusion.sql.QueryTable) from a CF page, but my java code (running
in the same JVM, configured as a servlet) apparently cannot.
BTW, I compile the java code using a reference to the cfusion.jar file
on my local machine; the code only runs inside a
I get an error
Variable TEMP is undefined.
I get an error too.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
cfset list = valuelist(myquery.columnName) /
... or use the QuotedValueList() function, if the values need to be quoted.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
It's a CGI var, which means it will exist on some servers and not others.
Cool. I did not realize that.
I didn't realise that the cgi 'scope' was searched automatically by CF when
trying to identify a variable. Why oh why?!
I forgot how many scopes CF searches. One more reason to scope
cfqueryparam doesn't care that the input is not quoted:
Duh! Even better.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
The biggest problem I am having is getting the columns for the form to
line up properly (they are a series of radio buttons). I can get all of
the values and the text fields fill in properly. The radio button values
fill in with what I select, just not in the correct column.
Did you ever try
The problem with that is the same problem as the previous example I
posted though.
Try searching for dates between 10/15/2006 and 04/14/2007
Given those search dates, how do you want to handle records with a year only
(2006 or 2007). Same question for the month.
1 - 100 of 156 matches
Mail list logo
