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 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
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
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
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
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
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
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
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
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?
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
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?
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
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
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
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
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
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
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
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" > 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 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 ( 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=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
