hello all
I tried my hardest to figure this one out by myself, but here goes.
I have a query that returns sums of a few columns. I need to count the number
of
people with certain occupations and count the number of classes they took by a
certain course ID.
The problem is there are only 4 peop
try this:
SELECT tsessiontracking.siteID,
tsessiontracking.userid, tsessiontracking.entered
FROM tsessiontracking
WHERE DATE(tsessiontracking.entered) =
DATE() is a mysql functions that returns just the date part of a
datetime/timestamp field.
Azadi Saryev
Sabai-dee.com
http://www.sabai-d
Hi there
I am trying to do a query of a table in a database using a date field and I am
getting no records returned.
The date field in the database (MySQL database) is set as a datetime field.
So I am guessing that querying just using the date '2008-10-01' is not correct.
My query is this
I would prefer to get this running directly from CF, simply because it's
less complicated...
No, CF is not running as System.
When I try to add /u *localUserName* /p *password* I get this:
ERROR: Invalid syntax. Cannot specify user name without specifying
system name.
So... when I add /s //*m
> 2) Yes, logging into the physical box with the same account (RDP or
> since it's my dev server, I can walk over to it.. .:))
So, CF isn't running as SYSTEM? Just want to confirm that.
> 3) If I run either of these from the command prompt on the server
> schtasks /create /tn createMovie47 /tr
>
What does the code look like that is creating myvar?
-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 8:35 PM
To: cf-talk
Subject: SPAM-LOW: dynamic formfield
I'm having a problem with a dynamic form field that I'm building.
input type = "te
1) I tried specifying the full path to schtasks.exe but that didn't make
a difference.
2) Yes, logging into the physical box with the same account (RDP or
since it's my dev server, I can walk over to it.. .:))
3) If I run either of these from the command prompt on the server
schtasks /create /t
I'm having a problem with a dynamic form field that I'm building.
input type = "text" name = "nm_#myvar#"
myvar is something that can be up to 16 digits. When the form is
submitted it looks something like : nm_1.54585221559E+015. I need it
to show something like: nm_1458522155945998
What
> I'm creating a batch file that converts a .swf to an video file from the
> command line in a cfm page, writing it out and trying to run it with
> cfexecute. (I've tried running the program directly from cfexecute,
> with no luck).
>
> What's really odd is when I RDP to the server in question, I
>
>
>
>
>
> SELECT * FROM TABLE WHERE field = cfsqltype="cf_sql_integer">
>
>
>
>
> Is this over-kill or good practice?
Use it always - it's safer and simpler that way.
Since you're asking about good practice, I want to pick on a couple of things
in your example. ;)
First, the "SEL
On Mon, Sep 29, 2008 at 5:04 PM, Adam Haskell wrote:
> On Sun, Sep 28, 2008 at 1:20 AM, denstar wrote:
>>
>> Are you being sarcastic? I'm not quite sure.
>>
>
> Yes and no. I really am curious if you folks would deal with you giving them
> a "JEE app"* that they do not have resources to maintain.
I'm creating a batch file that converts a .swf to an video file from the
command line in a cfm page, writing it out and trying to run it with
cfexecute. (I've tried running the program directly from cfexecute,
with no luck).
What's really odd is when I RDP to the server in question, I can run
-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED]
Sent: Monday, September 29, 2008 1:28 PM
To: cf-talk
Subject: Re: remote proxy object security
Richard,
We recently implemented a few webservices for our parent company. When
doing these I took a multi-tier approach
On Tue, Sep 30, 2008 at 2:39 AM, Tom Chiverton wrote:
> On Monday 29 Sep 2008, Ian Skinner wrote:
>> connected to receive content. The closest you can get with these
>> technologies is to regularly pull updated data from the client. I.E.
>> Set a function on the client to check the server for new
>I have columns in MySQL database containing boolean values, using a data
>type of unsigned tinyint. Would the cfsqltype of cf_sql_tinyint or
>cf_sql_bit be best to use? If using cf_sql_bit what does cfqueryparam do
>in that case with values such as "-1" or "3" - will it cast them to 1/0,
>or
No it's not overkill. You could be passing in the argument as a form or url
scoped variable for example:
If you just cfqueryparam everything you don't have to worry about it.
-- Josh
- Original Message -
From: "Hunsaker, Michael Scott" <[EMAIL PROTECTED]>
To: "cf-talk"
Sent: Tue
Perfectly,
Thanks Adrian
>Does this work for you?
>
>#query_1.recordcount + query_2.recordcount#
>
>Adrian
>
>Greetings,
>Is it possible to print the summation of two recordcounts?
>Bear with me if I'm being long-winded, but here's the deal:
>Let's say we have two queries, query_1 and query_2.
>I
Woohoo.
Thanks folks.
#query_1.recordcount + query_2.recordcount#
Worked perfectly.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674
Just use it all the time, then it's never an issue.
Plus it does more than just protect against SQL injection.
Adrian
-Original Message-
From: Hunsaker, Michael Scott [mailto:[EMAIL PROTECTED]
Sent: 30 September 2008 21:21
To: cf-talk
Subject: cfqueryparam within a cfc
Hello -
We are
Hello -
We are consistently using the CFQUERYPARAM tag in our code but not within out
CFCs. Here's a quick example:
SELECT * FROM TABLE WHERE field =
Is this over-kill or good practice?
Thanks!
Mike
~
I have an application that worked perfectly on an MX7 Standard server. I've
since attempted to move everything to Enterprise 8, matching the settings as
closely as possible. The application sends text to a key stamper that then
stamps serial numbers on brass keys. The stamper is old and doesn
Brain,
Aren't those instructions specific to configuring email clients? That
is the only place I have seen a reference to TLS. I have never used
it, but I have always has to use 'useSSL' for the CFMAIL tag. I have
noticed though that the port # differs. I am not sure what logic
Google uses to ddte
Does this work for you?
#query_1.recordcount + query_2.recordcount#
Adrian
-Original Message-
From: Michael Norton [mailto:[EMAIL PROTECTED]
Sent: 30 September 2008 20:46
To: cf-talk
Subject: Recordcount Summation of 2 Queries
Greetings,
Is it possible to print the summation of two rec
On Tue, Sep 30, 2008 at 12:45 PM, Michael Norton <
[EMAIL PROTECTED]> wrote:
> Greetings,
> Is it possible to print the summation of two recordcounts?
> Bear with me if I'm being long-winded, but here's the deal:
> Let's say we have two queries, query_1 and query_2.
> In the text, I print the numb
Michael Norton wrote:
> Greetings,
> Is it possible to print the summation of two recordcounts?
> Bear with me if I'm being long-winded, but here's the deal:
> Let's say we have two queries, query_1 and query_2.
> In the text, I print the number of records by using the following expressions:
> #que
#total#
like that?
Steve
On Tue, Sep 30, 2008 at 3:45 PM, Michael Norton <[EMAIL PROTECTED]
> wrote:
> Greetings,
> Is it possible to print the summation of two recordcounts?
> Bear with me if I'm being long-winded, but here's the deal:
> Let's say we have two queries, query_1 and query_2.
>
Greetings,
Is it possible to print the summation of two recordcounts?
Bear with me if I'm being long-winded, but here's the deal:
Let's say we have two queries, query_1 and query_2.
In the text, I print the number of records by using the following expressions:
#query_1.recordcount#
#query_2.recordc
I have columns in MySQL database containing boolean values, using a data
type of unsigned tinyint. Would the cfsqltype of cf_sql_tinyint or
cf_sql_bit be best to use? If using cf_sql_bit what does cfqueryparam do
in that case with values such as "-1" or "3" - will it cast them to 1/0,
or will
Rick wrote:
> Now I want to query that session results much the
> same way as you would do a query of Query.
Then why not use the query of query? Having the result set in a session
variable does not matter. The query of a query needs a variable with a
result set in it. Provide it the session
Aditional info:
When I write the session I do this:
Session.SearchResults = StructNew();
Session.SearchResults = QryGetProviders;
Session.SearchText = Form.SearchText;
Request.SearchText = Form.Se
It's possible and it's also a good way to kill your server.
Think of how much memory it would take to store a single record set in session.
Now think of how many sessions you have on average. Finally, picture how much
memory it would take for 10% of those sessions to store large amounts of data
Aditional info:
When I write the session I do this:
-Original Message-
From: Rick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 2:10 PM
To: cf-talk
Subject: Query of Session?
I have a large amount of data returned from a database using a query and I
write it to a session.
Yup:
SELECT *
FROM SESSION.yourQueryData
Adrian
-Original Message-
From: Rick [mailto:[EMAIL PROTECTED]
Sent: 30 September 2008 20:10
To: cf-talk
Subject: Query of Session?
I have a large amount of data returned from a database using a query and I
write it to a sessi
I have a large amount of data returned from a database using a query and I
write it to a session. Now I want to query that session results much the
same way as you would do a query of Query.
Isn't this possible?
I want to build a "Search within these Results".
Thanks.
Rick
~~~
Adrian:
Direct from Google's config instructions:
17. Enter smtp.gmail.com as the Server Name and set the Port to 587.
18. Select User name and password and enter your full email address (including
@gmail.com or @your_domain.com) in the User Name field.
19. Select TLS from the Use secure connect
In my experience so far with a few different Google apps domains,
useSSL is required and I have never used useTLS. That is with CF 8
though, I don't think useSSL works in 7.02. Make sure your username is
the complete [EMAIL PROTECTED] account name.
Dan
On Tue, Sep 30, 2008 at 9:40 AM, Adrian Lync
Of course. You're forced to connect using SSL anyway.
Just found it strange to see it working when I removed the attributes at the
end.
A
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: 30 September 2008 15:23
To: cf-talk
Subject: Re: cfmail + gmail
On Tuesday 30
On Tuesday 30 Sep 2008, Adrian Lynch wrote:
> From reading it seemed that useTLS was the one but I ran a few tests and
> the last one I ran didn't user either of those attributes.
Maybe it works without, but you shouldn't be sending your username and
password over the internet in plain text.
> I
Well I know at least one is needed as it doesn't work without it.
>From reading it seemed that useTLS was the one but I ran a few tests and the
last one I ran didn't user either of those attributes.
Is there some sort of caching going on. So once I specify useSSL it uses it
again even if I remove
On Tuesday 30 Sep 2008, Adrian Lynch wrote:
> Can anyone say whether useTLS="true" and/or useSSL="true" are needed in
> cfmail to send via a Google hosted email account?
Depends. Do you want your username and password sent in the clear or not ?
--
Tom Chiverton
Helping to proactively introduce w
If it works, don't fix it :)
On Tue, Sep 30, 2008 at 8:40 AM, Adrian Lynch <[EMAIL PROTECTED]>wrote:
> Can anyone say whether useTLS="true" and/or useSSL="true" are needed in
> cfmail to send via a Google hosted email account?
>
> The following works for me:
>
> server="smtp.gmail.com"
>
Can anyone say whether useTLS="true" and/or useSSL="true" are needed in
cfmail to send via a Google hosted email account?
The following works for me:
Message
But blog posts I've read say useTLS is needed.
Does specifying the port change anything?
Adrian Lynch
http://www.halestorm.co.uk/
http:/
On Tue, Sep 30, 2008 at 6:12 AM, Jochem van Dieten
<[EMAIL PROTECTED]>wrote:
> Adam Haskell wrote:
> >>> On Fri, Sep 26, 2008 at 3:31 AM, Jochem van Dieten wrote:
>
> ColdFusion is compiled to Java. Hand the code to the company in an EAR
> or WAR and they won't ever know you used Co
Hi,
I am having a problem using Cfchart in coldfusion mx7 version
7,0,2,142559
The error reported is "Invalid attribute: autoAdjust" and the code used
to test this is shown below.
Thanks
Carl
~|
Adobe® ColdF
Adam Haskell wrote:
>>> On Fri, Sep 26, 2008 at 3:31 AM, Jochem van Dieten wrote:
ColdFusion is compiled to Java. Hand the code to the company in an EAR
or WAR and they won't ever know you used ColdFusion.
> Yes and no. I really am curious if you folks would deal with you giving the
On Monday 29 Sep 2008, Discover Antartica wrote:
> The counter shows 1 to 50. The email is sent from 2 to 50.
Confirmed by looking at the mail logs on CF, the mail server, or watching the
network traffic ?
> Does cfmail
> always lose the first email from a list?
No, it must be a fault elsewhe
On Monday 29 Sep 2008, Ian Skinner wrote:
> connected to receive content. The closest you can get with these
> technologies is to regularly pull updated data from the client. I.E.
> Set a function on the client to check the server for new data every X
> seconds.
There are actually several ways t
On Monday 29 Sep 2008, Richard White wrote:
> we ensure that no one else can use these remote proxy objects / web
> services without coming through the JSMX message calls from our client
> software?
The generic answer is to issue a (time and/or IP limited) token when the
client logs in, and requi
Is that really how your code is formatted? Post the actual code. It's
unlikely to be a problem with cfmail or cfloop.
Adrian
-Original Message-
From: Discover Antartica [mailto:[EMAIL PROTECTED]
Sent: 29 September 2008 23:58
To: cf-talk
Subject: Losing Mail?
Hi All,
If I run the follo
49 matches
Mail list logo