Re: Anybody have exerience with KickAssVPS.com?
> It makes sense to me that a VPS would only be getting > a part of the processing potential of whatever processor > it's running on...is the quad-core different? Could I be > getting an entire "core" to myself of the "quad"? > > Or is it not necessarily true that a slice of a quad core > beats a slice of a Pentium 4? A "slice" is not a consistent unit of measurement. Would you rather have half of an 8" pizza, or an eighth of a 12" pizza? They're both slices. If I were a hosting provider, I'd be able to put more customers on a bigger machine than a smaller one. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anybody have exerience with KickAssVPS.com?
>>As a KAVPS user looking for other providers (note the looking for other providers part...), I would highly recommend you stay away from them. Dear Anon ymous, If you put ANYTHING of consequence on a VPS for $25-35/mo. you have simply gotten what you paid for. You get what you pay for. Especially with hosting. If you put mission critical apps on an economy VPS or Dedicated provider with out fail over you only have yourself to blame. Your options with engineering: Good Cheap Fast Your options with hosting: Support price features In either case: Pick 2 Sorry... but complaining about support for a super cheap hosting plan is like complaining about water being wet. If you want a VPS or Dedicated server that NEEDS to be five nines? Be prepared to pay for it. In the same breath... I have had my blog, other sites, and staging server on KAVPS with no noticeable down time or emails relating to such (as in none) for nearly a year. I was in the hosting biz for years so I take issue with Annon pot shots. Just saying G! On Sat, Aug 9, 2008 at 4:04 PM, Anon ymous -- Gerald Guido http://www.myinternetisbroken.com "To invent, you need a good imagination and a pile of junk." -- Thomas A. Edison ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: [JavaScript] Getting Parent
try: parent.top.location.href Andrew. >Hi All, > > > >I have a page that loads a modal popup using ShowModalDialog. To get around >issues with submitting data inside a modal dialog, I have an iframe to >handle posts within in the modal dialog. > > > >The popup gets triggered two minutes before the session is about to timeout. >They assume that if you don't click the ok button in the popup within 2 >minutes you have walked away from your station and want to log you out. To >handle this the popup starts a two minute count down and if timer reaches 0 >then the page calls itself to kill the session (since the act of loading the >popup resets the session timer) and needs to redirect the parent page to the >login page. > > > >The redirect is where I am having a problem. I have tried >window.opener.location.href, top.location.href, top.parent.location.href, >and parent.window.location.href. > > > >Can someone point me in the correct direction? > > > >Thanks, > >Duane > >Sandy Bay Networks - www.sandybay.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anybody have exerience with KickAssVPS.com?
I ended up getting a dedicated server from CFDynamics, the $189 a month dedicated package. CF was included in the price as was a shared SQL server. While it isn't a particulary fast machine (not a quad core p4), since I have it all to myself, it runs like a champ. I have had it running for 2 years now without a single issue. It functions as the web server, mail server, and ftp server and since the CF and SQL are included in the price, it was the perfect match for me. While I dont have a VPS with HMS, we do have a couple dedicated VM machines there as well. The setup took longer than we were anticipating but support has been very good when needed. And for these servers, we moved from a CF7/SQL 2000 environment to a CF8/SQL 2005 environment and the performance improvement with that on the new HMS hardware was amazing. Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sessions in FB 5.5.x
I've been trying to make my app establish a user session. I put my user validation code in my controller's prefuseaction: select role from v_users where oprid = '#theusername#' and isInactive is null; That doesn't seem to work - when I do a debug cfoutput in my welcome view: #GetAuthUser()# / #len(session.username)# I get a username for my first value but a zero for my 2nd. Ideas? tia, - Joe ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Syntax error
worked for me. Plus, that is what Adobe shows in their docs. 2009/3/16 Jason Fisher : > > Interesting ... COUNT(DISTINCT prodcode) will work, huh? That may come in > handy some day. Thanks! > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Syntax error
COUNT(DISTINCT [fieldName] is very important to remember when using JOINS. For example, if you have the query... SELECT COUNT(A.code) AS total FROM TableA A INNER JOIN TableB ON A.code = B.code And you wanted to know how many records in TableA have records in TableB. If this query returns 10 records, there may only be 3 DISTINCT records returned from TableA. If you use COUNT(A.code) as written above, the result will be 10. If you change it to COUNT(DISTINCT A.code), you will get your desired answer of 3. >Interesting ... COUNT(DISTINCT prodcode) will work, huh? That may come in >handy some day. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Syntax error
Interesting ... COUNT(DISTINCT prodcode) will work, huh? That may come in handy some day. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Syntax error
Thanks. I found it finally. The right syntax (for this issue) is select count(distinct prodcode) as prodcnt There was a second issue with computed_field_1 the was being bounced by the ODBC driver as well. On Mon, Mar 16, 2009 at 3:54 PM, Jason Fisher wrote: > > This is invalid: > > distinct(count prodcode) > > Are you trying to do a DISTINCT on the aggregate function COUNT()? > > Not sure that would work, but it would have to be DISTINCT COUNT(prodcode) > if that's what you're after. > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: SQL Syntax error
This is invalid: distinct(count prodcode) Are you trying to do a DISTINCT on the aggregate function COUNT()? Not sure that would work, but it would have to be DISTINCT COUNT(prodcode) if that's what you're after. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Syntax error
Can anyone point me to the error in this code and the generated query? I am kind of stuck right now as it all looks ok to me. Thanks --S ^ [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "prodcode) from product where product.man" (10713) The error occurred in C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 189 : not variables.stError.v008.occurred> 190 : AND product.famcode = '#scan.famcode#' ) 191 : 192 : 193 : SQLselect distinct(count prodcode) from product where product.manufid = '030030' AND product.famcode2 = '111' and product.famcode > '000' and product.prodcode not in (select prodcode from product where manufid='030030' AND product.famcode = '111' ) -- Jean Anouilh - "What you get free costs too much." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Syntax error
I forgot the code snippet. select distinct(count prodcode) from product where product.manufid = '#scan.manufid#' AND product.famcode2 matches '#left(scan.famcode, 2)#.' ANDproduct.famcode2 matches '#left(scan.famcode,1)#..' AND product.famcode2 = '#scan.famcode#' and product.famcode > '000' and product.prodcode not in (select prodcode from product where manufid='#scan.manufid#' and product.famcode matches '#left(scan.famcode, 2)#.') and product.famcode matches '#left(scan.famcode,1)#..') ) AND product.famcode = '#scan.famcode#' ) On Mon, Mar 16, 2009 at 3:45 PM, Steve Lichtenberg wrote: > Can anyone point me to the error in this code and the generated query? > I am kind of stuck right now as it all looks ok to me. > > Thanks > --S > ^ > > > [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC > Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL > statement at or about "prodcode) from product where product.man" > (10713) > > The error occurred in > C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 > Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 > Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 > Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 > Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 > Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 > Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 > Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 > > 189 : not variables.stError.v008.occurred> > 190 : AND product.famcode = '#scan.famcode#' ) > 191 : > 192 : > 193 : > > SQLselect distinct(count prodcode) from product where > product.manufid = '030030' AND product.famcode2 = '111' and > product.famcode > '000' and product.prodcode not in (select prodcode > from product where manufid='030030' AND product.famcode = '111' ) > > -- > > Jean Anouilh - "What you get free costs too much." > -- Jean Anouilh - "What you get free costs too much." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
[JavaScript] Getting Parent
Hi All, I have a page that loads a modal popup using ShowModalDialog. To get around issues with submitting data inside a modal dialog, I have an iframe to handle posts within in the modal dialog. The popup gets triggered two minutes before the session is about to timeout. They assume that if you don't click the ok button in the popup within 2 minutes you have walked away from your station and want to log you out. To handle this the popup starts a two minute count down and if timer reaches 0 then the page calls itself to kill the session (since the act of loading the popup resets the session timer) and needs to redirect the parent page to the login page. The redirect is where I am having a problem. I have tried window.opener.location.href, top.location.href, top.parent.location.href, and parent.window.location.href. Can someone point me in the correct direction? Thanks, Duane Sandy Bay Networks - www.sandybay.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Anybody have exerience with KickAssVPS.com?
Virtually every site I have running on it does image creation/ manipulation. Upload, rename, resize, create multiple sizes, etc. I'm doing all that with cffile and cfimage. Speed seems fine. I haven't done any actual speed tests to compare. Speed for me is not much of an issue, since virtually all of my image handling is done in my clients' site managers, where speed is not as critical as in the user interface. Rick > -Original Message- > From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] > Sent: Monday, March 16, 2009 12:16 PM > To: cf-talk > Subject: RE: Anybody have exerience with KickAssVPS.com? > > > Doing any PDF or image creation/manipulation? If so how are you finding > it > for speed? > > Adrian > > > -Original Message- > > From: Rick Faircloth [mailto:r...@whitestonemedia.com] > > Sent: 16 March 2009 16:04 > > To: cf-talk > > Subject: RE: Anybody have exerience with KickAssVPS.com? > > > > > > I've kinda lost track of who I'm responding to...did you just > > reply to this to get the topic back in the loop, Mike? I didn't > > see any comments by you below. I assume that means you're just > > re-asking the question does anyone have any experience with > > KickAssVPS.com. > > > > If so, I've had about 9 months experience with them now and not a > > single problem at all...not billing issues, no server downtime (that > > wasn't announced...and a good thing is that when a planned upgrade > > didn't go smoothly, instead of continuing to keep the system down > while > > they tried to work out the issue, the downgraded and got the system > > back > > up immediately), no server problems at all. Nice support staff. > > Worked > > with me to get a special configuration of services I wanted included > > and > > some I didn't want taken out of the configuration...and adjust the > > price > > accordingly to make it a good deal. > > > > Check out their offerings and don't hesitate to request changes to > the > > "stock" configurations. Also, they were running a 2GB Mem special > for > > the > > price of one when I got my server, which helps. But I've never had > any > > slow server issues. And except for initial software setup and > > configuration, > > I've never even had to reboot the server! Smooth as silk. > > > > Can't recommend them highly enough! I have no vested interest, just > a > > very > > satisfied customer. I tried at least two other companies before > trying > > KickAssVPS.com and have never looked back. > > > > As far as I remember, with remoting into the server: > > > > - Win 2003 Server > > - Running MySQL 5 > > - ColdFusion 8 > > - Plesk was part of the pack, but I don't allow customer access to > the > > server, > > so I had it uninstalled > > - MSSQL is available, but I don't use it > > > > I can't think of anything else, but I'm completely satisfied. Feel > > free to > > ask > > about more specifics if you need them. > > > > Rick > > > > PS - and from Jochems remarks awhile back, you do just get a "slice" > of > > a > > quad-core > > Pentium, but that beats a "slice" of a Pentium 4! > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anybody have exerience with KickAssVPS.com?
Can you explain, Dave? It makes sense to me that a VPS would only be getting a part of the processing potential of whatever processor it's running on...is the quad-core different? Could I be getting an entire "core" to myself of the "quad"? Or is it not necessarily true that a slice of a quad core beats a slice of a Pentium 4? What part are your referring to? Rick > -Original Message- > From: Dave Watts [mailto:dwa...@figleaf.com] > Sent: Monday, March 16, 2009 12:18 PM > To: cf-talk > Subject: Re: Anybody have exerience with KickAssVPS.com? > > > > PS - and from Jochems remarks awhile back, you do > > just get a "slice" of a quad-core Pentium, but that beats > > a "slice" of a Pentium 4! > > That is not necessarily true. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sort database records as a human not a computer.
Check out the SQL PATINDEX function. In combination with SUBSTRING and
REPLACE, you could retrieve a column that omits the leading words and then
ORDER BY that column.
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Monday, March 16, 2009 9:27 AM
To: cf-talk
Subject: Sort database records as a human not a computer.
With SQLServer (2000 I believe) if that matters, which it may well.
I have a data column that contains titles. I desire the titles to be
sorted alphabetically as a human would not a computer. The records I'm
currently concerned with start with a quote (") and need to start with a
quote. Ideally I would like the records sorted with these records
placed in order by the first letter inside the quotes like a human
librarian would not to the top of the list as a computer does it. Since
I'm wishing for this, it would be really cool if the sort also ignored
the other human librarian no goes 'a', 'an' and 'the' that are supposed
to be ignored at the beginning of titles when sorting.
Luckily this is a very minor requirement and can be ignored if there is
not is not a simple solution out there, but I also can't believe I am
the first programmer that needed to do this with database data, so maybe
the functionality already exists.
TIA
Ian
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320549
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: bean? anything wrong?
Your default is an empty string. Set the default to 0. ~Lori -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Monday, March 16, 2009 12:42 PM To: cf-talk Subject: bean? anything wrong? Sorry for the long post but I've been working on this for a few days and have got nowhere I'm working with flex and cf and I have a bean.. it looks okay but just testing it with an init() function is giving me an error The argument HEADLINE_ID passed to function init() is not of type numeric I'm not passing headline_id to the init() function... the code in the .cfm is simple it's just a createobject call to the cfc.. and here's the bean... there's another bean in another directory set up almost exactly the same way and I can init that bean with no error. variables.instance = StructNew(); variables.instance.headline_id = 0; variables.instance.headline = ""; variables.instance.actiondate = ""; variables.instance.effdate = ""; variables.instance.endeffdate = ""; variables.instance.actionuser = ""; ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any Denver/Boulder events??
On Mon, Mar 16, 2009 at 1:54 PM, Richard Dillman wrote: > > I and the wife have some family obligations in Denver Co from March 23rd > Through > April 4nd. That being said we should have lots of free time in the > evening/weekend and are hoping to hop into some conferences, seminars, > classes or > even a meet-up group or two. I am big into ColdFusion, CSS, SEO, OOP ; she > is > more into growing the business and making some forays into web design so we > run > the gamut. > > Ive been googling but most events are either upcoming or will have just > passed, > so please if you know of any event during that time in the Denver/Boulder > area we > would love to hear about it! > Want to go clubbing? I don't live in Denver anymore but this joint is a nice place to get down and Tribal Touch is wicked! * DJ Tribal Touch* * 03-26-2009 21:00 at The Church Nightclub 11th & lincoln, Denver, Colorado 80203 Cost: 0* Ill be spinning at The Church Nightclub every Thursday night so stop by & say Hello!! Drop "Im on Tribals List" at the door for VIP Access ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Any Denver/Boulder events??
I and the wife have some family obligations in Denver Co from March 23rd Through April 4nd. That being said we should have lots of free time in the evening/weekend and are hoping to hop into some conferences, seminars, classes or even a meet-up group or two. I am big into ColdFusion, CSS, SEO, OOPâ¦; she is more into growing the business and making some forays into web design so we run the gamut. Iâve been googling but most events are either upcoming or will have just passed, so please if you know of any event during that time in the Denver/Boulder area we would love to hear about it! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: bean? anything wrong?
never mind, the other bean uses string for everything.. so my problem isnt in the bean On Mon, Mar 16, 2009 at 11:42 AM, Greg Morphis wrote: > Sorry for the long post but I've been working on this for a few days > and have got nowhere > I'm working with flex and cf and I have a bean.. it looks okay but > just testing it with an init() function is giving me an error > The argument HEADLINE_ID passed to function init() is not of type numeric > > I'm not passing headline_id to the init() function... > the code in the .cfm is simple it's just a createobject call to the cfc.. > > > > and here's the bean... there's another bean in another directory set > up almost exactly the same way and I can init that bean with no error. > > > > > > > > > > > variables.instance = StructNew(); > variables.instance.headline_id = 0; > variables.instance.headline = ""; > variables.instance.actiondate = ""; > variables.instance.effdate = ""; > variables.instance.endeffdate = ""; > variables.instance.actionuser = ""; > > > returntype="path.to.my.cfc.headlines"> > default="" /> > default="" /> > default="" /> > default="" /> > default="" /> > default="" /> > > > > > > > > > > > > > returntype="arc_headlines" output="false"> > > > > > output="false" > > > > > > returntype="void"> > > > > returntype="numeric"> > > > returntype="void"> > > > > returntype="string"> > > > returntype="void"> > > > > returntype="date"> > > > returntype="void"> > > > > returntype="date"> > > > returntype="void"> > > > > returntype="date"> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sort database records as a human not a computer.
I would agree with Brian and Claude on adding the column for sorting. It would be easy enough to adjust your INSERT / UPDATE calls to auto-create the sort version, like this: UPDATE ... SET title = , sortTitle = WHERE ID = ... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
bean? anything wrong?
Sorry for the long post but I've been working on this for a few days and have got nowhere I'm working with flex and cf and I have a bean.. it looks okay but just testing it with an init() function is giving me an error The argument HEADLINE_ID passed to function init() is not of type numeric I'm not passing headline_id to the init() function... the code in the .cfm is simple it's just a createobject call to the cfc.. and here's the bean... there's another bean in another directory set up almost exactly the same way and I can init that bean with no error. variables.instance = StructNew(); variables.instance.headline_id = 0; variables.instance.headline = ""; variables.instance.actiondate = ""; variables.instance.effdate = ""; variables.instance.endeffdate = ""; variables.instance.actionuser = ""; ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sort database records as a human not a computer.
I'm with Claude on this one, your best bet it probably to generate another column such as sortTitle that you can then sort on. On Mon, Mar 16, 2009 at 11:39 AM, Claude Schneegans < schneeg...@internetique.com> wrote: > > >>but you can use string > manipulation functions in the ORDER BY clause to sort your data. > > That would prevent the query from using an index, and it may have some > impact on performance. > > An alternative would be to apply these functions once for all on the > titles, > store the result in an extra column and ORDER BY this column. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anybody have exerience with KickAssVPS.com?
Doing any PDF or image creation/manipulation? If so how are you finding it for speed? Adrian > -Original Message- > From: Rick Faircloth [mailto:r...@whitestonemedia.com] > Sent: 16 March 2009 16:04 > To: cf-talk > Subject: RE: Anybody have exerience with KickAssVPS.com? > > > I've kinda lost track of who I'm responding to...did you just > reply to this to get the topic back in the loop, Mike? I didn't > see any comments by you below. I assume that means you're just > re-asking the question does anyone have any experience with > KickAssVPS.com. > > If so, I've had about 9 months experience with them now and not a > single problem at all...not billing issues, no server downtime (that > wasn't announced...and a good thing is that when a planned upgrade > didn't go smoothly, instead of continuing to keep the system down while > they tried to work out the issue, the downgraded and got the system > back > up immediately), no server problems at all. Nice support staff. > Worked > with me to get a special configuration of services I wanted included > and > some I didn't want taken out of the configuration...and adjust the > price > accordingly to make it a good deal. > > Check out their offerings and don't hesitate to request changes to the > "stock" configurations. Also, they were running a 2GB Mem special for > the > price of one when I got my server, which helps. But I've never had any > slow server issues. And except for initial software setup and > configuration, > I've never even had to reboot the server! Smooth as silk. > > Can't recommend them highly enough! I have no vested interest, just a > very > satisfied customer. I tried at least two other companies before trying > KickAssVPS.com and have never looked back. > > As far as I remember, with remoting into the server: > > - Win 2003 Server > - Running MySQL 5 > - ColdFusion 8 > - Plesk was part of the pack, but I don't allow customer access to the > server, > so I had it uninstalled > - MSSQL is available, but I don't use it > > I can't think of anything else, but I'm completely satisfied. Feel > free to > ask > about more specifics if you need them. > > Rick > > PS - and from Jochems remarks awhile back, you do just get a "slice" of > a > quad-core > Pentium, but that beats a "slice" of a Pentium 4! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anybody have exerience with KickAssVPS.com?
> PS - and from Jochems remarks awhile back, you do > just get a "slice" of a quad-core Pentium, but that beats > a "slice" of a Pentium 4! That is not necessarily true. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Anybody have exerience with KickAssVPS.com?
I've kinda lost track of who I'm responding to...did you just reply to this to get the topic back in the loop, Mike? I didn't see any comments by you below. I assume that means you're just re-asking the question does anyone have any experience with KickAssVPS.com. If so, I've had about 9 months experience with them now and not a single problem at all...not billing issues, no server downtime (that wasn't announced...and a good thing is that when a planned upgrade didn't go smoothly, instead of continuing to keep the system down while they tried to work out the issue, the downgraded and got the system back up immediately), no server problems at all. Nice support staff. Worked with me to get a special configuration of services I wanted included and some I didn't want taken out of the configuration...and adjust the price accordingly to make it a good deal. Check out their offerings and don't hesitate to request changes to the "stock" configurations. Also, they were running a 2GB Mem special for the price of one when I got my server, which helps. But I've never had any slow server issues. And except for initial software setup and configuration, I've never even had to reboot the server! Smooth as silk. Can't recommend them highly enough! I have no vested interest, just a very satisfied customer. I tried at least two other companies before trying KickAssVPS.com and have never looked back. As far as I remember, with remoting into the server: - Win 2003 Server - Running MySQL 5 - ColdFusion 8 - Plesk was part of the pack, but I don't allow customer access to the server, so I had it uninstalled - MSSQL is available, but I don't use it I can't think of anything else, but I'm completely satisfied. Feel free to ask about more specifics if you need them. Rick PS - and from Jochems remarks awhile back, you do just get a "slice" of a quad-core Pentium, but that beats a "slice" of a Pentium 4! > -Original Message- > From: Mike Aushana [mailto:mi...@madwebdesigns.ca] > Sent: Monday, March 16, 2009 12:43 PM > To: cf-talk > Subject: Re: Anybody have exerience with KickAssVPS.com? > > > >Rick Faircloth wrote: > >> Hmmm... let me look at ServerPronto's site... > >> > >> - Intel Pentium 4, 3 GHz (as opposed to a Quad Core Pentium) > > > >You don't get a quad core pentium, you get a time-slice off a quad > core > >pentium. > > > > > >> - Only 6 email support tickets per month ($15 each for extra!) > >> - 6 reboots ($29 each for extra!) > > > >If either of those isn't enough, you shouldn't be running a server in > >the first place. > > > > > >> - Windows 2003 Server - $26 per month (incl with KAVPS) > > > >You never mentioned Windows was a requirement :) > > > > > >> - MSSQL 2005 Standard - $99 per month (incl with KAVPS) > > > >You have sufficient diskspace and RAM to install MSSQL 2005 Express on > >your own server. And I think the 1 GB space allotment isn't much with > KAVPS. > > > > > >> - Plesk for 100 Domains - $40 per month (incl with KAVPS) > > > >Why would you need this? You have the root password. > > > > > >> Am I looking at this correctly? > > > >I find both options a bit fuzzy on the details of backup and restore. > > > >All our SLA's for dedicated hosting include a provision that the > client > >can ask us once every X months to proof that our backup procedures are > >correct by performing a restore within the response time from the SLA. > >Doing that is a great way to make sure your procedures are correct. > With > >whatever plan you choose you should probably factor in the time and > cost > >of a trial run of restoring just a database and the entire server. > > > >Jochem > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anybody have exerience with KickAssVPS.com?
>Rick Faircloth wrote: >> Hmmm... let me look at ServerPronto's site... >> >> - Intel Pentium 4, 3 GHz (as opposed to a Quad Core Pentium) > >You don't get a quad core pentium, you get a time-slice off a quad core >pentium. > > >> - Only 6 email support tickets per month ($15 each for extra!) >> - 6 reboots ($29 each for extra!) > >If either of those isn't enough, you shouldn't be running a server in >the first place. > > >> - Windows 2003 Server - $26 per month (incl with KAVPS) > >You never mentioned Windows was a requirement :) > > >> - MSSQL 2005 Standard - $99 per month (incl with KAVPS) > >You have sufficient diskspace and RAM to install MSSQL 2005 Express on >your own server. And I think the 1 GB space allotment isn't much with KAVPS. > > >> - Plesk for 100 Domains - $40 per month (incl with KAVPS) > >Why would you need this? You have the root password. > > >> Am I looking at this correctly? > >I find both options a bit fuzzy on the details of backup and restore. > >All our SLA's for dedicated hosting include a provision that the client >can ask us once every X months to proof that our backup procedures are >correct by performing a restore within the response time from the SLA. >Doing that is a great way to make sure your procedures are correct. With >whatever plan you choose you should probably factor in the time and cost >of a trial run of restoring just a database and the entire server. > >Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sort database records as a human not a computer.
>>but you can use string manipulation functions in the ORDER BY clause to sort your data. That would prevent the query from using an index, and it may have some impact on performance. An alternative would be to apply these functions once for all on the titles, store the result in an extra column and ORDER BY this column. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sort database records as a human not a computer.
Ian, you could do something like this...
select * from footest
order by (case when title like '"%' then substr(title, 2, length(title))
when title like 'a %' then substr(title, 3, length(title))
when title like 'an %' then substr(title, 4, length(title))
when title like 'the %' then substr(title, 5, length(title))
else title end)
But if you get a bunch of records I'd suggest an "orderTitle" column
like suggested prior
On Mon, Mar 16, 2009 at 9:39 AM, Dawson, Michael wrote:
>
> I'm not sure if I follow you, completely, but you can use string
> manipulation functions in the ORDER BY clause to sort your data. For
> example, you can use the replace function to remove quotes, for sorting.
>
> Thanks,
> Mike
>
> -Original Message-
> From: Ian Skinner [mailto:h...@ilsweb.com]
> Sent: Monday, March 16, 2009 9:27 AM
> To: cf-talk
> Subject: Sort database records as a human not a computer.
>
>
> With SQLServer (2000 I believe) if that matters, which it may well.
>
> I have a data column that contains titles. I desire the titles to be
> sorted alphabetically as a human would not a computer. The records I'm
> currently concerned with start with a quote (") and need to start with a
> quote. Ideally I would like the records sorted with these records
> placed in order by the first letter inside the quotes like a human
> librarian would not to the top of the list as a computer does it. Since
> I'm wishing for this, it would be really cool if the sort also ignored
> the other human librarian no goes 'a', 'an' and 'the' that are supposed
> to be ignored at the beginning of titles when sorting.
>
> Luckily this is a very minor requirement and can be ignored if there is
> not is not a simple solution out there, but I also can't believe I am
> the first programmer that needed to do this with database data, so maybe
> the functionality already exists.
>
> TIA
> Ian
>
>
>
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320536
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) FTP and the ports it uses for data.
Scott Stewart wrote: > FTP typically uses port 21. For the control commands and another port for the data. http://en.wikipedia.org/wiki/File_Transfer_Protocol ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) FTP and the ports it uses for data.
FTP typically uses port 21. -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Monday, March 16, 2009 10:37 AM To: cf-talk Subject: (ot) FTP and the ports it uses for data. HISTORY|BACKGROUND I am in the process of reworking a ColdFusion and Oracle 11g application. At one point this application sends some files it generates to another server with FTP. For various reasons, the FTP is being done with the Oracle database management system. Thus we are running into the 'ACL' Access Control List security feature that is new to Oracle 11g. If you are unfamiliar with this feature, Oracle 11g now blocks all HTTP, SMTP and FTP access to any other servers from PL/SQL code unless a ACL entry is created that defines what user can connect to what server with what protocol to what port range. A pretty cool concept actually as it really locks down the server so that it can only do what the developer wants it to do without completely giving up these occasionally very useful protocols. PROBLEM The trouble we are having is what ports are used for the FTP data transfer. These ports need to be defined in the ACL otherwise the process will be blocked by Oracle, but as far as we can tell just about any of the 65,000+ ports can be used for data transfer. I am unfamiliar with FTP server administration so how can one determine or define what range of ports can be used for data transfers? TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sort database records as a human not a computer.
I'm not sure if I follow you, completely, but you can use string
manipulation functions in the ORDER BY clause to sort your data. For
example, you can use the replace function to remove quotes, for sorting.
Thanks,
Mike
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Monday, March 16, 2009 9:27 AM
To: cf-talk
Subject: Sort database records as a human not a computer.
With SQLServer (2000 I believe) if that matters, which it may well.
I have a data column that contains titles. I desire the titles to be
sorted alphabetically as a human would not a computer. The records I'm
currently concerned with start with a quote (") and need to start with a
quote. Ideally I would like the records sorted with these records
placed in order by the first letter inside the quotes like a human
librarian would not to the top of the list as a computer does it. Since
I'm wishing for this, it would be really cool if the sort also ignored
the other human librarian no goes 'a', 'an' and 'the' that are supposed
to be ignored at the beginning of titles when sorting.
Luckily this is a very minor requirement and can be ignored if there is
not is not a simple solution out there, but I also can't believe I am
the first programmer that needed to do this with database data, so maybe
the functionality already exists.
TIA
Ian
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320533
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sort database records as a human not a computer.
If you'd like to keep things simple, create a new column and enter the title
as you'd like it to be ordered by. Would love to hear if someone has an idea
about this also.
Adrian
> -Original Message-
> From: Ian Skinner [mailto:h...@ilsweb.com]
> Sent: 16 March 2009 14:27
> To: cf-talk
> Subject: Sort database records as a human not a computer.
>
>
> With SQLServer (2000 I believe) if that matters, which it may well.
>
> I have a data column that contains titles. I desire the titles to be
> sorted alphabetically as a human would not a computer. The records I'm
> currently concerned with start with a quote (") and need to start with
> a
> quote. Ideally I would like the records sorted with these records
> placed in order by the first letter inside the quotes like a human
> librarian would not to the top of the list as a computer does it.
> Since
> I'm wishing for this, it would be really cool if the sort also ignored
> the other human librarian no goes 'a', 'an' and 'the' that are supposed
> to be ignored at the beginning of titles when sorting.
>
> Luckily this is a very minor requirement and can be ignored if there is
> not is not a simple solution out there, but I also can't believe I am
> the first programmer that needed to do this with database data, so
> maybe
> the functionality already exists.
>
> TIA
> Ian
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320532
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) FTP and the ports it uses for data.
HISTORY|BACKGROUND I am in the process of reworking a ColdFusion and Oracle 11g application. At one point this application sends some files it generates to another server with FTP. For various reasons, the FTP is being done with the Oracle database management system. Thus we are running into the 'ACL' Access Control List security feature that is new to Oracle 11g. If you are unfamiliar with this feature, Oracle 11g now blocks all HTTP, SMTP and FTP access to any other servers from PL/SQL code unless a ACL entry is created that defines what user can connect to what server with what protocol to what port range. A pretty cool concept actually as it really locks down the server so that it can only do what the developer wants it to do without completely giving up these occasionally very useful protocols. PROBLEM The trouble we are having is what ports are used for the FTP data transfer. These ports need to be defined in the ACL otherwise the process will be blocked by Oracle, but as far as we can tell just about any of the 65,000+ ports can be used for data transfer. I am unfamiliar with FTP server administration so how can one determine or define what range of ports can be used for data transfers? TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Sort database records as a human not a computer.
With SQLServer (2000 I believe) if that matters, which it may well.
I have a data column that contains titles. I desire the titles to be
sorted alphabetically as a human would not a computer. The records I'm
currently concerned with start with a quote (") and need to start with a
quote. Ideally I would like the records sorted with these records
placed in order by the first letter inside the quotes like a human
librarian would not to the top of the list as a computer does it. Since
I'm wishing for this, it would be really cool if the sort also ignored
the other human librarian no goes 'a', 'an' and 'the' that are supposed
to be ignored at the beginning of titles when sorting.
Luckily this is a very minor requirement and can be ignored if there is
not is not a simple solution out there, but I also can't believe I am
the first programmer that needed to do this with database data, so maybe
the functionality already exists.
TIA
Ian
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320530
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Verity Search indexing problem - reading not processing
> >Dug a little deeper and turned on the -verbose command. It says > >"Skipping key [http://127.0.0.1:8500/mysite/ because of mime-type" > > > >If I change it to include the index.cfm it still says the same thing. > > > Anyone familiar with what could be causing this mime-type problem? > I've experimented with the commands -mimeinclude & -indmimeinclude but > no luck. I'm also seeing "Candidate dequeued" for my paths that have CF files in them. Has anyone had any success getting the vspider to work? I seem to be getting these errors in both cf7 & 8, on XP and 2003 server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
