On 8/19/06, Jenny Gavin-Wear [EMAIL PROTECTED] wrote:
I have been wondering whether to post this link for a while now, so here
goes.
http://www.fasttrackonline.co.uk/shopping-cart-features.cfm
Constructive feedback would be appreciated.
If anyone is interested in selling this on, please
You could perform a Reverse DNS lookup on the IP address and get something
usefull.
You can test this using www.dnsstuff.com
If the host has set things up correctly though, where a domain has been
given a dedicated IP, the RDNS should point to that. So it may not be that
useful.
Perhaps the
Yep, and there is even more confusion when a load balancer etc comes into
play as it is that IP which you will see, not the web server.
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in
On Sunday 20 August 2006 13:14, Doug Brown wrote:
where at do you get it?
You'll never guess, but VMWare's web site.
--
Tom Chiverton
Helping to centrally compete next-generation models
This email is sent for and on behalf of Halliwells
When trying to display an RSS feed I am getting the following error
An error occured while Parsing an XML document.
Content is not allowed in prolog.
I am using CFMX 7 enterprise, any ideas on what is causing this error?
code-
cfscript
URLToPull =
The feed has a comment before the XML declaration, so it's not valid
XML. You can parse out the comment lines and use what's left as XML.
On 8/21/06, Ian Vaughan [EMAIL PROTECTED] wrote:
When trying to display an RSS feed I am getting the following error
An error occured while Parsing an XML
Both those questions were already answered in the previous post.
Where is the comment in the feed
The feed has a comment before the XML declaration
what do I need to parse out
You can parse out the comment lines and use what's left as XML
-Original Message-
From: Ian Vaughan
I am still getting the error, and have changed the feed to a feed from
the bbc website.
An error occured while Parsing an XML document.
Content is not allowed in prolog.
The error occurred in F:\xmlrss.cfm: line 15
13 : cfscript
14 : XMLContent = trim(cfhttp.filecontent);
15 :
thanks for that, Will, sorted by putting adding a form validation and
restricted max characters in the input box.
What did you think of the Admin and overall features list/functionality?
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: 21 August 2006 04:25
To:
Yes, I suspect something is inserting characters somewhere. Dump the
CFHTTP result to a file and examine it.
On 8/21/06, Ian Vaughan [EMAIL PROTECTED] wrote:
I am still getting the error, and have changed the feed to a feed from
the bbc website.
An error occured while Parsing an XML document.
Hi Mac,
No mySQL version planned in the immediate future,
I would consider reasonable offers for the source code.
Jenny
-Original Message-
From: mac jordan [mailto:[EMAIL PROTECTED]
Sent: 21 August 2006 08:34
To: CF-Talk
Subject: Re: Shopping Cart
On 8/19/06, Jenny Gavin-Wear [EMAIL
ROFL.
Anyway, I was actually wrong, the comment is after the XML dec and it
should be ok.
Can you output the raw CFHTTP to a file, so you can see exactly what
is happening to the XML?
On 8/21/06, Snake [EMAIL PROTECTED] wrote:
Both those questions were already answered in the previous post.
Can anyone help me in setting up Coldfusion 7 and JRun for Clustered
Environment.
I have 4 servers. How can i do the session management settings.
Thanks
Ali
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of
When trying a
cfdump var=#cfhttp.filecontent#
I am getting a 'Connection Failure' ? ??
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: 21 August 2006 11:12
To: CF-Talk
Subject: Re: Parsing an XML Feed
Yes, I suspect something is inserting characters
There you go. Your feed isn't coming through and you are getting a
connection failure message instead, hence the error when you try to
parse it as XML.
Look for a firewall or other problem preventing the connection.
On 8/21/06, Ian Vaughan [EMAIL PROTECTED] wrote:
When trying a
cfdump
On 8/21/06, Jenny Gavin-Wear [EMAIL PROTECTED] wrote:
No mySQL version planned in the immediate future,
rules it out for us, then. Unless you'd like to commission us to convert it
:)
--
mac jordan
home: www.kestrel.org
work: www.webhorus.net
them: www.jordan-cats.org
Ali,
See Brandon Purcell's article on CF clustering...
http://www.bpurcell.org/viewContent.cfm?ContentID=121
-- Mike Wolfe
-Original Message-
Can anyone help me in setting up Coldfusion 7 and JRun for
Clustered Environment.
I have 4 servers. How can i do the session management
I agree with James the simplest way would be to give both applications the
same name in the cfapplication, tag they would then both have access to the
same shared scope variables.
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: 19 August 2006 14:12
To: CF-Talk
where at do you get it?
You'll never guess, but VMWare's web site.
Those sneaky bastards ...
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago,
Can anyone help me in setting up Coldfusion 7 and JRun for
Clustered Environment. I have 4 servers. How can i do the
session management settings.
If you're using CF 7, the easiest way is to use the Instance Manager and the
Cluster Manager in the CF Administrator. If I recall correctly,
Thanks Bobby and everyone. CfContent did the trick. :)
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 20, 2006 4:28 PM
To: CF-Talk
Subject: RE: Quick CF CSS question.
I replied before all the emails came in ;-)
You obviously already had the
I've got something that's a bit OT here. I was going to write something
to parse all of this XML against these XSD's, but I just don't want to
do it. All I want is to be able to import the data right into SQL
Server. I know that xml works as a datatype in SQL Server 05, but that's
not what I need.
besides all the above/below suggestions. There are times you may want to do
this. We have a server wide SSO setup that does this by having one
cfapplication called MAIN and every other application having cfapplication
names that differ. The way to access both is to use two cfapplication
tags.
Does this help?
http://www.awprofessional.com/articles/article.asp?p=102307seqNum=13rl=1
Snake
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: 21 August 2006 14:57
To: CF-Talk
Subject: OT: XML and SQL Server 05
I've got something that's a bit OT here. I was
This is the error we get in the administrator when trying to setup a new
MS Access datasource:
Connection verification failed for data source: AACT
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink
Server]The specified data source is not defined.
The root cause was that:
This is the error we get in the administrator when trying to
setup a new MS Access datasource:
Connection verification failed for data source: AACT
java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver][SequeLink Server]The specified data source is not defined.
The root cause was
I am now getting another xml error after getting rid of the last message
when trying to consume an rss feed.
The new error is
An error occured while Parsing an XML document.
White spaces are required between publicId and systemId.
The error occurred in F:\xmlrss.cfm: line 16
14 :
Has anyone used Hash() in combonation with a private key todigitally sign
some xml?
Thanks
Rolf
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers,
I have not as I don't think this is built into ColdFusion directly. If you
can, find someone who has worked with Google Checkout, as I believe they
need to do just that in order to encrypt the the shopping cart XML. In fact,
you might want to try looking at the Google Checkout documentation, as
That did it. Thanks.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 10:31 AM
To: CF-Talk
Subject: RE: CF 7.0.2 Updater and HotFix hf702-62335 Problems
This is the error we get in the administrator when trying to setup a
new MS Access
A valiant effort indeed Snake, but I've Googled it to absolute pieces.
I've seen that article too... My code to use the object is fine - it's
just blowing up on what it finds in the schema. It doesn't like the fact
that the types are derived from multiple bases. That doesn't seem to me
like it
Hello Paul,
I cannot pass a variable that I create, so I am trying to
find something that is unique and the servers primary IP
is what I have come up with.
Just a question: why can't you create a variable to track this kind of info?
Seems like a natural use for the SERVER scope if you ask
Hey gang,
I'm looking for a good, simple solution to encode one or more URL
variables, pass them through, and decode them. URLEncodedFormat() etc
isn't what I need, as I want to obfuscate the contents of the vars.
I see CharEncode() and CharDecode() would likely do the trick for me,
but alas,
Use Encrypt() and Decrypt()
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 11:08 AM
To: CF-Talk
Subject: URL var encoding/decoding in CF6.1
Hey gang,
I'm looking for a good, simple solution to encode one or more URL variables,
pass them
What about:
UrlEncodedFormat( Encrypt( URL.somevalue, my_key ) )
Then
UrlDecode( Decrypt( URL.somevalue, my_key ) )
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 11:08 AM
To:
The problem with Encrypt/Decrypt, in my situation, is I want to use this
to pass some constant vars in the URL without them being obvious to the
end user. And Encrypt tends to spit out lots of non-alphanumeric
characters. Using URLEncodedFormat() on this works, but then the string
in question
From: Dan Plesse [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 20, 2006 10:56 AM
I have something called the NASDAQ 3000 which I use a gateway
to compile
public companies using 3000 quotes I built up using
the NASDAQ 3000 index. It's something like 3251 not 3000. It
uses a hsqldb
No I don't have something that big running all the time and at 15 minutes
regular intervals.
On 8/21/06, Munson, Jacob [EMAIL PROTECTED] wrote:
From: Dan Plesse [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 20, 2006 10:56 AM
I have something called the NASDAQ 3000 which I use a gateway
I am using a 3rd party authentication plugin for IIS (IISPASSWORD).
But when trying to get the value of CGI.AUTH_USER, it is blank, so it seems
this info is not sent in this variable.
How else can one extract this data, as I understand it is still in the http
header
Which will contain a value
Hi,
Does anyone know what the rules are for ColdFusion including
Application.cfm? I mean, it cannot be as simple as you have requested a
..cfm file, I am gonna look for an Application.cfm now is it? Does it look
into headers etc?
If anyone knows a more technical process for its inclusion,
Ah..
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi97.htm
:-)
-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 21 August 2006 17:34
To: CF-Talk
Subject: HTTP Request Header Authorization
I am using a 3rd party authentication plugin for IIS
It is as simple as you stated. If you run a .cfm file, ColdFusion looks
for an Application.cfm file in it's directory, and in the parent
application's root directory. It will run both of those (assuming there
is a lower level directory Application.cfm file)
-Original Message-
From:
Uh...not as I understand it. CF looks for an Application.cfm in the
current template's directory. If one isn't found it looks in the next
higher directory and keeps moving up the directory tree until it finds
an Application.cfm or reaches the root directory. It never runs more
than one
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/appfra11.htm
Might help
Eric
On 8/21/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
wrote:
Hi,
Does anyone know what the rules are for ColdFusion including
Application.cfm? I mean, it cannot be as simple as you have requested a
I'm going to start teaching a few friends in the NY area ColdFusion and was
wondering the best way to broadcast this out to the net for others to hear? I
don't have breeze and having a live broadcast where I can take questions seems
like the best way to go. Something with a scratch pad for code
Ah, good to know. I thought it ran both, but anything done in the local
one overrides the stuff in the root file. Anyway, I'm not sure how
they'd do that, now that I think about it. So that makes sense (that it
only runs the local one).
-Original Message-
From: Everett, Al
I've heard that local CFUGs have free access to breeze...maybe you can
tie this into your local CFUG, to get the breeze access?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 11:14 AM
I'm going to start teaching a few friends in
I run the local CFUG (NYCFUG) and using the CFUG breeze is ok for a meeting
but I'm talking 2-3 times a week for a few weeks. I mean real classes with
people in my front room being broadcasted.
I've heard that local CFUGs have free access to breeze...maybe you can
tie this into your local
I've been playing around a lot with CFCs and looking at other peoples code
and on one point, I'm not sure quite which is more acceptable or better
practice... I have my own preference but I'm interested to find out which
approach I *should* be using so, the question is...
Which of the examples
We're looking for a feature rich imaging tool or service that will allow
us to modify images once they've been uploaded to our web application.
Any recommendations on existing tools? I'm looking to do things like:
* resize
* crop
* histogram
* color hues
* overlay
OK here is a summary of what I'm trying to achieve.
I have displayed on the screen two select lists. A user is then able to
select names from one select list to the other. In fact, the select list on
the lest is a master list so all the names will appear in that list.
Lets say a user
Al is correct. Once it finds an Application.cfm, it stops looking.
And, it will continue to traverse up the directory tree to find one,
beyond the web root all the way to the drive root. (At least that's
what they say in the book. I haven't tried it.) An Application.cfc
will take precedence. If an
On my classifieds database it will have...
categories and corresponding sub_categories and corresponding
sub_sub_categories. How would you design the table names and relationships to
avoid confusion? Kinda new to database design!!
IE:
Antiques-category
antique furniture - sub_category
hutches
CF looks for an Application.cfm in the
current template's directory. If one isn't found it looks in the next
higher directory and keeps moving up the directory tree until it finds
an Application.cfm or reaches the root directory. It never runs more
than one Application.cfm unless you do something
http://www.easel2.com/cfximage_support.html
Hopefully this will help. I ahve not used it myself, but a friend of mine
swears by it.
- Original Message -
From: Block, Jon [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, August 21, 2006 11:57 AM
Subject: OT: How
Block, Jon wrote:
We're looking for a feature rich imaging tool or service that will allow
us to modify images once they've been uploaded to our web application.
Any recommendations on existing tools? I'm looking to do things like:
* resize
* crop
* histogram
* color
Hey Doug... I know this isn't a direct answer to your question, but
something for the future - - get this book... it made everything pretty
clear for relational databases:
Database Design for Mere Mortals . . by Michael Hernandez
-Original Message-
From: Doug Brown [mailto:[EMAIL
You might have to double check to see if the column was in fact added and
you might have to look at the metadata.
Example
http://www.cfide.org/getColumnLength.html
Shows the bootloader at work and metadata returned as cfquery object for an
access table as a test.
You need to loop over the comma delimited list, doing multiple inserts:
cfquery name=insertGirls datasource=#request.dsn#
cfloop list=#form.girls# index=i
Insert into testRoster(
Girl_name
)
Values(
This is going to be a bit tricky to explain without diagrams, but I'll
try and hope it's reasonably clear.
One approach is use a single category table that is self-referential.
For example, a table named category, with a categoryid, and a parentid.
Parentid would be a foreign key relationship to
Doug, yYou can actually use a single table for that. One way is to create a
field that serves as a parent_id.
Example:
ID: 1, NAME: Antiques and Vintages, PARENT_ID: 0
ID: 2, NAME: Antique Furniture, PARENT_ID: 1
ID: 3, NAME: Vintage Cars, PARENT_ID: 1
ID: 4, NAME: Hutches, PARENT_ID: 2
ID: 5,
Hmmm, there must be something more to this... Will have to investigate
further.
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
Doug thanks for the help. By the way I am Doug too.
Right now I have this
[categories]
cat_id
category
[sub_categories]
sub_cat_id
cat_id [FK sub_categories_categories]
sub_categories
I am also going to be needing to add a table for the sub_categories of the
sub_categories table. Hopefully
Thanks michael, but if I do it that way, will I not have hundreds of tables?
I currently have about 24 categories and each category has prob 10-50
sub_categories and then each sub_category has it's own set of
sub_categories.
- Original Message -
From: Michael E. Carluen [EMAIL
It was a hunter program to answer questions like which biotech company has
the highest ratio of insiders holding the stock and which biotech company
has the most insiders buying in the the past year.
I was set up to do quarterly updates and alerts but I feel asleep on the
idea. I think I started
With could be done quite easily in Flash. Maybe if I get bored...
!k
-Original Message-
From: Jordan Michaels [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 12:26 PM
To: CF-Talk
Subject: Re: OT: How can I crop, resize, change image color properties
online?
Block, Jon wrote:
The best free choice you have is the open source version of the Flash Media
Server which is still a newborn, but stable...
http://www.osflash.org/red5
Cheers,
Kevin
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 11:32 AM
To: CF-Talk
That was supposed to be english. It could be done quite easily in Flash /
Flex...
!k
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 1:34 PM
To: CF-Talk
Subject: RE: OT: How can I crop, resize, change image color properties
online?
With
The one table design that Michael is describing will hold all your
categories and sub-categories, as well as any further nesting that you
might need.
For example:
Cat_id, category_name, parent_id
1, category 1, NULL
2, category 2,
To simplify what I was getting at in my previous reply, what I was
suggesting is this single table (in place of the three you are
suggesting):
[categories]
cat_id
category
parent_id [FK_categories]
This method allows for unlimited levels of subcategories using only a
single table.
The top
Jon,
I built an application quite a while ago which deals with image cropping and
resizing on the broswer side using some DHTML + Java Advance Image (JAI)
API. You can find it here
If you build this, I will happily send you 1 boston cream donut as
payment.
Jon
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 3:34 PM
To: CF-Talk
Subject: RE: OT: How can I crop, resize, change image color properties
online?
With could be
i cant get the IN/CONTAINS to work on searching a numeric field.
i can can get the result if the passed value is the exact Number.
but if i want the subset of a number or any results with 1300 then i cant
get it to work.
i have googled it, every way i can think
cfquery name=ClientList_Query
No, only one table. I believe Doug Bezona and I are suggesting an identical
approach (so you now have a consensus solution).
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 12:26 PM
To: CF-Talk
Subject: Re: Database design question
I'm about to embark on updating Ray's blogCFC app for Oracle. Has
anyone already done it? If not, I'd be happy to share back my results
with Ray (if he wants them).
~|
Introducing the Fusion Authority Quarterly Update. 80 pages
What is the value of #FORM.search#
It must be at least 1 number, or a comma dleimited list of numbers.
Contains requires full-text search and is for text fields.
Snake
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]
Sent: 21 August 2006 21:34
To: CF-Talk
Subject:
I am a big proponent of method A. My reasoning is that it cleanly
separates instance data from other data in the object. I create a
debug() method in all my objects that return the instance struct, which
gives a very clean way to see what data is within an object.
Additionally you can use the
Paul,
I am not sure if you want to get the subset to match in the DB or in the CF
variable???
You could always loop over the WHERE items.
SELECT
*
FROM
[table]
WHERE
1 = 0
cfloop index=i list=#FORM.search#
OR
CAST( ClientID AS VARCHAR(12)) LIKE
I use it with MySQL, which is already supported. But I'm sure Ray would
be happy to at least a blog entry about it when you finish, he's posted
about a couple of the changes I've made. :)
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21,
the search field could be a first name, id date, whatever.
i am doing the 0=0 to return all records if nothing is passed.
then will check to see if it numeric, if it is they will be looking up an
ID.
if there is a similar id, return that set..
say our ids have 123456789 charecters.
i just want to
ome to an intensive class on CSS, Flex, Fusebox or ColdFusion.
Classes limited to 12 students each so that you can be sure
to get your own questions answered! Sign up today to
guarantee a place at http://www.teratech.com/training/
- Michael Smith, TeraTech, Inc
PS If you can't make a class we
Our shopping cart software SiteDirector is having trouble with one of it's
sites finding the component directory. We haven't seen this before and for the
life of us can't figure out why it's having this trouble.
We've checked permissions and tried various combinations of the component
Hey all,
I am trying to insert an encrypted string into a MySQL database. When
inserted, the db seems to add extra characters on the end of the encrypted
string, which makes it so that the string cannot be decrypted successfully.
It seems to add a couple of spaces plus the dreaded box
You need to loop over the comma delimited list, doing multiple inserts:
cfquery name=insertGirls datasource=#request.dsn#
cfloop list=#form.girls# index=i
Insert into testRoster(
Girl_name
)
Values(
Ok, I think I am understanding. So are you saying that I will need another
table if this is the case? Say I have antiques and collectible and it has a
sub_category of furniture. Since not all furniture is antique or collectible
would that require another table?
- Original Message -
You could maybe use UrlEncodedFormat() after the encypt... This will escape
the characters... Its not intuitive, but it should work. You might want to
also try another algorithm, but I am not that experienced with encryption.
...
Ben Nadel
www.bennadel.com
-Original
I got the cfloop working and I am now able to create a record in the
database. I want to make a small change however and I have it partly
working:
In the master list of names there is an id key which exists. I am now
displaying that as part of the select list, so that that it can be moved
OOO... sweeet. I bet you get all the girls with offers like that!
Seriously, if I get the chance I'll start one up right away...
!k
-Original Message-
From: Block, Jon [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 2:16 PM
To: CF-Talk
Subject: RE: OT: How can I crop,
thanks Ben
will try those examples in the mornning.
On 8/21/06, Ben Nadel [EMAIL PROTECTED] wrote:
Paul,
I am not sure if you want to get the subset to match in the DB or in the
CF
variable???
You could always loop over the WHERE items.
SELECT
*
FROM
[table]
WHERE
Wow, look at all the Doug B's here!
Awhile back I posted some code samples on my blog regarding this very topic,
though in my example I was working with a hierarchical navigation system where
nav items could have children who could have children, etc. The concept has
been quite adequately
I need to get today's orders in a query. I know there's one test order in the
db today, but I can't get my query to return anything. It's SQL Server,
smalldatetime field. Here's the data in the db: 8/13/2006 6:04:00 PM
What do I do to make this work?
cffunction name=getTodayOrders
The problem here is that you are creating a datetime, which contains the
time and comparing with a date.
You need to use a greater than comparison.
try this:
WHERE orderdate =
cfqueryparam cfsqltype=cf_sql_timestamp
value=#CreateODBCDate(Now())#
Kevin
-Original Message-
From: Will
I think your Where clause needs to be something more like.
WHERE OrderDate like #DateFormat(Now(),'m/dd/')#
The way you have it written now, the date AND time have to match the exact
minute and second precisely.
Hope this helps some.
By the way this is untested and my CF is a little
Try using the month, day and year instead. Assuming MS SQL server:
WHERE Year(orderdate) = Year(GetDate()) AND Month(orderdate) =
Month(GetDate()) AND Day(orderdate) = Day(GetDate())
That will pull everything from the database where the month, day, and year
match the current monthm day and
Oh, I thought you were providing semi-realtime stock quotes or
something. Yeah, I don't see anything wrong occasional screen scraping
like what you were planning. :)
-Original Message-
From: Dan Plesse [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 1:27 PM
It was a
The correct solution to this problem is...
In MSSQL Server when you want all of the orders from today:
cfset variables.Today = CreateDate(year(NOW()), month(NOW()),
day(NOW()))
cfquery
SELECT *
FROM ORDERS
WHERE OrderDate BETWEEN
cfqueryparam cfsqltype=cf_sql_timestamp
The problem you are seeing is that when you are comparing orderdate =
now() that it's including minutes and seconds, which will not equal your
record.
You can use:
WHERE CAST(CONVERT(varchar, orderdate, 1) as smalldatetime) =
'8/19/2006' to get all valid orders from the specific date
I went with this one - It worked first time:
WHERE Year(orderdate) = Year(GetDate()) AND Month(orderdate) = Month(GetDate())
AND Day(orderdate) = Day(GetDate())
Thanks to everyone for their help. It was important that I log the exact time
of the sale, but I guess I've made my work harder using
Mytypical response is: I'll be happy to blog about it, and even
include it in an Unsupported folder, but I will not roll it in
because I don't have a local Oracle environment. (And it is hard
enough to keep the 3 dbs I support in check. :)
Of course, if I got off my lazy butt and wrote some unit
No, just take advantage of the power of the RDBMS you use. One note, this
will not give you another day's oirders. GetDate is an MS SQL server
function.
On 8/21/06, Will Tomlinson [EMAIL PROTECTED] wrote:
I went with this one - It worked first time:
WHERE Year(orderdate) = Year(GetDate())
1 - 100 of 124 matches
Mail list logo
