Re: Conditiial form requirements

2007-05-25 Thread Ken Wexel
Do you want the field to be locked/unlocked based on the selection, and do you want to do your validation client side or server side? Either way is possible, but you'll have to handle your validation manually, as opposed to via cfinput required... On 5/25/07, Michael Beins [EMAIL PROTECTED]

Re: get a list of database servers on network

2007-05-18 Thread Ken Wexel
In CF natively? Not any way that I'm aware of, but there are a variety of other apps to use (or code) that can scan for hosts listening on a given port... On 5/18/07, Brad Wood [EMAIL PROTECTED] wrote: Here's a good Friday question. In my internal web app, is it possible to populate a

Re: zip+4 lookup?

2007-05-11 Thread Ken Wexel
Can you use the offline version of the USPS dataset? Didn't see any usps-only requirements for that (but just glanced at it) http://www.usps.com/ncsc/faq/#3 On 5/11/07, Russ [EMAIL PROTECTED] wrote: We need to do zip+4 lookup for an address. Does anyone know of a webservice or a

Re: defeating offline form posts

2007-05-09 Thread Ken Wexel
for my needs.. On 5/8/07, Maximilian Nyman [EMAIL PROTECTED] wrote: But the only thing I have to do to get around that is to hit the live form, do a View source, get the hidden values and update my local form with those hidden value(s). On 5/9/07, Ken Wexel [EMAIL PROTECTED] wrote: When I

Re: defeating offline form posts

2007-05-09 Thread Ken Wexel
True...it's all relatively relative I supposed :) On 5/9/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Wednesday 09 May 2007, Ken Wexel wrote: seems like it would be a lot of work to create the session, load the form, save the form locally, change the post path, spoof the session, etc

Re: defeating offline form posts

2007-05-08 Thread Ken Wexel
When I ran into this problem previously, I'd set a value into the user session and set the same value as a hidden form field. On post, if the two didn't match, I knew the posting was invalid. Can be something as simple as a long numeric value.. On 5/8/07, Eric J. Hoffman [EMAIL PROTECTED]

Re: Table Data

2007-05-04 Thread Ken Wexel
The loop from 1 to 24 probably makes sense if you always want a 24 row output, regardless of the actual number of rows returnedyou'll probably have to validate the data as you loop/output to be sure you're showing the correct data in the correct row and not accidentally moving everything up a

Re: URL Stop and then Redirect

2007-04-20 Thread Ken Wexel
Done this exact things many times using the META redir tag...nice little fudged CF automation :) On 4/20/07, John Cox [EMAIL PROTECTED] wrote: Hi all, I am a little stuck on a little problem, and times like these are when there is an obvious solution from a non-interested party. I am writing

Re: form data not being inserted into mssql database

2007-04-18 Thread Ken Wexel
can you post the form code, insert code, and variable values that did not insert properly? On 4/18/07, John P [EMAIL PROTECTED] wrote: Coldfusion updates that were performed were 7.0.1 and 7.0.2 I'm researching but does anyone know if these updates affected session variables? Thx John

Re: Correct locking / cftransaction

2007-03-29 Thread Ken Wexel
If you are simply inserting a new record, then doing a select max type operation to determine the id, you shouldn't need to specify the isolation level, as the default will work...e.g. cftransaction cfquery name=whatever datasource=mydsn INSERT INTO(.) /cfquery cfquery name=getMyWhateverID

Re: Correct locking / cftransaction

2007-03-29 Thread Ken Wexel
going to yield consistent results. Serializable is the only way to be sure. Of course, with MySQL, this all only applies if the table type is InnoDB, since MyISAM doesn't support transactions at all. On 3/30/07, Ken Wexel [EMAIL PROTECTED] wrote: If you are simply inserting a new record

Re: Regex

2007-03-27 Thread Ken Wexel
Do you have to use Regex, or can you do it via list/string functions? On 3/27/07, Richard Cooper [EMAIL PROTECTED] wrote: Hi all, I'm really not very good with regex, but I need to extract a list of member numbers. The numbers are contained in a list like this: John Smith (mid: 1000),

Re: Having trouble getting variables from different tables to output

2007-03-12 Thread Ken Wexel
perhaps i'm reading this wrong, but do you have to do 2 queries for this, or can you join the tables, then group the output to get what you need? On 3/12/07, Michael Stevens [EMAIL PROTECTED] wrote: Hey guys! I'm new to ColdFusion and having some problems altering some old cfm pages I've

Re: What is wrong with this?

2007-03-12 Thread Ken Wexel
looks fine...what's the value being returned in your var? On 3/12/07, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... I'm getting an invalid format mask on this: Value=#NumberFormat(Get_Property_Details.Sale_Price, )# Why? Thanks, Rick

Re: Having trouble getting variables from different tables to output

2007-03-12 Thread Ken Wexel
without a HUGE rewrite of the code that drops data into and reads data out of those two separate tables. And I'm not even up to this task let alone a complete overhaul of the system... -Original Message- From: Ken Wexel [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 1:52 PM

Re: PDA Website?

2007-03-12 Thread Ken Wexel
Well, unless they need to carry multiple devices (pda, phone, etc.), this is a pretty decent smartphone with phone and pda capabilities as well as pocket ie (or whatever it's called these days). http://www.utstar.com/pcd/view_phone_details.aspx?mcode=PPC6700sAct=0 On 3/12/07, Coldfusion [EMAIL

Re: List of Countries

2007-03-12 Thread Ken Wexel
http://www.unece.org/etrades/download/downindex.htm Down toward the bottom is a country/iso code download link... On 3/12/07, James Edmunds [EMAIL PROTECTED] wrote: Mike, I would love to know if you have link to the UN source of the CSV etc., so that I could download and make my own mods,

Re: List of Countries

2007-03-12 Thread Ken Wexel
ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/13/07, Ken Wexel [EMAIL PROTECTED] wrote: http://www.unece.org/etrades/download/downindex.htm Down toward the bottom is a country/iso code download link... On 3/12

Fwd: Subject: How to invoke a method from inside another method in a cfc

2007-03-11 Thread Ken Wexel
can't you just cfinvoke the method from inside the first method? -Ken -- Forwarded message -- From: Mike Oldfield [EMAIL PROTECTED] Date: Mar 11, 2007 4:58 PM Subject: Subject: How to invoke a method from inside another method in a cfc To: CF-Talk cf-talk@houseoffusion.com

Re: Format Date Field

2007-02-08 Thread Ken Wexel
Beverly, So you just want the date value in the cfinput to be something like 01Jun1997? On 2/8/07, Larson, Beverly [EMAIL PROTECTED] wrote: I have the following form field code below. The date is being pulled from a small oracle db. I need to know how I format the date field with the

Re: programmatically create an Access Datasource

2007-02-06 Thread Ken Wexel
You got it! On 2/6/07, Jonathon S [EMAIL PROTECTED] wrote: Huh -- never knew about that functionality! Taking a stab here -- if I wanted my own CFC's to do this same thing I'd be filling out those hint and description attributes that I've been skipping over? Jonathon --- Ken Wexel

Re: programmatically create an Access Datasource

2007-02-05 Thread Ken Wexel
You can still browse them to see their methods, properties, etc. using the CFC browser. I've used the admin api set pretty heavily - they are very very handy! On 2/5/07, Jonathon S [EMAIL PROTECTED] wrote: Yep, they're encrypted -- was the first thing I checked when it was suggested. But

Re: programmatically create an Access Datasource

2007-02-05 Thread Ken Wexel
in the example. Hope this helps, but if I can be of assistance, feel free to drop me a line off-list -Ken On 2/5/07, Jonathon S [EMAIL PROTECTED] wrote: I'm not familiar with that -- CFC Browser? Jonathon --- Ken Wexel [EMAIL PROTECTED] wrote: You can still browse them to see their methods

Re: Not able to enable debugging in CF server

2007-01-23 Thread Ken Wexel
It depends.. if you are viewing the pages using http://localhost or http://127.0.0.1 then it will be fine with that addr if you are viewing the pages using the actual machine name, you'll need the ip addr assigned to the machine as well/instead On 1/24/07, hussain shaikh [EMAIL PROTECTED]

Re: firewall?

2007-01-22 Thread Ken Wexel
Works fine for me. Are you trying to reach it from inside the same network, using the external, public IP? That might not work for you if you're inside the firewall and it's doing NAT or PAT. From outside, I get the classifieds site with no trouble. -Ken On 1/22/07, Doug Brown [EMAIL

Re: slow query in cf but fast in Sql2k5 management studio.

2007-01-10 Thread Ken Wexel
I've seen this problem just recently when using a cfqueryparam as part of an IN () clause in my queries. With a large number of list values, the cfqueryparam version of the query took many times longer than using the list directly in the querydoesn't look like you have but a couple of values

Re: escaping Semi Colons

2006-12-27 Thread Ken Wexel
If you don't want them in the content at all, is there any reason you can't strip them out using Replace or ReplaceNoCase? On 12/26/06, Bruce Sorge [EMAIL PROTECTED] wrote: Hello list, I have a form that contains some free text fields, and users sometimes put semi-colons in the field. I am

Re: Compare 2 structures or arrays

2006-05-31 Thread Ken Wexel
This may be what you're looking for... http://cflib.org/udf.cfm?id=1136enable=1 On 5/31/06, Andy Mcshane [EMAIL PROTECTED] wrote: On my site I have an area where up to 40 individual records consisting of several fields each are displayed and are able to be edited by the user. My customer