Decrypting a string which was encrypted by C# doesn't handle extended ascii
Hi I need to decrypt a string which was originally encrypted in C#. It works fine for normal ascii strings, but not with extended ascii characters, e.g. the ö in Citroën. It returns the unrepresentable character 65533 This is the code that was used for the encryption: http://pastebin.com/gxv6cuYJ And this is what I'm using to decrypt http://pastebin.com/vFqGXr0j Any help would be greatly appreciated. Cheers Bert ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Decrypting a string which was encrypted by C# doesn't handle extended ascii
Thanks Mark and Leigh. Leigh, that did the trick. Cheers Bert On 27 February 2013 14:48, Leigh cfsearch...@yahoo.com wrote: a string which was originally encrypted in C#. It works Oh wait...it looks like an encoding difference. CF's encrypt/decrypt functions always use UTF-8. Based on the results, those custom c# methods are using Encoding.Unicode, which is different. You need to use the same encoding ie UTF-16LE in CF. http://pastebin.com/fZtdeQ2e -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Porting password hash mechanism from C#
Hi I need to write a hash mechanism in CF that replaces on in C#: it accepts a salt, and the password the user enters, and returns a string. #Something(rOE3gOJuY/8iZCa0iFmjAQ==, Sup3rP4sSwORD)# -- YRsleC9Zqpb8/pk3KEtOcuA2jho= I've tried a few things, but haven't got it yet, then I thought I'd post it here, in case there was someone who could just bash it out. Thanks in advance Bert p.s. by way of introduction, its been a few years since I posted here, but I'm still working on a fusebox app I started in early 2000. p.p.s. here's the (psuedo) C# code that i need to replicate that I've been given, along with the comment pay specific attention on how the base 64 string are directly converted to byte arrays. class Program{static void Main(string[] args){ // These values are retrieved from the database.string userSpecificSaltB64String = rOE3gOJuY/8iZCa0iFmjAQ==;string realPasswordSHA1HashB64String = YRsleC9Zqpb8/pk3KEtOcuA2jho=; // This value is the string entered by the user in the login form. string passwordToValidate = Sup3rP4sSwORD; // We write the result of the IsPasswordValid call.Console.WriteLine( string.Format(Is Password Valid: {0}, IsPasswordValid(passwordToValidate, userSpecificSaltB64String, realPasswordSHA1HashB64String) ? YES : NO)); // This will display:// Is Password Valid: YES} /// summary /// Validates if the provided password has the same hash as the one stored in the database./// The high level algorithm is to compare the hash provided in argument (DBPwdHash), retrieved from the DB, /// with the one we generate thanks to the user specific salt (DBSalt), also retrieved from the DB, and the provided password (ProvidedPwd) by following this comparaison pattern:/// DBPwdHash == SHA1(DBSalt + ProvidedPwd)/// /summary/// param name=passwordToValidateThe password in clear/plain text we want to validate. This value is provided by the user via the login form./param /// param name=userSpecificSaltB64StringThe base 64 encoded string of the user specific salt. This value is retrieved from the database./param/// param name=realPasswordSHA1HashB64StringThe base 64 encoded string of the real password hash. This value is retrieved from the database./param /// returnsTrue is the password is valid (that is, produces the same hash). False otherwise./returnsprivate static bool IsPasswordValid(string passwordToValidate, string userSpecificSaltB64String, string realPasswordSHA1HashB64String){ // We convert the user specific salt from the B64 string (as stored in the DB) to a byte array.byte[] userSpecificSaltByteArray = Convert.FromBase64String(userSpecificSaltB64String); // We convert the provided password from a clear/plain text string to a byte array.byte[] passwordToValidateByteArray = Encoding.Unicode.GetBytes(passwordToValidate); // We contenate the salt and provided password byte arrays into one saltAndProvidedPasswordByteArray byte array, in the order salt then provided password.byte[] saltAndPasswordToValidateByteArray = new byte[userSpecificSaltByteArray.Length + passwordToValidateByteArray.Length]; Buffer.BlockCopy(userSpecificSaltByteArray, 0, saltAndPasswordToValidateByteArray, 0, userSpecificSaltByteArray.Length); Buffer.BlockCopy(passwordToValidateByteArray, 0, saltAndPasswordToValidateByteArray, userSpecificSaltByteArray.Length, passwordToValidateByteArray.Length); // We generate the SHA1 hash of the saltAndProvidedPasswordByteArray byte array.SHA1 sha = new SHA1CryptoServiceProvider();byte[] saltAndPasswordToValidateSHA1HashByteArray = sha.ComputeHash(saltAndPasswordToValidateByteArray); // We convert the saltAndProvidedPasswordSHA1HashByteArray into a B64 string. string saltAndPasswordToValidateSHA1HashB64String = Convert.ToBase64String(saltAndPasswordToValidateSHA1HashByteArray); // We compare the SHA1 hash generated thanks to the provided password with the one stored in the database.return saltAndPasswordToValidateSHA1HashB64String == realPasswordSHA1HashB64String; }} ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Porting password hash mechanism from C#
http://pastebin.com/htcPsqpG Cheers Bert On 4 February 2013 14:52, Justin Scott leviat...@darktech.org wrote: p.p.s. here's the (psuedo) C# code that i need to replicate that I've been given, along with the comment pay specific attention on how the base 64 string are directly converted to byte arrays. I'd recommend pasting that code into pastebin or other code-sharing site which can retain formatting and provide for color coding and such and share the link back here. Unfortunately the sample would require a lot of reformatting to be useful as-is. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Porting password hash mechanism from C#
Many thanks Leigh: that does indeed seem to do the trick. Cheers Bert On 4 February 2013 15:03, Leigh cfsearch...@yahoo.com wrote: http://stackoverflow.com/a/12539088/104223 Okay, I just tested your values and it is the same algorithm. So that link should do the trick. -Leigh Subject: Re: Porting password hash mechanism from C# To: cf-talk cf-talk@houseoffusion.com Date: Monday, February 4, 2013, 8:59 PM Without testing anything, that sounds like DNN hashing. See if this helps: http://stackoverflow.com/a/12539088/104223 -Leigh Subject: Re: Porting password hash mechanism from C# To: cf-talk cf-talk@houseoffusion.com Date: Monday, February 4, 2013, 8:55 PM http://pastebin.com/htcPsqpG Cheers Bert On 4 February 2013 14:52, Justin Scott leviat...@darktech.org wrote: p.p.s. here's the (psuedo) C# code that i need to replicate that I've been given, along with the comment pay specific attention on how the base 64 string are directly converted to byte arrays. I'd recommend pasting that code into pastebin or other code-sharing site which can retain formatting and provide for color coding and such and share the link back here. Unfortunately the sample would require a lot of reformatting to be useful as-is. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
gamma correction in CF9 images
Does anyone know if its possible to do gamma correction using the built in image processing in CF9? Cheers Bert ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: inserting datetime
When you use CreateODBCDate and pass in a string it will first try to convert it to a date using the US format of mm/dd/, and only if that fails will it try the rest-of-the-world format of dd/mm/. The same goes for some of the other CF date functions. So 12/13/2009 and 13/12/2009 will both get converted to 13th Dec 2009. :| IMO, the safest way to deal with dates coming in as strings (e.g. from forms etc) is to convert them to CF dateobjects using CreateDate as soon as you can using something like the following, though the error handling would obviously do something more friendly than just abort. cftry cfset myDateObject = CreateDate(ListGetAt(form.dateString, 3, '/'), ListGetAt(form.date, 2, '/'), ListGetAt(form.date, 1, '/')) cfoutput#myDateObject#/cfoutput cfcatch cfabort showerror=i couldn't make a date out of form.date... /cfcatch /cftry Assuming that the datatype of your dB column is DATETIME, you'll want to do something similar when displaying the date you pull out of the database, this time using DateFormat(yourDate, 'dd/mm/'). (N.B. DateFormat should be used to display a date object in a particular format, and not to try to create a date object from a string in a particular format...) As Peter mentioned, where possible it is preferable to use mmm is any dates you display to the end user as this removes any ambiguity between dd/mm vs. mm/dd: everyone understands Jan 2 2009 and 2 Jan 2009. Cheers Bert On Tue, Apr 7, 2009 at 8:08 AM, alex poyaoan ap.cli...@tiscali.it wrote: HI everybody have this problem and could't get over it.. I have a flash form that insert date on an mssql 2000 db the format that is on the db field is dd/mm/... I display the date on a form and it displays right without doing anything and press ok on the form it flips the day and month ex 01/02/2009 (feb 1 2009) now is 02/01/2009 the insert statementi is CREATEODBCDATE(FIELDNAME) AND THE UPDATE IS THE SAME.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: would you consider this a bug, CF8
Or you could start with the first, add a month, then take away a day: cfset date1 = CreateDate(2008, 12, 1)!--- best to create a date object than using a string... --- cfoutput cfloop from=1 to=6 index=i cfset date2 = dateAdd('d', -1, dateAdd('m', i, date1)) #dateFormat(date2, 'mm/dd/')#br / /cfloop /cfoutput Bert On Thu, Apr 2, 2009 at 10:15 AM, Francois Levesque cfab...@gmail.comwrote: That's odd, but not unexpected. Since you're starting on the 30th, it's adding a month to that and reduces when the month doesn't have 30 days in it. It's not taking the initiative of thinking you want the last day of the month. Maybe this would work? cfset date1 = '11/01/2008' / cfoutput cfloop from=1 to=6 index = i cfset date2 = dateAdd('m', i, date1) / #dateFormat(date2,'mm')#/#daysInMonth( date2 )#/#dateFormat(date2,'')#br / /cfloop /cfoutput Francois Levesque http://blog.critical-web.com/ On Thu, Apr 2, 2009 at 11:05 AM, Tony tonyw...@gmail.com wrote: cfset date1 = '11/30/2008' / cfoutput cfloop from=1 to=6 index = i cfset date2 = dateAdd('m', i, date1) / #dateFormat(date2,'mm/dd/')# br / /cfloop /cfoutput very simple code. however, its behaving like i dont want it to. id rather see it increment by a MONTH, not same day next month. the output of that code above is: 12/30/2008 01/30/2009 02/28/2009 03/30/2009 04/30/2009 05/30/2009 and i would rather it be 12/31/2008 1/31/2009 2/28/2009 3/31/2009 4/30/2009 5/31/2009 what should i be using? this is weird... i supply m to get month increment, but no dice... thanks tw ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 linux not recognising CF mapping
I'm trying to port from CF7 on windows to CF8 on linux. Everything was going fine, and was working, and then something happened and it went wierd: things which were previously working weren't. The guys configuring the linux box can't remember what they might have done as this happened a while ago. When I try to include a file via a CF mapping, it not only fails to find the file, but it doesn't throw a file not found exception, and just includes the index.cfm again, leading to an infinite loop. Any ideas why it isn't picking up the CF mapping? (The failure to throw an error, and to re-include the index.cfm is also odd, but that appears to happen on my mac CF8 when the CF mapping doesn't exist, so i'm not so concerned about that. I just need to get it to honour the CF mapping) Cheers Bert Here's my mapping, which points to the webroot: /testmapping1 /home/bdawson/trips/trunk/trips2/www_versions/-wvr-en-something-/ The contents of the webroot: [bdaw...@cfusion-tng -wvr-en-something-]$ pwd /home/bdawson/trips/trunk/trips2/www_versions/-wvr-en-something- [bdaw...@cfusion-tng -wvr-en-something-]$ ls -l -rwxrwxrwx 1 bdawson likewise 59 Apr 2 09:53 Application.cfc -rwxrwxrwx 1 bdawson likewise 59 Apr 2 09:53 include.cfm -rwxrwxrwx 1 bdawson likewise 301 Apr 2 10:26 index.cfm Application.cfc and include.cfm both contain the following: brbr cfoutput#getcurrenttemplatepath()#/cfoutput brbr index.cfm has: cfoutput cfparam name=request.counter default=0 cfset request.counter = request.counter + 1 cfif request.counter GT 3 brAborted in #getcurrenttemplatepath()# to prevent infinite loop cfabort /cfif brbr #getcurrenttemplatepath()# br cftry include #request.counter#: cfinclude template=/testmapping1/include.cfm cfcatchcfdump var=#cfcatch.message#/cfcatch /cftry brbr /cfoutput And here's the output i get: /home/bdawson/trips/trunk/trips2/www_versions/-wvr-en-homeaway-/Application.cfc /home/bdawson/trips/trunk/trips2/www_versions/-wvr-en-homeaway-/index.cfm include 1: /home/bdawson/trips/trunk/trips2/www_versions/-wvr-en-homeaway-/index.cfm include 2: /home/bdawson/trips/trunk/trips2/www_versions/-wvr-en-homeaway-/index.cfm include 3: Aborted in /home/bdawson/trips/trunk/trips2/www_versions/-wvr-en-homeaway-/index.cfm to prevent infinite loop It looks like the file is being not found, but in stead of throwing an exception it is including the index.cfm If I change the cfinclude to be cfinclude template= testmapping1/include.cfm then it throws a file not found exception as expected. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
('1,1') * 1 = 39448
I tracked down a defect to a piece of code which basically did the following: total = form.quantity * form.itemamount In some cases, form.quantity is commong through as *1,1* which is presumably due to an HTML issue with duplicate form fields with the same name. But rather than getting a CF error cos 1,1 isn't a number, it evaluates to 39448! i.e. cfoutput'1,1' * 1 = #'1,1' * 1#/cfoutput produces: '1,1' * 1 = 39448 I'm not worried about the original problem with the form.quantity coming though as *1,1* rather than the expected *1* since I can fix that, but i'm curious as to any reason for this odd result. It looks like (x,y) * 1 is the same as (y,x) * 1 In other words cfoutput#'5,23' * 1# = #'23,5' * 1# = 39591/cfoutput As i say, i'm not worried about fixing the defect, but i'm just curious if there is an underlying explanation for the apparently wierd behaviour. Or is it just a bug in the way CF does the conversion? Cheers Bert p.s. FWIW here's a snippet which will create a 101 square grid of all the combinations: table border=1 cfloop from=0 to=100 index=i tr cfloop from=0 to=100 index=j td nowrap=true#wtf(i,j)#/td /cfloop /tr /cfloop /table cfscript function wtf(a,b) { var x = '#a#,#b#'; try { return '#x#*1 = ' x*1; } catch(Any E) { return '#x#*1 pukes'; } } /cfscript ~| 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:309488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ('1,1') * 1 = 39448
I should have spotted that: i noticed that the difference between 0,1 and 0,2 and 0,3 were 31, 29 and 31, etc. And also that the sequences jumped when the numbers went from 12 to 13, and likewise around 30. And also leaps of 365 and 366 between 1,32 and 1,33 and 1,34 etc. So CF is saying, well, 1,1 isn't a number, but might be a date, then getting the number of days from 1 jan 1900 (or 30 dec 1988) to 1st Jan 2008 and use that in the calculation. Well, at least there is an explanation, but personally i can't see the point in a feature which interprets 1,1 and 12,13 and 13,12 and 12,53 etc as dates, and that any code which actively relied on such an abomination (as oposed to falling victim to this feature) should be taken out and shot. But looking on the bright side, we shouldn't have anymore customers getting charged $1,143,992 for something they were expecting to pay $29 for... Cheers Bert On Tue, Jul 22, 2008 at 5:43 PM, Experienced CF Developer [EMAIL PROTECTED] wrote: Looked like it could be a ColdFusion date value to me. So I did a dateFormat() on that and came up with 01/01/2008: cfset nValue = 1,1 * 1 cfoutput#dateFormat(nValue,mm/dd/)#brbr/cfoutput It's assuming 1,1 is the current month and year. I did the same for 5,23 * 1 and got 05/23/2008. What's really fun is if you do 1,1 * 2.. Go ahead... see what you get. 10/15/2116 Now go figure THAT one out! Dave Phillips -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 5:08 PM To: CF-Talk Subject: ('1,1') * 1 = 39448 I tracked down a defect to a piece of code which basically did the following: total = form.quantity * form.itemamount In some cases, form.quantity is commong through as *1,1* which is presumably due to an HTML issue with duplicate form fields with the same name. But rather than getting a CF error cos 1,1 isn't a number, it evaluates to 39448! i.e. cfoutput'1,1' * 1 = #'1,1' * 1#/cfoutput produces: '1,1' * 1 = 39448 I'm not worried about the original problem with the form.quantity coming though as *1,1* rather than the expected *1* since I can fix that, but i'm curious as to any reason for this odd result. It looks like (x,y) * 1 is the same as (y,x) * 1 In other words cfoutput#'5,23' * 1# = #'23,5' * 1# = 39591/cfoutput As i say, i'm not worried about fixing the defect, but i'm just curious if there is an underlying explanation for the apparently wierd behaviour. Or is it just a bug in the way CF does the conversion? Cheers Bert p.s. FWIW here's a snippet which will create a 101 square grid of all the combinations: table border=1 cfloop from=0 to=100 index=i tr cfloop from=0 to=100 index=j td nowrap=true#wtf(i,j)#/td /cfloop /tr /cfloop /table cfscript function wtf(a,b) { var x = '#a#,#b#'; try { return '#x#*1 = ' x*1; } catch(Any E) { return '#x#*1 pukes'; } } /cfscript ~| 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:309498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How to cancel a running query...?
Does anyone know if its possible to cancel a running query in CF? I found this article (http://www.onjava.com/lpt/a/4938) which describes how to do it in java, so i'm guessing it must be possible in CF, but has anyone done it? Cheers Bert p.s. This is similar to a thread just started about cfquery and timeout... http://www.houseoffusion.com/lists.cfm/link=i:4:219038 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219040 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is using a trigger to return the identity OK or Bad?
Mike I'm on CFMX7 with hf2, in J2EE configuration, JRun 4 updater 5, win2003, sql server 2000. I've knockup up a test, and reproduced this on 2 dev servers, test and staging, though i haven't tried it on live :) !--- /* script to create table with trigger which returns the ID column */ if exists (select * from dbo.sysobjects where id = object_id(N'[my_table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE dbo.my_table GO CREATE TABLE dbo.my_table ( my_id int NOT NULL IDENTITY (1, 1), my_text varchar(50) NULL ) ON [PRIMARY] GO CREATE TRIGGER get_my_id ON dbo.my_table FOR INSERT AS SELECT my_id AS my_new_id FROMINSERTED GO --- cfset dsn = trips2_hr cfset text = the time is #now()# cfquery name=q_test datasource=#dsn# INSERT INTO my_table (my_text) VALUES ('#text#') /cfquery cfdump var=#q_test# When using DataDirect 3.3 it works, but when i upgrade to 3.4 JRun CPU sticks at 50%, and the thread remains busy. If i delete the trigger then it works on the 3.4 drivers. I haven't had time to investigate this further than posting this mail... Cheers Bert On 7/20/05, Mike Chabot [EMAIL PROTECTED] wrote: Bert, I have been returning new identities using triggers for years without any problems. It is working for me using CFMX 6.1 and the DataDirect 3.4drivers. I do not see any JRun CPU spike on my server. Are you suggesting that everything works without any error messages being generated, but JRun seems to consume more CPU than it should? I would be interested to know if you are able to find an answer to this problem. I would make sure you have applied the latest SQL Server and CFMX service packs / hotfixes. Good luck, Mike Chabot On 7/20/05, Bert Dawson [EMAIL PROTECTED] wrote: Years ago i picked up a way of returning the value inserted into an Identity column in SQL server, by adding a trigger to that table: CREATE TRIGGER get_my_id ON dbo.my_table FOR INSERT AS SELECT my_id AS my_new_id FROM INSERTED GO Then i can run: cfquery name=q_test datasource=#dsn# INSERT INTO my_table (my_text) VALUES ('foo') /cfquery my new id = #q_test.my_new_id# I know i can use @@IDENTITY or SCOPE_IDENTITY(), but i was wondering if the trigger method is a Bad thing to do... Its worked from CF4 to CFMX7, but barfs with the DataDirect 3.4 drivers: the insert happens, but JRun sits at 50%. Does that mean there's a bug with the driver, or something wrong with my code? Cheers Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Is using a trigger to return the identity OK or Bad?
Years ago i picked up a way of returning the value inserted into an Identity column in SQL server, by adding a trigger to that table: CREATE TRIGGER get_my_id ON dbo.my_table FOR INSERT AS SELECT my_id AS my_new_id FROMINSERTED GO Then i can run: cfquery name=q_test datasource=#dsn# INSERT INTO my_table (my_text) VALUES ('foo') /cfquery my new id = #q_test.my_new_id# I know i can use @@IDENTITY or SCOPE_IDENTITY(), but i was wondering if the trigger method is a Bad thing to do... Its worked from CF4 to CFMX7, but barfs with the DataDirect 3.4 drivers: the insert happens, but JRun sits at 50%. Does that mean there's a bug with the driver, or something wrong with my code? Cheers Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf7 debugging - solved - maybe
I think there's a bug in CFMX 7: when you delete a log file through CFadmin it locks the file in someway so the CF won't write anything to it. I think you'll need to stop CF and delete the files manually. The workaround is not to delete but use archive. Cheers Bert On 6/5/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: That's interesting... I supose the debug setting in the jrun.xml file has to be true and the setting in neo-admin.xml (or whatever) has to be true as well for it to work. I'd bet the admin script reads from only one but updates them both g. Yeah, likely... Oddly, now that I've resolved the debugging info, cflog seems to have stopped working... It was working (after fixing the debugging I thought) and then I purged the application.log in the CF Admin and now I can't get it to put anything into the application log at all... several cflog tags that were working before just suddenly stopped working... I can ouput text to the browser both before and after the tag, and no error is produced, but nothing is written to the log file. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DatePart problem
Use list functions and CreateDate() to convert you string into a date object, then use DatePart() or Month(): myDateObj = CreateDate(ListGetAt(str, 3, '/'), ListGetAt(str, 2, '/'), ListGetAt(str, 1, '/')); foo = DatePart(myDateObj); Lots of CF functions expect a date object, but if you pass them a string then they will helpfully try to process them with unexpected results, as you've found out with DatePart(). DateFormat() is another: this is for converting data objects into strings of the specified format, not the other way round. HTH Bert ps Also, you mention you're storing your dates in the database in format dd/m/. You'd be well advised to start storing dates in columns of datatype date, and use dateFormat() when displaying them to users. On 5/31/05, Mark Henderson [EMAIL PROTECTED] wrote: I want to extract the month from a date that is in the format dd/m/, so I've tried using DatePart (access is the database format). The problem I have is that, by default, DatePart always seems to presume the entry is in the m/dd/ format and thus, it's setting the month from the day (where possible). An example: from 12/02/2005 (12th February 2005) DatePart will select the 12 as the month. From 25/02/2005, it obviously works correctly, due to a lack of alternatives. Actually, my situation is slightly more complicated in that this is actually used to submit events to a calendar table in the database. Start_date is currently in the above mentioned dd/m/ format and that is the way I wish to keep things (to save confusion for those submitting). So my question - can this be achieved, and if so, how...any ideas? A worst case scenario means I will just have to alter the form thats entered, but this (DatePart) is something I might like to use in the future, so I figured I would ask. All help appreciated. TIA Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208030 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX 7 and JRun updater 5
Glad to establish that JRun U5 is supported with CFMX 7, but i'm afraid i have to disagree with your dates: According to MM forums Boby posted on April 26th, over a month after Brandon's Blog post on 25th March No matter. Cheers Bert from http://www.bpurcell.org/blog/index.cfm?mode=entryentry=1053 # CFMX 7 with JRun 4 U5 is tested and supported. Posted by Brandon at 3/25/05 8:23 AM # from http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=69threadid=995120 # 04/26/2005 12:39:37 PM No. Infact, updater5 of JRun 4 has not yet been certified to be used with CF7. HTH Boby Thomas # On 5/26/05, Steven Erat [EMAIL PROTECTED] wrote: Boby posted that remark on April 9th, before the announcement was made. At that time, QA hadn't finished regression tests. Updater 5 for JRun is supported with CFMX 7. Bert Dawson wrote: OK, i've just been pointed to Brandon Purcell's blog which says: CFMX 7 with JRun 4 U5 is tested and supported. (http://www.bpurcell.org/blog/index.cfm?mode=entryentry=1053) I'd still be interested to know what Boby was talking about... Cheers Bert On 5/26/05, Bert Dawson [EMAIL PROTECTED] wrote: Macromedia recommends that ALL customers apply Updaters. (http://www.macromedia.com/support/updaters/terms.html) But someone called Boby Thomas (from macromedia?) posted this on MM forums: updater5 of JRun 4 has not yet been certified to be used with CF7 (http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=69threadid=995120) Should i go ahead an install JRun Updater 5? If so, can anyone explain what Boby is talking about? Running win2k and CFMX 7 ent. Cheers Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207839 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX 7 and JRun updater 5
Macromedia recommends that ALL customers apply Updaters. (http://www.macromedia.com/support/updaters/terms.html) But someone called Boby Thomas (from macromedia?) posted this on MM forums: updater5 of JRun 4 has not yet been certified to be used with CF7 (http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=69threadid=995120) Should i go ahead an install JRun Updater 5? If so, can anyone explain what Boby is talking about? Running win2k and CFMX 7 ent. Cheers Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX 7 and JRun updater 5
OK, i've just been pointed to Brandon Purcell's blog which says: CFMX 7 with JRun 4 U5 is tested and supported. (http://www.bpurcell.org/blog/index.cfm?mode=entryentry=1053) I'd still be interested to know what Boby was talking about... Cheers Bert On 5/26/05, Bert Dawson [EMAIL PROTECTED] wrote: Macromedia recommends that ALL customers apply Updaters. (http://www.macromedia.com/support/updaters/terms.html) But someone called Boby Thomas (from macromedia?) posted this on MM forums: updater5 of JRun 4 has not yet been certified to be used with CF7 (http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=69threadid=995120) Should i go ahead an install JRun Updater 5? If so, can anyone explain what Boby is talking about? Running win2k and CFMX 7 ent. Cheers Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:20 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfoutput inside cfoutput with a string coming from a db
or you could write your own render() function, though you'd want a bit of error trapping, and might want to use the temp directory rather than the current one. And performance is going to be a bit not great. Plus you'd want to be *very* careful about what gets passed to this function... cffunction name=render output=No returntype=string cfargument name=str required=Yes type=string cfset var rStr = cfset var tmpFile = CreateUUID() cffile action=WRITE file=#GetDirectoryFromPath(GetCurrentTemplatePath())##tmpFile# output=#arguments.str# cfsavecontent variable=rStr cfinclude template=#tmpFile# /cfsavecontent cffile action=DELETE file=#GetDirectoryFromPath(GetCurrentTemplatePath())##tmpFile# cfreturn rStr /cffunction Bert On 4/27/05, Adam Haskell [EMAIL PROTECTED] wrote: Uwe if you want to do this you would have to use New Atlanta's Blue Dragon. They have a new function (version 6.2) called Render. It should perform exactly as you are expecting cfoutput#bob#/cfoutput. Adam H ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204973 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Sessions Across Domains / SSL
Passing cfid and cftoken in the URL to a separate domain on the same server will allow you to share sessions across domains, but only if the server is set NOT to use J2EE sessions (cfadmin server settings memory variables). If you *are* using J2EE sessions then passing the jsessionid in the URL won't work across domains: i'm not sure what JRun uses to determine that a particular sessionid is not valid for a domain, but you will get assigned a new session. The only way i've found to share a session accross domains is to pass the sessionid to the new domain (either in URL or form), then on the new domain write the cookie manually using cfheader (eg cfheader name=Set-Cookie value=jsessionid=#form.jsessionidFromTheOtherDomain#) (Using cfcookie didn't work cos it urlencodes the $'s...). Once you have written the cookie on the new domain then all subsequent requests on the new domain will use the session attached to that cookie. I don't know if this will work in your case, but its the only way i've found to use J2EE sessions and share them accross more than one domain (eg www.myenglishdomain.com and www.myfrenchdomain.fr) If anyone has a simpler way to do this then i'd like to know... Cheers Bert On 4/26/05, Brad Roberts [EMAIL PROTECTED] wrote: I'm using a shared SSL from HostMySite. When I send a visitor to an SSL page, they lose their session and are prompted to login again. In the past, I've appended the urlToken and session vars were maintained. I do know that HostMySite has upgraded to CFMX 7. Shouldn't this work if I pass the cfid/cftoken? Thanks, Brad Roberts ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204645 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfoutput inside cfoutput with a string coming from a db
You could save the dB output to a file, then cfinclude the file. Depending on your particlular situation this could either be a good idea, or a bad one, and possibly anywhere in between. Cheers Bert On 4/27/05, Uwe Degenhardt [EMAIL PROTECTED] wrote: Hi list, I have a db-field let us say string_field. Let us assume that this field contains the followingexpression inside the db-field: Hello, my name is cfoutput#form.name#/cfoutput... When I output that with: cfoutput#a#/cfoutput appears Hello, my name is #form.name# So it doesn't work out as expected. How can I show the paramater correctly of #string_field# Thanks for infos. Uwe ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204646 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Are search engine safe URLs really necessary?
I use a custom 404 set in IIS to redirect to a URL (index.cfm/fuseaction/iis404), and i either get a 302 or 200 status code depending on whether fuseaction:iis404 does a cflocation or not. (reading status codes using the firefox live http headers tool) Cheers Bert On 4/25/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jeff, While that works, doesn't it mean that HTTP status code returned is still 404? Could be enough to make the googlebot not even index the page content. Just a thought ~k -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: 25 April 2005 13:34 To: CF-Talk Subject: RE: Are search engine safe URLs really necessary? I use a custom 404 handler that does a database lookup from a table of vanity URLs. It evaluates the last value of a list separated by / and searches the database for the url... Simple enough for me. HTH, Jeff ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfx image?
it might be worth pointing out there are (at least?) two completely different cfx_image tags out there: in addition to the one below (which i haven't used) there is Jukka Manner's which you'll find at http://www.kolumbus.fi/jukka.manner/ I have used jukka's and it was fine for what we needed. Cheers Bert On 4/13/05, Stan Winchester [EMAIL PROTECTED] wrote: I've used the freeware CFX_Image as found on http://vwww.gafware.com:81/ and have really liked it. It only works on Windows servers though. His site is slow and a pain to get around, but I really like the tag. If you search for cfx image in his search form, you should be able to download the tag. Hi, I've fiddled with some image manipulation tags and found some of them to make jagged images on resize. Anybody know how good cfx image is at resizing? I previously used imagemagic which seems very good but the docs say it doesnt work with mx because of issues with cfexecute. Anybody knows if this is ok now? Thanks! -- DRE http://www.webmachineinc.com http://www.theanticool.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202532 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 500 null
If you go to cfadmin/settings and uncheck enable HTTP status codes, this will give you the standard CF error which should help you diagnose the root cause of the problem. If it turns out to be a timeout thing then you might need to add cfsetting requesttimeout=... to the long running pages. HTH Bert On Thu, 17 Mar 2005 09:41:10 -, James Smith [EMAIL PROTECTED] wrote: Every now and again, often on pages that take a while to execute but not always I receive a 500 null in big black letters. The code looks like this. headtitleJRun Servlet Error/title/headh1500 null/h1body /body Does anyone know what is causing it and how to avoid it as it is becoming a real problem for us. -- Jay ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199094 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SES urls, cgi.path_info, cgi.request_uri, CF6 and CF7
Moving from CF6.1 to CF7 on IIS6, and i've noticed that the cgi.path_info variable is reported slightly differently when using SES type URLs. In previous versions of CF, the cgi.path_info always included the, er, path info, whether SES variables were apended or not.: URL: example.com/sumdir/index.cfm?foo=bar CF6 cgi.path_info: /sumdir/index.cfm CF7 cgi.path_info: /sumdir/index.cfm URL: example.com/sumdir/index.cfm/foo/bar CF6 cgi.path_info: /sumdir/index.cfm/foo/bar CF7 cgi.path_info: /foo/bar The SESconverter.cfm from fusium.com still works in CF7 since it tests for the presence of cgi.request_uri, which is present in both CF6 and CF7 on IIS6, and appears the same as the pre-CF7 cgi.path_info. So it looks like i'm going to have to change all references from cgi.path_info to cgi.request_uri. Strange thing about cgi.request_uri is that its not present if you dump the cgi scope, but it is there if you reference it directly, both in IIS6 and apache2. How come its not in cgi structure when dumped, but is there when referenced? Is cgi.request_uri a more standard cgi variable? And is it safe to use? (not showing in the cgi dump makes me a little cautious) Cheers Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197811 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Homesite 5.5 vs. Dual Monitors
To get more than one HS+ running, open regedit, go to HKCU\Software\Macromedia\Homesite+ and add a new string value: AllowMultipleInstances = -1 AFAIR the only annoying thing is that clicking on a .cfm template means a new instance of studio opens, and i haven't used since about 4 years ago, but it seems to still work with HS+ Cheers Bert On Tue, 1 Mar 2005 15:31:13 -0600, Justin Hansen [EMAIL PROTECTED] wrote: I have dual 19's and I REALLY want to be able to view to different files at the same time, one on each monitor, in Homesite. Homesite will not let me have more than one window open at a time. Does DW support multi windows? I know eclipse does, but I can't get passed the over complicated snipit keys. I may have to try DW again. Argh... Anyone? Justin Hansen Project Manager Uhlig Communications ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197094 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: guide to upgrading 6.1 to 7
Tom I knew it was *possible* to install them side by side, but i just got into a bit of a state looking for a dummys guide to doing the ear thing to get from 6.1 on JRun to MX7 multiserver. However, i've just found the following sentance in the release notes (http://www.macromedia.com/support/documentation/en/coldfusion/mx7/releasenotes.html#installation) If you installed ColdFusion MX 6.1 using the ColdFusion MX with JRun 4 option and wish to use the Enterprise Manager, you must uninstall JRun before installing ColdFusion MX 7 So i had to re-instal it all anyway, cos i want the Enterprise Manager. Slightly Sheepishly Bert On Mon, 28 Feb 2005 14:46:25 -0500, Tom Jordahl [EMAIL PROTECTED] wrote: Bert, We made sure that CFMX 6.1 and CFMX 7 could be installed side-by-side. In particular, if you had just installed standalone CFMX 7, you should have had no problems, especially if you selected the built in web server option. There should be information about this in the release notes. -- Tom Jordahl Macromedia Server Development ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: guide to upgrading 6.1 to 7
hmm, i saw that: it seems to be more about moving from CF5 to MX7. In the end i just uninstalled 6.1, JRun and all, and then installed 7. Since this is the dev box it would have been nice to have both running side by side, or the option to switch between them without a full uninstal/instal, but after 15 minutes getting wound up by the MM site i decided to cut my losses: i couldn't afford to spend a few hours fiddling with ear files and wsconfig, and whatever else... Cheers Bert ps maybe i'm being dumb or just picky, but there appear to be a lack of a 6.1 to 7 guide, at least i couldn't find one. Normally i just go ahead and install stuff, but this time i wanted to at least skim TFM. On Thu, 24 Feb 2005 13:36:40 -0500, Earl, George [EMAIL PROTECTED] wrote: Bert said: I'm looking for a guide to upgrading from 6.1 to 7 on the MM site and coming up with nothing. Does anyone know if such a thing exists? Cheers You mean something like this? http://download.macromedia.com/pub/documentation/en/coldfusion/mx7/cfmx7_mig rating.pdf George [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
guide to upgrading 6.1 to 7
I'm looking for a guide to upgrading from 6.1 to 7 on the MM site and coming up with nothing. Does anyone know if such a thing exists? Cheers Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196282 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
can't get onApplicationStart to fire...
I can't seem to get onApplicationStart to run, nor onSessionStart, but on request start works fine. I'd be grateful if someone could caste an eye over my code to see if they can spot what i'm doing wrong: 2 files in a directory: Application.cfc and index.cfm: -- Application.cfc: cfcomponent cffunction name=onApplicationStart returnType=boolean cfset application.started = now() cfreturn True /cffunction cffunction name=onRequestStart returnType=boolean cfset request.started = now() cfreturn True /cffunction cffunction name=onSessionStart returnType=void cfset session.started = now() /cffunction /cfcomponent -- index.cfm: cfapplication name=#CreateUUID()# clientmanagement=No sessionmanagement=Yes setclientcookies=No cfdump var=#application# cfdump var=#request# cfdump var=#session# -- When i run index.cfm only request.started has been set (plus application.name, session.jsessionid and session.urltoken, and request.cfdumpinited). TIA Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194206 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: can't get onApplicationStart to fire...
No, but then why should i? If the methods were getting called then the ?.started variables would be getting set, but only request.started is getting set. Bert On Fri, 11 Feb 2005 06:32:53 -0500, Calvin Ward [EMAIL PROTECTED] wrote: Are you restarting CF before you request index.cfm? -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 5:48 AM To: CF-Talk Subject: can't get onApplicationStart to fire... I can't seem to get onApplicationStart to run, nor onSessionStart, but on request start works fine. I'd be grateful if someone could caste an eye over my code to see if they can spot what i'm doing wrong: 2 files in a directory: Application.cfc and index.cfm: -- Application.cfc: cfcomponent cffunction name=onApplicationStart returnType=boolean cfset application.started = now() cfreturn True /cffunction cffunction name=onRequestStart returnType=boolean cfset request.started = now() cfreturn True /cffunction cffunction name=onSessionStart returnType=void cfset session.started = now() /cffunction /cfcomponent -- index.cfm: cfapplication name=#CreateUUID()# clientmanagement=No sessionmanagement=Yes setclientcookies=No cfdump var=#application# cfdump var=#request# cfdump var=#session# -- When i run index.cfm only request.started has been set (plus application.name, session.jsessionid and session.urltoken, and request.cfdumpinited). TIA Bert ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194214 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: can't get onApplicationStart to fire...
But I'm using createUUID() as the application name to ensure the application always starts on every request... (I'm only doing this cos i got bored of changing the name everytime i tweaked Application.cfc to try and get it to work) And either i'm using the same session, in which case session.startup should already be set, or its a new session, in which case it should be set. Or am i missing something? Bert On Fri, 11 Feb 2005 07:01:49 -0500, Calvin Ward [EMAIL PROTECTED] wrote: Because if you don't restart CF then the Application is already started and onApplicationStart will never fire. The Application starts on the first browser request to the CF server after the CF server is started. Additionally, you may want to close and re-open your browser to get onSessionStart to fire. - Calvin -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 6:50 AM To: CF-Talk Subject: Re: can't get onApplicationStart to fire... No, but then why should i? If the methods were getting called then the ?.started variables would be getting set, but only request.started is getting set. Bert On Fri, 11 Feb 2005 06:32:53 -0500, Calvin Ward [EMAIL PROTECTED] wrote: Are you restarting CF before you request index.cfm? -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 5:48 AM To: CF-Talk Subject: can't get onApplicationStart to fire... I can't seem to get onApplicationStart to run, nor onSessionStart, but on request start works fine. I'd be grateful if someone could caste an eye over my code to see if they can spot what i'm doing wrong: 2 files in a directory: Application.cfc and index.cfm: -- Application.cfc: cfcomponent cffunction name=onApplicationStart returnType=boolean cfset application.started = now() cfreturn True /cffunction cffunction name=onRequestStart returnType=boolean cfset request.started = now() cfreturn True /cffunction cffunction name=onSessionStart returnType=void cfset session.started = now() /cffunction /cfcomponent -- index.cfm: cfapplication name=#CreateUUID()# clientmanagement=No sessionmanagement=Yes setclientcookies=No cfdump var=#application# cfdump var=#request# cfdump var=#session# -- When i run index.cfm only request.started has been set (plus application.name, session.jsessionid and session.urltoken, and request.cfdumpinited). TIA Bert ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194224 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: can't get onApplicationStart to fire...
I'm confused now: I'm i right in thinking that onApplicationStart() should fire automatically when the application starts? And by application starting i mean the first time a cfapplication tag with a particular application name is run (assuming server has just restarted). If thats correct then i can't get it to work: my onApplicationStart() never fires. Or am i supposed to call it manually: ie cfapplication name=myApp cfif NOT IsDefined('application.started') cfset onApplicationStart() /cfif Cheers Bert On Fri, 11 Feb 2005 06:36:19 -0600, Raymond Camden [EMAIL PROTECTED] wrote: You may also want to consider a very low app timeout while testing. You may also want to consider putting something like this in your onRequestStart: if isDefined(url.reinit) onApplicationStart() Unfortunately, this will only run you rmethod. It will not reset the Application like a true restart. But in most cases you don't really care. I've already bugged MACR about adding a real way to programatically restart an App/Session. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: can't get onApplicationStart to fire...
Aha - thats what i was missing. So in order to use the onApplication and onSession methods you need to initialise the application in application.cfc, except instead of using the cfapplication tag you set the the parameters in the This scope. In other words, Application.cfc replaces both Application.cfm and cfapplication (unless you only want to use the onRequest methods) Thanks Bert On Fri, 11 Feb 2005 22:29:51 +0800, James Holmes [EMAIL PROTECTED] wrote: Does it work if you use Application.cfc to set the app paramaters? http://livedocs.macromedia.com/coldfusion/7/htmldocs/1115.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFQUERY ALTER TABLE
CREATE TABLE HartGraph ( IDNumb int NOT NULL default 0, HorizMark int NOT NULL default 0, ) the above CREATE TABLE statement will also create you a couple of default contraints, using automatically generated names. In effect the above query was run as: CREATE TABLE HartGraph ( IDNumb int NOT NULL default 0, HorizMark int NOT NULL CONSTRAINT DF__HartGrap__Horiz__123EB7A3 default 0, ) You are going to have to drop the contraint before you can change the column: ALTER TABLE HartGraph DROP CONSTRAINT DF__HartGrap__Horiz__123EB7A3 You should then be able to run your alter column statement ALTER TABLE HartGraph ALTER COLUMN HorizMark VARCHAR( 20 ) NULL HTH Bert ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194024 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: problems installing mx7
Take a look at the source of the admin index.cfm, ie open the actaul index.cfm from the file system, not the browser. If it looks like the garbage you get in the browser then it sounds like apache hasn't been configured correctly during the installation Try running the web server config app (C:\JRun4\bin\wsconfig.exe). If Apache is already there then remove it, then add it again. HTH Bert On Tue, 08 Feb 2005 15:15:52 -0400, dan martin [EMAIL PROTECTED] wrote: Anyone else have problems installing it? It said it installed properly and I can run cfm pages through it, but going to the cfide/administrator/index.cfm page displays garbage on the screen. I uninstalled and reinstalled with all the default setting with the same results. I am running on win xp with apache with the 30 day trial version downloaded today. Anyone have any ideas how to troubleshoot this? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193800 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: null null The error occurred on line -1.
We used to be plagued with null null errors, followed by server hanging or restarting every hour during busy periods. We fixed it by setting Max Pooled Statements on the advanced dsn page in cfadmin to zero. MM are still trying to figure out why we were getting this, so i suppose its unlikely to be the same problem. But its worth a try. (preferably before embarking on weeks of tweaking around with various java settings, garbage collection, trawling through a 5 years in the making codebase looking for problems) Cheers Bert On Mon, 7 Feb 2005 09:26:24 -0500, Gaulin, Mark [EMAIL PROTECTED] wrote: Anybody know what this error (reporting by error.Diagnostics) means? null null The error occurred on line -1. We got a four of them before a CFMX server stopped responding, but they were spread out over a few minutes. I don't know if it is directly related to the seize up or not, but it sure looks funny. Thanks Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193363 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Coldfusion VS ASP.NET use
index.cfm: about 17,600,000 index.asp: about 16,600,000 Looks like an open and shut case. :) Cheers Bert ps and after a quick check (google on site:www.mysite.com) i reckon about 4% of those 17 million are mine! On Fri, 4 Feb 2005 10:59:48 +, Mark Drew [EMAIL PROTECTED] wrote: I found this graph a while back, and I am looking to see if there are any other sites that show the graph of technology use that is more up to date? http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_java_servlets.html I am trying to get some figures on overall usage of CF on websites. Anybody got something like that knocking round? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ fusebox plugin for cfeclipse: http://cfopen.org/projects/fusebox3cfe/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193059 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 500 Internal Server Error (Update)
Have you tried going to CF admin and unchecking the Enable HTTP status codes on the settings page? Bert On Fri, 4 Feb 2005 09:47:54 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: From: Micha Schopman [mailto:[EMAIL PROTECTED] I have the same issues, and they occur only when I really have put a bug somewhere. But it is a pain in the ass to debug, because you haven't got an idea where to look especially with OO frameworks with a lot of references. Yeah, PITA is right. I noticed it happens most when the error/exception is database related... This time it was a typo calling a stored procedure. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193073 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Coldfusion VS ASP.NET use
whoops - looked like i removed the first line - it should have read:... searching google i found: index.cfm: about 17,600,000 index.asp: about 16,600,000 Cheers Bert On Fri, 4 Feb 2005 10:37:36 -0500, Vince Bonfanti [EMAIL PROTECTED] wrote: Where did you search to get those number? {snip} -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:43 AM To: CF-Talk Subject: Re: Coldfusion VS ASP.NET use index.cfm: about 17,600,000 index.asp: about 16,600,000 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193094 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic Query Problem
Are you *sure* PreservereSingleQuotes() doesn't work? This works fine: cfset myQry = select 'hello' cfquery name=q datasource=#request.dsn# #PreserveSingleQuotes(myQry)# /cfquery I'd guess you're over escaping them somewhere along the line... Bert On Thu, 3 Feb 2005 13:39:24 -0500, Burns, John D [EMAIL PROTECTED] wrote: I'm going crazy here because I can't figure out why this is acting this way. We've got some code in a CFSCRIPT block that builds some SQL to be executed in a query. The variable holds a value that looks like this: insert into table(id,value1,value2,value3) values(9,'First Name', 'Last Name','123-123-1234') and when we dump the variable prior to the query, it looks fine and we can copy and paste it into Enterprise Manager or SQL Query Analyzer and it does what it's supposed to. However, we try putting that variable into a cfquery tag and for some reason it doubles up all of the single quotes and then the query fails. We've tried putting 2 single quotes on each side of a string and also 3 single quotes on each side. It seems to double whatever number of single quotes we put there. We've also tried PreserveSingleQuotes() and we've tried no quotes but nothing works. I know I'm missing something simple. Anyone have any ideas? John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192950 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Displaying the first value from cfoutput
You can use array notation to specify the record you want: #myQuery.myColumn[1]# Cheers Bert On Thu, 3 Feb 2005 11:34:12 -0800, Rodger [EMAIL PROTECTED] wrote: I use a cfquery to retrieve a small list. I then want to display the first value returned as the default, and populate all of the items into a list box. The list box populates ok, but when I use cfoutout query=, I get all values displayed. How can I capture the first value into a variable, so that I can then use it as the default? Rodger ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192951 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: redirect opinions
Have you considered using cfinclude rather than cflocation? eg: cfswitch expression=#cgi.server_name# cfcase value=mysite1.com cfset brand = mysite1 /cfcase cfcase value=mysite2.com cfset brand = mysite2 /cfcase cfdefaultcase cfset brand = mysite3 /cfdefaultcase /cfswitch cfinclude template=../#brand#/#cgi.script_name# If all requests come through the index.cfm (as in eg fusebox) then this works a treat. Otherwise its going to need a bit more thought, but i'd say its still going to be preferable to doing a cflocation. Cheers Bert On Sat, 29 Jan 2005 12:58:54 -0500, Les Mizzell [EMAIL PROTECTED] wrote: I've got a client that's decided to host a bunch of different sites under one domain. Though the hosting company is suggesting that I use a PHP script to handle the domain redirects, I'm a PHP noob, so I'd rather go with something I know. So, in the root directory I figure I can just add this to the Application.cfm file to take care of it: CFIF #CGI.SERVER_NAME# CONTAINS abc.com CFLOCATION URL=whatever/index.cfm /CFIF Is there a better solution? I've also warned the client that this is going to make it darned hard to get the different domains spidered correctly by the search engines, but what the heck Haven't tried it yet, but maybe include an index file with links containing a paragraph or two with proper descriptions and keywords for each site it's linking to. Regular users visiting the site wouldn't see this because they'd get redirected by the application file. I'm not 100% sure if the spiders would see it either but it's worth a try. -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Frequent Server Restart
We had a similar problem until 2 days ago: servers restarting every hour or so when under load. We changed Max Pooled Statements from the default 1000 to 0, and the servers have been running happily for over 48 hours now. We're waiting to hear back from MM on the cause... There's a thread over on the cf server list: http://www.houseoffusion.com/cf_lists/messages.cfm/threadid=1263/forumid=10 Cheers Bert On Thu, 27 Jan 2005 23:45:16 -0400, Andrew Grosset [EMAIL PROTECTED] wrote: Hi, I have a site (that is not yet public) which is on a shared server with a major CF hosting company running MX 6.1 . In the last nine days the server has been restarted nine times including twice today. The server restarts are monitored by scheduling cfscheduler to call a template once an hour that checks if a specific application variable is defined, if it's not it emails me and resets the application variable. They are also unable to synchronise the server time with nist.time.gov but that is a separate issue. Any suggestions as to what they (the hosting Co) and I can do? Andrew. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192067 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Sessions being show to wrong users?
I've seen this occurring when a PC which already has the cfid and cftoken has been used as an image to clone more PC's, all of which ended up having identical cookies. Is this just happening on certain machines? Also, i've seen it happen due to sloppy coding in an application scoped cfc, which resulted in everyone pointing to the same session. But if you're on CF5 it wouldn't be that. Cheers Bert On Wed, 26 Jan 2005 09:06:03 -, Kevin Roche [EMAIL PROTECTED] wrote: Hi, In the past I have seen the following acuse this problem: 1/ users who sent each other links to pages with CFID and CFTOKEN in the link. 2/ Search engine spiders site and picks up a CFID and CFTOKEN. 3/ Firewall caches the CFID and CFTOKEN (This was many years ago and I think most are fixed now) 4/ Missing CFLOCK Hope that helps Kevin -Original Message- From: Ian Buzer [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 07:31 To: CF-Talk Subject: Re: Sessions being show to wrong users? I'd back up Martin's theory of it being search engines indexing the site with the CFID/CFTOKEN in the URL. If two people follow that link within the session time out they will share the session. I now only use CFID/CFTOKEN in the URL from behind a log in page, or after someone has added an item to the basket etc ... all things a search engine can't do. It's always occurred to me that this is a massive security hole in the way that ColdFusion manages sessions. Having said that, most application servers use a similar method of maintaining session when cookies are not enabled. Ian What is the URL that these people are coming in on ? Meaning, has Google cached one of your pages which has mypage.cfm?CFID=xxxcftoken=xxx in the URL. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191772 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Calling Templates
Assuming the other template you're calling is a cf one, then CFINCLUDE and/or CFMODULE are almost certainly what you want. I'm not sure what you mean when you say we need portability and CFINCLUDE forces hard coding of file directories. Could you be more specific? If the template you're calling is not a CF one then you might want to look at GetPageContext().include(filename). As for CFHTTP, IMHO this should be used for getting stuff from *other* sites/servers: i've never come across a situation where using CFHTTP to make a request to the same server cannot be done in a more, er, elegant way. Cheers Bert On Sat, 22 Jan 2005 02:35:20 -0600, Nick Baker [EMAIL PROTECTED] wrote: Calling another template. Same site. Different subdirectory. CFEXECUTE does what I believe I need, but we need portability, and CFEXECUTE is disabled by lots of host. Short comings of other tags I haven't found an elegant way to over come: 1. CFINCLUDE - We are doing some file work and using CFINCLUDE forces hard coding of file directories 2. CFCONTENT and CFMODULE appear to hold some possibilities, but haven't used these in this sort of method. Concerned about what problems I might be introducing? 3. CFHTTP appears to be the best based on what I know, but is this really elegant? Thanks, Nick ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191524 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cftree error after an upgrade
Can you see the /CFIDE/classes from your webroot? This is where the cfapplets.jar is kept, and he reference to is is in the HTML that CF spits out when you use cftree, so you'll either need a copy of it under your webroot, or a virtual directory to point to it. Cheers Bert ps there might be a way to specify where the browser should look for these controls - i know you can tell a cfform where to look for the .js files used by cfinput and the like, but i don't know for sure On Thu, 20 Jan 2005 07:51:07 -0400, Richard East [EMAIL PROTECTED] wrote: cftree error after an upgrade I recently upgraded a server from 5 to MX. I’m trying to use the cftree tag but the applet fails to load. Checking the Java Console I got the following error: load: class coldfusion.applets.CFTreeApplet.class not found. java.lang.ClassNotFoundException: coldfusion.applets.CFTreeApplet.class Checking livedocs someone else has had a similar problem, but there’s no solution posted. Does anybody know what I need to do to get cftree back on my server, please? I’m not new to CF, but I am new to fiddling behind the scenes… Thank you for your help, Richard ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191201 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
two websites, one Cfusion, sharing sessions
Is it possible to run 2 websites on a single CF server, and for a user to have the same Jsession on both sites? I have enabled Use J2EE session variables in cf admin, and tried passing the jsessionid in URL and form fields when linking between the two sites, but it doesn't work: sooner or later a jsession cookie will get set which has a differnt value, and each site then has a separate session. TIA Bert ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190896 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: two websites, one Cfusion, sharing sessions
They already *do* share the same application name The problem seems to be with setting the jsession cookie: I go to site-a, get a jsession cookie, then when i follow a link to site-b i need to have the same jsession cookie set for that domain. If i pass the in the URL (?jsessionid=#session.sessionID# or ?#session.urltoken# or URLsessionFormat() ) then the session is shared, but no cookie is set on site-b, and so the session is only available on site-b when the ID is passed in the URL. If i try to manually set a jsessionid cookie on site-b then it is re-set whenever i follow a link without the ID in the URL, as if JRun can recognise that it is not a cookie set by JRun... I currently do the same thing using cfid and cftoken, and it works fine, but i need to move to jsessions and this is proving to be a bit of a stumbling block Bert On Tue, 18 Jan 2005 11:57:44 -, Tim Blair [EMAIL PROTECTED] wrote: Is it possible to run 2 websites on a single CF server, and for a user to have the same Jsession on both sites? The easiest way would be to have the same application name in your cfapplication tag on each site. Of course, both sites would also share the same application scope etc too. Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - independent digital media agency We are big, we are funny and we are clever! New site launched at http://www.rawnet.com/ --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: two websites, one Cfusion, sharing sessions
Is this something you've found that works, of is it the official answer? Apart from being such a PITA as to not really be an option, i've done a quick test and it looks like this is not going to would with sticky sessions in a cluster - the request with the jsession in the URL gets passed to whichever server is next, rather than the one related to the particular jsessionid. Cheers Bert On Tue, 18 Jan 2005 21:24:40 +0800, James Holmes [EMAIL PROTECTED] wrote: You also need to continue to pass the URKLToken in every link in your app. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: two websites, one Cfusion, sharing sessions
On Tue, 18 Jan 2005 15:29:50 +0100, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: it's not a bug, it's a (security) feature - a site can only retrieve cookies it has set itself, I know that. I need to get to a situation where 2 sites have the same jsessionid. It gets set automatically on site-a, by JRun. Ideally, when the user clicks to site-b i would like to pass along the sessionID in the URL, and for JRun to see the url.jsessionid, send the request to the correct server if its clustered, and set a cookie.jsessionid on site-b. But it doesn't appear to do this. If i set the cookie on site-b (using the value in url.jsessionid) manually using CF then the $ signs are helpfully escaped to %24. This causes JRun to set a new cookie (and start a new session) when i start relying on the cookie. I've just discovered that if I use javascript to set the cookie then everything works OK, but this relies on the user having javascript enabled. Has no-one else had to share Jsessions accross mutliple domains? Bert ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: two websites, one Cfusion, sharing sessions
I tried UrlDecode() , and replace, but using cfcookie or cfset cookie always seems to escape the $. Is there a way to manually set the cookie without using javascript or CF? test cfcookie name=TEST value=$ cfcookie name=TEST1 value=#URLdecode('%24')# cfset cookie.TEST2 = $ script document.cookie=TEST3=$; document.write(document.cookie); /script result: TEST=%24; TEST1=%24; TEST2=%24; JSESSIONID=d830efc7b820$DCU$3DH; TEST3=$ It would be nice to set the cookie before going to the site, eg by creating an img tag with the id in the url, but i don't know how many people have 3rd party cookies turned off. Plus, if i can't use CF to set the cookie then this is a non-starter.. On Tue, 18 Jan 2005 11:41:37 -0500, Dave Watts [EMAIL PROTECTED] wrote: is that because it came from the URL? Try the two following tricks: - use UrlDecode() when writing url.jsessionid to the cookie or - have siteA write a cookie for siteB (using cfcookie domain=... syntax) and vice versa (siteB writes cookies for siteA) The first option should work. The second one probably won't, because you can't just specify a completely different domain when writing a cookie. The DOMAIN attribute lets you limit the cookie being written to a specific subdomain within a domain. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190947 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: two websites, one Cfusion, sharing sessions
On Tue, 18 Jan 2005 18:13:02 +0100, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: what does though, is doing it by hand: cfheader name=Set-Cookie value=TEST_BYHAND=;path=/tanguyland/ yields Set-Cookie: TEST_BYHAND=;path=/tanguyland/ Cool - that does the trick. Now the only problem is that when i make the first request from one site to the other there is no cookie, so CF/JRun won't send my request to the correct server if i have a cluster. I suppose i can take care of this using CFlocation once i've set the cookie. Alternatively, when i log-on to one site i can cflocate around the sites writing cookies then end up where i started. After that i shouldn't even need to bother with passing the jsession in any URLs. Just out of interest, does anyone else share jsessions over several domains in this (or any other) way? Cheers Bert ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190953 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: GetPageContext vs CFINCLUDE
The way see it, using getpagecontext to pull in an HTML file has the advantage that it doesn't cause CF to process the included file, whereas cfinclude will always treat it as if it were cfml, i.e. compile a class etc. On the other hand, you can cfinclude an HTML file from anywhere, but getpagecontext has to reference a file under the web root. Personally, i use getpagecontext to include dynamically created (and cached) HTML year-planner type pages. And also to request various scheduled tasks: rather than having a dozen or so tasks to set up in cf admin i now hav one which says: getpagecontext('/schedule/task1.cfm?requesttimeout=120'); sleep(5000); getpagecontext('/schedule/task2.cfm?requesttimeout=120'); etc. Bert ps and i use cfinclude a lot too. On Fri, 14 Jan 2005 22:50:18 -, Ciliotta, Mario [EMAIL PROTECTED] wrote: Hi can anyone tell me the value of using getpagecontext vs CFINCLUDE. I have a few sites that make big use of CFINCLUDE to include HTML and I was wondering if the getpagecontext is a better choice. Also do you need to put CFOUTPUT around it or just use it in cfscript Here is my example below. Thanks Mario CFINCLUDE template=./html/spacer.htm CFSCRIPT getPageContext().include(./html/spacer.htm) /CFSCRIPT ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: search engine friendly urls
Prior to FB3 there was a customtag called formURL2attributes. Later versions of this tag included the SES conversion stuff, but when FB3 was released the form and URL scope copying was moved to the core files, and the SES stuff to a separate SESconverter.cfm. So, if you want to use SES stuff in FB3+ you'll need to call SESconverter.cfm from your code. In FB3 this will need to happen before you include the core file, but I'm not 100% sure about FB4: calling it before the core file should work, but there might be a more cunning way... As for how to call it, you can either call as a tag or cfinclude it. The main thing you'll need to do is ensure you output the #basehref# at the top of your template. Also, on MX, you'll need to add a servlet mapping as described in issue 52942 on http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_known_problems.html#generalserver And there's an FAQ on www.fusium.com Cheers Bert On Tue, 11 Jan 2005 08:27:19 +1100, Duncan I Loxton [EMAIL PROTECTED] wrote: I was just wondering if Fusebox 3 and 4 had this natively, Bert - how do I approach this and use it? All our apps use FB3 4.5 and we are moving them slowly but surely to MX and FB4. Duncan ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189902 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
sharing sessions across domains
I have 2 domains pointing at the same 2 web sites which in turn point to the same CF codebase (win2k, iis6, cf6.1 enterprise with updater): eg: www.mysite_en.com and www.mysite_de.com Currently i can share my session between the 2 sites by passing the cfid and cftoken in the URL when i link from one site to the other. However, we're (probably) going to move to clustering (multiple CF instances on a single server) using sticky sessions, and as far as i understand this means i'll need to start using J2EE session variables. But when try passing the jsessionid to the other site it doesn't use it, but rather sets a new cookie.jsessionid. Even if i manually set it using cfcookie name='jsessionid' value='#url.jsessionid#' So, the question: is it possible to have a single user/browser session accessing the same J2EE session from 2 different domains on 2 separate web sites running on the same server? And if so, how? TIA Bert ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189968 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: search engine friendly urls
SESconverter from http://www.fusium.com/index.cfm?fuseaction=ses.intro should do the trick. Cheers Bert (ps FYI, when fusebox 3 was released the SES stuff from formURL2attributes.cfm was tweaked and repackaged as SESconverter.cfm) On Mon, 10 Jan 2005 17:07:41 +1100, Duncan I Loxton [EMAIL PROTECTED] wrote: Can anyone point me in the direction of a tag or tutorial on how to convert a url and all its bits into a Search engine firendly one? i.e. uses all \ rather than the standard ? and = and Specifically for CF 4.5 right now, but also for MX later. And is it really worth doing? Will it make it easier to get our sites into engines other than google? What are the arguments against doing it? Thanks Duncan ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Certification exam: Wait for Blackstone?
1. no idea 2. dunno, but i took the exam at CF4.5, and when CF5 came out a few months later i got a new certificate saying i was a CF5 certified (advanced) developer. 3. dunno 4. personally, i would wait. I had a vague plan to take the exam again sometime, but have put this on hold until the cf7 one comes out. Cheers Bert On Thu, 06 Jan 2005 10:20:16 -0400, Stephen Lapointe [EMAIL PROTECTED] wrote: For those with some insider knowledge, some questions about CF certification and Blackstone: 1) Will the Blackstone certification exam become available at about the same time as the Blackstone product release? 2) If someone were to take the CF certification exam now (and pass), would the certification be carried forward to Blackstone? 3) If the answer to 2 is no, would there be some coupon/discount for the Blackstone exam if you've taken the current CF exam just a short period before the Blackstone exam is available? 4) Bottom line: Would you recommend taking the CF certification exam now, or wait until the Blackstone exam becomes available? Thanks for any input. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189621 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: help with loops, updating data
Its only using the first record from the state_contact_detail query because thats what you're telling it to do... You should be able to do what you want all in the UPDATE statement: UPDATE contact_detail SET state = ( SELECT davids_excel.state FROMdavids_excel WHERE davids_excel.company_name = contact_detail.company_name) HTH Bert On Wed, 15 Dec 2004 14:16:47 -0500, Tim Laureska [EMAIL PROTECTED] wrote: I have two tables in an access db... I'm trying to update a state number field in one with the state number from another the only way to match up the two tables is by company name so I'm trying this but failing (not getting error, but only extracts the first company name from the state_contact_detail query cfquery name=state_change datasource=#SalesPerson_DB# SELECT state, companyname FROM davids_excel where companyname=companyname /cfquery cfquery name=state_contact_detail datasource=#SalesPerson_DB# SELECT state, company_name FROM contact_detail where company_name=company_name /cfquery cfloop query=state_change cfquery name=QRY_update datasource=#Salesperson_DB# UPDATE Contact_detail SET State=#state_change.state# where '#state_contact_detail.company_name#'='#state_change.companyname#' /cfquery /cfloop Tim Laureska 1st-String Technologies ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: QUERY2FORM
Would be best not to return 2 columns with the same name in the first place: tweak the select statement to either alias them, or exclude the columns you don't want. SELECT table1.myColumn AS column_1 , table2.myColumn AS column_2 etc Cheers Bert On Wed, 15 Dec 2004 15:53:01 -0400, Asim Manzur [EMAIL PROTECTED] wrote: The last thing which needs to be done is I have two different table which has same field names. when I am using the function Query2Form, and these two variables comes to the loop it becomes a comma delimated value. How can I prevent to re-declare the already declared variable in Query2Form funciton ? ? ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187866 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: sql server: SQLTransaction
Just for the record, things seemed to quiten down after i rebuilt all the statistics. AskJeeves spider was hitting the server in the particular way which was causing the problems: there's a big cfquery with loads of conditional stuff (cfif somethingand someCol=whatever/cfif), and using particular search criteria was causing the query to run 00's of times slower than normal. All the same SQL was run in query analyser it ran fast. Removing the cfqueryparam tags also made the query run fast, so i ran sp_updatestats, and everything ran fast again - hurrah! I suppose lessons would be to run sp_updatestats before anything else. And that the AskJeeves spider likes SES urls. Cheers Bert On Tue, 7 Dec 2004 13:13:48 +, Bert Dawson [EMAIL PROTECTED] wrote: Are you sure the username is the one that is used from CF then? Yes, it definately the CF user - when i started looking at this i created a new new SQL login, and the only place this is used is in the DSN set up in CFadmin. How would you suggest i use a manual checkpoint? Just open up query analyser and run CHECKPOINT? Yes. I'll give that a go... Also, have just profiler again, over a period of about 10 minutes when there appeared to be no abnormal activity (according to CPU usage), and there are still times where the number of SQLtransactions appear v high (up to 9,000 in a second), so i'm begining to wonder if this level of SQLTransactions/second is unusual, or just normal activity... I think it would be unusual Thats what i would have thought. They seem to some in pairs, with EventSubSlass: Begin and Commit, and ObjectName: sort_init Do the periods of high activity coincide with the transaction log backups? Nope, they seem to come and go, though sometimes they show up failry regularly, and other times the CPU is just up and down all day I'm begining to think i might need to rebuild some indexes, as there are a few tables which have fairly heavy levels of delete and insert. Do you think fragmente indexes could cause this sort of behaviour? Thanks Bert ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187528 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
An exception occurred when instantiating a Com object
I'm getting an error (An exception occurred when instantiating a Com object, The cause of this exception was that: AutomationException: 0x80040154 - Class not registered) when trying to instantiate a COM object, but i only get it on some servers. My laptop works fine, as does the test server and a couple of the live servers. But the dev and a new live server are both giving the error above. (all are running CFMX6.1, with updater. And win2003, except the laptop which is XPpro SP1) a cfm file containing: CreateObject(COM, InternetExplorer.Application): throws the error on some of the servers (as listed above) a .vbs file containing Set o = CreateObject(InternetExplorer.Application) doesn't throw an error on any servers. (if i change the object name then it does throw an error) Any ideas why creating COM objects in CF would work on some servers and not on others? Cheers Bert ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187534 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFScript question - Queries
I think you need to escape (i.e. double up) the single quotes in any CF vars you're using in the query, then use preservesinglequotes() inside cfquery tag. cfscript mySQLstring = SELECT orders_id FROM Orders WHERE label = '#Replace(This_Label, ', '', all)#'; /cfscript cfquery name=qwe datasource=myDsn #PreserveSingleQuotes(mySQLstring)# /cfquery Cheers Bert On Wed, 8 Dec 2004 18:08:02 -0500, C. Hatton Humphrey [EMAIL PROTECTED] wrote: Why not just double up the single quotes? Tried that - may be a NDA thing or just a MySQL thing - I got the same error when sending the query. To answer Barney's question - I'm using a MySQL database. That's what the clent has and I haven't been able to dissuade him from using it. When I sent the query select orders_id from orders where label = '#This_Label#' ... I get a SQL error showing the doubled-up quotes. Hatton ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Nested Outputs
I think allowing nested cfoutputs is an MX thing: this just worked on MX 6,1,0,83762 cfoutputcfoutput#now()#/cfoutput/cfoutput I can't think of any reason why you'd want to do that, or why it was introduced - maybe its a feature which just happened in the move to java. It gets a bit more particular if you try nesting cfoutput when using the query and group attributes, and seems to work in the same way as cf5. Bert On Thu, 9 Dec 2004 10:48:51 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: Okay, so just means this server does not have its latest updates. Bothered me why it would be working. :) On Thu, 09 Dec 2004 11:46:17 -0400, Larry White [EMAIL PROTECTED] wrote: You can nest cf outputs with queries if you use the group attribute, otherwise nesting cfoutput is not permitted. It seems cfmx 6.0 had a bug that allowed it but it's been corrected I am sure this has been asked before and I have forgotten, but why is it that this works in MX(I recall it not in CF5). I also tried it with a cfquery to get blah so my first output had the query attribute, ran without errors. cfset myVar = blah cfoutput cfoutput#Variables.myVar#/cfoutput /cfoutput -- Aaron Rouse http://www.happyhacker.com/ ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186849 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFScript question - Queries
If you're using CF variables in your SQL you may* need to escape any single quotes when you're creating your SQL statement in the first place: cfset user = Barney O'Boivert cfset sql = select * from mytable where name = '#Replace(user, ', '', all))#' / cfquery ... #preserveSingleQuotes(sql)# /cfquery Bert * if there's any chance they will contain single quotes then you'll need to escape them On Thu, 9 Dec 2004 08:23:07 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: I use preserveSingleQuotes with MySQL without any issue. You shouldn't need to do anything special: cfset sql = select * from mytable where name = 'barneyb' / cfquery ... #preserveSingleQuotes(sql)# /cfquery On Wed, 8 Dec 2004 18:08:02 -0500, C. Hatton Humphrey [EMAIL PROTECTED] wrote: Why not just double up the single quotes? Tried that - may be a NDA thing or just a MySQL thing - I got the same error when sending the query. To answer Barney's question - I'm using a MySQL database. That's what the clent has and I haven't been able to dissuade him from using it. When I sent the query select orders_id from orders where label = '#This_Label#' ... I get a SQL error showing the doubled-up quotes. Hatton -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186926 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: sql server: SQLTransaction
Are you sure the username is the one that is used from CF then? Yes, it definately the CF user - when i started looking at this i created a new new SQL login, and the only place this is used is in the DSN set up in CFadmin. How would you suggest i use a manual checkpoint? Just open up query analyser and run CHECKPOINT? Yes. I'll give that a go... Also, have just profiler again, over a period of about 10 minutes when there appeared to be no abnormal activity (according to CPU usage), and there are still times where the number of SQLtransactions appear v high (up to 9,000 in a second), so i'm begining to wonder if this level of SQLTransactions/second is unusual, or just normal activity... I think it would be unusual Thats what i would have thought. They seem to some in pairs, with EventSubSlass: Begin and Commit, and ObjectName: sort_init Do the periods of high activity coincide with the transaction log backups? Nope, they seem to come and go, though sometimes they show up failry regularly, and other times the CPU is just up and down all day I'm begining to think i might need to rebuild some indexes, as there are a few tables which have fairly heavy levels of delete and insert. Do you think fragmente indexes could cause this sort of behaviour? Thanks Bert ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186433 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: sql server: SQLTransaction
We're not using client variables (default storage in cfadmin=none, clientManagement=No, no DSNs are configured to use client variables, or have the tables in them). How would you suggest i use a manual checkpoint? Just open up query analyser and run CHECKPOINT? Or place it in the code somewhere? Also, have just profiler again, over a period of about 10 minutes when there appeared to be no abnormal activity (according to CPU usage), and there are still times where the number of SQLtransactions appear v high (up to 9,000 in a second), so i'm begining to wonder if this level of SQLTransactions/second is unusual, or just normal activity... 0-99 SQLtransactions/second: 650 100-999 SQLTransactions/sec: 19 1000-1999: 6 2000-2999: 4 3000-3999: 2 4000-4999: 3 5000-5999: 1 6000-6999: 3 7000-7999: 0 8000-8999: 2 9000-: 1 AFAIK the only thing happening to the dBs apart from getting hit by CF is a backup of the transaction logs every 10 minutes, and a full back-up every hour. Any ideas of where to look next? (The underlying probem i'm trying to fix is jrpp.delayMs sometimes going through the roof for no apparent reason, and i suspect the dB, or connections to it, is in someway involved since the areas of the site which are more dB intensive are hit harder by timeouts when there is a problem) Thanks Bert On Fri, 03 Dec 2004 22:03:15 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Bert Dawson wrote: I've got a SQL server box that ticks along quite happily at about 15% CPU, but occasionally goes up to around 40% and stays there for anything up to a minute. During these peaks the jrpp.delayMs can start to climb, up to from a few seconds up to hundreds of seconds. I also start getting a few timeouts in the application log. (timeout is se to 35 seconds) Do you get the same behaviour when using a manual checkpoint? I ran a SQL profile trace and spotted that during the peaks there were massive numbers of SQLTransaction entries: over a 2.5 minute period there are ussually about 12 SQLTransactions per second, but this hit a maximm of 16283, which sounds like a lot to me! Are you using client variables? Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: sql server: SQLTransaction
I've got a SQL server box that ticks along quite happily at about 15% CPU, but occasionally goes up to around 40% and stays there for anything up to a minute. During these peaks the jrpp.delayMs can start to climb, up to from a few seconds up to hundreds of seconds. I also start getting a few timeouts in the application log. (timeout is se to 35 seconds) I ran a SQL profile trace and spotted that during the peaks there were massive numbers of SQLTransaction entries: over a 2.5 minute period there are ussually about 12 SQLTransactions per second, but this hit a maximm of 16283, which sounds like a lot to me! If anyone has any ideas what sort of thing could cause just a leap then i'd appreciate any input, or ideas of where to look next. TIA Bert dB server is Win2003 SQLserver 2k, dual xeon3.2ghz, 4gig ram. CFMX6.1 on JRun with updater, Win 2003, dual xeon 3GHz, 3.75 gig ram ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186103 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: sql server: SQLTransaction
I do'n't know anything about the FTS service, and i don't knowingly use it, so i've stopped it. But I doubt that was the cause as there seemed to be no pattern to the 2 minutes @ 30% periods. Also, i suspect its something to do with CF since the loginname reported in profiler is only used in the CF dsn. (i created a new user today specially for CF so that i could eliminate the possibility that someone or something else was causing the trouble.) Any more ideas of things to look for? Cheers Bert On Fri, 03 Dec 2004 12:06:52 -0500, Jerry Johnson [EMAIL PROTECTED] wrote: Just as a guess, maybe a scheduled FTS catalog population? Jerry Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 12/03/04 12:01PM If anyone has any ideas what sort of thing could cause just a leap then i'd appreciate any input, or ideas of where to look next. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186124 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
Rather than putting the error structure into an array, why not use a structure? Then rather than having an array whuch is mostly empty you'll have a structure which only contains errors. so rather than errorsArray[rowNumber] = stError; you could do errorsStructure[rowNumber] = stError; does that makes sense? or did i misunderstand what you're doing? Cheers Bert On Thu, 02 Dec 2004 08:31:16 -0400, Brant Winter [EMAIL PROTECTED] wrote: if there is an error put the errored text in a structure in an array, the array index will be relevant to the current row id of the query i am looping, and there will be a structure of the errors in each array element ( if that makes sense ) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
set stAllMyErrors = StructNew() loop through each row set tmpErrStruct = StructNew() loop through the columns if this column is bad set tmpErrStruct[columnname] = 'there was an error in this column' /if /loop if NOT structIsEmpty(tmpErrStruct) set stAllMyErrors[thisrow] = tmpErrStruct /if /loop Then stAllMyErrors should contain a structure of any errors for each row which had an error, and nothing else. Yes? No? Bert On Thu, 02 Dec 2004 09:15:05 -0400, Brant Winter [EMAIL PROTECTED] wrote: Bert - I think that is I have 24 fields per row, if I have multiple errors per row they wont be able to be written as a group of errors if you know what i mean ? What I want is an array with the row number as the element number, and in that a structure that may have 24 elements in total. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185920 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: HTM vs CFM Pages
Is it possible to use getPageContext().include() to access a file which isn't under the webroot? Bert On Thu, 2 Dec 2004 12:53:07 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: CFINCLUDE will parse any page it includes, which means that it will look through the page for CF content to evaluate. Doesn't matter if it's a plain html page or a CF one, doesn't matter what the extension is. If you are including html content into a CF page, it's better to use: getPageContext().include('./myfile.html') This will run the html page and include it into the calling page without parsing it. i.e. it's an html page, not a CF one. The same code calling a CF page will parse it though. As for cfincludeing a file, it doesn't matter what the extension is. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185979 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: every 10 row
For SQL server you could try: SELECT TOP 10 PERCENT * FROM my_table ORDER BY NEWID() Cheers Bert On Mon, 22 Nov 2004 12:52:20 -0400, Asim Manzur [EMAIL PROTECTED] wrote: I don't need the first 16600. I need to choose randomly. in more easy way every 10th row. (or randomly 16600) SELECT FIRST 16600 * FROM TABLE The situation is I have 166000 records. I need to select 10% of it. i.e. every 10th row. And I need to select 10% and thats it. after that I don't need this field anymore. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185047 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Find first letter
If you need to list them alphabetically then you should just retrieve them alphabetically from the database: SELECT employee_lname FROM employees ORDER BY employee_lname If you're not getting the names from a dB, but have an actual list then you could convert the list to an array (using listToArray()), then sort the array using ArraySort() Or is there another reason why you need the first character? Bert On Mon, 15 Nov 2004 10:03:20 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I need to output a list of names alphabetically via the field employee_lname (last name). What's the code that can check the first letter of the field employee_lname? Thanks. Robert O. HWW ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: When to use cachedwithin
Whether or not the RDBMS caches it CF will still have to go to the dB server and get it. If you use cachedwithin (or cachedafter) then it stays in CF's memory, and no trips to the dB are required, so i'd say cache it. And don't forget you could put it in a persistent scope (either application or server in this case) by using cfquery name=application.myquery etc..., and only running the query when you start up the application. There are pluses and minuses for bother cachedwithin/after and persistent scope caching - it depends on the individual case... Bert On Wed, 03 Nov 2004 10:01:21 -0400, Chris Peters [EMAIL PROTECTED] wrote: I have a web site that uses CFMX 6.1 and MS SQL for data handling. This question is probably because I don't know as much about MS SQL as I should, so bear with me. Is it efficient to use cachedwithin on a query that only returns a row or two in the recordset? Keep in mind that this query is accessed quite a bit. A colleague says that the OS/RDBMS probably caches the small recordset anyway, so I should only use cachedwithin on queries that use complex joins, return large datasets, use unions, etc. Thanks for your help! Chris ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SPAM-BULK: Forcing text to wrap in table cell
On Mon, 1 Nov 2004 16:50:53 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone have a simple solution? The simplest solution is not to worry about it, though without knowing more details i can't say whether this is an option. Who is going to be entering a big string with no whitespace? And who is going to see it? If its someone using a CMS system saying look, i can break you design by doing this stupid thing you might want to reply with and i can break your keyboard by doing this stupid thing Bert ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183103 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: using cfabort in an include....
yes, I checked the docs before i posted, and took it to mean that it executes in the same way as cfabort. But as others have pointed out, in CFMX6.1 cfexit used in an include *doesn't* execute in the same was as cfabort: the included template stops processing but the request continues. It would be nice to know if this is a bug in cfexit or a typo in the docs... Bert On Mon, 25 Oct 2004 14:58:35 -0400, Tangorre, Michael [EMAIL PROTECTED] wrote: Read here: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p26.htm#wp10 98252 In particular, this note If this tag is encountered outside the context of a custom tag, for example in the base page or an included page, it executes in the same way as cfabort. The cfexit tag can help simplify error checking and validation logic in custom tags. Michael T. Tangorre ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182583 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: using cfabort in an include....
In a custom tag you could use cfexit, but since you're in a cfinclude you'll need to put everything in a cfelse: cfif records IS 0 some code... cfelse more code /cfif HTH Bert On Mon, 25 Oct 2004 12:23:45 -0400, Phillip Perry [EMAIL PROTECTED] wrote: I'm using cfinclude. inside the included file that has some code that I want to stop being processed if there is an error. Like this, cfif records IS 0 some code... /cfabort /cfif more code But the problem is that the cfabort not only stops that code in the include file its stopping the code in the calling template. Is there a way to confine the abort to the included file only and leave the template thats calling it alone? ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Truncating database field
An alternative would be to ammend your select statement to do the trimming: cfquery... SELECT LEFT(description, 50) FROM mytable /cfquery This will reduce trafic between the dB and CF, and make the dB do more of the work. This could be significant if you were retrieving huge numbers of enourmous descriptions. Cheers Bert - Original Message - From: John Stanley [EMAIL PROTECTED] Date: Wed, 29 Sep 2004 15:18:55 -0400 Subject: RE: Truncating database field To: CF-Talk [EMAIL PROTECTED] I do something similar for my blog on my homepage http://www.stangocity.com http://www.stangocity.com cfoutput query=hotnews #title#br #left(description,50)#.. /cfoutput -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 3:16 PM To: CF-Talk Subject: Truncating database field Currently I have a hotnews page which calls information from an access database table. In this table when the data is entered it captures the date and time, and I would now like to be able to do two things with this. In another linked page I'd like to display the title and only the first 50 characters of the relevant description field for each item. A google search didn't reveal much. I'm sure this is possible..any ideas? Here's the query... cfquery datasource=#request.dsn# name=hotnews SELECT news_ID,title,description,image,date_added,active FROM hot_news /cfquery TIA MarkH _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
installing MX on win2003 hangs when installing ODBC Services
I'm trying to install MX6.1 on Jrun, on a fresshly rebuilt 2003 server. Everything goes fine, then when i fire up CFadmin it goes through the set up things. RDS password enerted OK, then it goes to ODBC Setup: Installing the ODBC Services. This may take a few minutes. and there it stays... Any ideas/help would be much appreciated as i'm due to go on holiday in about half an hour and i really don't have time for this now. :( TIA Bert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Second Pair Of Eyes
in CF5 arguments is an array: try: IsDefined(FORM.#ARGUMENTS[1]#) I think that will work on MX too. HTH Bert - Original Message - From: Adrian Lynch [EMAIL PROTECTED] Date: Tue, 31 Aug 2004 16:22:29 +0100 Subject: Second Pair Of Eyes To: CF-Talk [EMAIL PROTECTED] Can anyone see something wrong with this, working on CFMX but failing on CF5 cfscript function formValue(formName, defaultValue) { if ( IsDefined(FORM.#ARGUMENTS.formName#) ) { return HTMLEditFormat(FORM[#ARGUMENTS.formName#]); } else { return HTMLEditFormat(ARGUMENTS.defaultValue); } } /cfscript Error resolving parameter ARGUMENTS.FORMNAME Is this ok on CF5..? IsDefined(FORM.#ARGUMENTS.formName#) What about... FORM[#ARGUMENTS.formName#] Thanks, just need someone else to look at it as it seems ok to me. Ade [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Looping through lines in a file
Treat it as a list, but with line breaks or carriage returns as delimiter. I'd convert the whole lot to an array, where each line was an element, then loop over each element as a list - seems neatest way to do it in this particular case. cfscript myStuff = oneline,qwe anotherline,wer andanother,tee; delim = chr(13)chr(10); aStuff = ListToArray(myStuff, delim); for (i=1; i LTE ArrayLen(aStuff); i=i+1) { for (j=1; j LTE ListLen(aStuff[i]); j=j+1) { writeoutput(ListGetAt(aStuff[i], j) 'br'); } writeoutput('hr'); } /cfscript Cheers Bert - Original Message - From: Mark Drew [EMAIL PROTECTED] Date: Fri, 27 Aug 2004 15:59:42 +0200 Subject: Looping through lines in a file To: CF-Talk [EMAIL PROTECTED] How would I loop through each of the rows below in cfscript? I am brain dead this afternoon something, url something else, else somethingnice, nice I want to loop through each row and then will split it as a list any ideas? -- Mark Drew mailto:[EMAIL PROTECTED] blog:http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Top-level variables?
Depending on your application and environment this dump could get pretty huge, specially if you start dumping application, request and server scopes. You might be in danger of information overload. I would have thought you'd just want the user input scopes: form, url, cookie, and probably client and session should give you enough to reproduce most errors. Bert BTW after a cfquery tag there is variables[cfquery.executiontime] - checked the livedocs and its in there, but i never new about it till now... - Original Message - From: Damien McKenna [EMAIL PROTECTED] Date: Fri, 27 Aug 2004 11:26:34 -0400 Subject: Re: Top-level variables? To: CF-Talk [EMAIL PROTECTED] On Aug 27, 2004, at 10:40 AM, Mosh Teitelbaum wrote: Depending on your application you may also want to include URL, SESSION, CLIENT, SERVER, COOKIE, etc. Awesome, thank you! -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Unknown tag: admin:l10n
This is covered as issue 56971 on ColdFusion MX 6.1 Updater release notes: http://www.macromedia.com/support/documentation/en/coldfusion/mx61updater/releasenotes_cfmx61_updater.html#knownissues [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 Updater Now Available
I'm getting the same thing. I installed cfadmin to d:\www when i first installed Jrun/CFMX, and did the same when i ran the updater. Judging by the date stamps it looks likethe updater has added/ammended 5 .cfm files, both in the D:\www\CFIDE\administrator\ location, and the default D:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\CFIDE\administrator\ I don't have access to any other servers right now so i can't see what ight have changed till tomorrow. Bert - Original Message - From: Barney Boisvert [EMAIL PROTECTED] Date: Thu, 26 Aug 2004 13:33:07 -0700 Subject: Re: CFMX 6.1 Updater Now Available To: CF-Talk [EMAIL PROTECTED] Check the install instructions.You probably copied the CFADMIN to a different location.Replace it with the newly updated on at %cfmxroot%/wwwroot/CFIDE/administrator and you should be good to go, as per the instructions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 Updater Now Available
I deleted the files that the installer added to the default directory (D:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\CFIDE\administrator\) and cfadmin now works fine where i installed and updated it (D:\www\CFIDE\administrator\). Thanks Collin Bert - Original Message - From: Collin Tobin [EMAIL PROTECTED] Date: Thu, 26 Aug 2004 16:29:39 -0400 Subject: RE: CFMX 6.1 Updater Now Available To: CF-Talk [EMAIL PROTECTED] For some reason you have a CFIDE dir in your cf_root and in your webroot. Make sure the two have the same files, or rename the CFIDE dir in your cf_root. Collin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: MX components accessing callerspace?
what about: request.x = CreateObject(component, x); request.x.caller = variables; that might work, but looks a bit, er, like you shouldn't do it. Bert - Original Message - From: erick calder [EMAIL PROTECTED] Date: Thu, 26 Aug 2004 18:29:50 -0400 Subject: MX components accessing callerspace? To: CF-Talk [EMAIL PROTECTED] MX components don't have access to the caller space so typically one has to do something like: x = CreateObject(component, x); x.caller = caller; so that the component can set variables in the caller space like this: this.caller[whatever] = true; This all works fine from a cutom tag, however x = CreateObject(component, x); x.caller = variables; placed in the main page causes a stack overflow in MX.The reason is that however, the problem with this approach is that /variables/ contains /x/ so the assignment /x.caller = variables/ creates a circular reference. is there a better way to handle this?I need to be able to modify variables on the main page from a component. - e [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV to Query
Not to forget querySim: there's the original tag which you can get from http://www.halhelms.com/index.cfm?fuseaction=code.detail or the UDF version from http://www.cflib.org/udf.cfm?ID=255 Both do pretty much the same thing - take some formatted text and return a recordset. As to which to use, its much of a muchness - I think the UDF is slightly faster until the amount of data being passed in reaches a certain size, after which performance deteriorates faster than the tag, but I haven't looked at either for years, so that would have been testing on CF5 Cheers Bert From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 25 August 2004 17:14 To: CF-Talk Subject: Re: CSV to Query Here's a second vote for ostermiller's CSV parser.It's java, so it requires a touch of Java knowlesge, but it's very easy to use, as Marc's demo illustrates, and quite fast. cheers, barneyb On Wed, 25 Aug 2004 10:20:29 -0400, Marc Campeau [EMAIL PROTECTED] wrote: Anybody have a UDF for this? I need it sharpish, I can write it myself but if someone else has done this.. whooho! I use a Java library (ExcelCSVParser) from www.Ostermiller.com. You can find some other great utils there too. This is the code I use to parse a CSV file... it creates an array not a query though. !--- Convert CVS file to matrix(java.lang.String[][]) for easier manipulation --- cflock timeout=10 throwontimeout=Yes name=ImportTasks type=EXCLUSIVE cfscript f = createObject( java, java.io.FileInputStream ); f.init(#REQUEST.DOCUMENT_DIRECTORY#\#File.ServerFile#); parser = createObject( java, com.Ostermiller.util.ExcelCSVParser ); parser.init( f ); csvArr = parser.getAllValues(); parser.close(); f.close(); /cfscript /cflock -- -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Server Rebuild Questions
1. I've got a feeling that one version of the installer assumed your temp directory was c:\Temp, and install fails if you've moved it to d:\temp or something, so you might want to check that. 2. If the dev server is running then try doing a DTS transfer - open enterprise manager, right click on databases and choose import. Otherwise i'd go for restoring from backups - you might be able to reattach the data files, but its not something i've ever tried. Similar lack of experiance with migrating accounts and stuff-sorry. HTH Bert On Wed, 11 Aug 2004 08:25:22 -0400, Burns, John D [EMAIL PROTECTED] wrote: Our main dev server went nuts yesterday and I've been tasked to rebuild it. I'm trying to build another server just like the original as fast as possible so all of our developers aren't dead in the water without the dev server.I've run into a few questions/problems that I'd like to see if the list can help with. 1. Where can I download a 6.1 installer so I can install straight to 6.1 without installing from the CD first and then upgrading?I tried downloading the one on the 6.1 upgrade page but when I try to run it it says Please extract the installer to a different directory and I've tried moving it to all kinds of directories with no luck, so I'm guessing that the installer wants to be extracted to the directory where CFMX 6.0 already exists?This is a brand new Dell with Windows 2003 Server (I already know the gotchas for installing 6.1 on Win2k3 with IIS). 2. Our dev server also is running an instance of SQL server with approximately 15 databases inside.What's the best way to move all of the databases (and, if possible, the SQL settings and logins and security) from one server to the next.I wasn't sure if I could just copy the data files over or if I needed to run backups on each database to get those files.Any tips or tricks would be extremely helpful. 3. We also have an instance of MySQL installed, which I'm not 100% sure needs to be on the new server, but if it does, any tips or tricks for moving that over? Thanks in advance for the help! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
i don't want cookie.jsessionid...
On my local machine CF sets the cookie.jsessionid, but it doesn't on the test or live boxes. The first time i request a page the cookie doesn't show up in the debug output, but i can read it using _javascript_. On subsequent requests it does appear in cf debug output. I have the Use J2EE session variables checkbox unchecked. Is there anything else i need to do? Version: 6,1,0,63958 Edition Enterprise (DevNet) Operating System: Windows XP OS Version: 5.1 Cheers Bert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfqueryparam best practices
But if the query relies on data from the browser then using a persistent scope will be a bit of a drag since you'd have to provide some way to identify the correct recordset depending on the values of the parameters passed - presumably by dynamically naming the query depending on the parameters being passed, and then copying/pointing that to a common name, or am I missing something? An alternative is to cache a query of query: cfparam name=url.id default=1 cfset somethingunique = 'the ID is #url.id#' cftry cfquery name=cachedQuery dbtype=query cachedwithin=#CreateTimeSpan(0,0,0,10)# SELECT * FROM realquery WHERE '#somethingunique#' = '#somethingunique#' /cfquery cfcatch cfquery datasource=#request.dsn# name=realquery SELECT cfqueryparam value=#url.id# cfsqltype=CF_SQL_INTEGER , #now()# /cfquery cfquery name=cachedQuery dbtype=query cachedwithin=#CreateTimeSpan(0,0,0,0)# SELECT * FROM realquery WHERE '#somethingunique#' = '#somethingunique#' /cfquery /cfcatch /cftry cfdump var=#cachedQuery# Cheers Bert From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 31 July 2004 19:26 To: CF-Talk Subject: RE: cfqueryparam best practices Caching queries will not work using cfqueryparam. No, but if your choice is to either cache a query or use CFQUERYPARAM, and that query accepts data directly from the browser (Form, URL, Cookie variables), I'd recommend you use CFQUERYPARAM. As others have pointed out, you can cache queries in the Application, Session and Server scopes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with SQL Server and CF5
It works on one machine running the same version of CF, or is one on CF5 and one CFMX? If i were you i'd create a template with just the cfdirectory, cfquery QofQ, and a cfdump and take it from there, twaeking bits till you get to the root cause. eg : Replace the cfdirectory with a dummy hand made recordset using queryNew() etc - does the QofQ still break? Try SELECT *... in the QofQ? Does the error go away if you replace the QofQ with a dummy made query (using QueryNew(), QueryAddRow() etc)? I suppose this highlights the problems f developing on one version and deploying on another... Bert From: Mickael [mailto:[EMAIL PROTECTED] Sent: 19 July 2004 20:30 To: CF-Talk Subject: Re: Problem with SQL Server and CF5 Gave me the same error.Strange it works on my machine. - Original Message - From: Bert Dawson To: CF-Talk Sent: Monday, July 19, 2004 2:10 PM Subject: Re: Problem with SQL Server and CF5 just a guess as i haven't got access to a CF5 box this second, but try changing it to: cfquery name=qry_MakeThumbnailList dbtype=query SELECT[name] AS filename FROM imagelist /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Trusted cache and updated templates
One way which might assist automating this would be to use the RunTimeService of the CF serviceFactory: 1. Use cfdirectory to get list of updated templates. 2. factory.runtimeservice.SetTrustedCache(false); 3. loop though updated templates, including each one inside a cftry/catch to ignore errors 4. factory.runtimeservice.SetTrustedCache(true); I just tested this and seems to work OK. Cheers Bert ps it would be nice to have a tag to flush the template cache like cfobjectcache does for queries... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Problem with SQL Server and CF5
What does your Query of a Query say? There are a number of subtle differences in the way it works in CFMX vs. CF5 Bert From: Mickael [mailto:[EMAIL PROTECTED] Sent: 19 July 2004 17:15 To: CF-Talk Subject: Problem with SQL Server and CF5 Hello All, I am relatively new to MSSQL so forgive me if the question is rather junior.I have a few pages that make up an image gallery.I designed the pages using CFMX and MSSQL and they worked fine on my machine.I have uploaded them to the server and I am getting the following error PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The code line is not exact but it is point around a line of code where I am doing a Query of a Query on CF5. I have never seen this error before could someone point me in the right direction with this one. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with SQL Server and CF5
just a guess as i haven't got access to a CF5 box this second, but try changing it to: cfquery name=qry_MakeThumbnailList dbtype=query SELECT[name] AS filename FROM imagelist /cfquery It might not like the name column (i would expect MX to complain about it but it doesn't seem to mind either way...) Cheers Bert From: Mickael [mailto:[EMAIL PROTECTED] Sent: 19 July 2004 19:02 To: CF-Talk Subject: Re: Problem with SQL Server and CF5 Here is what the lines around the error say. cfdirectory action="" directory=#thisDirectory##qry_GetDirectoryNames.GalleryDirectory# name=imagelist filter=*.jpg cfquery name=qry_MakeThumbnailList dbtype=query Select name from imagelist /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm, CFInput, etc not xhtml compatible!
I think the simplest, quickest and dirtiest solution would be to write a tag which you wrap round all calls to CFFORM, then use the tag to parse thistag.generatedcontent, lowercasing this, and end tagging that - should be fairly simple to write... Global search and replace cfform with cf_yourTagcfform And /cfform with /cfform/cf_yourTag So, now you have a quick frix if you need to be xmtml in a hurry (i.e. if/when the directive comes down), and if you have time you can look into qForms, or hang around waiting for Blackstone. Cheers Bert From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 15:27 To: CF-Talk Subject: RE: CFForm, CFInput, etc not xhtml compatible! I was just trying to make some of my pages xhtml 1.0 transitional compatible and when I tested through the W3C testing page I noticed that cfform and the others capitalize the tags and don't self close them. Anyone else notice this? I would hate to have to recode all of my pages when the directive comes down to be xhtml compatible (I know it's coming just don't know when). Yes, this is a known issue with the current version of CFMX. However, based on what has been demonstrated about Blackstone at user groups, I strongly suspect this will be resolved (and then some) in the upcoming version of CF. Beyond that, though, I'd recommend that you use something like qForms, or build your own form validation mechanism, rather than using CFFORM. While it's very easy to use CFFORM, it's a bit harder to customize it to your liking. I strongly recommend you look at qForms. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Time Tracking
If you are using J2EE sessions then you can listen out for when the J2EE sessions expires. There was an article about this in the May 2004 issue of CFDJ (http://www.sys-con.com/magazine/?issueid=490), and also a utility in the MM DevNet Resousre Kit 7 called session expiration alarm, either of which will might do what you're after. HTH Bert From: Britney Spears [mailto:[EMAIL PROTECTED] Sent: 23 June 2004 12:52 To: CF-Talk Subject: re: Time Tracking Hello, I have an application that users log into using Windows authentication. I would like to track when a user logs and store that information when they log out so I can see how long they have been online using the application. Is there a add-onor code out there that I could plug into my application. Is this easy to do? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL query style (WAS: SQL search query)
Except that a persistent scope doesn't automatically handle the cachedafter/within type stuff, and if the recordset depends on url.id for example then you'll have to incorporate that fact into how/where you store the persistent variable. One way to use queryparam AND cachedwithin/after would be to use a Query of Query with catch/try: If the QofQ is cached then everything is fine. If there is no cache (ie either doesn't exist or doesn't match the cachedwithin/after attribute) then the error is cfcaught, dB is hit, and this recordset is cached in the QofQ. cftry cfquery name=myQ dbtype=query cachedwithin=...SELECT * FROM myQ WHERE '#hash(url.id)# = '#hash(url.id)#/cfquery cfcatch cfquery name=myQ datasource=#request.dsn# SELECT * FROM myTable WHERE ID = cfqueryparam value=#url.id# cfsqltype=CF_SQL_INTEGER /cfquery cfquery name=myQ dbtype=query cachedwithin=...SELECT * FROM myQ WHERE '#hash(url.id)#' = '#hash(url.id)#/cfquery /cfcatch /cftry I've sucessfully used this technique to cache results from verity, to allow paging through large recordsets without hitting verity again, and recordsets returned from CFDIRECTORY, and I don't see why it wouldn't work for normal SQL statements. In practice though, for the above example, I would just validate #url.id# up to the gills to make sure it was an integer, then run the query without cfqueryparam. Cheers Bert From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: 16 June 2004 13:47 To: CF-Talk Subject: Re: SQL query style (WAS: SQL search query) On Wed, 16 Jun 2004 14:27:24 +0200, Pascal Peters wrote: You should ALWAYS use CFQUERYPARM on EVERY query, no matter what I agree in theory, but you can't use it with cached queries. Store the queries in a persistant scope, such as Application - it's simple enough and gives you just as much control [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: saving files in homesite.... slooooow!
I had similar problem a few years ago - studio slow to save files on network, but other apps fine. I think i solved it by fiddling around in the registry and clearing up references to invalid drive mappings in the Studio bit. If it wasn't in the registry then it might have been in some Studio config file, but i'm pretty sure i was the registry. Sorry i can't be more specific - as i say it was a couple of years ago, but the symptoms sound similar. HTH Bert From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 07 June 2004 03:34 To: CF-Talk Subject: RE: saving files in homesite slow! wasn't on :( I guess its just that saving to a network drive is slow... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]