Dear all
I'm having a bit of trouble installing MX7 std trial on my dev win 2003
server R2 / iis 6
CF5 enterprise has been running fine on it for ages. I would like to retain
CF5 along the lines of http://dfdj.sys-con.com/42069.htm so I renamed the
CF5 CFIDE and CFDOCS before starting.
+ 1 again for Viviotech. I've been very happy with my VPS bluedragon
account. I'm not doing much on there right now but they are very helpfull.
The control panel is great and when you want you can login through ssh and
surf around the linux box, keep yourself up to date on the non-windows
world.
I've been digging around with Hibernate lately in order to assist with
a J2EE development effort and it got me wondering...
Will Transfer or Reactor (or both) actually *create* the data model
for you from scratch? Given an empty database to connect with,
Hibernate can create the tables and also
Hello. Sorry I cannot answer your question but I have also been using
Hibernate a little recently and was not aware that it could do such a thing as
create your tables in a blank database for you.
Can you point me in the direction of documentation of how to do this I am very
interested in
Hi All,
What are people in the knows experience of running CF in distributed mode?
Better? Faster? More secure?
Cheers
Neil
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Sadly, I can't. My involvement came after the initial creation was
done. I'll talk to the guys who did it, though, and see if I can find
anything out.
On 2/20/07, Martin Thorpe [EMAIL PROTECTED] wrote:
Hello. Sorry I cannot answer your question but I have also been using
Hibernate a little
Since about noon yesterday morning Eclipse has been giving me major problems.
I've come to really love it, but it's kinda unusable right now and I'm begging
anyone out there to help. I have projects set up on both my dev box and
production box (both via mapped drives). Everytime I try to
I had to do a silent install and turn off DEP to get MX 7 installed on
my 2003 R2 machine.
Here's a link on how to silent install:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=87bd20f4
To turn off DEP just right click My Computer and choose properties. The
DEP settings are under
Hmmm... Thanks for all the responses. It seems I have some research to do...
Che
-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 7:26 AM
To: CF-Talk
Subject: Re: CF Hosting Question... 25+ domains with one account.
+ 1 again for
You should try the cfeclipse mailing list
-Original Message-
From: todd sharp [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 7:42 AM
To: CF-Talk
Subject: Need Eclipse Help!!!
Since about noon yesterday morning Eclipse has been giving me major
problems. I've come to really
Hi all,
I have a a few question about using cfc with dynamic tables.
i.e.
cfquery
.
FROM #ARGUMENTS.tablename#
.
/cfquery
now I would normally pass that argument via the calling page as a request
variable.
First question, is that safe enough?
I wasn't sure if it was so I thought
Todd,
3.2.2 is the latest for the 3.2.x builds. There is also 3.3Mx series as
well.
I have tested CFE on 3.2, 3.2.1, 3.3M4 and 3.1.1.
3.3M5 is not supported to date I blieve for CFE 1.3. Unless there was a
critical fix for a different perspective that you need, I would recommend
just using
Reactor does not generate data table. I have not used Transfer as yet.
There is a CF Hibernate open source project here:
http://cfopen.org/projects/cfhibernate/
I am not sure how active that project is though.
Teddy
On 2/20/07, Rob Wilkerson [EMAIL PROTECTED] wrote:
I've been digging
Rob,
Reactor and Transfer operate in the reverse of what you're looking for: they
introspect the existing database to create DAOs, Gateways, TOs, etc. Reactor
(probably Transfer, too; I'm just not sure) can also create aliases for your
column names, if you define them in the XML config. But if
Are all the VPS accounts at Viviotech on Linux?
Are any on Windows?
Rick
-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 7:26 AM
To: CF-Talk
Subject: Re: CF Hosting Question... 25+ domains with one account.
+ 1 again for Viviotech. I've
At 15k or 1.5k a QoQ is pretty small for overhead, even a shared hosting
environment should handle this fine. The problem with Query caching on a
shared environment the # cached queries is controlled by the host and who
knows what other systems are on that box that might eat that # away. The
With the growing number of ColdFusion developers using AjaxCFC for
jQuery, I felt it was important to announce a new development that will
dramatically benefit their ability to deliver RIA applications.
I'm proud to announce that the open source jQuery Project and Jack
Slocums open source Ext
Eric,
We are also a Payflow Pro customer and received much the same treatment.
I tried all the numbers I could find on their web site but no one
answered or knew what they were talking about. This was a very bad
experience for us. I believe we might soon switch away from them as our
vendor.
Leon,
If you find a better choice, please let me know. This put us down for an
hour and a half.
Rey...
Leon Oosterwijk wrote:
Eric,
We are also a Payflow Pro customer and received much the same treatment.
I tried all the numbers I could find on their web site but no one
answered or knew
Thanks Teddy, I rolled back to 3.2.1 - still was having issues so I recreated
my workspace and did about 10 other little things and everything seems back to
normal.
Todd,
3.2.2 is the latest for the 3.2.x builds. There is also 3.3Mx series as
well.
I have tested CFE on 3.2, 3.2.1, 3.3M4 and
Where can I find J-Query or AjaxCFC examples. I went to the websites and found
great documentation but i did not find any component examples.
Furthermore is anyone creating custom tags for the components or shoud I start
getting familiar with javascript. urgh.
-- Original Message
FR 2.0 under Solaris 9
In a multi-server but shared environment, we want to offer FR in each
instance but disallow the ability to add instances. We want the ability to
add instances only available to a single (admin) instance.
Basically we want to the customers to monitor their own CF instance
Hi Dwayne,
Ext 1.0 and Ext 1.0 for jQuery has not been officially released. Its
still in alpha and work is being done to get things finalized.
In the interim, here are some resource links for both AjaxCFC and jQuery
that will help you get started:
AjaxCFC:
Examples:
Rob,
Apologies for the self-promotion, but I have a (free) tool that does this
(though it isn't technically an ORM tool).
blog:
http://steve.coldfusionjournal.com/create_tables_with_data.htm
see the Synchronize Database Structure presentation:
Slightly off topic but if you want to understand a little more about
transfer Mark Mandel (transfer creator) has just been interviewed on
cfFrameworks.com. Heres the link:
http://www.cfframeworks.com/blog/index.cfm/2007/2/20/Mark-Mandel-talks-about-his-Transfer-ORM-Framework
HTH
On 20/02/07,
Hi, I'm having a problem with Verity on MX6.1 on a Linux box. The problem is I
can't seem to get either the cfindex tag or the administrator to index any
files at all. It seems to work fine on my Windows server. I don't have any
problem indexing from a query either - but I need to index
Brilliant
After a -lot- of messing around, the silent install finally worked.
Thanks!
I have to say that CF 4.5 and 5 always installed like a dream (for me). I
heard a lot of tales of woe when MX 6 came out which rather put me off
upgrading but I really would have thought it would have
Dwayne,
If you download the latest package from RIA Forge, you will get examples
packaged with the code. However, this comes up now and then so I'll
share a simple example here.
You need to start off by including all the appropriate libraries (of
course your paths will vary):
script
I am running ColdFusion MX 7 (7,0,1,116466). Mail is getting into the queue
and processing however it is only doing them one at a time. I have an email
that goes out nightly to about 1800 users and it is taking about 8 hours for
all the email to leave. Even during the day when there is much
By the way, why exactly does cfqueryparam prevent caching?
The query still looks the same in the end using some custom
cf check or cfqueryparam check. Why didn't MM work around
whatever the problem is?
There's no inherent reason, beyond that's how they made it. I seem to
recall someone at
The problem with Query caching on a shared environment the #
cached queries is controlled by the host and who knows what
other systems are on that box that might eat that # away.
The application scope approach bypasses that issue.
While you can bypass the fixed number of cached queries
Thanks, all. Since I saw no evidence that either tool would do this,
I thought I'd ask, but since I also didn't see any evidence with
Hibernate...well, it does it, maybe other tools just don't market that
capability either. I guess that's not the case.
Nick, I'll definitely look at the
Are you running CF standard or enterprise? CF Standard does send out emails
fairly slow, and I believe only uses 1 thread. You can try the free version
of IMS - IMS Lite which I believe does 5 threads. We've switched to using
it in the past to speed up mail delivery with great success. Now
Rob,
If you are looking for Transfer presentations, Mark links to a few from the
Getting Started page of his documentation:
http://www.compoundtheory.com/transfer/documentation/gettingStarted.html
Steve
Nick, I'll definitely look at the interview with Mark. I've also
heard about at least one
Todd,
That is good news. If it happens again, it would be to point it out in the
future to see if Eclipse is introducing changes that CFEclipse needs to
cover.
Mark is a troubleshooter of one. It takes time sometimes to adopt new
releases that may have changed the implementation.
Teddy
On
We are using standard, however this has never been an issue in the past. This
started happening a little over a month ago. Previous to then, it would shoot
out 1800 emails in about 10 minutes.
I'll check out IMS though, thanks!
Are you running CF standard or enterprise? CF Standard does
In that case it's likely that the culprit is your mail server. Perhaps they
enabled some rate limiting on it to fight spam, or maybe it's just
overloaded. I believe IMS can act as it's own mail server, but you will
need to add proper reverse dns entries and do a bunch of other annoying
things to
I am looping though a list that outputting that into a select control (this
is the JS and code that Charlie sent me last week. Thanks Charlie). The loop
works fine as does the select, but when I go to the edit page where I want
to select the item in the list that is in the database, it is not
Doug, Also check out CSS in Easy Steps by Mike McGrath (sold exclusively in
Barnes and Noble for $9.95). It is not the most comprehensive, but it could
be a good quick reference for the CSS stuff you will use very often; like
positioning and inheritance. Good value for what you're getting.
Hi, all.
Anyone know of a discussion/tutorial on the best way to go about
creating a website traffic management/reporting system?
I've been using my own methods for several years, and, while they
work well enough, I know there are bound to be better methods.
I'm looking not just for coding, but
You mean like a WebTrends kind of thing?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be
cfinput type=text name=SubmitterPhone size=15 required=yes
message=You must include a phone number.
When looking at the page source, buried inside a javascript routine I
find
//form element SubmitterPhone required check
if( !_CF_hasValue(_CF_this['SubmitterPhone'], TEXT, false ) )
Yes, but it doesn't have to be quite that extensive...something like
their Standard Package...(whew, even the Standard version of WebTrends
is around $800!!... yes, I'll build my own!)
Rick
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday,
Rick,
Webmaster World has one of the best forums for that topic:
http://www.webmasterworld.com/analytics/
Check them out.
I recommend Sawmill for website tracking data (http://sawmill.net). I've
also read some VERY good things about Mint (http://www.haveamint.com/)
although its only a
Rick,
Last week we deployed new code, here at work, redesigning our
application and session startup and management, specifically for
improving our own click-through user/session tracking on our client's
sites. Now, we're talking about a shared application templated system
that services 1600+
I have a form with a set of checkboxes. There could be any number of
rows of checkboxes, since the fields are populated from the database
(values come from a lookup table). I am passing the number of rows to
expect when the form is processed via the discount_category_count
form field. The set
Rick,
Also checkout Google Analytics (http://www.google.com/analytics/) which
is Google's implementation of Urchin.
Rey
Rick Faircloth wrote:
Yes, but it doesn't have to be quite that extensive...something like
their Standard Package...(whew, even the Standard version of WebTrends
is around
Thanks for the info, Rey... I'll check out the references.
Rick
-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 2:38 PM
To: CF-Talk
Subject: Re: Best Practices for Web Site Traffic Tracking
Rick,
Webmaster World has one of the best forums
Glad I could finally give something back to the community hehe, even if
it was a cut and paste. :) Yall have helped me out greatly in the past!
Richard Meredith-Hardy wrote:
Brilliant
After a -lot- of messing around, the silent install finally worked.
Thanks!
I have to say that
If what is coming from the DB is a datetime object, it won't match a
formatted string. If your timelist contains things like 8:15, try
making your compare something more like:
timeformat(getElectionProcedure1Ret.StartTime, h:mm) eq i
Or course, modify the time format to fit your data.
--Ben
Can you build it for less or = to $800 with the same features? :-)
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential
Hi Pete,
Instead of this:
FORM[ind_inpatient_][i]
I think you might want this:
FORM[ind_inpatient_ i]
-- Josh
- Original Message -
From: Pete Ruckelshaus [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 20, 2007 11:40 AM
Subject: Need help - looping
In the DB, it is just a varchar field.
On 2/20/07, Ben Doom [EMAIL PROTECTED] wrote:
If what is coming from the DB is a datetime object, it won't match a
formatted string. If your timelist contains things like 8:15, try
making your compare something more like:
You've hit on one of the reasons I've asked about this.
I don't have any really high-volume sites, but for some of the
sites that I do track, the database entries really pile up over
the years. And I haven't built in a system for archiving.
So when I go to get stats, it takes a lng time for
Should it be...
cfloop index=i from=1 to=#FORM.discount_category_count# step=1
cfscript
tmp = structnew();
tmp.ind_inpatient = 0;
tmp.ind_outpatient = 0;
if (isDefined(FORM[ind_inpatient_ i]) AND
FORM[ind_inpatient_ i] EQ
A client has requested a change log on their database.
Basically, it's a SQL server database with several hundred fields used
for updating information on specific computer/data systems within a
group of businesses. What they're asking for is when client logs in and
updates their info, they
I use them for my sites that I do SEO/SEM for.
And since it is free, I could use for all my sites.
And the Site Overlay is nice...but the data processing
is manual...
(Man, they can certainly churn out some quick stats!)
But I'm considering doing some things like generating
traffic reports at
I've seen dedicated systems solely for parsing the logs. Can chew up a
lot of CPU resource. But, they (WebTrends) do have a hosted service that
only requires you adding a small scriptlet to pages. They work out
pricing according to your projected page hits, then incrementally raise
you if you
I am running Exchange 2003 and haven't had any problems until this. All out
anti-spam is handled outside by postini and as the web server and mail server
sit on the same subnet all the talking is local, so there isn't any worries
there.
I doubt it's an overloading issue as the system
As some other developers noted, Verisign went down over the weekend and
at a VERY inopportune time. While the error script I had in place
notified me of the issue and I was able to address it, I want to expand
the site's capabilities to handle any future timeout and non-response
issues when
Larry,
The cause of this problem is almost always the inability of the web server
to find the cfform.js file. And it's usually because the CFIDE directory is
outside of the webroot, or not at /CFIDE/
So -- two questions: Does the path /CFIDE/scripts/cfform.js actually
correctly point to a file
Two suggestions:
1. It looks like there is no space between the option tag start and the
selected key word. The HTML is probably there, just not getting
rendered as optionSelected is not a valid tag.
2. Try selected=true... Its slightly more standards compliant.
Probalby not the issue though.
In this specific situation, ColdFusion timed out (not
Verisign) so the CF error trapper caught that exception and
presented the user with a nice error page.
What I want to do is take it a step further so that if my
Verisign call times out, I can override the handling of the
ColdFusion
Les Mizzell wrote:
I shouldn't complain too much, as they don't care how much it costs and
pay quickly - but, is there a more efficient way of doing this?
triggers.
~|
Deploy Web Applications Quickly across the enterprise
Of the features they list...
- Key Metrics Performance Dashboard
- 5-Point Scenario Analysis
- Visual Path and Content Analysis
- Scenario Conversion Analysis
- Geographic Report
- On-site Advertising
- Basic Search Engine Reporting
all I really need is the last one, Basic Search Engine
Hi Dave,
Thats exactly what I had before but the error.cfm template still caught
the issue.
What I'd like to do is somehow prevent the error.cfm page from kicking
in so that the rest of the script can continue and the user is oblivious
to the timeout.
Perhaps I need to trap for a specific
Hey all,
I'm messing around with Application.cfc and trying to set up a logging
routine that fires on onSessionEnd.
Trouble is that it seems onSessionEnd doesn't fire when the session ends -
or rather, the session doesn't end when it has supposedly timed out, so
onSessionEnd doesn't fire.
I
Whew... I think my server would choke... :o)
Thanks for the info on the procedure, however.
Rick
-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 3:22 PM
To: CF-Talk
Subject: Re: Best Practices for Web Site Traffic Tracking
I've
Thats exactly what I had before but the error.cfm template
still caught the issue.
What I'd like to do is somehow prevent the error.cfm page
from kicking in so that the rest of the script can continue
and the user is oblivious to the timeout.
Perhaps I need to trap for a specific
The cause of this problem is almost always the inability of the web
server to find the cfform.js file. And it's usually because the CFIDE
directory is outside of the webroot, or not at /CFIDE/
So -- two questions: Does the path /CFIDE/scripts/cfform.js actually
correctly point to a file within
Anyone using Paymentech's real-time credit card validation? I'm
having a problem with their service because there are circumstances
where they'll send back two replies. It's due in part I think to my
customers clicking twice on the Submit button, so I've got some
Javascript preventing that
Pardon me if this turns into a double posting, but for some reason CF-Talk
isn't getting my emails. So I tried the Yahoo interface once but there's text
there with a link saying it should be done from
http://www.houseoffusion.com/groups/CF-Talk/reply.cfm.
=
I have been tasked by one of my customers to create an on-line sweepstakes.
They want to be able to create a sweepstakes dynamically (title of the
sweepstakes, questions, answers and control types).
Also, they want to be able to run one or more sweepstakes at a time, but
they do not want a link to
Perhaps a start and end date to the Sweepstakes.
Just at first glance.
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 4:10 PM
To: CF-Talk
Subject: Is this the best approach?
I have been tasked by one of my customers to create an on-line
Damn. That would be a good feature to have. Thanks.
On 2/20/07, Adkins, Randy [EMAIL PROTECTED] wrote:
Perhaps a start and end date to the Sweepstakes.
Just at first glance.
~|
ColdFusion MX7 and Flex 2
Build sales
ok, having fixed DNS, I have IMS working on it's own without relay to my
exchange server. It seems pretty darn quick, we'll see when my process kicks
off later tonight.
Thanks for your input Russ.
~|
ColdFusion MX7 and Flex
Thanks again for the reply Dave. Replies below:
You should certainly be as specific as possible within your exception
handler.
Let me be a bit more specific. In terms of a CF timeout, do you (or
anyone reading) happen to know what exception code CF spits out? The
types listed for CFCatch
OK, I got it to work. I just put the list into a database table and it works
fine now.
On 2/20/07, Ben Nadel [EMAIL PROTECTED] wrote:
Two suggestions:
1. It looks like there is no space between the option tag start and the
selected key word. The HTML is probably there, just not getting
As an alternative to dynamically creating/managing directories and
copying code into them, here is what I have done in the past. Each time
a sweepstake is added, modified or deleted, we recreated a .htaccess
file in the root directory that sets up redirects for each sweepstake.
So
Let me be a bit more specific. In terms of a CF timeout, do
you (or anyone reading) happen to know what exception code CF
spits out?
Is the page itself timing out, or something specific (like a CFHTTP call)
timing out? I was assuming the latter - I honestly don't know how you'd deal
with a
Rick,
I would seriously look at Google Analytics:
Benefits
1. it's free
2. it is extensively documented
3. you can manage multiple websites thru one interface
4. there are books written by real authors on the reports
5. the reports are the most user friendly of any I have seen
6. cross section
Larry,
Well, you've found the problem; just not the solution.
The errors show that the file is not being found (assuming the file hasn't
been corrupted or something).
Ignore the CFINCLUDE route for a moment: can you browse to
http://servername/CFIDE/scripts/cfform.js? If not, then the file
SmarterStats is cheep and provides a wealth of information about your
visitor.
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive:
The error is:
Error,jrpp-65,02/19/07,10:36:59,HBC,The request has exceeded
the allowable time limit Tag: cfmail brThe error occurred on line
1346., /purchase.cfm
But the CFMail tag specified there isn't the culprit because I received
the email alerts. Its the cfmail code thats included in
So, if the session doesn't effectively end when it times out, can I use
onSessionEnd to do what I want to do, or is there another way? Or am I
missing something obvious?
-- Josh
What are you doing when the session ends? I've not done much with these
events, but when I played with it, I
Thanks for the tip, Adam...
I've been using GA on the sites that I do SEO/SEM for,
but I probably should expand that to the other sites, as well.
Thanks for the feedback!
Rick
-Original Message-
From: Adam Howitt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 4:49 PM
To:
I would like to use a regular expression to camouflage email addresses in a
forum I'm building. I'd like to replace just the domain name (not the .com or
.net or other extension though) with x's:
FROM THIS: [EMAIL PROTECTED]
TO THIS:[EMAIL PROTECTED]
Where the number of x's exactly
I would like to use a regular expression to camouflage email addresses in a
forum I'm building. I'd like to replace just the domain name (not the .com or
.net or other extension though) with x's:
FROM THIS: [EMAIL PROTECTED]
TO THIS:[EMAIL PROTECTED]
Where the number of x's exactly
I had looked at SmarterStats once before and decided to
create my own, but now I think it would be a wise choice.
Now, I'm doing SEO/SEM for clients, too, and the amount
of info SmarterStats provides is significant.
The Pro version at $199 would be sufficient for now.
Thanks for bringing that
Haven't used FCK much, but I'm curious, can the file browser mechanism be
set to browse a public directory on a remote server (which is in another
city)? In other words, could I set it to browse using a FQDN:
http://www.somesite.com/assets/images/...
Thanks,
Mark
cfset email = ReReplaceNocase(email,
([a-zA-Z0-9_\-\.]+)@((([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3}),
[EMAIL PROTECTED])/
Try this one
Eric
On 2/20/07, K Simanonok [EMAIL PROTECTED] wrote:
I would like to use a regular expression to camouflage email addresses in
a forum I'm building.
Thanks Ian, I figured it out now.
I was trying to update the database based on the session id and token. But
since the session had timed out, those values didn't exist.
As I figured out, you have to use the sessionScope argument in
onSessionEnd to get at those values. Once I did that
On 2/20/07, Rob Wilkerson @gmail.com wrote:
Thanks, all. Since I saw no evidence that either tool would do this,
You know, someone had blogged about using the generated
reactor info to reverse the process-- they'd accidentally blown
away the DB and were able to re-create it using the
On 2/20/07, todd sharp [EMAIL PROTECTED] wrote:...
Any ideas?
I assume you tried the -clean option when starting Eclipse?
If not, DO THAT whenever something weird just starts
to happen w/ Eclipse.
97% of the time that'll fix whatever the issue is.
I would like to use a regular expression to camouflage email addresses in a
forum I'm building. I'd like to replace just the domain name (not the .com or
.net or other extension though) with x's:
FROM THIS: [EMAIL PROTECTED]
TO THIS:[EMAIL PROTECTED]
Where the number of x's exactly
On 2/20/07, Paul Hastings [EMAIL PROTECTED] wrote:
Les Mizzell wrote:
I shouldn't complain too much, as they don't care how much it costs and
pay quickly - but, is there a more efficient way of doing this?
triggers.
AJAX. Field-based editing with a simple log. =]
Hi,
I have forgotten password for my admin account in vista. I am really sorry and
I can't bypass login now. It there any opportunity to restore or reset password
?
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent
Why am I having so many issues with trying to use cfqueryparam on a mysql
date field. I'm trying to return the archive of content for a givin year
2007 and the only way to add a queryparam to it is varchar. Seems like this
isn't the best option anyone have an idea of a better queryparam to use?
On 2/20/07, Casey Dougall [EMAIL PROTECTED] wrote: ...
AND YEAR(DateField) = cfqueryparam cfsqltype=cf_sql_varchar
value=#URL.Archive#
YEAR() doesn't return a date-- you know that, right?
mysql *SELECT YEAR('98-02-03');*
- 1998
Is there anything else I can use here? I want to use
Oh yeah, if you really want to use a date (not sure if there was
more to that question) you could do something like
AND DateField BETWEEN
cfqueryparam cfsqltype=cf_sql_date
value=#createODBCDateTime(url.archive '-01-01 00:00:00')#
AND
cfqueryparam cfsqltype=cf_sql_date
1 - 100 of 122 matches
Mail list logo