that something running ON the server that is supposed
to send you this email is probably not going to work if its running on the
service you are trying to monitor.
On 4/1/14, 12:11 PM, morchella morchella.delici...@gmail.com wrote:
looks like onServerStart is turned off. i cant change that on our
so i am trying some thing out on localhost befor i move to dev
i want to know when my cf server was started or restarted.
so after my onApplicationStart
i put in a cfmail and fir up an instance of cf9 for my localhost.
i dont get the email unless i actually goto 127.x.x.x to view a page.
i
onServerStart and Server.cfc
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WS7AC9408A-1AC6-4ab7-9C8
E-CF1DA8FCA16D.html
On 4/1/14, 11:31 AM, morchella morchella.delici...@gmail.com wrote:
so i am trying some thing out on localhost befor i move to dev
i want to know when my cf server
looks like onServerStart is turned off. i cant change that on our server.
On Tue, Apr 1, 2014 at 11:49 AM, morchella morchella.delici...@gmail.comwrote:
thanks guys! i was unfamilar with onServerStart. looking now!
Much appreciated!
On Tue, Apr 1, 2014 at 11:44 AM, Bobby bo
so we have some people at the top here wanting us to switch from cf to
groovy.
i have no control other then will support all apps until this thing happens.
so was curious if any one here has done any groovy stuff, and what advice
they could give to a old man who has done cf since 1998.
i don't
yeah, i get it.. just stuborn.
was hoping there was something as good as the WACK book.
alot of stuff i am seeing just isnt pasionate, compelling, et.
-m
~|
Order the Adobe Coldfusion Anthology now!
Dave i agree completly. questions like that are not appreciated where i am
currently!
i have found some basic tut's and will go through them. hopfuly i can set
up a test env on local machine without needing admin right to instal the
JDK.
hate being on lockdown. i need to change my outlook as
Thanks guys! As always your opinions and replies are valued and taken to
heart!
time for a new hat!
On Mon, Mar 17, 2014 at 10:16 AM, C. Hatton Humphrey chumph...@gmail.comwrote:
On Mon, Mar 17, 2014 at 9:59 AM, Dave Watts dwa...@figleaf.com wrote:
That said, it may not actually be the
...@gmail.com wrote:
Is it possible there is whitespace appended to some of the array values?
Byron Mann
Lead Engineer Architect
HostMySite.com
On Feb 27, 2014 7:32 PM, morchella morchella.delici...@gmail.com
wrote:
hey guys i have two, 2 dimensional arrays.
they have 3
hey guys i have two, 2 dimensional arrays.
they have 3 columns.
i have used #array2.equals(array1)# to show when they are difference and then
just continue with normal logic.
but now i have an instance where they say no the don't equal.
but for the life of me i cant visually see the difference
Hey Guys, i know this is not necessarily a cf question.
i know next to nothing about java, other then creating a scheduled job to
copy a table.
now my employer has tasked me with moving or backing up a MySQL DB from one
server to another.
to me this sounds crazy. but i am not supposed to use
They turned this off on one of our servers. we do not have access to cfadmin.
can any one think of a way to output the names of dsn's set up on a
server without having access to java objects?
any help would be appreciated!
-m
Detail Access to Java objects in the ColdFusion package has been
Thanks Guys.
Was just given access to readonly cfadmin where i can do debuggning
and see dsn's
they are/is current employer.
~|
Order the Adobe Coldfusion Anthology now!
i am stuck.
cant show any code. but most of it is old.
tried to stick a simple move multi select box into an existing page that
does all sort of ajax call i can figure out.
the jq stuff work fine in most/90% of the site
just this one page it is confusing me..
may have to re-write the form.
hey guys!
i could use a liitle help. i am trying to get a specific value. in this
example chapter_id
ListgetAt could work, but the returned form url cold have the value in a
different oposition at any time.
i thought i could use a delimiter specifiying ,chapter_id= but that dosnt
seem to work.
, Inc.*
ma...@assetresearch.com mailto:ma...@assetresearch.com
On 11/15/2012 7:28 AM, morchella wrote:
hey guys!
i could use a liitle help. i am trying to get a specific value. in this
example chapter_id
ListgetAt could work, but the returned form url cold have the value in a
different
,?) /
cfset p = listtoarray(params, ) /
cfset chapter_id = 0 /
cfloop array=#p# index=i
cfif find(chapter_id=, i)
cfset chapter_id = listgetat(i, 2, =) /
/cfif
/cfloop
cfdump var=#chapter_id# /
On Thu, Nov 15, 2012 at 8:28 AM, morchella
morchella.delici
not sure what the listgetat 2 is doing?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
are there any articles you could recomend.
my solution works but that sounds pretty slick.
i am googling log4j ColdFusion
~|
Order the Adobe Coldfusion Anthology now!
is there a way that if logging is truned of for a cf site to recreate
say, mailsent.log just through cfm in say, an include in
application.cfm?
dosnt need to be fancy.
just would like the same info for an application. but the place it is
sitting has logs disapbled,.
Thanks Dave.
I dont have access to log dit.
i just did a little cffile and apended data i needed to a new line.
simple. would have rather used the mailsent.log format.
On Thu, Sep 13, 2012 at 1:55 PM, Dave Watts dwa...@figleaf.com wrote:
is there a way that if logging is truned of for a cf
ok i am not getting it. this is what i have
the cfc that uses JSONUtil to initialize results, but dont htink i am
passing them back?
!--- get Metric ---
cffunction name=getMetrics access=remote
cfargument name=business_unit type=string required=yes!--- (xxa,
xxv, ET) ---
cfset var qry_Metric =
so use something like this to return my query to the cfc called in your
example.
http://jsonutil.riaforge.org/
was told i would be on cf 10. ha!
~|
Order the Adobe Coldfusion Anthology now!
Hey Guys.
I need to be able to have 2,3 or 5 selects related.
CF server 7, latest jquery lib.
I have looked at the relevant examples i could find. but not sure how to
make them work with standard cfc functions/query's
=json was added in CF8 or 7.
If it was 8, then you need to write a CFM that uses a JSON CFC (check
RIAForge, there should be a bunch) to generate a JSON result from the
data.
On Sat, Jun 30, 2012 at 10:22 AM, morchella
morchella.delici...@gmail.com wrote:
Hey Guys.
I need to be able
well this was an easy fix.
in CfAdmin there is a setting under the Advanced Settings to Enable binary
large object retrieval (BLOB). In my case, it was unchecked. On the New
server instance.
On Jan 30, 2012 7:13 PM, morchella morchella.delici...@gmail.com wrote:
so we have our file data stored
so we have our file data stored in a blob.
upgrading from websphere cf7 to jboss. cf9
for some reason i cant for the life of me trouble shoot correctly.
some/most xls are no longer downloading correctly.
if i upload a simple xls it works.
so does an xls.
but existing binary data from a blob
Hey guys. Long time no post. Any help and or advice would be greatly
appreciated. i will respond as time allows.
this one has got me scratching my head.
Upgrading from cf 7 to 9. from webSphere to jBoss.
jboss-5.0.1.GA, apache2-2.2.10-2.24.5
Jboss one box Apache on another..
if we use default
hey guys. i am trying to get a simple trigger to work.
if i update a field then it sets the corresponding fields with a date.
but the code below when u update the field it then updates ALL fields in table
with said date.
i am sure i just need to pass the pkey as a @var to a where clause.
but i
got it...
gerr...
CREATE TRIGGER trig_Update_Waive_Date
ON customer
FOR UPDATE
AS
IF UPDATE(waive)
BEGIN
UPDATE customer
SET waive_date = getdate()
where pkey=(Select pkey from Inserted)
END
just under a gigabyte.
i need to find an example on getting record count of source table and looping
the inserts say 1000 at a time.
right now its just delete destination grab source and insert into destination.
but google is failing me..
ssis loop recordcount insert
Hey Guys.
i need to
BACKUP DATABASE Northwind TO DISK='C:\Northwind.BAK' WITH
MEDIAPASSWORD='mssqltips'
but i have a user table, with passwords i need to hash or remove. but
i am not sure how to do this with out messing up the data, i need to
keep..
thanks for any ideas..
-m
nm.
just copy db to new db name.
edit out crap, back up, and done.
On Mon, Mar 15, 2010 at 11:08 AM, morchella
morchella.delici...@gmail.com wrote:
Hey Guys.
i need to
BACKUP DATABASE Northwind TO DISK='C:\Northwind.BAK' WITH
MEDIAPASSWORD='mssqltips'
but i have a user table
hey guys.
i know cfgrid flash doesn't support href in cfgridcolumn
but there has to be a way?
cfgrid name=hoverArea query=gHa selectmode=edit format=flash
height=210 width=800 rowheaders=no
onchange=getUrl('_edit_hoverArea.cfm?ha_1Id=' +
hoverArea.dataProvider[hoverArea.selectedIndex]['ha_Id']);
ok i have set up a new site in IIS.
now on a page that has a simple link
it is being appended with the site IP
so link looks like http://12.345.678.910/www.google.com
instead of http://www.google.com
i am sure i have seen this in the past, just not sure where to look.
or what to change.
a href=''www.google.comsome example link/a
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
o man.
i was kidding when i told my wife the reason my eye is blood shot is
was that i had a stroke.
now i am worried..
thanks guys..
wth..
o_O
~|
Want to reach the ColdFusion community with something they want? Let them know
ok how do i catch this??
i have old data and images that where .uploaded. some one did a bunch of
gif's but named them jpg.
so i am using cfimage to display width and hieght. but it pucks when it trys
to read the jpg..
cfoutput query=getPonyLogo
cfif LEN(TRIM(#pony_logo#))
cfset iTempDir =
thanks guys..
i seems we just need to reformat the images.
and fix info in db..
then catch any crud on upload.
On Tue, Nov 17, 2009 at 11:41 AM, Leigh cfsearch...@yahoo.com wrote:
I do not know. On the one hand it would be nice if it could guess a bit
better. But on the other, these images
Hey Guys!
http://63.144.103.199/FORMS/temp/2select.cfm?xp1DayId=10006
i am trying to bind the 2nd selecty max value to the selcted value of the
first select
so say first select is 1 to 5 and user selects 3, then the 2nd select would
be a loop from 1 to 3
the value of the text field is the max
Hey Guys..
dRange should be 1,4,5.i want to remove vRange from nRange
but what i get is...
nRange: 1, 2, 3, 4, 5
vRange: 2,3
dRange: 1, 3, 4, 5
cfset nRange = 1, 2, 3, 4, 5
i am inside a cfoutput query...
nRange: #nRange#br /
Cfset vRange = #ValueList(rs_RFQ.xpNum,,)#
cfset dRange =
got it..
but its ugly
Cfset vRange = #ValueList(rs_RFQ.xpNum,,)#
cfset dRange = #ReplaceList(nRange,#vRange#, )#
select name=x
cfloop index=i list=#dRange# delimiters=,
cfif #i# NEQ option value=#i##i#/option/cfif
/cfloop
/select
= ReplaceList( numbers, numbersToExclude, ',' ) /
select name=x
cfloop index=i list=#numbers#
cfif Val(i)option value=#i##i#/option/cfif
/cfloop
/select
Dominic
2009/4/13 morchella morchella.delici...@gmail.com:
got it..
but its ugly
Cfset vRange = #ValueList(rs_RFQ.xpNum
because they mhey not use you as a consultant any longer...they mhey be
trying to cut costs hire some one they can count on as every thing shrinks
inward.
i would take a full time gig with benefits over loosing a client that feeds
you 40 hours a week.
then again, i may take a 25k pay cut to cut
does Justin's file redirect the intruder?
i tried passing
/products/index.cfm?n1Id=1FOREIGN=test
but nothing happened
i am including the file in my application.cfm
modified the email such..
how can i test it
~|
Adobe®
i have two places that call the same form
here it validates just fine before the submit
http://rittal-corp.com/products/index.cfm?n1ID=1n2ID=1n3ID=1
but here
http://rittal-corp.com/products/product_details.cfm?n1Id=1n2Id=1n3Id=1pn=1500510
it validates, but stills submits with out forcing you to
http://63.144.103.199/products/partNumsTab3.cfm?n1ID=5n2ID=43n3ID=133
ok i am not getting the results i am expecting.
i took the spaces out of the db..
but Cable Management still shows multiples.
tried adding a ',' to the cfset so when the list loops it makes it one list.
bbut its not removing
i have some duplicates in a list i need to delete
but am not getting it once again.
cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter
cfoutput group=specs_partnum
cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)#
cfset acccL = ListSort(#acccL#,text, ASC)
all that seems to do is to remove the commas?
cfoutput query=getAce group=title
#title# xbr /
cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter
cfoutput group=specs_partnum
cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)#
cfset acccL = '#acccL#,'
thanks guys.
will try that in the morning.
such a beautiful day!
~|
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
ok i have a query
SELECT TOP 100 PERCENT LEFT(dbo.NavTitle.titleName, PATINDEX('%[_]%',
dbo.NavTitle.titleName) - 1) AS title, dbo.NavAccessory.specs_partnum
FROM dbo.NavAccessory INNER JOIN
dbo.NavTitle ON dbo.NavAccessory.titleID =
dbo.NavTitle.titleID
WHERE
nm, got it.
~|
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
Archive:
ok. i am having a serious brain fart...
i know there is a beter way to ooutput a list the is comma seperated then
this..
cfloop query=getProd
cfset columns = columns#specs_partnum#,
/cfloop
!--- remove the last comma ---
cfset columns = left(columns,evaluate(len(columns) -1))
awsome...
thank you!
now.. =]
how would i remove doubles?
!--- List of Accessory's that are assigned to this product ---
cfquery name=getAccessory datasource=listit
SELECT DISTINCT ascList
FROM dbo.list
WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL)
/cfquery
gives me...
also why is it not listed in my wack books under functions?
also where did functions go in the 8 series of wack books..
i know its there in 4.5-7...
On Tue, May 13, 2008 at 11:46 AM, morchella [EMAIL PROTECTED]
wrote:
awsome...
thank you!
now.. =]
how would i remove doubles?
!--- List
PROTECTED]
wrote:
If you're doing a distinct in your query, or a group by, then you
shouldn't
have any dupes.
-Original Message-
From: morchella [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 13, 2008 10:47 AM
To: CF-Talk
Subject: Re: easy one! : comma separated list from cfoutput
Ian, Thank You!
http://63.144.103.199/products/index.cfm?n1ID=5n2ID=46n3ID=148
cant really even to attempt to explain the db structure...
never worked with arrays or structures.
i do appreciate it..
On Tue, May 13, 2008 at 2:12 PM, Ian Skinner [EMAIL PROTECTED] wrote:
Paul Ihrig wrote:
lets
bump..
any ideas how to do this?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
ok i have a .xls
with a field called zip, it will have values like this
43202
43206
43207
43208
43212
in my sql table, i have from_zip ans to_zip.
so i would like to see if the zip in the xls file is concurent, if so
put the lowest value in from highest value in to. IF NOT just put
from too to
hey guys!
i need a little sql help/advice.
i have a table that has 2 columns
from_zip
to_zip
i get xls files from people in the office with massive zip entries.
like:
Zip Code
20106
22002
22401
22402
22404
22407
22408
22412
i want to go through this file and create the from/to fields...
is there a dummies version?
over the next 3 weeks or so i am tasked with figuring out what is
needed on half dozen live servers/domains countless temp crap...
coping it all to a virtual server set up.
as well as sql2000 db's...?
upgrading/install cf8ent currently every thing is 7
cleaning it
thank you dave..
your advice is always appreciated...
few quick questions.
will it move iis settings and such.
what about macros that may interact with current sql server, that i
may NOT be aware of since i am no dba...
is there a easy way to macro un/pw replacement as well as ip/port replacement
. Count(*) will always return an int - so using isNULL and
count together is not possible - plus you are mixing data types if you are
trying to return a 0.1 to a function call designed to return an int.
-Original Message-
From: morchella [mailto:[EMAIL PROTECTED]
Sent: Thursday
i have been trying to figure out how to check for null like whats done
in this url:
http://www.bennadel.com/blog/984-Using-NULLIF-To-Prevent-Divide-By-Zero-Errors-In-SQL.htm
SELECT
(
ISNULL(
(45 / NULLIF( 0, 0 )),
0
)
) AS value
how would i re write the code below to check for null
i can then
(SELECT ISNULL(COUNT(*),0)
FROM Emp
WHERE emp_assID = rEmp.empID AND addSale = 1) * 100 /
NULLIF((SELECT COUNT(*)
FROM Emp
WHERE emp_assID = rEmp.empID AND ((Emp.Qal = 4) OR
(Emp.addSale = 1))) AS perEmp
worked really well
thanks for all the help... Adam Dominic!
hey guys.
this is a 2 parter.
i have a table i need to fix. i have no real idea how to do this. the
problem is the Contact filed.
the first several thousand entries combine fnme lname into this one field
from a xls file.
then maybe 20,000 entries only have a name with a space in the Contact
with G..
So try something like
select * from tbl where name like '% ';
That will catch anything with a trailing space.
Just a heads up..
On Jan 3, 2008 9:03 AM, morchella [EMAIL PROTECTED] wrote:
hey guys.
this is a 2 parter.
i have a table i need to fix. i have no real idea how
ok..
thank you!
SELECT id, Contact, Address, City, State, Zip
FROM Leads
WHERE (Contact LIKE '') OR
(Contact LIKE ' ') OR
(Contact NOT LIKE '% % ')
AND (LTRIM(RTRIM(Contact)) NOT LIKE '% %')
ORDER BY id
now to fix 20,000+ records!
Mark
i am trying to find where only the lastname was added to the field Contact.
some 2000+ records. then do a match on a known field like email or phone
then update the Contact field with the combined 'fname lname' from a xls
spread sheet.
then after all the names are combined i will just add 2
ok not sure what i am doing wrong
in my out put it does the count just fine, but i cant get it to SUM up the
totals.
error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '*'.
cfquery datasource=myBD name=get_totals
Select Count(*) AS total,
SUM(*) AS Sumtotal
nm
cfset Sumtotal = 0
just had to nest cfset Sumtotal = Sumtotal + get_totals
honestly i already have all every thing i need dont inside of a nested loop.
but some one said doing it with q0q inside nested ouptuts would put less
strain on the server.
Is this true?
OK...
very cool.
i am not familiar with sub queries.
will have to google.
On Jan 1, 2008 1:32 PM, Greg Morphis [EMAIL PROTECTED] wrote:
use a subquery..
select sum(foo) as daSum
from
(
select count(goo) as foo
from table
where hoo = 1
)
On Jan 1, 2008 12:14 PM, Paul Ihrig [EMAIL
ok..
i did this
cfquery datasource=myBD name=get_totals
Select SUM(total) AS Sumtotal
From (
Select Count(*) AS total
From employees
WHERE emp_assigned = #get_Emp.usr_id#
) AS derived_table
/cfquery
but now i cant call the variable total to show with in my page?
it shows Sumtotal
thats what i just said.
i can now get #get_totals.Sumtotal#
but not #get_totals.total#
where befor i could get either using a qoq.
cfquery datasource=myBD name=get_totals
Select SUM(total) AS Sumtotal
From (
Select Count(*) AS total
From employees
WHERE emp_assigned =
1, 2008 1:47 PM, morchella [EMAIL PROTECTED] wrote:
thats what i just said.
i can now get #get_totals.Sumtotal#
but not #get_totals.total#
where befor i could get either using a qoq.
cfquery datasource=myBD name=get_totals
Select SUM(total) AS Sumtotal
From (
Select Count
never mind...
i didnt nest correctly.
it is slick now..
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
hey guys.
for the life of me i cant get it to ok with a record set out put into a table.
if i add static tr's above where the code loops to make a datagrid of
sorts the static stuff will sort, but not the trs with data pulled in
from a db..
any ideas?
this probably dosnt make any sense
77 matches
Mail list logo
