Re: CF 8 Hosting recommendations

[Mike Little]

gosh vivio is cheap!! can anyone else vouch for these guys? i would be keen to 
try them out.

>Yes, if that's the chosen path then Viviotech can provide a VPS for
>$19.95 per month.
>
>http://www.viviotech.net/vps.cfm
>
>mxAjax / CFAjax docs and other useful articles:
>http://www.bifrost.com.au/blog/
>> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322460
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

cross side scripting hotfix for CFMX 6.1 not working

[Vineet Mangal]

Hi, 
   I am trying to install a hotfix for ColdFusion MX: Cross-site scripting 
vulnerability in forms found at: http://kb2.adobe.com/cps/966/dcf966be.html.
We are running CFMX verion 6,1,0,83762 on Windows server 2003 with IIS 6.0. 

I have followed the steps exactly as specified on Adobe's site above and 
restarted the server. The issue is that in CF Administrator, the hotfix is not 
getting picked up. 

According to the Adobe's website above I should see 6,1,0 hf64586_611 in the 
version section which doesn't seem to be the case. I still see 6,1,0,83762. Any 
ideas?

Thanks,
Vineet 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322459
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

replace width/height values in youtube script

[Mike Little]

hey guys,

developing an app that the user inputs the embed script from a youtube video. 
what i want however, is for all width="" and height="" attributes to be 
replaced with custom values that fit our site layout.

just a little lost as how to do this with a regular expression.

any help will be greatly appreciated.

mike 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322458
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Coldbox - mxunit testing database interaction

[Jake Pilgrim]

Thanks for the response Matt. I'll repost this there. In the meantime for 
anyone else viewing this thread, what I'm struggling with is finding out if the 
save occurred successfully. Maybe the answer is that I should be unit testing 
the model directly and ignoring this test within the handler's unit tests. 
Here's what I'm thinking this unit test should look like (partial pseudo-code):

 


var event = "";
var rc = '';
var testObj = '';

// set up fake form submission
rc.userID = 1;
rc.userName='testUser';
rc.password = 'testPass';
rc.departmentID_fk = 1;

event = execute("demoApp.edit");
rc = event.getCollection();
debug(rc);

testObj = createObject('component','path.to.users');
testObj.load(rc.userID);

assertEquals(testObj.get('username'),rc.username,'usernames are not equal.');

assertEquals(testObj.get('password'),rc.password,'passwords are not equal.');




... but you can see how this is a MUCH bigger function than what I'm actually 
trying to test. If I used this approach in a more complex scenario, I could see 
it taking twice as long to write the test than it did to write the 
functionality I'm trying to test... Seems like a losing battle - I'm hoping I'm 
missing something? 

Thanks!

>Jake,
>
>I would highly recommend posting this question to the ColdBox and/or MXUnit
>groups (links below).  You are almost guaranteed to get a much greater
>response from those than you will from CF-Talk.
>
>/0.02
>
>I would offer a suggestion, but I'm honestly not exactly sure what you're
>trying to do, or specifically, what you're struggling with.  But that might
>be just because I a) don't use any of the built-in model stuff, and b) don't
>really write controller unit tests.  I write extensive tests on my model
>itself, but typically just browser test the controllers.
>
>HTH 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322457
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Storing SSN ... I know, I know

[Judah McAuley]

Encryption and hashing aren't the same thing, but if there is only one
end user for the data (the bank in question) then I'd say that PKI is
the way to go. You have the bank set up a public/private key store.
They give you the public key. You are able to encrypt the SSN's using
the banks public key and store that in the db. Then when they get
transmitted to the bank, the bank is able to decrypt them using their
private key. The important part is that only the holder of the private
key is able to decrypt the ssn's that were encrypted with the matching
public key, so you couldn't give up the raw SSN info even if you
wanted to because you don't have the private key.

Judah

On Tue, May 12, 2009 at 7:20 AM, Andy Matthews  wrote:
>
> If the user is connecting with ONLY one bank, then see if that bank will let
> you send them the encrypted SSN and they can decrypt it on their end using
> whatever they have.
>
> Then all you have to do is one way hash it, and they can do the comparison
> on their end.
>
> -Original Message-
> From: ColdFusion Developer [mailto:cfdev...@gmail.com]
> Sent: Monday, May 11, 2009 7:19 PM
> To: cf-talk
> Subject: Storing SSN ... I know, I know
>
>
> What's a best practice for securely storing a social security number? I've
> talked myself blue trying to talk my client out of doing this, but the bank
> he's working with for this project absolutely, positively cannot process his
> transactions without the SSNs of our users (most of the businesses they work
> with are payroll companies with secure internal data storage, not a
> public-facing site like his will be).
>
> What would you all recommend as a process/method for storing this info in
> the most secure way possible? Most of what I've read just says
> "encrypt/decrypt it in the database and you're fine" -- but I'm not so sure
> that's the best course.
>
> Thanks in advance!
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322456
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldbox - mxunit testing database interaction

[Matt Quackenbush]

Jake,

I would highly recommend posting this question to the ColdBox and/or MXUnit
groups (links below).  You are almost guaranteed to get a much greater
response from those than you will from CF-Talk.

/0.02

I would offer a suggestion, but I'm honestly not exactly sure what you're
trying to do, or specifically, what you're struggling with.  But that might
be just because I a) don't use any of the built-in model stuff, and b) don't
really write controller unit tests.  I write extensive tests on my model
itself, but typically just browser test the controllers.

HTH


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322455
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: table display: row number. without recordset

[Judah McAuley]

You could always use cfcontent to render the code and place it in a
variable, then output into email. You could also call it via cfhttp
and use the response.

Be aware, however, JS and CSS do not always play nicely with email
clients so make sure you test your target client(s).

Judah

On Tue, May 12, 2009 at 9:53 AM, Paul Ihrig  wrote:
>
> there are like 5 separate queries.
> with sub quires inside the first 3.
>
> so current row wouldn't work. unless i wrote a big nasty q0q
> that's why i really liked the jquery rendering of the row number.
>
>
>
> On Tue, May 12, 2009 at 12:23 PM, Azadi Saryev  wrote:
>
>>
>> how are you rendering the table in cfmail? is it based on query output?
>> use queryname.currentrow then, or a custom row counter if your query
>> uses group output...
>>
>> Azadi Saryev
>> Sabai-dee.com
>> http://www.sabai-dee.com/
>>
>>
>>
>> Paul Ihrig wrote:
>> > ok here is a weird one.
>> > the numbers render fine on display in browser.
>> > but if i include the rendered output in a cfmail, i dont get the
>> numbering?
>> >
>> > i have the js, and css linked correctly..
>> >
>> >
>> >
>>
>>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322454
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Coldbox - mxunit testing database interaction

[Jake Pilgrim]

I'm just starting to get into Coldbox and I'm encountering some confusion as to 
how to *really* test my models and database interaction. 

So I have the following handler function which is fired upon form submission:




var rc = arguments.event.getCollection();
var demoModelObj = getModel('demoModel');

demoModelObj.editUserObj(rc);

runEvent('demoApp.list');



... which calls the following model function:




if (structKeyExists(rc,'userID')) {
instance.usersObj.load(rc.userID);
instance.usersObj.setAll(rc);
instance.usersObj.save();
}




This all works fine and dandy (at least for a 'hello world' coldbox application 
- I know this code is lacking in a number of places). So now I'm trying to set 
up a mxunit test to test the behaviors of the handler, but I'm coming to a 
blank when I try to come up with an assertion for this... I could bundle the 
whole test up in a cftransaction, and rollback when I'm done - I get that, but 
the problem is I don't see how to test this w/o writing twice as much code 
within the test. Take the following beginning of a unit test:




var event = "";
var rc = '';

// set up fake form submission
rc.userID = 1;
rc.userName='testUser';
rc.password = 'testPass';
rc.departmentID_fk = 1;

event = execute("demoApp.edit");
rc = event.getCollection();
debug(rc);

// what to do here?



... what kind of assertions can I make at the 'what to do here?' line? Is there 
an easy way to get at instance.usersObj from the model's method, or do I have 
to have my model return it (seems wrong to have the model return just to allow 
for debugging)? Am I totally missing the short-bus here? Any insight would be 
greatly appreciated! 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322453
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Include one form within another

[Ian Skinner]

Ian Skinner wrote:
> Dave have you ...
 
*gave*

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322452
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Include one form within another

[Ian Skinner]

fun and learning wrote:
> As I said I was using URL, but due to security concerns, I have to use form 
> variables to post data.
>
> Thanks

Dave have you pretty good advice an how to accomplish your goal.

I would like to point out the red flag of any statement that indicates 
post (form as you named them) variables are inherently more secure then 
get (aka URL) variables.  They both suffer from the exact same security 
concerns.  Just because a user does not conveniently see the post form 
variables in the URL bar of a browser does not make them any more secure 
or trustworthy then the get form variables that can be.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322451
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Include one form within another

[Dave Watts]

> In the form I am creating, sometimes the user would be presented with a link 
> to enroll themselves
> (This would happen before the actual form submission). So, when they click 
> that which takes them
> to another form, those form fields should get prepoulated with the form 
> fields that I need to pass from
> current form. As I said I was using URL, but due to security concerns, I have 
> to use form variables to
> post data.

If you can use JavaScript, you can have your link trigger a JavaScript
function that changes the action of the form, then submits the form:

Enroll

...


function enroll()
{
 document.forms[0].action = "enroll.cfm";
 document.forms[0].submit();
}


Alternatively, you could have the link set a form field value, then
use CF in your action page to check for the existence of the form
field value, and show the user the appropriate results in either case.
You could just have a checkbox for this.

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, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322450
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: my cfqueryparam grievance

[Jason Fisher]

Ummm, not sure why your cookie.theID would shift, but I would say absolutely 
that the CF_SQL_TYPE is designed to match the database column data type, not 
the incoming variable parameter.  The entire point of the CF_SQL_TYPE is to let 
the JDBC driver handle the data pass-through for you in a way that is safe and 
that the database server understands, regardless of what RDBMS you are using.

So, I would agree that there are 2 separate issues: what's gone on with your 
data, independent of the CFQUERY and then ensuring that all CFQUERYPARAMs are 
designed to match your database rather than your application data, which in 
this case just happens to be integer. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322449
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Include one form within another

[fun and learning]

In the form I am creating, sometimes the user would be presented with a link to 
enroll themselves (This would happen before the actual form submission). So, 
when they click that which takes them to another form, those form fields should 
get prepoulated with the form fields that I need to pass from current form. As 
I said I was using URL, but due to security concerns, I have to use form 
variables to post data.

Thanks


> > I am faced with a peculiar situation. I have a form, which has a 
> save link at the end of finishing the form.
> > In the form, I have used Javascript to show/display some other 
> hyperlink, and it has its own href attibute
> > and am passing variables with it as URL scope. But now, I need to 
> include another form to post variables
> > instead of using URL scopes. Is this possible to achieve in 
> Coldfusion?
> 
> This has nothing to do with ColdFusion, and everything to do with
> HTML. In HTML, you can't place one form within another. However, I
> don't see why they'd need to be nested. I'm not entirely sure what
> you're trying to accomplish, either, so you may want to describe
> exactly what outcome you want, rather than talking about the
> underlying mechanisms of forms, JavaScript, etc.
> 
> 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, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more 
information! 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322448
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Load Test Apps

[Cutter (CFRelated)]

We found OpenLoad to be reasonable, for a tool that could also read AMF 
requests, which we required since we have so many tools front ended by 
Flash and Flex.

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer

Co-Author of "Learning Ext JS"
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com

On 5/12/2009 2:26 PM, Justin Scott wrote:
> Any recommendations on web site load testing apps?  I'm considering JMeter
> and the Microsoft Web Application Stress Tool.  Anything else I should be
> looking at?  What's easiest to configure, run, and gives decent reporting?
>
>
> -Justin
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322447
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Load Test Apps

[Justin Scott]

> The nice thing about Badboy is that its a proxy
> recorder, so it can record everything you do in
> the browser. Once you're satisfied with it you
> can export the recording to a Jmeter test xml.

Oh, shiny.  I'll definitely check that out as it will make creating the
tests a lot easier if it does what you describe.  Thanks!


-Justin


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322446
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: my cfqueryparam grievance

[Adrian Lynch]

Start logging the value of COOKIE.theID. Just save it somewhere and see if
it's ever an unexpected value.

Adrian

> -Original Message-
> From: Qing Xia [mailto:txiasum...@gmail.com]
> Sent: 12 May 2009 20:16
> To: cf-talk
> Subject: my cfqueryparam grievance
> 
> 
> Hello folks,
> 
> I had a pretty strange experience with CFQueryParam today.   Basically,
> I
> have an innocent-looking query:
> 
> *SELECT* username, password
> *FROM* someTable
> *WHERE* someID =  "#cookie.theID#" maxlength="6">
> 
> 
> This query had worked just fine for nearly a year (since I
> cfqueryparamed it
> last summer) until this morning, when it broke.  The error messages
> read:
> 
> *Message:*
> Error Executing Database Query.
> 12 May 2009 01:49:21 PM EDT
> Diagnostics:
> Error Executing Database Query. [Macromedia][SQLServer JDBC
> Driver][SQLServer]Syntax error converting the varchar value '521636a'
> to a
> column of data type int.  The error occurred on line 35.
> 
> That error points to the WHERE statement, and it complains the
> cookie.theID
> is not an integer-but it is!!! *Even the error messages themselves
> which
> contains a CFDump on Cookie scope say it is an integer, of 6 digits!!!*
> Even
> more strangely, the error messages always say ".converting the varchar
> value
> '521636a'." , no matter what the actual cookie.theID value is.  Since
> this
> query is called from a template that logs users in, I got dozens of
> error
> reports, all with this identical error message, even though the actual
> theID
> values were very different.
> 
> When I switched the cfqueryparam cfsqltype to varchar, the error went
> away!!  Of course, the actual data type of the id table column IS
> varchar,
> but I had purposefully made it integer in the cfqueryparam, for code
> "readability" and more control over the incoming value.  L
> 
> The moral of the story, of course, is that the cfsqltype should
> probably
> always match the receiving database table column's data type.  But I am
> just
> curious. why were my values being converted to "521636a".? 6-digit
> integer/varchar values are certainly not out of bounds for SQL int data
> type, so I simply cannot fathom why conversion was done and why it was
> necessary.
> 
> A


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322445
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Include one form within another

[Dave Watts]

> I am faced with a peculiar situation. I have a form, which has a save link at 
> the end of finishing the form.
> In the form, I have used Javascript to show/display some other hyperlink, and 
> it has its own href attibute
> and am passing variables with it as URL scope. But now, I need to include 
> another form to post variables
> instead of using URL scopes. Is this possible to achieve in Coldfusion?

This has nothing to do with ColdFusion, and everything to do with
HTML. In HTML, you can't place one form within another. However, I
don't see why they'd need to be nested. I'm not entirely sure what
you're trying to accomplish, either, so you may want to describe
exactly what outcome you want, rather than talking about the
underlying mechanisms of forms, JavaScript, etc.

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, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322444
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Load Test Apps

[Josh Nathanson]

I found openSTA pretty easy to get up and running.

http://www.opensta.org/

-- Josh


-Original Message-
From: Justin Scott [mailto:jscott-li...@gravityfree.com] 
Sent: Tuesday, May 12, 2009 12:26 PM
To: cf-talk
Subject: Load Test Apps


Any recommendations on web site load testing apps?  I'm considering JMeter
and the Microsoft Web Application Stress Tool.  Anything else I should be
looking at?  What's easiest to configure, run, and gives decent reporting?


-Justin




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322443
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Load Test Apps

[Larry Lyons]

>Any recommendations on web site load testing apps?  I'm considering JMeter
>and the Microsoft Web Application Stress Tool.  Anything else I should be
>looking at?  What's easiest to configure, run, and gives decent reporting?
>
>
>-Justin

you may want to look at Selenium or BadBoy, http://www.badboysoftware.biz/

The nice thing about Badboy is that its a proxy recorder, so it can record 
everything you do in the browser. Once you're satisfied with it you can export 
the recording to a Jmeter test xml. then redo the tests in Jmeter. So it allows 
you to create some complex load tests that can imitate a real world load. It 
also has some limited reporting capabilities.

hth,
larry 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322442
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: my cfqueryparam grievance

[brad]

It might have been a problem on the SQL server side if a corrupted
prepared statement got cached.  Changing the cfsqltype effectively
cleared the old statement since a new one needed to be recompiled.
Can't say I've ever seen what you described but I have seen structure
changes a database break cached prepared statements before.

~Brad

 Original Message 
Subject: my cfqueryparam grievance
From: Qing Xia 
Date: Tue, May 12, 2009 2:16 pm
To: cf-talk 


Hello folks,

I had a pretty strange experience with CFQueryParam today. Basically, I
have an innocent-looking query:

*SELECT* username, password
*FROM* someTable
*WHERE* someID = 


This query had worked just fine for nearly a year (since I
cfqueryparamed it
last summer) until this morning, when it broke. The error messages read:

*Message:*
Error Executing Database Query.
12 May 2009 01:49:21 PM EDT
Diagnostics:
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]Syntax error converting the varchar value '521636a' to
a
column of data type int. The error occurred on line 35.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322441
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: my cfqueryparam grievance

[Ian Skinner]

Qing Xia wrote:
> I simply cannot fathom why conversion was done and why it was
> necessary.

Presumably not necessary, definitely undesirable as you describe it.  
But seeing that value 521636a makes me wonder if something is trying to 
interpret the value as a hexadecimal for some reason?

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322440
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Include one form within another

[fun and learning]

Hi All,

I am faced with a peculiar situation. I have a form, which has a save link at 
the end of finishing the form. In the form, I have used Javascript to 
show/display some other hyperlink, and it has its own href attibute and am 
passing variables with it as URL scope. But now, I need to include another form 
to post variables instead of using URL scopes. Is this possible to achieve in 
Coldfusion? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322439
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Load Test Apps

[Justin Scott]

Any recommendations on web site load testing apps?  I'm considering JMeter
and the Microsoft Web Application Stress Tool.  Anything else I should be
looking at?  What's easiest to configure, run, and gives decent reporting?


-Justin


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322438
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldfusion Date format question

[fun and learning]

Hi All,

Thanks a lot for the answers. It works now...

Thanks


> Using cfsqltype="cf_sql_timestamp" will definitely solve that problem.
> 
> 
> I expect you're just trying to give an example, but if all you're
> trying to do is move values from one table to another, you can do 
> this
> en-mass with SQL:
> 
> 
> insert into table2(date_field2)
> select date_field1 from table1
> 
> 
> Cheers,
> Kris
> 
> 
> > I have an issue inserting date and time together into a database 
> table from coldfusion.
> >
> > Right now, I am using  to get records from a particular 
> table, in which one of the field is date, and its value in the 
> database is something like
> > "2/14/2007 9:10:12 AM". I am performing insert operation into 
> another table which has to insert this date field into the column of 
> new table. I am doing currently as follow:
> >
> > 
> >   select date_field from table
> > 
> >
> > 
> >  
> >    insert into table2 (date_field1) values ( cfsqltype="cf_sql_date" value=#getDate.date_field#>)
> >  
> > 
> >
> > The problem with this is only the date is getting inserted but not 
> the time. How to format 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322437
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

my cfqueryparam grievance

[Qing Xia]

Hello folks,

I had a pretty strange experience with CFQueryParam today.   Basically, I
have an innocent-looking query:

*SELECT* username, password
*FROM* someTable
*WHERE* someID = 


This query had worked just fine for nearly a year (since I cfqueryparamed it
last summer) until this morning, when it broke.  The error messages read:

*Message:*
Error Executing Database Query.
12 May 2009 01:49:21 PM EDT
Diagnostics:
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]Syntax error converting the varchar value '521636a' to a
column of data type int.  The error occurred on line 35.

That error points to the WHERE statement, and it complains the cookie.theID
is not an integer—but it is!!! *Even the error messages themselves which
contains a CFDump on Cookie scope say it is an integer, of 6 digits!!!* Even
more strangely, the error messages always say “…converting the varchar value
‘521636a’…” , no matter what the actual cookie.theID value is.  Since this
query is called from a template that logs users in, I got dozens of error
reports, all with this identical error message, even though the actual theID
values were very different.

When I switched the cfqueryparam cfsqltype to varchar, the error went
away!!  Of course, the actual data type of the id table column IS varchar,
but I had purposefully made it integer in the cfqueryparam, for code
“readability” and more control over the incoming value.  L

The moral of the story, of course, is that the cfsqltype should probably
always match the receiving database table column’s data type.  But I am just
curious… why were my values being converted to “521636a”…? 6-digit
integer/varchar values are certainly not out of bounds for SQL int data
type, so I simply cannot fathom why conversion was done and why it was
necessary.

A

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322436
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: table display: row number. without recordset

[Paul Ihrig]

there are like 5 separate queries.
with sub quires inside the first 3.

so current row wouldn't work. unless i wrote a big nasty q0q
that's why i really liked the jquery rendering of the row number.



On Tue, May 12, 2009 at 12:23 PM, Azadi Saryev  wrote:

>
> how are you rendering the table in cfmail? is it based on query output?
> use queryname.currentrow then, or a custom row counter if your query
> uses group output...
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/
>
>
>
> Paul Ihrig wrote:
> > ok here is a weird one.
> > the numbers render fine on display in browser.
> > but if i include the rendered output in a cfmail, i dont get the
> numbering?
> >
> > i have the js, and css linked correctly..
> >
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322435
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: table display: row number. without recordset

[Paul Ihrig]

display1Day.cfm
http://63.144.103.199/FORMS/rittalXpress/ie/inc/detail/display1Day.cfm?placeholder=enclosures&xp1DayId=10027&#step1

the jquery auto number is in the display1Day.cfm

which renders fine.
i dont need the sorting or any thing in the email, just the line number.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322434
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: table display: row number. without recordset

[Azadi Saryev]

how are you rendering the table in cfmail? is it based on query output?
use queryname.currentrow then, or a custom row counter if your query
uses group output...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Paul Ihrig wrote:
> ok here is a weird one.
> the numbers render fine on display in browser.
> but if i include the rendered output in a cfmail, i dont get the numbering?
>
> i have the js, and css linked correctly..
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322433
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: table display: row number. without recordset

[Azadi Saryev]

well, whatever you put in the body of  tag would be processed
and rendered BEFORE the page is displayed in the browser, thus BEFORE
any jQuery magic kicks in...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Paul Ihrig wrote:
> ok here is a weird one.
> the numbers render fine on display in browser.
> but if i include the rendered output in a cfmail, i dont get the numbering?
>
> i have the js, and css linked correctly..
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322432
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: table display: row number. without recordset

[Peter Boughton]

You can't do JavaScript in emails. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322431
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: table display: row number. without recordset

[Paul Ihrig]

ok here is a weird one.
the numbers render fine on display in browser.
but if i include the rendered output in a cfmail, i dont get the numbering?

i have the js, and css linked correctly..


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322430
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Help With Regular Expressions

[Andy Matthews]

Can you provide one more of the actual links? I'm going to assume that the
folderName string is not actually 'folderName'. If that's the case then it
would affect the regular expression and what it would need to look for. Will
the two character string always be at the end of the link?

If everything else is the same, and you just need the last two characters of
a link:








-Original Message-
From: Robert Nurse [mailto:rnu...@gmail.com] 
Sent: Tuesday, May 12, 2009 11:20 AM
To: cf-talk
Subject: Help With Regular Expressions


Hi All,

I'm trying to find a way of using regular expressions to locate and replace
text.  My application reads in some text containing links from a DB: e.g.
../folderName/someCFMFile.cfm?code=AB.  I want to change all occurrences of
this to ../folderName/AB.html.  Note that "code" can be any
2-uppercase-character combination.  I've gotten to the point where I have
../folderName/code using:

 


My problem is how to get it to replace what it matches with that same match
(which would be ../folderName/code) with ../folderName/code.html? 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322429
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Help With Regular Expressions

[Barney Boisvert]

This is untested, but should be close.

REReplace(string, "[a-zA-Z0-9_-]+\.cfm\?code=([A-Z]{2})", "\1.html", "all")

find zero or more a-zA-Z0-9_-, then ".cfm?code=", then any two A-Z and
replace the whole thing with thos upper case letters plus ".html".  If
"someCFMFile.cfm" is static, you can replace that character class with
the literal.

cheers,
barneyb

On Tue, May 12, 2009 at 9:20 AM, Robert Nurse  wrote:
>
> Hi All,
>
> I'm trying to find a way of using regular expressions to locate and replace 
> text.  My application reads in some text containing links from a DB: e.g. 
> ../folderName/someCFMFile.cfm?code=AB.  I want to change all occurrences of 
> this to ../folderName/AB.html.  Note that "code" can be any 
> 2-uppercase-character combination.  I've gotten to the point where I have 
> ../folderName/code using:
>
> 
> 
>
>
> My problem is how to get it to replace what it matches with that same match 
> (which would be ../folderName/code) with ../folderName/code.html?
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322428
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Help With Regular Expressions

[Robert Nurse]

Hi All,

I'm trying to find a way of using regular expressions to locate and replace 
text.  My application reads in some text containing links from a DB: e.g. 
../folderName/someCFMFile.cfm?code=AB.  I want to change all occurrences of 
this to ../folderName/AB.html.  Note that "code" can be any 
2-uppercase-character combination.  I've gotten to the point where I have 
../folderName/code using:





My problem is how to get it to replace what it matches with that same match 
(which would be ../folderName/code) with ../folderName/code.html? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322427
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: I think he is going to the wrong school.

[Ian Skinner]

Casey Dougall wrote:
> On Tue, May 12, 2009 at 10:12 AM, Phillip Vector
> wrote:
>   
>> *something NOT ColdFusion*
>> 
> No, he just posts to cf-talk because it's picked up by google quicker and
> he's on some type of ego trip!
>   

I blame "Alien Hand Syndrome"... Please don't give away the ending, I've 
only watch the first quarter of the episode this morning.

P.S.  I have resent another copy the original message to the correct 
list immediately after realizing I had sent another message to the wrong 
list yet again.  This topic can be continued there.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322426
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: I think he is going to the wrong school.

[Andy Matthews]

I agree. If you're paying to go a private school, then you should be aware
of their restrictions and choose to go to another school. 

-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com] 
Sent: Tuesday, May 12, 2009 9:06 AM
To: cf-talk
Subject: I think he is going to the wrong school.


http://apnews.myway.com/article/20090511/D9848CA00.html

I don't agree with this school's stance on dancing, rock music and
hand-holding, but I agree they have a right to have these stances and that
others can choose to agree with them to attend the school.  There was
another story yesterday that said the father also disagreed with the schools
stance.

I presume this is a private school that this boys family is paying for him
to attend...

With that assumption, I have these questions:

Why pay to go to a school you and your family don't agree with?

Why advertise you are going to go to a prom against the schools rules?  
I guess it could be a small enough town that doing so would somehow get back
to the school, but I can't imagine that the school as undercover dance
detectives going to these forbidden functions looking for rule breakers,
would they?





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322425
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: I think he is going to the wrong school.

[Phillip Vector]

Just FYI, you may want to consider a Gmail account. It can send from
your domain name and it has an "Undo" button which has saved me a few
times as well. :)

and also to note, IMHO, private school, private rules. It sucks, but
the kid is getting way to much attention to a non-issue.

On Tue, May 12, 2009 at 7:11 AM, Ian Skinner  wrote:
>
> Ian Skinner wrote:
>> Stuff I should have sent to the other list!
>
> It would be nice if there was some way to change this after I have hit
> the send button.
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322424
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Storing SSN ... I know, I know

[Andy Matthews]

If the user is connecting with ONLY one bank, then see if that bank will let
you send them the encrypted SSN and they can decrypt it on their end using
whatever they have.

Then all you have to do is one way hash it, and they can do the comparison
on their end. 

-Original Message-
From: ColdFusion Developer [mailto:cfdev...@gmail.com] 
Sent: Monday, May 11, 2009 7:19 PM
To: cf-talk
Subject: Storing SSN ... I know, I know


What's a best practice for securely storing a social security number? I've
talked myself blue trying to talk my client out of doing this, but the bank
he's working with for this project absolutely, positively cannot process his
transactions without the SSNs of our users (most of the businesses they work
with are payroll companies with secure internal data storage, not a
public-facing site like his will be).

What would you all recommend as a process/method for storing this info in
the most secure way possible? Most of what I've read just says
"encrypt/decrypt it in the database and you're fine" -- but I'm not so sure
that's the best course.

Thanks in advance! 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322423
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: I think he is going to the wrong school.

[Casey Dougall]

On Tue, May 12, 2009 at 10:12 AM, Phillip Vector
wrote:

>
> So.. Does the school use ColdFusion? :) I'm not seeing how ColdFusion
> (this IS a ColdFusion list) is used here. I mean, if anything, they
> are using ASP (Look at the "We are Hiring" link).
>
> So why bring this up on a ColdFusion list to ColdFusion people? :)
>
> On Tue, May 12, 2009 at 7:06 AM, Ian Skinner  wrote:
>
> *something NOT ColdFusion*
>


No, he just posts to cf-talk because it's picked up by google quicker and
he's on some type of ego trip!


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322422
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: I think he is going to the wrong school.

[Phillip Vector]

So.. Does the school use ColdFusion? :) I'm not seeing how ColdFusion
(this IS a ColdFusion list) is used here. I mean, if anything, they
are using ASP (Look at the "We are Hiring" link).

So why bring this up on a ColdFusion list to ColdFusion people? :)

On Tue, May 12, 2009 at 7:06 AM, Ian Skinner  wrote:

*something NOT ColdFusion*

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322421
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: I think he is going to the wrong school.

[Ian Skinner]

Ian Skinner wrote:
> Stuff I should have sent to the other list!

It would be nice if there was some way to change this after I have hit 
the send button.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322420
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: (ot) Who takes care of this site? ;-))

[Shannon Peevey]

cf forum perhaps?

http://web.archive.org/web/20071226130838rn_1/www.cfcode.com/cfforum/

With this?
*cfforum-forummessages-sql-injection (47234)*

http://xforce.iss.net/xforce/xfdb/47234

Here is a thread which is discussing the issues that customers were
having with SQL injection attacks with that software:
http://74.125.95.132/search?q=cache:rpWLYB_1Q1AJ:www.cfcode.com/cfforum/printthread.cfm%3FForum%3D9%26Topic%3D1568+cfforum+security&cd=4&hl=en&ct=clnk&gl=us&client=iceweasel-a

A google search of site:cfcode.com shows that the software makes registered
members usernames available to Google spiders through the whois.cfm, which
would make a brute force attack fairly easy...

Just a heads-up for anyone running this software.

speeves

On Tue, May 12, 2009 at 8:47 AM, Shannon Peevey  wrote:

> whois is our friend :) Robert has been contacted.
>
>
> On Tue, May 12, 2009 at 8:41 AM, Gerald Guido wrote:
>
>>
>> Not to add insult to injury but this is too funny.
>>
>> From the domain tools listing page:
>> Front Page Information Website Title:  HaCKeD By
>> EL_MuHaMMeD  Title
>> Relevancy 100%
>>
>>
>> On Tue, May 12, 2009 at 10:25 AM, Peter Boughton > >wrote:
>>
>> >
>> > I guess talking to Robert would be a good start...
>> >
>> > http://whois.domaintools.com/cfcode.com
>> >
>> >
>> >
>> >
>>
>> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322419
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

I think he is going to the wrong school.

[Ian Skinner]

http://apnews.myway.com/article/20090511/D9848CA00.html

I don't agree with this school's stance on dancing, rock music and 
hand-holding, but I agree they have a right to have these stances and 
that others can choose to agree with them to attend the school.  There 
was another story yesterday that said the father also disagreed with the 
schools stance.

I presume this is a private school that this boys family is paying for 
him to attend...

With that assumption, I have these questions:

Why pay to go to a school you and your family don't agree with?

Why advertise you are going to go to a prom against the schools rules?  
I guess it could be a small enough town that doing so would somehow get 
back to the school, but I can't imagine that the school as undercover 
dance detectives going to these forbidden functions looking for rule 
breakers, would they?



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322418
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: getting cfx_imsmail and cfset to play nice?

[Jack Ring]

I should add that I'm using cfx_imsmail version 3.3.2.  The coolfusion.com 
website is really messed up at the moment, and link to files on the download 
page link to the same smtp installer file.  Does anyone know where I can get 
the newest version of cfx_imsmail?  Or an answer to the OP would be great too.

> I am currently trying to use the  tag (custom tag 
> available using inFusion Mail Server) and I have a question which I 
> hope can be easily answered.
> 
> I want to use the cfx_imsmail tag to replace a cfmail tag that uses a 
> query attribute.  I am using the query and queryfield attributes to 
> automatically loop the same query.  My problem is that while inside an 
> attribute of the cfx_imsmail tag, my  tags seem to be ignored.  
> I want to put in place some link tracking logic and also a  
> tag that calls a dynamic template name.  I have tried to set up this 
> data in a token_emailbody attribute, directly in the body attribute, 
> and also directly in the html attribute, but nothing seems to work for 
> me.  
> 
> a dumbed-down code snippet is attached below:
> 
>header_to="#myquery.to_email#"
>   header_from="#myquery.from_email#"
>   smtpfrom="#myquery.from_email#"
>   header_subject="#myquery.subject#"
>   failto="graph...@gammasports.com"
>   parsetokens="yes"
>   renderplaintext="no"
>   log="yes"
>   priority="0"
>   query="myquery"
>   queryfield="to_email"
>   html="
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>value='#var. myvariable#' 
> />
>   
>   
> ">
> 
> Please note that the data contained in the html attribute of the 
> cfx_imsmail tag in the above code example was taken directly from 
> between the opening and closing  tags that I'm trying to 
> replace.  The cfmail tag works without any problems at all times.
> 
> I keep getting an error on line 57 stating that a variable is 
> undefined, even though I have the variable being defined on line 54. 
> This leads me to believe that the  I am using is not being 
> executed.  Is there anything I can do to get my  to behave 
> properly while inside of the cfx_imsmail tag?
> 
> I have had success looping the cfx_imsmail tag for my query, replacing 
> query and queryfield attributes with the smtpto attribute, and using a 
> cfsavecontent tag before the cfx_imsmail tag to build the content for 
> the html attribute.  I do not want to do it this way, as this is far 
> less efficient than using the query and queryfield attributes. 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322417
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: (ot) Who takes care of this site? ;-))

[Shannon Peevey]

whois is our friend :) Robert has been contacted.

On Tue, May 12, 2009 at 8:41 AM, Gerald Guido wrote:

>
> Not to add insult to injury but this is too funny.
>
> From the domain tools listing page:
> Front Page Information Website Title:  HaCKeD By
> EL_MuHaMMeD  Title
> Relevancy 100%
>
>
> On Tue, May 12, 2009 at 10:25 AM, Peter Boughton  >wrote:
>
> >
> > I guess talking to Robert would be a good start...
> >
> > http://whois.domaintools.com/cfcode.com
> >
> >
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322416
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: (ot) Who takes care of this site? ;-))

[Gerald Guido]

Not to add insult to injury but this is too funny.

>From the domain tools listing page:
Front Page Information Website Title:  HaCKeD By
EL_MuHaMMeD  Title
Relevancy 100%


On Tue, May 12, 2009 at 10:25 AM, Peter Boughton wrote:

>
> I guess talking to Robert would be a good start...
>
> http://whois.domaintools.com/cfcode.com
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322415
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: (ot) Who takes care of this site? ;-))

[Peter Boughton]

I guess talking to Robert would be a good start...

http://whois.domaintools.com/cfcode.com



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322414
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

getting cfx_imsmail and cfset to play nice?

[Jack Ring]

I am currently trying to use the  tag (custom tag available using 
inFusion Mail Server) and I have a question which I hope can be easily answered.

I want to use the cfx_imsmail tag to replace a cfmail tag that uses a query 
attribute.  I am using the query and queryfield attributes to automatically 
loop the same query.  My problem is that while inside an attribute of the 
cfx_imsmail tag, my  tags seem to be ignored.  I want to put in place 
some link tracking logic and also a  tag that calls a dynamic 
template name.  I have tried to set up this data in a token_emailbody 
attribute, directly in the body attribute, and also directly in the html 
attribute, but nothing seems to work for me.  

a dumbed-down code snippet is attached below:



Please note that the data contained in the html attribute of the cfx_imsmail 
tag in the above code example was taken directly from between the opening and 
closing  tags that I'm trying to replace.  The cfmail tag works without 
any problems at all times.

I keep getting an error on line 57 stating that a variable is undefined, even 
though I have the variable being defined on line 54. This leads me to believe 
that the  I am using is not being executed.  Is there anything I can do 
to get my  to behave properly while inside of the cfx_imsmail tag?

I have had success looping the cfx_imsmail tag for my query, replacing query 
and queryfield attributes with the smtpto attribute, and using a cfsavecontent 
tag before the cfx_imsmail tag to build the content for the html attribute.  I 
do not want to do it this way, as this is far less efficient than using the 
query and queryfield attributes. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322413
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfmail validation

[alex poyaoan]

thanks will try this out...



>isValid("email", emailaddr) will tell you if it's a correctly formed email
>address, but not if it actually exists. 
>
>This udf will check that a mailbox exists. Haven't tried it myself yet:
>
>http://cflib.org/udf/verifyEmail
>
>HI everybody am using cfmail with the code below.. my problem is with the
>query that get's all email addresses. If an email address is valid it goes
>if at one point emailaddress is not valid it gives an error. is there a way
>with my code to test valid email addresses or better then if there is a way
>that i could check which emails just went thru or not?
>
>
>   SERVER="cbox.cbox.org" 
>   SUBJECT="subject"
>   FROM="""press service"" "
>   TO="""#Trim(Name)# #Trim(Fname)#"" <#Trim(emailaddr)#>"
>   TYPE="HTML"  >  
>
> 
>  
>
>thanks for any help 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322412
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: (ot) Who takes care of this site? ;-))

[Beru]

Attachments don't go through... the site is www.cfcode.com


On Tue, May 12, 2009 at 12:47, Beru  wrote:

>
> Site is hacked... And no, it's not me...
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322411
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

(ot) Who takes care of this site? ;-))

[Beru]

Site is hacked... And no, it's not me...


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322410
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Why is my server in the US ?

[Tom Chiverton]

On Tuesday 12 May 2009, Paul Hastings wrote:
> ah, two countries separated by a language...no i meant that *you* do the
> low level java call to set the default locale as a workaround until you can
> track down what's resetting the locale.

*Ah ha* gotcha now :-)
We've stuck the relevant options in the CF jvm.config file for the moment.

-- 
Helping to augmentatively empower 24/7 virtual synergistic solutions as part 
of the IT team of the year, '09 and '08

Tom Chiverton
Developer
Tel: +44 0161 618 5032
Fax: +44 0161 618 5099 
tom.chiver...@halliwells.com
3 Hardman Square, Manchester, M3 3EB
www.Halliwells.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of 
members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners. We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged. If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents. If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.Halliwells.com.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322409
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cfmail validation

[Will Swain]

isValid("email", emailaddr) will tell you if it's a correctly formed email
address, but not if it actually exists. 

This udf will check that a mailbox exists. Haven't tried it myself yet:

http://cflib.org/udf/verifyEmail

-Original Message-
From: alex poyaoan [mailto:ap.cli...@tiscali.it] 
Sent: 12 May 2009 09:15
To: cf-talk
Subject: cfmail validation


HI everybody am using cfmail with the code below.. my problem is with the
query that get's all email addresses. If an email address is valid it goes
if at one point emailaddress is not valid it gives an error. is there a way
with my code to test valid email addresses or better then if there is a way
that i could check which emails just went thru or not?


"
TO="""#Trim(Name)# #Trim(Fname)#"" <#Trim(emailaddr)#>"
TYPE="HTML"  >  

 
  

thanks for any help 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322408
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfmail validation

[alex poyaoan]

HI everybody am using cfmail with the code below.. my problem is with the query 
that get's all email addresses. If an email address is valid it goes if at one 
point emailaddress is not valid it gives an error. is there a way with my code 
to test valid email addresses or better then if there is a way that i could 
check which emails just went thru or not?


"
TO="""#Trim(Name)# #Trim(Fname)#"" <#Trim(emailaddr)#>"
TYPE="HTML"  >  


 
  

thanks for any help 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322407
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4