RE: regex help for grabbing values of html tag attributes
Google doesn't put quotes around most attributes. The following works
(takes single or double quotes or even no quotes into consideration).
Watch out for wrapping in the regular expressions. It allows you to find
the value of 1 attribute in one or more tags (see examples).
cfscript
function GetAttributeValue(str,tag,attr){
var regexp =
(#tag#)\s[^]*#attr#=('.*?'|.*?|[^\s]+)[^]*;
var aReturn = ArrayNew(1);
var start = 1;
var stTmp = StructNew();
while(true){
stTmp = REFindNoCase(regexp,str,start,true);
if(stTmp.pos[1] IS 0) break;
ArrayAppend(aReturn,REReplace(Mid(str,stTmp.pos[3],stTmp.len[3]),^[']
(.*)[']$,\1));
start = stTmp.pos[1] + stTmp.len[1];
}
return aReturn;
}
/cfscript
cfhttp url=http://www.google.com/; throwonerror=yes/cfhttp
cfoutput#HTMLCodeFormat(cfhttp.filecontent)#/cfoutput
cfdump var=#GetAttributeValue(cfhttp.filecontent,'a','href')#
cfdump var=#GetAttributeValue(cfhttp.filecontent,'img','src')#
cfdump var=#GetAttributeValue(cfhttp.filecontent,'a|td','class')#
Pascal
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 22 March 2005 22:59
To: CF-Talk
Subject: RE: regex help for grabbing values of html tag attributes
Ben,
I can see what you've got (I think) and it makes sense, but for some
reason, it's not working. I'm grabbing the html from www.google.com
and
running it on it and this is what I've got in my code:
#refindnocase('img.*?src=(.*?).*?',cfhttp.fileContent,0,true)#
I'm using cfdump to display that info and what I see are 2 arrays
(len
and pos) and both have values of 1 and 0. I thought that if the first
value was 1, the second value would be the position of the occurrence
of
the search string. I know google has an image, and I'm displaying the
cfhttp.filecontent in a textarea above so that I can ensure the
results
are coming back as expected. Any ideas? Am I doing something wrong?
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 4:54 PM
To: CF-Talk
Subject: Re: regex help for grabbing values of html tag attributes
Well, I see a couple of problems with what you're using. First,
you've
not got a closing on the attribute. Second, you've wrapped a regex
that contains a in 's, which will error out if you don't escape
the
inner 's. You can wrap it with single quotes to fix that. Also, the
last * boggles me. I don't know why it's there.
Or, try this:
'#tag#.*?#att#=(.*?).*?'
where (should be obvious) tag and att are defined as the tag and
attribute you want. Please note that if you define them as span and
class and you have this:
spanstuff in betweenspan class=bob the whole tag match will
return both span tags and the stuff in between. The attribute match
will return bob. So, if this might be the case, lemme know and we'll
tweak the regex.
Not tested, your miles may vary, trix are for kids, etc.
--Ben
Burns, John D wrote:
6.1. I was looking at the archives and have come up with this but
it's erroring
I'm using the img instance because it's easier to test on pages that
have multiple images...
#refindnocase(img[^]*src=([^]*)*,cfhttp.fileContent,0,true)#
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199743
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help for grabbing values of html tag attributes
Google doesn't put quotes around most attributes. The following works
(takes single or double quotes or even no quotes into consideration).
Watch out for wrapping in the regular expressions. It allows you to find
the value of 1 attribute in one or more tags (see examples).
cfscript
function GetAttributeValue(str,tag,attr){
var regexp =
(#tag#)\s[^]*#attr#=('.*?'|.*?|[^\s]+)[^]*;
var aReturn = ArrayNew(1);
var start = 1;
var stTmp = StructNew();
while(true){
stTmp = REFindNoCase(regexp,str,start,true);
if(stTmp.pos[1] IS 0) break;
ArrayAppend(aReturn,REReplace(Mid(str,stTmp.pos[3],stTmp.len[3]),^[']
(.*)[']$,\1));
start = stTmp.pos[1] + stTmp.len[1];
}
return aReturn;
}
/cfscript
cfhttp url=http://www.google.com/; throwonerror=yes/cfhttp
cfoutput#HTMLCodeFormat(cfhttp.filecontent)#/cfoutput
cfdump var=#GetAttributeValue(cfhttp.filecontent,'a','href')#
cfdump var=#GetAttributeValue(cfhttp.filecontent,'img','src')#
cfdump var=#GetAttributeValue(cfhttp.filecontent,'a|td','class')#
Pascal
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 22 March 2005 22:59
To: CF-Talk
Subject: RE: regex help for grabbing values of html tag attributes
Ben,
I can see what you've got (I think) and it makes sense, but for some
reason, it's not working. I'm grabbing the html from www.google.com
and
running it on it and this is what I've got in my code:
#refindnocase('img.*?src=(.*?).*?',cfhttp.fileContent,0,true)#
I'm using cfdump to display that info and what I see are 2 arrays
(len
and pos) and both have values of 1 and 0. I thought that if the first
value was 1, the second value would be the position of the occurrence
of
the search string. I know google has an image, and I'm displaying the
cfhttp.filecontent in a textarea above so that I can ensure the
results
are coming back as expected. Any ideas? Am I doing something wrong?
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199744
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Extracting/Replacing URL's from text
Regexp can do it for you: cfscript newurl = new url to prepend/; regexp = (a\s[^]*href=)(.*?)([^]*); newtext = REReplaceNoCase(text,regexp,\1#newurl#\2\3,all); /cfscript This only takes links into consideration and the url has to be surrounded by double quotes. If the href attribute can have double, single or no quotes around the value, it needs a bit more work (a loop). You can get inspiration from my post in the thread regexp help ... from this morning (http://www.houseoffusion.com/lists.cfm/link=i:4:199744). Pascal -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 08:37 To: CF-Talk Subject: RE: Extracting/Replacing URL's from text Actually, this is a bit too simplified because what I needed was a way to search for url's in a body of text without knowing what they are. Here's what I came up with...a little custom tag called CF_GetLinkList. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Extracting/Replacing URL's from text
Do you have the ability to retrieve them with Javascript? A while ago I did some testing of a linkchecker with Javascript to take away some of the load from the server (but it failed due to cross domain security settings in IE). http://www.mschopman.demon.nl/linkchecker.html The link extracting however works perfectly. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: woensdag 23 maart 2005 8:37 To: CF-Talk Subject: RE: Extracting/Replacing URL's from text Actually, this is a bit too simplified because what I needed was a way to search for url's in a body of text without knowing what they are. Here's what I came up with...a little custom tag called CF_GetLinkList. If anyone can find holes in this, let me know...so far it seems to be working fairly well...basically, it will take a body of text (html obviously) and pull out all the URL's from that body of text. I'm sure there's something else out there (and maybe something a bit more sophisticated) but this is working for me, for now. After using this tag to get the links, I then loop through the LinkList and replace each one with my new link. Here's the code for the tag in case anyone's interested (this assumes that the first character at the end of an 'href' value will always be either a space, a single quote, a double quote, or a greater than sign. If I need to check for any other possibility, please let me know. !--- cf_getlinksfromtext REQUIRED ATTRIBUTES: TEXT = body of text you wish to search for links OPTIONAL ATTRIBUTES: VAR = name of variable to store the link list - defaults to: LinkList --- CFPARAM NAME=ATTRIBUTES.Var DEFAULT=LinkList CFSET EndListToCheck = chr(32) chr(34) chr(39) chr(62) CFSET NewText = ATTRIBUTES.TEXT CFSET Hit = findnocase(href=,newtext) CFSET temp = SetVariable(caller. ATTRIBUTES.VAR,) CFLOOP CONDITION=Hit CFSET NewText = mid(newtext,Hit+5,len(newtext)) CFIF left(newtext,1) EQ chr(34) OR left(newtext,1) EQ chr(39) CFSET newtext = mid(newtext,2,len(newtext)) /CFIF CFSET EndHit = FindOneOf(EndListToCheck,NewText) CFIF EndHit CFIF NOT ListFindNoCase(Evaluate(Caller. attributes.Var),left(newtext,EndHit-1)) CFSET temp = SetVariable(Caller. attributes.Var,ListAppend(Evaluate(Caller. ATTRIBUTES.VAR),left(newtext,EndHit-1))) /CFIF CFSET NewText = mid(NewText,EndHit,len(NewText)) CFSET Hit = findnocase(href=,NewText) CFELSE CFBREAK /CFIF /CFLOOP ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
nesting variables...
I have defined a variable earlier in my template titled region. and it equals a string of my location... ie. CAN or US. I also have a query titled countryName. cfquery name=countryName datasource=#datasource# select #region# from location where id = #form.location# /cfquery So how could I use that region varible in order to access the data retrieved from my query like so below ( both versions throw an error )... #countryName[region]# OR #countryName[#region#]# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199747 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: nesting variables...
#countryName[region][countryName.currentrow]# -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 11:15 To: CF-Talk Subject: nesting variables... I have defined a variable earlier in my template titled region. and it equals a string of my location... ie. CAN or US. I also have a query titled countryName. cfquery name=countryName datasource=#datasource# select #region# from location where id = #form.location# /cfquery So how could I use that region varible in order to access the data retrieved from my query like so below ( both versions throw an error )... #countryName[region]# OR #countryName[#region#]# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199748 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: nesting variables...
OR avoid the problem altogether cfquery name=countryName datasource=#datasource# select #region# AS myregion from location where id = #form.location# /cfquery #countryName.myregion# Pascal -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 13:28 To: CF-Talk Subject: RE: nesting variables... #countryName[region][countryName.currentrow]# -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 11:15 To: CF-Talk Subject: nesting variables... I have defined a variable earlier in my template titled region. and it equals a string of my location... ie. CAN or US. I also have a query titled countryName. cfquery name=countryName datasource=#datasource# select #region# from location where id = #form.location# /cfquery So how could I use that region varible in order to access the data retrieved from my query like so below ( both versions throw an error )... #countryName[region]# OR #countryName[#region#]# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199749 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Default Value for MS Access ALTER TABLE ADD COLUMN
On Tuesday 22 Mar 2005 01:10 am, Stan Winchester wrote: It seems if it can be done in the Access Design View there should be a SQL equivalent. Why ? One thing knows all about the grubby internals of your specific database, and the other is an open language standard. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199750 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Free Coldfusion Devs Tool
On Tuesday 22 Feb 2005 19:25 pm, Bryan F. Hogan wrote: He should be able to make a mac projector and all will be ok for your Mac. Does anyone know if http://www.keslabs.com/crd/ is being updated still ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199751 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: nesting variables...
or #countryName[region][1]# if the query is only supposed to return a single row - the problem of course will occur if the query returns no rows, then [1] (or any number) will produce an error whereas #countryName.myregion# would return an empty string. So if there's any doubt that the query might ever be empty, you end up needing something like this cfif countryName.recordcount#countryName[region][1]#/cfif #countryName[region][countryName.currentrow]# -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 11:15 To: CF-Talk Subject: nesting variables... I have defined a variable earlier in my template titled region. and it equals a string of my location... ie. CAN or US. I also have a query titled countryName. cfquery name=countryName datasource=#datasource# select #region# from location where id = #form.location# /cfquery So how could I use that region varible in order to access the data retrieved from my query like so below ( both versions throw an error )... #countryName[region]# OR #countryName[#region#]# s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199752 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: nesting variables...
Since CF6 referencing a row greater than the record count, even one of 0, doesn't cause an error. In fact, all of these work... #qArticles[ArticleID][-10]# #qArticles[ArticleID][0]# #qArticles[ArticleID][1000]# regardless of the record count of qArticles. Which has it's benefits :O) Ade -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 14:32 To: CF-Talk Subject: RE: nesting variables... or #countryName[region][1]# if the query is only supposed to return a single row - the problem of course will occur if the query returns no rows, then [1] (or any number) will produce an error whereas #countryName.myregion# would return an empty string. So if there's any doubt that the query might ever be empty, you end up needing something like this cfif countryName.recordcount#countryName[region][1]#/cfif #countryName[region][countryName.currentrow]# -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 11:15 To: CF-Talk Subject: nesting variables... I have defined a variable earlier in my template titled region. and it equals a string of my location... ie. CAN or US. I also have a query titled countryName. cfquery name=countryName datasource=#datasource# select #region# from location where id = #form.location# /cfquery So how could I use that region varible in order to access the data retrieved from my query like so below ( both versions throw an error )... #countryName[region]# OR #countryName[#region#]# s. isaac dealey 954.522.6080 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199753 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Flash Forms: Lesson Learned
Just thought I'd share this bit of duh with folks - I've been working on a flash form in CFMX7 and it wasn't quite working the way that I was used to it from other forms. On HTML forms you have to be careful to make sure that checkbox and radio fields exist in the action set. Now with flash forms there is a difference. Checkbox fields always exist. They also do not pass a value; rather they pass a simple true/false. Radio fields do run the risk of not existing if none of the options are selected. cfdump is your friend! Hatton ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: 32K span If possible, please refactor this component
There is a hard limit of the generated actionscript. (remember it's cfml - mxml - actionscript). The actionscript compiler can't handle .as files larger then this limit. Unfortunately there isn't a way to tell you hard limit on the amount of cfml you can write, or to refactor the code around this. But if you are really close to finishing your form, try removing your style attributes, this will add additional actionscript to the final size that you can control. If that still isn't enough I would recommend breaking the code into multiple cfform forms. I've seen people use a tree or links on the side, and Iframes to break the form up into multiple forms. Hth, ---nimer -Original Message- From: David Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 10:32 PM To: CF-Talk Subject: Re: 32K span If possible, please refactor this component Anyone have any suggestions? Somone suggested that there might be a limit with the get method, but not the post method. I checked our form method and we are using post. But still get the 32k span error. Given our form is rather large around 6 tabs with full pages of form elements. David - Original Message - From: David Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 22, 2005 12:47 PM Subject: 32K span If possible, please refactor this component From what I can tell this is a limit of the flash player. How can you fix this in cfmx 7 flash forms; other then breaking up the form into smaller parts. David ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199755 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Free Coldfusion Devs Tool
I am not sure if its being updated (no info here) but I have tried to use it with CFMX 7 but havent got it running (but the right server and path) Is there problems with the Java objects it creates? MD On Wed, 23 Mar 2005 14:12:02 +, Thomas Chiverton [EMAIL PROTECTED] wrote: On Tuesday 22 Feb 2005 19:25 pm, Bryan F. Hogan wrote: He should be able to make a mac projector and all will be ok for your Mac. Does anyone know if http://www.keslabs.com/crd/ is being updated still ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199756 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Coldfusion report builder - charts in excel not working?
Hi All, I've been trying to get comfortable with the new Report Builder in MX7. I have created a new report that has a pie chart. When I set the report type to either Flashpaper or PDF the pie chart displays fine, however when I set the report type to excel, no dice. I get the report header but nothing else, just a whole lot of white space where the report should be. Any thoughts or suggestions? ~Cynthia ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Coldfusion report builder - charts in excel not working?
I haven't played with this since beta days What version of M$ Office? Have you tested on different versions of Office? My company is still stuck on Office 97, which usually can't do any of this stuff. D On Wed, 23 Mar 2005 10:32:59 -0500, Cynthia Reece [EMAIL PROTECTED] wrote: Hi All, I've been trying to get comfortable with the new Report Builder in MX7. I have created a new report that has a pie chart. When I set the report type to either Flashpaper or PDF the pie chart displays fine, however when I set the report type to excel, no dice. I get the report header but nothing else, just a whole lot of white space where the report should be. Any thoughts or suggestions? ~Cynthia ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199758 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Coldfusion report builder - charts in excel not working?
I believe I remember reading in the CFREPORT tag documentation that the export to Excel does not support Charts or some numeric data formatting (I think it goes into text only, not formatted numbers). Thanks, Phil Hi All, I've been trying to get comfortable with the new Report Builder in MX7. I have created a new report that has a pie chart. When I set the report type to either Flashpaper or PDF the pie chart displays fine, however when I set the report type to excel, no dice. I get the report header but nothing else, just a whole lot of white space where the report should be. Any thoughts or suggestions? ~Cynthia ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RDS and ColdFusion Report Builder
I've asked this on another forum, but thought I'd post hear since the responses seem to be quicker on CF-Talk, :). I've been playing around with the report builder for the last few weeks. I have one question about RDS and its use within a report once its been posted to a server (accessed through CFREPORT tag). If RDS is turned off in our production environment, will queries built using the Query Builder fail? Also, can the Advanced tab of the Report Builder be utilized to place a variable in the datasource attribute as sometimes we change our datasources from development through production? I guess, in summary, is the role of RDS primarily for developing and not for executing the output of the report? I remember asking this question at MAX and got a vague answer at best on it. Thanks, Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199760 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Standard Method of receiving XML
All, I'm writing an XML interface that receives data from outside users. In my code, I am using GetHttpRequestData to get to the Content header. Now in my testing, I am using CFHTTP to post the requested page and everything is perfect. I can parse and utilize the content header just peachy. But I am realizing that the actual users of this interface will be using a variety of means to get the xml to my system, so that the content header may appear quite different from connection to connection. So for cfhttp my header appears as: Transmission /Transmission if I use a form posting with a hidden element named xml, it is: xml= Transmission /Transmission I am sure that there are other methods of sending xml that will yeild still different results. Is there a way to pull only the XML from the content header regardless of what other information is in there? Or is this a case of us directing the users on how they should format their requests. Also, I am using the Charles HTTP Proxy to watch the headers real-time. I notice that when I call a page, and that page uses cfhttp to request another page, that request doesnt appear in the Charles log, although it does appear if I change the code to use a auto-submitting form to the same page. In what way can I view the CFHTTP requests then? I have tried also using LiveHttpHeaders on firefox with similar results. All of the pages being called are on the localhost. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199761 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free Coldfusion Devs Tool
I couldn't get it to work with 7 either, just hangs. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 9:54 AM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool I am not sure if its being updated (no info here) but I have tried to use it with CFMX 7 but havent got it running (but the right server and path) Is there problems with the Java objects it creates? MD On Wed, 23 Mar 2005 14:12:02 +, Thomas Chiverton [EMAIL PROTECTED] wrote: On Tuesday 22 Feb 2005 19:25 pm, Bryan F. Hogan wrote: He should be able to make a mac projector and all will be ok for your Mac. Does anyone know if http://www.keslabs.com/crd/ is being updated still ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199762 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RDS and ColdFusion Report Builder
My understanding is that RDS is only used for the creation of the reports, the .cfr files shouldn't need RDS. - Calvin -Original Message- From: Phillip Duba [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 10:03 AM To: CF-Talk Subject: RDS and ColdFusion Report Builder I've asked this on another forum, but thought I'd post hear since the responses seem to be quicker on CF-Talk, :). I've been playing around with the report builder for the last few weeks. I have one question about RDS and its use within a report once its been posted to a server (accessed through CFREPORT tag). If RDS is turned off in our production environment, will queries built using the Query Builder fail? Also, can the Advanced tab of the Report Builder be utilized to place a variable in the datasource attribute as sometimes we change our datasources from development through production? I guess, in summary, is the role of RDS primarily for developing and not for executing the output of the report? I remember asking this question at MAX and got a vague answer at best on it. Thanks, Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199763 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free Coldfusion Devs Tool
I'm the creator of it and Yes, its still being updated. I'm working on getting all the fixes I received by email completed as well as a CF7 version. I'm a one man show with a full time job, so please be patient. =] Cheers, Kevin -- http://www.keslabs.com Coldfusion Remote Dashboard :: http://www.keslabs.com/crd -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:54 AM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool I am not sure if its being updated (no info here) but I have tried to use it with CFMX 7 but havent got it running (but the right server and path) Is there problems with the Java objects it creates? MD On Wed, 23 Mar 2005 14:12:02 +, Thomas Chiverton [EMAIL PROTECTED] wrote: On Tuesday 22 Feb 2005 19:25 pm, Bryan F. Hogan wrote: He should be able to make a mac projector and all will be ok for your Mac. Does anyone know if http://www.keslabs.com/crd/ is being updated still ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RDS and ColdFusion Report Builder
You should be passing in the query via a CFC. The query builder really should only be used when first creating the report and the layout. -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 9:10 AM To: CF-Talk Subject: RE: RDS and ColdFusion Report Builder My understanding is that RDS is only used for the creation of the reports, the .cfr files shouldn't need RDS. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199765 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RDS and ColdFusion Report Builder
I've seen CFCs used for formatting data but not for passing in whole queries, how would you do this, within the Advanced tab of the query builder like one CFHTTP example I saw? Thanks, Phil You should be passing in the query via a CFC. The query builder really should only be used when first creating the report and the layout. -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 9:10 AM To: CF-Talk Subject: RE: RDS and ColdFusion Report Builder My understanding is that RDS is only used for the creation of the reports, the .cfr files shouldn't need RDS. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199766 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free Coldfusion Devs Tool
Just so everyone knows, heres a list of the current updates: - Tabbing between fields - Y-axis Graphing scale - Timeout fix - CFC updates and fixes - documentation New features: - Multiple hard disk monitoring - More flexible session querying selection If I've missed anything, please don't hesistate to let me know. When the next version is ready, the application will alert you. Sincerely, Kevin -- http://www.keslabs.com Coldfusion Remote Dashboard :: http://www.keslabs.com/crd -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 10:12 AM To: CF-Talk Subject: RE: Free Coldfusion Devs Tool I'm the creator of it and Yes, its still being updated. I'm working on getting all the fixes I received by email completed as well as a CF7 version. I'm a one man show with a full time job, so please be patient. =] Cheers, Kevin -- http://www.keslabs.com Coldfusion Remote Dashboard :: http://www.keslabs.com/crd -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:54 AM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool I am not sure if its being updated (no info here) but I have tried to use it with CFMX 7 but havent got it running (but the right server and path) Is there problems with the Java objects it creates? MD On Wed, 23 Mar 2005 14:12:02 +, Thomas Chiverton [EMAIL PROTECTED] wrote: On Tuesday 22 Feb 2005 19:25 pm, Bryan F. Hogan wrote: He should be able to make a mac projector and all will be ok for your Mac. Does anyone know if http://www.keslabs.com/crd/ is being updated still ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RDS and ColdFusion Report Builder
In the report builder there is a button that shows you the query/CFC code for you to copy and paste into your own CFC. -Original Message- From: Phillip Duba [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:32 AM To: CF-Talk Subject: Re: RDS and ColdFusion Report Builder I've seen CFCs used for formatting data but not for passing in whole queries, how would you do this, within the Advanced tab of the query builder like one CFHTTP example I saw? Thanks, Phil You should be passing in the query via a CFC. The query builder really should only be used when first creating the report and the layout. -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 9:10 AM To: CF-Talk Subject: RE: RDS and ColdFusion Report Builder My understanding is that RDS is only used for the creation of the reports, the .cfr files shouldn't need RDS. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199768 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RDS and ColdFusion Report Builder
In the report builder there is a button that shows you the query/CFC code for you to copy and paste into your own CFC. -Original Message- From: Phillip Duba [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:32 AM To: CF-Talk Subject: Re: RDS and ColdFusion Report Builder I've seen CFCs used for formatting data but not for passing in whole queries, how would you do this, within the Advanced tab of the query builder like one CFHTTP example I saw? Thanks, Phil You should be passing in the query via a CFC. The query builder really should only be used when first creating the report and the layout. -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 9:10 AM To: CF-Talk Subject: RE: RDS and ColdFusion Report Builder My understanding is that RDS is only used for the creation of the reports, the .cfr files shouldn't need RDS. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199769 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Standard Method of receiving XML
You can't capture the CFHTTP requests unless your sniffer is running on your server, because they never actually leave the server. As for getting your XML out of the header, Just do a search for the first and first =, take the lower non-zero one, and start reading from there. cheers, barneyb On Wed, 23 Mar 2005 11:00:31 -0500, John Stanley [EMAIL PROTECTED] wrote: All, I'm writing an XML interface that receives data from outside users. In my code, I am using GetHttpRequestData to get to the Content header. Now in my testing, I am using CFHTTP to post the requested page and everything is perfect. I can parse and utilize the content header just peachy. But I am realizing that the actual users of this interface will be using a variety of means to get the xml to my system, so that the content header may appear quite different from connection to connection. So for cfhttp my header appears as: Transmission /Transmission if I use a form posting with a hidden element named xml, it is: xml= Transmission /Transmission I am sure that there are other methods of sending xml that will yeild still different results. Is there a way to pull only the XML from the content header regardless of what other information is in there? Or is this a case of us directing the users on how they should format their requests. Also, I am using the Charles HTTP Proxy to watch the headers real-time. I notice that when I call a page, and that page uses cfhttp to request another page, that request doesnt appear in the Charles log, although it does appear if I change the code to use a auto-submitting form to the same page. In what way can I view the CFHTTP requests then? I have tried also using LiveHttpHeaders on firefox with similar results. All of the pages being called are on the localhost. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199770 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RDS and ColdFusion Report Builder
I understand that, but is your suggestion below assuming I'm passing in the query using the query attribute of the CFREPORT tag and a CFINVOKE prior to this tag to get the query? Maybe I should explaing that the basis of my question is sub-reports. If I create a sub-report, it appears I can only pass one query reference into the main report for the main query, not the sub-reports query. That's why I'm asking about the Advanced tab. It would seem to me to use this part of the query builder to define a query in the sub-report or put in code to call a CFC with a parameter from the main query. I don't know if that makes any sense or not. Thanks, Phil In the report builder there is a button that shows you the query/CFC code for you to copy and paste into your own CFC. -Original Message- From: Phillip Duba [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:32 AM To: CF-Talk Subject: Re: RDS and ColdFusion Report Builder I've seen CFCs used for formatting data but not for passing in whole queries, how would you do this, within the Advanced tab of the query builder like one CFHTTP example I saw? Thanks, Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199771 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RDS and ColdFusion Report Builder
Ahh, sub-reports. Did not see that detail. I do recall this being an issue and don't recall the solution if any. I'll keep an eye out for it. -Original Message- From: Phillip Duba [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:45 AM To: CF-Talk Subject: Re: RDS and ColdFusion Report Builder I understand that, but is your suggestion below assuming I'm passing in the query using the query attribute of the CFREPORT tag and a CFINVOKE prior to this tag to get the query? Maybe I should explaing that the basis of my question is sub-reports. If I create a sub-report, it appears I can only pass one query reference into the main report for the main query, not the sub-reports query. That's why I'm asking about the Advanced tab. It would seem to me to use this part of the query builder to define a query in the sub-report or put in code to call a CFC with a parameter from the main query. I don't know if that makes any sense or not. Thanks, Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199772 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RDS and ColdFusion Report Builder
Thanks Connie and I was afraid that's what the answer would be, Phil Ahh, sub-reports. Did not see that detail. I do recall this being an issue and don't recall the solution if any. I'll keep an eye out for it. -Original Message- From: Phillip Duba [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:45 AM To: CF-Talk Subject: Re: RDS and ColdFusion Report Builder I understand that, but is your suggestion below assuming I'm passing in the query using the query attribute of the CFREPORT tag and a CFINVOKE prior to this tag to get the query? Maybe I should explaing that the basis of my question is sub-reports. If I create a sub-report, it appears I can only pass one query reference into the main report for the main query, not the sub-reports query. That's why I'm asking about the Advanced tab. It would seem to me to use this part of the query builder to define a query in the sub-report or put in code to call a CFC with a parameter from the main query. I don't know if that makes any sense or not. Thanks, Phil ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199773 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Reserved word list for verity
Dose anyone have a link to a full list (heck, I'll even settle for part of a list) of verity reserved words? I can't believe Google did not return anything of value. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Free Coldfusion Devs Tool
On Wednesday 23 Mar 2005 16:31 pm, Kevin Aebig wrote: If I've missed anything, please don't hesistate to let me know. When the next version is ready, the application will alert you. There was talk of making the client work on non-Windows boxes using projector, or just a bare flash file. As we're Linux desktop/Linux server we'd love that. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199775 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free Coldfusion Devs Tool
I almost forgot about that. I'll be releasing a browser version as well that maintains the config with CF. Cheers, Kevin -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 11:08 AM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool On Wednesday 23 Mar 2005 16:31 pm, Kevin Aebig wrote: If I've missed anything, please don't hesistate to let me know. When the next version is ready, the application will alert you. There was talk of making the client work on non-Windows boxes using projector, or just a bare flash file. As we're Linux desktop/Linux server we'd love that. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199776 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Free Coldfusion Devs Tool
Kevin, It looks great! I installed it locally at 127.0.0.1 with my component path as /Dashboard (which is a directory under the webroot I put the components). The Dashboard seems to connect, but threw an error: Service Connection Error SERVER.PROCESSING Service threw an exception during method invocation: Current user was not authorized to invoke this method. I have a very standard CF install on XP Pro SP2/IIS 5.1 CF7.0 Ent. I believe CF is just running under the Administrator account. I entered my CF Admin password with username Administrator. What do I need to do? Thanks, Greg On Tue, 22 Feb 2005 13:53:55 -0600, Kevin Aebig [EMAIL PROTECTED] wrote: FYI Quick explanation for anyone not quite getting the server mappings. Please don't be shy if something is confusing or doesn't work the way you feel it should. The hardest part of app development is usability and what you guys tell me is golden. http://www.keslabs.com/crd/docs.php Cheers, Kevin -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 1:56 PM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool Kevin Aebig wrote: it completely so I'm not exactly sure how much unicode support I can garantee. With the Flash 7 though, unicode is supposed to be the primary have you separated the app's text resources? that's probably key to this sort of thing. string type, so I can't forsee a problem. As for skinning it, I might add support down the line, but the next couple features higher on the list are: yeah, understand. thanks again for this cool tool. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199777 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free Coldfusion Devs Tool
It sounds like either you're running CF7... which hasn't been tested because I don't have CF7. =] - OR - You didn't type in the password properly. As for the username, that can be whatever you want. Its only in place for a future version with more multi-user functionality. Cheers, Kevin -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 11:46 AM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool Kevin, It looks great! I installed it locally at 127.0.0.1 with my component path as /Dashboard (which is a directory under the webroot I put the components). The Dashboard seems to connect, but threw an error: Service Connection Error SERVER.PROCESSING Service threw an exception during method invocation: Current user was not authorized to invoke this method. I have a very standard CF install on XP Pro SP2/IIS 5.1 CF7.0 Ent. I believe CF is just running under the Administrator account. I entered my CF Admin password with username Administrator. What do I need to do? Thanks, Greg On Tue, 22 Feb 2005 13:53:55 -0600, Kevin Aebig [EMAIL PROTECTED] wrote: FYI Quick explanation for anyone not quite getting the server mappings. Please don't be shy if something is confusing or doesn't work the way you feel it should. The hardest part of app development is usability and what you guys tell me is golden. http://www.keslabs.com/crd/docs.php Cheers, Kevin -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 1:56 PM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool Kevin Aebig wrote: it completely so I'm not exactly sure how much unicode support I can garantee. With the Flash 7 though, unicode is supposed to be the primary have you separated the app's text resources? that's probably key to this sort of thing. string type, so I can't forsee a problem. As for skinning it, I might add support down the line, but the next couple features higher on the list are: yeah, understand. thanks again for this cool tool. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cftransaction behavior
CFTRANSACTION action=BEGIN CFTRY many CFQUERY tags CFTRANSACTION action=COMMIT / CFCATCH CFTRANSACTION action=ROLLBACK / /CFCATCH /CFTRY /CFTRANSACTION It's worth pointing out that this isn't really necessary, if all you're doing is running a bunch of CFQUERY tags using the same datasource, username and password. If any of those queries throws an error, the transaction will automatically rollback all the other queries. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199779 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cftransaction behavior
If I comment out the CFTRANSACTION action=COMMIT tag and the query completes without errors, the data is still written to the database. Shouldn't I have to explicitly use COMMIT in order for the data to be saved? At first glance it seems that the only time I'd want to ROLLBACK is in the event of an error, but if this is the expected behavior I'm not sure why I'd ever need to use CFTRANSACTION action=COMMIT. Anyone have any ideas? The ACTION=COMMIT and ACTION=ROLLBACK are there primarily to allow you to do partial commits and rollbacks within a single transaction. In your case, all you need to do is wrap your queries within a single CFTRANSACTION tag, and ensure you're using the appropriate isolation level. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199780 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Search and Replace DWMX 2004
I want to replace a datasource that's listed through many DWMX sites. I can do the search and get a list without any probelms. In fact, I can do the replace all and it will replace all the references for me. My question, the issue is how do I get the multiple files that have been changed locally up to the live site? These changes have taken place through the multiple levels below my webroot. Do I have to find the path for each and upload each file? How do I get the changed files from the local version of my site up to the live site quickly. My test search found 127 results. I don't want to manually find the path of 127 files to assure each file is uploaded. I can't upload the entire site, there is another developer that uses Homesite and I may overwrite their open pages. DWMX 2004 has an option to allow you to upload only the changed files within the site. Of course, if the other developer has any of those files open, they will still be clobbered. As others have suggested, you might look into implementing version control. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199781 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Ajax
One last comment .. made by Erik Arvidsson.. seems he agrees. Very, very, very hard indeed. Writing a mail application is hard using any toolkit. (Just look at Mozilla Thunderbird.) The same applies to Google maps. Sure some things might have been easier with WinForms, Avalon or Lazslo but the application in itself is the biggest part of the development time and cost. The biggest short coming with HTML/XML and scripting is indeed the lack of good reusable components (and sometime a unified application framework). I think if IE supported DOM level 2 and XBL2 I think it would totally kill the alternative frameworks (as long as some the different platforms are compatible enough with each other). I'm not sure whether he's agreeing with you or with me. He says it's hard to write a mail application using any toolkit, not that it's especially hard to do it with DHTML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199782 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Standard Method of receiving XML
Barney, Thanks for your help. John -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 11:40 AM To: CF-Talk Subject: Re: Standard Method of receiving XML You can't capture the CFHTTP requests unless your sniffer is running on your server, because they never actually leave the server. As for getting your XML out of the header, Just do a search for the first and first =, take the lower non-zero one, and start reading from there. cheers, barneyb On Wed, 23 Mar 2005 11:00:31 -0500, John Stanley [EMAIL PROTECTED] wrote: All, I'm writing an XML interface that receives data from outside users. In my code, I am using GetHttpRequestData to get to the Content header. Now in my testing, I am using CFHTTP to post the requested page and everything is perfect. I can parse and utilize the content header just peachy. But I am realizing that the actual users of this interface will be using a variety of means to get the xml to my system, so that the content header may appear quite different from connection to connection. So for cfhttp my header appears as: Transmission /Transmission if I use a form posting with a hidden element named xml, it is: xml= Transmission /Transmission I am sure that there are other methods of sending xml that will yeild still different results. Is there a way to pull only the XML from the content header regardless of what other information is in there? Or is this a case of us directing the users on how they should format their requests. Also, I am using the Charles HTTP Proxy to watch the headers real-time. I notice that when I call a page, and that page uses cfhttp to request another page, that request doesnt appear in the Charles log, although it does appear if I change the code to use a auto-submitting form to the same page. In what way can I view the CFHTTP requests then? I have tried also using LiveHttpHeaders on firefox with similar results. All of the pages being called are on the localhost. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199783 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 32K span If possible, please refactor this component
Nimer, I just wanted to say thank you for both this answer the suggestion of where to place my form focus on another question. - Original Message - From: Mike Nimer [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 23, 2005 9:43 AM Subject: RE: 32K span If possible, please refactor this component There is a hard limit of the generated actionscript. (remember it's cfml - mxml - actionscript). The actionscript compiler can't handle .as files larger then this limit. Unfortunately there isn't a way to tell you hard limit on the amount of cfml you can write, or to refactor the code around this. But if you are really close to finishing your form, try removing your style attributes, this will add additional actionscript to the final size that you can control. If that still isn't enough I would recommend breaking the code into multiple cfform forms. I've seen people use a tree or links on the side, and Iframes to break the form up into multiple forms. Hth, ---nimer -Original Message- From: David Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 10:32 PM To: CF-Talk Subject: Re: 32K span If possible, please refactor this component Anyone have any suggestions? Somone suggested that there might be a limit with the get method, but not the post method. I checked our form method and we are using post. But still get the 32k span error. Given our form is rather large around 6 tabs with full pages of form elements. David - Original Message - From: David Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 22, 2005 12:47 PM Subject: 32K span If possible, please refactor this component From what I can tell this is a limit of the flash player. How can you fix this in cfmx 7 flash forms; other then breaking up the form into smaller parts. David ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199784 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free Coldfusion Devs Tool
I think it's a great looking application, let us know when you've got a CF7 version, as we can't run it to let it alert us :) - Calvin -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 11:32 AM To: CF-Talk Subject: RE: Free Coldfusion Devs Tool Just so everyone knows, heres a list of the current updates: - Tabbing between fields - Y-axis Graphing scale - Timeout fix - CFC updates and fixes - documentation New features: - Multiple hard disk monitoring - More flexible session querying selection If I've missed anything, please don't hesistate to let me know. When the next version is ready, the application will alert you. Sincerely, Kevin -- http://www.keslabs.com Coldfusion Remote Dashboard :: http://www.keslabs.com/crd -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 10:12 AM To: CF-Talk Subject: RE: Free Coldfusion Devs Tool I'm the creator of it and Yes, its still being updated. I'm working on getting all the fixes I received by email completed as well as a CF7 version. I'm a one man show with a full time job, so please be patient. =] Cheers, Kevin -- http://www.keslabs.com Coldfusion Remote Dashboard :: http://www.keslabs.com/crd -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 8:54 AM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool I am not sure if its being updated (no info here) but I have tried to use it with CFMX 7 but havent got it running (but the right server and path) Is there problems with the Java objects it creates? MD On Wed, 23 Mar 2005 14:12:02 +, Thomas Chiverton [EMAIL PROTECTED] wrote: On Tuesday 22 Feb 2005 19:25 pm, Bryan F. Hogan wrote: He should be able to make a mac projector and all will be ok for your Mac. Does anyone know if http://www.keslabs.com/crd/ is being updated still ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Merging Flex 1.5 and CFMX7 on JRun
I'm trying to figure out how to merge Flex 1.5 and CFMX7 on JRun and I'm just not having any luck. I tried the Macromedia tech note for merging Flex 1 and CFMX 6.1, and it wouldn't work (CFMX wouldn't even start until I restored the original web.xml file). Basically what I'm trying to do is install Flex 1.5, then install CFMX7 Enterprise on the JRun configuration. Once CF is installed, CF runs like normal and I can log in to the JRun admin with no problems, I just have no idea exactly how to deploy the Flex 1.5 WAR file into the cfusion JRun server instance so that they'll play nice. I've tried a few things, but when I go to test a .cfm page that contains a cfimport taglib=WEB-INF/lib/flex-bootstrap.jar prefix=mm, I get a JRun 500 null error. I'm trying the example code on Ben's blog at: http://www.forta.com/blog/index.cfm?mode=eentry=1038 Any ideas? - Matt ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199786 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Need help parsing CSV file
I'm a bit stuck. I'm using cffile to read in a CSV file that is comma-delimited, quoted-value; only those values with commas in them are quoted, i.e.: 123,this is a string,456,789 124,comma, baby,456,789 I need to parse through this file and grab specific values. I'm using a loop to get each row of data by using chr(13)chr(10) as line delimeters, then using listGetAt() to get each of the values in that row. Problem, of course, is the second example, when I really need the comma, baby value but listGetAt(list,2) would return comma as the value for the second item and baby as the third item in the list. Is there a simple solution? Thanks Pete ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199787 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFgrid
I see if I have my cfgrid set to applet you can use the values attribute and valuesdisplay of the cfgridcolumn. If I set cfgrid to applet and place it in a cfform format= flash. Is the cfgrid still an applet or now considered flash and thush I can't use values and valuesdiplay. David ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199788 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Ajax
I'm not sure whether he's agreeing with you or with me. He says it's hard to write a mail application using any toolkit, not that it's especially hard to do it with DHTML. Yeah, that was more the point I was trying to make. CF-generated HTML is an amazingly simple way to create feature-rich UIs, if you don't mind the poor user experience (because of page loads). Any kind of real UI (Ajax, Flash/Flex, Java, C#, etc) is going to take a lot more work than HTML, but you get a lot of benefits. And that's even if the toolkit you use has a well designed and documented API. You still have to deal with programming against that API, which is necessarily going to be a lot harder than simple HTML. Definitely a shift from web programing to real programming, and that's hard. cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Need help parsing CSV file
Here is what I do: After cffile: cfset FORM.Delims = #chr(13)# #chr(10)# cfset Form.FileSize = #Len(variables.FileContent)# cfset Form.FileLines = #ListLen(Variables.FileContent, Form.Delims)# cfset variables.FileContent = #Replace(variables.filecontent, ,,, , ,, all)# cfset variables.FileContent = #Replace(variables.filecontent, ,,, , ,, all)# cfset FileContentLines = #ListToArray(variables.filecontent, form.delims)# cfset filecontentlength = #ArrayLen(variables.filecontentlines)# cfset ColumnName1 = 0 cfset ColumnName2 = 0 cfset ColumnName3 = 0 cfset FieldNameList = #variables.filecontentlines[1]# cfset fieldqnty = #ListLen(variables.fieldnamelist, ,)# cfset fieldnamearray = #ListToArray(variables.fieldnamelist, ,)# cfloop index=FieldCounter from=1 to=#variables.fieldqnty# step=1 !--- One of these cfif lines for each column header whiching to pull into the database --- cfif #variables.fieldnamearray[variables.fieldcounter]# contains Column Name Header Desc cfset ColumnName1 = #variables.FieldCounter# /cfif /cfloop cfloop index=FileProcess from=2 to=#variables.filecontentlength# step=1 cfset FieldDataArray = #ListToArray(FileContentLines[variables.FileProcess], ,)# cfset Column1Value = #FieldDataArray[variables.ColumnName1]# cfset Column2Value = #FieldDataArray[variables.ColumnName2]# cfset Column3Value = #FieldDataArray[variables.ColumnName3]# cfquery to insert data into database /cfloop Pete Ruckelshaus wrote: I'm a bit stuck. I'm using cffile to read in a CSV file that is comma-delimited, quoted-value; only those values with commas in them are quoted, i.e.: 123,this is a string,456,789 124,comma, baby,456,789 I need to parse through this file and grab specific values. I'm using a loop to get each row of data by using chr(13)chr(10) as line delimeters, then using listGetAt() to get each of the values in that row. Problem, of course, is the second example, when I really need the comma, baby value but listGetAt(list,2) would return comma as the value for the second item and baby as the third item in the list. Is there a simple solution? Thanks Pete ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Reading Session Variables
Does anyone know if it is possible to read session variables withing Javascript?
Example,
Have a session variable called CompareList
CFSET session.CompareList = /
input type=hidden name=Session.CompareList value=#Session.CompareList#
/
JS:
function ReadList() {
var CurrCompareValues = document.myform.Session.CompareList.value;
// This doesn't work because of the Session.Comparelist
alert(CurrCompareValues);
}
name.
Thanks
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199791
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need help parsing CSV file
From that sample data below you could do the following:
!--- If there's a double quote in the line switch to using it as the
delimited ---
your crlf loop
cfif Find('', yourLine, 1)
cfset secondValue = ListGetAt(yourLine, 2, '')
cfelse
cfset secondValue = ListGetAt(yourLine, 2, ,)
/cfif
/your crlf loop
This assumes there's not much variation from the data below.
Ade
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: 23 March 2005 18:39
To: CF-Talk
Subject: Need help parsing CSV file
I'm a bit stuck. I'm using cffile to read in a CSV file that is
comma-delimited, quoted-value; only those values with commas in them
are quoted, i.e.:
123,this is a string,456,789
124,comma, baby,456,789
I need to parse through this file and grab specific values. I'm using
a loop to get each row of data by using chr(13)chr(10) as line
delimeters, then using listGetAt() to get each of the values in that
row.
Problem, of course, is the second example, when I really need the
comma, baby value but listGetAt(list,2) would return comma as the
value for the second item and baby as the third item in the list.
Is there a simple solution?
Thanks
Pete
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199792
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Reading Session Variables
Of the top of my head, try a different syntax.
var CurrCompareValues = document.myform[Session.CompareList].value;
Does that work?
Ade
-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED]
Sent: 23 March 2005 19:52
To: CF-Talk
Subject: Reading Session Variables
Does anyone know if it is possible to read session variables withing
Javascript?
Example,
Have a session variable called CompareList
CFSET session.CompareList = /
input type=hidden name=Session.CompareList
value=#Session.CompareList# /
JS:
function ReadList() {
var CurrCompareValues = document.myform.Session.CompareList.value;
// This doesn't work because of the Session.Comparelist
alert(CurrCompareValues);
}
name.
Thanks
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199793
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Reading Session Variables
Does anyone know if it is possible to read session variables
withing Javascript?
Example,
Have a session variable called CompareList
CFSET session.CompareList = /
input type=hidden name=Session.CompareList
value=#Session.CompareList# /
JS:
function ReadList() {
var CurrCompareValues =
document.myform.Session.CompareList.value;
// This doesn't work because of the Session.Comparelist
alert(CurrCompareValues);
}
name.
The short answer is no, you can't read Session variables within JavaScript.
However, you can output them within form fields or JavaScript variables
within your HTML page, and read those from JavaScript.
The problematic part of your code is your form field name. The dot (.) is
a JavaScript metacharacter, so you won't want to name your form field
Session.CompareList.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199794
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Reading Session Variables
It's not possible since session vars are server side only.
Regards,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm
--- On Wednesday, March 23, 2005 2:52 PM, Chad McCue scribed: ---
Does anyone know if it is possible to read session variables withing
Javascript?
Example,
Have a session variable called CompareList
CFSET session.CompareList = /
input type=hidden name=Session.CompareList
value=#Session.CompareList# /
JS:
function ReadList() {
var CurrCompareValues =
document.myform.Session.CompareList.value; // This doesn't
work because of the Session.Comparelist
alert(CurrCompareValues); }
name.
Thanks
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199795
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
divide by zero error
Overview: run a cold fusion query against a datasource. Get a divide by zero error. Take that query in SQL Query analyzer and type in the query substituting values and it works fine. All values being input by cold fusion appear correct as well. Can anyone identify where to look in this instance? IN case it helps, resultant query: Select DISTINCT customer.id as cid, customer.business, customer_orders.id, SUM (customer_orders_prod.qty) as totunits FROM customer_orders JOIN customer on customer.id = customer_orders.customer_id JOIN customer_contact on customer.id = customer_contact.customer_id LEFT OUTER JOIN customer_orders_prod on customer_orders.id = customer_orders_prod.order_id JOIN inventory on customer_orders_prod.product_id = inventory.service_id WHERE customer_orders.orderdate BETWEEN '1/1/05' AND '3/1/05' AND customer_orders_prod.product_id = 101 AND customer_orders_prod.qty = 1 AND customer.state = 'MN' AND (phone LIKE '%952%' OR phone LIKE '%651%' or Phone like '%763%' or Phone like '%612%') AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%') AND customer.category 5 GROUP BY customer_orders.id, customer.id, business Eric J. Hoffman Market Connections 2081 Industrial Blvd. Stillwater MN 55082 http://www.marketconnections.us T: 651.207.1526 F: 651.207.1536 M: 952.210.9060 E: [EMAIL PROTECTED] This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Reading Session Variables
I think the question he asked was not what he was really after.
If my previous post didn't work you can just create the var directly where
you are trying to access the form value
var CurrCompareValues = #Session.CompareList#
instead of
input type=hidden name=Session.CompareList
value=#Session.CompareList# /
var CurrCompareValues = document.myform.Session.CompareList.value;
Ade
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: 23 March 2005 20:04
To: CF-Talk
Subject: Re: Reading Session Variables
It's not possible since session vars are server side only.
Regards,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm
--- On Wednesday, March 23, 2005 2:52 PM, Chad McCue scribed: ---
Does anyone know if it is possible to read session variables withing
Javascript?
Example,
Have a session variable called CompareList
CFSET session.CompareList = /
input type=hidden name=Session.CompareList
value=#Session.CompareList# /
JS:
function ReadList() {
var CurrCompareValues =
document.myform.Session.CompareList.value; // This doesn't
work because of the Session.Comparelist
alert(CurrCompareValues); }
name.
Thanks
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199797
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: divide by zero error
Is it a problem in the ColdFusion code rather than the SQL? I can't see where you're doing any division in the code below. Have you got the CF code for us to see? Ade -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 20:05 To: CF-Talk Subject: divide by zero error Overview: run a cold fusion query against a datasource. Get a divide by zero error. Take that query in SQL Query analyzer and type in the query substituting values and it works fine. All values being input by cold fusion appear correct as well. Can anyone identify where to look in this instance? IN case it helps, resultant query: Select DISTINCT customer.id as cid, customer.business, customer_orders.id, SUM (customer_orders_prod.qty) as totunits FROM customer_orders JOIN customer on customer.id = customer_orders.customer_id JOIN customer_contact on customer.id = customer_contact.customer_id LEFT OUTER JOIN customer_orders_prod on customer_orders.id = customer_orders_prod.order_id JOIN inventory on customer_orders_prod.product_id = inventory.service_id WHERE customer_orders.orderdate BETWEEN '1/1/05' AND '3/1/05' AND customer_orders_prod.product_id = 101 AND customer_orders_prod.qty = 1 AND customer.state = 'MN' AND (phone LIKE '%952%' OR phone LIKE '%651%' or Phone like '%763%' or Phone like '%612%') AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%') AND customer.category 5 GROUP BY customer_orders.id, customer.id, business Eric J. Hoffman -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199798 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: divide by zero error
would be better to show your SQL with the CF variables rather than the end SQL result. On Wed, 23 Mar 2005 14:05:22 -0600, Eric J. Hoffman [EMAIL PROTECTED] wrote: Overview: run a cold fusion query against a datasource. Get a divide by zero error. Take that query in SQL Query analyzer and type in the query substituting values and it works fine. All values being input by cold fusion appear correct as well. Can anyone identify where to look in this instance? IN case it helps, resultant query: Select DISTINCT customer.id as cid, customer.business, customer_orders.id, SUM (customer_orders_prod.qty) as totunits FROM customer_orders JOIN customer on customer.id = customer_orders.customer_id JOIN customer_contact on customer.id = customer_contact.customer_id LEFT OUTER JOIN customer_orders_prod on customer_orders.id = customer_orders_prod.order_id JOIN inventory on customer_orders_prod.product_id = inventory.service_id WHERE customer_orders.orderdate BETWEEN '1/1/05' AND '3/1/05' AND customer_orders_prod.product_id = 101 AND customer_orders_prod.qty = 1 AND customer.state = 'MN' AND (phone LIKE '%952%' OR phone LIKE '%651%' or Phone like '%763%' or Phone like '%612%') AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%') AND customer.category 5 GROUP BY customer_orders.id, customer.id, business Eric J. Hoffman Market Connections 2081 Industrial Blvd. Stillwater MN 55082 http://www.marketconnections.us T: 651.207.1526 F: 651.207.1536 M: 952.210.9060 E: [EMAIL PROTECTED] This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199799 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: divide by zero error
Eric J. Hoffman wrote: Can anyone identify where to look in this instance? Select DISTINCT customer.id as cid, customer.business, customer_orders.id, SUM (customer_orders_prod.qty) as totunits FROM customer_orders JOIN customer on customer.id = customer_orders.customer_id JOIN customer_contact on customer.id = customer_contact.customer_id LEFT OUTER JOIN customer_orders_prod on customer_orders.id = customer_orders_prod.order_id JOIN inventory on customer_orders_prod.product_id = inventory.service_id WHERE customer_orders.orderdate BETWEEN '1/1/05' AND '3/1/05' This ine is the only line that could possibly have a division. If you have a problem with the quotes and a date in the year 2000 you get 1/1/0 which will throw an error. Can you show the CF code? Are you using cfqueryparam for all your variables? Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199800 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: divide by zero error
its ugly because I couldn't get the loops to work inside the sql...suggestions
also welcomed. :)
!---GET CUSTOMER INFO
cfif form.area neq ''
cfset sql1 =
cfset listnum = 0
cfloop list=#form.area# index=m
cfset listnum = listnum + 1
cfset sql1 = '#sql1#' customer_contact.phone LIKE '%#trim(m)#%'
cfif listnum LT listLen(form.area)
cfset sql1 = '#sql1#' ' OR '
/cfif
/cfloop
/cfif
cfif form.zip NEQ ''
cfset sql2 =
cfset listnum1 = 0
cfloop list=#form.zip# index=p
cfset listnum1 = listnum1 + 1
cfset sql2 = '#sql2#' customer.zip LIKE '%#trim(p)#%'
cfif listnum1 LT listLen(form.zip)
cfset sql2 = '#sql2#' ' OR '
/cfif
/cfloop
/cfif
cfquery name=getcust#i# datasource=#heinz.dsn#
Select
DISTINCT customer.id as cid,
customer.business,
customer_orders.id,
SUM (customer_orders_prod.qty) as totunits
FROM customer_orders
JOIN customer on customer.id = customer_orders.customer_id
JOIN customer_contact on customer.id = customer_contact.customer_id
LEFT OUTER JOIN customer_orders_prod on customer_orders.id =
customer_orders_prod.order_id
WHERE customer_orders.orderdate BETWEEN #createODBCDate(DateAdd('D', -1,
form.start1))# AND #CreateODBCDate(DateAdd('D', 1, form.end1))#
AND customer_orders_prod.product_id = #i#
cfif form.lowcap GT 0 AND form.highcap GT 0
AND customer_orders_prod.qty BETWEEN #form.lowcap# AND #form.highcap#
/cfif
cfif form.lowcap GT 0 AND form.highcap EQ ''
AND customer_orders_prod.qty = #form.lowcap#
/cfif
cfif form.lowcap EQ '' AND form.highcap GT 0
AND customer_orders_prod.qty = #form.highcap#
/cfif
cfif form.state NEQ ''
AND customer.state = '#form.state#'
/cfif
cfif form.area neq ''
AND (#sql1#)
/cfif
cfif form.zip NEQ ''
AND (#sql2#)
/cfif
AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business NOT
LIKE '%HAS%' AND business NOT LIKE '%HAM%')
AND customer.category 5
GROUP BY customer_orders.id, customer.id, business
/cfquery
THANK YOU!!!
Eric
Eric J. Hoffman
Market Connections
2081 Industrial Blvd.
Stillwater
MN 55082
http://www.marketconnections.us
T: 651.207.1526
F: 651.207.1536
M: 952.210.9060
E: [EMAIL PROTECTED]
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Wed 3/23/2005 2:12 PM
To: CF-Talk
Subject: RE: divide by zero error
Is it a problem in the ColdFusion code rather than the SQL? I can't see
where you're doing any division in the code below.
Have you got the CF code for us to see?
Ade
-Original Message-
From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: 23 March 2005 20:05
To: CF-Talk
Subject: divide by zero error
Overview: run a cold fusion query against a datasource. Get a divide by
zero error. Take that query in SQL Query analyzer and type in the query
substituting values and it works fine. All values being input by cold
fusion appear correct as well.
Can anyone identify where to look in this instance?
IN case it helps, resultant query:
Select
DISTINCT customer.id as cid,
customer.business,
customer_orders.id,
SUM (customer_orders_prod.qty) as totunits
FROM customer_orders
JOIN customer on customer.id = customer_orders.customer_id
JOIN customer_contact on customer.id = customer_contact.customer_id
LEFT OUTER JOIN customer_orders_prod on customer_orders.id =
customer_orders_prod.order_id
JOIN inventory on customer_orders_prod.product_id = inventory.service_id
WHERE customer_orders.orderdate BETWEEN '1/1/05' AND '3/1/05'
AND customer_orders_prod.product_id = 101
AND customer_orders_prod.qty = 1
AND customer.state = 'MN'
AND (phone LIKE '%952%' OR phone LIKE '%651%' or Phone like '%763%' or
Phone like '%612%')
AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business
NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%')
AND customer.category 5
GROUP BY customer_orders.id, customer.id,
business
Eric J. Hoffman
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005
~|
Logware (www.logware.us): a new and convenient web-based
RE: Reading Session Variables
You can output cf variables in your javascript like this:
Alert(cfoutput#session.mysessionvariable#/cfoutput);
If that's what you mean.
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 23, 2005 2:04 PM
To: CF-Talk
Subject: Re: Reading Session Variables
It's not possible since session vars are server side only.
Regards,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm
--- On Wednesday, March 23, 2005 2:52 PM, Chad McCue scribed: ---
Does anyone know if it is possible to read session variables withing
Javascript?
Example,
Have a session variable called CompareList
CFSET session.CompareList = /
input type=hidden name=Session.CompareList
value=#Session.CompareList# /
JS:
function ReadList() {
var CurrCompareValues =
document.myform.Session.CompareList.value; // This doesn't
work because of the Session.Comparelist
alert(CurrCompareValues); }
name.
Thanks
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199802
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
WOT: networking question and list suggestion
Hi all, This is quite off topic, but I am sure a lot of people on the list sometimes have to deal with networking questions between two servers. I need to find (if it is possible) the connectivity or the speed of data transfer (via TCP/IP) between two servers in a wide area network. Is there a tool to do this or can this be done? Also are there any suggestions for a good mailing list for networking questions such as this? Thanks, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199803 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: divide by zero error
:Oo agghh my eyes!!
Only kidding :OD
I can't see any division in your code. Am I just being blind?
Do you have the error to show us? Is it a CF or SQL one?
Ade
-Original Message-
From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: 23 March 2005 20:17
To: CF-Talk
Subject: RE: divide by zero error
its ugly because I couldn't get the loops to work inside the
sql...suggestions also welcomed. :)
!---GET CUSTOMER INFO
cfif form.area neq ''
cfset sql1 =
cfset listnum = 0
cfloop list=#form.area# index=m
cfset listnum = listnum + 1
cfset sql1 = '#sql1#' customer_contact.phone LIKE '%#trim(m)#%'
cfif listnum LT listLen(form.area)
cfset sql1 = '#sql1#' ' OR '
/cfif
/cfloop
/cfif
cfif form.zip NEQ ''
cfset sql2 =
cfset listnum1 = 0
cfloop list=#form.zip# index=p
cfset listnum1 = listnum1 + 1
cfset sql2 = '#sql2#' customer.zip LIKE '%#trim(p)#%'
cfif listnum1 LT listLen(form.zip)
cfset sql2 = '#sql2#' ' OR '
/cfif
/cfloop
/cfif
cfquery name=getcust#i# datasource=#heinz.dsn#
Select
DISTINCT customer.id as cid,
customer.business,
customer_orders.id,
SUM (customer_orders_prod.qty) as totunits
FROM customer_orders
JOIN customer on customer.id = customer_orders.customer_id
JOIN customer_contact on customer.id = customer_contact.customer_id
LEFT OUTER JOIN customer_orders_prod on customer_orders.id =
customer_orders_prod.order_id
WHERE customer_orders.orderdate BETWEEN #createODBCDate(DateAdd('D', -1,
form.start1))# AND #CreateODBCDate(DateAdd('D', 1, form.end1))#
AND customer_orders_prod.product_id = #i#
cfif form.lowcap GT 0 AND form.highcap GT 0
AND customer_orders_prod.qty BETWEEN #form.lowcap# AND #form.highcap#
/cfif
cfif form.lowcap GT 0 AND form.highcap EQ ''
AND customer_orders_prod.qty = #form.lowcap#
/cfif
cfif form.lowcap EQ '' AND form.highcap GT 0
AND customer_orders_prod.qty = #form.highcap#
/cfif
cfif form.state NEQ ''
AND customer.state = '#form.state#'
/cfif
cfif form.area neq ''
AND (#sql1#)
/cfif
cfif form.zip NEQ ''
AND (#sql2#)
/cfif
AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business
NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%')
AND customer.category 5
GROUP BY customer_orders.id, customer.id, business
/cfquery
THANK YOU!!!
Eric
Eric J. Hoffman
Market Connections
2081 Industrial Blvd.
Stillwater
MN 55082
http://www.marketconnections.us
T: 651.207.1526
F: 651.207.1536
M: 952.210.9060
E: [EMAIL PROTECTED]
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message, which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version.
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Wed 3/23/2005 2:12 PM
To: CF-Talk
Subject: RE: divide by zero error
Is it a problem in the ColdFusion code rather than the SQL? I can't see
where you're doing any division in the code below.
Have you got the CF code for us to see?
Ade
-Original Message-
From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: 23 March 2005 20:05
To: CF-Talk
Subject: divide by zero error
Overview: run a cold fusion query against a datasource. Get a divide by
zero error. Take that query in SQL Query analyzer and type in the query
substituting values and it works fine. All values being input by cold
fusion appear correct as well.
Can anyone identify where to look in this instance?
IN case it helps, resultant query:
Select
DISTINCT customer.id as cid,
customer.business,
customer_orders.id,
SUM (customer_orders_prod.qty) as totunits
FROM customer_orders
JOIN customer on customer.id = customer_orders.customer_id
JOIN customer_contact on customer.id = customer_contact.customer_id
LEFT OUTER JOIN customer_orders_prod on customer_orders.id =
customer_orders_prod.order_id
JOIN inventory on customer_orders_prod.product_id = inventory.service_id
WHERE customer_orders.orderdate BETWEEN '1/1/05' AND '3/1/05'
AND customer_orders_prod.product_id = 101
AND customer_orders_prod.qty = 1
AND customer.state = 'MN'
AND (phone LIKE '%952%' OR phone LIKE '%651%' or Phone like '%763%' or
Phone like '%612%')
AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business
NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%')
AND customer.category 5
GROUP BY customer_orders.id, customer.id,
business
RE: divide by zero error
Also, what are you doing with the resultset? Are you doing ANY calculations? Ade -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199805 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WOT: networking question and list suggestion
George Abraham wrote: This is quite off topic, but I am sure a lot of people on the list sometimes have to deal with networking questions between two servers. I need to find (if it is possible) the connectivity or the speed of data transfer (via TCP/IP) between two servers in a wide area network. Is there a tool to do this or can this be done? A stopwatch. Nothing beats just transfering the data and measuring the time. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199806 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: divide by zero error
yeah, no division and a big ugly query. CF Error, and if I take out my ugly
workaround for zipcode or areacode it works fine.
DIAGNOSTIC:
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]Divide by zero error encountered.
The error occurred on line 127.
Eric J. Hoffman
Market Connections
2081 Industrial Blvd.
Stillwater
MN 55082
http://www.marketconnections.us
T: 651.207.1526
F: 651.207.1536
M: 952.210.9060
E: [EMAIL PROTECTED]
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Wed 3/23/2005 2:25 PM
To: CF-Talk
Subject: RE: divide by zero error
:Oo agghh my eyes!!
Only kidding :OD
I can't see any division in your code. Am I just being blind?
Do you have the error to show us? Is it a CF or SQL one?
Ade
-Original Message-
From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: 23 March 2005 20:17
To: CF-Talk
Subject: RE: divide by zero error
its ugly because I couldn't get the loops to work inside the
sql...suggestions also welcomed. :)
!---GET CUSTOMER INFO
cfif form.area neq ''
cfset sql1 =
cfset listnum = 0
cfloop list=#form.area# index=m
cfset listnum = listnum + 1
cfset sql1 = '#sql1#' customer_contact.phone LIKE '%#trim(m)#%'
cfif listnum LT listLen(form.area)
cfset sql1 = '#sql1#' ' OR '
/cfif
/cfloop
/cfif
cfif form.zip NEQ ''
cfset sql2 =
cfset listnum1 = 0
cfloop list=#form.zip# index=p
cfset listnum1 = listnum1 + 1
cfset sql2 = '#sql2#' customer.zip LIKE '%#trim(p)#%'
cfif listnum1 LT listLen(form.zip)
cfset sql2 = '#sql2#' ' OR '
/cfif
/cfloop
/cfif
cfquery name=getcust#i# datasource=#heinz.dsn#
Select
DISTINCT customer.id as cid,
customer.business,
customer_orders.id,
SUM (customer_orders_prod.qty) as totunits
FROM customer_orders
JOIN customer on customer.id = customer_orders.customer_id
JOIN customer_contact on customer.id = customer_contact.customer_id
LEFT OUTER JOIN customer_orders_prod on customer_orders.id =
customer_orders_prod.order_id
WHERE customer_orders.orderdate BETWEEN #createODBCDate(DateAdd('D', -1,
form.start1))# AND #CreateODBCDate(DateAdd('D', 1, form.end1))#
AND customer_orders_prod.product_id = #i#
cfif form.lowcap GT 0 AND form.highcap GT 0
AND customer_orders_prod.qty BETWEEN #form.lowcap# AND #form.highcap#
/cfif
cfif form.lowcap GT 0 AND form.highcap EQ ''
AND customer_orders_prod.qty = #form.lowcap#
/cfif
cfif form.lowcap EQ '' AND form.highcap GT 0
AND customer_orders_prod.qty = #form.highcap#
/cfif
cfif form.state NEQ ''
AND customer.state = '#form.state#'
/cfif
cfif form.area neq ''
AND (#sql1#)
/cfif
cfif form.zip NEQ ''
AND (#sql2#)
/cfif
AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%' AND business
NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%')
AND customer.category 5
GROUP BY customer_orders.id, customer.id, business
/cfquery
THANK YOU!!!
Eric
Eric J. Hoffman
Market Connections
2081 Industrial Blvd.
Stillwater
MN 55082
http://www.marketconnections.us
T: 651.207.1526
F: 651.207.1536
M: 952.210.9060
E: [EMAIL PROTECTED]
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message, which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version.
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Wed 3/23/2005 2:12 PM
To: CF-Talk
Subject: RE: divide by zero error
Is it a problem in the ColdFusion code rather than the SQL? I can't see
where you're doing any division in the code below.
Have you got the CF code for us to see?
Ade
RE: divide by zero error
no, no result setsjust outputtingit dies exactly in the query where I reference sql2 or sql1 as a variable. pull it out, its okay. But doing the loops in the query I couldn't get to work either, because its very hard to program through the pain meds. I don't recommend. Eric J. Hoffman Market Connections 2081 Industrial Blvd. Stillwater MN 55082 http://www.marketconnections.us T: 651.207.1526 F: 651.207.1536 M: 952.210.9060 E: [EMAIL PROTECTED] This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wed 3/23/2005 2:26 PM To: CF-Talk Subject: RE: divide by zero error Also, what are you doing with the resultset? Are you doing ANY calculations? Ade -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199808 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: divide by zero error
I do not see any division in sql but this may help... ( [num] / ( case [divider] when 0 then NULL else [divider] end)) Dave - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 23, 2005 3:26 PM Subject: RE: divide by zero error Also, what are you doing with the resultset? Are you doing ANY calculations? Ade -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: divide by zero error
Output #sql1# and #sql2# and see what it looks like. Ade -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 20:30 To: CF-Talk Subject: RE: divide by zero error no, no result setsjust outputtingit dies exactly in the query where I reference sql2 or sql1 as a variable. pull it out, its okay. But doing the loops in the query I couldn't get to work either, because its very hard to program through the pain meds. I don't recommend. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Free Coldfusion Devs Tool
Opening paragraph, shouldn't it be initially. Not initial? Initial created for personal use, the Coldfusion MX Remote Dashboard is a portable server monitor and administration tool. Will ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199811 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: OSI Hosting Company?
Just wondering if anyone uses OSI Hosting? Their web site claims they are building a facility here in Texarkana where I live and I'm trying to verify they are legit somehow. Any feedback greatly appreciated. TIA, Donna -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199812 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: WOT: networking question and list suggestion
Yeah. Have a baseline file that you use that is always the same size. You must also be cognizant that because unless you own and only control this direct line between the two servers, it will vary in time for file transfers. Eric J. Hoffman Market Connections 2081 Industrial Blvd. Stillwater MN 55082 http://www.marketconnections.us T: 651.207.1526 F: 651.207.1536 M: 952.210.9060 E: [EMAIL PROTECTED] This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wed 3/23/2005 2:25 PM To: CF-Talk Subject: Re: WOT: networking question and list suggestion George Abraham wrote: This is quite off topic, but I am sure a lot of people on the list sometimes have to deal with networking questions between two servers. I need to find (if it is possible) the connectivity or the speed of data transfer (via TCP/IP) between two servers in a wide area network. Is there a tool to do this or can this be done? A stopwatch. Nothing beats just transfering the data and measuring the time. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199813 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: divide by zero error
Eric J. Hoffman wrote:
cfquery name=getcust#i# datasource=#heinz.dsn#
SELECT
DISTINCT customer.id as cid,
customer.business,
customer_orders.id,
SUM (customer_orders_prod.qty) as totunits
FROM customer_orders
JOIN customer on customer.id = customer_orders.customer_id
JOIN customer_contact on customer.id =
customer_contact.customer_id
LEFT OUTER JOIN customer_orders_prod on customer_orders.id =
customer_orders_prod.order_id
WHERE customer_orders.orderdate BETWEEN cfqueryparam
value=#DateAdd('D', -1, form.start1)# AND cfqueryparam
value=#DateAdd('D', 1, form.end1)#
AND customer_orders_prod.product_id = cfqueryparam value=#i#
cfif form.lowcap GT 0 AND form.highcap GT 0
AND customer_orders_prod.qty BETWEEN cfqueryparam
value=#form.lowcap# AND cfqueryparam value=#form.highcap#
/cfif
cfif form.lowcap GT 0 AND form.highcap EQ ''
AND customer_orders_prod.qty = cfqueryparam
value=#form.lowcap#
/cfif
cfif form.lowcap EQ '' AND form.highcap GT 0
AND customer_orders_prod.qty = cfqueryparam
value=#form.highcap#
/cfif
cfif form.state NEQ ''
AND customer.state = cfqueryparam value=#form.state#
/cfif
cfif form.area neq ''
AND ( 1=0
cfloop list=#form.area# index=m
OR customer_contact.phone LIKE cfqueryparam
value=%#trim(m)#%
/cfloop
)
/cfif
cfif form.zip NEQ ''
AND ( 1=0
cfloop list=#form.zip# index=p
OR customer.zip LIKE cfqueryparam value=%#trim(p)#%
/cfloop
)
/cfif
AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%'
AND business NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%')
AND customer.category 5
GROUP BY customer_orders.id, customer.id, business
/cfquery
Jochem
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199814
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: divide by zero error
looks perfect SQL, thats what freaks me. example: customer_contact.phone LIKE '%952%' OR customer_contact.phone LIKE '%651%' so that makes that line: AND (customer_contact.phone LIKE '%952%' OR customer_contact.phone LIKE '%651%' ) yeah, no division anywhere and a big ugly query. CF Error, and if I take out my ugly workaround for zipcode or areacode it works fine. DIAGNOSTIC: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred on line 127. Eric J. Hoffman Market Connections 2081 Industrial Blvd. Stillwater MN 55082 http://www.marketconnections.us T: 651.207.1526 F: 651.207.1536 M: 952.210.9060 E: [EMAIL PROTECTED] This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wed 3/23/2005 2:38 PM To: CF-Talk Subject: RE: divide by zero error Output #sql1# and #sql2# and see what it looks like. Ade -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 20:30 To: CF-Talk Subject: RE: divide by zero error no, no result setsjust outputtingit dies exactly in the query where I reference sql2 or sql1 as a variable. pull it out, its okay. But doing the loops in the query I couldn't get to work either, because its very hard to program through the pain meds. I don't recommend. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199815 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WOT: networking question and list suggestion
Ha, I was too ignorant to know whether that was a joke or a well-intentioned suggestion. :-) However I am concerned that there is a bottleneck (in terms of old wiring and a bad connection to the Internet backbone) at one of the servers. And no, we don't own the line between the two servers. A direct fibre link would be sweet, but absolutely not practical. George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199816 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: divide by zero error
Eric J. Hoffman wrote: looks perfect SQL, thats what freaks me. example: customer_contact.phone LIKE '%952%' OR customer_contact.phone LIKE '%651%' so that makes that line: AND (customer_contact.phone LIKE '%952%' OR customer_contact.phone LIKE '%651%' ) It is correct SQL until you factor in that CF doubles the single quotes. Might the % be the MODULO operator in your particular SQL dialect? Anyhow, use the code I sent you, it solves some style issues and uses cfqueryparam instead of passthrough SQL. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199817 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: OSI Hosting Company?
Just wondering if anyone uses OSI Hosting? Their web site claims they are building a facility here in Texarkana where I live and I'm trying to verify they are legit somehow. pst.pt be careful Donna. When I've posted about hosting companies, they've been deemed as cf-community material. Just a heads up :) Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199818 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WOT: networking question and list suggestion
This is quite off topic, but I am sure a lot of people on the list sometimes have to deal with networking questions between two servers. I need to find (if it is possible) the connectivity or the speed of data transfer (via TCP/IP) between two servers in a wide area network. Is there a tool to do this or can this be done? Netperf: http://www.netperf.org/netperf/NetperfPage.html Also are there any suggestions for a good mailing list for networking questions such as this? Newsgroup comp.dcom.net-analysis would be a good place to find this type of information. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199819 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: divide by zero error
Ahhh, got it. THANK YOU!...and thanks for clearing/cleaning that up...I see
how you did the loop and got it to work inside the SQLI added
cfsqltype=CF_SQL_DATE to the two date fields and it magically worked.
THANK YOU AGAIN.
Eric J. Hoffman
Market Connections
2081 Industrial Blvd.
Stillwater
MN 55082
http://www.marketconnections.us
T: 651.207.1526
F: 651.207.1536
M: 952.210.9060
E: [EMAIL PROTECTED]
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wed 3/23/2005 2:50 PM
To: CF-Talk
Subject: Re: divide by zero error
Eric J. Hoffman wrote:
cfquery name=getcust#i# datasource=#heinz.dsn#
SELECT
DISTINCT customer.id as cid,
customer.business,
customer_orders.id,
SUM (customer_orders_prod.qty) as totunits
FROM customer_orders
JOIN customer on customer.id = customer_orders.customer_id
JOIN customer_contact on customer.id =
customer_contact.customer_id
LEFT OUTER JOIN customer_orders_prod on customer_orders.id =
customer_orders_prod.order_id
WHERE customer_orders.orderdate BETWEEN cfqueryparam
value=#DateAdd('D', -1, form.start1)# AND cfqueryparam
value=#DateAdd('D', 1, form.end1)#
AND customer_orders_prod.product_id = cfqueryparam value=#i#
cfif form.lowcap GT 0 AND form.highcap GT 0
AND customer_orders_prod.qty BETWEEN cfqueryparam
value=#form.lowcap# AND cfqueryparam value=#form.highcap#
/cfif
cfif form.lowcap GT 0 AND form.highcap EQ ''
AND customer_orders_prod.qty = cfqueryparam
value=#form.lowcap#
/cfif
cfif form.lowcap EQ '' AND form.highcap GT 0
AND customer_orders_prod.qty = cfqueryparam
value=#form.highcap#
/cfif
cfif form.state NEQ ''
AND customer.state = cfqueryparam value=#form.state#
/cfif
cfif form.area neq ''
AND ( 1=0
cfloop list=#form.area# index=m
OR customer_contact.phone LIKE cfqueryparam
value=%#trim(m)#%
/cfloop
)
/cfif
cfif form.zip NEQ ''
AND ( 1=0
cfloop list=#form.zip# index=p
OR customer.zip LIKE cfqueryparam value=%#trim(p)#%
/cfloop
)
/cfif
AND (business NOT LIKE '%HSR%' AND business NOT LIKE '%OSR%'
AND business NOT LIKE '%HAS%' AND business NOT LIKE '%HAM%')
AND customer.category 5
GROUP BY customer_orders.id, customer.id, business
/cfquery
Jochem
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199820
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: WOT: networking question and list suggestion
No, well intentioned. :) There are some utilities you can download that will do a little hunt-up for you... Sometimes, too, a good old fashioned tracert will let you watch each hop, tell you how long it is taking to get around...that way you can pinpoint maybe which segment is jacked up since there are likely several between you and the true backbone out there... We've had before that a local provider was blaming our internal network for speed issues...so we proved the internal systems were running top speed, and then showed them tracert results that things ran smoothly until 2 hops outside our network where they were involvedhard to argue with proof that the problem is upstream. Eric J. Hoffman Market Connections 2081 Industrial Blvd. Stillwater MN 55082 http://www.marketconnections.us T: 651.207.1526 F: 651.207.1536 M: 952.210.9060 E: [EMAIL PROTECTED] This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Wed 3/23/2005 2:54 PM To: CF-Talk Subject: Re: WOT: networking question and list suggestion Ha, I was too ignorant to know whether that was a joke or a well-intentioned suggestion. :-) However I am concerned that there is a bottleneck (in terms of old wiring and a bad connection to the Internet backbone) at one of the servers. And no, we don't own the line between the two servers. A direct fibre link would be sweet, but absolutely not practical. George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199821 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Process CF Page Then Cancel Response
I want to click on a link, have CF process some stuff (send an email) then that's it. I don't want the page to change in the browser. How do I do that? Thanks M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199822 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Process CF Page Then Cancel Response
it hasn't been talked about much here lately...but you could try the XMLHTTPRequest :) On Wed, 23 Mar 2005 15:53:04 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: I want to click on a link, have CF process some stuff (send an email) then that's it. I don't want the page to change in the browser. How do I do that? Thanks M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199823 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Process CF Page Then Cancel Response
Your best bet is to do some javascript. Change a hidden iframe, change an image src, call an XMLHttpRequest, or whatever. Have it hit a CFM page, then the current page will stay but your page will have been called -nathan strutz http://www.dopefly.com/ Dawson, Michael wrote: I want to click on a link, have CF process some stuff (send an email) then that's it. I don't want the page to change in the browser. How do I do that? Thanks M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199824 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Process CF Page Then Cancel Response
Is there a way to do it w/o Javascript? I was thinking that there may be some sort of header I could return to the browser that would make it ignore the request altogether. Thanks! -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 3:59 PM To: CF-Talk Subject: Re: Process CF Page Then Cancel Response Your best bet is to do some javascript. Change a hidden iframe, change an image src, call an XMLHttpRequest, or whatever. Have it hit a CFM page, then the current page will stay but your page will have been called -nathan strutz http://www.dopefly.com/ Dawson, Michael wrote: I want to click on a link, have CF process some stuff (send an email) then that's it. I don't want the page to change in the browser. How do I do that? Thanks M!ke ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199825 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Process CF Page Then Cancel Response
Dawson, Michael wrote: I want to click on a link, have CF process some stuff (send an email) then that's it. I don't want the page to change in the browser. How do I do that? Send a HTTP 204 status code in response without an actual response body: cfcontent reset=yescfheader statuscode=204cfabort Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199826 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free Coldfusion Devs Tool
Haha... I'm just a flash geek, not an english major. Good catch though... Thanks Kevin -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 1:39 PM To: CF-Talk Subject: Re: Free Coldfusion Devs Tool Opening paragraph, shouldn't it be initially. Not initial? Initial created for personal use, the Coldfusion MX Remote Dashboard is a portable server monitor and administration tool. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199827 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Process CF Page Then Cancel Response
Nathan Strutz wrote: Your best bet is to do some javascript. Javascript is not the right tool for this job. HTTP statuscode 204 No Content has been assigned specifically for this purpose: quote 10.2.5 204 No Content The server has fulfilled the request but does not need to return an entity-body, and might want to return updated metainformation. The response MAY include new or updated metainformation in the form of entity-headers, which if present SHOULD be associated with the requested variant. If the client is a user agent, it SHOULD NOT change its document view from that which caused the request to be sent. This response is primarily intended to allow input for actions to take place without causing a change to the user agent's active document view, although any new or updated metainformation SHOULD be applied to the document currently in the user agent's active view. The 204 response MUST NOT include a message-body, and thus is always terminated by the first empty line after the header fields. /quote RFC 2616, http://www.ietf.org/rfc/rfc2616.txt Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199828 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Process CF Page Then Cancel Response
Use a hidden iframe. I'd have to wonder why you would want that though. Surely if you click a link you want to at least know if the operation completed successfully? Spike Dawson, Michael wrote: Is there a way to do it w/o Javascript? I was thinking that there may be some sort of header I could return to the browser that would make it ignore the request altogether. Thanks! -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 3:59 PM To: CF-Talk Subject: Re: Process CF Page Then Cancel Response Your best bet is to do some javascript. Change a hidden iframe, change an image src, call an XMLHttpRequest, or whatever. Have it hit a CFM page, then the current page will stay but your page will have been called -nathan strutz http://www.dopefly.com/ Dawson, Michael wrote: I want to click on a link, have CF process some stuff (send an email) then that's it. I don't want the page to change in the browser. How do I do that? Thanks M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199829 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Process CF Page Then Cancel Response
Jochem van Dieten wrote: Nathan Strutz wrote: Your best bet is to do some javascript. Javascript is not the right tool for this job. HTTP statuscode 204 No Content has been assigned specifically for this purpose: Yeah, I just read your other post. Neat trick, I didn't know that one. -nathan strutz http://www.dopefly.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199830 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
DWMC2004 Can save files?
Does anyone know what's causing this? I get an error message when I try to save edited files in DWMX2004. While executing receiveArguments in File_Save.htm, the following JavaScript error(s) occurred: at line 75 of the c:\Program Files|Macromedia\DreamWeaver MX 2004\configuration\Menus\mm\File_Save.js: Exception thrown in native function. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199831 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Process CF Page Then Cancel Response
Jochem, this worked perfectly. Thanks M!ke -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 4:02 PM To: CF-Talk Subject: Re: Process CF Page Then Cancel Response Dawson, Michael wrote: I want to click on a link, have CF process some stuff (send an email) then that's it. I don't want the page to change in the browser. How do I do that? Send a HTTP 204 status code in response without an actual response body: cfcontent reset=yescfheader statuscode=204cfabort Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199832 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Process CF Page Then Cancel Response
I built a Click to add this event to your calendar link on our intranet site. The page emails a vCalendar message to the person who is logged in. This really isn't a mission-critical feature. Even if I put a confirmation page, that doesn't really mean the email actually got all the way to their inbox. Thanks! -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 4:07 PM To: CF-Talk Subject: Re: Process CF Page Then Cancel Response Use a hidden iframe. I'd have to wonder why you would want that though. Surely if you click a link you want to at least know if the operation completed successfully? Spike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199833 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Process CF Page Then Cancel Response
Ah yes, That makes sense. Thanks Spike Dawson, Michael wrote: I built a Click to add this event to your calendar link on our intranet site. The page emails a vCalendar message to the person who is logged in. This really isn't a mission-critical feature. Even if I put a confirmation page, that doesn't really mean the email actually got all the way to their inbox. Thanks! -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 4:07 PM To: CF-Talk Subject: Re: Process CF Page Then Cancel Response Use a hidden iframe. I'd have to wonder why you would want that though. Surely if you click a link you want to at least know if the operation completed successfully? Spike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199834 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RequestTimeout=900 equivalent for custom tags?
Is there a way I can specify a timeout value when I call a custom tag? I have a Custom Tag that relies on a web site that needs a little more time to complete. Sorry if this is a FAQ, I've been away. Thanks. -Nate ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199835 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RequestTimeout=900 equivalent for custom tags?
Is there a way I can specify a timeout value when I call a custom tag? I have a Custom Tag that relies on a web site that needs a little more time to complete. You can set the request timeout for the calling page itself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199836 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: RequestTimeout=900 equivalent for custom tags?
cfsetting requestTimeout=900 / cheers, barneyb On Wed, 23 Mar 2005 16:41:50 -0600, Nathan C. Smith [EMAIL PROTECTED] wrote: Is there a way I can specify a timeout value when I call a custom tag? I have a Custom Tag that relies on a web site that needs a little more time to complete. Sorry if this is a FAQ, I've been away. Thanks. -Nate -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199837 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RequestTimeout=900 equivalent for custom tags?
Thanks gentlemen! -Nate -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 4:48 PM To: CF-Talk Subject: Re: RequestTimeout=900 equivalent for custom tags? cfsetting requestTimeout=900 / cheers, barneyb On Wed, 23 Mar 2005 16:41:50 -0600, Nathan C. Smith [EMAIL PROTECTED] wrote: Is there a way I can specify a timeout value when I call a custom tag? I have a Custom Tag that relies on a web site that needs a little more time to complete. Sorry if this is a FAQ, I've been away. Thanks. -Nate -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199838 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Question about ColdFusionTraining.com
I'm looking into attending the Cold Fusion MX Master Course at ColdFusionTraining.com. Someone on this list (or cf-community) recently recommended this school, run by Adam and David Churvis. My question to the list is, has anyone here attended any of their classes? If so, do you recommend them? If so, why? If not, why not? Feel free to email me privately if you feel necessary. Thanks to all. John. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199839 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Question about ColdFusionTraining.com
John, We'd love to have you attend our April class. Remember that class size is limited to only three students, and it's taught by both David and me, so it's more like private mentoring than traditional training. It's also an exhausting class because it lasts from 8AM to 7PM for five days straight. Please feel free to call us at 770-446-8866 with any questions you may have. Gotta run-- taking my wife (aka, The Lovely And Talented Lisa) to dinner tonight. Yay! :) Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 - Original Message - From: John Stanley [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 23, 2005 5:50 PM Subject: Question about ColdFusionTraining.com I'm looking into attending the Cold Fusion MX Master Course at ColdFusionTraining.com. Someone on this list (or cf-community) recently recommended this school, run by Adam and David Churvis. My question to the list is, has anyone here attended any of their classes? If so, do you recommend them? If so, why? If not, why not? Feel free to email me privately if you feel necessary. Thanks to all. John. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199840 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
HTML Editor
Hello All, I am sorry for being OT but I was wondering if anyone could point me in the right direction in regards to an HTML Editor that can be used for my users to edit their own pages. I have been using FCK editor and SoEditor but find that their support for stylesheets is terrible. Can an anyone recommend a good reliable editor that I can use or buy. Thanks Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199841 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: HTML Editor
Why not Dreamweaver MX 2004? That's my favorite one. -Dustin -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 3:02 PM To: CF-Talk Subject: HTML Editor Hello All, I am sorry for being OT but I was wondering if anyone could point me in the right direction in regards to an HTML Editor that can be used for my users to edit their own pages. I have been using FCK editor and SoEditor but find that their support for stylesheets is terrible. Can an anyone recommend a good reliable editor that I can use or buy. Thanks Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199842 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
