Jeremy, M@'s right. The BD Interest list really
is the best place to discuss this:
http://www.newatlanta.com/products/bluedragon/self_help/archive_search/index.cfm
For
one reason, it's staffed by our engineers and many enthusiastic customers who
all love to help solve any such problems.
Toward Better Error Handling - Part 4 (Page-Level Error Handling)
http://www.sys-con.com/story/?storyid=41772DE=1
Hope some of that's helpful.
Charlie Arehart
CTO, New Atlanta Communications, makers of BlueDragon
(678) 256-5395 [EMAIL PROTECTED]
www.newatlanta.com/bluedragon/
-Original
-code.html
I'll point out as well that after I joined New Atlanta, I got us to add a
CFPAUSE tag (CFPAUSE Interval=x).
Charlie Arehart
CTO, New Atlanta Communications, makers of BlueDragon
(678) 256-5395 [EMAIL PROTECTED]
www.newatlanta.com/bluedragon/
-Original Message-
From: cfaussie
Ryan, if youre just asking for how
to determine the identity of the authenticated user, check out cgi.auth_user
(and the related cgi.auth_type).
Or are you asking something else? (Even
reading the replies since this original note, Id rather ask than guess.)
/Charlie
Well, just to be clear, when you say you have 42 sites running under the
root, you still have only 1 web site in IIS, right? And your need was to
create a new web site with its own docroot other than the one that all the
others are under, right?
That's specifically what this IISAdmin tool does
Jeremy, if I'm understanding you, you could replace the loop with this:
cfset IDs = valuelist(CChanges.CID)
Does that work for you?
/charlie
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of cfgroupie
Sent: Monday, May 01, 2006 9:31 PM
To:
I think a lot of the reason we haven't "seen much"
Flex/Flash work out there was the high cost for Flex (1). Flex 2's pricing model
should help there quite a bit. There are still a lot of people under the
impression that "flex will cost". It's not quite true. If you want to, you will
be
Yep, it's a real service. I have 7.1, not 6, but it's there in my task
manager (though not the name of the EXE running for any of the CFMX main
services, as far as I can see). The following, though from 2004, may still
be of value:
First things first: is /realestate the name of a server on your server? If
not, that's your problem. (I'm not familiar with that demo app to know if
that's hard-coded there or not). You'd need to change that to the name of
your server where you have CFMX (and thus the /flashservices/gateway)
Have you checked out those at xmethods.net? They're the
classics used often by most getting started with (or demonstrating) web
services. There are several there, especially if you take the link at the bottom
of the page for "full list".
/charlie
From: cfaussie@googlegroups.com
quot;
VALUE="Australia"/ /CFINVOKE
I'd appreciate any help with this.
- Original Message -
From:
Charlie Arehart
To: cfaussie@googlegroups.com
Sent: Wednesday, June 07, 2006 10:56
PM
Subject: [cfaussie] Re: Currency
conversion webservice
Have you checked
Now we see why I said if I'm understanding your question correctly. :-)
I just thought you wanted a more CFQUERY-like capability in Java. I
certainly wasn't trying to suggest it was as good or better than CFQUERY.
:-) Good luck in your search.
/charlie
-Original Message-
From:
someone else had written!
(PS: Dale: Amen to that - but I am only a small voice in the crowd)
On 6/15/06, Charlie Arehart [EMAIL PROTECTED] wrote:
Barry, if I'm understanding your question correctly, have you looked at
the
JSTL (JSP Standard Tag Library)? It makes JSP look a lot more like
As for CF/Java integration, f you want to get a head start on that class,
and get pointers to resources to learn more, see a CFDJ article I did last
year:
Getting Started Integrating CFML with Java .NET
http://coldfusion.sys-con.com/read/86127.htm
Hope that helps. See also the chapter on Java
Shane, that must have been over a year ago that you found
BD.NET to be in beta. It has long been in production use by many companies now,
not the least of which is Myspace, which many know was a CF5 site that was
gasping until they decided to move to .NET and found BD.NET a great way to make
Are the client browsers both within the same network? If not, one could be
going through a proxy that may be having a problem honoring the redirect
that the CFLOCATION causes (some think CFLOCATION sends the users from one
page to another on the server, but instead it causes the server to tell
of a sudden there were no more issues.
Probably irrelevant to most of us but its worth taking note, just for anyone
thinking of installing jrun updater 6 on a windows 2003 server.
Joel
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Charlie Arehart
Sent
What web server are you using? There are ways in both IIS (and even easier
in Apache) to handle this in the web server.
Some resources:
http://httpd.apache.org/docs/1.3/misc/rewriteguide.html
http://support.microsoft.com/default.aspx?scid=kb;en-us;313074sd=tech
Hope that helps.
/charlie
Are you assuming that the query is returning a single
record? If it does not, then because your creation of the array and struct are
outside the loop, you *will* get duplicates simply because you already have a
value from the previous record. If you want to make it so you never process more
Yes, that would surprise me, too. Can you tell us where you found the
designer within CF's directories?
/charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Chris Velevitch
Sent: Tuesday, August 08, 2006 4:27
That's aGREAT takeaway--and indeed mantra--for us,
Robin:
Don't try to sell the CF
Platform to business. Sell CF Solutions to
business.
/charlie
http://www.carehart.org/blog/
From: cfaussie@googlegroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Robin
HilliardSent: Tuesday, August
they did give use.
I'm not 100% sure if your supposed to use it, but you can.
Regards
Dale Fraser
http://dale.fraser.id.au
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart
Sent: Wednesday, 9 August 2006 12:47 AM
To: cfaussie
Justin, did you ever resolve the problem you raised
below? Did the suggestions help at all? Just
thought I'd double-check in case you might have any useful news to share from
your experience on this problem.
/charlie
http://www.carehart.org/blog/
From: cfaussie@googlegroups.com
Hey, Gary, yes, I will put up a hand and say I do remember
the CFStudio debugging prior to CFMX and did get it to work. In fact, I used to
give user group talks on it. There were issues, and times it didn't work. The
bigger problem was simply that the feature was so hidden in Studio that
Thanks for that, Dale. And it's really interesting that all
this should come up today, as literally just this morning as I woke up, I had an
idea come to mind of creating a "blog of the day" kind of review
mechanism. It could serve a similar purpose to your idea, Dale. Again,
there are
Great to hear, Geoff. Speaking of making it pay, have you thought of
following Ray's lead in recognizing that while some will not pay cash, they
will buy stuff off an Amazon wishlist. Not necessarily something for the
company's benefit, but certainly for yours.
I'll be very interested to see how
Wow, they've been very responsive to me. Are you sending to the support
address ([EMAIL PROTECTED])? If not, maybe there's another you
found and they have a problem of getting email to that. (And they're human:
even if you found what you use in someplace that they said to use it, it
could just be
Patrick, just as one example, my blog (which
usesBlogCFC) does indeed send that "category" element, and it's based on
the "category" I pick in my site. As I said in an earlier note, though, the
categories I choose are based on my own presumption that people looking at my
blog already know
Just a point of clarification, in case anyone missed it:
Steveindicated that the problems he's seen aregenerally due to the
swsoc.exe process. That's the ColdFusion MX ODBC Server service,
which is there to process requests for ODBC datasources (which he said he
was using for his Informix
Do you want one integrated with CFML? Hal Helms just
mentioned on last week's podcast how much he liked. I've asked him (by email) to
confirm if this is what it means, but it looks very nice:
http://www.cftagstore.com/tags/cfsortable.cfm
Here's a nice
demo:
Lest anyone just drop that code into the application.cfm, do be careful as
Joel says at the end (and as later notes indicate how time-consuming this
can be). Note that he suggests it for reloading the apps on first launch.
While the new application.cfc has a method where you can put this code to
Yes, as Scott and M@ have said, the first thing to check is whether that
feature (queryposition) is a new one in CF7. A quick look at the livedocs
shows that it is (they have started identifying what release a given feature
was introduced in, which is very helpful.)
I hadn't noticed this one
, Charlie Arehart [EMAIL PROTECTED] wrote:
Lest anyone just drop that code into the application.cfm, do be
careful as Joel says at the end (and as later notes indicate how
time-consuming this can be). Note that he suggests it for reloading the
apps on first launch.
While the new application.cfc
aussie@googlegroups.comSubject: [cfaussie] Re: Bluedragon
woes
I notice over at mySpace I am starting to see:
myspace.com/error.aspx?page=index.cfm
But which made the error?
From:"Charlie Arehart"
[EMAIL PROTECTED]Reply-To:cfaussie@googlegroups.comTo:cfaussie@googlegroups
Drew, are you running on CF7, by chance? If so, there is a new
getsoapresponse() function that may help. I don't know for sure, but it's
worth checking out.
Beyond that, you may also want to look into the underlying Apache Axis
project upon which CF's (and BD's) web service interaction is
There's also an entire section of the Adobe site with other solutions:
http://www.adobe.com/devnet/activecontent/
As for searching to find such things, the key would be in using the term
active content, since that's the term by which MS refers to the concept:
No worries. I only dug into it myself for the first time a couple months
ago, so I appreciate the challenge you faced. :-)
/charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Kear
Sent: Monday, September
M@, are you referring to interactive step debugging? Or
something else? I'd just not heard of any plans for Adobe to do step debugging,
so just curious what you may have heard.
In the meantime, for those interested, I have started a
series of entries on the interactive step debugger from
Shane, you can indeed "attach a debugger" to CFMX (using
Eclipse, as Haikal Saadh requested yesterday). That's exactly what FusionDebug
is (fusiondebug.com).
No, it's not free, but it's because as you hint CFMX is not
"done like JSPs", so the company (Intergral) had to go through some
I don't want to sound like a broken record, but since it's unclear if Barry
has seen or will see the note I'd sent an hour or so before his, I'll say
again that there is indeed interactive step debugging for CFML now, in
FusionDebug, albeit it's not from Adobe and it's not for free (though it is
Or, are you analyzing your web server logs (or some tracking in your CF app)
to monitor the traffic into your site? You could be experiencing a sudden
change in bot visits, such as from search engine indexers. Many don't make
the connection but since such tools don't preserve cookies sent by the
Also check out the upcoming Adobe Connect Present.
http://www.adobe.com/products/presenter/
Sounds like it may do a lot of what you want.
/charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Chris Velevitch
Hi, Barry. Was just curious if you might be offering the opportunity for
remote users to watch via Breeze? Even if the speaker is local, if you have
a net connection, you can use Breeze to let others watch in. :-)
Beyond that, you can also then record the presentation (even if you don't
want to
Sure, all that makes sense. We've been miscommunicating a bit. On point 2, I
wasn't proposing that folks watching a recorded presentation have remote
attendees. Anyway, beyond your group I was also talking as much to the whole
CFAussie list. Hope the suggestions and resources will be helpful.
know about CF!
I'm sure you're not surprised to hear that Google CodeSearch has a Google
Group:
http://groups.google.com/group/Google-Code-Search
Sign up and add your voice!
B)
Charlie Arehart wrote:
That's the spirit. It's better to light one candle than to curse the
darkness
FusionDebug: www.fusiondebug.com
I'll also point out several blog entries I've done on it:
http://carehart.org/blog/client/index.cfm/fusiondebug
Besides entries on getting your started using it, and helping explain why
you should, I also offer some tips and traps to save you heartache (as can
Jeremy, there are known instances where breakpoints may not fire. The good
news is that it's not a bug in the product, but either simply a setup issue
or CF optimizing the code such that the CFML source no longer exactly
matches the underlying Java classes (not FD's problem, in other words).
In
Right: when you're in the method itself you do have the info. I'll ask the
guys about having access to it always (since if it's stored in a variable,
it would seem it should be accessible to dig into as a struct or array). May
be some challenge they can't overcome, though. Remember: they did all
Chris, I think you're looking at the wrong screen, mate.
Are you expecting that to look like those in figures 2.1 and 5.1 in the User
Guide? They are what it seems you're expecting, showing creation of an
Eclipse debug configuration. The steps to get to that screen is in section 5
of the
Chris, beside what Andrew has offered, there's a specific FAQ on the
question you raised:
http://www.fusion-reactor.com/fusiondebug/support-breakpointsDontFire.html
http://www.fusion-reactor.com/fusiondebug/support.html#breakpoints4
I also point out some tips that are note listed there, which
Yes, I'm glad to see that they did that. I was about to propose it myself.
Now, I want to say something to them if they're reading this, and to you
(since you said in an earlier note that you had read all the support
articles and docs). This challenge with the default setup of multiple Jrun
Thanks for asking, Brett. :-) I would absolutely love to come. It's been 5
years since I was last there (honeymoon) and 10 since I lived there (in
sunny Canberra).
But I'm now an independent (which means no one to pay my way), so I have to
weigh it carefully. I'm in Atlanta GA, so the airfare
Chris, did this response make sense for your situation?
/charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart
Sent: Tuesday, October 10, 2006 11:56 AM
To: cfaussie@googlegroups.com
Subject
-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Chris Velevitch
Sent: Monday, October 16, 2006 12:32 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFC Explorer and Application.cfm
On 10/16/06, Charlie Arehart [EMAIL PROTECTED] wrote:
Chris, did this response
?
/charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Chris Velevitch
Sent: Monday, October 16, 2006 1:06 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFC Explorer and Application.cfm
On 10/16/06, Charlie
Well, if an uninstall doesn't work, here's a workaround:
just go into the Windows "Services" panel (from "control paneladministrative
tools") and a) stop the CF 6.1 instance and b) set its properties to "disabled"
so that it no longer runs. Don't forget to turn off all services related to
Just to clarify, BD grew out of a project (much like Smith
in concept) in 1998, by a company in Scotland called n-ary (who remain partners
in BD to this day). Back then they had grand plans of releasing it as an open
source project as well, but the realized how big it was (and this was
Matthew said:
I've just read this article
(http://www.adobe.com/devnet/server_archive/articles/cf_locking_best_practic
es.html)
on locking read/write to application scoop, however the article seems old,
is this still relevant? Note: the project I'm working on does not use
application.cfc.
would stay the same.
Shane
On 11/18/06, Charlie Arehart [EMAIL PROTECTED] wrote:
Yes, that is indeed old news if you're on CFMX (6 or above). Here's a more
updated version of the state of affairs regarding locking and shared scope
variables:
http://www.adobe.com/cfusion/knowledgebase
Yes, BD did have it first, but because they announced it before Scorpio was
settled it seems a good chance it will be added. In the meantime, the mod
offered by Damon certainly helps those who want to check out the concept and
indeed use it now in CF 7.02.
This reiterates a point I made many
Peter, when you say you followed the wikipedia instructions, do you just
mean the FCK wiki, at
http://wiki.fckeditor.net/Developer's_Guide/Configuration/Built_in_File_Brow
ser? And did you see there the link to more specific directions for CF
folks, at http://wiki.fckeditor.net/ColdFusion? Just
OK, but are you saying you have tried the file browser test mentioned at the
bottom of the CF page?
/Charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Peter Tilbrook
Sent: Saturday, December 02, 2006 5:14
Tilbrook
Sent: Saturday, December 02, 2006 10:41 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: FCKEditor file browsing (was RE: [cfaussie] Re:
Download Farcry)
Where is that exactly Charlie? (BD 7 sounds like it will be amazing also)
On 03/12/06, Charlie Arehart [EMAIL PROTECTED] wrote:
OK
I don't use or support the tool, if you're asking for my thoughts, Mike. I
was just responding to Peter's request for help when I found what appeared
to be a relevant post. It seems that it offers more than just that
conclusion to problems one can have, and solutions.
But if you're saying for
I think you've got it right in your earlier conclusions, Steve. When it
comes to using Java functionality from within CF, such as only
undocumented from the perspective of a CF person learning about them from
the CF docs. They're the same, real java methods available with any Java
class and CF is
Murray, what do you really mean by cfhttp the page in Firefox (or IE)? Do
you mean page a.cfm does a CFHTTP that calls page b.cfm, which includes HTML
to show a Flash file? And you call page a.cfm from the browser?
And what if you just call page b.cfm from the browser? Does that work
See this:
World's Top Companies Use ColdFusion MX
http://www.adobe.com/products/coldfusion/proven/
Also, Ben Forta has long maintained a list of shops using CF, and he offers
a subset of highlighted ones (from which I imagine many of the above were
drawn, yet offers still more):
Well, to be accurate, MySpace is not a CF site but it is a CFML site.
It runs on BlueDragon, to be specific, BlueDragon.NET.
That latter distinction is as important because since it's a .NET shop, you
hear a lot of MS folks and fans saying proudly that it's a .NET shop. They
don't mention
Thanks, Mike, but in case anyone has tried to just drop that XML CFFORM
example into a CFML page, you'll have found that the references to
personbean and qstates make it fail. :-)
To save the trouble for all you good chooks just getting to work in OZ,
here's a version that does work (creates a
For those folks, point them to Dreamweaver's ability to do so (as well as to
build SQL queries, build CFCs, build calls to them and web services, and
more). Yes, yes, many CF folks will raise all manner of complaints against
Dreamweaver. That's not the point here.
You've got vb type developers
Folks, I did get info for you, both an explanation and a solution for at
least some wanting to verify certs.
First, it turns out that the Adobe side of the house had never posted names
of folks getting certifications (for security and privacy reasons). As such,
perhaps along with the hassles
I won't call it best practices, or even current, but I'll point out that
(for perhaps other's interest) I did an article in the Aug 2006 CFDJ,
Errors in Your Code: Handling, debugging, and testing for them, which is
available online (like all my articles) via links from:
I don't know that it will be fruitful to start a discussion of the value of
certs. That's been debated many times, and there are as many opinions. :-)
But I do want to respond to the comment, But what would be the point if
Adobe wont let anyone verify they're certified. Again, it's not that you
Yes, that's what they're thinking of doing. The challenge was handling the
people from the past. If they've not opted in to being contacted (which
Adobe does ask), then Adobe is hard-pressed to contact them to ask that
permission. This is what they alluded to in the call. And while doing it
for
Sure, no problem. I'd never used it so was just sharing it for your
consideration.
Given that you're reaching the end of your rope, I'll point out that
BlueDragon has built-in spidering, via CFINDEX (and a new Type=WebSite)
option. You could of course control scheduling using CFSCHEDULE (or the
Well, the vspider utility is a command line tool. It's at
C:\CFusionMX7\verity\k2\_nti40\bin\vspider.exe (or
C:\CFusionMX\lib\_nti40\bin\vspider.exe).
And CFEXECUTE can be used to call any command line tool. Are you asking for
more than that?
You can find more info on it at:
Sorry. I'd just missed that. Hope it may help someone else in the future.
Before you give up, is this a public site? Are you aware of the Google
site search feature? That would be free. I blogged about it (from a
slightly different perspective) at:
Dale, can you try calling the webservice using ?wsdlmethod=methodname?
That works if the methodname takes no args, or if it takes simple args you
can add them as parm1=parm1value. Does that give you a response? It may
give clues. If you do it in a browser, be sure to do a
view source to see the
Well, still another alternative to LiveCycle (which may be too much for som)
is the XPAAJ (XML/PDF Access API for Java) API that Adobe has created and
sells, but is now free to licensed CF users. Ben discusses it and offers
some sample code at this blog entry:
Zac, I've never seen this. I run 7.02 on Windows (XP) as well, with a dual
core Dell, 2 gig ram, IIS, etc. I've run both standalone and multi-server
option. If you're really stuck for ideas, you may know all these but here
are a few:
You say you've stopped the services, but are you sure to have
I'll point out that our Atlanta CFUG list has just such a community list,
and it's great for solving this very problem. When things get too out of
control, folks just plead that it be taken to the community list.
Since you're using Google Groups, I'd say someone should just create
Aw, shucks, Peter. I put my pants on one leg at a time (or should I say,
debug my code one line at a time) just like everyone else. :-) But thanks
for the kind words.
And I should say I look forward to meeting many of you in March at the WebDU
event. I'll be there speaking, both with a general
Here's an interesting free (Windows only) alternative to better file
searching. I wrote about it when I was at New Atlanta:
http://bluedragon.blog-city.com/tool_tip_for_better_windows_file_searching_u
se_agent_ransack.htm
It even offers a means to build RegEx's by example (you fill in the
ransack there is a Test option. It doesn't work with the test
phrase:
INSERT INTO MY_TABLE_NAME WITH (NOLOCK)
Oh well.
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications Hunter-New England Area Health
Service
p: +61 02 49213589
m: 0413800242
Charlie
Ah, then that would suggest that the date of the event is Wed *March* 21,
right? The day before the WebDU event. :-) So it's not this coming week!
In fact, it's the evening after the 4 separately priced workshop sessions
that are also being held that day before (though I should note that only my
What version of CF are you using? In 7, there is the new RESULT attribute
allowing you to name a variable which is a structure, and one of its keys is
SQL and another is sqlparameters:
CFQUERY NAME=demoq DATASOURCE=cfdocexamples result=test
select * from employees
where lastname =
OK, I've done a little digging and this works in CFMX 6 and 7:
CFQUERY NAME=demoq DATASOURCE=cfdocexamples
select * from employees
where lastname = cfqueryparam value=smith
cfsqltype=CF_SQL_VARCHAR
/CFQUERY
cfdump var=#demoq#
cfset factory = createobject(java,
Duncan, I can't think of any security concern to note.
As for your 3rd question, there is indeed a way to do it without this old
trick. It's new as of CFMX 6, and involves the new J2EE sessions feature
that's settable in the Admin console. That means it's for all apps on a
server. It can't be
Welcome to the CFAussie list, Jeff. :-) I don't see you having posted
before, so will presume that you've just joined.
And to add to his note about CF-based Google Custom Search Engines (CSEs),
I'll point out that I had created one right around the same time he did, and
we ended up sharing the
Yes, as Scott later said, Andrew, you don't want to confuse caching of the
query with what Duncan said, which was caching of the query plan.
And as Scott clarified, you definitely don't want to spread the
misconception that cfqueryparam is just for security. The value in query
plan caching can
Goodness, too many caches! Now you're talking about cached templates,
Duncan. It sure seems to me that Andrew was referring to query caching,
since he said, The query is only cached when you tell it to be cached and
later mentioned storing data in shared scopes. And then of course Scott was
This may be a good place to point out that there is a free service
(mail-archive.com) which serves as a place to archive and provide search/web
interface for mailing lists. Now, with cfaussie using googlegroups, one may
ask, why bother, but I'm just answering the question that Steve may be
asking:
So, are you saying that removing the select * does or does not solve the
problem? I just want to know where this thread is crossing from solving your
problem to discussing the broader issue of select *.
I'm actually surprised to hear that you would ask for a spelling out of the
reasons for why
Well, sure, like the point about Select * being bad when you select more
than just the columns you need, so too is the benefit of CFQUERYPARAM (from
its performance perspective) only valuable for databases that support bind
variables (or what SQL Server calls parameterized queries). I'm sorry
Again, this is going down the template cache and query cache routes, in
trying to solve Duncan's problem with his CFQUERYPARAM error. Please do tell
us, Duncan, if it's just the SELECT * or if indeed the problem remains even
after that.
But the points Andrew makes before are indeed often
Mike, I'll take a shot, but first I want to admit I'm not sure I'm
appreciating all the nuances of what you've put forth. Are you saying
basically that your insert/update fails because it expects either a date or
null for this dateapproved column? It's not clear, because you never refer
to a
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
How about
cfqueryparam value=#myDate# cfsqltype=cf_sql_datetime null=#not
isDate(myDate)# /
/Max
On 3/5/07, Charlie Arehart [EMAIL PROTECTED] wrote:
Mike, I'll take a shot, but first I want to admit I'm not sure I'm
appreciating all
Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Charlie Arehart
Sent: Saturday, 3 March 2007 3:44 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CFQUERYPARAM was RE: [cfaussie] Re: @#$!!
queryparam
Andrew, I didn't say anything about SPs, nor did I
Right, then as it seems, this all comes down to the point made some time
ago: if you use SELECT * in a statement using CFQUERYPARAM, you can expect
trouble if you add columns to the table. Among the places this is discussed
is here:
http://www.1pixelout.net/2004/06/16/cfqueryparam/
Hope that
Well, I know I just wrote my last note so you can't have seen it yet, but
I'll answer more directly this later question of yours, Andrew: there is no
connection between CFQUERYPARAM and the cached queries feature. Are you
saying you have some MM resource that suggests otherwise? That would be
1 - 100 of 557 matches
Mail list logo