How to write a IP clause

2006-05-12 Thread Mike Kear
I'm sorry if this is somewhat off-topic, but I'm sure others have confronted this situation before and can help me solve it .. I have a client who wants me to develop a web site for him, that is a key part of his business system. In fact I'm sure what he wnats to do is build his business around

Re: How to write a IP clause

2006-05-12 Thread Martyn Bowis
Hi Mike, It is the client's idea, and the developer cannot usurp ownership of that IP. The client benefits from your experience in writing code quickly and robustly, which comes from having written a lot of code already for other people. Your code snippets are your toolset, and you need to

MacroMedia Wiki, update of pages broken ?

2006-05-12 Thread Tom Chiverton
Database error From Adobe Labs A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function SearchUpdate::doUpdate. MySQL returned error 1034: Incorrect key file for table 'searchindex';

CF5 email error

2006-05-12 Thread Martin Thorpe
Hello. We are using CF5 to run a scheduled task that sends out emails. There are only 100 or so emails being sent but I am getting this error in the log: An unknown exception happened while attempting to process spooled mail. Polling will continue I have looked at this tech note:

RE: JRun hang, how to detect and restart service automatically

2006-05-12 Thread Stephen Cassady
Hey Douglas - He he he. The better option is absolutely being performed (lol, I wouldn't understand anyone who didn't attempt to resolve the problem first, and then build a secondary solution in place of fixing the first). The issue seems to be isolated to PDF creation through ColdFusion.

Re: Timing Out Work Around

2006-05-12 Thread Randy Messer
Client uploads Access Db, then script runs a qry to grab zip, loop thru SQL to find assoc. Dealer, it emails the dealer and then updates the Access. Problem is it times out. I'm looping 50 records at a time and thought this would cure it, but doesn't. The loops are using the original qry

RE: (Admin) Blogging CF-Talk

2006-05-12 Thread Mark A Kruger
Michael, I'm definitely one of the culprits. I usually just say ...over on cf-talk along with a link to houseoffusion. I will start trying to link to the thread in question. I was thinking folks would just join the list - but you are right, they would search for the thread. -Mark

Re: JRun hang, how to detect and restart service automatically

2006-05-12 Thread Douglas Knudsen
I hear ya, damn little Sprites!Maybe you could look at other PDF generating tools? Jasper reports, iText, Birt, and OpenReports are a few free OS ones. Maybe way out of your scope, but thought I'd suggest. I setup a OpenReports server recently for evaluation. Its pretty kewl. Are your

Query of Queries

2006-05-12 Thread Rick Root
I'm getting the following error: Query Of Queries runtime error./bbr Cannot apply the binary numeric operator [*|/] on a non numeric type When running the following query of queries: select sum(QUANTITY) AS QUANTITY, SUM(QUANTITY*OPTION_PRICE) AS

RE: Query of Queries

2006-05-12 Thread Ben Nadel
I have never seen this specifically, but I have gotten similar errors when I try to define a query with QueryNew() sending in data types... Are you using QueryNew() to define any query that you are queryying? ... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor

Re: Query of Queries

2006-05-12 Thread Michael Dinowitz
When creating a query using QueryNew() you can add an optional second attribute to it which will define each column as a specific data type. This will avoid the error: QueryNew(columnlist, [columntypelist]) Michael Dinowitz Host: House of Fusion http://www.houseoffusion.com Publisher:

Re: MacroMedia Wiki, update of pages broken ?

2006-05-12 Thread Cutter (CFRelated)
Yeah! Adobe and MySQL... Cutter Tom Chiverton wrote: Database error From Adobe Labs A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function SearchUpdate::doUpdate. MySQL

RE: Query of Queries

2006-05-12 Thread Ben Nadel
Michael, I have actually had problems where the data type caused a problem. I was building a query based on score, all of which were of type Integer... When dumping the query, all values were numeric... However when sorting on the column, it would throw errors about trying to sort on non-numeric

Re: Query of Queries

2006-05-12 Thread Rick Root
Ben Nadel wrote: I have never seen this specifically, but I have gotten similar errors when I try to define a query with QueryNew() sending in data types... Are you using QueryNew() to define any query that you are queryying? Nope. contents is a query returned from a CFC, and both fields are

Re: Query of Queries

2006-05-12 Thread Michael Dinowitz
Can you send me a full code sample to look at? I'd like to play with it a bit to see what's up. I've been finding a number of (rare) issues with CF tags, functions and combinations of syntax. I'm logging them all to www.blogoffusion.com and this looks like another one to go up there. Thanks

RE: (Admin) Blogging CF-Talk

2006-05-12 Thread Munson, Jacob
I've got ads on my sites, and I'd prefer to only show people one page with ads. If they want to click around, and thus are exposed to more ads, it's fine with me. But it also brings your total page views up for the day, which decreases the effectiveness of that day's ads, and you are paid less

AJAX, IIS UTF-8 Question

2006-05-12 Thread Rey Bango
Hi everyone. I'm doing my best to learn about Ajax and development of web apps using this architecture. I recently read this: Ajax uses UTF-8. Normal forms are sent using the encoding of the parent page. Thus a SJIS encoded page will default to sending form content encoded in SJIS. Ajax

cfreport and report generation slowness

2006-05-12 Thread wolf2k5
Hi, I'm trying to generate an XLS report with cfreport on ColdFusion MX 7.0.1. The db query is very fast and the recordset contains about 1000 rows, each row has about 10 text/numeric fields. The report generation takes up to 1 minute on my PowerBook, it's a bit faster on the production Linux

RE: What CMS for .cfm?pageid=

2006-05-12 Thread Robertson-Ravo, Neil (RX)
Well this isn't really an indicator of any CMS etc, just a (poor) way to get content for a particular page. -Original Message- From: Doug Bedient [mailto:[EMAIL PROTECTED] Sent: 05 May 2006 18:56 To: CF-Talk Subject: What CMS for .cfm?pageid= I'm starting to see this in a lot of

RE: How to get several resultsets from SP

2006-05-12 Thread Robertson-Ravo, Neil (RX)
Surely if it is an SP you will know how many it is returning?! -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: 05 May 2006 17:02 To: CF-Talk Subject: How to get several resultsets from SP Hi all I need to know dynamically the number(and metadata) of resultsets

Re: AJAX, IIS UTF-8 Question

2006-05-12 Thread Rob Wilkerson
I'd first try it and see what happens. The only time I've ever had a problem was when I had to return XML from an AJaX call and it was pretty easy to get around by specifying the charset as you listed: cfprocessingdirective suppresswhitespace=true cfcontent type=text/xml; charset=UTF-8

Re: What CMS for .cfm?pageid=

2006-05-12 Thread Crow T. Robot
Curious, what makes it so poor? Robertson-Ravo, Neil (RX) wrote: Well this isn't really an indicator of any CMS etc, just a (poor) way to get content for a particular page. -Original Message- From: Doug Bedient [mailto:[EMAIL PROTECTED] Sent: 05 May 2006 18:56 To: CF-Talk

Re: AJAX, IIS UTF-8 Question

2006-05-12 Thread Rey Bango
LOL. Thanks Rob. I'm trying to do my homework before I fall into a pit. I appreciate the feedback. Anything that I should consider in terms of data storage in SQL Server or MySQL? Rey... Rob Wilkerson wrote: I'd first try it and see what happens. The only time I've ever had a problem was

Re: AJAX, IIS UTF-8 Question

2006-05-12 Thread Rob Wilkerson
I can't give you any specifics, but I set all my databases for UTF-8 character storage. Saves time later when a client says that they need to expand into Korea. :-) Just remember that AJaX isn't anything new. At the risk of (slight) oversimplification, it's nothing more than a way to spawn a

Really Quick, I've never seen this error detail before...

2006-05-12 Thread Jeff Small
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. If something worked...then suddenly stopped working, and when you went to a user edit page, and made no edits, but clicked submit and you got that error dumped...

any ASPers out there (OT, a little)

2006-05-12 Thread Ray Champagne
Can any give me a hand with some ASP? I need a vbscript way of parsing out a list of email addresses passed into a page as a form var. I know next to nothing about vbscript or ASP, but i'd assume this has to be pretty easy. Any takers? TY, Ray -- Ray Champagne - Senior Application

Re: Really Quick, I've never seen this error detail before...

2006-05-12 Thread Tom Chiverton
On Fri, May 12, 2006 at 4:13 PM, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: Where would you look? In the rest of the stack trace :-) Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is

RE: Really Quick, I've never seen this error detail before...

2006-05-12 Thread Dawson, Michael
I have seen this where the directory, containing the Access DB, is Read-Only. The most-common cause, from what I have encountered, however, is a lack of primary key on the table you are updating. M!ke -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Friday, May 12,

Re: Really Quick, I've never seen this error detail before...

2006-05-12 Thread Jeff Small
Interesting...that's exactly what I was looking for...you've pointed me in a good direction, methinks. I have seen this where the directory, containing the Access DB, is Read-Only. The most-common cause, from what I have encountered, however, is a lack of primary key on the table you are

RE: any ASPers out there (OT, a little)

2006-05-12 Thread Dawson, Michael
You can convert the delimited list as an array with Split(). http://www.codefixer.com/tutorials/array_functions.asp M!ke -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 10:17 AM To: CF-Talk Subject: any ASPers out there (OT, a little) Can

Re: Really Quick, I've never seen this error detail before...

2006-05-12 Thread Jeff Small
I have seen this where the directory, containing the Access DB, is Read-Only. Which is exactly what happens when it's not checked out on your end, locally. Okay, so I'm not above looking *really* silly...but see how fast you helped me resolve that? lol...

RE: Really Quick, I've never seen this error detail before...

2006-05-12 Thread Dawson, Michael
Woo-hoo! +1 for Mikey -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 10:27 AM To: CF-Talk Subject: Re: Really Quick, I've never seen this error detail before... I have seen this where the directory, containing the Access DB, is Read-Only.

Frameworks

2006-05-12 Thread Rick Root
I was just cruising through the coldfusion job postings on the raleigh craigslist, and I came across the following in one of the postings: This position requires a programmer who is NOT set on his/her own methodology. Our team does not create un-necessary code with a

RE: Frameworks

2006-05-12 Thread Dawson, Michael
I agree completely and I currently use no framework other than my own. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 10:36 AM To: CF-Talk Subject: Frameworks I was just cruising through the coldfusion job postings on the raleigh craigslist, and

Re: Query of Queries

2006-05-12 Thread Rick Root
Anyone else got any ideas on this? contents is a regular query result set, not anything made by QueryNew()... and the columns in question are both numeric columns (quantity is an integer and option_price is a decimal(10,2)... mysql database) Rick Rick Root wrote: I'm getting the following

Re: Frameworks

2006-05-12 Thread Tom Chiverton
On Fri, May 12, 2006 at 4:35 PM, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I've been programming in coldfusion for 9 years, and I've never used a framework of any kind. NOT because I don't want to, but because I've never NEEDED to. None of my employers have ever asked me to

RE: What CMS for .cfm?pageid=

2006-05-12 Thread Robertson-Ravo, Neil (RX)
Mainly SEO - a big thing these days. Yeah I know Google etc can all spider this content - it just looks bad etc. In this case say pageid=3455 = an About Us section of a website where /aboutus would do. What is better www.awebsite.com/aboutus or www.awebsite.com/index.cfm?pageid=3455

Re: Frameworks

2006-05-12 Thread Zaphod Beeblebrox
If you choose not to use a framework, you still have made a choice, you can choose from OOP or procedural code still, I will choose a path that's clear, I will choose freewill Apologies to Rush Zaph On 5/12/06, Dawson, Michael [EMAIL PROTECTED] wrote: I agree completely and I currently use no

Re: What CMS for .cfm?pageid=

2006-05-12 Thread Paul Giesenhagen
I agree with Neil, In the past year we had one of our customers of SiteDirector request absolute page names ie /this-is-the-productname.cfm so we wrote scripts to do just that. Now 1 year later, when searching in google for his types of products we see him always in the top 5 of the page and

RE: Query of Queries

2006-05-12 Thread Ben Nadel
Do any parts of the query work? Meaning, If you run with just the first SUM directive does it work? Does it work if you do not do the * in the second SUM? Let's see if we can narrow it down to exactly what is breaking? ... Ben Nadel Web Developer Nylon Technology 350 7th

Re: Frameworks

2006-05-12 Thread Rob Wilkerson
Apologies, perhaps, but a nice reset nonetheless. You just don't see enough Neil Peart lyrics quoted on these mailing lists anymore. :-) On 5/12/06, Zaphod Beeblebrox [EMAIL PROTECTED] wrote: If you choose not to use a framework, you still have made a choice, you can choose from OOP or

Re: Frameworks

2006-05-12 Thread Jeff Small
Maybe you don't have a 'framework' in the sense of FB or Mach, but I bet you have the same ways of doing common things that you use over and over again. Which is all a good framework is, really :-) Isn't there a frameworks death match at CFUNITED? I think I read something about Simon heading

RE: Query of Queries

2006-05-12 Thread Munson, Jacob
Did you try putting Val() around quantity and option_price, just to make sure CF isn't doing something funny? -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 9:47 AM Anyone else got any ideas on this? contents is a regular query result

Re: What CMS for .cfm?pageid=

2006-05-12 Thread Ray Champagne
OK, I can get on board with that. I thought he meant from a programmatical standpoint it was bad. This actually is a hot-button issue right now here at our firm. So, if you don't mind, can I ask why you didn't use SES URL's? Are they not as effective as this-is-the-product-name.cfm method?

Re: Query of Queries

2006-05-12 Thread Josh Nathanson
Total stab in the dark but maybe you could try changing the alias for QUANTITY so it's not the same name as the column name itself? Maybe that's messing things up somehow. -- Josh - Original Message - From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent:

RE: Frameworks

2006-05-12 Thread Snake
Alas I think times are a changing, and if you were to be looking for a new job, there is a good chance you might need to familiar with the whole damn lot of them. russ ~| Message:

long page requests

2006-05-12 Thread Brad Wood
I have Cold Fusion set to log all requests which take longer than 120 seconds. Occasionally someone will run something in our production environment (CFMX7 Standard running on Linux) and server.log will show a whole bunch of long requests until the initial big one got done, or we restarted the

RE: long page requests

2006-05-12 Thread Munson, Jacob
We use fuse box so EVERY request is to index.cfm. Sorry for a somewhat OT response, but this is probably the number 1 reason I have avoided frameworks up to this point. Not only does it make some debugging difficult, but it makes most stats packages useless (if you want to track which pages are

RE: Frameworks

2006-05-12 Thread Munson, Jacob
Isn't there a frameworks death match at CFUNITED? I think I read something about Simon heading up the anti-frameworks side. Yes, Hal Helms vs. Simon Horwith. I'm really looking forward to that. :) --- This transmission may contain information that is privileged, confidential

Re: Query of Queries

2006-05-12 Thread Rick Root
Ben Nadel wrote: Do any parts of the query work? Meaning, If you run with just the first SUM directive does it work? Does it work if you do not do the * in the second SUM? Let's see if we can narrow it down to exactly what is breaking? It is definately this one causing the problem: select

Re: Query of Queries

2006-05-12 Thread Rick Root
I ran this query and got a different error: select SUM((OPTION_PRICE+0)) AS MERCH_CHARGE FROM contents Cannot mix types VARCHAR and BIGINT in a + binary operation so it looks like for some reason, coldfusion things OPTION_PRICE is a varchar, even though the

RE: Query of Queries

2006-05-12 Thread Mark A Kruger
Rick, What happens when you just do quantity + option_price -Mark -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 11:48 AM To: CF-Talk Subject: Re: Query of Queries Ben Nadel wrote: Do any parts of the query work? Meaning, If you run with

RE: Query of Queries

2006-05-12 Thread Munson, Jacob
Try using the val() function. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 10:53 AM I ran this query and got a different error: select SUM((OPTION_PRICE+0)) AS MERCH_CHARGE FROM contents Cannot mix types

RE: Query of Queries

2006-05-12 Thread Ben Nadel
This wouldn't make much sense, but maybe it's that one is int and one is float... Try putting in SUM(1.0 * OPTION_PRICE) AS MERCH_CHARGE - and - SUM( 1 * OPTION_PRICE ) AS MERCH_CHARGE This way we will see if that breaks. If the 1 still breaks but the 1.0 does not break, then it's a

RE: Query of Queries

2006-05-12 Thread Mark A Kruger
Why not CAST? Select SUM(CAST(option_price AS DECIMAL) * QUANTITY) as merch_charge -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 11:53 AM To: CF-Talk Subject: Re: Query of Queries I ran this query and got a different error: select

RE: long page requests

2006-05-12 Thread Kevin Aebig
FYI, A few stat packages allow you log pages unique with their URL variables intact. I believe Mint does that and so does DeepMetrix. Cheers, !k -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: May 12, 2006 10:41 AM To: CF-Talk Subject: RE: long page requests

SOLVED: Query of Queries

2006-05-12 Thread Rick Root
SOLVED... I got it to give me a different error which led me to a posting on ExpertsExchange which mentions that cast is actually a valid function to use in query of queries. http://livedocs.macromedia.com/coldfusion/7/htmldocs/1270.htm#1182700 this page describes the need to cast things

Re: Query of Queries

2006-05-12 Thread Rick Root
Munson, Jacob wrote: Try using the val() function. val is a coldfusion function, not a SQL function. you can't use val() anymore than you can use lcase() or chr() in a query of queries. Rick ~| Message:

RE: Frameworks

2006-05-12 Thread Michael E. Carluen
Agree with you Tom. Even if you may not find a need of packaged frameworks, I'm sure we all operate on our own pseudo- coding structure. Something that makes the code predictable to the next guy, yet still being fluid and flexible as we need it to be. Often, I think rigidity of frameworks often

Re: Frameworks

2006-05-12 Thread Rick Root
Michael E. Carluen wrote: Agree with you Tom. Even if you may not find a need of packaged frameworks, I'm sure we all operate on our own pseudo- coding structure. Something that makes the code predictable to the next guy, yet still being fluid and flexible as we need it to be. Often, I

RE: ColdFusion Tech Talk (CF-Talk): Digest every hour

2006-05-12 Thread Peters, Christopher D.
Hello all. I have a very Enterprise-level question here. (Whatever that means! :) My agency has a solid investment in IBM iSeries equipment, and we have several large applications written in Java running on OS/400. ColdFusion is not supported on OS/400, but I have seen one article on the Web

RE: Query of Queries

2006-05-12 Thread Munson, Jacob
Oops, I was thinking of when I use cf functions on the right side of a where clause. :\ -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 11:18 AM To: CF-Talk Subject: Re: Query of Queries Munson, Jacob wrote: Try using the val() function.

HELP!!! - ORA-12505 Connection refused, the

2006-05-12 Thread Eddie Trinidad
Good afternoon HOF users, I'm a first time poster and I'm a business analyst... so I'm not that tech savvy. I maintain our office CF server Jacksonville that links up with an network operation center in KC. Well they did this migration thing of Oracle 10g and our webserver can't connect with

ANN: BlogCFC v5 Released

2006-05-12 Thread Raymond Camden
The subject says it all, details, and free party favors, may be found here: http://ray.camdenfamily.com/index.cfm/2006/5/12/BlogCFC-v5-The-circle-is-now-complete (The free party favor thing is a lie.) Raymond Camden ~|

Re: ColdFusion Tech Talk (CF-Talk): Digest every hour

2006-05-12 Thread Rick Root
Way over my head, but if what you're talking about is a full blown j2ee server, then couldn't coldfusion be installed as a j2ee app? If not, then BlueDragon for J2EE Servers might be your next best bet. The product blurb for Bluedragon j2ee even mentions Websphere. BlueDragon for J2EE

Re: HELP!!! - ORA-12505 Connection refused, the

2006-05-12 Thread Michael Dinowitz
This is covered in the following Adobe tech notes: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a http://www.adobe.com/support/documentation/en/coldfusion/mx701updater/oracle10g.html Good afternoon HOF users, I'm a first time poster and I'm a business analyst... so I'm not that

RE: AJAX, IIS UTF-8 Question

2006-05-12 Thread O�uz_Demirkap
Hi Rey, You can see my comment on your blog. Oðuz Demirkapý -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Freitag, 12. Mai 2006 16:34 To: CF-Talk Subject: AJAX, IIS UTF-8 Question Hi everyone. I'm doing my best to learn about Ajax and development of web apps

Re: HELP!!! - ORA-12505 Connection refused, the

2006-05-12 Thread Douglas Knudsen
oddness... yeah, no need for Oracle client install and tnsnames on the server, but the tnsnames entry is helpful for filling out the DSN info in CFAdmin. Is this new Oracle install a RAC? No SID with that. see this http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0 info near the

Re: BlogCFC v5 Released

2006-05-12 Thread Rick Root
Mark A Kruger wrote: Ok, I watched this whole episode, and I have a sense of humor, but there has to be something I don't understand ... Some inside joke. It's funny But I think it's just the SNL style that you're not getting. I think it's pretty funny myself. Maybe the humor is in that

Okay, here's *another* error message I've never seen...

2006-05-12 Thread Jeff Small
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] At most one record can be returned by this subquery. What on earth? Admittedly, this isn't my code, but I'm tasked with figuring out why it's generating that error message...what, philosophically, would

RE: ColdFusion Tech Talk (CF-Talk): Digest every hour

2006-05-12 Thread Dawson, Michael
I could be wrong, but I thought CF was supported on WAS only on a Windows server. M!ke -Original Message- From: Peters, Christopher D. [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 12:27 PM To: CF-Talk Subject: RE: ColdFusion Tech Talk (CF-Talk): Digest every hour Hello all. I

Re: Okay, here's *another* error message I've never seen...

2006-05-12 Thread Rick Root
Jeff Small wrote: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] At most one record can be returned by this subquery. and the query is. ~| Message:

Re: Okay, here's *another* error message I've never seen...

2006-05-12 Thread Nathan Strutz
Usually it would be something like an embedded query returning more than one result when it expected just one. select * from users1 where username = (select name from users2 where firstname = 'Jeff'') If the users 2 table contains more than one person named jeff, you're screwed. There are a

apache module for coldfusion and php as one handler

2006-05-12 Thread Martin Orth
Hello, I am searching for a way to parse the contents of of a coldfusion file for coldfusion code and after that the content should be parsed for php code or vice versa. I tried doing this with mod_ext_filter but this does not work for me and it would be not so fast like a modul. The best way I

Re: Okay, here's *another* error message I've never seen...

2006-05-12 Thread Robert Everland III
Are you using Microsoft SQL Server? If so are you using the ODBC connector or are you using the built in Microsoft SQL Driver? If both are yes you may want to try the JDBC driver that Microsoft offers. I have done some advanced queries that choked on the datadirect drivers, but worked with

RE: Okay, here's *another* error message I've never seen...

2006-05-12 Thread Mosh Teitelbaum
If your query is along the lines of: SELECT column FROM table WHERE column = (SELECT column2 FROM Table2) The subquery can return multiple results. However, the = operator (or , , =, , =, etc.) only compares a single value to a single value. Instead, your query should use

Hype 2.0

2006-05-12 Thread Jon Block
What do you cf developers think of this web 2.0 chatter in our industry? Do you feel like you need to use asynchronous JavaScript and other current widgets and services just to tell people that you are web 2.0 compliant? This seems like a silly buzzword ... do we need to embrace it to be

250K Document limit in OEM version of Verity

2006-05-12 Thread Scott Stewart
All, There is a limited of 250K documents in the OEM version of Verity that comes with CFMX. We've reached that limit four times over. Has anyone seen this restriction cause any performance or stability issues? Thanks sas Scott Stewart ColdFusion Developer/Administrator GlobalNet

RE: Okay, here's *another* error message I've never seen...

2006-05-12 Thread Ian Skinner
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] At most one record can be returned by this subquery. You have a subquery in you sql statement in a place only one record can be used, but the subquery is returning more then one row. A simple example

RE: Hype 2.0

2006-05-12 Thread Steve Brownlee
Absolutely not. Now, if we have some spare time, we are planning on implmenting a flashy little gizmo on our start page just to give the customers a little 'wow factor', but that's the extent of it. Customers want a product that works, has 99.99% uptime, fulfills all of their business needs and

Re: Okay, here's *another* error message I've never seen...

2006-05-12 Thread Bryan Stevenson
sub-queries can only return one recordthus the error So in the main SELECT clause there is a sub-query aliased as a columnit is retuning more than one record and bailing Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone:

Re: ColdFusion Tech Talk (CF-Talk): Digest every hour

2006-05-12 Thread Nathan Strutz
Chris, ColdFusion is a fully compliant J2EE application. If you have a J2EE server, it should work, period. However, Adobe doesn't officially support the OS/400 platform. That's just a support issue, but because of its certified 100% Java nature, it should deploy on any J2EE server native to any

Re: Hype 2.0

2006-05-12 Thread Bryan Stevenson
Well I feel that using AJAX is damn fine and beats the crap out of Flash for RIA that said I have otherwise ignored Web 2.0 Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL

RE: Hype 2.0

2006-05-12 Thread Munson, Jacob
Personally I use Ajax because I think it's very handy and does some pretty awesome stuff. But I have a stable full time job in a corporation, so I don't really need to worry about being competitive. Oh, and by the way, it's pretty easy to get into Ajax, if you use one of the ColdFusion libraries

RE: Okay, here's *another* error message I've never seen...

2006-05-12 Thread Ben Nadel
Jeff, It just means that your sub-query can return more than one row, which a subquery used in comparison or selection cannot... Just selec the TOP 1 to make sure this doesn't happen. It it is NOT supposed to happen, then you have bad data or are not using all required criteria (ie. is_deleted =

RE: Hype 2.0

2006-05-12 Thread Lee.S.Surma
Just tell them that Web 2.0 is old school and Flex is Web 3.0. Lee ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240400 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription:

RE: Hype 2.0

2006-05-12 Thread Ben Nadel
Personally, I think it is way over-hyped... Or at least, it is not done well enough. Almost every time I see something very web2.0, it feels like it is not worht it. Here are requirements that I have for web2.0 to be good: 1. My back button (backspace on the keyboard) cannot act wrong as it does

RE: BlogCFC v5 Released

2006-05-12 Thread Mark A Kruger
Ok I'll rethink it. Who in the ham sandwich is Bruce Dickinson? -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 2:10 PM To: CF-Talk Subject: Re: BlogCFC v5 Released Mark A Kruger wrote: Ok, I watched this whole episode, and I have a sense of

Re: Okay, here's *another* error message I've never seen...

2006-05-12 Thread Jeff Small
sub-queries can only return one recordthus the error So in the main SELECT clause there is a sub-query aliased as a columnit is retuning more than one record and bailing Thanks all, you're pointing me in the right direction. Appreciate it.

RE: BlogCFC v5 Released

2006-05-12 Thread Everett, Al \(NIH/NIGMS\) [C]
http://en.wikipedia.org/wiki/More_cowbell -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 4:05 PM To: CF-Talk Subject: RE: BlogCFC v5 Released Ok I'll rethink it. Who in the ham sandwich is Bruce Dickinson? -Original Message-

RE: BlogCFC v5 Released

2006-05-12 Thread Che Vilnonis
Iron Maiden dude. -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 4:05 PM To: CF-Talk Subject: RE: BlogCFC v5 Released Ok I'll rethink it. Who in the ham sandwich is Bruce Dickinson? -Original Message- From: Rick Root

Re: apache module for coldfusion and php as one handler

2006-05-12 Thread Alan Rother
I dont have an answer, but I have to ask, WHY? If you MUST use some php code you could always have it on a seperate file then call it using cfhhtp, then out puit it's results onto your cf page. Ok I guess I do have an answer... =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7

Re: Hype 2.0

2006-05-12 Thread Alan Rother
I think the key is, web 2.0 really refers to buildin Apps, not websites. If you are building a website, then you really don't have much use for ajax, flash(I know, some people like pretty flash banners ) or flex. If you are building an online application, such as gmail, an online store etc.,

HELP I'm drowning in a sea of encoding.

2006-05-12 Thread Ian Skinner
Can anybody provide me some insight or helpful links to understand how encoding has a hand in displaying pages across technologies? I have a small CMS type form. I have used the tinyMCE wysiwyg widget to allow formatting and such. Now the authors usually write their content up in MS Word and

RE: Hype 2.0

2006-05-12 Thread Ben Nadel
I agree with Alan. Web 2.0 should maybe me just Web Based Applications. The websites out there are already pretty good. I rarely find fault (other than design) with them, or wish they could be better. I do like AJAX for stuff though, and am looking into how to use it well.

Coldfusion validating a standard form?

2006-05-12 Thread Andy Matthews
A co-worker just asked me about a form that's been online for several years. It's a plain form, no cfinput tags, nothing. It's been working perfectly for all this time and now, all of a sudden, CF is trying to validate it like it's a cfform. You know, that plain grey box at the top left of the

RE: Coldfusion validating a standard form?

2006-05-12 Thread Ben Nadel
Can you post the form code? CF automatically tries to validate some form variables (I think) that end in things like _date. ... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com You

RE: BlogCFC v5 Released

2006-05-12 Thread Mark A Kruger
Ok but she will have to hold still -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 3:16 PM To: CF-Talk Subject: RE: BlogCFC v5 Released Iron Maiden dude. -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent:

table of unlimited jobs and users?

2006-05-12 Thread Kiley Simpson
Hi List, I have to print a grid/table (not cfgrid) of jobs along the x-axis(horizontal) and users along the y-axis(vertical). Can someone show me how to make a table which will display 30 users along the y-axis and 10 jobs along the x-axis knowing there are unlimited of each? 10 x 30 for

RE: table of unlimited jobs and users?

2006-05-12 Thread Ben Nadel
Kiley, The problem is a bit strange... Can you explain it in english and maybe we can get you a better solution. How are you decided which data to show?? For example: I want to show the 30 most recent jobs for the 10 most active users. ... Ben Nadel www.bennadel.com

  1   2   >