RE: DataDirect JDBC drivers (shipped with CFMX)..
This has been discussed Serveral times here.. Use your Vendor Specific JDBC Driver. MM Provides Some Drivers for Ease of Client use, i dont think this necessarily means the Best Driver. MS-SQL Server Specific. When i tested the Microsoft released JDBC Type IV Driver, this performed very well and was very Stable compared to any other. They Key is always Go With the Vendor Specific Stuff... most likely this will be LESS Headache. http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d- 8f7b-3d47969e66ae&DisplayLang=en There were some concerns here that the above Driver was not compatible with J2SE 1.4 For the stuff in CFMX.. Everything works well. Joe Eugene -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 5:07 PM To: CF-Talk Subject: DataDirect JDBC drivers (shipped with CFMX).. Apparently whichever way you go there's going to be an issue to deal with on the JDBC drivers, has anyone else worked through these? This is on Windows 2000, with SQL Server 2000. === DataDirect 3.1 Old (CFMX Updater 3) - cfstoredproc: Could not find prepared statement with handle DataDirect 3.1 New (CFMX 6.1) - 100% CPU Utilization DataDirect 3.2 - no more data to read - sql insufficient memory to complete this query === Thanks, Calvin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: downloading to a mac
>>holding CTRL (not CMD) and clicking is the equivalent of a right click. Ok, but then they have no Ctrl-click? ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DataDirect JDBC drivers (shipped with CFMX)..
DataDirect 3.2, add "4096 null" under load. -nathan strutz -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:07 PM To: CF-Talk Subject: DataDirect JDBC drivers (shipped with CFMX).. Apparently whichever way you go there's going to be an issue to deal with on the JDBC drivers, has anyone else worked through these? This is on Windows 2000, with SQL Server 2000. === DataDirect 3.1 Old (CFMX Updater 3) - cfstoredproc: Could not find prepared statement with handle DataDirect 3.1 New (CFMX 6.1) - 100% CPU Utilization DataDirect 3.2 - no more data to read - sql insufficient memory to complete this query === Thanks, Calvin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Service not running
Check the front page of HouseOfFusion.com :-) Michael changed it recently. I had a similar problem in a couple of the betas that could sorta kinda be fixed by manually starting the services (it didn't work on mySQL but I could get Access db's working). You have the ailment Michael describes, I bet. That reminds me, I have to put 6.1 on my laptop as well. Happy Friday, -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DataDirect JDBC drivers (shipped with CFMX)..
Apparently whichever way you go there's going to be an issue to deal with on the JDBC drivers, has anyone else worked through these? This is on Windows 2000, with SQL Server 2000. === DataDirect 3.1 Old (CFMX Updater 3) - cfstoredproc: Could not find prepared statement with handle DataDirect 3.1 New (CFMX 6.1) - 100% CPU Utilization DataDirect 3.2 - no more data to read - sql insufficient memory to complete this query === Thanks, Calvin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Service not running
I tried to install CFMX 6.1 on my notebook and when I tried to setup an Access DB in the Datasources, I recieved the following message: The ColdFusion MX odbc server service is not running or has not been installed. Anyone know how to go about getting this running? (I looked at the services and both ODBC MX services are running). Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Giving up on DW 2004 MX (Please End)
Hey guys, can you give it a rest? a) no system is perfect for all b) if you don't like it, suggest a change my 2 cents Cutter jon hall wrote: > Thursday, October 16, 2003, 10:37:33 AM, you wrote: > >> MTeF> I strongly disagree with this. Both about the documentation > and the > MF> power > >> MTeF> :-) > >> > >> Oh really... :) > > MF> Just tell me about something that you would like to implement as DW's > MF> extension and you can't due to the API's limitations > > For one example, setting focus. Focus needs to be able to be set from > anywhere, to anywhere. This is especially problematic with dynamic > content in a floater as doc.write has, i assume unintended, > consequences in regards to focus. > Floaters themselves need all of the DOM events...onmouseover is a big > one. Onmouseover...floaters need to be able to be focused. > Onrightclick is another big missing one. > > >> How exactly does an extremely small subset of DOM 1 that is > >> implemented unevenly across the different objects qualify as > >> powerful? To say nothing of DOM 2 or 3. > > MF> See above, what part of DOM 2 or 3 do you need inside the API, and why? > > doc.write being the only way to dynamically alter content is so 5 > years ago, slow, and has obvious code maintenance problems. The world has > DOM 2 now. Fourth generation browsers are dead, and doc.write is lame. > > >> How does the fact that all the menus are very nicely defined in XML > >> files, but no one has thought to distribute DTD's of any kind qualify > >> as well documented? > > MF> Do you really feel like it's so hard to read without a DTD? > MF> Do you think HS's stuff is better documented? > > A simple DTD says so much about an XML document...it's vastly > superior to the few paragraphs and examples given. > Homesite's built in objects and functions are documented clearly and named > logically. It also benefits from the fact that tons of preexisting > documentation exists for the WSH languages and COM objects. > > >> How can DW's data connectivity compare in any regard to ADO for power? > > MF> I never felt the need to connect to a datasource from a DW's > extension, but, > MF> apart from C++, you can leverage Flash Remoting too > > I can't remember who developed it, but I'm sure you have seen that > cool new DW data wizard that was recently released. It's > great...except DW's data limitations wont allow an editable > grid, just viewing. Even WebMatrix allows data editing, and it's > free. > > >> DW allows only JS or C, HS allows any language built on WSH, meaning > >> VBS, JS, Kix, etc., and any language a COM object can be written in. > > MF> There is a huge difference here, DW API are cross-platform. > > I only use DW on one platform...I don't see why I have to be > limited. Would it be hard to allow Windows people to use WSH and allow > Mac people to use AppleScript? > > >> Why the heck is DWFile so slow? > > MF> How many files you need to process with it? I used it for up to 2-3.000 > MF> files testing my site-wide extensions, it does the job, I never felt the > MF> need for anything faster (remember it's cross platform too) > > Directory listings read from the HD directly every time instead of > using the Windows API's ability to cache directory listings. > > >> I also can't speak to the C API, knowing very little C, but how many web > >> developers know C? > > MF> I don't, but I was still able to do a few not too trivial things > using DW's > MF> API > > >> The only thing going for DW is the UI extensibility, which is awesome, > > MF> And leaves HS in the dust here... :-) > MF> Try this for example: > MF> http://www.communitymx.com/content/article.cfm?cid=A1EDDF56F77EE7CA > > A custom floater in Flash? Nice looking...still has all of Flash's UI > problems like lack of right-click, and scroll button though. I > want to extend my IDE because I want more usability out of my IDE, not > even more usability problems. > > DW does trump HS with the ability to alter the UI, but just putting a > sticker on the side of the box doesn't make it so. It's has to fully > deliver that capability. > > >> I can't help but feel that the whole DW > >> extensibility thing has not enough resources, meaning people working > >> on it, or it has too many, and not enough organization. Maybe it's > >> because it has to run on the Mac as well that is holding it back. > > MF> I am not pretending DW's API is perfect, but I stand by my words > saying that > MF> I strongly disagree with your statement about HS's extensibility > being more > MF> powerful or better documented > > >> I think Mozilla is the model of what DW extensibility model want's > to be. > >> XUL/XBL/XPCOM kicks butt...or even HTML/DOM2/XML Events. Whatever the > >> solution is, DW needs it. It's really lagging. > > MF> Well, actually DW predates Mozilla, the XML menus were based on the very > MF> early draft of XUL (back in 1999) > > Four years...The extensibility
Re:Microsoft JDBC driver
I used netstat and telnet to see if I can get to 1433, it does nothing. When i use telnet to connect to full blow SQL server here, I can connect. Just wondering if anyone knows a fix to get it back on the network. I have all the protocols enabled, but I know MS went a little security crazy on this release and made it default to not load any network protocols. As for the firewall, there is a firewall at the company here, but I am using 127.0.0.1 to connect, so it shouldn't even touch the firewall for that. Bob >Robert Everland III wrote: >> >> Even with the above driver I can not get it to connect, though now I >get a better error message telling me that it can't connect to the >socket. > >Is MSDE listening on the port you tell CF to look? Use a tool >like fport to make sure. Are there any firewalls? > >Jochem > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: (Admin) Respect
maybe they just wanted some of your muffins angel, lol > Guys in black suits showed up at MikeyD's house! > In black SUVs... > > And snipers were standing on the neighbours mailbox to get a good > vantage point... > > And there were helicopters...and and...SWAT teams rapelling! > > And..and they busted in and yelled they had a warrant...and someone even > came down the chimney... > > and it was all about someone on the mailing list saying something silly > about killing the president! > > He has videos of the event for sale too I think. > All proceeds go to maintaining the lists. > > Ok you have a good weekend. > Bye *Waves* > :) > > -Gel > > > -Original Message- > From: GH - CF [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 4:26 PM > To: CF-Talk > Subject: Re: (Admin) Respect > > > What SS event? Could you tell more? > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: (Admin) Respect
Guys in black suits showed up at MikeyD's house! In black SUVs... And snipers were standing on the neighbours mailbox to get a good vantage point... And there were helicopters...and and...SWAT teams rapelling! And..and they busted in and yelled they had a warrant...and someone even came down the chimney... and it was all about someone on the mailing list saying something silly about killing the president! He has videos of the event for sale too I think. All proceeds go to maintaining the lists. Ok you have a good weekend. Bye *Waves* :) -Gel -Original Message- From: GH - CF [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 4:26 PM To: CF-Talk Subject: Re: (Admin) Respect What SS event? Could you tell more? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: (Admin) Respect
> What SS event? Could you tell more? http://www.houseoffusion.com/lists.cfm?link=m:5:3044:43245 It has all the details and most of the relevant links. Any further discussion on the event should be moved to CF-Community. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Microsoft JDBC driver
Robert Everland III wrote: > > Even with the above driver I can not get it to connect, though now I get a better error message telling me that it can't connect to the socket. Is MSDE listening on the port you tell CF to look? Use a tool like fport to make sure. Are there any firewalls? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Microsoft JDBC driver
Has anyone used the driver for SQL 2000 provided here? http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&DisplayLang=en . On another note, has anyone ever gotten CFMX 6.1 to work succesfully with MSDE 2000 SP3. Even with the above driver I can not get it to connect, though now I get a better error message telling me that it can't connect to the socket. Bob Everland [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: (Admin) Respect
What SS event? Could you tell more? Michael Dinowitz wrote: > Please refrain from personal attacks. They do not reflect the attackers > professionalism or even maturity. Remember that everything on this list is > archived and an attack today can come back to haunt you at work or > other places > tomorrow. (remember the Secret Service event as an extreme of that) > Thank you > > -- > Michael Dinowitz > Finding technical solutions to the problems you didn't know you had yet > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: recordcount on a grouped output
To do something like this I would use a simple flag. put something here only if it's the first time -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 12:45 PM To: CF-Talk Subject: recordcount on a grouped output How have people handled recordcount issues when doing a cfoutput with a group clause. In other words, if I'm doing a How do you handle the inner loop "first time through" issue. If you use recordcount, it refers to the outer loop. Thoughts? -Deanna - Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Parse Undeliverable email addresses
Not that this helps a whole lot, but here is some perl code to do it.. (for future reference, maybe?) http://search.cpan.org/~vparseval/Mail-Transport-Dbx-0.04/ -d - Original Message - From: Ben Densmore To: CF-Talk Sent: Friday, October 17, 2003 3:31 PM Subject: Parse Undeliverable email addresses Has anyone seen or written anything that can look into a outlook folder and parse all the email addresses out of each email? I have about 2500 emails I need to remove from our mailing list that bounced back and are sitting in an undeliverable folder in outlook and wanted to try and do it through CF. I know someone who did it in Perl once but don't have his code. Thanks, Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Parse Undeliverable email addresses
Ben: I use a piece of software written by G-Lock Software. It is called "Email Processor", and it does a pretty nice job. I haven't spent to much time with it, but the setup was quite easy. It is $99.00, but they do have a trial version with limited capability. http://www.glocksoft.com/ep/index.htm _ From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:31 PM To: CF-Talk Has anyone seen or written anything that can look into a outlook folder and parse all the email addresses out of each email? I have about 2500 emails I need to remove from our mailing list that bounced back and are sitting in an undeliverable folder in outlook and wanted to try and do it through CF. I know someone who did it in Perl once but don't have his code. Thanks, Ben _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
recordcount on a grouped output
How have people handled recordcount issues when doing a cfoutput with a group clause. In other words, if I'm doing a How do you handle the inner loop "first time through" issue. If you use recordcount, it refers to the outer loop. Thoughts? -Deanna - Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Parse Undeliverable email addresses
Has anyone seen or written anything that can look into a outlook folder and parse all the email addresses out of each email? I have about 2500 emails I need to remove from our mailing list that bounced back and are sitting in an undeliverable folder in outlook and wanted to try and do it through CF. I know someone who did it in Perl once but don't have his code. Thanks, Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Questions about 6.1 and the Certification Exam...
yeah, i got dinged by a couple cuz of this as well... -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:20 PM To: CF-Talk Subject: RE: Questions about 6.1 and the Certification Exam... > From: Samuel Neff [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 1:09 PM > To: CF-Talk > Subject: RE: Questions about 6.1 and the Certification Exam... > > > I was told that the exam does not and will not cover 6.1. > The exam is based on 6.0 gold. > > Unfortunately, I heard that there was actually a question in > the pool that has a different answer depending on if you're > talking about 6.0 or 6.1. The correct answer is based on > 6.0. I don't know more than that. > > So just study CFMX 6.0 gold stuff. I can attest to this as well. It's unfortunate as I know I got dinged by this once. I guess I can understand not upgrading the test for 6.1, but at the least they should avoid questions that would be a problem w/ 6.0 versus 6.1. I used the feedback form of the test but I'm not sure if anything came of it. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Questions about 6.1 and the Certification Exam...
> From: Samuel Neff [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 1:09 PM > To: CF-Talk > Subject: RE: Questions about 6.1 and the Certification Exam... > > > I was told that the exam does not and will not cover 6.1. > The exam is based on 6.0 gold. > > Unfortunately, I heard that there was actually a question in > the pool that has a different answer depending on if you're > talking about 6.0 or 6.1. The correct answer is based on > 6.0. I don't know more than that. > > So just study CFMX 6.0 gold stuff. I can attest to this as well. It's unfortunate as I know I got dinged by this once. I guess I can understand not upgrading the test for 6.1, but at the least they should avoid questions that would be a problem w/ 6.0 versus 6.1. I used the feedback form of the test but I'm not sure if anything came of it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Questions about 6.1 and the Certification Exam...
I was told that the exam does not and will not cover 6.1. The exam is based on 6.0 gold. Unfortunately, I heard that there was actually a question in the pool that has a different answer depending on if you're talking about 6.0 or 6.1. The correct answer is based on 6.0. I don't know more than that. So just study CFMX 6.0 gold stuff. Good luck. Sam -- Blog: http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- > -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 2:54 PM > To: CF-Talk > Subject: Questions about 6.1 and the Certification Exam... > > I've been studying, and I got Ben's CFMX Developers Study > Guide a while > back, and was getting close to scheduling my test, when a > co-worker casually > asked me, "So...does the test cover 6.1 stuff?" > > I genuinely didn't know...does it? > > Do I need to brush up on 6.1 stuff like changes to the mail > tag or look up > any other significant changes that might creep into a test > question? If so, > is there a place that can fast track me to the relevant > changes and how they > might show up in the form of questions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Questions about 6.1 and the Certification Exam...
have you checked out www.centrasoft.com for their cfmxbuster exam? its like 39.95 and you get 11 practice exams. I cant speak for the 6.1 inclusion but I can say its cfmx centric... im taking one each morning, in the month leading up to max, and then, BAM, CERTIFIED TIME BABY!!! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:54 PM To: CF-Talk Subject: Questions about 6.1 and the Certification Exam... I've been studying, and I got Ben's CFMX Developers Study Guide a while back, and was getting close to scheduling my test, when a co-worker casually asked me, "So...does the test cover 6.1 stuff?" I genuinely didn't know...does it? Do I need to brush up on 6.1 stuff like changes to the mail tag or look up any other significant changes that might creep into a test question? If so, is there a place that can fast track me to the relevant changes and how they might show up in the form of questions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Questions about 6.1 and the Certification Exam...
I've been studying, and I got Ben's CFMX Developers Study Guide a while back, and was getting close to scheduling my test, when a co-worker casually asked me, "So...does the test cover 6.1 stuff?" I genuinely didn't know...does it? Do I need to brush up on 6.1 stuff like changes to the mail tag or look up any other significant changes that might creep into a test question? If so, is there a place that can fast track me to the relevant changes and how they might show up in the form of questions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Not allowed to query of query a query in a structure.
Did we all know you can't do this? In other words the following does not work. SELECT * FROM this.data[key] WHERE CSV_RANK > 0 But the following does work. Interesting isn't it. SELECT * FROM temp WHERE CSV_RANK > 0 Ok, maybe not so interesting, but I fought with this way to long on a Friday. Cheers -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sort Order Best Practice Request
I wouldn't think it would be too hard to write some logic that would automatically renumber the order column... Some very rough pseudo code. So in you example, a user moves the item (foo) in position 5 to position 25 Loop from 6 to 25 index i Update i Set sortIndex = sortIndex -1 next update set sortIndex = 25 where ID = foo HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:12 AM To: CF-Talk Subject: Re: Sort Order Best Practice Request Les, We do this by having a sort order column and then a _javascript_ interface that lets them move items updown in a list. Then, the list of ordered items is sent to the action page, and looped through, and we update the sortorder column based on the new order of the list. We're not dealing with huge lists, though. The overhead for looping through as many as you're talking about might negate the benefits of this option. -Deanna Here's the _javascript_:
Here's the form table: size="#sortableUsers.recordcount#"> #lastname#, #firstname# swapitems(s,s.selectedIndex,s.selectedIndex-1)">Move Up swapitems(s,s.selectedIndex,s.selectedIndex+1)">Move Down Here's the action page: name="sortupdate"> UPDATE projperson SET sort = WHERE projectid = value="#projectid#"> AND prsnid = value="#listgetat(form.itemorder, i)#"> - Original Message - From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 12:44 PM Subject: Sort Order Best Practice Request Here's a problem I've been plagued with recently, and sure others have as well. I've got a large number of tables listing industrial parts. There's columns and columns of specs, temperature tolerances, blah, blah, blah... I've built an administration system for the client to keep all this stuff updated, and built display pages that they're pulling into Acrobat to actually print their catalogue when needed. However, they need products from each table listed in a specific order for printing. There's nothing in the database that can be used to sort these to get them in the order they want - it's completely arbitrary. No alpha or numeric sort on any combination of columns will actually do the trick. So, for a page listing 550 parts from a table, what type of solution or system can I use that will allow them to specify, on whatever whim, the exact order all these parts get listed. They need to be able, for example, shift product number 15 down to the 25th position and have everything else resort from there You *could* let them manually edit a "sort index", but if you change #5 to #15, then how the heck to you avoid having to manually edit every other number in the table to sort them all out again, since duplicates ain't gonna work? Ideas? Best practice? How are others handling this sort (pun!) or thing? -- Les Mizzell - "Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo." _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sort Order Best Practice Request
Deanna Schneider wrote: > We do this by having a sort order column and then a _javascript_ interface > that lets them move items updown in a list. Then, the list of ordered items > is sent to the action page, and looped through, and we update the sortorder > column based on the new order of the list. We're not dealing with huge > lists, though. The overhead for looping through as many as you're talking > about might negate the benefits of this option. This looks very interesting. Will give it a try over the weekend. Thanks! -- Les Mizzell - Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Nowadays Verisign requires that you sign up for services they still cheekily call "optional" with PFPro. The fraud protection stuff. Takes their minimum monthly fee to about US$98 (!). My client reported this back to me recently and I freaked. He was a Bank of America customer so I used their service, which costs about US$40 monthly. Wish I'd known about the Terrapayments stuff at that time. Would have saved me a lot of the PITA that was integrating the quirky BofA system. Although that 6-month rolling reserve they require (and hold for 6 months) probably would have killed the deal. Bummer, that. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
I'd recommend Authorize.net. I've integrated Authorize.net, SkipJack, and Verisign. Verisign is good, but their CF tag doesn't work, so I had to use COM to integrate it into my shopping cart. SkipJack is also good, but more restrictive than AuthNet. Authorize.net allows the ability to pay by ECHECK if you so choose, and integration is fairly simple (unless you have a Wells Fargo SecureSource account - then it gets slightly more complex). I think if I was a store owner I'd tend toward whichever is the cheapest between these three options, but as a developer I'd tend toward SkipJack or AuthNet. -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 7:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sort Order Best Practice Request
Les, We do this by having a sort order column and then a _javascript_ interface that lets them move items updown in a list. Then, the list of ordered items is sent to the action page, and looped through, and we update the sortorder column based on the new order of the list. We're not dealing with huge lists, though. The overhead for looping through as many as you're talking about might negate the benefits of this option. -Deanna Here's the _javascript_:
Here's the form table: size="#sortableUsers.recordcount#"> #lastname#, #firstname# swapitems(s,s.selectedIndex,s.selectedIndex-1)">Move Up swapitems(s,s.selectedIndex,s.selectedIndex+1)">Move Down Here's the action page: name="sortupdate"> UPDATE projperson SET sort = WHERE projectid = value="#projectid#"> AND prsnid = value="#listgetat(form.itemorder, i)#"> - Original Message - From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 12:44 PM Subject: Sort Order Best Practice Request Here's a problem I've been plagued with recently, and sure others have as well. I've got a large number of tables listing industrial parts. There's columns and columns of specs, temperature tolerances, blah, blah, blah... I've built an administration system for the client to keep all this stuff updated, and built display pages that they're pulling into Acrobat to actually print their catalogue when needed. However, they need products from each table listed in a specific order for printing. There's nothing in the database that can be used to sort these to get them in the order they want - it's completely arbitrary. No alpha or numeric sort on any combination of columns will actually do the trick. So, for a page listing 550 parts from a table, what type of solution or system can I use that will allow them to specify, on whatever whim, the exact order all these parts get listed. They need to be able, for example, shift product number 15 down to the 25th position and have everything else resort from there You *could* let them manually edit a "sort index", but if you change #5 to #15, then how the heck to you avoid having to manually edit every other number in the table to sort them all out again, since duplicates ain't gonna work? Ideas? Best practice? How are others handling this sort (pun!) or thing? -- Les Mizzell - "Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo." [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Mime type for a dwf file?
We have a system where a user can upload files, then later access these files (with security) through a CFContent call. We set the mime types for most of the common files (images, documents, spreadsheets, etc.), and the browser handles the files accordingly (opens the appropriate plug-in if it's available). Recently we have had a request to handle Autocad files. I've changed my code to specifically recognize dxf, dwg, and dwf, and set the mime types accordingly. However, even with this, the browser is not recognizing the mime type and firing the plugin. If I link to the file in question directly, the plugin get's fired. I've tried "drawing/x-dwf", "image/x-dwf", and "image/vnd.dwf" (though I didn't expect this one to work - I don't think this is a valid mime type). Does anyone have any suggestions on which mime type I need to specify? Or maybe another way to get the plugin to fire? Thanks in adavance. Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Sort Order Best Practice Request
Here's a problem I've been plagued with recently, and sure others have as well. I've got a large number of tables listing industrial parts. There's columns and columns of specs, temperature tolerances, blah, blah, blah... I've built an administration system for the client to keep all this stuff updated, and built display pages that they're pulling into Acrobat to actually print their catalogue when needed. However, they need products from each table listed in a specific order for printing. There's nothing in the database that can be used to sort these to get them in the order they want - it's completely arbitrary. No alpha or numeric sort on any combination of columns will actually do the trick. So, for a page listing 550 parts from a table, what type of solution or system can I use that will allow them to specify, on whatever whim, the exact order all these parts get listed. They need to be able, for example, shift product number 15 down to the 25th position and have everything else resort from there You *could* let them manually edit a "sort index", but if you change #5 to #15, then how the heck to you avoid having to manually edit every other number in the table to sort them all out again, since duplicates ain't gonna work? Ideas? Best practice? How are others handling this sort (pun!) or thing? -- Les Mizzell - Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Whatever you do, do not use psigate for any merchant account processing. They have terrible support, uptime, and customer service. I learned this the hard way. Do not pick psigate.com! Brook At 10:01 AM 10/17/2003, you wrote: >I've had very good success with VeriSign's PayFlow pro. I've had >consistently fast response times and their servers haven't gone down >once since I've been using them. If you want to do all the processing >"on-site" (opposed to redirecting to another site) then they are a great >way to go. > > >I wouldn't use their SSL certs, or anything else from them, though. > >Jeff Polaski >RGS Webmaster > >"I've never seen an abominable snowman, >I'm hoping not to see one, >I'm also hoping, if I do, >That it will be a wee one. " > - The Abominable Snowman , by Ogden Nash > >-Original Message- >From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] >Sent: Friday, October 17, 2003 7:30 AM >To: CF-Talk >Subject: Merchant Account Suggestions > > >I have a small business that I am doing an e-commerce >application for >and they are wanting to setup a merchant/gateway account for the >website. I have not had any experience with setting up a this >type of an >account and I am wondering what are my options. > > >Is there something that is not rather expensive that you have >used? I >am prepared for the monthly payments and %'s taken out, but >there are >just so many damn options. > > >All suggestions are welcome. Thank you! > >--- >Ricky Fritzsching > > > > _ > > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading to a mac
Awesome - thanks Ryan from the heart of this pcers bottom er... bottom of this pcers heart. -mk -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 12:16 PM To: CF-Talk Subject: Re: downloading to a mac Yep, do this cntrl click, and there should be a save target as, or a download link target or something. Depends on the browser you are using obviously!! On 17/10/03 17:38, "Barney Boisvert" <[EMAIL PROTECTED]> wrote: > There is a right click in the mac world, you just need a non-mac mouse to > have a right button. However, holding CTRL (not CMD) and clicking is the > equivalent of a right click. > > barneyb > -Original Message- > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 9:29 AM > To: CF-Talk > Subject: OT: downloading to a mac > > Mac gurus, > > What's the best way to set up a file download on a windows based server to > a MAC? We have a .mov file. If you click on > the link to the file it plays (naturally) - but I don't know an equivalent > to "right-click -- save target as". Is there > such a thing in the mac world? > > -Mark > > Mark A. Kruger, MCSE, CFG > www.cfwebtools.com > www.necfug.com > http://mxc.blogspot.com > ...what the web can be! > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: downloading to a mac
Yep, do this cntrl click, and there should be a save target as, or a download link target or something. Depends on the browser you are using obviously!! On 17/10/03 17:38, "Barney Boisvert" <[EMAIL PROTECTED]> wrote: > There is a right click in the mac world, you just need a non-mac mouse to > have a right button. However, holding CTRL (not CMD) and clicking is the > equivalent of a right click. > > barneyb > -Original Message- > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 9:29 AM > To: CF-Talk > Subject: OT: downloading to a mac > > Mac gurus, > > What's the best way to set up a file download on a windows based server to > a MAC? We have a .mov file. If you click on > the link to the file it plays (naturally) - but I don't know an equivalent > to "right-click -- save target as". Is there > such a thing in the mac world? > > -Mark > > Mark A. Kruger, MCSE, CFG > www.cfwebtools.com > www.necfug.com > http://mxc.blogspot.com > ...what the web can be! > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: SQL Query
does this work? SELECT TOP 1 reportID FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT reportID FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT TOP 1 reportID FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) ORDER BY tripDate same thing minus the beginning ( and ending ) you had followed by a straggler order by tripDate? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 12:40 PM To: CF-Talk Subject: Re: OT: SQL Query Ok here is the query that I have ... and the error that is showing up. I am using MS SQL 2000 ( SELECT TOP 1 reportID FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT reportID FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT TOP 1 reportID FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) ) ORDER BY tripDate ERROR: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near ')'. SQL = "SELECT TOP 1 * FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = 1032) UNION SELECT * FROM beaverReports WHERE reportID = 1032) UNION SELECT TOP 1 * FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = 1032) ORDER BY tripDate" Thanks for the help! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Friday, October 17, 2003 3:56 AM Subject: Re: OT: SQL Query Paul Giesenhagen said: > > I have a number of reports all dated, but dated by day (no time). > Some of the reports are on the same day If I have an ID value, I > need to grab the report before and the report after that ID and it > needs to be by date. > > Here is what the data looks like: > > ReportID | ReportDate | Report | > 19/10/2003 > 29/11/2003 > 39/11/2003 > 49/11/2003 > 59/12/2003 > 89/12/2003 > 99/14/2003 > 1110/01/2003 etc.. > > If I am looking at ReportID (5), then I want to know that reportID 4 > is previous and reportID 8 is next > > So my output should be > Previous = 4 > This > > Next = 8 > > Oh, and I need to know if previous is Nothing or Next is nothing (ie > there isn't anymore eitherway). It won't be evry fast, but should be acceptable if the dataset isn't too large. The preliminary resultsets need to be limited to one row, the code for that is between square brackets (database dependent). ( SELECT [TOP 1] * FROM table WHERE ReportDate > (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate, ID [LIMIT 1] UNION SELECT * FROM table WHERE ID = 5) UNION SELECT [TOP 1] * FROM table WHERE ReportDate < (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate DESC, ID DESC [LIMIT 1] ) ORDER BY ReportDate Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
I've had very good success with VeriSign's PayFlow pro. I've had consistently fast response times and their servers haven't gone down once since I've been using them. If you want to do all the processing "on-site" (opposed to redirecting to another site) then they are a great way to go. I wouldn't use their SSL certs, or anything else from them, though. Jeff Polaski RGS Webmaster "I've never seen an abominable snowman, I'm hoping not to see one, I'm also hoping, if I do, That it will be a wee one. " - The Abominable Snowman , by Ogden Nash -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 7:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Structure of Structures Question
Bryan/Raymond, Thanks a million. You made my Friday. Have a great weekend! Regards, James Blaha Bryan F. Hogan wrote: > > 'Middle_Name')> > > Didn't test it, but it should work. > -Original Message- > From: James Blaha [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 11:23 AM > To: CF-Talk > Subject: Structure of Structures Question > > All: Structure of Structures Question > > I'm trying to look at an element and see if that element has a variable > defined. I'm getting an error: > > Element MIDDLE_NAME is undefined in a Java object of type class > coldfusion.runtime.MemorySessionScope referenced as > What can I do to check for existence of this item Middle_Name? > > My Setup: CFMX6.1, Win2k, Sun ONE > > Regards, > James Blaha > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic page processing
2) Create actual blank pages on the filesystem named astronomy.cfm, etc when the content is created, then use application.cfm to get the ball rolling. Is there much, if any, overhead in using the application.cfm file in this manner? A variant of this approach that is used by content management systems like CommonSpot (http://www.paperthin.com ) is to have stub pages which set up various variables etc. that the framework uses e.g. have an astronomy.cfm stub page which simply includes/redirects/modules the actual content. This requires the publishing and synchronizing of these stub pages when content is being added/updated but you can utilize this to your advantage by allowing them to cache various page settings. This approach is somewhere in between having fully published static pages which are very fast to serve and fully dynamic pages which are always up to date but draining on the server. André [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Query
Ok here is the query that I have ... and the error that is showing up. I am using MS SQL 2000 ( SELECT TOP 1 reportID FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT reportID FROM beaverReports WHERE reportID = #variables.thisReport#) UNION SELECT TOP 1 reportID FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = #variables.thisReport#) ) ORDER BY tripDate ERROR: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near ')'. SQL = "SELECT TOP 1 * FROM beaverReports WHERE tripDate > (SELECT tripDate FROM beaverReports WHERE reportID = 1032) UNION SELECT * FROM beaverReports WHERE reportID = 1032) UNION SELECT TOP 1 * FROM beaverReports WHERE tripDate < (SELECT tripDate FROM beaverReports WHERE reportID = 1032) ORDER BY tripDate" Thanks for the help! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Friday, October 17, 2003 3:56 AM Subject: Re: OT: SQL Query Paul Giesenhagen said: > > I have a number of reports all dated, but dated by day (no time). > Some of the reports are on the same day If I have an ID value, I > need to grab the report before and the report after that ID and it > needs to be by date. > > Here is what the data looks like: > > ReportID | ReportDate | Report | > 19/10/2003 > 29/11/2003 > 39/11/2003 > 49/11/2003 > 59/12/2003 > 89/12/2003 > 99/14/2003 > 1110/01/2003 etc.. > > If I am looking at ReportID (5), then I want to know that reportID 4 > is previous and reportID 8 is next > > So my output should be > Previous = 4 > This > > Next = 8 > > Oh, and I need to know if previous is Nothing or Next is nothing (ie > there isn't anymore eitherway). It won't be evry fast, but should be acceptable if the dataset isn't too large. The preliminary resultsets need to be limited to one row, the code for that is between square brackets (database dependent). ( SELECT [TOP 1] * FROM table WHERE ReportDate > (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate, ID [LIMIT 1] UNION SELECT * FROM table WHERE ID = 5) UNION SELECT [TOP 1] * FROM table WHERE ReportDate < (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate DESC, ID DESC [LIMIT 1] ) ORDER BY ReportDate Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: downloading to a mac
There is a right click in the mac world, you just need a non-mac mouse to have a right button. However, holding CTRL (not CMD) and clicking is the equivalent of a right click. barneyb -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:29 AM To: CF-Talk Subject: OT: downloading to a mac Mac gurus, What's the best way to set up a file download on a windows based server to a MAC? We have a .mov file. If you click on the link to the file it plays (naturally) - but I don't know an equivalent to "right-click -- save target as". Is there such a thing in the mac world? -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://mxc.blogspot.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Structure of Structures Question
Your isDefined statement is incorrect, you should use isDefined("application.usersloggedin.#variables.useridatdoor#.middlename ")> which will only work if variables.userIDatDoor is a valid variable name. It would be better to do this: structKeyExists(application.usersLoggedIn[variables.userIDAtDoor],"middl eName")> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Structure of Structures Question
'Middle_Name')> Didn't test it, but it should work. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:23 AM To: CF-Talk Subject: Structure of Structures Question All: Structure of Structures Question Im trying to look at an element and see if that element has a variable defined. Im getting an error: Element MIDDLE_NAME is undefined in a Java object of type class coldfusion.runtime.MemorySessionScope referenced as What can I do to check for existence of this item Middle_Name? My Setup: CFMX6.1, Win2k, Sun ONE Regards, James Blaha [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: downloading to a mac
Mac gurus, What's the best way to set up a file download on a windows based server to a MAC? We have a .mov file. If you click on the link to the file it plays (naturally) - but I don't know an equivalent to "right-click -- save target as". Is there such a thing in the mac world? -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://mxc.blogspot.com ...what the web can be! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Structure of Structures Question
All: Structure of Structures Question Im trying to look at an element and see if that element has a variable defined. Im getting an error: Element MIDDLE_NAME is undefined in a Java object of type class coldfusion.runtime.MemorySessionScope referenced as What can I do to check for existence of this item Middle_Name? My Setup: CFMX6.1, Win2k, Sun ONE Regards, James Blaha Variables.USERIDATDOOR)# IS TRUE> IsDefined(APPLICATION.USERSLOGGEDIN["#Variables.USERIDATDOOR#"].Middle_Name)> Defined Not Defined [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dynamic page processing
Publishing static pages translate to a more complex admin process, but much less load on the public side. I love what they do for me, personally, and use them wherever possible. Embrace the horror :D Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Forum 2000
Jim Davis wrote: > Actually - if I remember correctly - CF Forums was never encrypted. So > no matter what version you have you should be able to dig in. I have looked it over a few times over the last years, but since it was never released under an OSI approved Open Source license I never released any code. And with all the new features that MX offers, it is probably better to start from scratch. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
If you are actually on the ColdFusion server can you browse to that same URL? André -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:55 To: CF-Talk Subject: Re:CFHTTP Question! When I browse the asp file in the browse, it displays the menu on the browser. This is the url I'm using: http://myProject/site/includes/topmenu/folder2/menu.asp But when I include this url in cfhttp I get You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. error. Here is my code: METHOD="GET" RESOLVEURL="true" throwonerror="yes"/> #CFHTTP.FileContent# Am I missing some attributes in my cfhttp tag? >Allan, > >What is the URL you need to type into a browser in order to run >menu.asp? > >That is the URL you need to specify for using CFHTTP. > >(Remember when using CFHTTP it is the ColdFusion server running the >request so the URL needs to be from the perspective of what the >ColdFusion server can see the menu.asp page as which could mean using a >127.0.0.1 or localhost address since it is on the same server. Also, in >general better to use IP addresses to avoid domain name resolution >issues though you loose the obvious benefits.) > >André > >-Original Message- >From: Allan Clarke [mailto:[EMAIL PROTECTED] >Sent: 17 October 2003 16:01 >To: CF-Talk >Subject: CFHTTP Question! > >Hello everybody, > >I'm trying to call a .asp file from my coldfusion page >using cfhttp and I keep getting errors. Both files are >on the same server, just different folders under the >site webroot. >This should explain it: > >The ColdFusion file is in >C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm > >and the ASP file is in >C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. > >Can somebody show me how to use cfhttp to call the asp >file (menu.asp) in my coldfusion file >(searchreport.cfm) > >Many Thanks >Allan > >__ >Do you Yahoo!? >The New Yahoo! Shopping - with improved product search >http://shopping.yahoo.com > _ > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFHTTP Question!
As a side thought If that menu.asp is actually just a bunch of html with no asp code in there, the you could just use to drag it into your cf code. Or you could bin that asp junk altogether and. ~joking~ ;o) Andre Mohamed wrote: > Allan, > > > What is the URL you need to type into a browser in order to run > menu.asp? > > > That is the URL you need to specify for using CFHTTP. > > > (Remember when using CFHTTP it is the ColdFusion server running the > request so the URL needs to be from the perspective of what the > ColdFusion server can see the menu.asp page as which could mean using a > 127.0.0.1 or localhost address since it is on the same server. Also, in > general better to use IP addresses to avoid domain name resolution > issues though you loose the obvious benefits.) > > > André > > > -Original Message- > From: Allan Clarke [mailto:[EMAIL PROTECTED] > Sent: 17 October 2003 16:01 > To: CF-Talk > Subject: CFHTTP Question! > > > Hello everybody, > > I'm trying to call a .asp file from my coldfusion page > using cfhttp and I keep getting errors. Both files are > on the same server, just different folders under the > site webroot. > This should explain it: > > The ColdFusion file is in > C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm > > and the ASP file is in > C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. > > Can somebody show me how to use cfhttp to call the asp > file (menu.asp) in my coldfusion file > (searchreport.cfm) > > Many Thanks > Allan > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
Most likely there are directory permissions setup on this folder and that you are logged into your network with an account that has permission to view this directory. Which is why you are able to browse the file. However CFHTTP can not because it is making a request like I would be if I where to click the link. I can not verify that this is the problem because you left your domain out of the URL that you provided. -Original Message- From: ColdFusion Programmer [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:55 AM To: CF-Talk Subject: Re:CFHTTP Question! When I browse the asp file in the browse, it displays the menu on the browser. This is the url I'm using: http://myProject/site/includes/topmenu/folder2/menu.asp [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFHTTP Question!
When I browse the asp file in the browse, it displays the menu on the browser. This is the url I'm using: http://myProject/site/includes/topmenu/folder2/menu.asp But when I include this url in cfhttp I get You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. error. Here is my code: #CFHTTP.FileContent# Am I missing some attributes in my cfhttp tag? >Allan, > >What is the URL you need to type into a browser in order to run >menu.asp? > >That is the URL you need to specify for using CFHTTP. > >(Remember when using CFHTTP it is the ColdFusion server running the >request so the URL needs to be from the perspective of what the >ColdFusion server can see the menu.asp page as which could mean using a >127.0.0.1 or localhost address since it is on the same server. Also, in >general better to use IP addresses to avoid domain name resolution >issues though you loose the obvious benefits.) > >André > >-Original Message- >From: Allan Clarke [mailto:[EMAIL PROTECTED] >Sent: 17 October 2003 16:01 >To: CF-Talk >Subject: CFHTTP Question! > >Hello everybody, > >I'm trying to call a .asp file from my coldfusion page >using cfhttp and I keep getting errors. Both files are >on the same server, just different folders under the >site webroot. >This should explain it: > >The ColdFusion file is in >C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm > >and the ASP file is in >C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. > >Can somebody show me how to use cfhttp to call the asp >file (menu.asp) in my coldfusion file >(searchreport.cfm) > >Many Thanks >Allan > >__ >Do you Yahoo!? >The New Yahoo! Shopping - with improved product search >http://shopping.yahoo.com > _ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
Thomas Chiverton wrote: > On Friday 17 Oct 2003 15:53 pm, Jochem van Dieten wrote: > >>>You don't have to be doing something stupid to trigger a trojon. >> >>What would be a non-stupid way for an admin to trigger a trojan on his >>server? > > > DNS poisioning when you downloaded the patch file, for instance. > On UNIX boxes, a local attacker could have altered an alias for a common > command to fetch, compile and insert a Nasty kernel module and then waited > for you to run that command. That is what checksums are for. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SES urls on CFMX6.1 installed on top of JRun
I'm running CFMX6.1 installed on top of JRun, Win XP pro, and i can't get "search engine safe" (SES) urls to work. --- -- START TESTS --- no dummy extension --- URL http://127.0.0.1/index.cfm/this/that RESULT JRun Servlet Error404 /index.cfm/this/that /index.cfm/this/that --- ".htm" dummy extension --- URL http://127.0.0.1/index.cfm/this/that.htm RESULT: JRun Servlet Error404 /index.cfm/this/that.htm /index.cfm/this/that.htm --- ".cfm" dummy extension --- URL http://127.0.0.1/index.cfm/this/that.cfm RESULT - "standard" CFMX error: Error Occurred While Processing Request File not found: /index.cfm/this/that.cfm Please try the following: etc etc -- END TESTS - I had no problems when running CFMX6.0 with the built in JRun - this has only been a problem with 6.1 on the full JRun. Any help/advise/anything gratefully received. TIA Bert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFHTTP Question!
This is the code I have got on my Coldfusion file #CFHTTP.FileContent# I get an error: You are not authorized to view this page You do not have permission to view this directory or page using the credentials you supplied. Can somebody tell me what am I doing wrong Thanks >Hello everybody, > >I'm trying to call a .asp file from my coldfusion page >using cfhttp and I keep getting errors. Both files are >on the same server, just different folders under the >site webroot. >This should explain it: > >The ColdFusion file is in >C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm > > >and the ASP file is in >C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. > >Can somebody show me how to use cfhttp to call the asp >file (menu.asp) in my coldfusion file >(searchreport.cfm) > >Many Thanks >Allan > >__ >Do you Yahoo!? >The New Yahoo! Shopping - with improved product search >http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Ok last post from me in regards to this advertising frenzy ;-) I realize we may not be a "household name" but rest assured we've been around for years. Here are some quick notes on us: - We currently process in excess of 1 Billion dollars a year - We do CCs and checks - We're International, supporting a wide array of currencies - One of the fastest payment gateways on the planet - We specialize in high risk transactions (i.e. extensive fraud prevention) - We are not a reseller, but we do offer reseller programs - Easy CF, PHP, Java, Com integration - Macromedia Partner - No setup fees if you go thru me - I do not earn any commission; I just believe we offer great service. :) I'm done! Back to regular scheduled CF programming... Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 11:34 AM To: CF-Talk Subject: RE: Merchant Account Suggestions sweet. I didn't know! thanks. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:31 AM To: CF-Talk Subject: RE: Merchant Account Suggestions We're in the midst of a revamp on the corporate site so some info is not very apparent, please checkout the faq for pricing info https://payment.firepay.com/surefire/ccs/reg/faq.jsp As for the setup fees...waived for cf-talk folks! (just be sure to give me a holler) Cheers, Stace _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 11:22 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Stacy, What is your credit card processing service priced out as? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:07 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Of course I'm biased but I'd have to disagree on that. ;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFHTTP Question!
Allan, What is the URL you need to type into a browser in order to run menu.asp? That is the URL you need to specify for using CFHTTP. (Remember when using CFHTTP it is the ColdFusion server running the request so the URL needs to be from the perspective of what the ColdFusion server can see the menu.asp page as which could mean using a 127.0.0.1 or localhost address since it is on the same server. Also, in general better to use IP addresses to avoid domain name resolution issues though you loose the obvious benefits.) André -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 16:01 To: CF-Talk Subject: CFHTTP Question! Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
sweet. I didn't know! thanks. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:31 AM To: CF-Talk Subject: RE: Merchant Account Suggestions We're in the midst of a revamp on the corporate site so some info is not very apparent, please checkout the faq for pricing info https://payment.firepay.com/surefire/ccs/reg/faq.jsp As for the setup fees...waived for cf-talk folks! (just be sure to give me a holler) Cheers, Stace _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 11:22 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Stacy, What is your credit card processing service priced out as? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:07 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Of course I'm biased but I'd have to disagree on that. ;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
We're in the midst of a revamp on the corporate site so some info is not very apparent, please checkout the faq for pricing info https://payment.firepay.com/surefire/ccs/reg/faq.jsp As for the setup fees...waived for cf-talk folks! (just be sure to give me a holler) Cheers, Stace _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 11:22 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Stacy, What is your credit card processing service priced out as? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:07 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Of course I'm biased but I'd have to disagree on that. ;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
It would have to do the search more than twice, it woudl have to do every possible case combination of either the string or the RE. I suspect that internally it just does a LOWER or UPPER on both the RE and the string. -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 8:15 AM To: CF-Talk Subject: RE: number of occurrences in a string. Wouldn't it be "faster" to use a Lower() on the string rather than REFindNoCase? I thought that doing a NoCase does the search twice, so on long strings, it could be slower... Just a thought [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 15:53 pm, Jochem van Dieten wrote: > > You don't have to be doing something stupid to trigger a trojon. > What would be a non-stupid way for an admin to trigger a trojan on his > server? DNS poisioning when you downloaded the patch file, for instance. On UNIX boxes, a local attacker could have altered an alias for a common command to fetch, compile and insert a Nasty kernel module and then waited for you to run that command. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
\b only on cfmx. As I said before, the array created will give you the number of subexpressions (2: the entire regexp and the subexpr (beg)) of the first match. In cf you need a loop. Try putting 3 beg's in your string. Pascal -Oorspronkelijk bericht- Van: Raymond Camden [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 17:01 Aan: CF-Talk CC: Onderwerp: RE: number of occurrences in a string. I'm not a regex guru, but what about using the \b boundry: This seems to work well. In a UDF you would just return the arrayLen of foo.pos. Does this seem right to others? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
I always assumed it said, match A or a, not search twice. I guess it depends on what is happening at the lowest level. I've never seen any recommendations in the past to not use findNoCase or reFindNocase (or etc). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 15:58 pm, Dave Watts wrote: > > You don't have to be doing something stupid to trigger a > > trojon. > I would classify unnecessary use of Administrator privileges as "something > stupid". But you don't have be doing something stupid (like unnecessary use of Administrator privileges) to be caught out. At some point you have to trust (say) your external DNS to really give you the real patch file you asked for, as oppsoed to Something Nasty. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Stacy, What is your credit card processing service priced out as? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:07 AM To: CF-Talk Subject: RE: Merchant Account Suggestions Of course I'm biased but I'd have to disagree on that. ;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Uh oh, my bad. I was talking about the old Allaire forums which went open-source. http://www.houseoffusion.com/forumspot Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:46 AM To: CF-Talk Subject: RE: CF Forum 2000 Help me out...are we talking about the following forum here??? http://www.cfcode.com/index.cfm/fuse/forumdetails.htm Let me know...Ché -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:43 AM To: CF-Talk Subject: RE: CF Forum 2000 Yes but. it looks nice. -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:35 AM To: CF-Talk Subject: RE: CF Forum 2000 Run, do not walk away from cfForums. It is a curse. It's one of the most poorly written applications I've seen. I've read every single line of code, and my god, it's junk. We had over 30 forums and it was slow and unresponsive. Not to mention debugging the application and/or integrating it is a feat in patience. The code is so disorganized and backasswards. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:19 AM To: CF-Talk Subject: RE: CF Forum 2000 Actually - if I remember correctly - CF Forums was never encrypted. So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a "oh, do we HAVE to!" budget and timeline. It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS> Hi all, RS> Has anyone here implemented a high volume site using CF FORUM 2000? RS> We have just inherited one, and am wondering how solid the code is. RS> Its a very busy forum, doing about 3 gigs of traffic per day, and its RS> started to show signs of breaking down, e.g. deadlock errors, RS> timeouts, "No more data available to read" errors. RS> Should I be looking for different forum software? Or re-write the code RS> myself? RS> Has anyone done an optimisation job on the CFFORUM code and can give a RS> few pointers on where the bottlenecks are? RS> thanks, bye! _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
Wouldn't it be "faster" to use a Lower() on the string rather than REFindNoCase? I thought that doing a NoCase does the search twice, so on long strings, it could be slower... Just a thought -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:02 AM To: CF-Talk Subject: RE: number of occurrences in a string. I'm not a regex guru, but what about using the \b boundry: This seems to work well. In a UDF you would just return the arrayLen of foo.pos. Does this seem right to others? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Benjamin S. Rogers said: >> Somebody wrote IP, network and MAC data types for PostgreSQL, > > And how far along are they in porting that to Windows? :) SRA and some others sell commercial versions, 7.2.1 is available as a free source distribution. >> including support for the big seven operators. So I could just >> use the IP datatype for SourceIP and everything would work >> automagically: > > That's pretty handy. Out of curiosity, does it also include > functions for selecting individual octets? If not, how about user > defined functions? That would make it useful for what we're doing. There isn't really code to select individual octets, but you could write something for it in any of the available procedural languages. But do you really want to select individual octets or is that just the workaround you use now? Because there are operators to check for subnet inclusion and functions to calculate broadcast address, network address etc from subnet definitions. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Of course I'm biased but I'd have to disagree on that. ;-) We provide easy CF integration including fully functional test accounts for our payment gateways. http://www.terrapayments.com (previously Surefire Commerce) Cheers! Stace _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: October 17, 2003 10:49 AM To: CF-Talk Subject: RE: Merchant Account Suggestions paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
Nope, I stand corrected, you still need to loop. But \b may be better than [^a-z]+. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Verity K2 Spider Missing Some Titles
On Thu, 16 Oct 2003 16:36:34 -0400, in cf-talk you wrote: >I'm using VK2 spider (bundled with the old CF5) to crawl a Web site. >Some indexed CFM pages are returning titles, while others are not. >I've painstakingly compared "view-source" code from pages that do have >titles in the index, and those that don't: I can't find *any* common >element(s) in the code that might prevent a title from being >parsed/collected. > >Does anyone have any ideas as to what the problem/solution might be? Problem solved. Reluctant admission, but for posterity: Original problem was with HTML comments before the tag. This prevented title gathering. When these were removed, titles still weren't being collected, but this time, it was because IIS was pointing to an old codebase, and our comment removal hadn't been done there. Duh, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
I'm not a regex guru, but what about using the \b boundry: This seems to work well. In a UDF you would just return the arrayLen of foo.pos. Does this seem right to others? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFHTTP Question!
Hello everybody, I'm trying to call a .asp file from my coldfusion page using cfhttp and I keep getting errors. Both files are on the same server, just different folders under the site webroot. This should explain it: The ColdFusion file is in C:\Inetpub\wwwroot\myProject\pages\folder1\searchreport.cfm and the ASP file is in C:\Inetpub\wwwroot\myProject\site\includes\topmenu\folder2\menu.asp. Can somebody show me how to use cfhttp to call the asp file (menu.asp) in my coldfusion file (searchreport.cfm) Many Thanks Allan __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Traffic Analyzer
Hi Neil, Did you look at Statistex on CFTagStore.com by Shawn Wellman? http://www.cftagstore.com/index.cfm/page/viewtag/tagId/31 Regards, Dan. -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 15:19 To: CF-Talk Subject: CF Traffic Analyzer Hello folks... I am looking for a traffic analyzer that I can implement into our current site. Basically what we have is a template driven web site for our agent's which gives each of them their own personalized site. What I need to do is give them the ability to track visitors to their site and report on things like refers and keywords so that they can monitor who is linking to them and what search engines are bringing them visitors. If anyone has any idea where I could find some type of ColdFusion application that doses something like this please let me know. Not sure how involved this would be to build from scratch and I kind of have a time constraint. Any help would be appreciated. Thanks - Neal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL Server Administration
Sorry for the OT post, but I know plenty of people on here work with SQL Server. We're running SQL Server 7 that hosts a few large databases for internal use. One of them is Saleslogix, if any of you work with that. I was reassigning accounts (like 3500) from Saleslogix's administrator (which executes a big batch update), and that action makes that database unusuable for everyone else. My belief is there should be some way to balance this out, either by user or machine. Basically, I don't want the Administrator to ever push that database so hard that it's making it COMPLETELY unusuable for everyone else. I can accept slow down, and I can accept the Adminstrative things (like reassigning accounts) going slower. I can see where I can change the amount of memory SQL can consume, the number of processor threads, the windows priority settings, but nothing to limit a particular machine/user from gobbling up all the resources. I'm certainly no DBA, but was hoping someone might shed some light. Thanks for any help! --- Josh Remus Network Manager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
Thomas Chiverton said: > On Friday 17 Oct 2003 15:15 pm, Jochem van Dieten wrote: >> Who is running what as admin? If I log in as Admin and I do >> something stupid that gives problems. But how is somebody else >> going to run anything as admin that can replace kernel files? > > You don't have to be doing something stupid to trigger a trojon. What would be a non-stupid way for an admin to trigger a trojan on his server? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Antivirus software on web server
> You don't have to be doing something stupid to trigger a > trojon. I would classify unnecessary use of Administrator privileges as "something stupid". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
paypal by far is the easiest. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
> Somebody wrote IP, network and MAC data types for PostgreSQL, And how far along are they in porting that to Windows? :) > including support for the big seven operators. So I could just > use the IP datatype for SourceIP and everything would work > automagically: That's pretty handy. Out of curiosity, does it also include functions for selecting individual octets? If not, how about user defined functions? That would make it useful for what we're doing. > Since it is my understanding that you can't write your own > operators in MS SQL Server, I doubt this is going to fly. I don't know of a SQL Server equivalent functionality wise. Perhaps Yukon with C# will address this, though a multi-thousand dollar upgrade for an IP datatype would just be silly. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Help me out...are we talking about the following forum here??? http://www.cfcode.com/index.cfm/fuse/forumdetails.htm Let me know...Ché -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:43 AM To: CF-Talk Subject: RE: CF Forum 2000 Yes but. it looks nice. -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:35 AM To: CF-Talk Subject: RE: CF Forum 2000 Run, do not walk away from cfForums. It is a curse. It's one of the most poorly written applications I've seen. I've read every single line of code, and my god, it's junk. We had over 30 forums and it was slow and unresponsive. Not to mention debugging the application and/or integrating it is a feat in patience. The code is so disorganized and backasswards. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:19 AM To: CF-Talk Subject: RE: CF Forum 2000 Actually - if I remember correctly - CF Forums was never encrypted. So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a "oh, do we HAVE to!" budget and timeline. It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS> Hi all, RS> Has anyone here implemented a high volume site using CF FORUM 2000? RS> We have just inherited one, and am wondering how solid the code is. RS> Its a very busy forum, doing about 3 gigs of traffic per day, and its RS> started to show signs of breaking down, e.g. deadlock errors, RS> timeouts, "No more data available to read" errors. RS> Should I be looking for different forum software? Or re-write the code RS> myself? RS> Has anyone done an optimisation job on the CFFORUM code and can give a RS> few pointers on where the bottlenecks are? RS> thanks, bye! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 15:15 pm, Jochem van Dieten wrote: > Who is running what as admin? If I log in as Admin and I do something > stupid that gives problems. But how is somebody else going to run > anything as admin that can replace kernel files? You don't have to be doing something stupid to trigger a trojon. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Merchant Account Suggestions
Authorize.net is very easy to setup and use. -Original Message- From: Ricky Fritzsching [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:30 AM To: CF-Talk Subject: Merchant Account Suggestions I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Yes but. it looks nice. -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:35 AM To: CF-Talk Subject: RE: CF Forum 2000 Run, do not walk away from cfForums. It is a curse. It's one of the most poorly written applications I've seen. I've read every single line of code, and my god, it's junk. We had over 30 forums and it was slow and unresponsive. Not to mention debugging the application and/or integrating it is a feat in patience. The code is so disorganized and backasswards. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:19 AM To: CF-Talk Subject: RE: CF Forum 2000 Actually - if I remember correctly - CF Forums was never encrypted. So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a "oh, do we HAVE to!" budget and timeline. It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS> Hi all, RS> Has anyone here implemented a high volume site using CF FORUM 2000? RS> We have just inherited one, and am wondering how solid the code is. RS> Its a very busy forum, doing about 3 gigs of traffic per day, and its RS> started to show signs of breaking down, e.g. deadlock errors, RS> timeouts, "No more data available to read" errors. RS> Should I be looking for different forum software? Or re-write the code RS> myself? RS> Has anyone done an optimisation job on the CFFORUM code and can give a RS> few pointers on where the bottlenecks are? RS> thanks, bye! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Forum 2000
Run, do not walk away from cfForums. It is a curse. It's one of the most poorly written applications I've seen. I've read every single line of code, and my god, it's junk. We had over 30 forums and it was slow and unresponsive. Not to mention debugging the application and/or integrating it is a feat in patience. The code is so disorganized and backasswards. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:19 AM To: CF-Talk Subject: RE: CF Forum 2000 Actually - if I remember correctly - CF Forums was never encrypted. So no matter what version you have you should be able to dig in. My main issue with it is that the fundamental codebase for CF Forums was begun with CF 2.0 and was maintained on a "oh, do we HAVE to!" budget and timeline. It was a fine piece of software 5 or six years ago, but it's age is just too apparent now. Jim Davis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:04 AM To: CF-Talk Subject: Re: CF Forum 2000 Yes, maybe, and yes. :) If you are talking about rewriting it I assume you have the open source version. CF Forums main bottleneck is that it uses subqueries to generate the message counts. Get a lot of messages, or a lot of forums and it starts to blow a gasket. It's also been a while and there may be a new version out...so my experience may be outdated here. The key optimizations that needs to be done it start precalculating those topic totals, etc, remove all the looped over queries, then start in caching. In the end I was able to get a forum with 50! forums and over 75,000 messages displaying in sub 100ms times with a single user, before any db optimizations. Under load it did well...can't remember times though. -- mailto:[EMAIL PROTECTED] Friday, October 17, 2003, 12:21:35 AM, you wrote: RS> Hi all, RS> Has anyone here implemented a high volume site using CF FORUM 2000? RS> We have just inherited one, and am wondering how solid the code is. RS> Its a very busy forum, doing about 3 gigs of traffic per day, and its RS> started to show signs of breaking down, e.g. deadlock errors, RS> timeouts, "No more data available to read" errors. RS> Should I be looking for different forum software? Or re-write the code RS> myself? RS> Has anyone done an optimisation job on the CFFORUM code and can give a RS> few pointers on where the bottlenecks are? RS> thanks, bye! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
the for loop isn't right: 1. if it doesn't find a match, it continues looping 2. if there is a match, start will become greater than the string length 3. the word is not escaped for special chars in regexp 4. when the new start position is set, it isn't set to the right place (should be +Len(word)+2, but this isn't a problem, it is just not efficient). Look at the code I posted, I think it will be more efficient. Maybe the 4th attribute of REFindNoCase can be dropped and the length to add can be calculated from the original word before escaping. -Oorspronkelijk bericht- Van: Raymond Camden [mailto:[EMAIL PROTECTED] Verzonden: vr 17/10/2003 15:52 Aan: CF-Talk CC: Onderwerp: RE: number of occurrences in a string. What didn't look right about the function? It's working here. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Merchant Account Suggestions
I have a small business that I am doing an e-commerce application for and they are wanting to setup a merchant/gateway account for the website. I have not had any experience with setting up a this type of an account and I am wondering what are my options. Is there something that is not rather expensive that you have used? I am prepared for the monthly payments and %'s taken out, but there are just so many damn options. All suggestions are welcome. Thank you! --- Ricky Fritzsching [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Sorry about that. I was busy yesterday, but I saw a question that I thought I could provide one possible answer too so I rattle it off a couple of e-mails without looking back at the thread. And I didn't take offense to Jochem's quip: my apologies to Jochem if it seemed that way. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 4:45 PM To: CF-Talk Subject: RE: Sorting IP Addresses not for me :) im not the one lookin, it was , david delbridge. and don't mind jochem, I think that's just his brand of humor. although not very funny sometimes, its just jochem, and we deal. he is a db wizard. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 4:33 PM To: CF-Talk Subject: RE: Sorting IP Addresses > Sure. I would use: > > SELECT * > FROM SourceIPSpamCount > ORDER BY SourceIP > > But I don't use MS SQL Server ;-) I'm afraid that comment was lost on me? If you could give me a bit more information, perhaps I could come up with an equivalent in SQL Server for Tony. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Developing CF Code on a Linux Machine
On Friday 17 Oct 2003 15:07 pm, David Adams wrote: > What are the available CF code editors for Linux. I love HomeSite but I am > sure there is no market demand to port it over to Linux. Any comments? jEdit -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sorting IP Addresses
Well, performance is relative. However, it is a solution which overcomes a lack of native support for an IP data type and addresses Dave's requirement that "everything must happen in the query itself." As I said, this bit of code was excerpted and adapted from a DNSBL we run. We found that this chunk of code, when executing it against 150,000 records, was too slow to be used in real time DNS requests. The DNS requests would take about 5 seconds, which meant that our SMTP banner would take just as long to appear. There is actually a good deal more going on, but that's the gist of it. Our solution was to convert the query to a view. A scheduled task runs every 15 minutes and populates a table from the view. Now, DNS requests take milliseconds and the SMTP banner appears almost immediately. So, for us, performance was an issue, but we did not have similar requirements to Dave. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 4:35 AM To: CF-Talk Subject: Re: Sorting IP Addresses That sounds like it could perform poorly, would it? - Calvin - Original Message - From: Benjamin S. Rogers To: CF-Talk Sent: Thursday, October 16, 2003 4:38 PM Subject: RE: Sorting IP Addresses > that doesn't work perfectly. > > 166.141.22.4 > 166.141.22.40 > 166.141.22.41 > 166.141.22.47 > 166.141.22.48 > 166.141.22.5 Sorry about that. I forgot to convert the substrings to integers. Try this: SELECT * FROM SourceIPSpamCount ORDER BY CONVERT(INT, SUBSTRING(SourceIP, 1, CHARINDEX('.', SourceIP) - 1)), CONVERT(INT, SUBSTRING(SourceIP, CHARINDEX('.', SourceIP) + 1,CHARINDEX('.', SourceIP, CHARINDEX('.', SourceIP) + 1) - CHARINDEX('.', SourceIP) - 1)), CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), CHARINDEX('.', REVERSE(SourceIP)) + 1, CHARINDEX('.', REVERSE(SourceIP), CHARINDEX('.', REVERSE(SourceIP)) + 1) - CHARINDEX('.', REVERSE(SourceIP)) - 1))), CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), 1, CHARINDEX('.', REVERSE(SourceIP)) - 1))) Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Developing CF Code on a Linux Machine
> What are the available CF code editors for Linux. I use JEdit: http://www.jedit.org/ You could also try Eclipse: http://www.eclipse.org/ Tim. PS. Vi rocks! :) --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Traffic Analyzer
Hello folks... I am looking for a traffic analyzer that I can implement into our current site. Basically what we have is a template driven web site for our agent's which gives each of them their own personalized site. What I need to do is give them the ability to track visitors to their site and report on things like refers and keywords so that they can monitor who is linking to them and what search engines are bringing them visitors. If anyone has any idea where I could find some type of ColdFusion application that doses something like this please let me know. Not sure how involved this would be to build from scratch and I kind of have a time constraint. Any help would be appreciated. Thanks - Neal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
Thomas Chiverton said: > On Friday 17 Oct 2003 14:32 pm, Jochem van Dieten wrote: >> Administrators are only allowed to do an interactive login. How >> many of those can there be at the same time? > > But any programs they run are now running as admin... you only solve > some problems by enforcing this. Who is running what as admin? If I log in as Admin and I do something stupid that gives problems. But how is somebody else going to run anything as admin that can replace kernel files? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Linux Newbie
On Thursday 16 Oct 2003 21:37 pm, Nathan Strutz wrote: > a boot manager like grep grub -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Query
The dataset is fairly small .. I doubt it would be over a few hundred records for awhile .. and in a few years maybe up to 2000, so I don't think it will be a huge ordeal. Thanks in advance, I will give it a try! Paul Giesenhagen QuillDesign - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Friday, October 17, 2003 3:56 AM Subject: Re: OT: SQL Query Paul Giesenhagen said: > > I have a number of reports all dated, but dated by day (no time). > Some of the reports are on the same day If I have an ID value, I > need to grab the report before and the report after that ID and it > needs to be by date. > > Here is what the data looks like: > > ReportID | ReportDate | Report | > 19/10/2003 > 29/11/2003 > 39/11/2003 > 49/11/2003 > 59/12/2003 > 89/12/2003 > 99/14/2003 > 1110/01/2003 etc.. > > If I am looking at ReportID (5), then I want to know that reportID 4 > is previous and reportID 8 is next > > So my output should be > Previous = 4 > This > > Next = 8 > > Oh, and I need to know if previous is Nothing or Next is nothing (ie > there isn't anymore eitherway). It won't be evry fast, but should be acceptable if the dataset isn't too large. The preliminary resultsets need to be limited to one row, the code for that is between square brackets (database dependent). ( SELECT [TOP 1] * FROM table WHERE ReportDate > (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate, ID [LIMIT 1] UNION SELECT * FROM table WHERE ID = 5) UNION SELECT [TOP 1] * FROM table WHERE ReportDate < (SELECT ReportDate FROM table WHERE ID = 5) ORDER BY ReportDate DESC, ID DESC [LIMIT 1] ) ORDER BY ReportDate Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Antivirus software on web server
On Friday 17 Oct 2003 14:32 pm, Jochem van Dieten wrote: > Administrators are only allowed to do an interactive login. How many > of those can there be at the same time? But any programs they run are now running as admin... you only solve some problems by enforcing this. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Programmatically set debug options
FuseBox 4 supports a "Developer" switch. Then when you complete you turn the switch to "Production". [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Developing CF Code on a Linux Machine
What are the available CF code editors for Linux. I love HomeSite but I am sure there is no market demand to port it over to Linux. Any comments? Using VI is not the answer I am looking for. ;) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: number of occurrences in a string.
What didn't look right about the function? It's working here. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7.x and CFSTOREDPROC
Kris Pilles said: > I have outputted the variables on the page so I can see them it > is the weirdest thing works fine in IE but not NS Does it work from telnet? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Netscape 7.x and CFSTOREDPROC
I ficed it... had NO-CACHE on the action page... seems to have corrected thr problems by removing it -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:47 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC that's odd...i cant imagine how a browser could dictate how cf stuff runs on the server...apart from the data it sends to it ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:42 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC I have outputted the variables on the page so I can see them it is the weirdest thing works fine in IE but not NS -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:39 AM To: CF-Talk Subject: RE: Netscape 7.x and CFSTOREDPROC have you/can you verify the data that is getting passed to the cfstoredproc. browser shouldn't matter apart from the data getting to the cfstored proc. form driven data? url driven data? id look there. cf is server side, so it shouldn't matter ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 9:38 AM To: CF-Talk Subject: Netscape 7.x and CFSTOREDPROC Ok... This is kind of odd... I have a CFSTOREDPROC that works fine with IE but when we try to call it with Netscape 7.X it crashed... Has anyone else had this sort of problem?? Anyone have any ideas as to how to fix this? Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 6.0 & 6.1 on same machine?
One other option I forgot to mention is that you can install CFMX 6.0 and CFMX 6.1 on the same machine at the same time as long as you don't run both of them at the same time. You will have issues with ODBC services as there is a registry reference to the DLL that needs to be changed every time you switch from 6.0 to 6.1 (which can be done with reg/bat files). I had CFMX 6.1 installed on my laptop like this before moving fully to 6.1. Best regards, Sam -- Blog: http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]