ColdFusion memory leaks

2010-05-14 Thread Qing Xia
to periodically recycle JVM memory once it reaches a threshold, but I am a little too concerned to use it--it is not really like fixing the problem. Any idea will be most appreciated! Thanks, Qing Xia ~| Order the Adobe Coldfusion

Re: Scheduled task isn't running the item in the url

2010-04-21 Thread Qing Xia
Logging is your friend. :-) Create a log file for your scheduled task. Does this page sit in an application that requires authentication? If so, make sure to specify the username and password. On Wed, Apr 21, 2010 at 10:48 AM, daniel kessler dani...@umd.edu wrote: I have the following task

Re: Decrypt CF scheduled job password?

2010-04-05 Thread Qing Xia
code so enter at your own legal risk. :) ~Brad Original Message Subject: Decrypt CF scheduled job password? From: Qing Xia txiasum...@gmail.com Date: Tue, March 30, 2010 8:09 pm To: cf-talk cf-talk@houseoffusion.com Hello folks, I was just wondering, does anyone happen

ColdFusion dateDiff() function?

2010-04-05 Thread Qing Xia
Okay, I am probably splitting hairs over here, but I ran into an icky situation with the native ColdFusion function DateDiff() today and just thought I'd check whether anyone else has experienced this before. Basically, I wrote a CF Scheduled Task that is supposed to go to a directory and delete

Re: Best way to return generated html from cfc

2010-04-05 Thread Qing Xia
I have a cfc that will generate some html to be displayed inline. I was just going to reuturn a string rather than have it output directly. Is this the proper way to do that? I've been struggling to draw a clear line between the usage of CFCs and Custom Tags, but one general trend I see

Re: ColdFusion dateDiff() function?

2010-04-05 Thread Qing Xia
would depend on what you are trying to achieve, which I could only guess at. -Mike Chabot On Mon, Apr 5, 2010 at 10:05 PM, Qing Xia txiasum...@gmail.com wrote: Okay, I am probably splitting hairs over here, but I ran into an icky situation with the native ColdFusion function DateDiff

Decrypt CF scheduled job password?

2010-03-30 Thread Qing Xia
-cron.xml# var name=*password*string (/:/!LJ*'XN@char code=*0a* //string/var Thanks in advance for your thoughts! Cheers, Qing Xia - file:///C:/ColdFusion9/lib/neo-cron.xml# ~| Want to reach the ColdFusion community

Re: jquery ajax tabs cfinclude

2010-02-17 Thread Qing Xia
Actually I took out all the complication and put the cfincluded files in the same directory as the calling page dispAppointments.cfm. It still gives the same issue. Hmm... peculiar. What happens if your put the following code directly into your jQuery tabs? cfset variables.thisPath =

Re: jquery ajax tabs cfinclude

2010-02-17 Thread Qing Xia
I do not believe you could include query strings after the template name when you are doing cfinclude. You can use CFlocation url= instead, or you can do cfmodule and pass in the values in ATTRIBUTES, like you would with a custom tag. On Wed, Feb 17, 2010 at 1:01 PM, Sachin Mohan

Re: jquery ajax tabs cfinclude

2010-02-17 Thread Qing Xia
Apologies, I found what I was doing wrong : cfinclude template=.. cannot have a querystring ?mln= it just needs to be name of the cfm file. Pretty basic. ah, sorry, just saw this note. :-) ~| Want to reach the

Re: onSessionEnd not firing

2010-02-17 Thread Qing Xia
Why are the values for cookies the same as before? I thought expired cookies don't get sent by the browser anymore. But maybe I am mistaken and the CF server checks if cookies are expired? If I remember correctly, the jSessionID/CFID/CFToken values are associated with the browser instance,

Re: Combing Multiple Queries Into One Table

2010-02-10 Thread Qing Xia
Ok, I have multiple queries. I have to have multiple queries to massage the data differently for some of the columns. I want to combine all those queries into one table or cfgrid. How do I do that? Check out the Query...() functions such as QueryNew(), QueryAddColumn() and etc. The other

Re: IDE for coldfusion 9

2010-02-09 Thread Qing Xia
Can anyone tell me if there is a new CFEclipse plugin for Coldfusion 9? I am using CFEclipse plugin version 1.3.4.200906240705, which seems to be the latest version. I noticed certain new CF9 tags, such as CFIMAP, are not recognized.

Re: IDE for coldfusion 9

2010-02-09 Thread Qing Xia
You have to specify which version of CF you're using on your project, and if you upgraded, you'll still be set on CF8. Not sure what the default is, but it could well be CF8 as well, since CF9 is still lower adoption. Oh yeah, you are right Barney. My dictionary view is set to CF8.

Re: IDE for coldfusion 9

2010-02-09 Thread Qing Xia
Well, well, the lesson is never to assume. My version of CFEclipse was *NOT* the latest. The latest is 1.3.5.201002010103. Once I upgraded my CFEclilpse plugin, I am defaulted to the CF9 dictionary. BTW, the dropdown at the top of Dictionary View lets you select which version of the dictionary

Re: IDE for coldfusion 9

2010-02-09 Thread Qing Xia
The default is in the global prefs (Windows Preferences), and each project has it's own setting the project properties. Neat, thanks! One more reason to like CFEclipse! [?] ~| Want to reach the ColdFusion community with

Re: CFPop with specific folders?

2010-02-07 Thread Qing Xia
:48 AM, Aaron Neff w...@itisdesign.com wrote: Hi Qing Xia, If you wish to use cfimap w/ Gmail, here are a couple of things you may want to watch out for: - When polling Gmail, the item counts returned by cfimap may not match the same in Gmail (Gmail bug). - When retrieving emails from

Re: CFPop with specific folders?

2010-02-07 Thread Qing Xia
- When polling Gmail, the item counts returned by cfimap may not match the same in Gmail (Gmail bug). You are right on this one, Aaron. Gmail groups messages by conversation, which is really just the email subject lines. For example, I've got this Gmail folder that has 8 conversations but 15

CFPop with specific folders?

2010-02-06 Thread Qing Xia
about doing that? I know this can be done to emails sitting on an exchange server through the CFExchangeEmail tag but I can't think of a way to do that with a POP email account. Any thought is welcome and most appreciated! Thanks, Qing Xia

Re: IE8 is killing my website

2010-02-02 Thread Qing Xia
In theory, you could use the native CF URLSessionFormat() function to conditionally pass the CFID and CFToken values if the user's browser either wouldn't or couldn't accept cookies. This idea is explained in some detail in Chapter 20 of CF8 WACK book I. I have never tested this theory

CF8 Advanced Status?

2010-01-31 Thread Qing Xia
Does anyone know what the % score needed to get the Advanced Certified Status in CF8 is? I went searching for it (high and low!) but no dice. Hmm, maybe the Pentagon needs to hire Adobe to guard its papers. ~| Want to reach

Re: CF8 Advanced Status?

2010-01-31 Thread Qing Xia
Yeah, for CF7 it was 85% and 80% for CF6... but now I can't find what it is for CF8. On Sun, Jan 31, 2010 at 10:55 PM, lists li...@commadelimited.com wrote: In the past it's been 85% I believe. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Sunday, January

Re: cferror / cfmail issue

2010-01-28 Thread Qing Xia
What CF version were you on before this recent upgrade to CF9? Try changing the TYPE attribute in the CFError tag to type=exception, and see what happens. On Thu, Jan 28, 2010 at 2:41 PM, Tim Do t...@wng.com wrote: We just upgraded to cf9 and my error handling is no longer working the way

Re: cferror / cfmail issue

2010-01-28 Thread Qing Xia
the error info and doesn't send. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Thursday, January 28, 2010 11:53 AM To: cf-talk Subject: Re: cferror / cfmail issue What CF version were you on before this recent upgrade to CF9? Try changing the TYPE attribute

Re: cferror / cfmail issue

2010-01-28 Thread Qing Xia
around it, I get nothing but the text from the errorPage. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Thursday, January 28, 2010 12:21 PM To: cf-talk Subject: Re: cferror / cfmail issue When type=request, the error template is not supposed to contain any CFML

Re: Drop down subselect

2010-01-27 Thread Qing Xia
Without going into coding detail, here is (my) theory: assuming you are on CF8, you can easily use cfselect data binding to make the two selects related. Then you can use jQuery (or plain old JavaScript) to toggle the 2nd select so that it is only visible when something from the first select is

Re: (ot) Adobe error messages

2010-01-27 Thread Qing Xia
) ~Brad Original Message Subject: Re: (ot) Adobe error messages From: Qing Xia txiasum...@gmail.com Date: Tue, January 26, 2010 4:11 pm To: cf-talk cf-talk@houseoffusion.com What NULL ? We're talking about the log file, not the tag.Regardless, log it in Adobe's bug

Re: (ot) Adobe error messages

2010-01-26 Thread Qing Xia
25 Jan 2010, Qing Xia wrote: I wonder how long it is going to take Adobe to replace all the [Macromedia] in CF error messages to [Adobe]. Completely irrelevant maybe, but nice to have so new CF people don't have to wonder. You could only do that in a major release (like CF10) because you

Re: (ot) Adobe error messages

2010-01-26 Thread Qing Xia
What NULL ? We're talking about the log file, not the tag.Regardless, log it in Adobe's bug tracker and then post back with the number so other people can vote for it. I did submit it to the wish list at https://www.adobe.com/cfusion/mmform/index.cfm?name=wishform, but I don't believe I

Re: Determine Site-Wide Error Handler

2010-01-26 Thread Qing Xia
Assuming the language in the error template are not dynamically generated by pulling some database record, could you do a global search among your CF templates for the language used in the error template? Like, search for the phrase We are awfully sorry but you've hit an error on Orange Whip

Re: Email Format question

2010-01-25 Thread Qing Xia
Hmm... have you tried using CFSaveContent? On Mon, Jan 25, 2010 at 10:58 AM, Rob Voyle robvo...@voyle.com wrote: Hi folks I thought I had this fixed butnow I am baffled. I have an cf email that lists a series of values such as '#title# '#prog# '#programvalue# which results in the

Re: language for mailer

2010-01-25 Thread Qing Xia
I'd be the first to admit that I am a die-hard CF fan, but if you want an off-the-shelf software solution, check out Campaign Enterprise: http://www.arialsoftware.com/enterprise.htm http://www.arialsoftware.com/enterprise.htmIt gives average users the ability to create simple HTML email

(ot) Adobe error messages

2010-01-25 Thread Qing Xia
I wonder how long it is going to take Adobe to replace all the [Macromedia] in CF error messages to [Adobe]. Completely irrelevant maybe, but nice to have so new CF people don't have to wonder. ~| Want to reach the ColdFusion

Re: (ot) Adobe error messages

2010-01-25 Thread Qing Xia
Kind of like tacit advertising if it can be fixed... But then on the other hand, I agree this wouldn't be on the top of my wish list for Adobe. I'd rather they fix the problem of not checking NULL=#YesNoFormat(NOT isDefined('form.someFromField'))# in the CFQueryParam tag first. On Mon, Jan 25,

Re: Why .Net is on its last legs

2010-01-22 Thread Qing Xia
I can admit, I have some really sloppy code from my first years as a coder. So did I--like you said, I imagine most did with their first applications. And those were the ones that mattered most. They don't care about frameworks, OO, languages, wire frames, documentation or preferences,

Re: Why i fear ColdFusion is on its last legs

2010-01-21 Thread Qing Xia
Now, here's the ultimate test: let's post a ASP.NET is dying thread to their mailing list and see if the response is as strong. [?] On Thu, Jan 21, 2010 at 4:36 PM, Dave Watts dwa...@figleaf.com wrote: Is that so strange?India has different problems that the rest of the world does

Re: Why .Net is on its last legs

2010-01-21 Thread Qing Xia
I second that. I took a 5-month certificate program for ASP.NET with C# last Spring at a prestigious university in the DC metropolitan area. (Not naming names here) The teacher is an extremely well qualified individual with over half a dozen MS certificates, including one in ASP.NET web

Re: Article feed for website

2010-01-20 Thread Qing Xia
Do you mean like an RSS feed...? On Wed, Jan 20, 2010 at 7:05 PM, Mike Little m...@nzsolutions.co.nz wrote: hi guys, my client wishes to make available code (javascript??) that website visitors can embed in their own websites/blogs to display the most recent articles. this is the first

Re: More Efficient (Faster) Method

2010-01-17 Thread Qing Xia
*Here are my two cents:* *On the subject of Premature Optimization: I agree with Dave that as developers, sometimes our tendency to create clever code could result in cryptic code, albeit short. That said, I also believe there are definite lines between decent and sloppy code. For example, I

Re: More Efficient (Faster) Method

2010-01-15 Thread Qing Xia
Check out this UDF: http://www.cflib.org/udf/BusinessDaysAdd http://www.cflib.org/udf/BusinessDaysAddAlso, if I may venture to suggest: 1. You don't need sharp signs inside ColdFusion tags 2. It would be nice to use cfqueryparam to pass in those variables to your query--faster and more

jQuery tableSorter tab plugins

2010-01-14 Thread Qing Xia
that before. If so, I would be most grateful for any suggestions! [?] Cheers, Qing Xia ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http

Re: jQuery tableSorter tab plugins

2010-01-14 Thread Qing Xia
/javascript //jQuery table sorter function $(document).ready(function() {$(#cfoutput#attributes.tableName#/cfoutput).tablesorter();}); /script On Thu, Jan 14, 2010 at 4:37 PM, Qing Xia txiasum...@gmail.com wrote: Hello all, I am having a dilemma regarding two jQuery plugins: the tableSorter and tab

Re: reorder a query

2010-01-12 Thread Qing Xia
Could it be that one (or more) of the rows in column reOrder is of type Double while the other rows are all of type string? I am guessing maybe you want a numeric value in this row but one of more rows got empty. On Tue, Jan 12, 2010 at 1:34 PM, Chad Gray cg...@careyweb.com wrote: While I am

Re: Problem deleting structure in an array

2010-01-12 Thread Qing Xia
You are looping over the array sequentially from 1 but are you sure your array key values are sequential from 1 as well? Your loop goes 1, 2, 3, which means it will expect to find session.shoppingCart[1].itemid, session.shoppingCart[2].itemid and session.shoppingCart[3].itemid. But are you sure

Re: Problem deleting structure in an array

2010-01-12 Thread Qing Xia
at 4:51 PM, Qing Xia txiasum...@gmail.com wrote: You are looping over the array sequentially from 1 but are you sure your array key values are sequential from 1 as well? Your loop goes 1, 2, 3, which means it will expect to find session.shoppingCart[1].itemid, session.shoppingCart[2].itemid

Re: Problem deleting structure in an array

2010-01-12 Thread Qing Xia
So maybe you can figure out which array index values are NOT selected for deletion, clear out the original array and insert the un-deleted array elements back in there. On Tue, Jan 12, 2010 at 5:10 PM, Qing Xia txiasum...@gmail.com wrote: Nope, on 2nd thought, Chat was right. If your array

Re: Problem deleting structure in an array

2010-01-12 Thread Qing Xia
Yep, Leigh's solution is much simpler. [?] On Tue, Jan 12, 2010 at 9:47 PM, jrmuniz jrmu...@sfsailing.com wrote: Leigh: My apologies. When I read your post I stopped at the word Yes not realizing there was more. What you are saying makes perfect sense. I'll give that a try. Jaime See

Re: empty strings

2010-01-11 Thread Qing Xia
I didn't test it against an Oracle DB, but the following works against a SQL Server DB. Be sure to adjust the cfsqltype according to the data type of your form field. cfqueryparam value=#form.myField# cfsqltype=cf_sql_varchar null=#YesNoFormat(NOT LEN(TRIM(form.myField)))# Hope this helps! On

Re: jquery javascript coldfusion.navigate cflayout cfdiv

2010-01-08 Thread Qing Xia
that Live() was needed in this case. I never even heard of Live() cause I don't use jQuery that much, I should start. But it works now, thanks All. On Thu, Jan 7, 2010 at 1:39 PM, Qing Xia txiasum...@gmail.com wrote: I am a jQuery newbie so I definitely feel your pain. One method

Re: form.FieldNames

2010-01-07 Thread Qing Xia
Additionally, if your form consists of radio buttons which only exist if users choose something, then your fieldnames list can be out of order when those radio button fields go missing. On Thu, Jan 7, 2010 at 11:23 AM, Barney Boisvert bboisv...@gmail.comwrote: I would expect the order to be

Re: jquery javascript coldfusion.navigate cflayout cfdiv

2010-01-07 Thread Qing Xia
I am a jQuery newbie so I definitely feel your pain. One method that has worked for me is to the bottom-up approach. Start with a bare-bone simple form with just the jQuery stuff and then add the other stuff you want in, one by one. Make sure to also strip down your CSS file to just those

Re: Query/Report Builder

2010-01-04 Thread Qing Xia
We have both Crystal Reports and SQL Server 2008 Reporting Services at work. While they are not super customized, they do serve the purpose of allowing users to run some rudimentary reports. However, neither is ColdFusion-based, and it sounds like that is what you are looking for. On Sun, Jan

Re: ColdFusion 9 Install Problems

2009-12-31 Thread Qing Xia
If you wouldn't mind sharing, I was just wondering, what was the solution that you found to overcome the issue of copying over settings from CF8 to CF9? On Thu, Dec 31, 2009 at 2:41 AM, Michael Grove gro...@idzyns.com wrote: we recently purchased and installed CF9 on a windows 2003 server

Re: Searching a Date Range

2009-12-22 Thread Qing Xia
Another approach is to use the dateDiff() SQL function. That way, you can determine the level of precision at which you are comparing. For example, run the following scripts against any SQL database. You will see that the result is quite different. If you only want to know two date values are

Re: Searching a Date Range

2009-12-22 Thread Qing Xia
True, if at least one side of the date comparison is a constant then it is better to structure the comparison in such a way that functions can be avoided. On Tue, Dec 22, 2009 at 3:56 PM, Leigh cfsearch...@yahoo.com wrote: SET @dateVal_2 = '2009-12-22 23:59:59.000' You will see that the

Re: my cfqueryparam grievance

2009-05-14 Thread Qing Xia
Hello folks: Thanks to all who replied--I really appreciate your thoughts and insights on the issue. Here is the latest development on my fascinating CFQueryparam issue: 1. I have gone through the error messages on this issue, and none of them has bad data coming in. Which is to say, all the

Re: my cfqueryparam grievance

2009-05-14 Thread Qing Xia
LOL I am glad that you asked about the VARCHAR auto increment, Dave. It is an interesting story (everybody grab some hot cocoa, please): Well, (most) iMIS tables have a VARCHAR identity field which need to auto-increment like an integer. To achieve that, there is table which stores the next ID

Re: my cfqueryparam grievance

2009-05-14 Thread Qing Xia
I wish--but the value is a ID value passed back in a query recordset and there is no way how users can manually pass it in. On Thu, May 14, 2009 at 3:39 PM, Adrian Lynch cont...@adrianlynch.co.ukwrote: The user changed it maybe? Adrian -Original Message- From: Qing Xia

Re: my cfqueryparam grievance

2009-05-14 Thread Qing Xia
you said it was a cookie value? -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:43 To: cf-talk Subject: Re: my cfqueryparam grievance I wish--but the value is a ID value passed back in a query recordset and there is no way how users

my cfqueryparam grievance

2009-05-12 Thread Qing Xia
Hello folks, I had a pretty strange experience with CFQueryParam today. Basically, I have an innocent-looking query: cfquery datasource=#application.myDB# name=qGetUser *SELECT* username, password *FROM* someTable *WHERE* someID = cfqueryparam cfsqltype=CF_SQL_INTEGER value= #cookie.theID#

cftextarea with richtext

2009-02-04 Thread Qing Xia
Hello folks: I am having a strange issue with CFTextarea. So, basically, I've got this CFtextarea in my cfform/cfform. And then, my submit button is an image button which calls a JavaScript function to check a bunch of form fields have been filled out. However, the simple JavaScript function

CF Scheduled Jobs monitoring

2008-09-29 Thread Qing Xia
, then this CF scheduled job monitor itself will just fail along with all other CF scheduled jobs. So the monitoring should (ideally) be done by an external process. Any suggestion will be most appreciated! Thanks a lot in advance, Qing Xia

Re: A Little Confusion on CFQUERYPARAM and Nulls...

2008-09-12 Thread Qing Xia
One way of overcoming this is to have a default constraint on your DB column. That way, if a NULL is passed in, then it automagically defaults to N (or whatever you want). If you always want it to default to the same value, then this can help keep your CF code nice and clean. On Fri, Sep 12,

Re: A Little Confusion on CFQUERYPARAM and Nulls...

2008-09-12 Thread Qing Xia
The default constraint only works when you are not explicitly inserting or updating the value of a column to something, including NULL. So since you have the default constraint in place, then simply do: cfif LEN((TRIM(form[sortORD_#myIDX#])) link_sort = cfqueryparam value=#Form[sortORD_#myIDX#]#

Re: A Little Confusion on CFQUERYPARAM and Nulls...

2008-09-12 Thread Qing Xia
on CFQUERYPARAM and Nulls... Qing Xia wrote: then simply do: cfif LEN((TRIM(form[sortORD_#myIDX#])) link_sort = cfqueryparam value=#Form[sortORD_#myIDX#]# cfsqltype=CF_SQL_VARCHAR /cfif Yea, was hoping to avoid all those extra cfif statements and keep it a little neater. Oh well

Re: (ot) SQL Join With LIKE in Join Criteria

2008-09-11 Thread Qing Xia
Hmm so long as the data in the 2nd table is consistent, you are safe. If one day, the 2nd table has data like Bad_Data_2008FA_bad, then your solution will break. This solution, I think, at its best, is temporary. A more permenant solution will be to have a REF table where the value of table

Re: Keeping people logged in with CFLOGIN

2008-09-08 Thread Qing Xia
Giving session variables a life time of 30 days seem a little scary, particularly so if you have a large number of users visiting your site. It could take up too much memory on your server. Perhaps consider using client cookie variables to recognize users when they come back is another approach?

recommendation for ISAPI injection filter?

2008-09-02 Thread Qing Xia
? We have CF8 and IIS7. Thanks a bunch, Qing Xia ~| 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

Re: SQL injection attack on House of Fusion

2008-08-19 Thread Qing Xia
filter--but that is not within my control and the only thing I can do now is on the code side. Thanks and any help will be most appreciated! Qing Xia On Sun, Aug 17, 2008 at 12:43 PM, Jochem van Dieten [EMAIL PROTECTED]wrote: denstar wrote: On Sun, Aug 17, 2008 at 2:08 AM, Jochem van Dieten wrote

Re: SQL injection attack on House of Fusion

2008-08-19 Thread Qing Xia
Neat! Thanks Dave. On Tue, Aug 19, 2008 at 11:54 AM, Dave Watts [EMAIL PROTECTED] wrote: What is the ASP equivalent of CFQUERYPARAM? http://prepared-statement.blogspot.com/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber

Re: Forum software

2008-07-29 Thread Qing Xia
We have FuseTalk. It is definitely feature-rich. I also like their tech-support. My phone calls are answered right away and they usually reply to emails promptly (within an hour) as well. However, I am not happy with the fact that their CFCs are all encrypted. Well, being a CF developer

Re: Forum software

2008-07-29 Thread Qing Xia
you can get directly from adobe. William Seiter (mobile) Have you ever read a book that changed your life? go to: http://www.winninginthemargins.com and use passcode: GoldenGrove -Original Message- From: Qing Xia [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com

Re: can't enable debug output in coldfusion 8

2008-07-28 Thread Qing Xia
Maybe there is something in the CF code that is suppressing the debug output...? On Mon, Jul 28, 2008 at 2:54 PM, Alex I [EMAIL PROTECTED] wrote: already re-installed CF8 and can't find any solution... i'm simply trying to enable debug output in CF admin and nothing happens when i check

Re: writing protected CF with CFStoredProc

2008-07-23 Thread Qing Xia
Excellent points! Thanks Dave, and everyone who took the time to reply to / read this thread. Moral lessons learned: 1) Don't go crazy with tightening security around SQL statements. Only secure the vulnerable; 2) Whenever possible, think of using native CF functions to simplify code. :-) BTW,

writing protected CF with CFStoredProc

2008-07-22 Thread Qing Xia
Hello folks: The discussion yesterday regarding using CFqueryparam to protect sites from SQL Injection attacks got me thinking. Well, it is easy enough to use CFQUERYPARAM everywhere inside CFQUERY tags, wherever a variable is passed to the SQL query. However, how do you do that with

Re: writing protected CF with CFStoredProc

2008-07-22 Thread Qing Xia
Adrian -Original Message- From: Qing Xia [mailto:[EMAIL PROTECTED] Sent: 22 July 2008 15:21 To: CF-Talk Subject: writing protected CF with CFStoredProc Hello folks: The discussion yesterday regarding using CFqueryparam to protect sites from SQL Injection attacks got me thinking

Re: writing protected CF with CFStoredProc

2008-07-22 Thread Qing Xia
True! I can certainly do this as well. On Tue, Jul 22, 2008 at 10:40 AM, morgan l [EMAIL PROTECTED] wrote: What's wrong with using: cfquery ... exec sps_testproc cfif whichvar = A @aid=cfqueryparam value=123 cfsqltype=cf_sql_integer cfelse

Re: Test

2008-07-15 Thread Qing Xia
I noticed this too when I first start participating in the discussion list (very recently). Somehow, I do not see my own emails but I do see emails from others. If you go to the House of Fusion page where the recent discussion threads are listed though, you should see it there. On Tue, Jul 15,

Re: TimeOut Problems

2008-07-11 Thread Qing Xia
Or, maybe you can do a CFHTTP call to handle the file upload in the background while sending your users on to other pages. The CFHTTP call can give you back a result code so that you can know if it is successful. On Fri, Jul 11, 2008 at 11:19 AM, Robert Harrison [EMAIL PROTECTED] wrote:

Re: Date and Time Validation

2008-07-11 Thread Qing Xia
Maybe you can use Regular Expression to validate the input. On Fri, Jul 11, 2008 at 12:37 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Fri, Jul 11, 2008 at 3:37 AM, Kamru Miah [EMAIL PROTECTED] wrote: Please let me know how to validate time input in HH:MM format (i.e. not HH:MM:SS). I am

Re: cffile error: String index out of range: -1

2008-07-10 Thread Qing Xia
I have had the same error before with file upload. The cause of my problem was that the destination file path was not exactly correct. However, in your case since the file is already uploaded to the server then it must be correct. I saw that you are using the MODE attribute...could this be an

Re: Sorting International Names Challenge!

2008-07-10 Thread Qing Xia
are used, then how do they rate in order compared to the 26 English alphabets? For example, my name, Qing Xia is the alphabetized version of my real Chinese name. Which, is easy enough to sort as that. But I can't imagine what criteria would be involved in order to sort the real Chinese characters

Re: Sorting International Names Challenge!

2008-07-10 Thread Qing Xia
, 2008 at 12:11 PM, Yuliang Ruan [EMAIL PROTECTED] wrote: Actually Qing Xia, how are chinese phonebooks done? Is it by pinyin? I grew up here in the US, dunno how alot of commonplace things are in China ~| Adobe® ColdFusion

Re: Sorting International Names Challenge!

2008-07-10 Thread Qing Xia
be listed before Liu? Also, why is Åquist at the end of the list? Qing Xia wrote: Hmm... this is an interesting problem. But I am a bit confused: what is your criteria for sorting international names? For example, for the Janpanese names, are the actual names stored (with Japanese

Re: Sorting International Names Challenge!

2008-07-10 Thread Qing Xia
Aha. Interesting. BTW, if you wouldn't mind sharing, I'd love to learn from your function which converts iso-8859-1 strings to upper case keys. I have not had a chance to work with international characters in the DB, so this sounds really interesting. On Thu, Jul 10, 2008 at 12:52 PM, Claude

Re: CF 7.0.2 Scheduled Task Log File Incomplete

2008-07-08 Thread Qing Xia
This is just a totally random idea that I am throwing out there: is it possible that the log file has reached the max size alloted for it in the CFAdmin? Additionally, when you set up a max log file size in CFAdmin and allow log files to rotate, for CFMX7, you must apply a hotfix to actually

Re: simple select query not working

2008-07-08 Thread Qing Xia
Hmmm... if it is a query of query, then you are limited to what the parent query (sorry, don't really know what the first query from DB is called...) has. So, even if a row of data does exist in a table, if that row of data is not pulled by the parent query, then there is no way how you can get

Re: simple select query not working

2008-07-08 Thread Qing Xia
at a time. This way you can see the exclusion of which condition gives you the desired the result, then you can use that as a clue On Tue, Jul 8, 2008 at 3:26 PM, Qing Xia [EMAIL PROTECTED] wrote: Hmmm... if it is a query of query, then you are limited to what the parent query (sorry, don't really

Re: simple select query not working

2008-07-08 Thread Qing Xia
Wow. That is wild! I have never experienced where a column is one data type in a SQL server table and then changed to something else after CF pulls it... (Except for NULL of course, there is no NULL in CF) Beats me! I can't imagine why this is happening... But, just for kicks... change that

Re: simple select query not working

2008-07-08 Thread Qing Xia
Try: LEN(RTRIM(LTRIM(my_integer_column))) = 0 On Tue, Jul 8, 2008 at 4:01 PM, Richard White [EMAIL PROTECTED] wrote: Hi Ian, yes i did start off comparing with empty strings - like where xx = but i wont always know the data type of the column and therefore i get an error if the column data

Re: simple select query not working

2008-07-08 Thread Qing Xia
Speaking of left outer joins: when you have a left outer join, and then you put a condition for the right-hand-side table in the WHERE clause, then that turns the LEFT OUTER JOIN into an INNER JOIN. For exmaple, the following two queries will return the same result: select ta.ta_id,

Re: CF DNS Cache

2008-07-08 Thread Qing Xia
Here's an interesting article on this subject: http://tjordahl.blogspot.com/2004/10/cfmx-and-dns-caching.html On Tue, Jul 8, 2008 at 5:55 PM, Brad Wood [EMAIL PROTECTED] wrote: I don't know that CF caches DNS, but I bet the OS probably does. Is this a one-time thing, or do you need to

Re: ONE Ring to Rule them all

2008-07-07 Thread Qing Xia
One way to do that is to put store your application variables in your SQL database (or whatever database you use). That way, in your appication.cfm / application.cfc files, you can do a query to pull out the values for various application variables such as file_upload_path, application_home,

Re: CF vs .Net or PHP - need arguement help

2008-07-02 Thread Qing Xia
The company which I used to work for (it has a very large and very complex CF application written to manage HR and disability data for Fortune 500 companies) outsourced to India. It was not nearly as successful as one would have hoped. The people looked good on paper (many with MS in Computer

Re: (ot) How do I creat a new SVN repos from an existing SVN repos?

2008-06-30 Thread Qing Xia
So, if I understand correctly, you are trying to set up a new repository that will include the same content as what is currently in the existing one? If so, try the following: 1. On the server where the repository currently lives, go to the command prompt and type in: svnadmin dump

Re: (ot) How do I creat a new SVN repos from an existing SVN repos?

2008-06-30 Thread Qing Xia
and deleting and re-checkout everything takes a long time. Otherwise, you can just do a re-checkout. On Mon, Jun 30, 2008 at 8:46 AM, Qing Xia [EMAIL PROTECTED] wrote: So, if I understand correctly, you are trying to set up a new repository that will include the same content as what is currently

Re: (ot) How do I creat a new SVN repos from an existing SVN repos?

2008-06-30 Thread Qing Xia
Greg's way is much simpler and works perfect if your existing repository is still very young or if you do not intend to keep revision history in the repository. On Mon, Jun 30, 2008 at 8:39 AM, Greg Luce [EMAIL PROTECTED] wrote: I would do an Export of the code from SVN to a new directory. That

Re: JRUN.exe

2008-06-25 Thread Qing Xia
I feel your pain, having only recently gotten rid of a very weak server. We also had server performance issues that are results of bad application code. A few important logs to look at include: 1) exception.log This one has some pretty cryptic Java stack traces, but the information is very

Re: Coldfusion 8 install question

2008-06-23 Thread Qing Xia
Since we are talking about multiple instances, I thought I'd pass along a couple of things that have caused me much grief: 1) Be sure that IIS sites need to be assigned to CF instances using the Web Server Configuration tool (installation driver\JRun4\bin\wsconfig.exe) 2) When you apply CF hot

Re: Coldfusion 8 install question

2008-06-23 Thread Qing Xia
tuning arguments you can control within each instance's jrun.xml. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Qing Xia wrote: Since we are talking about multiple instances, I

  1   2   >