Re: Replace comma in replace list
I don't know if you can do it with the ReplaceList function at all... But you can wrap your var with a replace first.. Example: ,|,:,$,.,',&,@,#chr(44)#","_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_")#"> hope this helps. -- Sam On Wed, Jun 25, 2008 at 1:49 PM, Robert Harrison <[EMAIL PROTECTED]> wrote: > How do I indicate a comma in a replace list so I can replace the comma? > > Example: > ,/,\,*,?,<,>,|,:,$,.,',&,@,#chr(44)#", > "_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_")#"> > > chr(44) is the comma, but that doesn't work and neither does ,,. > > > Robert B. Harrison > Director of Interactive services > Austin & Williams > 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 > T : 631.231.6600 Ext. 119 > F : 631.434.7022 > www.austin-williams.com > > Great advertising can't be either/or... It must be &. > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop using to much memory
I'm using a java stringbuffer which works great for the portion of the code, but the main issue is with the cfloop tag. On Wed, Jun 25, 2008 at 6:51 PM, Brian Kotek <[EMAIL PROTECTED]> wrote: > If you aren't, use a Java StringBuffer or StringBuilder to build up the > CSV. > If you do the concatenation using CF you'll use large amounts of memory > because every concatenation creates a new String object. > > On Wed, Jun 25, 2008 at 9:26 PM, Dan Vega <[EMAIL PROTECTED]> wrote: > > > Are you using CF8 because they made many improvements to this very > problem > > in 8. > > > > Dan > > > > > > On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach <[EMAIL PROTECTED]> > > wrote: > > > > > We are trying to create a CSV file with about 250,000 rows with about > 40 > > > dynamic columns which we need to loop over so we can get the correct > > order. > > > > > > We see an issue coming from the nested loops on the large dataset and > the > > > server is running out of memory. We took a step back on even doing a > > > simple loop over over a large set of rows seems to have the same > issues. > > > Anyone have any ideas how to deal with this? > > > > > > If you run this code on watch the memory on the CF Server it will just > > keep > > > climbing until garbage collection runs. > > > > > > > > > > > > > > > > > > > > > > > > thanks, > > > -- Sam > > > > > > > > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop using to much memory
Yes I am using CF8. On Wed, Jun 25, 2008 at 6:26 PM, Dan Vega <[EMAIL PROTECTED]> wrote: > Are you using CF8 because they made many improvements to this very problem > in 8. > > Dan > > > On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach <[EMAIL PROTECTED]> > wrote: > > > We are trying to create a CSV file with about 250,000 rows with about 40 > > dynamic columns which we need to loop over so we can get the correct > order. > > > > We see an issue coming from the nested loops on the large dataset and the > > server is running out of memory. We took a step back on even doing a > > simple loop over over a large set of rows seems to have the same issues. > > Anyone have any ideas how to deal with this? > > > > If you run this code on watch the memory on the CF Server it will just > keep > > climbing until garbage collection runs. > > > > > > > > > > > > > > > > thanks, > > -- Sam > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trying to read a text file of data and input into db...
On Wed, Jun 25, 2008 at 8:47 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > I think I see what's happening... when the file is read > with cffile, the variable, "hmls_offices", apparently has > all the chr(9)'s, chr(10)'s, and chr(13)'s stripped out. those characters aren't rendered by the browser, so you won't see them. doesn't mean they're stripped out. try changing your delimiters attribute of your from: delimiters = "#chr(13)#, #chr(10)#" to: delimiters = "#chr(13)#&#chr(10)#" -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Trying to read a text file of data and input into db...
I think I see what's happening... when the file is read with cffile, the variable, "hmls_offices", apparently has all the chr(9)'s, chr(10)'s, and chr(13)'s stripped out. Do I need some kind of "preserveHTML" function or something? Rick > -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2008 11:40 PM > To: CF-Talk > Subject: RE: Trying to read a text file of data and input into db... > > Oops... list="hmls_offices" should have been list = "#hmls_offices#" > > Now, I get an error stating: > > Expression Exception - in > E:\Inetpub\webroot\c21-ar-homesite\tasks\0_process_hmls_offices_text_file.cfm > : line 14 > Invalid list index 3. > (Index 3 is the " > Thoughts? > > > "e:\inetpub\webroot\real_estate_data\hmls\data\#DateFormat(now(), > '_mmdd')#_idx_custom\office.txt"> > > > > > > > > > > > > > > > > > > > > > #record# > > > > office_id = #office_id# > office_name = #office_name# > street_no_street_name = #street_no_street_name# > address_02 = #address_02# > city = #city# > state = #state# > zipcode = #zipcode# > phone = #phone# > fax = #fax# > email = #email# > > > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to read a text file of data and input into db...
Oops... list="hmls_offices" should have been list = "#hmls_offices#" Now, I get an error stating: Expression Exception - in E:\Inetpub\webroot\c21-ar-homesite\tasks\0_process_hmls_offices_text_file.cfm : line 14 Invalid list index 3. (Index 3 is the " #record# office_id = #office_id# office_name = #office_name# street_no_street_name = #street_no_street_name# address_02 = #address_02# city = #city# state = #state# zipcode = #zipcode# phone = #phone# fax = #fax# email = #email# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to read a text file of data and input into db...
Well, here's the code I'm trying, but I get nothing on the screen... no errors, no output, either... Suggestions, anyone? Rick #record# office_id = #office_id# office_name = #office_name# street_no_street_name = #street_no_street_name# address_02 = #address_02# city = #city# state = #state# zipcode = #zipcode# phone = #phone# fax = #fax# email = #email# > -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2008 10:59 PM > To: CF-Talk > Subject: RE: Trying to read a text file of data and input into db... > > Hi, Dave... > > Yes, it is a tab-delimited file. I've already been > manually importing several different documents into MySQL 5 > using Navicat. I've got the manual approach down pat, but > need to automate this part. > > I did find this technique written up online from 2003, which > I'll try to incorporate into the solution. (And I did try > using #record# instead of #hmls_offices#, but the entire file > was output again...) > > > list="#str_Content#" > delimiters="#chr(13)##chr(10)#" > index="str_Line"> > > > > listGetAt(str_Line, 1, ",")> > listGetAt(str_Line, 2, ",")> > listGetAt(str_Line, 3, ",")> > > > > > > > > > -Original Message- > > From: Dave Francis [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, June 25, 2008 10:02 PM > > To: CF-Talk > > Subject: RE: Trying to read a text file of data and input into db... > > > > Off the top of my head, shouldn't it be #record#? > > And I know you said tab-delimited, but have you confirmed that it really > > is? ie what does listlen(list,Chr(09)) give you. > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOOP - why are there duplicates?
I assume the insert is going directly into a table and not into a query? -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 19 June 2008 20:35 To: CF-Talk Subject: Re: CFLOOP - why are there duplicates? Thanks. I thought I was going crazy. >[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: >> That's why I'm showing the following after the first query and >> it confirms that it's the 100k >> #getmailids.recordcount# >> >> Strange isn't it? > >There isn't anything in the code you have shown so far that would >account for there to be more inserts then the number of records in the >getMailIds record set. So the search would have to be expanded to see >if there is anyway that this code is being run twice or does something >happen in the database to somehow cause duplication of data. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to read a text file of data and input into db...
Hi, Dave... Yes, it is a tab-delimited file. I've already been manually importing several different documents into MySQL 5 using Navicat. I've got the manual approach down pat, but need to automate this part. I did find this technique written up online from 2003, which I'll try to incorporate into the solution. (And I did try using #record# instead of #hmls_offices#, but the entire file was output again...) > -Original Message- > From: Dave Francis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2008 10:02 PM > To: CF-Talk > Subject: RE: Trying to read a text file of data and input into db... > > Off the top of my head, shouldn't it be #record#? > And I know you said tab-delimited, but have you confirmed that it really > is? ie what does listlen(list,Chr(09)) give you. > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to read a text file of data and input into db...
Off the top of my head, shouldn't it be #record#? And I know you said tab-delimited, but have you confirmed that it really is? ie what does listlen(list,Chr(09)) give you. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 9:26 PM To: CF-Talk Subject: Trying to read a text file of data and input into db... Hi, all... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfloop using to much memory
If you aren't, use a Java StringBuffer or StringBuilder to build up the CSV. If you do the concatenation using CF you'll use large amounts of memory because every concatenation creates a new String object. On Wed, Jun 25, 2008 at 9:26 PM, Dan Vega <[EMAIL PROTECTED]> wrote: > Are you using CF8 because they made many improvements to this very problem > in 8. > > Dan > > > On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach <[EMAIL PROTECTED]> > wrote: > > > We are trying to create a CSV file with about 250,000 rows with about 40 > > dynamic columns which we need to loop over so we can get the correct > order. > > > > We see an issue coming from the nested loops on the large dataset and the > > server is running out of memory. We took a step back on even doing a > > simple loop over over a large set of rows seems to have the same issues. > > Anyone have any ideas how to deal with this? > > > > If you run this code on watch the memory on the CF Server it will just > keep > > climbing until garbage collection runs. > > > > > > > > > > > > > > > > thanks, > > -- Sam > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop using to much memory
Are you using CF8 because they made many improvements to this very problem in 8. Dan On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach <[EMAIL PROTECTED]> wrote: > We are trying to create a CSV file with about 250,000 rows with about 40 > dynamic columns which we need to loop over so we can get the correct order. > > We see an issue coming from the nested loops on the large dataset and the > server is running out of memory. We took a step back on even doing a > simple loop over over a large set of rows seems to have the same issues. > Anyone have any ideas how to deal with this? > > If you run this code on watch the memory on the CF Server it will just keep > climbing until garbage collection runs. > > > > > > > > thanks, > -- Sam > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Trying to read a text file of data and input into db...
Hi, all... I'm trying to read a tab-delimited text file of data and separate it into field data so I can input it into a database. I can read the file, and output the entire contents, but nothing I tried worked to output the contents into separate pieces of data and separate records. The code below just outputs everything. Anyone have a little help for what I should add next to this code? (At first I'm just trying to separate the data into the individual parts for the fields and records...after that I can insert it into my db...) I picked up the code below online, but couldn't find a way to make it work. Thanks for any clues! Rick #hmls_offices# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfloop using to much memory
We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step back on even doing a simple loop over over a large set of rows seems to have the same issues. Anyone have any ideas how to deal with this? If you run this code on watch the memory on the CF Server it will just keep climbing until garbage collection runs. thanks, -- Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: deploying and using jar files
On Wed, Jun 25, 2008 at 4:50 PM, Brad Wood wrote: > Nicely done. I am curious though, how did it manage to work on the > Linux server? Random guess: they already had all the needed information on the linux server. :-) |Denny -- When someone asks you, A penny for your thoughts, and you put your two cents in, what happens to the other penny? George Carlin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cffile upload temporary folder changes
On Tue, Jun 24, 2008 at 11:42 PM, James Holmes wrote: > As we're lucky enough that it's only happened in dev and test and not > prod (yet) I'm waiting until we change to our new CF8 architecture > before expending any effort. If it happens in prod I'll just make > /var/tmp writeable for the CF user. > > I still win the list :P Hmmm... I dunno -- if it's not happening in production, I'm not sure it qualifies as a /true/ CF-TALK question. ;-] Seriously, it sounds like the system temp folder is leaking in (duh;]), so just be sure that what leaks in, is the same as what's already in there... -- Well, if crime fighters fight crime and fire fighters fight fire, what do freedom fighters fight? They never mention that part to us, do they? George Carlin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: deploying and using jar files
Nicely done. I am curious though, how did it manage to work on the Linux server? ~Brad -Original Message- From: Doug Boude (rhymes with 'loud') [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 5:44 PM To: CF-Talk Subject: Re: deploying and using jar files Ah, as it turns out, it IS as simple as dropping the jar files into the /lib directory. The issue was that there was a supporting jar file that the client failed to give me (and tell me about in the first place), as well as a .properties file that needed to live in my WEB-INF\classes directory. Those pesky clients. They're just rascals, aren't they? :) Doug ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: deploying and using jar files
Ah, as it turns out, it IS as simple as dropping the jar files into the /lib directory. The issue was that there was a supporting jar file that the client failed to give me (and tell me about in the first place), as well as a .properties file that needed to live in my WEB-INF\classes directory. Those pesky clients. They're just rascals, aren't they? :) Doug >Have you tried putting the jar in this path > >C:\ColdFusion8\wwwroot\WEB-INF\lib > >Thanks > > > >On Wed, Jun 25, 2008 at 5:56 PM, Doug Boude (rhymes with 'loud') < >[EMAIL PROTECTED]> wrote: > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: deploying and using jar files
Have you tried putting the jar in this path
C:\ColdFusion8\wwwroot\WEB-INF\lib
Thanks
On Wed, Jun 25, 2008 at 5:56 PM, Doug Boude (rhymes with 'loud') <
[EMAIL PROTECTED]> wrote:
> Okay, from what I've read thus far, deploying a jar file is so easy that
> even a monkey could do it. As I understand it, if I drop the jar file into
> the /lib directory and then restart CF 8, it will magically be available to
> me. Only, I must be missing something because this hasn't been the case.
> Here are the details:
>
> I am working on a project that requires the use of java proxies. I am in
> the process of setting up my local environment using CF8 developer edition,
> standalone. I drop the jar file (Wdqc00sm.jar) into the /lib directory and
> restart. I then attempt to execute a template with two lines in it:
> createobject("Java","Wdqc00sm.Abean.Wdqc00s1SecurityAuthorization").Init()>
>
>
> and promptly get the error:
> Object Instantiation Exception.
> An exception occurred when instantiating a Java object. The class must not
> be an interface or an abstract class. Error:
> com/ca/gen75/jprt/ProxyException.
>
> Now, if I take the exact same template and execute it on the remote dev
> server where CF8 is running J2EE style on Linux (which I can't develop on
> due to other issues), with the same jar file deployed there, the object is
> created and dumps just fine.
>
> SO, can anybody tell me what I have to do to successfully install/deploy
> this jar file locally?
>
> Any input is MUCH appreciated. :)
>
> Doug
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308153
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replace comma in replace list
You can't supply an alternate delimiter to replaceList, unfortunately, so that won't work. cheers, barneyb On Wed, Jun 25, 2008 at 3:05 PM, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > Change your list delimiter so a comma isn't interpreted as a delimiter. > Check out listChangeDelims() (or something like that) > > ..:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Replace comma in replace list
Change your list delimiter so a comma isn't interpreted as a delimiter. Check out listChangeDelims() (or something like that) ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 4:50 PM To: CF-Talk Subject: Replace comma in replace list How do I indicate a comma in a replace list so I can replace the comma? Example: ,|,:,$,.,',&,@,#chr(44)#", "_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_")#"> chr(44) is the comma, but that doesn't work and neither does ,,. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
deploying and using jar files
Okay, from what I've read thus far, deploying a jar file is so easy that even a monkey could do it. As I understand it, if I drop the jar file into the /lib directory and then restart CF 8, it will magically be available to me. Only, I must be missing something because this hasn't been the case. Here are the details: I am working on a project that requires the use of java proxies. I am in the process of setting up my local environment using CF8 developer edition, standalone. I drop the jar file (Wdqc00sm.jar) into the /lib directory and restart. I then attempt to execute a template with two lines in it: and promptly get the error: Object Instantiation Exception. An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. Error: com/ca/gen75/jprt/ProxyException. Now, if I take the exact same template and execute it on the remote dev server where CF8 is running J2EE style on Linux (which I can't develop on due to other issues), with the same jar file deployed there, the object is created and dumps just fine. SO, can anybody tell me what I have to do to successfully install/deploy this jar file locally? Any input is MUCH appreciated. :) Doug ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replace comma in replace list
I think you have to do it separately. So do your replaceList for everything except comma, and then follow it up with a replace for just the comma. cheers, barneyb On Wed, Jun 25, 2008 at 1:49 PM, Robert Harrison <[EMAIL PROTECTED]> wrote: > How do I indicate a comma in a replace list so I can replace the comma? > > Example: > ,/,\,*,?,<,>,|,:,$,.,',&,@,#chr(44)#", > "_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_")#"> > > chr(44) is the comma, but that doesn't work and neither does ,,. > > > Robert B. Harrison > Director of Interactive services > Austin & Williams > 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 > T : 631.231.6600 Ext. 119 > F : 631.434.7022 > www.austin-williams.com > > Great advertising can't be either/or... It must be &. > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Replace comma in replace list
How do I indicate a comma in a replace list so I can replace the comma? Example: ,|,:,$,.,',&,@,#chr(44)#", "_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_")#"> chr(44) is the comma, but that doesn't work and neither does ,,. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 cftextarea richtext is stealing form focus, and being referred to by the form
In addition, FCKConfig.StartupFocus= false; in fckconfig.js ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 cftextarea richtext is stealing form focus, and being referred to by the form
Hello, I am having an issue where a cftextarea field on a cfform is stealing form focus without explicity being told to focus on it. If I switch out of richtext mode it works fine. I have tried setting focus on another field, but I think because of the fckeditor startup delay, without doing a timed call, it steals it back. In addition, since what I really want to do is toggle my div's innerHTML (I know.. I know) the fact that I initially hide the div area containing the cftextarea in richtext mode it fails trying to focus on it, well because I strip it out of the div on initial view. Grrr.. Anyway, anyone know how to make cftextarea/cfform combo stop taking focus ?? Thanks, Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: More Funky Email Address Validation Stuff
> http://haacked.com/archive/2007/08/21/i-knew-how-to-validate-an-email-address-until-i.aspx Jezz, it's worse than we all thought, huh? Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Decent Eclipse plugin for SQL editing?
Although I haven't used it myself but MyEclipse comes with a DB plugin which looks nice. On Wed, Jun 25, 2008 at 2:10 PM, Nathan Strutz <[EMAIL PROTECTED]> wrote: > Mark, > > I tried out the Eclipse Data Tools plugin a while ago and blogged it here: > > http://www.dopefly.com/techblog/entry.cfm?entry=243 > > nathan strutz > http://www.dopefly.com/ > > On Wed, Jun 25, 2008 at 6:43 AM, Gaulin, Mark <[EMAIL PROTECTED]> > wrote: > > > Hi > > I'm looking for an Eclipse plugin (for 3.2) that will do syntax > > highlighting and such for SQL (T-SQL specifically, but I don't care > > about that), specifically for *.sql files. > > > > I tried SQL Explorer but it does a pretty lame job of syntax > > highlighting while editing existing sql files... it appears to need > > something like CFE's "refresh syntax highlighting" because only the > > lines you actually edit get highlighted and the rest are plain text. > > > > There are other plugins out there but I value this group's opinions. > > > > Thanks > >Mark > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF tags in CFFILE write
Whoa, I think it's time for a coffee break... :) -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Been looking at this code for 9 hours straight now. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
Thanks Brad,
I should have known that, and I should have looked harder. Been looking at
this code for 9 hours straight now.
Thanks again.
Rick
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: June-25-08 3:20 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
You'll notice my example also has cfoutput tags wrapped around it.
Does yours?
~Brad
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 1:07 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Hey Brad,
Thanks for the tip but I tried that already. It just outputs [#Loop#] in
the
file I'm writing.
I am in a block btw.
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: June-25-08 3:02 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
In ColdFusion, you need to wrap a variable in pound signs (#) for its
value to be output.
var lat[#Loop#] = {latitude};
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 12:55 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Well,
The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].
var lat[Loop] = {latitude};
Within the cfsavecontent, how can I make the row number show up in the
loop
when I define it?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308142
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
You'll notice my example also has cfoutput tags wrapped around it.
Does yours?
~Brad
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 1:07 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Hey Brad,
Thanks for the tip but I tried that already. It just outputs [#Loop#] in
the
file I'm writing.
I am in a block btw.
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: June-25-08 3:02 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
In ColdFusion, you need to wrap a variable in pound signs (#) for its
value to be output.
var lat[#Loop#] = {latitude};
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 12:55 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Well,
The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].
var lat[Loop] = {latitude};
Within the cfsavecontent, how can I make the row number show up in the
loop
when I define it?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308141
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Decent Eclipse plugin for SQL editing?
Mark, I tried out the Eclipse Data Tools plugin a while ago and blogged it here: http://www.dopefly.com/techblog/entry.cfm?entry=243 nathan strutz http://www.dopefly.com/ On Wed, Jun 25, 2008 at 6:43 AM, Gaulin, Mark <[EMAIL PROTECTED]> wrote: > Hi > I'm looking for an Eclipse plugin (for 3.2) that will do syntax > highlighting and such for SQL (T-SQL specifically, but I don't care > about that), specifically for *.sql files. > > I tried SQL Explorer but it does a pretty lame job of syntax > highlighting while editing existing sql files... it appears to need > something like CFE's "refresh syntax highlighting" because only the > lines you actually edit get highlighted and the rest are plain text. > > There are other plugins out there but I value this group's opinions. > > Thanks >Mark > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF tags in CFFILE write
Hey Brad,
Thanks for the tip but I tried that already. It just outputs [#Loop#] in the
file I'm writing.
I am in a block btw.
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: June-25-08 3:02 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
In ColdFusion, you need to wrap a variable in pound signs (#) for its
value to be output.
var lat[#Loop#] = {latitude};
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 12:55 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Well,
The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].
var lat[Loop] = {latitude};
Within the cfsavecontent, how can I make the row number show up in the
loop
when I define it?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308139
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
In ColdFusion, you need to wrap a variable in pound signs (#) for its
value to be output.
var lat[#Loop#] = {latitude};
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 12:55 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Well,
The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].
var lat[Loop] = {latitude};
Within the cfsavecontent, how can I make the row number show up in the
loop
when I define it?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308138
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
Well,
The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].
var lat[Loop] = {latitude};
Within the cfsavecontent, how can I make the row number show up in the loop
when I define it?
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: June-24-08 10:05 PM
To: CF-Talk
Subject: Re: CF tags in CFFILE write
Build the output using cfsavecontent and write the result using the cffile
tag.
On Wed, Jun 25, 2008 at 8:37 AM, Rick Sanders <[EMAIL PROTECTED]> wrote:
> Hey everyone,
>
>
>
> I need to dynamically write a javascript file from Cold fusion. However,
it
> keeps giving me errors. Is there a way to write a file using cf tags in
the
> output?
--
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: More Funky Email Address Validation Stuff
Read this: http://haacked.com/archive/2007/08/21/i-knew-how-to-validate-an-email-ad dress-until-i.aspx ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: More Funky Email Address Validation Stuff
> GeorgeO'[EMAIL PROTECTED] Wait! I'm *WRONG*!!! It's valid This is crap It clears! Ain't clearing any of my regx though. Hmmm. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
More Funky Email Address Validation Stuff
Validating email addresses for imported list for a particular client is driving me nutz. They keep sending me more crazy email addresses going "hey, it's a legal address" - but it's something odd that won't clear either CF "isvalid" or any of the regx stuff I've tried. Here's the latest (not a real address - but you get the idea): GeorgeO'[EMAIL PROTECTED] The CFMAIL tag will actually try to send this out without choking on it, but nothing I've tried will clear this through validation without allowing all sorts of other illegal crap through. Ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: variables.whatever isn't defined in CFC
Then I'd start checking things that run on every request like Application.cfc onRequestStart, Fusebox preprocess or other plugin points, etc. The bottom line is that it *has* to be running something that is causing a cfcookie error. On Wed, Jun 25, 2008 at 12:23 PM, Ian Rutherford < [EMAIL PROTECTED]> wrote: > Hi Brian, > > I did a full project search in Eclipse and it isn't anywhere in the > project. I'm not including any files in either the wrapper or the other cfc. > > I'm using FB3 which I have heard can do some strange things to layout tags > like cfpod and cflayout but there aren't any cookies there either. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: variables.whatever isn't defined in CFC
Create a temp scribble page and call that cfc, passing in only the bare essentials to make it run. And do some cfdumps or cflog entries to see where it is failing. If you're on CF8, the step debugger is a useful tool to see what all pages have been called, variables created (including cookies), etc. On Wed, Jun 25, 2008 at 11:23 AM, Ian Rutherford <[EMAIL PROTECTED]> wrote: > Hi Brian, > > I did a full project search in Eclipse and it isn't anywhere in the project. > I'm not including any files in either the wrapper or the other cfc. > > I'm using FB3 which I have heard can do some strange things to layout tags > like cfpod and cflayout but there aren't any cookies there either. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: variables.whatever isn't defined in CFC
Hi Brian, I did a full project search in Eclipse and it isn't anywhere in the project. I'm not including any files in either the wrapper or the other cfc. I'm using FB3 which I have heard can do some strange things to layout tags like cfpod and cflayout but there aren't any cookies there either. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
> Thanks for your thoughts. Once you read it, i think you'll > see the tutorial does actually explain the terms. > > At the end of the tutorial, readers will have seen examples > of encapsulation, used the variables scope and var scope, and > hopefully seen the difference between them, cfqueryparam, > init() methods, seen the benefits of isolating all queries > to a single file, designing forms for multple uses, and > getting used to the notion of reusing code. Also passing > arguments into a method using objects rather than just simple > strings or numbers. I have tried to make the terms sneak > up on them rather than be up there and obvious. That sounds like a perfect approach, then. Thanks! 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRUN.exe
I feel your pain, having only recently gotten rid of a very weak server. We also had server performance issues that are results of bad application code. A few important logs to look at include: 1) exception.log This one has some pretty cryptic Java stack traces, but the information is very helpful once you get the hang of it. 2) application.log Look for the "Request timed out" messages in there. 3) server.log Search for the phrase "ColdFusion started" to see if there is any unexpected restarts I have been using MS Log Parser 2.2 to make my log files more human-readable. You can download it at: http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en On Wed, Jun 25, 2008 at 11:52 AM, Smith, Daron [PA] <[EMAIL PROTECTED]> wrote: > We are having an issue with Jrun.exe consuming over well over 50% of > CPU. If we restart the CF application server it goes back down to > almost nothing. We are running CF MX 7 . Is there any logging that > would help us nail down if this is code related. We have had numerous > hardware related issues on this box as well so we aren't sure if it's > code or hardware that is causing our problem. This box is going away > soon, but we need the site that's on it to run for another couple of > months. > > Thanks for any help you can give in tracking this down. > > Daron Smith > > "PSEA E-mail Firewall" annotation on Wed Jun 25 2008 11:52:23 > > - > > > NOTICE: Only the individual sender is responsible for the content of the > message, and the message does not necessarily reflect the position or policy > of the Pennsylvania State Education Association. > - > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: variables.whatever isn't defined in CFC
Ian, have you focused your search in the /adminCFCs/couponWrapper.cfc file since that appears to be where ColdFusion found the "Attribute validation error for the CFCOOKIE tag"? Is there a stack trace that accompanies the error message that gives you any hints? Perhaps you could go through the couponWrapper.cfc file and check for any included files which might contain cookie logic. If you are using Eclipse it will usually collapse sections of code for you automatically so it may not be visible. (Right click, expand all) ~Brad On Wed, Jun 25, 2008 at 11:42 AM, Ian Rutherford < [EMAIL PROTECTED]> wrote: > I have it one file in the project but it isn't being called on these pages. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: variables.whatever isn't defined in CFC
I'm not sure what to tell you then, because CF appears to think that it is being called, or at least that a cfcookie tag is being called and is causing some kind of problem. My instinct would be that either you missed a cfcookie tag somewhere, or that whatever you are doing is calling the code that has the cfcookie tag in it and you are just not aware that it is happening. Without more information I can't really offer any advice other than to carefully step through the code using cfdump and cfabort where appropriate and try to track down the source of the error. I can tell you with certainty that simply using a CFC doesn't do anything with the cfcookie tag, so the problem must be somewhere else in your code. On Wed, Jun 25, 2008 at 11:42 AM, Ian Rutherford < [EMAIL PROTECTED]> wrote: > I have it one file in the project but it isn't being called on these pages. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308127 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
JRUN.exe
We are having an issue with Jrun.exe consuming over well over 50% of CPU. If we restart the CF application server it goes back down to almost nothing. We are running CF MX 7 . Is there any logging that would help us nail down if this is code related. We have had numerous hardware related issues on this box as well so we aren't sure if it's code or hardware that is causing our problem. This box is going away soon, but we need the site that's on it to run for another couple of months. Thanks for any help you can give in tracking this down. Daron Smith "PSEA E-mail Firewall" annotation on Wed Jun 25 2008 11:52:23 - NOTICE: Only the individual sender is responsible for the content of the message, and the message does not necessarily reflect the position or policy of the Pennsylvania State Education Association. - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: variables.whatever isn't defined in CFC
I have it one file in the project but it isn't being called on these pages. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Spry Menu / Flash Collision Problem
I sent this out a couple of months ago, but maybe someone has seen a solution since. When you use Adobe's new spry menus AND use an interactive Adobe Flash on the same page, they don't play well together. It looks like they are competing for the same resources on the video card. Has anyone successfully combined the use of Spry Menus and Interactive Flash on the same page and, if so, can you offer some insight as to how to solve the problem? Thanks Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: variables.whatever isn't defined in CFC
So the problem now is the cfcookie tag? Try doing a global search for cfcookie since you must be using it somewhere from what the error says. On Wed, Jun 25, 2008 at 10:30 AM, Ian Rutherford < [EMAIL PROTECTED]> wrote: > Any other thoughts on this? I'm stuck. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: variables.whatever isn't defined in CFC
So the problem now is the cfcookie tag? Try doing a global search for cfcookie since you must be using it somewhere from what the error says. On Wed, Jun 25, 2008 at 10:30 AM, Ian Rutherford < [EMAIL PROTECTED]> wrote: > Any other thoughts on this? I'm stuck. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: variables.whatever isn't defined in CFC
Any other thoughts on this? I'm stuck. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Decent Eclipse plugin for SQL editing?
Hi I'm looking for an Eclipse plugin (for 3.2) that will do syntax highlighting and such for SQL (T-SQL specifically, but I don't care about that), specifically for *.sql files. I tried SQL Explorer but it does a pretty lame job of syntax highlighting while editing existing sql files... it appears to need something like CFE's "refresh syntax highlighting" because only the lines you actually edit get highlighted and the rest are plain text. There are other plugins out there but I value this group's opinions. Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do you setup an empty structure
You might also try removing the default attribute. -Original Message- From: Kamru Miah [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 4:59 AM To: CF-Talk Subject: Re: How do you setup an empty structure >By putting type="struct" you force the variable to be a struct, else an >error would be thrown. >By setting de default value to an empty string, you invoke that error. > >This should work: >default="#StructNew()#"> > > > > >> Could someone please explain why I get 'Invalid parameter type' error >> for the cfparam below in Mozilla (used by some of my users), but not in Firefox? >> >> >> >> What is the alternative that will work in both browsers? Thanks >> >> Thanks Wim, but this doesn't work either. However the following declaration did fix the problem (although a cfparam is more appropriate in my situation): ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDocument PDF output request producing errors
Okay, I tried it without the extension at home and it worked on the localhost, but it's not working on the server. I am using this on GoDaddy and I can't solve it. Any sort of idea as to why? On Wed, Jun 25, 2008 at 8:55 AM, Kevin K. <[EMAIL PROTECTED]> wrote: > Okay, I tried it without the extension at home and it worked on the > localhost, but it's not working on the server. > > > On Thu, Jun 19, 2008 at 12:52 PM, Kevin K. <[EMAIL PROTECTED]> wrote: > >> Explain yourself. >> >> >> On Wed, Jun 18, 2008 at 3:51 PM, Chris Norloff <[EMAIL PROTECTED]> >> wrote: >> >>> There's a cumulative hot fix for cfdocument, at least if you're using >>> CFMX >>> 7. We found it fixed some problems with writing pdf's. >>> >>> Chris >>> >>> >>> ColdFusion MX 7.02 - CFDocument Cumulative Hot Fix >>> >>> http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402093&sliceId=1 >>> http://www.adobe.com/go/kb402093 >>> >>> >>> -Original Message- >>> From: Kevin K. [mailto:[EMAIL PROTECTED] >>> Sent: Tuesday, June 17, 2008 4:17 PM >>> To: CF-Talk >>> Subject: Re: CFDocument PDF output request producing errors >>> >>> Okey, it's producing but I don't know where they are. I even looked in >>> the >>> folder and I cannot locate them. Are they hidden because of a parameter? >>> >>> On Fri, Jun 13, 2008 at 5:30 PM, Wil Genovese <[EMAIL PROTECTED]> wrote: >>> >>> > I have not tried writing a PDF to disk with cfdocument, but my guess >>> > is that like every other file operation in CF you need to specify the >>> > exact and full file path. >>> > >>> > ie - filename='d:\wwwroot\mywebsite\documents\stg.pdf' >>> > >>> > >>> > Wil Genovese >>> > Sr. Web Application Developer >>> > WolfNet Technologies, LLC >>> > >>> > >>> > On Fri, Jun 13, 2008 at 8:55 AM, Kevin Kelly <[EMAIL PROTECTED]> >>> wrote: >>> > >>> > > I am not sure what I am doing wrong here, but I have tried this >>> > > about a bunch of times so far. I believe that this is correct for the >>> top. >>> > > >>> > > >>> > > >> > > filename='stg.pdf' >>> > > orientation="#URL.frmt#" >>> > > pagetype="custom" >>> > > pageheight="#VARIABLES.numH#" >>> > > pagewidth="#VARIABLES.numW#" >>> > > scale='100' >>> > > overwrite = "no" >>> > >> >>> > > >>> > > >>> > > My issue is that the document is not outputting to a separate file. >>> > > However, without the filename, I get the desired effect for browser >>> > output. >>> > > Suggestions, please. >>> > > >>> > > >>> > >>> > >>> >>> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
Hi, Dave... Yes, Mike's doing that. He's explaining the concept in "non-jargon" terms, then identifying the concept by its proper term. He did that with "encapsulation", for example. Instantiation, also. I think what he intends, by his approach to teaching, is to teach the concepts first without relying on the unfamiliar terms, thereby avoiding unnecessary initial confusion. Once the reader understands the concept, the label is applied. It's the way I like to teach music... teach the student how to make music first, then tell them what they're doing in standard musical terms. Rick > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2008 6:53 AM > To: CF-Talk > Subject: RE: Waaa! Why won't my CFC work! > > > For those following this thread ... I've put the step-by-step > > tutorial I mentioned earlier on my company's web site. > > That's very nice of you! > > > And it's been written to specifically AVOID the use of all that OO > > jargon like 'encapsulation' and 'model-view-controller'.It's > > written in terms that people experienced with the more > > traditional procedural code mehods in ColdFusion will understand. > > I haven't looked it over yet, but from reading your description I can only > make one recommendation. > > You don't want to avoid those terms. If you want to understand OO, you need > to understand what those terms mean, so you can carry on conversations with > people who do know those terms and understand what they're talking about. I > agree that you shouldn't explain things only with those terms, but once > you've explained the fundamentals of encapsulation (which you'll do whether > you use the word "encapsulation" or not), you should wrap that part up by > explaining that this is what people mean by "encapsulation". > > For all I know, you are doing that, and I don't want to come off as overly > critical. After all, it's better than any OO tutorial I've posted anywhere. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on persistent variable on 3 cfm templates
You will need to add the url info, that you want to pass with the cflocation cflocation is like clicking a link on the page itself, so if you need to pass a url var then you would need to do this. But I will ask you this though, do you need to place an extra overhead to the web server in this case? Would a cfinclude not surfice? The reason I ask is that cflocation hits the web server again, and adds a little extra to the processing of the request. On Wed, Jun 25, 2008 at 10:13 PM, alex poyaoan <[EMAIL PROTECTED]> wrote: > >Are you using Firefox? > > > >I suggest you do go and d'load that and install it. Then grab yourself a > >copy of fireBug and install that into firefox. > > > >The best thing about this plugin, that information can be seen or not > going > >through the URL and can be debugged if your code is wrong or not. Because > >you will see what is being passed in the URL? > > > >Also you do not say which version of Coldfusion you are using, but if you > >are using Coldfusion 8 then I suggest reading a bit more on line > debugging, > >and you can debug your code that way. > > > >Not using Coldfusion 8, then I suggest looking at fusionDebug as a good > >addition to your Eclipse (oh did Iask that) anyway there are some great > >tools for this at your disposal. I suggest maybe looking into one or more > of > >these. > > > >Now for your problem, you could do a cfdump var="#URL#" and then abort the > >page to see if the values are going across, and that you are indeed > passing > >them via the url. > > > >However, if it was me. And you don't indicate any more than the vars not > >being there in the URL. But I would be maybe looking at what framework > your > >using, none then double check your links. but I would be looking at what > >information these other pages need to share? Could it be stored in the > >application scope (available to all the application) or could it be held > in > >the session. > > > >Eitherway, it could be a case that you could repull this info at anytime > >without passing it back and forth. But this is something you will need to > >look at when it comes to sharing the data from one page to the next. > > > >I hope I haven't confused you too much, but the tools I mentioned with > >firefox are invaluable to you and debugging passing of URL / Rest and > other > >information from client to server. Plus you get all the added benefits of > >modifying your css and html and JS, huge benefit to use. > > > >But as I said, if you look at what you are passing around. Then you could > >decide what scope to hold that info in, or not. And decide whether or not > >you need to rehit the database or not. Plenty of options open to you, if > you > >dig deeper into your requirement. > > > > > > > >>Hi Andrew > Thanks for your advise will be trying what you said.. And to clarify things > more.. yes i'm using firefox so will try firebug... also am using coldfusion > mx7... Well the url variable coming from the index.cfm template is going > thru magazine.cfm page. my problem is when i add a magazine article on > magazinearticle.cfm on the action page I HAVE THE url="magazine.cfm"> so it gets me back to that page and naturally the url > which was passed earlier is gone already so it gives an error url undefined > I tried a session variable with it but couldn't go thru.. > thanks > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on persistent variable on 3 cfm templates
thanks got it thru but i created a session variable this time from the url and struct clear it everytime the same user edits or adds new magazine articles I don't know it it is a good idea using session variable for these three pages... >Why can't you just add the URL variable to the ? >ie. or whatever > >Thanks for your advise will be trying what you said.. And to clarify >things more.. yes i'm using firefox so will try firebug... also am using >coldfusion mx7... Well the url variable coming from the index.cfm >template is going thru magazine.cfm page. my problem is when i add a >magazine article on magazinearticle.cfm on the action page I HAVE THE > so it gets me back to that page and >naturally the url which was passed earlier is gone already so it gives >an error url undefined I tried a session variable with it but couldn't >go thru.. >thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: help on persistent variable on 3 cfm templates
Why can't you just add the URL variable to the ? ie. or whatever -Original Message- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 8:14 AM To: CF-Talk Subject: Re: help on persistent variable on 3 cfm templates >>Hi Andrew Thanks for your advise will be trying what you said.. And to clarify things more.. yes i'm using firefox so will try firebug... also am using coldfusion mx7... Well the url variable coming from the index.cfm template is going thru magazine.cfm page. my problem is when i add a magazine article on magazinearticle.cfm on the action page I HAVE THE so it gets me back to that page and naturally the url which was passed earlier is gone already so it gives an error url undefined I tried a session variable with it but couldn't go thru.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on persistent variable on 3 cfm templates
>Are you using Firefox? > >I suggest you do go and d'load that and install it. Then grab yourself a >copy of fireBug and install that into firefox. > >The best thing about this plugin, that information can be seen or not going >through the URL and can be debugged if your code is wrong or not. Because >you will see what is being passed in the URL? > >Also you do not say which version of Coldfusion you are using, but if you >are using Coldfusion 8 then I suggest reading a bit more on line debugging, >and you can debug your code that way. > >Not using Coldfusion 8, then I suggest looking at fusionDebug as a good >addition to your Eclipse (oh did Iask that) anyway there are some great >tools for this at your disposal. I suggest maybe looking into one or more of >these. > >Now for your problem, you could do a cfdump var="#URL#" and then abort the >page to see if the values are going across, and that you are indeed passing >them via the url. > >However, if it was me. And you don't indicate any more than the vars not >being there in the URL. But I would be maybe looking at what framework your >using, none then double check your links. but I would be looking at what >information these other pages need to share? Could it be stored in the >application scope (available to all the application) or could it be held in >the session. > >Eitherway, it could be a case that you could repull this info at anytime >without passing it back and forth. But this is something you will need to >look at when it comes to sharing the data from one page to the next. > >I hope I haven't confused you too much, but the tools I mentioned with >firefox are invaluable to you and debugging passing of URL / Rest and other >information from client to server. Plus you get all the added benefits of >modifying your css and html and JS, huge benefit to use. > >But as I said, if you look at what you are passing around. Then you could >decide what scope to hold that info in, or not. And decide whether or not >you need to rehit the database or not. Plenty of options open to you, if you >dig deeper into your requirement. > > > >>Hi Andrew Thanks for your advise will be trying what you said.. And to clarify things more.. yes i'm using firefox so will try firebug... also am using coldfusion mx7... Well the url variable coming from the index.cfm template is going thru magazine.cfm page. my problem is when i add a magazine article on magazinearticle.cfm on the action page I HAVE THE so it gets me back to that page and naturally the url which was passed earlier is gone already so it gives an error url undefined I tried a session variable with it but couldn't go thru.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
fusebox plugin for Dreamweaver
Does anyone know if there's a Fusebox extension for Dreamweaver CS? Thanks -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
G'day Dave, Thanks for your thoughts. Once you read it, i think you'll see the tutorial does actually explain the terms. At the end of the tutorial, readers will have seen examples of encapsulation, used the variables scope and var scope, and hopefully seen the difference between them, cfqueryparam, init() methods, seen the benefits of isolating all queries to a single file, designing forms for multple uses, and getting used to the notion of reusing code. Also passing arguments into a method using objects rather than just simple strings or numbers. I have tried to make the terms sneak up on them rather than be up there and obvious. My main point was that when i was getting started in understanding OO, i felt so frustrated because for several weeks, every time i thought i had a glimmer or understanding, someone would explain something to me and use yet another term i didnt understand. I felt (rightly or wrongly) that some people were delibierately answering that way so they could show off, rather than enlighten me. It took me quite some weeks to get over that feeling. It was probably my own shortcoming rather than anyone else's, but i very nearly gave it all away and went back to procedural code. Looking back now from a distance of about 2.5 years, I'm SOO glad i didnt go back! Thanks for your input Dave. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Jun 25, 2008 at 8:53 PM, Dave Watts <[EMAIL PROTECTED]> wrote: >> For those following this thread ... I've put the step-by-step >> tutorial I mentioned earlier on my company's web site. > > That's very nice of you! > >> And it's been written to specifically AVOID the use of all that OO >> jargon like 'encapsulation' and 'model-view-controller'.It's >> written in terms that people experienced with the more >> traditional procedural code mehods in ColdFusion will understand. > > I haven't looked it over yet, but from reading your description I can only > make one recommendation. > > You don't want to avoid those terms. If you want to understand OO, you need > to understand what those terms mean, so you can carry on conversations with > people who do know those terms and understand what they're talking about. I > agree that you shouldn't explain things only with those terms, but once > you've explained the fundamentals of encapsulation (which you'll do whether > you use the word "encapsulation" or not), you should wrap that part up by > explaining that this is what people mean by "encapsulation". > > For all I know, you are doing that, and I don't want to come off as overly > critical. After all, it's better than any OO tutorial I've posted anywhere. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Negatives
Never mind .. I sorted it out .. -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 June 2008 12:25 To: CF-Talk Subject: Negatives I have a cfif condition for a positive/negative value of 1 or -1, but when I run the query to get the value it is always returning a positive, regardless of the value in the MSSQL table. I have set the field type to hold the value as numeric. The idea is that the levels of navigation can be opened and closed and when open show the next level below of nav links. Any ideas of where I am going wrong, please? Jenny Page header: select * from cms_nav where navID = #url.navID# update cms_nav set navOpen = #navState# where navID = #url.navID# Page body: #navtop.NavTitle# select * from cms_nav where navLinkID = #session.mNavID# #nextNav.NavTitle# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Installing ColdFusion on IIS
Also you don't state what version of the OS you are using, if you are using Vista and Coldfusion 8. Make sure you install the IIS6 meta compatable option. Otherwise this option will not appear when you try to use the Web Server Configuration tool. Also make sure you run, the Web Server Connector as an administrator as well. Some seem to not care about this, but I have had serious issues at times if I haven't. Google the options, there are plenty of blogs about the Vista install problems and pitfalls. So if you aren't using Vista then ignore this;-) On Wed, Jun 25, 2008 at 9:59 AM, sam menon <[EMAIL PROTECTED]> wrote: > Hi, > I have coldfusion installed on my local system, than selecting IIS as the > server , i installed it as default, now it has installed in c:/CF/wwwroot > folder, how can I change it to IIS? > > Will selecting the IIS as server change the rest of the sites on it?? > > please help me > > Thanks > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on persistent variable on 3 cfm templates
Are you using Firefox? I suggest you do go and d'load that and install it. Then grab yourself a copy of fireBug and install that into firefox. The best thing about this plugin, that information can be seen or not going through the URL and can be debugged if your code is wrong or not. Because you will see what is being passed in the URL? Also you do not say which version of Coldfusion you are using, but if you are using Coldfusion 8 then I suggest reading a bit more on line debugging, and you can debug your code that way. Not using Coldfusion 8, then I suggest looking at fusionDebug as a good addition to your Eclipse (oh did Iask that) anyway there are some great tools for this at your disposal. I suggest maybe looking into one or more of these. Now for your problem, you could do a cfdump var="#URL#" and then abort the page to see if the values are going across, and that you are indeed passing them via the url. However, if it was me. And you don't indicate any more than the vars not being there in the URL. But I would be maybe looking at what framework your using, none then double check your links. but I would be looking at what information these other pages need to share? Could it be stored in the application scope (available to all the application) or could it be held in the session. Eitherway, it could be a case that you could repull this info at anytime without passing it back and forth. But this is something you will need to look at when it comes to sharing the data from one page to the next. I hope I haven't confused you too much, but the tools I mentioned with firefox are invaluable to you and debugging passing of URL / Rest and other information from client to server. Plus you get all the added benefits of modifying your css and html and JS, huge benefit to use. But as I said, if you look at what you are passing around. Then you could decide what scope to hold that info in, or not. And decide whether or not you need to rehit the database or not. Plenty of options open to you, if you dig deeper into your requirement. On Wed, Jun 25, 2008 at 9:04 PM, alex poyaoan <[EMAIL PROTECTED]> wrote: > HI everybody. have this problem which I couldn't seem to solve.. I have > three templates. I have to declare a variable that would persist in these > three templates. On the index page is a url variable that is passed to > magazine.cfm and from the magazine.cfm to magarticles.cfm.. this after the > action page it comes back to magazine.cfm.. but it gives me an error which > is that url.magazineid is undefined... > > index.cfm magazine.cfm?magazineid=#UrlEncodedFormat(getall.magazineid)# > magazine.cfm > magarticles.cfm > > thanks for any help > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Negatives
I have a cfif condition for a positive/negative value of 1 or -1, but when I run the query to get the value it is always returning a positive, regardless of the value in the MSSQL table. I have set the field type to hold the value as numeric. The idea is that the levels of navigation can be opened and closed and when open show the next level below of nav links. Any ideas of where I am going wrong, please? Jenny Page header: select * from cms_nav where navID = #url.navID# update cms_nav set navOpen = #navState# where navID = #url.navID# Page body: #navtop.NavTitle# select * from cms_nav where navLinkID = #session.mNavID# #nextNav.NavTitle# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anybody using POIUtility.cfc to import from Excel?
On Tuesday 24 Jun 2008, Les Mizzell wrote: > If I can figure out how to upgrade/install/whatever files on the server > (CF7 running on IIS), maybe I'm in business. You can use the JavaLoader CFC to load newer versions of a JAR into CF, without mucking about with replacing CF's files. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
help on persistent variable on 3 cfm templates
HI everybody. have this problem which I couldn't seem to solve.. I have three templates. I have to declare a variable that would persist in these three templates. On the index page is a url variable that is passed to magazine.cfm and from the magazine.cfm to magarticles.cfm.. this after the action page it comes back to magazine.cfm.. but it gives me an error which is that url.magazineid is undefined... index.cfm magazine.cfm?magazineid=#UrlEncodedFormat(getall.magazineid)# magazine.cfm magarticles.cfm thanks for any help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Installing ColdFusion on IIS
> I have coldfusion installed on my local system, than > selecting IIS as the server , i installed it as default, now > it has installed in c:/CF/wwwroot folder, how can I change > it to IIS? Use the Web Server Configuration Tool, which should be available from the appropriate group in your Start menu. Whatever folder you're using for your IIS web root will be where you want to place your CF code. If you want to run the CF Administrator through IIS, you'll need to create a virtual mapping pointing to c:\coldfusion8\wwwroot\CFIDE. > Will selecting the IIS as server change the rest of the > sites on it?? It depends. When you use the Web Server Configuration Tool, you can choose whether to configure all IIS sites or just one IIS site. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
> For those following this thread ... I've put the step-by-step > tutorial I mentioned earlier on my company's web site. That's very nice of you! > And it's been written to specifically AVOID the use of all that OO > jargon like 'encapsulation' and 'model-view-controller'.It's > written in terms that people experienced with the more > traditional procedural code mehods in ColdFusion will understand. I haven't looked it over yet, but from reading your description I can only make one recommendation. You don't want to avoid those terms. If you want to understand OO, you need to understand what those terms mean, so you can carry on conversations with people who do know those terms and understand what they're talking about. I agree that you shouldn't explain things only with those terms, but once you've explained the fundamentals of encapsulation (which you'll do whether you use the word "encapsulation" or not), you should wrap that part up by explaining that this is what people mean by "encapsulation". For all I know, you are doing that, and I don't want to come off as overly critical. After all, it's better than any OO tutorial I've posted anywhere. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do you setup an empty structure
> Thanks Wim, but this doesn't work either. However the > following declaration did fix the problem (although a cfparam > is more appropriate in my situation): > Occasionally, I've had problems creating an empty structure in a CFPARAM. You can just wrap it in a CFIF: 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do you setup an empty structure
I think that the reason my code doesn't work for you is because you already have a session.chgProject in your own session (which has a value of ""). Try putting back my code, and right above it, put this: Run the page once and then remove the above line. On Wed, Jun 25, 2008 at 11:58 AM, Kamru Miah <[EMAIL PROTECTED]> wrote: > >By putting type="struct" you force the variable to be a struct, else an > >error would be thrown. > >By setting de default value to an empty string, you invoke that error. > > > >This should work: > > > > > > > > > > > >> Could someone please explain why I get 'Invalid parameter type' error > for > >> the cfparam below in Mozilla (used by some of my users), but not in > Firefox? > >> > >> > >> > >> What is the alternative that will work in both browsers? Thanks > >> > >> > Thanks Wim, but this doesn't work either. However the following declaration > did fix the problem (although a cfparam is more appropriate in my > situation): > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do you setup an empty structure
>By putting type="struct" you force the variable to be a struct, else an >error would be thrown. >By setting de default value to an empty string, you invoke that error. > >This should work: > > > > > >> Could someone please explain why I get 'Invalid parameter type' error for >> the cfparam below in Mozilla (used by some of my users), but not in Firefox? >> >> >> >> What is the alternative that will work in both browsers? Thanks >> >> Thanks Wim, but this doesn't work either. However the following declaration did fix the problem (although a cfparam is more appropriate in my situation): ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do you setup an empty structure
By putting type="struct" you force the variable to be a struct, else an error would be thrown. By setting de default value to an empty string, you invoke that error. This should work: On Wed, Jun 25, 2008 at 10:53 AM, Kamru Miah <[EMAIL PROTECTED]> wrote: > Could someone please explain why I get 'Invalid parameter type' error for > the cfparam below in Mozilla (used by some of my users), but not in Firefox? > > > > What is the alternative that will work in both browsers? Thanks > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How do you setup an empty structure
Could someone please explain why I get 'Invalid parameter type' error for the cfparam below in Mozilla (used by some of my users), but not in Firefox? What is the alternative that will work in both browsers? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC Tutorial now on line
Hi Mike, Great stuff! Thanks for sharing this! Can't wait to read part 2: using a bean instead of a struct. Wim. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mailer Output
that works thankyou!! > On Tuesday 24 Jun 2008, Jason Congerton wrote: > > sorry I wasn't really clear with what I actually need help with, I > > basically need to know how to output the page html to a text file, I > have > > been looking at cfcontent. > > > #whateverMakesYourPage()# > > > > > -- > Tom Chiverton > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in > England and Wales under registered number OC307980 whose registered > office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, > Manchester, M3 3EB. A list of members is available for inspection at > the registered office. Any reference to a partner in relation to > Halliwells LLP means a member of Halliwells LLP. Regulated by The > Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above > and may be confidential or legally privileged. If you are not the > addressee you must not read it and must not use any information > contained in nor copy it nor inform any person other than Halliwells > LLP or the addressee of its existence or contents. If you have > received this email in error please delete it and notify Halliwells > LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Column type to CF_SQL_TYPE map
I hate when I miss things like this in the docs :O. Still wondering why there's no mapping of bigint to CF_SQL_BIGINT and why smallmoney maps to CF_SQL_DECIMAL and not CF_SQL_MONEY. Anyway, thanks for the link. Very useful. Adrian -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 23 June 2008 16:42 To: CF-Talk Subject: Re: Column type to CF_SQL_TYPE map http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_18.html about 1/2 down the page. smalldatetime is cf_sql_timestamp (i only knew that one 'cuz it bit me in the ass a couple of weeks ago) :) On Mon, Jun 23, 2008 at 8:33 AM, Adrian Lynch <[EMAIL PROTECTED]> wrote: > Is there a definitive list of what CF SQL type goes with what column data > type? > > I have a few I'm not sure of (CF_SQL_ below). Can anyone fill some of > these in? These are all SQL 2005 data types. > > int CF_SQL_INTEGER > nchar(10) CF_SQL_CHAR > ntext CF_SQL_LONGVARCHAR > numeric(18, 0) CF_SQL_NUMERIC > nvarchar(50)CF_SQL_VARCHAR > nvarchar(MAX) CF_SQL_ > realCF_SQL_REAL > smalldatetime CF_SQL_ > smallintCF_SQL_SMALLINT > smallmoney CF_SQL_ > sql_variant CF_SQL_ > textCF_SQL_LONGVARCHAR > timestamp CF_SQL_TIMESTAMP > tinyint CF_SQL_TINYINT > uniqueidentifierCF_SQL_ > varbinary(50) CF_SQL_ > varbinary(MAX) CF_SQL_ > varchar(50) CF_SQL_VARCHAR > varchar(MAX)CF_SQL_ > xml CF_SQL_ > bigint CF_SQL_BIGINT > binary(50) CF_SQL_ > bit CF_SQL_BIT > char(10)CF_SQL_CHAR > datetimeCF_SQL_DATE > decimal(18, 0) CF_SQL_DECIMAL > float CF_SQL_FLOAT > image CF_SQL_ > money CF_SQL_MONEY > > I hope the formatting holds. > > I'd hazard a guess that for smallmoney you'd use CF_SQL_MONEY and the same > for smalldatetime, CF_SQL_DATE. > > I've always used CF_SQL_LONGVARCHAR for text and ntext. Is this right? > > Thanks for any more insight. > > Adrian Lynch > http://www.adrianlynch.co.uk/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) mod_rewrite with VirtualHost and .htaccess
Thanks Barney. You were right in that I needed to allow the rules in ..htaccess to override those in httpd.conf. So in my VirtualHost I have: ... RewriteEngine On RewriteOptions Inherit In httpd.conf: ... AllowOverride All ... And then the rules are in .htaccess. Does this sound about right? The reason for wanting the rules in the .htaccess file is that the sites' final resting place will be on IIS and I'd like to have the rules pertaining to each site included in with all the other files. Thanks for pointing me in the right direction. Adrian -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 24 June 2008 22:32 To: CF-Talk Subject: Re: (ot) mod_rewrite with VirtualHost and .htaccess Check the .htaccess documentation from Apache. Basically you need to ensure you have rights to use .htaccess configured in the main apache file. Then you just stick your rules in there. Be aware of path issues, however, since you're not in a global context, you're in the context of the directory .htaccess lives in. If you own the main config file(s), a better option would be to use the Include directive to include an apache config file from each virtual host, instead of using .htaccess. The former approach will be more performant and less complicated, though it doesn't allow live editing (i.e. changes require an Apache restart). cheers, barneyb On Tue, Jun 24, 2008 at 2:14 PM, Adrian Lynch <[EMAIL PROTECTED]> wrote: > I'd like to have my rewrite rules in a .htaccess per site. I'm using virtual > hosts and everything I have read has said that I need to place the rules in > with the VirtualHost directive block or in httpd.config and then add the > following lines to my v-hosts: > > RewriteEngine On > RewriteOptions Inherit > > What I can't find reference to, and I can't get to work, is how to use > ..htaccess with v-hosts where the .htaccess file is in the webroot for a > given site. > > Any pointers would be greatly appreciated. > > Adrian Lynch ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
