Re: Conditiial form requirements
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] 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
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?
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
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
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
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
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
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
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
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 datasource=mydsn SELECT MAX(field) AS intNewID FROM someTable /cfquery /cftransaction -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: Correct locking / cftransaction
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. cftransaction cfquery name=whatever datasource=mydsn INSERT INTO(.) /cfquery cfquery name=getMyWhateverID datasource=mydsn SELECT MAX(field) AS intNewID FROM someTable /cfquery /cftransaction -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: Regex
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: 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? 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: cfquery name=Recordset1 datasource=AR SELECT OrderNum, Status, MainLine, acct_id, date, po_num FROM QOrdLineItems WHERE acct_id = '#COOKIE.id#' ORDER BY date DESC /cfquery 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: cfquery name=Recordset2 datasource=AR SELECT reorder_num, control_num FROM QHistRO WHERE reorder_num = '#Recordset1.OrderNum#' OR control_num = '#Recordset1.OrderNum#' /cfquery 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): table cfoutput query=Recordset1 startrow=#StartRow_Recordset1# maxrows=#MaxRows_Recordset1# cfset realdate = #Mid(Recordset1.date,5,2)#-#Mid(Recordset1.date,7,2)#-#Mid(Recordset1.date, 3,2)# tr td align=center#realdate#/td tdnbsp;#Recordset1.MainLine#/td td align=centera href=/orders/ord.cfm?ID=#Recordset1.ordernum# title=View Order Details#Recordset1.Ordernum# img src=/details.jpg border=0/a/td td align=centernbsp;#stat#/td td align=centernbsp;#Recordset1.PO_num#nbsp;/td /cfoutput td align=centercfoutput#Recordset2.control_num#/cfoutput/td td align=centercfoutput#Recordset2.reorder_num#/cfoutput/td /tr /table 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): cfparam name=URL.ID default=0TU45375 cfparam name=URL.Ref_1 default=TU cfif #url.id# contains NIcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains TUcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains DQcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains 00cfset newnumber = #mid(url.id,3,6)#/cfif cfquery name=HistRO datasource=AR SELECT invoice_num, reorder_num, control_num FROM QHistRO WHERE reorder_num = '#URL.ID#' or control_num= '#URL.ID#' /cfquery Control #brcfoutput#HistRO.control_num#/cfoutputbr Reorder #brcfoutput#HistRO.reorder_num#/cfoutputbr 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
Re: What is wrong with this?
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
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: PDA Website?
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 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: List of Countries
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: List of Countries
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
Fwd: Subject: How to invoke a method from inside another method in a cfc
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 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: cffunction name=method1... ... cfif... do method 2 /cfif /cffunction cffunction name=method2... ... /cffunction 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
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. cfinput type=datefield name=ACT_COMP label=Actual Completion 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
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
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_Documentationfile=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: programmatically create an Access Datasource
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: Not able to enable debugging in CF server
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?
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 cf-talk@houseoffusion.com 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.
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 in your IN, but maybe the problems are related.. On 1/5/07, Dave Watts [EMAIL PROTECTED] 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
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 (Strong 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
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 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