[cfaussie] Re: query function to delete a row from a query
is there anything wrong with doing a query to leave behind what you don't want?
cfquery dbtype=query name=temp
select * from origQofQ
where not #condition#
/cfquery
cfset origQofQ = temp /
On 4/6/06, Steve Onnis [EMAIL PROTECTED] wrote:
Just my opinion, but that UDF is yuk. Imagine looping over a large query
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Friday, April 07, 2006 6:57 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: query function to delete a row from a query
From cflib, cflib is your friend.
cfscript
/**
* Removes rows from a query.
* Added var col = ;
* No longer using Evaluate. Function is MUCH smaller now.
*
* @param Query Query to be modified
* @param Rows Either a number or a list of numbers
* @return This function returns a query.
* @author Raymond Camden ([EMAIL PROTECTED])
* @version 2, October 11, 2001
*/
function QueryDeleteRows(Query,Rows) {
var tmp = QueryNew(Query.ColumnList);
var i = 1;
var x = 1;
for(i=1;i lte Query.recordCount; i=i+1) {
if(not ListFind(Rows,i)) {
QueryAddRow(tmp,1);
for(x=1;x lte ListLen(tmp.ColumnList);x=x+1) {
QuerySetCell(tmp,
ListGetAt(tmp.ColumnList,x), query[ListGetAt(tmp.ColumnList,x)][i]);
}
}
}
return tmp;
}
/cfscript
Regards
Dale Fraser
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Andrew Mercer
Sent: Friday, 7 April 2006 17:54 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: query function to delete a row from a query
doesnt look like you can do a delete in QoQ
On 4/7/06, Andrew Mercer [EMAIL PROTECTED] wrote:
Does anyone know if there is something like queryDeleteRow() {the
opersite of queryAddRow()} in CF?
google found this in a blueDragon file
otherwise I guess i will have to do a QoQ to do it
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Connecting Coldfusion to Access databases with out ODBC.
I know this is possible, Just wondering if anyone on the list is doing it? If you are? how are you doing it? are you using a JDBC connector? if so? which one? Cheers Gareth. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: query function to delete a row from a query
that is what I went with before the deleteRow functions came inOn 4/10/06, Barry Beattie [EMAIL PROTECTED]
wrote:is there anything wrong with doing a query to leave behind what you don't want?
cfquery dbtype=query name=tempselect * from origQofQwhere not #condition#/cfquerycfset origQofQ = temp /On 4/6/06, Steve Onnis
[EMAIL PROTECTED] wrote: Just my opinion, but that UDF is yuk.Imagine looping over a large query -Original Message- From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Dale Fraser Sent: Friday, April 07, 2006 6:57 PM
To: cfaussie@googlegroups.com Subject: [cfaussie] Re: query function to delete a row from a query From cflib, cflib is your friend.
cfscript /*** Removes rows from a query.* Added var col = ;* No longer using Evaluate. Function is MUCH smaller now.** @param QueryQuery to be modified
* @param Rows Either a number or a list of numbers* @return This function returns a query.* @author Raymond Camden ([EMAIL PROTECTED])* @version 2, October 11, 2001
*/ function QueryDeleteRows(Query,Rows) { var tmp = QueryNew(Query.ColumnList); var i = 1; var x = 1; for(i=1;i lte Query.recordCount
; i=i+1) { if(not ListFind(Rows,i)) { QueryAddRow(tmp,1); for(x=1;x lte ListLen(tmp.ColumnList);x=x+1) { QuerySetCell(tmp,
ListGetAt(tmp.ColumnList,x), query[ListGetAt(tmp.ColumnList,x)][i]); } } } return tmp; } /cfscript
Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:
cfaussie@googlegroups.com] On Behalf Of Andrew Mercer Sent: Friday, 7 April 2006 17:54 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: query function to delete a row from a query
doesnt look like you can do a delete in QoQ On 4/7/06, Andrew Mercer [EMAIL PROTECTED]
wrote: Does anyone know if there is something like queryDeleteRow() {the opersite of queryAddRow()} in CF? google found this in a blueDragon file
otherwise I guess i will have to do a QoQ to do it
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: query function to delete a row from a query
I ask in case of any performance reasons not to do so.
I've left behind (previous project) an important tool/CFC that uses
this leave behind query method in important areas. If I've made a
faux pas in doing so, I'd like to know
On 4/10/06, Andrew Mercer [EMAIL PROTECTED] wrote:
that is what I went with before the deleteRow functions came in
On 4/10/06, Barry Beattie [EMAIL PROTECTED] wrote:
is there anything wrong with doing a query to leave behind what you don't
want?
cfquery dbtype=query name=temp
select * from origQofQ
where not #condition#
/cfquery
cfset origQofQ = temp /
On 4/6/06, Steve Onnis [EMAIL PROTECTED] wrote:
Just my opinion, but that UDF is yuk. Imagine looping over a large
query
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
Of Dale Fraser
Sent: Friday, April 07, 2006 6:57 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: query function to delete a row from a query
From cflib, cflib is your friend.
cfscript
/**
* Removes rows from a query.
* Added var col = ;
* No longer using Evaluate. Function is MUCH smaller now.
*
* @param Query Query to be modified
* @param Rows Either a number or a list of numbers
* @return This function returns a query.
* @author Raymond Camden ([EMAIL PROTECTED])
* @version 2, October 11, 2001
*/
function QueryDeleteRows(Query,Rows) {
var tmp = QueryNew(Query.ColumnList);
var i = 1;
var x = 1;
for(i=1;i lte Query.recordCount ; i=i+1) {
if(not ListFind(Rows,i)) {
QueryAddRow(tmp,1);
for(x=1;x lte ListLen(tmp.ColumnList);x=x+1) {
QuerySetCell(tmp,
ListGetAt(tmp.ColumnList,x), query[ListGetAt(tmp.ColumnList,x)][i]);
}
}
}
return tmp;
}
/cfscript
Regards
Dale Fraser
-Original Message-
From: cfaussie@googlegroups.com [mailto: [EMAIL PROTECTED] On
Behalf Of Andrew Mercer
Sent: Friday, 7 April 2006 17:54 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: query function to delete a row from a query
doesnt look like you can do a delete in QoQ
On 4/7/06, Andrew Mercer [EMAIL PROTECTED] wrote:
Does anyone know if there is something like queryDeleteRow()
{the
opersite of queryAddRow()} in CF?
google found this in a blueDragon file
otherwise I guess i will have to do a QoQ to do it
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Re: Connecting Coldfusion to Access databases with out ODBC.
Aren't some of the example DBs connect to access with just the file path to the Access DB? Have a look at those and see how they are done. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: query function to delete a row from a query
you could just do a QofQ WHERE id something
and if you use cfquery name=sameNameAsExistsingQuery, it would be
the same thing
HTH
On 4/7/06, Andrew Mercer [EMAIL PROTECTED] wrote:
doesnt look like you can do a delete in QoQ
On 4/7/06, Andrew Mercer [EMAIL PROTECTED] wrote:
Does anyone know if there is something like queryDeleteRow() {the opersite
of queryAddRow()} in CF?
google found this in a blueDragon file
otherwise I guess i will have to do a QoQ to do it
--
www.gavcooney.com
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
[cfaussie] Re: Connecting Coldfusion to Access databases with out ODBC.
Using ODBC drivers still I believe. Could be wrong. Cheers Gareth. David Harris wrote: Aren't some of the example DBs connect to access with just the file path to the Access DB? Have a look at those and see how they are done. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Web server level authentication
Not really what I'm after... I guess I want to set the value of 'cgi.auth_user'. I want to 'authenticate' the user, so they don't see the authentication dialog box. It's looking to me that all this authentication is done client-side, so perhaps CF won't help me in this case. thanks! From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie ArehartSent: Saturday, 8 April 2006 12:56 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Web server level authentication Ryan, if youre just asking for how to determine the identity of the authenticated user, check out cgi.auth_user (and the related cgi.auth_type). Or are you asking something else? (Even reading the replies since this original note, Id rather ask than guess.) /Charlie From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ryan SabirSent: Friday, April 07, 2006 1:46 AMTo: 'cfaussie@googlegroups.com'Subject: [cfaussie] Web server level authentication Heya folks, Say I've set up IIS authentication on a directory, so if I go there I get a standard browser popup window asking for a username and login... Is there any way I can use ColdFusion to get the user authenticated to that directory. Basically treat it as if the user had entered the correct username and password, and don't pop up the login request? thanks. Ryan SabirTechnical Directorp: (02) 9274 8030f: (02) 9274 8099m: 0411 512 454w: www.newgency.com Newgency Pty LtdWeb | Multimedia | eMarketing224 Riley StSurry Hills NSW 2010Sydney, Australia --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Web server level authentication
I'm very interested to see if you come up with a solution for this, we've been looking for something just like this. Something that I'm still looking into, but it may be possible for the pdf document to talk to the container page when your using the embedded approach. So, maybe create a new or an instance of the pdf document with a uuid or something and when the document is completed its open into the reader, delete the file behind the scenes. Something else that someone else pointed me to, is using custom 404 templates to capture the file not found on *.pdf files that don't really exist, and then using that to authenticate and embed the document, had a play with this, and couldn't really get it working because coldfusion won't pick up the requested url so I can tell where the request was from. We are also looking at paying a subscription for access to the more advanced Acrobat SDK's and examples, which may help us find a solution. Hope that makes some sense... email me if you want to talk more about it. Cheers Gareth. Ryan Sabir wrote: Not really what I'm after... I guess I want to set the value of 'cgi.auth_user'. I want to 'authenticate' the user, so they don't see the authentication dialog box. It's looking to me that all this authentication is done client-side, so perhaps CF won't help me in this case. thanks! From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart Sent: Saturday, 8 April 2006 12:56 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Web server level authentication Ryan, if youre just asking for how to determine the identity of the authenticated user, check out cgi.auth_user (and the related cgi.auth_type). Or are you asking something else? (Even reading the replies since this original note, Id rather ask than guess.) /Charlie From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Ryan Sabir Sent: Friday, April 07, 2006 1:46 AM To: 'cfaussie@googlegroups.com' Subject: [cfaussie] Web server level authentication Heya folks, Say I've set up IIS authentication on a directory, so if I go there I get a standard browser popup window asking for a username and login... Is there any way I can use ColdFusion to get the user authenticated to that directory. Basically treat it as if the user had entered the correct username and password, and don't pop up the login request? thanks. Ryan Sabir Technical Director p: (02) 9274 8030 f: (02) 9274 8099 m: 0411 512 454 w: www.newgency.com Newgency Pty Ltd Web | Multimedia | eMarketing 224 Riley St Surry Hills NSW 2010 Sydney, Australia --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Web server level authentication
how about a slightly different approach? store all the pdfs outside of the webroot. Then when a user logs in, create a symbolic link to the pdf uuid.pdf points to the pdf outside the web root. Then on session close (CF7) delete the sym link. Then you can use CF based authentication not IIS stuff.Am not sure how to create an IIS sym link programatically tho, but it's an idea.GavOn 4/10/06, Ryan Sabir [EMAIL PROTECTED] wrote: Not really what I'm after... I guess I want to set the value of 'cgi.auth_user'. I want to 'authenticate' the user, so they don't see the authentication dialog box. It's looking to me that all this authentication is done client-side, so perhaps CF won't help me in this case. thanks! -- www.gavcooney.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] secure client server communication
Hi, Can anyone tell me whether I am right by making the following assumptions; To make sure theproper client is talking to our server over **HTTPS** with XML I can do the following to authenticate them: - validate their remote IP (apparently can be spoofed??) to the one we have on file - work with public keys - have them include a password in the XML packet (obviously this could be guessed by brute force) Can't think of anything else, and I am assuming that the public key method would be the way to go? The scenario is: the clients are posting XML and we are returning XML but want to make sure they are subscribed to our services and are who they say they are. Thanks for any help Angus --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
