Hey Bryan, not to pick on your or anything :)
On 4/19/06, Bryan Stevenson [EMAIL PROTECTED] wrote:
Basically with Ruby it comes down to this (in my short investigation of
itI
stopped because it is NOT the Holy Grail)
So just because it's not the Holy Grail it isn't useful? Does
On 4/19/06, Andy Matthews [EMAIL PROTECTED] wrote:
Anyway, if anyone has input on this topic, I'd love to hear it. I tried
getting RoR running on my local dev machine and was immediately turned off
by the fact that you have to do so much work using the command prompt.
Have
the RoR developers
On 4/19/06, Jochem van Dieten [EMAIL PROTECTED] wrote:
Russ Michaels wrote:
No, only selects return a recordcount.
Although SQL does return a message about how many records are updated
Maybe some implementations update the diagnostic area with that
information, but returning a count of
That's it you blaspheming frood, you're off to the Frogstar and into the
Total Perspective Vortex!
You know, I tried to get into an evaluation of RoR, but from the initial
setup to building a couple of apps, it just felt off somehow. It may be
great, but it's one of those things, similar to
Dave Carabetta wrote:
On 4/19/06, Jochem van Dieten [EMAIL PROTECTED] wrote:
Maybe some implementations update the diagnostic area with that
information, but returning a count of the number of records
affected is not part of the SQL specification. More importantly,
it is only part of JDBC 3
I have been sort of following this conversation and I am just curious, are
ya'll just debating usefullness? Or is the return of the recordcount
actually creating a problem somewhere?
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Dave Carabetta
Don't make me read Vogon poetry to you!
I can totally understand. At first I was like where in the hell are my
application variables? and I realized later that the structure of
programming is way different. And as for feeling off.that's kinda the
way I feel about ASP.net 2.0. It looks
On 4/19/06, Bryan Stevenson [EMAIL PROTECTED] wrote:
Basically with Ruby it comes down to this (in my short investigation of
itI
stopped because it is NOT the Holy Grail)
It does lots of stuff for you...right up until it needs to something different
then the default...then you are
I think Pete just started the thread hoping there was a way to make
update queries return a value in the recordcount for how many rows were
updated instead of returning zero.
--Ferg
Ben Nadel wrote:
I have been sort of following this conversation and I am just curious, are
ya'll just
I tried getting RoR running on my local dev machine and was
immediately turned off by the fact that you have to do so much
work using the command prompt. Have the RoR developers never
heard of a web browser?
Why would you *develop* in a web browser? I assume that you realize
Rails *only*
are ya'll just debating usefullness? Or is the return of the recordcount
actually creating a problem somewhere?
I think the first two messages in the thread are quite clear:
1. It would be useful that a query returns the number of updated record
in an UPDATE in query.recordCount
2. The qurery
Wow...
What a great conversation!
Here's what I want to accomplish in my testing of RoR. I want to be able to
view the parsed files in my local dev setup, currently using XAMPP. I really
would prefer NOT having to start the Ruby server, just a preference there I
guess. The whole point of me
So just because it's not the Holy Grail it isn't useful? Does that infer CF
is the Holy Grail :)
No...just saying RoR ain't all it's being hyped up to beit may be useful to
youbut so far...not to me.
Or you could just extend those base classes to do the kinds of things you
want it
I don't want to use the command prompt. It's clunky, outdated and a pain to
get around. I'm enough of a visual person that it makes FAR more sense (to
ME) to use a visual interface to do things.
Why can't they just code it so that you load up a page in localhost/ruby and
type in the same things
That was my concensus early on. Seems like it would be a hard sell to
argue against either of those statements.
--
Rob Wilkerson
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238174
Archives:
Claude,
Sorry, I fogot the original question... I thought at some point it was being
argued that CF shouldn't return a RecordCount on non-selecting queries...
Good luck with a solution.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Claude Schneegans
don't like plural table names?
ActiveRecord::base.pluralize_table_names=false in environment.rb
want to override a table name?
class someTable ActiveRecord::Base
set_table_name some_crazy_table_name
end
Now that I'm finished blowing Coke out my nose
Are you seriously saying those
Below is a part of my code
cfquery name=insert_hourly datasource=storm
INSERT INTO hourly
(employee_id
,ticket_no
,ticket_date
cfif labor_start IS NOT ,labor_start/cfif
cfif labor_stop IS NOT ,labor_stop/cfif
cfif labor_lunch IS NOT
On 4/19/06, David Elliott [EMAIL PROTECTED] wrote:
Below is a part of my code
And my question might be a simple onethe line that says cfif equip_idle
IS NOT ,equip_idle/cfif...does this mean I'll only have any entry if
their is a value in it?
Yes, but a better way I think is to
Thanks Ryan.
Ryan Guill [EMAIL PROTECTED] wrote: On 4/19/06, David Elliott wrote:
Below is a part of my code
And my question might be a simple onethe line that says
,equip_idle...does this mean I'll only have any entry if their is a value in
it?
Yes, but a better way I think is
Dave,
I am not sure I follow 100%, but yes, the CFIF statements will stop the
values from being added. However, the column will still be in the database
for that new record and will have whatever default value you have assigned
to that column (or NULL if no default value has been set and the
No problem.
On 4/19/06, David Elliott [EMAIL PROTECTED] wrote:
Thanks Ryan.
Ryan Guill [EMAIL PROTECTED] wrote: On 4/19/06, David Elliott wrote:
Below is a part of my code
And my question might be a simple onethe line that says
,equip_idle...does this mean I'll only have any
On 4/19/06, Bryan Stevenson [EMAIL PROTECTED] wrote:
don't like plural table names?
ActiveRecord::base.pluralize_table_names=false in environment.rb
want to override a table name?
class someTable ActiveRecord::Base
set_table_name some_crazy_table_name
end
Now that I'm finished
it's not amazing, but in the model you would add
def validate
errors.add(:start_date,should be earlier than end_date) unless
start_date.nil? || start_date end_date
end
Exactlyright back to custom coding.
So although that is a hair less code than the equivalent in CFit's not so
it might be worth looking at whats returned in the
metadata (getMetaData) and the query result structure
I did some testing, and CF doesn't appear to treat update queries the
same as select queries. Neither cfdump nor getMetaData work with an
update query, in fact CF doesn't even recognize the
a cleaner way of writing this might be:
cfquery name=insert_hourly datasource=storm
INSERT INTO hourly
(employee_id
,ticket_no
,ticket_date
,labor_start
,labor_stop
,labor_lunch
,truck_id
,equip_start
,equip_stop
ben, did you get that working?
tw
On 4/19/06, Ben Nadel [EMAIL PROTECTED] wrote:
Thanks,
I will give that a try... Overall, though, I think QofQ are great and very
useful.
-b
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Tony [mailto:[EMAIL
CF shouldn't return a RecordCount on non-selecting queries.
Well, the best would be it returns a sensible value. If it cannot,
better return nothing, AND document it.
--
___
REUSE CODE! Use custom tags;
See
Tony,
Work is a bit hectic at the moment, so haven't had time to play around with
the casting. Right now, I just removed the QueryNew() DATA TYPES and that
seems to work for the moment. I will see what I can experiment with tonight.
...
Ben Nadel
www.bennadel.com
CF doesn't appear to treat update queries the
same as select queries
I think a good reason is that a SELECT SQL query returns a dataset, an
INSERT, UPDATE or DELETE
does not.
What we call a QUERY in CF is actually a dataset, the SELECT, UPDATE or
other is not a query,
it is an SQL statement.
\w is any alphanumeric character, so the \d is redundant. :)
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 19, 2006 10:05 AM
Glad I could help... I am sure there is a better way to make
the RegExp,
using the shorthand notation, but I am
I suppose one solutions, while it is a bit more work would be to have
osmething like:
cfquery ...
DECLARE @record_count INT;
SET @record_count = ISNULL(
(
SELECT COUNT(*) AS record_count FROM [TABLE] WHERE where clauses
),
0
);
!--- Now run update ---
UPDATE. WHERE..
Thanks, I can never remember those for some reason.
-b
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 19, 2006 3:25 PM
To: CF-Talk
Subject: RE: Extract email(s) from non-delivered message
\w
Anyone have a clue how to set up a virtual directory (not a cf mapping)
using the built in CF web server? Or if it's even possible to?
Cutter
Cutter,
You may want to try this article on the Adobe/Macromedia site on configuring
the built in web server:
http://www.antiwrap.com/?957
It has a
Neil: Polling every fifteen minutes is an enormous waste of
CPU and bandwidth... for both you and the source sites. For
example, if you're aggregating individual blogs, once every
24 hours will cover the vast majority just fine.
I disagree. RSS was originally built as a solution to
Anyone know if it's possible to catch this exception (when a CFM page is called
that doesn't exist) in the application without using the Missing Template
Handler? I was hoping to handle this in the application.cfc, but it looks like
this error is thrown before it ever hits the application.cfc
I'm going to chime in somewhere between Jacob and Roger. With the
bandwidth saving features I mentioned earlier, I'd say 30 mins to an
hour should be sufficient in almost every case. Of course, now we're
just stating opinions, but that's mine. For what it's worth...
On 4/19/06, Munson, Jacob
And one big plus -- CF works on Windows *far* better than Rails. Rails
is a *pain* to configure with stability and performance on Windows.
Well, considering that windows servers are a nightmare (/servers/, not
desktops), Rails is on the right track. Sorry, I had to say it. ;)
jake heads back
This is what I was thinking.
Sure there may well be some optimisations that can be done for the process, but
I agree that RSS is something that should be checked often.
Which brings me back to my original problem... How do I go about getting this
data checked, parsed and dumped into the db
Are you saying that Ruby (and hence RoR) is a strictly typed language?
That's enough to turn me off right there...
-Original Message-
From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 19, 2006 11:35 AM
I thought that same way until I really got into creating
yeah, it is custom coding, but isn't all your business logic going to be
custom code? What if you are required to have a start date, but your end
date could be open ended. There's really not an easy way to automate that
kind of logic.
Rails can make that kind of code easier I believe. Say you
This would work, as long as you're using MS SQL.
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 19, 2006 1:26 PM
I suppose one solutions, while it is a bit more work would be to have
osmething like:
cfquery ...
DECLARE @record_count INT;
not at all, it's dynamically typed, this would be valid
x=hello
x=1
y=x
y.to_s = 1
On 4/19/06, Munson, Jacob [EMAIL PROTECTED] wrote:
Are you saying that Ruby (and hence RoR) is a strictly typed language?
That's enough to turn me off right there...
-Original Message-
From:
With the exception of the adding a new field in the DB and it's avaialable
evrywhere bit, the other examples are easily handles by CFCsone method to
update...another to insert...they do different things...just like your example:
def validate_on_update
#stuff
end
or
def
We're having a recurring problem with CFMX 7.01 JNDI datasources deployed on
BEA WebLogic 9.1. For no apparent reason, ColdFusion seems to think the
datasources are failing (won't verify) even though BEA says the connection
pools are perfectly healthy. We did not have this problem deployed on
I've not found a way to do it with CFMX, but Bluedragon will allow you to
capture it.
On 4/19/06, Mike Garner [EMAIL PROTECTED] wrote:
Anyone know if it's possible to catch this exception (when a CFM page is
called that doesn't exist) in the application without using the Missing
Template
I finally figured it out. I wrote a blog entry on it:
http://blog.cutterscrossing.com/index.cfm/2006/4/19/CFs-BuiltIn-Server-and-Virtual-Directories
Thanks to everyone for your input.
Cutter
Larry Lyons wrote:
Anyone have a clue how to set up a virtual directory (not a cf mapping)
using the
The crap, though official answer will most likely be that CFMX7.01
isn't supported on 9.1 - only 7 and 8.1
Being that I don't personally use WebLogic I can't help any further.
Andy
On 19/04/06, Cathy Taylor [EMAIL PROTECTED] wrote:
We're having a recurring problem with CFMX 7.01 JNDI
You never said you were attempting to map a directory to a remote server..
No wonder you spent so much time on this issue.
--
Casey Dougall
On 4/19/06, Cutter (CFRelated) [EMAIL PROTECTED] wrote:
I finally figured it out. I wrote a blog entry on it:
No, the remote server was just a bonus, that wasn't my initial intention.
Cutter
Casey Dougall wrote:
You never said you were attempting to map a directory to a remote server..
No wonder you spent so much time on this issue.
--
Casey Dougall
On 4/19/06, Cutter (CFRelated) [EMAIL
Anyone know if there are plans to produce another training from the source
book for coldfusion 7? I use this book in a Continuing Education class i
teach and was hoping to continue using it.
If not anyone have an recommendations for a good intro to CF book other than
the WACK? i don't want to
Not sure on which kind of database it will work.
All I know is that it wont work with Access database.
Another way to get the same result would be to store a date time value
in the same query
as the INSERT or UPDATE, then count them in another query.
If the field is indexed, it should take a
All,
Got a query that works fine in MySQL 4.1 but not MySQL 5, I get a SQL syntax
error. It looks hairy but there are three tables involved: Orders,
Order_No, and Products. The subquery joins Orders and Order_No, the main
query joins the result of the subquery (alias ord) with Products
Anything jump out?
The lack of an error message from MySQL that indicates where the
syntax error occurred?
cheers,
barneyb
On 4/19/06, Josh Nathanson [EMAIL PROTECTED] wrote:
All,
Got a query that works fine in MySQL 4.1 but not MySQL 5, I get a SQL syntax
error. It looks hairy but there
I lved the CF MX Bible (bible series). It's a HUGE book, but it's really
fundamental and a straight forward book. Its big because it really explains
things well.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: jonese [mailto:[EMAIL PROTECTED]
Sent:
Here's the error:
--
Syntax error or access violation: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the right
syntax to use near 'SELECT Orders.Product_ID, Orders.Options,
Order_No.DateOrdered
---
That SELECT
Thanks for the kudos, Ben. We really worked hard on it.
Respectfully,
Adam Phillip Churvis
Certified Advanced ColdFusion MX 7 Developer
BlueDragon Alliance Founding Committee
Get advanced intensive Master-level training in
C# ASP.NET 2.0 for ColdFusion Developers at
Adam,
That's really cool that you worked on it. I liked it so much, that I have
looked up all the other Bible books. Only a few pertain to my field and
interests, but I definitely look forward to getting them, especially the
Flash 8 ActionScript Bible.
Thanks for the great books.
One thing I have noticed with the CF community is that the RSS feeds
that are published seem to be all over the place, some doing things
one way, some doing it another.
Neil: Pete Freitag and I have both published tips for getting CF-based feeds to
provide the correct headers and HTTP
My host is actually using MySQL 3, not 5 as I thought, and subqueries are
not allowed on MySQL 3. Crap.
-- Josh
- Original Message -
From: Josh Nathanson [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, April 19, 2006 3:40 PM
Subject: Re: Query works MySQL 4
I know this was an old question, but I'm just catching up.
My boss co-workers are SEO wizards. They allowed me to put our SES
URLs to death last year. We are still hitting the top in Google for our
target keywords. (enter matte satin bridesmaid dress in google.com or
google.co.uk and see
RSS was originally built as a solution to provide near
real-time updates on a site.
Jacob: The blogosphere has mechanisms to handle real-time updates, and
syndication feeds ain't one of 'em. Never has been.
Fullasagoog polls every 15 minutes, not
sure how often MXNA does it.
If all they're
Josh Nathanson wrote:
My host is actually using MySQL 3, not 5 as I thought, and subqueries are
not allowed on MySQL 3. Crap.
MySQL 3.23 is so freakin old... get a new host. =)
Rick
~|
Message:
Next time it comes up I'll create a recipe. It's only when I'm doing
complex dynamic creation of queries, and then trying a query of query of the
query I created. I don't think that it's anything preserveQuotes would fix,
and I haven't tried re-writing the generation to use cfqueryparams... I
Well I have been using JDBC Statement call from CF and it will return you
number of records effected for updated, inserts or deletes.
Thanks
Qasim
On 4/19/06, Claude Schneegans [EMAIL PROTECTED] wrote:
Not sure on which kind of database it will work.
All I know is that it wont work with
'specially watch the asterisk, as I've had some tough times with it- but
that could just be
my lack of real regex skillz. And the fact that the asterisk is different
depending on the
regex engine...
I bet your ninja is good with *... they do look sorta like throwing stars...
:d
On 4/18/06, Tony
So, how would I call my cfc from a cron job or win service?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238226
I know there is a TTL equivalent in Atom 1.0/RSS 1.0...
Rob: Nope, there's no ttl equivalent in Atom 1.0. Someone brought up
ttl/skipHours/skipDays in the IETF WG (or the pre-IETF group) at one point, and
the consensus was that the elements are seldom used, not well understood when
they *are*
I was thinking more along the lines as any freaking coding system
that doesn't have a single line comment is retarded. But I'm a retarded
coder, so... :-) Heh. Seriously tho, the time I save isn't too related
to the (apparently) old everything runs faster in cfscript, but more along
the lines of
On 4/18/06, Zaphod Beeblebrox [EMAIL PROTECTED] wrote:
I tried naming tables in the singular form once. I hated it. For some
reason it bothered me to write sql that read select top 50 * from book
Heh. I have a thing about plurals and singulars, so, I feel ya.
I swing like a pendulum (well,
On 4/19/06, Josh Nathanson [EMAIL PROTECTED] wrote:
Here's the error:
--
Syntax error or access violation: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the right
syntax to use near 'SELECT Orders.Product_ID,
Thanks for the clarification. I surely thought I remembered one from
when I built my reader. Hardly the first time my memory has failed
me.
On 4/19/06, Roger Benningfield [EMAIL PROTECTED] wrote:
I know there is a TTL equivalent in Atom 1.0/RSS 1.0...
Rob: Nope, there's no ttl equivalent in
On 4/19/06, Andy Matthews [EMAIL PROTECTED] wrote:
I don't want to use the command prompt. It's clunky, outdated and a pain to
get around. I'm enough of a visual person that it makes FAR more sense (to
ME) to use a visual interface to do things.
Then use RadRails in Eclipse and click the
On 4/19/06, Andy Matthews [EMAIL PROTECTED] wrote:
Wow...
What a great conversation!
Here's what I want to accomplish in my testing of RoR. I want to be able to
view the parsed files in my local dev setup, currently using XAMPP.
Not sure what you mean by parsed files. Ruby is
On 4/19/06, Dan G. Switzer, II [EMAIL PROTECTED] wrote:
The one exception to CF killing a thread when a connections is closed
might
be if you were using CFFLUSH to dump the output stream to the browser.
It's
Seems to be hit and miss. I've got a long running page that uses cfflush,
sometimes
Denny,
Seems to be hit and miss. I've got a long running page that uses cfflush,
sometimes it stops running (when browser go away), mostly it doesn't.
Maybe the confusion is in the socketWhatNot error or whatever, that one
Thanks for the information. That's pretty much what I figured, but that
I use a batch file that calls wget for win32 to call the template all run
from the service
On 4/19/06, Chris Velevitch [EMAIL PROTECTED] wrote:
So, how would I call my cfc from a cron job or win service?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
Chris,
So, how would I call my cfc from a cron job or win service?
You can always build a separate CFML template that invokes the methods in
your CFC--that way you can re-use your CFC, but still build something that
works in CF Standard.
You could then have the template compare the directory
I use a batch file that calls wget for win32 to call the template all run
from the service
You can also use curl (http://curl.haxx.se/.) I prefer curl because it
handles more protocols (FTP, FTPS, TFTP, HTTP, HTTPS, TELNET, DICT, FILE and
LDAP) than wget.
-Dan
On 4/19/06, Bryan Stevenson [EMAIL PROTECTED] wrote:
don't like plural table names?
ActiveRecord::base.pluralize_table_names=false in environment.rb
want to override a table name?
class someTable ActiveRecord::Base
set_table_name some_crazy_table_name
end
Now that I'm finished
What do you do if you have UserID used in a table twice? Such as maybe if
you had the need to track the user who did the original record creation and
who the last user to update the record was?
I tend to prefix these link tables with LKP_ and I got into the habbit
because they were tend to be
On 4/19/06, Bryan Stevenson [EMAIL PROTECTED] wrote:
With the exception of the adding a new field in the DB and it's avaialable
evrywhere bit, the other examples are easily handles by CFCsone method to
update...another to insert...they do different things...just like your
example:
First
I have a friend with an insurance company application that doesn't work well.
The app keeps up with insured customers, keeps track of rates and such.
I'm thinking I could build it better in CF. Is there anything that already
exists? Something I could build upon and customize?
Thanks,
Will
I'm going to have to do some serious thinking about this. Performance on
the mailer is a lot slower than I'd like, and I suspect its because I'm
using evaluate. Here's what happens:
1) Customer saves their message content, which might look something like:
Dear #firstname# #lastname#:
Blah
The first release candidate of CFMBB is now available for download from
the CFMBB Project Page (www.cfopen.org/projects/cfmbb)
For discussion and a demo, visit www.cfmbb.org
Here is a complete list of major features added to Ray's Galleon 1.5
o BBML / Smilies
o Signatures
o Avatars
The first release candidate of CFMBB is now available for download from
the CFMBB Project Page (www.cfopen.org/projects/cfmbb)
For discussion and a demo, visit www.cfmbb.org
Here is a complete list of major features added to Ray's Galleon 1.5
o BBML / Smilies
o Signatures
o Avatars
I surely thought I remembered one from
when I built my reader.
Rob: Could it have been one of the interim specs you were looking at? 'Cause
there was all kinds of odd stuff in there at certain points... particularly in
the pre-IETF drafts. In addition, there was (and is) a lotta stuff on the
SR. ColdFusion Web DeveloperCompany: TEKsystems, Inc. Location:
Cleveland, OhioCategory: Information Technology JobsRate: Negiotable
per HourJob Type: Direct HirePosting ID: 853437Posting Date:
4/18/2006
SR. ColdFusion Web Developer Job
101 - 188 of 188 matches
Mail list logo
