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  wrote:
> I am writing a form has a Project Type radio selection.  Values being New or 
> Existing.
> If the Project type is Existing a text field needs to be required with that 
> would contain the existing projects code, if it is a New project that field 
> should not be required.  I'm having trouble figuring this one out.
>
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279270
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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 dropdown with a
> list of computers on the network running a SQL Server.
>
> Basically, like in SQL enterprise Manager, when you would go to register
> a new database with the wizard it would "search" somehow and give you a
> list of servers to choose from.
>
> How did that work?  Would it just scan the subnet for hosts with port
> 1433 open?
>
> Is that possible with ColdFusion?
>
>
>
> Note: I am not talking about ColdFusion data sources at all here.
>
>
>
> ~Brad
>
>
>
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278656
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 dataset we can use?  I think we can use USPS webservice, but it's iffy
> if we can do it for this application, as they want it to be only used to
> ship stuff through USPS.
>
>
>
> Russ
>
>
>
>
>
>
>
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277833
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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. just to post it from somewhere else once.
>
> Depends on your threat profile.
> It only takes a geek an hour or so to automate the process and then distribute
> the Perl... :-)
>
> --
> Tom Chiverton
> Helping to apprehensively brand integrated experiences
> on: http://thefalken.livejournal.com
>
> 
>
> This email is sent for and on behalf of Halliwells LLP.
>
> Halliwells LLP is a limited liability partnership registered in England and 
> Wales under registered number OC307980 whose registered office address is at 
> St James's Court Brown Street Manchester M2 2JF.  A list of members is 
> available for inspection at the registered office. Any reference to a partner 
> in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by 
> the Law Society.
>
> CONFIDENTIALITY
>
> This email is intended only for the use of the addressee named above and may 
> be confidential or legally privileged.  If you are not the addressee you must 
> not read it and must not use any information contained in nor copy it nor 
> inform any person other than Halliwells LLP or the addressee of its existence 
> or contents.  If you have received this email in error please delete it and 
> notify Halliwells LLP IT Department on 0870 365 8008.
>
> For more information about Halliwells LLP visit www.halliwells.com.
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277443
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: defeating offline form posts

2007-05-09 Thread Ken Wexel
and have an active session with a matching key in the session
scope.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. just to post it from somewhere else once.  Not
bulletproof, but worked well enough 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 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]> wrote:
> > > That's where I startedbut the thing is, I think they can spoof that
> > > variable?  Or not?
> > >
> > >
> > > -Original Message-
> > >
> > > From: AJ Mercer [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, May 08, 2007 9:53 PM
> > > To: CF-Talk
> > > Subject: Re: defeating offline form posts
> > >
> > > Have a look at the CGI variables
> > > in particular CGI.HTTP_REFERER
> > > This is the page before the current one - it should have your server
> > > details
> > > in there, other wise discard.
> > >
> > >
> > > On 5/9/07, Eric J. Hoffman <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Curious question here.   If I think about this, if someone takes a
> > > form
> > > > of ours for login, for example, and makes a local copy on their
> > > > machineand they set the post action to be the live server
> > > > authenticate filewhat is the best way to detect this and defeat
> > > it?
> > > > Noone has ever gained access this way as of yet, but we are studying
> > > > possibilities, and this seems to me to be an attack vector.
> > > >
> > > >
> > > >
> > > > Any thoughts?A check to see if the referrer was the domain
> > > > name/login file name?   Or can that be spoofed as well then?
> > > >
> > > >
> > > >
> > > > Thanks~!
> > > >
>
> 

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277409
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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]> wrote:
> That's where I startedbut the thing is, I think they can spoof that
> variable?  Or not?
>
>
>
> 
>
>
> Eric J. Hoffman
> Managing Partner
> 2081 Industrial Blvd
> StillwaterMN55082
> mail: [EMAIL PROTECTED]
> www: http://www.ejhassociates.com
> tel: 651.717.4105
> fax: 651.717.4101
> mob: 651.245.2717
> Adobe Solutions Partner
> Microsoft Certified Partner
>
> 
>
> This message contains confidential information and is intended only for 
> [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not 
> disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] 
> immediately by e-mail if you have received this e-mail by mistake and delete 
> this e-mail from your system. E-mail transmission cannot be guaranteed to be 
> secure or error-free as information could be intercepted, corrupted, lost, 
> destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman 
> therefore does not accept liability for any errors or omissions in the 
> contents of this message, which arise as a result of e-mail transmission. If 
> verification is required please request a hard-copy version.
> 
>
> -Original Message-
>
> From: AJ Mercer [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 08, 2007 9:53 PM
> To: CF-Talk
> Subject: Re: defeating offline form posts
>
> Have a look at the CGI variables
> in particular CGI.HTTP_REFERER
> This is the page before the current one - it should have your server
> details
> in there, other wise discard.
>
>
> On 5/9/07, Eric J. Hoffman <[EMAIL PROTECTED]> wrote:
> >
> > Curious question here.   If I think about this, if someone takes a
> form
> > of ours for login, for example, and makes a local copy on their
> > machineand they set the post action to be the live server
> > authenticate filewhat is the best way to detect this and defeat
> it?
> > Noone has ever gained access this way as of yet, but we are studying
> > possibilities, and this seems to me to be an attack vector.
> >
> >
> >
> > Any thoughts?A check to see if the referrer was the domain
> > name/login file name?   Or can that be spoofed as well then?
> >
> >
> >
> > Thanks~!
> >
> > 
> >
> >
> > Eric J. Hoffman
> > Managing Partner
> > 2081 Industrial Blvd
> > StillwaterMN55082
> > mail: [EMAIL PROTECTED]
> > www: http://www.ejhassociates.com
> > tel: 651.717.4105
> > fax: 651.717.4101
> > mob: 651.245.2717
> > Adobe Solutions Partner
> > Microsoft Certified Partner
> >
> > 
> >
> > This message contains confidential information and is intended only
> for
> > [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com
> you
> > should not disseminate, distribute or copy this e-mail. Please notify
> > [EMAIL PROTECTED] immediately by e-mail if you have received
> this
> > e-mail by mistake and delete this e-mail from your system. E-mail
> > transmission cannot be guaranteed to be secure or error-free as
> information
> > could be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete,
> > or contain viruses. Eric J. Hoffman therefore does not accept
> liability for
> > any errors or omissions in the contents of this message, which arise
> as a
> > result of e-mail transmission. If verification is required please
> request a
> > hard-copy version.
> > 
> >
> >
> >
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277375
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 few hours if you have a hole in
the data..

On 5/4/07, Robert Rawlins - Think Blue
<[EMAIL PROTECTED]> wrote:
> Morning Guys,
>
>
>
> I'm a little stumped on how to resolve this problem, hopefully someone will
> have a bright idea on how to achieve it. I have a bunch of table data which
> gets displayed hour on hour for a certain time period. This works absolutely
> perfectly at the moment, however the little annoyance occurs when the user
> is looking at today's information. If they look at any past dates then they
> get a nice full length table with 24 rows (one for each hour) but if they
> look at today's date then it'll only display the records that have been
> published into persistence up until that moment, so if they check it first
> thing in the morning they only get 6 or 7 rows of data.
>
>
>
> This isn't really a big deal, but it looks a little untidy for presentation
> purposes, and what I'd like to do if have a full set of 24 rows there, but
> only populate the ones that have information, then if for some reason the
> system went down for a couple of hours on a particular date it wouldn't end
> up with a funny 22 row table, it would just say 'no data' in the rows that
> it didn't have data for.
>
>
>
> Does that make sense? What's the best way to achieve this? I'm thinking
> perhaps a cfloop from 1 to 24 or something like that.
>
>
>
> Thanks for any ideas,
>
>
>
> Rob
>
>
>
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277010
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 a dirty
> import script to move thousands of items from one architecture to another.
> What I am doing is basically getting all the information from the old
> database and converting it to the new database (is not a one-to-one
> relationship) structure.  I am just grabbing one item at a time and then
> redirecting back to the script.
>
> What I would like to do is stop and then redirect so I don't end up in an
> infinite loop, but the cflocation tag, doesn't really seem to behave quite
> the way I want.  Is there another tag that would do what I am thinking or
> can someone think of an alternative?  I have about 25k items to do, so I'd
> like to just start the script this afternoon and run it through the night
> tonight.
>
> Thanks for any suggestions!
>
> jc
>
>
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275952
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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
>
>
>
>
> > Hi All,
> >
> > I'm maintaining a Coldfusion Application which is storing form data in
> > an MSSQL database.
> >
> > We've recently received complaints from users that not all form data
> > is being inserted to the database. The issue appears to be random.
> > I've tested 4 times and found that only one of my fields is not
> > inserting. I've checked the form field name, insert statement, table
> > name and everything checks out there. The field I am attempting to
> > insert is one number. Out of 279 records, only 3 have not inserted
> > into this field. There are a couple of months between each of these
> > insert dates.
> >
> > I've flooded other fields with paragraphs of text, which insert fine.
> >
> >
> > We've recently (within the last month) applied both Microsoft and
> > Coldfusion updates to the server.
> >
> > Any ideas? Thanks a bunch!
>
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275787
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Correct locking / cftransaction

2007-03-29 Thread Ken Wexel
ahhh..true...i shouldn't be responding to posts while working.

Thread from January about the same concepts...

http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44021




On 3/29/07, James Holmes <[EMAIL PROTECTED]> wrote:
> If this DB defaults to read-committed, that's not always 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, 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.
> >
> > 
> >
> > 
> > INSERT INTO(.)
> > 
> >
> > 
> > SELECT MAX(field) AS intNewID
> > FROM someTable
> > 
> >
> > 
> >
> > -Ken
> >
> >
> > On 3/29/07, Matthew Chambers <[EMAIL PROTECTED]> wrote:
> > > Ok, but what CFTRANSACTION type do I use?
> > >
> > > Cheers
> > > Matthew
> > >
> > > >If msql4 supports transactions then you have no problems. That's what
> > > >transactions is all about, multiple queries that rely on one or another
> > > >failing, to summarise it up.
> > > >
> > > >
> > > >On 3/29/07, Matthew Chambers <[EMAIL PROTECTED]> wrote:
> > > >>
> > >
> > >
> >
> >
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274165
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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.




INSERT INTO(.)



SELECT MAX(field) AS intNewID
FROM someTable




-Ken


On 3/29/07, Matthew Chambers <[EMAIL PROTECTED]> wrote:
> Ok, but what CFTRANSACTION type do I use?
>
> Cheers
> Matthew
>
> >If msql4 supports transactions then you have no problems. That's what
> >transactions is all about, multiple queries that rely on one or another
> >failing, to summarise it up.
> >
> >
> >On 3/29/07, Matthew Chambers <[EMAIL PROTECTED]> wrote:
> >>
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274160
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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), Peter Pan (mid: 87), Harry Harrison (mid: 173),
>
> How would I go about doing this?
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273842
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: List of Countries

2007-03-12 Thread Ken Wexel
No prob..I use that as well as my handy-dandy state list (which
thankfully doesn't change) all the time!  ;-)

On 3/12/07, Mike Kear <[EMAIL PROTECTED]> wrote:
> Thanks Ken,I'd have given James the link but its so long ago I had
> forgotten where it was.
>
> But it's not all that bad, its not like there's new countries coming
> along all the time.  However there are more changes than you'd think.
>  Counties changing their official names as politics/coups/regimes
> change mostly rather than countries splitting off or merging.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
>
> On 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/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-visit periodically to get a
> > > freshened list, etc.
> > >
> > > Thanks in advance,
> > >
> > > James
> > >
> > >
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272483
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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-visit periodically to get a
> freshened list, etc.
>
> Thanks in advance,
>
> James
>
>
>
> On 3/12/07, Mike Kear <[EMAIL PROTECTED]> wrote:
> >
> > There's an "official" country list - its a UN publication.  It's in
> > CSV and other formats.   The database i have has the fulll country
> > name, the common abbreviations, and I've added the country dialling
> > codes to mine so i can validate phone numbers to an extent.
> >
> > I can send you a copy if you want.
> >
> > Cheers
> > Mike Kear
> > Windsor, NSW, Australia
> > Adobe Certified Advanced ColdFusion Developer
> > AFP Webworks
> > http://afpwebworks.com
> > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
> >
> >
> >
> >
> > On 3/13/07, Peter Tanswell <[EMAIL PROTECTED]> wrote:
> > > Hi there
> > >
> > > Just wondering if anyone knew of a source where I can obtain a list of
> > countries.  Hopefully in a format that I can import into a table in a
> > database.
> > >
> > > Thanks in advance.
> > >
> > > P
> > >
> > >
> >
> >
>
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272479
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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=PPC6700&sAct=0



On 3/12/07, Coldfusion <[EMAIL PROTECTED]> wrote:
>
> I have a client who is looking to add PDA access to submit timesheet data
> for the people in the field.
> Thus the ability to login via PDA and submit hours worked for themselves and
> their crew.
>
> Keep in mind: These people are NOT Technical
>
> Questions:
> 1. What PDA would you recommend?
> 2. Would this be a separate website for PDA access?
> 3. What is the best approach, obtain a PDA capable then build the site?
>
> Tips & Suggestions are EXTREMEL welcomed!
>
> TIA!
>
>
>
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272477
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Having trouble getting variables from different tables to output

2007-03-12 Thread Ken Wexel
I did indeed - multiple tables, single query of only the related data,
instead of multiples instances of the second query (or some type of
looping and comparison to only display what you want).  This may be a
bit outside of what you were originally asking, but was the first
thing that jumped out at me as I read your question.

On 3/12/07, Mik Muller <[EMAIL PROTECTED]> wrote:
> I think he meant use a single query to join the tables through code, rather 
> than two statements.
>
>
>
> At 05:07 PM 3/12/2007, you wrote:
> >If by join the tables you mean make it one table I'm sure that can't be done 
> >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
> >To: CF-Talk
> >Subject: Re: Having trouble getting variables from different tables to output
> >
> >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?
> >
>
> 
> Michael Muller
> Admin, MontagueMA.net Website
> work (413) 863-0030
> cell (413) 320-5336
> skype: michaelBmuller
> http://www.MontagueMA.net
>
> Eschew Obfuscation
>
>
>
>
> 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272476
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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
>
>
>
>
>
> 

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272404
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 inherited as the new "IT guy." I don't know much about ColdFusion but
> I've been able to stumble around and change a few things but one page
> (actually, two similar pages) in particular is giving me a problem.
>
> We are a print shop and our website is linked to our database through CF.
> We've got several "order" pages that display order numbers, order names,
> stocks, inks, all kinds of print-related information. I've been asked to put
> our reorder information on the order detail page so that customers can look
> up a past order and order with that number and not have to submit artwork
> again.
>
> There are two pertinent tables: QOrdLineItems and QHistRO. The first query
> looks like this:
>
> 
> SELECT OrderNum, Status, MainLine, acct_id, date, po_num FROM
> "QOrdLineItems" WHERE acct_id = '#COOKIE.id#' ORDER BY date DESC
> 
>
> My understanding is this pulls five variables from QOrdLineItems when the
> variable acct_id matches the id in the cookie being set when logged in. I
> have no idea what "ORDER BY date DESC" does.
>
> The new reorder information I need to output is in the QHistRO table and is
> in two different columns called reorder_num and control_num. I've tried a
> bunch of differnet ways to call these variables and none so far have worked,
> although it may be my output statements that aren't working. Currently I
> have this query:
>
> 
> SELECT reorder_num, control_num FROM "QHistRO" WHERE reorder_num =
> '#Recordset1.OrderNum#' OR control_num = '#Recordset1.OrderNum#'
> 
>
> I'm trying to pull the variables from the table only when the
> reorder_num/control_num matches the OrderNum in Recordset1 pulled from
> QOrdLineItems.
>
> I'm outputting the variables with (the startrow & maxrows are defined
> elsewhere and not causing problems):
>
> 
>  maxrows="#MaxRows_Recordset1#">
>  "#Mid(Recordset1.date,5,2)#-#Mid(Recordset1.date,7,2)#-#Mid(Recordset1.date,
> 3,2)#">
> 
> #realdate#
>  #Recordset1.MainLine#
>  title="View Order Details">#Recordset1.Ordernum#  border=0>
>  #stat#
>  #Recordset1.PO_num# 
> 
> #Recordset2.control_num#
> #Recordset2.reorder_num#
> 
> 
>
> I have sucessfully pulled those variables into a different page and got them
> to output using this code (the URL.ID is the order_num variable):
>
> 
> 
> 
> 
> 
> 
>
> 
>  SELECT invoice_num, reorder_num, control_num FROM "QHistRO" WHERE
> reorder_num = '#URL.ID#' or control_num= '#URL.ID#'
> 
>
> Control ##HistRO.control_num#
> Reorder ##HistRO.reorder_num#
>
> I don't know a lot about ColdFusion and I've actually accomplished more than
> I thought I could but I'm hoping someone can help me finish this problem.
>
> Thanks,
>
> Mike
>
>
> 

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272402
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 


 Hello everybody,
 somebody knows how can I invoke a method from inside another method in a
cfc?
 Please help me!

 I have something like this:
 
 ...
 
  do method 2
 
 
 
 ...
 

 Thanks for your help




~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272319
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 DateFormat function.   I can't seem to make the field in the
> format of ddmmm mask.
>
> I would like the following field to have the above mask.
>
>  
> bind="{faclogGrid.dataProvider[faclogGrid.selectedIndex]['ACT_COMP')]}"
>
> onChange="faclogGrid.dataProvider.editField(faclogGrid.selectedIndex,
> 'ACT_COMP', act_comp.datefield);">
>
>
>
> Thank you so much if you can show me the right syntax.
>
>
> Bev Larson
> National Security Technologies
> Data Management & Integration
> M/S ~ CF057
> 702.295.1901 (work)
> 702.630.9916 (cell)
> 702.794.1845 (pager)
>
>
>
> 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269266
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 <[EMAIL PROTECTED]> wrote:
>
> > ColdFusion Components (CFCs) are
> > self-describing...that is, you can
> > view the methods they expose, parameters they
> > require, etc. via a web
> > browser interface, using functionality built into
> > CF.  For example, to
> > view the CF Admin API CFC, browse to:
> >
> > http://YOURSERVER/cfide/adminapi/administrator.cfc
> >
> > You'll be prompted to authenticate - enter your CF
> > Admin or RDS
> > password, and you'll see what is available via that
> > particular CFC.
> >
> > The same steps will work for the other Admin API
> > CFCs, specifically:
> >
> > base.cfc
> > datasource.cfc (the one you'll need for your
> > programmatic manipulation
> > of datasources)
> > debugging.cfc
> > eventgateway.cfc
> > extensions.cfc
> > mail.cfc
> > runtime.cfc
> > security.cfc
> >
> > Essentially, each group of functions available
> > through the ColdFusion
> > administrator is also available via the API, using
> > the above CFCs
> > (well, nearly all of them).
> >
> > For more info on the admin API and an example of
> > programmatically
> > manipulating a datasource (SQL Server in this case)
> > via the API, check
> > out:
> >
> >
> http://livedocs.macromedia.com/coldfusion/7/htmldocs/1734.htm
> >
> > Same concepts work for Access, except you'll be
> > using the setMSAccess
> > (or setMSAccessUnicode) method instead of the
> > setMSSQL method used 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,
> > > > properties, etc. using
> > > > the CFC browser.  I've used the admin api set
> > pretty
> > > > heavily - they
> > > > are very very handy!
> > > >
> > >
> > >
> > >
> > >
> >
> 
> > > Now that's room service!  Choose from over 150,000
> > hotels
> > > in 45,000 destinations on Yahoo! Travel to find
> > your fit.
> > > http://farechase.yahoo.com/promo-generic-14795097
> > >
> > >
> >
> >
>
>
> 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268842
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: programmatically create an Access Datasource

2007-02-05 Thread Ken Wexel
ColdFusion Components (CFCs) are self-describing...that is, you can
view the methods they expose, parameters they require, etc. via a web
browser interface, using functionality built into CF.  For example, to
view the CF Admin API CFC, browse to:

http://YOURSERVER/cfide/adminapi/administrator.cfc

You'll be prompted to authenticate - enter your CF Admin or RDS
password, and you'll see what is available via that particular CFC.

The same steps will work for the other Admin API CFCs, specifically:

base.cfc
datasource.cfc (the one you'll need for your programmatic manipulation
of datasources)
debugging.cfc
eventgateway.cfc
extensions.cfc
mail.cfc
runtime.cfc
security.cfc

Essentially, each group of functions available through the ColdFusion
administrator is also available via the API, using the above CFCs
(well, nearly all of them).

For more info on the admin API and an example of programmatically
manipulating a datasource (SQL Server in this case) via the API, check
out:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/1734.htm

Same concepts work for Access, except you'll be using the setMSAccess
(or setMSAccessUnicode) method instead of the setMSSQL method used 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,
> > properties, etc. using
> > the CFC browser.  I've used the admin api set pretty
> > heavily - they
> > are very very handy!
> >
>
>
>
> 
> Now that's room service!  Choose from over 150,000 hotels
> in 45,000 destinations on Yahoo! Travel to find your fit.
> http://farechase.yahoo.com/promo-generic-14795097
>
> 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268775
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 there is documentation on it in the Livedocs:
> http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=1734.htm
>
> So if I did end up going that route, I'd reference
> that.
>
> Jonathon
>
> --- "Leitch, Oblio" <[EMAIL PROTECTED]>
> wrote:
>
> > I think they're all encrypted...
> >
> >
> > -Original Message-
> > From: Jonathon S [mailto:[EMAIL PROTECTED]
> > Sent: Monday, February 05, 2007 2:17 PM
> > To: CF-Talk
> > Subject: Re: programmatically create an Access
> > Datasource
> >
> > I had not thought about that!  I am running CFMX7
> > though, so I guess I
> > do have that option.
> >
> > Thanks!
> >
> > Jonathon
>
>
>
> 
> Expecting? Get great news right away with email Auto-Check.
> Try the Yahoo! Mail Beta.
> http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html
>
> 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268768
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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]> wrote:
> Ya, The CF server is running on the same m/c (Ip Addr) where I am viewing the 
> pages.
> Will the addition of this ip addr to that list in Debugging work?
>
> Hussain.
>
> 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267439
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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 PROTECTED]> wrote:
> All I use is the webserver. No SMTP or anything. Funny thing is, I opened up
> 80 and still cannot seem to access the server. Can someone see if they can?
>
> http://72.174.248.16/totallyclassified/index.cfm
>
>
> Doug B.
>
>
>
> - Original Message -
> From: "Bobby Hartsfield" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Monday, January 22, 2007 12:23 PM
> Subject: RE: firewall?
>
>
> > That depends on what you need access to... 80 of course will allow
> > unencrypted web traffic... 443 for SSL (https)
> >
> > -Original Message-
> > From: Doug Brown [mailto:[EMAIL PROTECTED]
> > Sent: Monday, January 22, 2007 2:12 PM
> > To: CF-Talk
> > Subject: firewall?
> >
> > I am not much of a admin, so I was wondering which ports I need to leave
> > open on my server. I am running WIN2K/CFMX7/SQL2K
> >
> > Doug B.
> >
> >
> >
> >
>
> 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267187
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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  wrote:
> > > Have you set sendStringParametersAsUnicode in your JDBC URL? If
> > > not, set it to false and try again.
> >
> > fyi, how would i set that param in the jdbc url? here is my current:
> > jdbc:sqlserver:// server1 : 1433 ;DatabaseName=db1
>
> I'm pretty sure you can just tack it onto the end:
>
> jdbc:sqlserver://server1:1433;DatabaseName=db1;sendStringParametersAsUnicode
> =false
>
> However, if you're using the DataDirect drivers, I'm pretty sure you can set
> this within the CF Administrator.
>
> 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!
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266124
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 outputting the information using the
> ParagraphFormat function. What is happening though is that the output fields
> formatting ( Tag) ends at the semi-colon rather than retain the
> format for the entire field. So other than tell the users to stop using
> semi-colons, how do I work around this?
>
> Thanks,
>
> --
> Bruce Sorge
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265124
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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=1136&enable=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 insists that there be only one submit button on this page, not 
> individual submits for each record. What I am trying to do is to minimise the 
> number of database calls for updating records by only submitting records that 
> have actually changed. What I have thought of doing is as follows, when the 
> page is first loaded I concatanate all of the fields for each record into a 
> string and build a structure/array of all of these strings. When the user has 
> updated the records and submits the page I will build another structure/array 
> in the same way. What I then need to do is to compare both structures/arrays 
> to identify which records have actually changed and return those records only 
> to be updated. Has anybody done anything similar to this? Do you know of any 
> custom tags that will do the same? Is there a better way of doing this?
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241788
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