Re: Anyone from Orlando not in the CFUG?
I feel compelled to correct you on this. The first ColdFusion User Group was (and is) the DC CFUG, founded by Steve Drucker and me in 1996. As for the largest, I have no idea. You may have meant the largest in the UK, but as a point of pride, I couldn't let the statement stand as it is. ~lol~ Yes I did mean in the UK. My bad... I grovel at your feet for forgiveness oh great and wise creator of User Groups. ;o) Regards Stephen __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
UDF Recursion Problems
Hey All:
I have created a UDF that will recurse over a query containing
Categories that are related to each other based on a column reference to
a parent. I got the necessary logic down to do this, however, my UDF is
not working. Once the UDF calls itself, the first call is lost.
Here is what my data looks like:
AC_ID AC_NAME AC_PARENT
---
1 Nissan0
2 Infinity 0
3 2000 1
4 2001 1
5 2002 1
6 2003 1
7 Sentra5
8 SE-R 5
9 Altima5
..
16 Marketing Info7
17 Photo Library 7
..
Given this data, I want to represent these categories in nodes based on
their parent, like so (kinda like XML nodes):
Nissan
2000
2001
2002
Sentra
Marketing Info
Photo Library
...
Altima
...
Infinity
2000
...
I created the following UDF to do this, however, it drops the original
call once the recurse beings, and only returns Nissan -- 2000, then
stops:
function recurse( query, parent )
{
for ( i = 1; i LTE query.RecordCount; i = i + 1 )
{
if ( query.AC_Parent[i] EQ parent )
{
writeOutput(query.AC_Name[i]);
writeOutput(br);
recurse(query,query.AC_ID[i]);
}
}
}
I then placed this logic in custom tag, and VIOLA! It worked. Here is
my custom tag code:
cfsetting enablecfoutputonly=yes
cfparam name=Attributes.Query default=
cfparam name=Attributes.Parent default=
cfloop query=Attributes.Query
cfif AC_Parent EQ Attributes.Parent
cfoutput#AC_Name# br/cfoutput
CF_REC QUERY=#Attributes.Query# PARENT=#AC_ID#
/cfif
/cfloop
cfsetting enablecfoutputonly=no
If any of you could shed some light as to why the UDF is not working, I
would greatly appreciate it.
TIA!
Scott
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Strange QueryString
Costas, Anyone ever seen this before: Template: G:\Inetpub\wwwroot\worp\AddNote.cfm Query String: name=notes¬etypeid=¬eclassid=doctypeid=4doctypevalue=9385refresh=0.857234 4947703243 This is directly from the error code. I can't even type a ¬! I've never seen anything like this. And we cannot reporoduce this on that workstation. Anyone got any ideas? The ¬ is in the top left next to the 1/! key on my keyboard. What you are actually seeing is your browsers interpretation of the string, what you actually have is : name=notesnotetypeid=noteclassid=doctypeid=4doctypevalue=9385refresh=0. 857234 The ¬ symbol can be represented in HTML using not; The trouble comes when browsers don't wait for the semi-colon to denote the end of the escape code. In this case your browser is picking up not from the Query String and displaying the ¬ symbol instead. Hope this helps Regards Stephen __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UDF Recursion Problems
Scott Van Vliet wrote: Hey All: I have created a UDF that will recurse over a query containing Categories that are related to each other based on a column reference to a parent. I got the necessary logic down to do this, however, my UDF is not working. Once the UDF calls itself, the first call is lost. Why reinvent the wheel when you can download cfx_make_tree or some other custom tag for this from the DevEx? Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UDF Recursion Problems
Scott, I created the following UDF to do this, however, it drops the original call once the recurse beings, and only returns Nissan -- 2000, then stops: The reason why the code works in a custom tag and not in a UDF is that as a custom tag the variables are by default local to each call to the tag. However, with UDFs they have access to all the variable scopes, so I suspect you're overwriting your parent variables etc. But as Jochem says, why reinvent the wheel Go looking the Devex on the MM site or there's Raymond Camden's library site at http://www.cflib.org/ Have a look under the resource section for Rob Brooks-Bilson's top 10 udf tips too Regards Stephen __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Input Type=file
Mike, I have a layout issue here. Is there a way when you use input type=file that you can get the browse button to appear below the form element as apposed to the right hand side? Kind of an odd question, but it would save me a ton of layout work. I'm afraid you can't change the word on the button or the position of the button. The best you can do is assign a class to the tag, so that it at least looks pretty. ;o) Regards Stephen __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MySQL error with myODBC drivers
Neil, update productsettings set vchvalue = '#Evaluate(FLD_ FTVAR_SETTINGSTRINGTMP)#' where vchsettingname = '#vchsettingname#' and iforumid = #FORUMID# What's the error you're getting? Regards Stephen __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Anyone for a spot of VXML
Hi, I have started top dabble in voice driven apps integrated with Cf.This is not a problem the problem is I am currently using voicegenie (usa) to process the vxml through their vxml gateway (great service). The app runs on our own servers but I dial up a number to access the app, because I am just dabbling with Vxml it would be too expensive to run our own vxml gateway at present.As we are based in Belfast the accounts department has started to look at my phone calls to the usa with horror,and I can see my wages disappear in front of my very eyes. Does anyone know of a similar service that voicegenie provides except a bit closer to home i.e. the Glorious UK. Many Thanks Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anyone for a spot of VXML
Jerry, BeVocal have a UK gateway (actually dials up over the pond but you get charged UK rates) check it: http://cafe.bevocal.com/ I used them for some trial apps and it worked quite well. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 09:32 To: CF-Talk Subject: Anyone for a spot of VXML Hi, I have started top dabble in voice driven apps integrated with Cf.This is not a problem the problem is I am currently using voicegenie (usa) to process the vxml through their vxml gateway (great service). The app runs on our own servers but I dial up a number to access the app, because I am just dabbling with Vxml it would be too expensive to run our own vxml gateway at present.As we are based in Belfast the accounts department has started to look at my phone calls to the usa with horror,and I can see my wages disappear in front of my very eyes. Does anyone know of a similar service that voicegenie provides except a bit closer to home i.e. the Glorious UK. Many Thanks Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** ** ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** ** ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Input Type=file
I have a layout issue here. Is there a way when you use input type=file that you can get the browse button to appear below the form element as apposed to the right hand side? The best you can do is assign a class to the tag, so that it at least looks pretty. ;o) I'm not sure you can even do that. The Browse... button's appearance is an OS/browser thing, and applying styles to the input have no effect on it. There was a JavaScript workaround at one point (http://and.doxdesk.com/software/js/upload.html) but even that's been withdrawn by the author because of difficulties. A pain, eh? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anyone for a spot of VXML
Cheers Rich -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 10:20 To: CF-Talk Subject: RE: Anyone for a spot of VXML Jerry, BeVocal have a UK gateway (actually dials up over the pond but you get charged UK rates) check it: http://cafe.bevocal.com/ I used them for some trial apps and it worked quite well. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 09:32 To: CF-Talk Subject: Anyone for a spot of VXML Hi, I have started top dabble in voice driven apps integrated with Cf.This is not a problem the problem is I am currently using voicegenie (usa) to process the vxml through their vxml gateway (great service). The app runs on our own servers but I dial up a number to access the app, because I am just dabbling with Vxml it would be too expensive to run our own vxml gateway at present.As we are based in Belfast the accounts department has started to look at my phone calls to the usa with horror,and I can see my wages disappear in front of my very eyes. Does anyone know of a similar service that voicegenie provides except a bit closer to home i.e. the Glorious UK. Many Thanks Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** ** ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** ** ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MySQL error with myODBC drivers
Hi Stephen. Turns out that mySQL was freaking with \ in a fieldname : I have to enter a path i.e. c:\blah\blah I had to escape the \ to get it work. I think it is a problem with the ODBC drivers as it is a pretty straightforward SQL action. Very strange indeed. Neil __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
preventing two or more users editing a page?
We wish to prevent two or more users from editing a page (at the same time) - so for example, if person A is editing something, person B and C cannot edit it. This is for a admin backoffice - the page in question would be a form where users could modify content. When person A has finished editing, someone else can then edit it. We want to prevent person A spending 30 minututes making changes, person B comes in, makes a single change (and waits), after person A saves, person B saves (and all changes that were made by person A are now lost). The problem is on how to release the lock on a page, if the user just closes the browser (or loses the connection to the site) we cannot unrelease the lock when they have finished since we cannot identify when a user has left. We don't want something cumbersome like a javascript popup asking the user 'Are you still editing?' every 5 minutes or so (and unlocking if there is no response etc). We could use a image pipe (from the browser to the server) to use javascript to inform the server every minute or so (I am still alive) and if this pipe is lost (ie the client does not make any request to the server) the server will know (via schedule etc) that its been 1 minute since the last request was made and release the lock - are there any disadvantages to this method? Bimal Shah Senior Web developer | Venus Internet Ltd | www.venus.co.uk e: [EMAIL PROTECTED] | t: 0207 240 5858 | f: 0207 240 5859 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk-list V1 #222
Thank you for the email. I am out of the office until Monday April 1st. I will receive your email when I return and respond to you at that time. If you have questions while I am out, please feel free to contact Janelle Schneider in our Client Services Department. She can be reached by email at [EMAIL PROTECTED] or by phone at 206-548-9295 x10. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DB info on files in Verity search results
I imagine I'm not alone in having information (filesize, filetype, description, custom title, upload date, etc.) about files uploaded to a site stored in a DB table. I'm creating a search interface, and I'm just wondering if there's any simple way in CF of including information from the DB about files in the collection when I index the files themselves. The only thing I can think to do is: - Name files that are uploaded with their ID on the end, like 'download_23.pdf' (which I do anyways) - Index the files - When the search results are output, grab the ID with ListLast(filename, _), perform a CFQUERY, and output the DB-stored info with each result This seems like overkill on the DB. I suppose if you limit the results to ten per page... But still, I'd rather not have ten extras DB hits for every search request. Is there are simpler way? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP
I have to run a shell script in a Linux server(I have all the permissions) using a cold fusion page but my cold fusion is runing in a Windows NT. Can i use cfhttp type=POST (CGI).? If yes how can i get the output(text printed on the scream) into a variable? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UDF Recursion Problems
Looking at it...
The loops look right, even though you are using different types of loops (A
For vs collection).
I bet the person who mentioned scopes is right on.
Complex structures pass by reference. Simple structures pass by
value. I wonder if it is seeing: query.AC_ID[i] as a simple value or a
complex value?
Try this and see if it has an affect:
function recurse( query, parent )
{
var nextparent = 0;
for ( i = 1; i LTE query.RecordCount; i = i + 1 )
{
if ( query.AC_Parent[i] EQ parent )
{
writeOutput(query.AC_Name[i]);
writeOutput(br);
nextparent = query.AC_ID[i];
recurse(query,nextparent);
}
}
}
Other than that, I'm stuck.
At 01:02 AM 3/28/2002 -0800, you wrote:
Hey All:
I have created a UDF that will recurse over a query containing
Categories that are related to each other based on a column reference to
a parent. I got the necessary logic down to do this, however, my UDF is
not working. Once the UDF calls itself, the first call is lost.
Here is what my data looks like:
AC_ID AC_NAME AC_PARENT
---
1 Nissan0
2 Infinity 0
3 2000 1
4 2001 1
5 2002 1
6 2003 1
7 Sentra5
8 SE-R 5
9 Altima5
..
16 Marketing Info7
17 Photo Library 7
..
Given this data, I want to represent these categories in nodes based on
their parent, like so (kinda like XML nodes):
Nissan
2000
2001
2002
Sentra
Marketing Info
Photo Library
...
Altima
...
Infinity
2000
...
I created the following UDF to do this, however, it drops the original
call once the recurse beings, and only returns Nissan -- 2000, then
stops:
function recurse( query, parent )
{
for ( i = 1; i LTE query.RecordCount; i = i + 1 )
{
if ( query.AC_Parent[i] EQ parent )
{
writeOutput(query.AC_Name[i]);
writeOutput(br);
recurse(query,query.AC_ID[i]);
}
}
}
I then placed this logic in custom tag, and VIOLA! It worked. Here is
my custom tag code:
cfsetting enablecfoutputonly=yes
cfparam name=Attributes.Query default=
cfparam name=Attributes.Parent default=
cfloop query=Attributes.Query
cfif AC_Parent EQ Attributes.Parent
cfoutput#AC_Name# br/cfoutput
CF_REC QUERY=#Attributes.Query# PARENT=#AC_ID#
/cfif
/cfloop
cfsetting enablecfoutputonly=no
If any of you could shed some light as to why the UDF is not working, I
would greatly appreciate it.
TIA!
Scott
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UDF Recursion Problems
But as Jochem says, why reinvent the wheel Go looking the Devex on the MM site or there's Raymond Camden's library site at Just to make it clear, the site is run by Rob Brooks-Bilson _and_ me, not just myself. Everything that works - I did. Everything broken is his fault. ;) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UDF Recursion Problems
But as Jochem says, why reinvent the wheel Go looking the Devex on the MM site or there's Raymond Camden's library site at Just to make it clear, the site is run by Rob Brooks-Bilson _and_ me, not just myself. Everything that works - I did. Everything broken is his fault. ;) Ah... So that's why he's got more UDFs uploaded on the site than anyone He's been fiddling the figures... ;oD __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UDF Recursion Problems
Your UDF has one simple problem, and it's a problem I see _many_ users
do.
You MUST always remember to var scope your variables. In this case, you
forgot to var the variable, I. So, when you call recurse the second
time, i is no longer reset to 1. To fix this, simply add: var i = 1;
When I did that, your UDF worked immidiately.
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
I created the following UDF to do this, however, it drops the original
call once the recurse beings, and only returns Nissan -- 2000, then
stops:
function recurse( query, parent )
{
for ( i = 1; i LTE query.RecordCount; i = i + 1 )
{
if ( query.AC_Parent[i] EQ parent )
{
writeOutput(query.AC_Name[i]);
writeOutput(br);
recurse(query,query.AC_ID[i]);
}
}
}
I then placed this logic in custom tag, and VIOLA! It worked. Here is
my custom tag code:
cfsetting enablecfoutputonly=yes
cfparam name=Attributes.Query default=
cfparam name=Attributes.Parent default=
cfloop query=Attributes.Query
cfif AC_Parent EQ Attributes.Parent
cfoutput#AC_Name# br/cfoutput
CF_REC QUERY=#Attributes.Query# PARENT=#AC_ID#
/cfif
/cfloop
cfsetting enablecfoutputonly=no
If any of you could shed some light as to why the UDF is not
working, I
would greatly appreciate it.
TIA!
Scott
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: preventing two or more users editing a page?
Why not simply require manual check out and check in? -Original Message- From: Bimal Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 6:08 AM To: CF-Talk Subject: preventing two or more users editing a page? We wish to prevent two or more users from editing a page (at the same time) - so for example, if person A is editing something, person B and C cannot edit it. This is for a admin backoffice - the page in question would be a form where users could modify content. When person A has finished editing, someone else can then edit it. We want to prevent person A spending 30 minututes making changes, person B comes in, makes a single change (and waits), after person A saves, person B saves (and all changes that were made by person A are now lost). The problem is on how to release the lock on a page, if the user just closes the browser (or loses the connection to the site) we cannot unrelease the lock when they have finished since we cannot identify when a user has left. We don't want something cumbersome like a javascript popup asking the user 'Are you still editing?' every 5 minutes or so (and unlocking if there is no response etc). We could use a image pipe (from the browser to the server) to use javascript to inform the server every minute or so (I am still alive) and if this pipe is lost (ie the client does not make any request to the server) the server will know (via schedule etc) that its been 1 minute since the last request was made and release the lock - are there any disadvantages to this method? Bimal Shah Senior Web developer | Venus Internet Ltd | www.venus.co.uk e: [EMAIL PROTECTED] | t: 0207 240 5858 | f: 0207 240 5859 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: preventing two or more users editing a page?
You can read descriptions of this below, but here it is... 1) create an application variable containing two elements. a) Page being edited (cgi.script_name) b) Person that is making the edit. 2) set the application variable to timeout at about 10 minutes. We want to prevent person A spending 30 minututes making changes, person B comes in, makes a single change (and waits), after person A saves, person B saves (and all changes that were made by person A are now lost). Two things you can do here.. 1) create an application array that holds the list of pages that are currently being edited... Hmmm... you might need an application variable for each page instead. (see second set of comments for the next problem). I think each application variable will also need a by whom identifier so it can restrict edit to one person. 2) create a datasource with a list of all the pages that can be edited and place a yes/no type field in there that says when it is locked. The problem is on how to release the lock on a page, if the user just closes the browser (or loses the connection to the site) we cannot unrelease the lock when they have finished since we cannot identify when a user has left. you can set the application variable's timeout to a small number, say 10 minutes. If the page is re-requested by the same user, then the timer gets reset for another 10 minutes. If not, it times out, releasing the lock. We don't want something cumbersome like a javascript popup asking the user 'Are you still editing?' every 5 minutes or so (and unlocking if there is no response etc). We could use a image pipe (from the browser to the server) to use javascript to inform the server every minute or so (I am still alive) and if this pipe is lost (ie the client does not make any request to the server) the server will know (via schedule etc) that its been 1 minute since the last request was made and release the lock - are there any disadvantages to this method? Bimal Shah Senior Web developer | Venus Internet Ltd | www.venus.co.uk e: [EMAIL PROTECTED] | t: 0207 240 5858 | f: 0207 240 5859 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
UDF Recursion Problems
Scott,
You didn't VAR your variables - which is causing the value to be
overwritten. In UDFs, you must always VAR temporary or variables that
are local to the UDF.
Add this as the first line to your UDF:
var i=1;
-Rob
snip
I created the following UDF to do this, however, it drops the original
call once the recurse beings, and only returns Nissan -- 2000, then
stops:
function recurse( query, parent )
{
for ( i = 1; i LTE query.RecordCount; i = i + 1 )
{
if ( query.AC_Parent[i] EQ parent )
{
writeOutput(query.AC_Name[i]);
writeOutput(br);
recurse(query,query.AC_ID[i]);
}
}
}
I then placed this logic in custom tag, and VIOLA! It worked. Here is
my custom tag code:
cfsetting enablecfoutputonly=yes
cfparam name=Attributes.Query default=
cfparam name=Attributes.Parent default=
cfloop query=Attributes.Query
cfif AC_Parent EQ Attributes.Parent
cfoutput#AC_Name# br/cfoutput
CF_REC QUERY=#Attributes.Query# PARENT=#AC_ID#
/cfif
/cfloop
cfsetting enablecfoutputonly=no
If any of you could shed some light as to why the UDF is not working, I
would greatly appreciate it.
TIA!
Scott
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity Spider Weirdness -- Cannot Purge
I'm trying to create and index a collection using the search spider in CF 5. In general, I've had pretty good luck with this in the past, but now it's giving me an error when I try to purge the collection. It says: (ind002006) VDK: Error E3-0326 (Vdk Info): Collection c:\cfusion\verity\collections\main_site is currently read_only; cannot submit work. I've tried stopping the server and checking that. I've gone through the folders, and as far as I can tell they all have normal permissions. I'm trying to do this through the command line with: vspider -purge -collection c:\cfusion\verity\collections\main_site Anyone got any hints? Seen this before? -- jon - jon roig senior manager, online production epilepsy foundation tel: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error 0x80040707 ISRT.GetPorts
Ran into this error during the CF 5 install and thought that it might help someone. Fix: Stop the Print Spooler serive. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UDF Recursion Problems
I have a lot more code to run that just writeOutput(). Also, this is my first time building an app on CF 5 (I was trying to wait for NEO's release, but just couldn't last), and I wanted to get some first hand experience with UDFs. What's wrong with that? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:28 AM To: CF-Talk Subject: Re: UDF Recursion Problems Scott Van Vliet wrote: Hey All: I have created a UDF that will recurse over a query containing Categories that are related to each other based on a column reference to a parent. I got the necessary logic down to do this, however, my UDF is not working. Once the UDF calls itself, the first call is lost. Why reinvent the wheel when you can download cfx_make_tree or some other custom tag for this from the DevEx? Jochem __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UDF Recursion Problems
It works perfectly :) Thanks to all who helped. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 5:18 AM To: CF-Talk Subject: RE: UDF Recursion Problems But as Jochem says, why reinvent the wheel Go looking the Devex on the MM site or there's Raymond Camden's library site at Just to make it clear, the site is run by Rob Brooks-Bilson _and_ me, not just myself. Everything that works - I did. Everything broken is his fault. ;) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Verity Spider Weirdness -- Cannot Purge
You might try stopping the server, deleting the that collection's folder in \CFUSION\Verity\Collections, restart the server, and recreate the collection from your template or the cf admin. Jamie On Thu, 28 Mar 2002 09:28:10 -0500, in cf-talk you wrote: I'm trying to create and index a collection using the search spider in CF 5. In general, I've had pretty good luck with this in the past, but now it's giving me an error when I try to purge the collection. It says: (ind002006) VDK: Error E3-0326 (Vdk Info): Collection c:\cfusion\verity\collections\main_site is currently read_only; cannot submit work. I've tried stopping the server and checking that. I've gone through the folders, and as far as I can tell they all have normal permissions. I'm trying to do this through the command line with: vspider -purge -collection c:\cfusion\verity\collections\main_site Anyone got any hints? Seen this before? -- jon - jon roig senior manager, online production epilepsy foundation tel: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and EBAY
Me too!! Me too!! Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:40 AM To: CF-Talk Subject: RE: CF and EBAY I'd be interested as well. Thanks. Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 2:35 PM To: CF-Talk Subject: RE: CF and EBAY I'm interested as well. thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 2:20 PM To: CF-Talk Subject: RE: CF and EBAY Can the rest of us see? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 3:19 PM To: CF-Talk Subject: Re: CF and EBAY I wrote one of those two. It goes a step further and grabs all the bidders on the matching auctions... Very evil. ;) I have an agent that takes a search term and an optional category and searches for all items of that type. Would that do? I also did a little with an ebay agent in my HTTPAgent lecture from one of the conferences. Should be on the front of HoF. At 06:27 PM 3/26/02, you wrote: Does anyone know if any tags exist that grab a sellers auctions form ebay? I thought I would ask before trying to do this myself... no sense in reinventing the wheel. Thanks, Mike __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Office on Solaris?
I would say no on this one. Office is just barely starting to be able to run on Linux, which would be Solaris's redheaded stepson cousin. Maybe if they can get it to run on Linux it could work on Solaris one day. Then to be able to use com objects, I don't know about that. That may be some wishful thinking, I don't know how wine would be wrapping up Office to run. If I were you I would just save the files in a format that can be opened in those programs. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:21 AM To: CF-Talk Subject: Office on Solaris? I'm wondering if it's possible to do exports to Excel, Word, etc. on Solaris? I know that Office has to be installed on the server to do this kind of stuff, but do COM objects, etc. work on Solaris? Is there an Office for Solaris to begin with? I don't know much about Solaris, and I've searched CFComet with no luck on the issue. If you can't use Office, are there alternatives for a Solaris environment? I currently export to excel by giving an html file and xls extension, but I need more functionality (i.e., sorting columns, datatypes, etc.) than that trick provides. Thanks in advance, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Office on Solaris?
I'm wondering if it's possible to do exports to Excel, Word, etc. on Solaris? I know that Office has to be installed on the server to do this kind of stuff, but do COM objects, etc. work on Solaris? Is there an Office for Solaris to begin with? I don't know much about Solaris, and I've searched CFComet with no luck on the issue. If you can't use Office, are there alternatives for a Solaris environment? I currently export to excel by giving an html file and xls extension, but I need more functionality (i.e., sorting columns, datatypes, etc.) than that trick provides. Thanks in advance, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Office on Solaris?
Isn't StarOffice - www.staroffice.com a Solaris application suite much like MS Office? Neil Team Macromedia __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Office on Solaris?
You can do exports to Excel and Word on Solaris. We do it and we do not have Office setup on the server. You can create or I know there are some custom tags out there. Once you export it opens Excel or Word on there desktop. That is one way of doing it. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:21 AM To: CF-Talk Subject: Office on Solaris? I'm wondering if it's possible to do exports to Excel, Word, etc. on Solaris? I know that Office has to be installed on the server to do this kind of stuff, but do COM objects, etc. work on Solaris? Is there an Office for Solaris to begin with? I don't know much about Solaris, and I've searched CFComet with no luck on the issue. If you can't use Office, are there alternatives for a Solaris environment? I currently export to excel by giving an html file and xls extension, but I need more functionality (i.e., sorting columns, datatypes, etc.) than that trick provides. Thanks in advance, Dave. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Hypothetical SQL question
Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Announcement: New Flash MX component
This is a little OT, but I'm very excited to be able to announce the introduction of a new Flash MX component. Everyone's been hearing from MM about how Flash MX will save the world; here's a little demonstration. DaVinci is a component that can be used by itself, or within a larger Flash application, for capturing user input in a way that would be, well, difficult with just HTML. Fig Leaf Software Announces 'DaVinci' 'DaVinci' is the first of a series of Flash MX components being developed by Fig Leaf Software. Using DaVinci, you can add image annotation capabilities to your web-based applications. End-users may add lines, text, scribbles, and other geometric forms that sit in layers on top of a background JPEG image. The vector drawings are represented as XML and can be saved into a database for future reference. The component can be dropped into any HTML-based web page, or included as part of a complete Flash MX solution. Because the component was developed using Flash MX from Macromedia, it is cross-browser compatible with any device running the Flash 6 player. Fig Leaf Software will soon begin soliciting feedback from beta testers. If you want to join the beta, or get more information, go to http://davinci.figleaf.com; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hypothetical SQL question
Hope this helps :) cfset goodgrade = A CFQUERY name=getgradeA datasource=datasource Select Distinct people.people, grades.grades FROMgrades, people Where people.people_id = grades.people_id AND grades.grades = '#goodgrade#' /CFQUERY Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:32 AM To: CF-Talk Subject: Hypothetical SQL question Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Office on Solaris?
You beat me to it...I love Star Office/Open Office. Just to add a little info, Star Office is no longer going to be free, but the open source version, Open Office will remain free. http://www.openoffice.org jon - Original Message - From: Neil Clark =TMM= [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 11:24 AM Subject: RE: Office on Solaris? Isn't StarOffice - www.staroffice.com a Solaris application suite much like MS Office? Neil Team Macromedia __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Announcement: New Flash MX component
Dave, I checked out the drawing tool demo, and have just one question. Would it be possible to keep the focus on the drawing tool selected after you have release the mouse button? It would be better dont you think, if you wanted to continue to draw other elements with that tool. Right now once you release it, it goes back to the arrow selection tool. Success is a journey, not a destination!! Doug Brown - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 8:43 AM Subject: Announcement: New Flash MX component This is a little OT, but I'm very excited to be able to announce the introduction of a new Flash MX component. Everyone's been hearing from MM about how Flash MX will save the world; here's a little demonstration. DaVinci is a component that can be used by itself, or within a larger Flash application, for capturing user input in a way that would be, well, difficult with just HTML. Fig Leaf Software Announces 'DaVinci' 'DaVinci' is the first of a series of Flash MX components being developed by Fig Leaf Software. Using DaVinci, you can add image annotation capabilities to your web-based applications. End-users may add lines, text, scribbles, and other geometric forms that sit in layers on top of a background JPEG image. The vector drawings are represented as XML and can be saved into a database for future reference. The component can be dropped into any HTML-based web page, or included as part of a complete Flash MX solution. Because the component was developed using Flash MX from Macromedia, it is cross-browser compatible with any device running the Flash 6 player. Fig Leaf Software will soon begin soliciting feedback from beta testers. If you want to join the beta, or get more information, go to http://davinci.figleaf.com; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hypothetical SQL question
I have done a similar query for reporting purposes that took a very long time to run, but worked. Something like: SELECT a.*, b.* FROM People a, Grades b WHERE a.PeopleID = b.PeopleID AND a.PeopleID IN (SELECT c.PeopleID FROM People c, Grades d WHERE c.PeopleID = d.PeopleID AND d.Grade = A) Cantrell, Adam [EMAIL PROTECTED] 03/28/02 11:31AM Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hypothetical SQL question
select * from people, grades where people.id = grades.peopleID and people.id in ( select people.id from people, grades where people.id = grades.peopleID and grades.grade = 'a' ) Something like that? May have screwed up something in there, but that's how I'd do it. Jamie On Thu, 28 Mar 2002 10:31:30 -0600, in cf-talk you wrote: Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hypothetical SQL question
Select people.peopleid, grades.grade From people, grades Where grades.peopleid = people.peopleid and People.peopleid in (select grades.peopleid from grades where grades.grade= 'A') How about something like that? - Matt Small -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:32 AM To: CF-Talk Subject: Hypothetical SQL question Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hypothetical SQL question
That's what I have right now, but that won't return the other grades. It will show the people that have A's, but it won't return their B's C's and D's. I think it's an outer join of some sort, but I haven't been able to get it to work with my conditions. Adam. -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:44 AM To: CF-Talk Subject: RE: Hypothetical SQL question Hope this helps :) cfset goodgrade = A CFQUERY name=getgradeA datasource=datasource Select Distinct people.people, grades.grades FROM grades, people Where people.people_id = grades.people_id AND grades.grades = '#goodgrade#' /CFQUERY Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:32 AM To: CF-Talk Subject: Hypothetical SQL question Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
I checked out the drawing tool demo, and have just one question. Would it be possible to keep the focus on the drawing tool selected after you have release the mouse button? It would be better dont you think, if you wanted to continue to draw other elements with that tool. Right now once you release it, it goes back to the arrow selection tool. I'm sure it's possible. I've forwarded your suggestion to the appropriate people. Thanks for your input! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hypothetical SQL question
You can do a post filter on a group by clause by adding a having clause to your select. BUT it doesn't seem like you would wand to group results by peopleID since you would not be returning each grade associated with a user, you would (at best) only be able to return the ave grade for that user -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 8:32 AM To: CF-Talk Subject: Hypothetical SQL question Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hypothetical SQL question
Almosttry select p.*, g.* from people p INNER JOIN grades g ON (p.id = g.peopleid) where p.id IN (select p.id from people p INNER JOIN grades g ON (p.id = g.peopleid) where g.grade = 'a') -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 16:48 To: CF-Talk Subject: Re: Hypothetical SQL question select * from people, grades where people.id = grades.peopleID and people.id in ( select people.id from people, grades where people.id = grades.peopleID and grades.grade = 'a' ) Something like that? May have screwed up something in there, but that's how I'd do it. Jamie On Thu, 28 Mar 2002 10:31:30 -0600, in cf-talk you wrote: Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hypothetical SQL question
That was awesome... Jamie, Anthony, Matthew, Shawn, Andy, Steven, anyone else - you guys rule. I got that sucker working like pie! Thanks again. Adam. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:48 AM To: CF-Talk Subject: Re: Hypothetical SQL question select * from people, grades where people.id = grades.peopleID and people.id in ( select people.id from people, grades where people.id = grades.peopleID and grades.grade = 'a' ) Something like that? May have screwed up something in there, but that's how I'd do it. Jamie On Thu, 28 Mar 2002 10:31:30 -0600, in cf-talk you wrote: Hypothetical SQL question: I have a table called PEOPLE and a table called GRADES. I'd like to return a list of people and all of their grades and then output the results in a cfoutput, grouping by peopleID. Ok, that's easy enough, but what if I only want to return people that have an A as one of their grades? What type of condition do I use to achieve this? Currently I'm able to pull the people that have an A, but it won't return the other grades, so it ends up with a bunch of people with just one or more A's - it won't show their B's, C's, and D's. This seems way to easy, but I'm struggling with it this morning for some reason, maybe someone can give me a little push. Adam. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Complex List Delimiter
Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
Cool Tool Dave! Showed it to a coworker, and his comment was be nice if you could do something like this for an MPEG file. But, I can see lots of places this can come in handy. Shawn Grover -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:44 AM To: CF-Talk Subject: Announcement: New Flash MX component This is a little OT, but I'm very excited to be able to announce the introduction of a new Flash MX component. Everyone's been hearing from MM about how Flash MX will save the world; here's a little demonstration. DaVinci is a component that can be used by itself, or within a larger Flash application, for capturing user input in a way that would be, well, difficult with just HTML. Fig Leaf Software Announces 'DaVinci' 'DaVinci' is the first of a series of Flash MX components being developed by Fig Leaf Software. Using DaVinci, you can add image annotation capabilities to your web-based applications. End-users may add lines, text, scribbles, and other geometric forms that sit in layers on top of a background JPEG image. The vector drawings are represented as XML and can be saved into a database for future reference. The component can be dropped into any HTML-based web page, or included as part of a complete Flash MX solution. Because the component was developed using Flash MX from Macromedia, it is cross-browser compatible with any device running the Flash 6 player. Fig Leaf Software will soon begin soliciting feedback from beta testers. If you want to join the beta, or get more information, go to http://davinci.figleaf.com; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Announcement: New Flash MX component
Hey Dave, Pretty cool stuff. I can already see the project management and collaboration tool possibilities. I did have trouble trying to cut or delete a filled box. I made a filled box...clicked on it to select itselected either cut or delete from the edit menuno worky :-( (but that's what beta is for right) Cheers Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
I can't get to the site :( Our firewall is blocking the domain because, if I recall correctly, there was a virus called DaVinci, and anything related to that is being blocked! Errr.. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 8:44 AM To: CF-Talk Subject: Announcement: New Flash MX component This is a little OT, but I'm very excited to be able to announce the introduction of a new Flash MX component. Everyone's been hearing from MM about how Flash MX will save the world; here's a little demonstration. DaVinci is a component that can be used by itself, or within a larger Flash application, for capturing user input in a way that would be, well, difficult with just HTML. Fig Leaf Software Announces 'DaVinci' 'DaVinci' is the first of a series of Flash MX components being developed by Fig Leaf Software. Using DaVinci, you can add image annotation capabilities to your web-based applications. End-users may add lines, text, scribbles, and other geometric forms that sit in layers on top of a background JPEG image. The vector drawings are represented as XML and can be saved into a database for future reference. The component can be dropped into any HTML-based web page, or included as part of a complete Flash MX solution. Because the component was developed using Flash MX from Macromedia, it is cross-browser compatible with any device running the Flash 6 player. Fig Leaf Software will soon begin soliciting feedback from beta testers. If you want to join the beta, or get more information, go to http://davinci.figleaf.com; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Session variables dropping
I have an intermittent problem with the session scoped variables being dropped going from the frame definition template to the template within the frame. This is occurring on IE 6. I remember hearing at one point that IE 6 handles each separate frame as a separate window. Are there any known issues with how IE 6 handles session variables across frames? Lon Lentz Applications Developer and Keeper of the I.T. http://ProofitOnline.Com - Free 15 Day Trial __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Forcing Query Refresh (Sometimes)
I want to cache a query for 99% of the time. However, when users update the data, I want to allow them an option to refresh the query and set that query as the newly cached one. I can't use the cachedwithin attribute, or at least not as I know of it, but I really could benefit from caching, just when the data is updated I need to reset the cache. I know I could stop and start the CF service, but only I have access to this option and it's not optimal. Thanks for any help, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
site is not coming up. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:44 AM To: CF-Talk Subject: Announcement: New Flash MX component This is a little OT, but I'm very excited to be able to announce the introduction of a new Flash MX component. Everyone's been hearing from MM about how Flash MX will save the world; here's a little demonstration. DaVinci is a component that can be used by itself, or within a larger Flash application, for capturing user input in a way that would be, well, difficult with just HTML. Fig Leaf Software Announces 'DaVinci' 'DaVinci' is the first of a series of Flash MX components being developed by Fig Leaf Software. Using DaVinci, you can add image annotation capabilities to your web-based applications. End-users may add lines, text, scribbles, and other geometric forms that sit in layers on top of a background JPEG image. The vector drawings are represented as XML and can be saved into a database for future reference. The component can be dropped into any HTML-based web page, or included as part of a complete Flash MX solution. Because the component was developed using Flash MX from Macromedia, it is cross-browser compatible with any device running the Flash 6 player. Fig Leaf Software will soon begin soliciting feedback from beta testers. If you want to join the beta, or get more information, go to http://davinci.figleaf.com; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Announcement: New Flash MX component
Dave I want to sign up for the beta... but can't find out where from the link you gave. Dick __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
Dave You should be excited about this. Great work. I hope this is just the tip of the Figleaf Flash MX component Iceberg. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:44 AM To: CF-Talk Subject: Announcement: New Flash MX component This is a little OT, but I'm very excited to be able to announce the introduction of a new Flash MX component. Everyone's been hearing from MM about how Flash MX will save the world; here's a little demonstration. DaVinci is a component that can be used by itself, or within a larger Flash application, for capturing user input in a way that would be, well, difficult with just HTML. Fig Leaf Software Announces 'DaVinci' 'DaVinci' is the first of a series of Flash MX components being developed by Fig Leaf Software. Using DaVinci, you can add image annotation capabilities to your web-based applications. End-users may add lines, text, scribbles, and other geometric forms that sit in layers on top of a background JPEG image. The vector drawings are represented as XML and can be saved into a database for future reference. The component can be dropped into any HTML-based web page, or included as part of a complete Flash MX solution. Because the component was developed using Flash MX from Macromedia, it is cross-browser compatible with any device running the Flash 6 player. Fig Leaf Software will soon begin soliciting feedback from beta testers. If you want to join the beta, or get more information, go to http://davinci.figleaf.com; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Complex List Delimiter
try ListToArray(content,chr(12)) - Original Message - From: Wallick, Mike [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 10:54 AM Subject: Complex List Delimiter Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Removing Characters
I have a problem with WDDX and odd characters. If I have a form field that submits a title and has an appostrophe, such as Paul's example and then I am trying to stick it into a WDDX packet, I am getting an error. Is there anything you can do that will find all kinds of characters such as ', , and other possible bad things? Instead of doing a replace? The error I am getting is a Not Well Formed XML error.. Any help would be greatly appreciated! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CDONTS and ReplyTo
Can someone tell me how to set the Reply-To header when using CDONTS in ColdFusion? These assignments do NOT work: cfset objNewMail.ReplyTo = [EMAIL PROTECTED] cfset objNewMail.Reply_To = [EMAIL PROTECTED] cfset objNewMail.Value(Reply-To) = [EMAIL PROTECTED] Thanks, Dave Jones NetEffect __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFUG in the Midwest?
Does anyone know of a CFUG in the Midwest? Steve Kurtenbach Bay Technology Group, Inc. [EMAIL PROTECTED] (main) 605 331 5058 (ext) 605 335 4434 (fax) 605 338 2768 Enhancing Productivity in the Workplace Through.. E-Business, Consulting, Outsourcing, and Training http://www.bay-tech-group.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 3:04 AM To: CF-Talk Subject: Re: Anyone from Orlando not in the CFUG? I feel compelled to correct you on this. The first ColdFusion User Group was (and is) the DC CFUG, founded by Steve Drucker and me in 1996. As for the largest, I have no idea. You may have meant the largest in the UK, but as a point of pride, I couldn't let the statement stand as it is. ~lol~ Yes I did mean in the UK. My bad... I grovel at your feet for forgiveness oh great and wise creator of User Groups. ;o) Regards Stephen __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Forcing Query Refresh (Sometimes)
Use the cachedwithin attribute, then whenever the user updates the query, call the query without the cachedwithin attribute. Something like this: --somequery.cfm cfparam name=attributes.querytimeout default=#createtimespan(0,1,0,0)# cfquery .. cachedwithin=#attributes.querytimeout# .. /cfquery Then whenever the user updates data, call it like this. cfmodule template=somequery.cfm querytimeout=#createtimespan(0,0,0,0)# That will refresh the query with the new data. - Original Message - From: Smith, Daron [PA] [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 11:08 AM Subject: Forcing Query Refresh (Sometimes) I want to cache a query for 99% of the time. However, when users update the data, I want to allow them an option to refresh the query and set that query as the newly cached one. I can't use the cachedwithin attribute, or at least not as I know of it, but I really could benefit from caching, just when the data is updated I need to reset the cache. I know I could stop and start the CF service, but only I have access to this option and it's not optimal. Thanks for any help, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forcing Query Refresh (Sometimes)
You could have an Application variable that would flag your page whether or not updates to the database had been made. If changes were made, you could set the cachedwithin to zero. EXAMPLE: cfset cacheTime = CreateTimeSpan(1,0,0,0) cfif Application.DataHasBeenUpdated EQ 1 cfset cacheTime = 0 /cfif cfquery name=someQuery datasource=someDSN cachedwithin=#cacheTime# SELECT COLUMN1, COLUMN2 FROM TABLE WHERE CONDITION = SOMETHING /cfquery Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:09 AM To: CF-Talk Subject: Forcing Query Refresh (Sometimes) I want to cache a query for 99% of the time. However, when users update the data, I want to allow them an option to refresh the query and set that query as the newly cached one. I can't use the cachedwithin attribute, or at least not as I know of it, but I really could benefit from caching, just when the data is updated I need to reset the cache. I know I could stop and start the CF service, but only I have access to this option and it's not optimal. Thanks for any help, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and EBAY
I'd be interested as well. Thanks. Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 2:35 PM To: CF-Talk Subject: RE: CF and EBAY I'm interested as well. thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 2:20 PM To: CF-Talk Subject: RE: CF and EBAY Can the rest of us see? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 3:19 PM To: CF-Talk Subject: Re: CF and EBAY I wrote one of those two. It goes a step further and grabs all the bidders on the matching auctions... Very evil. ;) I have an agent that takes a search term and an optional category and searches for all items of that type. Would that do? I also did a little with an ebay agent in my HTTPAgent lecture from one of the conferences. Should be on the front of HoF. At 06:27 PM 3/26/02, you wrote: Does anyone know if any tags exist that grab a sellers auctions form ebay? I thought I would ask before trying to do this myself... no sense in reinventing the wheel. Thanks, Mike __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
I want to sign up for the beta... but can't find out where from the link you gave. That's because it's a secret beta! Well, not really - just obtuse. Click on the Order link image at the top right of the page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
site is not coming up. Could you provide more information? It's fine on our end. It is using host-header name support, which requires a browser that supports host-header naming. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex List Delimiter
Don't know for sure but it appears the delimiter is acting as a regular expression. Square brakets in a regular expression indicate optional components. So, as a shot in the dark you could try \[pagebreak\] HTH Shawn Grover -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:54 AM To: CF-Talk Subject: Complex List Delimiter Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFUG in the Midwest?
Go to http://www.macromedia.com/v1/usergroups/ You'll find one there. Regards, Dave - Original Message - From: Kurtenbach, Steve [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 12:37 PM Subject: CFUG in the Midwest? Does anyone know of a CFUG in the Midwest? Steve Kurtenbach Bay Technology Group, Inc. [EMAIL PROTECTED] (main) 605 331 5058 (ext) 605 335 4434 (fax) 605 338 2768 Enhancing Productivity in the Workplace Through.. E-Business, Consulting, Outsourcing, and Training http://www.bay-tech-group.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 3:04 AM To: CF-Talk Subject: Re: Anyone from Orlando not in the CFUG? I feel compelled to correct you on this. The first ColdFusion User Group was (and is) the DC CFUG, founded by Steve Drucker and me in 1996. As for the largest, I have no idea. You may have meant the largest in the UK, but as a point of pride, I couldn't let the statement stand as it is. ~lol~ Yes I did mean in the UK. My bad... I grovel at your feet for forgiveness oh great and wise creator of User Groups. ;o) Regards Stephen __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
Comes up fine for me, just FYI and looks really bloody exciting. Mike Brunt Sempra Energy 213.244.5226 Daddy, why doesn't this magnet pick up this floppy disk that says Emergency Repair Disk ? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:38 AM To: CF-Talk Subject: RE: Announcement: New Flash MX component site is not coming up. Could you provide more information? It's fine on our end. It is using host-header name support, which requires a browser that supports host-header naming. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
I can't get to the site :( Our firewall is blocking the domain because, if I recall correctly, there was a virus called DaVinci, and anything related to that is being blocked! Here's a workaround URL: http://www.cfugorama.com/d%u0061vinci/ The %u0061 is the Unicode representation for a, and your firewall probably won't bother doing the conversion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFUG in the Midwest?
I manage the Nebrask CFUG. There is also one in Chicago, Kansas City, Minneapolis, and Des Moines - how much do you want to travel? g -Original Message- From: Kurtenbach, Steve [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:38 AM To: CF-Talk Subject: CFUG in the Midwest? Does anyone know of a CFUG in the Midwest? Steve Kurtenbach Bay Technology Group, Inc. [EMAIL PROTECTED] (main) 605 331 5058 (ext) 605 335 4434 (fax) 605 338 2768 Enhancing Productivity in the Workplace Through.. E-Business, Consulting, Outsourcing, and Training http://www.bay-tech-group.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 3:04 AM To: CF-Talk Subject: Re: Anyone from Orlando not in the CFUG? I feel compelled to correct you on this. The first ColdFusion User Group was (and is) the DC CFUG, founded by Steve Drucker and me in 1996. As for the largest, I have no idea. You may have meant the largest in the UK, but as a point of pride, I couldn't let the statement stand as it is. ~lol~ Yes I did mean in the UK. My bad... I grovel at your feet for forgiveness oh great and wise creator of User Groups. ;o) Regards Stephen __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Removing Characters
I have a problem with WDDX and odd characters. If I have a form field that submits a title and has an appostrophe, such as Paul's example and then I am trying to stick it into a WDDX packet, I am getting an error. Is there anything you can do that will find all kinds of characters such as ', , and other possible bad things? Instead of doing a replace? The error I am getting is a Not Well Formed XML error.. Look at the XMLFormat function, if you're using CF 5. I'm not sure if it's available in earlier versions. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MySQL error with myODBC drivers
That's a feature, not a bug ;D. mySQL uses the backslash character as its beginner for native escape sequences, which you can pretty much ignore on balance. http://www.mysql.com/doc/S/t/String_syntax.html So, as you've probably already figured out, you need to use \\ for a \ in your input. I use a replace function on vorm vars just prior to insertion when users are entering windos pathnames and such. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Neil Clark =TMM= [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 2:04 AM To: CF-Talk Subject: RE: MySQL error with myODBC drivers Hi Stephen. Turns out that mySQL was freaking with \ in a fieldname : I have to enter a path i.e. c:\blah\blah I had to escape the \ to get it work. I think it is a problem with the ODBC drivers as it is a pretty straightforward SQL action. Very strange indeed. Neil __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
Wow! Kudos to Fig! I could really have used this a couple of years ago on a project where dentists collaborated on dental xrays and needed to make notes. Would have been much nicer if they could have made notes directly on the image. At save time is it possible to pull the text out and store it in a db or xml packet and reload it next time the image is viewed? Duane -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:42 PM To: CF-Talk Subject: RE: Announcement: New Flash MX component I can't get to the site :( Our firewall is blocking the domain because, if I recall correctly, there was a virus called DaVinci, and anything related to that is being blocked! Here's a workaround URL: http://www.cfugorama.com/d%u0061vinci/ The %u0061 is the Unicode representation for a, and your firewall probably won't bother doing the conversion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP
I have to run a shell script in a Linux server(I have all the permissions) using a cold fusion page but my cold fusion is runing in a Windows NT. Can i use cfhttp type=POST (CGI).? If yes how can i get the output(text printed on the scream) into a variable? Probably not, since you said it was a shell script that you wanted to run. CFHTTP would require that you have a web server and CGI script on the Linux server. You could write a batch file on your Windows server to handle connecting via telnet or ssh to the Linux box, and running the script, and capturing the output from the script. You could then call that batch file from CFEXECUTE. Note that this will be complicated, probably, and may be difficult to debug. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problems with MySql
Hello All, I have a question that I hope someone here can help me out with. The problem is that I have a stats program running in the background of every page. So when someone hits my website it insert a record in the mysql database. The problem start when the database is bigger then 1 million records. When I try to run the stats program the cpu on ther server stays the same and after about an hour the page timesout without any errors. This used to work very well...Is it because of the amount of records??? I have tables for every month... I am using a windows 2000 sp2, mysql 3.23.47-nt with 1gig of ram running coldfusion 5.0 prof. This was working very well last week. Does anyone have any idea why this is happeneing... Also...There is something call mysql max..Does anyone know if I should be using this or not??? We don't really have th emoney for oracle or mssql...So I would like to make it work with mysql... Thanks for all the help. Joel __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
Yes. -S -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:53 PM To: CF-Talk Subject: RE: Announcement: New Flash MX component Wow! Kudos to Fig! I could really have used this a couple of years ago on a project where dentists collaborated on dental xrays and needed to make notes. Would have been much nicer if they could have made notes directly on the image. At save time is it possible to pull the text out and store it in a db or xml packet and reload it next time the image is viewed? Duane -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:42 PM To: CF-Talk Subject: RE: Announcement: New Flash MX component I can't get to the site :( Our firewall is blocking the domain because, if I recall correctly, there was a virus called DaVinci, and anything related to that is being blocked! Here's a workaround URL: http://www.cfugorama.com/d%u0061vinci/ The %u0061 is the Unicode representation for a, and your firewall probably won't bother doing the conversion. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
At save time is it possible to pull the text out and store it in a db or xml packet and reload it next time the image is viewed? Yes, anything is possible! Seriously, though, it's a component, so you could certainly wrap it in a container that provides the behavior that you want. At this point, I don't know exactly what the finished featureset of the component itself will be. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
At save time is it possible to pull the text out and store it in a db or xml packet and reload it next time the image is viewed? Yes, anything is possible! Seriously, though, it's a component, so you could certainly wrap it in a container that provides the behavior that you want. At this point, I don't know exactly what the finished featureset of the component itself will be. The definitive answer: Yes. - Steve Drucker Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: preventing two or more users editing a page?
You could always set up each section in the database with an allowed number of users. Then have your users log in. Once they are logged in they go to each section they want to edit. If someone who is logged in has already checked out that page then they can't edit it. There are tons of things you can do. I wouldn't really rely on the client to tell you with javascript if they are still alive, javascript could be disabled. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Bimal Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 6:08 AM To: CF-Talk Subject: preventing two or more users editing a page? We wish to prevent two or more users from editing a page (at the same time) - so for example, if person A is editing something, person B and C cannot edit it. This is for a admin backoffice - the page in question would be a form where users could modify content. When person A has finished editing, someone else can then edit it. We want to prevent person A spending 30 minututes making changes, person B comes in, makes a single change (and waits), after person A saves, person B saves (and all changes that were made by person A are now lost). The problem is on how to release the lock on a page, if the user just closes the browser (or loses the connection to the site) we cannot unrelease the lock when they have finished since we cannot identify when a user has left. We don't want something cumbersome like a javascript popup asking the user 'Are you still editing?' every 5 minutes or so (and unlocking if there is no response etc). We could use a image pipe (from the browser to the server) to use javascript to inform the server every minute or so (I am still alive) and if this pipe is lost (ie the client does not make any request to the server) the server will know (via schedule etc) that its been 1 minute since the last request was made and release the lock - are there any disadvantages to this method? Bimal Shah Senior Web developer | Venus Internet Ltd | www.venus.co.uk e: [EMAIL PROTECTED] | t: 0207 240 5858 | f: 0207 240 5859 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with MySql
I know that the windows version of MySQL has a connection limit that the Linux version is not subject to. Perhaps there are other limitations as well. Have you considered moving your MySQL off to a linux box? -mk * you wrote ** .. I am using a windows 2000 sp2, mysql 3.23.47-nt with 1gig of ram running coldfusion 5.0 prof. .. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and EBAY (code posted)
Ok, here it is: http://galaga.technocraft.com/ebay/ Enjoy. I wrote it for internal use, so there is no UI to speak of... Sure. Let me put it up somewhere and y'all can wreak havoc with it. Can the rest of us see? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 3:19 PM To: CF-Talk Subject: Re: CF and EBAY I wrote one of those two. It goes a step further and grabs all the bidders on the matching auctions... Very evil. ;) I have an agent that takes a search term and an optional category and searches for all items of that type. Would that do? I also did a little with an ebay agent in my HTTPAgent lecture from one of the conferences. Should be on the front of HoF. At 06:27 PM 3/26/02, you wrote: Does anyone know if any tags exist that grab a sellers auctions form ebay? I thought I would ask before trying to do this myself... no sense in reinventing the wheel. Thanks, Mike __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: date massaging
Even if CF supported dates without separators, you are setting numdate wrong anyway. CFSET numdate=03042002 You really mean to set CFSET numdate=03042002 it is the string you want, not a number representing 3 million and change. Of course you really want something like CFSET numdate=03/04/2002 Just a thought Jerry Johnson [EMAIL PROTECTED] 03/27/02 06:27PM Looking at the docs, it says: Returns a date/time object from a string. ParseDateTime converts date/time strings that are in the U.S. date format. Use LSParseDateTime for international date parsing. And also: Year values 0 - 29 are interpreted as 21st century dates. Year values 30 - 99 are interpreted as 20th century dates. That seems to imply that (maybe?) it only handles 2-digit years... which would be very odd, but I've seen dumber things... Oh, okay - looking at the LSParseDateTime docs, it says (pardon the no-doubt bad formatting): - When passing a date/time value for the English (US) locale, the date/time string can be in any of the following forms: date/time Composition Example dd 25 January 1999 hh:mm:ss 8:30:00 hh:mm:ss 20:30:00 dd, hh:mm:ss January 25, 1999 8:30:00 hh:mm:ss mmm. dd, 8:30:00 Jan. 25, 1999 m/dd/ hh:mm:ss 1/25/1999 8:30:00 -- Looks like numbers without a separator aren't supported... :-( Dirk -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 3:16 PM To: CF-Talk Subject: re: date massaging Dave wrote, just wondering, is there a reason you wouldn't use parseDateTime() for this? it takes a string and converts it to a cf date. If I try this: CFSET numdate=03042002 CFSET thedate=ParseDateTime(numdate) CFOUTPUT#thedate#/CFOUTPUT I get this: ''The date parameter of function ParseDateTime(date), which is 03042002, does not represent a valid date'' Despite the fact that if I test the string against IsDate() it verifies just fine. --Matt-- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfset/cfstoredproc
This is somewhat of a repost from the other day but haven't gotten any feedback- since I don't think I worded my problem very well. I am moving some of my work from cfquery to storedprocedures- the problem is the formatting when I use cfset with a stored procedures- they don't react the same way as a cfquery does... I need the info to show as such Mark: 1. A 2. B 3. A Mary 1. A 2. A 3. D John 1. C 2. A 3. B To achieve this with cfquery I did this: CFOUTPUT QUERY=QOne CFSET NAME= One.FIRSTNAME CFLOOP QUERY =QTwo CFSET One=QTwo.Answer[1] CFSET Two=QTwo.Answer[2] CFSET Three=QTwo.Answer[3] /CFLOOP /CFOUTPUT If I do the same with a stored procedure I end up with Mark: 1. A 2. B 3. A Mary 1. A 2. B 3. A John 1. A 2. B 3. A I can't use just a regular output like Ben Forta shows in this CF5 book-I've tried all his solutions but they all deal with regular outputs(which works fine with the cfquery and cfstored proc)- I need to use a cfset statement because each answer needs its own name. Has anyone run across this? What's the best solution? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: IIS 5 WWW-Server and writing of logfiles
Hi list, is there a way to write under MS-IIS 5 (Win2000) with two virtual domains (One IP, via host-deader) in one (the same) log-file ? I haven't figured out, how to do it, since IIS is installing a new logfile when installing a new virtual domain. Thanks for your ideas. Uwe __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS 5 WWW-Server and writing of logfiles
Nope - I think not. No matter where you point your log file directory, IIS will create a subdirectory indexed to the order your domains have been created in (w3svc1-2-3 etc.). I doubt you are going to be able to change this - you could try hacking up the registry I suppose g. -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:37 PM To: CF-Talk Subject: OT: IIS 5 WWW-Server and writing of logfiles Hi list, is there a way to write under MS-IIS 5 (Win2000) with two virtual domains (One IP, via host-deader) in one (the same) log-file ? I haven't figured out, how to do it, since IIS is installing a new logfile when installing a new virtual domain. Thanks for your ideas. Uwe __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfset/cfstoredproc
Janine, I don't think I'm following your example. What's wrong with the second example? also, why do you need 2 queries? Why not a join? a join would give you columns of name , answer name, answer, name, answer name, answer ORder by name and make sure there is a PK ... then do this: cfoutput query=myQuery group=name #name# (or Cfset theName = name if you like) cfoutput group=PK ... Use the PK to ensure all records are iterated #answer# (or cfset Answer1 = answer) /cfoutput /cfoutput Still... I'm not sure I know exactly what the problem is from the example below. -Mark * your example * This is somewhat of a repost from the other day but haven't gotten any feedback- since I don't think I worded my problem very well. I am moving some of my work from cfquery to storedprocedures- the problem is the formatting when I use cfset with a stored procedures- they don't react the same way as a cfquery does... I need the info to show as such Mark: 1. A 2. B 3. A Mary 1. A 2. A 3. D John 1. C 2. A 3. B To achieve this with cfquery I did this: CFOUTPUT QUERY=QOne CFSET NAME= One.FIRSTNAME CFLOOP QUERY =QTwo CFSET One=QTwo.Answer[1] CFSET Two=QTwo.Answer[2] CFSET Three=QTwo.Answer[3] /CFLOOP /CFOUTPUT If I do the same with a stored procedure I end up with Mark: 1. A 2. B 3. A Mary 1. A 2. B 3. A John 1. A 2. B 3. A I can't use just a regular output like Ben Forta shows in this CF5 book-I've tried all his solutions but they all deal with regular outputs(which works fine with the cfquery and cfstored proc)- I need to use a cfset statement because each answer needs its own name. Has anyone run across this? What's the best solution? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
Stellar work, Fig Leaf. I'm looking forward to seeing this product develop! I will be signing up for the beta testing here shortly. :) --Paul Paul W. Wille [EMAIL PROTECTED] --- Certified Advanced Coldfusion 5 Developer --- ISITE Design, Inc. -- Solutions Architect www.isitedesign.com 615 SW Broadway, Suite 200 Portland, OR 97205 503.221.9860 x110 503.221.9865 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:06 AM To: CF-Talk Subject: RE: Announcement: New Flash MX component At save time is it possible to pull the text out and store it in a db or xml packet and reload it next time the image is viewed? Yes, anything is possible! Seriously, though, it's a component, so you could certainly wrap it in a container that provides the behavior that you want. At this point, I don't know exactly what the finished featureset of the component itself will be. The definitive answer: Yes. - Steve Drucker Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex List Delimiter
when you say pagebreak, are you talking about a new line? if so it would ce defined as #chr(13)##chr(10)#. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:54 AM To: CF-Talk Subject: Complex List Delimiter Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex List Delimiter
Except bare in mind that when you pass multiple chars as a list delim, CF will treat _each_ as a list delim. So, if your text contains a stray chr(13) or chr(10), it will also split there. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:48 PM To: CF-Talk Subject: RE: Complex List Delimiter when you say pagebreak, are you talking about a new line? if so it would ce defined as #chr(13)##chr(10)#. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:54 AM To: CF-Talk Subject: Complex List Delimiter Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFCOOKIE
Hi, I'm using a custom tag the displays the groups assigned to a specific user which works fine. The code below is in my application.cfm file in my wwwroot. I can't seem to figure out when I set a cookie it only displays the last group of that user? When I run the code for the first time the following groups are displayed from the #group# contract hrls supprt tax Administrators Groups: Administrators Why is it only displaying Administrators and not the who string? The idea is to use the cookie.SetGroups to set profiles for each user based on the groups assigned to them via NT. cfif IsDefined(Cookie.Groups) is False cfcookie name=Groups value=1 !--- START LIST VALID GROUPS FOR A SPECIFIC USER --- CFX_Users ACTION=GROUPS SCOPE=Local USER=test CFIF IsDefined(Users) CFIF IsQuery(Users) CFLOOP QUERY=Users cfoutput #Group# /cfoutput cfcookie name=SetGroups value=#group# expires=NEVER /CFLOOP /CFIF /CFIF !--- END LIST VALID GROUPS FOR A SPECIFIC USER --- /cfif Groups: cfoutput#COOKIE.SetGroups#/cfoutput +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS 5 WWW-Server and writing of logfiles
well, you can change the location of the logs when creating the virtual domains. point them at the same file. of course, you may run into some SERIOUS concurrency issues with two ISAPI processes writing to the file at the same time. as far as i've seen (YMMV, of course), the process holds the file open until it hits the rotation point. i can't predict that good things will happen when you ask two procs to have the same file open. what are you hoping to accomplish, though? perhaps there's another way around this. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:42 PM To: CF-Talk Subject: RE: IIS 5 WWW-Server and writing of logfiles Nope - I think not. No matter where you point your log file directory, IIS will create a subdirectory indexed to the order your domains have been created in (w3svc1-2-3 etc.). I doubt you are going to be able to change this - you could try hacking up the registry I suppose g. -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:37 PM To: CF-Talk Subject: OT: IIS 5 WWW-Server and writing of logfiles Hi list, is there a way to write under MS-IIS 5 (Win2000) with two virtual domains (One IP, via host-deader) in one (the same) log-file ? I haven't figured out, how to do it, since IIS is installing a new logfile when installing a new virtual domain. Thanks for your ideas. Uwe __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex List Delimiter
Actually, I think you have to use #chr(13)##chr(10)#, don't you? Kevin Langevin Flying Chimp Media 954-585-0999 [EMAIL PROTECTED] http://www.FlyingChimp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 1:48 PM To: CF-Talk Subject: RE: Complex List Delimiter when you say pagebreak, are you talking about a new line? if so it would ce defined as #chr(13)##chr(10)#. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:54 AM To: CF-Talk Subject: Complex List Delimiter Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Oracle version of TOP
Sorry for the OT, but do any of you know the Oracle function for selecting the top n records. (ie. SELECT TOP 10 * FROM TABLE - in SQL). Thanks! Scott -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with IE Browsers on Mac OS
We are having serious problems with Mac IE browsers as well. We're in the process of narrowing but it seems to follow the form variable problems. I'll keep you posted as we identify them. We are not having problems with ANY other browsers/platforms at this point. Regards, Neil -Original Message- From: Kurtenbach, Steve [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 6:02 PM To: CF-Talk Subject: FW: Problems with IE Browsers on Mac OS We are experiencing strange errors with a web application that we have developed that seems to be specific to Mac users. MAC problems include: - session management (occasionally dropping sessions) - retrieving form variables (incorrect data) - CFMAIL utility (seems flaky) - variable lengths (return incorrect lengths) Has anyone else experienced these problems? If so what did you do to resolve them? Are the problems typically browser or operating system specific? Are there any resources available for resolving MAC specific issues? If so what are they and where can we find them? Thanks Steve Kurtenbach Bay Technology Group, Inc. [EMAIL PROTECTED] (main) 605 331 5058 (ext) 605 335 4434 (fax) 605 338 2768 Enhancing Productivity in the Workplace Through.. E-Business, Consulting, Outsourcing, and Training http://www.bay-tech-group.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Complex List Delimiter
No, actually I mean the text string [pagebreak]. I'm not talking ASCII characters. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 12:48 PM To: CF-Talk Subject: RE: Complex List Delimiter when you say pagebreak, are you talking about a new line? if so it would ce defined as #chr(13)##chr(10)#. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:54 AM To: CF-Talk Subject: Complex List Delimiter Quick question for you gurus out there I want to use a text delimiter for my content that's in a database. I want to use [pagebreak] as the delimiter. In php, I would use: // Split the text into an array of pages $textarray = split(\[pagebreak], $content); However, in ColdFusion, ListToArray(content, [pagebreak]) (or some similar function) is interpreted as any of the characters in the [pagebreak] string could be a delimiter (i.e. [ p a g e b r e a k ]). Any ideas? mike wallick * web application developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with MySql
If you're trying to produce a results page by crunching thru a million records, then I expect that's the problem. I have a CF/mysql stats system on several sites - all on the same win2k server - and they run fine. The key for me was to archive old results for Week 1, 2, 3 etc. so the routine doesn't have to parse thru old data. Just pulls result totals out of a separate db and displays them. Mysql max allows you to use innodb and bdb-type tables, which give row locking and transaction support. V4.01 is fully acid-compliant, I believe. Slower and not something I'd play with if I didn't specifically need it. mysql max eats about 4 times the memory as plain old mysqld-nt.exe. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: CFTalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:57 AM To: CF-Talk Subject: Problems with MySql Hello All, I have a question that I hope someone here can help me out with. The problem is that I have a stats program running in the background of every page. So when someone hits my website it insert a record in the mysql database. The problem start when the database is bigger then 1 million records. When I try to run the stats program the cpu on ther server stays the same and after about an hour the page timesout without any errors. This used to work very well...Is it because of the amount of records??? I have tables for every month... I am using a windows 2000 sp2, mysql 3.23.47-nt with 1gig of ram running coldfusion 5.0 prof. This was working very well last week. Does anyone have any idea why this is happeneing... Also...There is something call mysql max..Does anyone know if I should be using this or not??? We don't really have th emoney for oracle or mssql...So I would like to make it work with mysql... Thanks for all the help. Joel __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problems with IE Browsers on Mac OS
I think that some Mac browsers insert a line break in form fields, if I remember right it is only when enctype=multipart/form-data. The solution is just to trim every form field when you use it in your CF code. Neil Giarratana [EMAIL PROTECTED] 03/28/02 02:12PM We are having serious problems with Mac IE browsers as well. We're in the process of narrowing but it seems to follow the form variable problems. I'll keep you posted as we identify them. We are not having problems with ANY other browsers/platforms at this point. Regards, Neil -Original Message- From: Kurtenbach, Steve [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 6:02 PM To: CF-Talk Subject: FW: Problems with IE Browsers on Mac OS We are experiencing strange errors with a web application that we have developed that seems to be specific to Mac users. MAC problems include: - session management (occasionally dropping sessions) - retrieving form variables (incorrect data) - CFMAIL utility (seems flaky) - variable lengths (return incorrect lengths) Has anyone else experienced these problems? If so what did you do to resolve them? Are the problems typically browser or operating system specific? Are there any resources available for resolving MAC specific issues? If so what are they and where can we find them? Thanks Steve Kurtenbach Bay Technology Group, Inc. [EMAIL PROTECTED] (main) 605 331 5058 (ext) 605 335 4434 (fax) 605 338 2768 Enhancing Productivity in the Workplace Through.. E-Business, Consulting, Outsourcing, and Training http://www.bay-tech-group.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Oracle version of TOP
VAN VLIET, SCOTT E (SBCSI) wrote: Sorry for the OT, but do any of you know the Oracle function for selecting the top n records. (ie. SELECT TOP 10 * FROM TABLE - in SQL). Thanks! Scott rowcount is similar but my oracle skills have bit rotted :-( i think :-) z __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCOOKIE
You are displaying the GROUP variable from inside a loop, but you are also setting the cookie inside the loop. So you are really doing this... contract [set cookie to contract] hrls [set cookie to hrls] supprt [set cookie to support] tax [set cookie to tax] Administrators [set cookie to Administrators] so you can see why the cookie ends up being Administrators... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:08 AM To: CF-Talk Subject: Re: CFCOOKIE Hi, I'm using a custom tag the displays the groups assigned to a specific user which works fine. The code below is in my application.cfm file in my wwwroot. I can't seem to figure out when I set a cookie it only displays the last group of that user? When I run the code for the first time the following groups are displayed from the #group# contract hrls supprt tax Administrators Groups: Administrators Why is it only displaying Administrators and not the who string? The idea is to use the cookie.SetGroups to set profiles for each user based on the groups assigned to them via NT. cfif IsDefined(Cookie.Groups) is False cfcookie name=Groups value=1 !--- START LIST VALID GROUPS FOR A SPECIFIC USER --- CFX_Users ACTION=GROUPS SCOPE=Local USER=test CFIF IsDefined(Users) CFIF IsQuery(Users) CFLOOP QUERY=Users cfoutput #Group# /cfoutput cfcookie name=SetGroups value=#group# expires=NEVER /CFLOOP /CFIF /CFIF !--- END LIST VALID GROUPS FOR A SPECIFIC USER --- /cfif Groups: cfoutput#COOKIE.SetGroups#/cfoutput +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFWDDX example needed
Here's the code I've written so far in my attempt to use WDDX to pass around
an array on a clustered server ... where I'm stuck is with getting the array
out of the packet and appending to it. (more comments after the code):
cfif NOT IsDefined('client.CartItems')
!--- if no cart, create it and populate it with the first item ---
cfscript
cart = ArrayNew(1);
item = StructNew();
item.itemEmployersID = '#client.CART_ID#';
item.itemName = '#form.ItemName#';
item.itemQuanity = '#quanity#';
item.itemPrice = '#form.Price#';
item.itemCategoryID = '#form.Category_ID#';
CartItems = ArrayAppend(cart, item);
/cfscript
cfwddx action=CFML2WDDX
input=#CartItems#
output=client.CartItems
usetimezoneinfo=No
cfelse
cfwddx action=WDDX2CFML
input=#client.CartItems#
output=Cart
cfscript
item = StructNew();
item.itemEmployersID = '#client.CART_ID#';
item.itemName = '#form.ItemName#';
item.itemQuanity = '#quanity#';
item.itemPrice = '#form.Price#';
item.itemCategoryID = '#form.Category_ID#';
CartItems = ArrayAppend(cart, item);
/cfscript
cfwddx action=CFML2WDDX
input=#CartItems#
output=client.CartItems
usetimezoneinfo=No
/cfif
Right now I'm getting an error at line 79: CartItems = ArrayAppend(cart,
item);
Parameter 1 of function ArrayAppend which is now YES must be an array
So I'm not sure how I get an array again and then append to it.
H.
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCOOKIE... more...
try this: cfcookie name=SetGroups value=#valuelist(users.group)# expires=NEVER +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:28 AM To: CF-Talk Subject: RE: CFCOOKIE You are displaying the GROUP variable from inside a loop, but you are also setting the cookie inside the loop. So you are really doing this... contract [set cookie to contract] hrls [set cookie to hrls] supprt [set cookie to support] tax [set cookie to tax] Administrators [set cookie to Administrators] so you can see why the cookie ends up being Administrators... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 11:08 AM To: CF-Talk Subject: Re: CFCOOKIE Hi, I'm using a custom tag the displays the groups assigned to a specific user which works fine. The code below is in my application.cfm file in my wwwroot. I can't seem to figure out when I set a cookie it only displays the last group of that user? When I run the code for the first time the following groups are displayed from the #group# contract hrls supprt tax Administrators Groups: Administrators Why is it only displaying Administrators and not the who string? The idea is to use the cookie.SetGroups to set profiles for each user based on the groups assigned to them via NT. cfif IsDefined(Cookie.Groups) is False cfcookie name=Groups value=1 !--- START LIST VALID GROUPS FOR A SPECIFIC USER --- CFX_Users ACTION=GROUPS SCOPE=Local USER=test CFIF IsDefined(Users) CFIF IsQuery(Users) CFLOOP QUERY=Users cfoutput #Group# /cfoutput cfcookie name=SetGroups value=#group# expires=NEVER /CFLOOP /CFIF /CFIF !--- END LIST VALID GROUPS FOR A SPECIFIC USER --- /cfif Groups: cfoutput#COOKIE.SetGroups#/cfoutput +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
