RE: Question from a beginner
Thanks everyone for helping me with this especially RS.I have managed to get it working though I have to move the pages into the running config.I went with a slightly different solution than the one proposed by others and thought I would add it to this thread incase it is of any value to others. Rather than handle the query in the application I used a series of selects by the ranges I wanted and unioned them together.Below is what I did.Not sure if it is what I am supposed to do but seemed to make sense and made things easier to build the href back the base page to re-filter the query. !--- Some Catch block for the URL variables I am expecting to catch --- cfif IsDefined(URL.Chart) AND url.Chart EQ 1 cfset ChartMe=Region cfset Title=Regional Distribution of Hikes /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 2 cfset ChartMe=HikeDifficulty cfset Title=Difficulty PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 3 cfset ChartMe=Reccomend cfset Title=Reccomendation Piechart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 4 cfset ChartMe=HikeTime cfset Title=Round Trip Time In Hours PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 5 cfset ChartMe=RoundTripDistance cfset Title=Round Trip Distance In Miles PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 6 cfset ChartMe=ElevationGain cfset Title=Elevation Gained In Feet PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 7 cfset ChartMe=HighPoint cfset Title=Peak Elevation Gained In Feet PieChart /cfif cfif IsDefined(URL.Chart) AND url.Chart EQ 8 cfset ChartMe=LowPoint cfset Title=Begining Elevation In Feet PieChart /cfif !--- End Catch block for URL variables --- cfif IsDefined(URL.Chart) AND url.Chart EQ 6 or url.Chart EQ 7 or url.Chart EQ 8 cfquery name=Recordset1 datasource=hike Select '0-500' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 0 and 500 union Select '501-1000' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 501 and 1000 union Select '1001-1500' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 1001 and 1500 union Select '1501-2000' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 1501 and 2000 union Select '2001-2500' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 2001 and 2500 union Select '2501-3000' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 2501 and 3000 union Select '3001-3500' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 3001 and 3500 union Select '3501-4000' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 3501 and 4000 union Select '4001-4500' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 4001 and 4500 union Select '4501-5000' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 4501 and 5000 union Select '5001-5500' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 5001 and 5500 union Select '5501-6000' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 5501 and 6000 union Select '6001-6500' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 6001 and 6500 union Select '6501-7000' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 6501 and 7000 union Select '7001-7500' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 7001 and 7500 union Select '7501-8000' as Elevation1, count(*) as NumOfHikes >From Hike where #ChartMe# between 7501 and 8000 /cfquery cfelse cfquery name=Recordset1 datasource=hike SELECT #ChartMe#, count(*) as Chart_count FROM hike Where #ChartMe# is not null group by #ChartMe# order by #ChartMe#; /cfquery /cfif !--- I don't think you need to have both blocks necessarily.I need to look at this later --- cfif IsDefined(URL.Chart) AND url.Chart EQ 6 or url.Chart EQ 7 or url.Chart EQ 8 cfchart showborder=yes show3d=yes chartwidth=600 chartheight=400pieslicestyle=sliced url=""> lumns#urlvalue=$ITEMLABEL$ cfchartseries type=pie query=Recordset1 itemcolumn=Elevation1valuecolumn=NumofHikes /cfchartseries /cfchart cfelse cfchart showborder=yes show3d=yes chartwidth=600 chartheight=400pieslicestyle=sliced url=""> lumns#urlvalue=$ITEMLABEL$ cfchartseries type=pie query=Recordset1 itemcolumn=#ChartMe#valuecolumn=Chart_count /cfchartseries /cfchart /cfif -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 10:54 AM To: CF-Talk Subject: RE: Question from a beginner Well, after looking at the site, I completely miss living in Portland, OR. Boo Hoo! Make the following changes and I think you can get there: (The label will say 500, rather than the more proper 500-1000, but I leave that as a detail for you to finish) =) Jerry Johnson cfif IsDefined(URL.Chart) AND
RE: JOIN help
A left outer join? -Oorspronkelijk bericht- Van: Cedric Villat [mailto:[EMAIL PROTECTED] Verzonden: za 15/11/2003 2:52 Aan: CF-Talk CC: Onderwerp: JOIN help Here is my query now, but all it returns are rows in which there are entries in the UserQueues table. SELECT Q.QueueID, AccessID, Q.QueueName FROM Queues Q RIGHT JOIN SecurityXrefUserQueues XUQ ON XUQ.QueueID = Q.QueueID WHERE XUQ.UserID = #url.uid# Anyone have any idea how I can get the above result that I need? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[2]: limit processor load of cfserver.exe ?
Jochem, thanks again for coming back with ideas to resolve this. I am using the tool from beyond logic. The following happens, when I try to change the priority: Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP V2.03 Copyright(C) 2002-2003 [EMAIL PROTECTED] Setting PriorityClass on PID 948 'cfserver.exe' to 32 Error 0x6 : Das Handle ist ung³ltig. meaning: the handle is invalid I tried several options with always the same result. Ideas what to do ? I will try the process viewer from MS now. ;-) Uwe JvD [EMAIL PROTECTED] wrote: Thursday, November 13, 2003, 11:29:40 PM, you wrote: [EMAIL PROTECTED] wrote: Hi list, is it (theoretically) possible, to limit the processor load coldfusion (cfserver.exe) is causing to the server itself ?(OS: Win2000 Server; CF: Version 5) Just give it a lower priority. The bad part is, that I cannot change the priority even though I am the administrator. Strange windows. The message is: Access denied JvD Try the Process Viewer from the MS Support Tools. Or else JvD http://www.beyondlogic.org/consulting/processutil/processutil.htm JvD (Since that works from the command line, you can even schedule it JvD every hour so it resets the priority even if CF is restarted.) JvD Jochem -- Best regards, cf-talk mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
TOP 3 Most Recent Records
How would you go about selecting the 3 newest records from an Access 2003 table where the PK is an autonumber and the table has no date/time field? Thanks. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: TOP 3 Most Recent Records
Michael, On Saturday, November 15, 2003, 9:49:42 AM, you wrote: MTT How would you go about selecting the 3 newest records from an Access 2003 MTT table where the PK is an autonumber and the table has no date/time field? This should work: select top 3 * from table order by pk desc ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: TOP 3 Most Recent Records
Ubqtous, many thanks. :-) _ From: Ubqtous [mailto:[EMAIL PROTECTED] Sent: Saturday, November 15, 2003 9:52 AM To: CF-Talk Subject: Re: TOP 3 Most Recent Records Michael, On Saturday, November 15, 2003, 9:49:42 AM, you wrote: MTT How would you go about selecting the 3 newest records from an Access 2003 MTT table where the PK is an autonumber and the table has no date/time field? This should work: select top 3 * from table order by pk desc ~ Ubqtous ~ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: TOP 3 Most Recent Records
sort by PK order by decending then limit the output to 3 records How would you go about selecting the 3 newest records from an Access 2003 table where the PK is an autonumber and the table has no date/time field? Thanks. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Central app for MAX - useless? [OT]
The Central shell is intended to go to pocket devices eventually, but not this first version... the plan is to prove it first in the Mac/Win audience, incorporate early feedback for shaping, and after that hit Linux, PDAs, phones, TVs, etc. Cool! I think the PDA is going to be the best target platform for Central. Can you talk more about the TV plans? I used to do a lot of ITV development, but I'm not sure how Central meshes with the needs of that market. (I still have last year's paper conference guide, and it's about two laptops thick... can't read Google News on it either ;-) Yep. I've got mine too from two years back. Kinda like lugging a laptop around ;-) A localized Central server option. For distribution, you don't have to go through the Macromedia navigation/transaction engine if you don't wish. Keep an eye out for more news on business models next week. I'll be doing just that. I like RIAs, and the concept of Central is intriguing but I'm just having trouble seeing it working for the desktop market. -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:JOIN help
No such luck. I had tried that earlier, but tried again just to make sure. A left and right join just return 1 row: UserIDQueueID AccessID 2 1 0 I never get the NULL row. Any more ideas? Cedric A left outer join? -Oorspronkelijk bericht- Van: Cedric Villat [mailto:[EMAIL PROTECTED] Verzonden: za 15/11/2003 2:52 Aan: CF-Talk CC: Onderwerp: JOIN help Here is my query now, but all it returns are rows in which there are entries in the UserQueues table. SELECT Q.QueueID, AccessID, Q.QueueName FROM Queues Q RIGHT JOIN SecurityXrefUserQueues XUQ ON XUQ.QueueID = Q.QueueID WHERE XUQ.UserID = #url.uid# Anyone have any idea how I can get the above result that I need? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Central app for MAX - useless?
I love the MAX app. I think it's a great little utility and the developers certainly deserve praise for it. I just don't know how many people are going to want to try and whip out a laptop between sessions to quickly check what's going on. I know from other conferences that there was sometimes barely time to make it from session to session. Last year at Devcon and at the FlashForward, they had PocketPC flash widgets. They may not have done everything the MAX Central app does but what was there was right in the palm of the hand. Ah well. I look forward to seeing everyone at MAX! Cheers gang. -Kevin - Original Message - From: Samuel R. Neff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, November 15, 2003 12:28 AM Subject: RE: Central app for MAX - useless? I for one thought that the MAX central app was a great proof-of-concept. I've been very negative toward central and primarily I still am, but I really liked the MAX app.I wish it actually integrated with the session chooser so it knew your sessions and had direct access to the presentation slides from within Central (at least direct links), but even without that I found it very useful. I can't imagine how you would do that room finder on a PDA size screen. Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 5:24 PM To: CF-Talk Subject: Central app for MAX - useless? I just got notice of an RIA for MAX Download an exciting new desktop application (free). The Macromedia Central MAX Guide includes detailed news and information on sessions and conference events. If you're bringing your laptop to MAX this guide will be an indispensable tool. You can find your way around the conference using the interactive map, set up alerts for when a session is about to begin, and get updated news whenever you are connected. For me this is completely useless since I know better than to lug around a laptop for this kind of thing. I was hoping for a PDA utility so that it would actually be portable. So to focus discussion and not make this too OT, do other people find Central to be the the wrong solution for the right technology? I really like the RIA concept, but distributing through Central just seems too awkward. What I see it needing to be useful for us: 1. A localized Central server option. It would be a great way to distribute our tools or tools we've approved to our employees. But telling our people to go find something at the MM run Central would be too confusing. (If this is already announced, somebody slap me. I just haven't seen it.) 2. A PDA Central. The entire reason we're interested in free-standing RIAs is for the PDA. -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Central app for MAX - useless?
I cantell you that as a presenter, especially one with as many presentations as I have, the MAX Central app. should prove very helpful in making sure I'm at the right place at the right timeI'd imagine that for anyone at the conference who wants to get as muchfrom their time there as they can, it will prove the same.Looking forward to seeing many of you in a few days... ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: 15 November 2003 17:25 To: CF-Talk Subject: Re: Central app for MAX - useless? I love the MAX app. I think it's a great little utility and the developers certainly deserve praise for it. I just don't know how many people are going to want to try and whip out a laptop between sessions to quickly check what's going on. I know from other conferences that there was sometimes barely time to make it from session to session. Last year at Devcon and at the FlashForward, they had PocketPC flash widgets. They may not have done everything the MAX Central app does but what was there was right in the palm of the hand. Ah well. I look forward to seeing everyone at MAX! Cheers gang. -Kevin - Original Message - From: Samuel R. Neff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, November 15, 2003 12:28 AM Subject: RE: Central app for MAX - useless? I for one thought that the MAX central app was a great proof-of-concept. I've been very negative toward central and primarily I still am, but I really liked the MAX app.I wish it actually integrated with the session chooser so it knew your sessions and had direct access to the presentation slides from within Central (at least direct links), but even without that I found it very useful. I can't imagine how you would do that room finder on a PDA size screen. Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 5:24 PM To: CF-Talk Subject: Central app for MAX - useless? I just got notice of an RIA for MAX Download an exciting new desktop application (free). The Macromedia Central MAX Guide includes detailed news and information on sessions and conference events. If you're bringing your laptop to MAX this guide will be an indispensable tool. You can find your way around the conference using the interactive map, set up alerts for when a session is about to begin, and get updated news whenever you are connected. For me this is completely useless since I know better than to lug around a laptop for this kind of thing. I was hoping for a PDA utility so that it would actually be portable. So to focus discussion and not make this too OT, do other people find Central to be the the wrong solution for the right technology? I really like the RIA concept, but distributing through Central just seems too awkward. What I see it needing to be useful for us: 1. A localized Central server option. It would be a great way to distribute our tools or tools we've approved to our employees. But telling our people to go find something at the MM run Central would be too confusing. (If this is already announced, somebody slap me. I just haven't seen it.) 2. A PDA Central. The entire reason we're interested in free-standing RIAs is for the PDA. -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMAIL acting funny on CF 4.5
We're running CF4.5 (latest service pack as far as I can tell) and we keep having a weird problem.If one of our pages generates a CFMail that has a blank to address, for some reason ColdFusion generates many copies of that mail (50K+). Has anyone come across this and knows how to fix it? Russ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JOIN help
What I need is to select User 1 and ALL Queues so I get a result like this: UserID QueueID AccessID 12 0 11 NULL You could use an intermediate or temp table to return your desired result set like this: /* create temp table with one row for each queueid for each userid */ select u.id as userid, q.id as queueid into #t1 from users u, queues q GO /* this will provide the result you described */ select #t1.*, uq.accessid from #t1 left outer join userqueues uq on #t1.userid=uq.userid and #t1.queueid=uq.queueid order by #t1.userid, #t1.queueid GO drop table #t1 GO There are probably other, better ways to do this but I hope this may help you. Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Looping through a query in cfscript
Hello I need to loop over a query in cfscript. I notice when I cfdump the query there is a record number in the left hand column, how would I loop using this as the identifier? I usually use cfloop but this is in the middle of a cfscript block :) Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping through a query in cfscript
myQuery.myColumn[recordNumber] Or myQuery[myColumnVar][recordNumber] -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Saturday, November 15, 2003 1:43 PM To: CF-Talk Subject: Looping through a query in cfscript Hello I need to loop over a query in cfscript. I notice when I cfdump the query there is a record number in the left hand column, how would I loop using this as the identifier? I usually use cfloop but this is in the middle of a cfscript block :) Thanks, Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looping through a query in cfscript
What I've always done is loop through the query like a structure of arrays:
for (i = 1; i = query.recordcount; i = i + 1)
{
do_something_with(query.column[i]);
}
HTH.
--Ben Doom
Ryan Mitchell wrote:
Hello
I need to loop over a query in cfscript.
I notice when I cfdump the query there is a record number in the left hand
column, how would I loop using this as the identifier? I usually use cfloop
but this is in the middle of a cfscript block :)
Thanks,
Ryan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Looping through a query in cfscript
Thanks :)
Spot on
On 15/11/03 6:55 pm, Ben Doom [EMAIL PROTECTED] wrote:
What I've always done is loop through the query like a structure of arrays:
for (i = 1; i = query.recordcount; i = i + 1)
{
do_something_with(query.column[i]);
}
HTH.
--Ben Doom
Ryan Mitchell wrote:
Hello
I need to loop over a query in cfscript.
I notice when I cfdump the query there is a record number in the left hand
column, how would I loop using this as the identifier? I usually use cfloop
but this is in the middle of a cfscript block :)
Thanks,
Ryan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CF Webservice Flash MX
Is it possible to for example have a Flash client talk to a CF Webservice (yes) and have the CF Webservice talk back to multiple Flash MX clients (?) Example; [Flash client 1] (send data) - [Web Service] [Web Service] (sends data) - [Flash client 2] and [Flash client 3] and [Flash client 4] and [Flash client etc.] If it's possible can anyone provide any links to tutorials, code samples etc.? (I can think of some things that would be problematic i.e. proxies) TIA Taco Fleur 0421 851 786 Tell me and I will forget Show me and I will remember Teach me and I will learn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Webservice Flash MX
Taco Fleur wrote: Is it possible to for example have a Flash client talk to a CF Webservice (yes) and have the CF Webservice talk back to multiple Flash MX clients (?) Example; [Flash client 1] (send data) - [Web Service] [Web Service] (sends data) - [Flash client 2] and [Flash client 3] and [Flash client 4] and [Flash client etc.] If you mean that the Web Service pushes the data back: no. FlashComm can do this. Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Webservice Flash MX
Flashcom and remote shared objects can do this...I've requested that particularly functionality in the next cfmx. Here's hopin...maybe Royale will support it, don't know. Stace _ From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: November 15, 2003 4:23 PM To: CF-Talk Subject: CF Webservice Flash MX Is it possible to for example have a Flash client talk to a CF Webservice (yes) and have the CF Webservice talk back to multiple Flash MX clients (?) Example; [Flash client 1] (send data) - [Web Service] [Web Service] (sends data) - [Flash client 2] and [Flash client 3] and [Flash client 4] and [Flash client etc.] If it's possible can anyone provide any links to tutorials, code samples etc.? (I can think of some things that would be problematic i.e. proxies) TIA Taco Fleur 0421 851 786 Tell me and I will forget Show me and I will remember Teach me and I will learn _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:TOP 3 Most Recent Records
What about if you want the Top 3 Most Recent Records that you're consuming from an XML stream via CFHTTP? Sifu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFQUERYPARAM bug?
but shouldn't the carriage return and tab preceding the AND be honored as spaces? - j james curran technical director nylon technology mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 212-691-1134 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 5:53 PM To: CF-Talk Subject: RE: CFQUERYPARAM bug? I'd wager that syntactically you would be stringing your variables together with your keywords as in WHERE the_id=?AND the_other_id=? no space between the q-mark and the AND.keywords are always delimited by spaces. When the driver does the prepare task it sees a bind placeholder abutting a keyword and throws an error. -Mark -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 4:31 PM To: CF-Talk Subject: CFQUERYPARAM bug? Hey All, Just figured i'd see if anyone else has insight on this: Using 6.1 and MSSQL Server CFQUERY SELECT * FROM table WHERE the_id = cfqueryparam value=#the_ID# cfsqltype=CF_SQL_INTEGER AND the_other_id = cfqueryparam value=#the_other_ID# cfsqltype=CF_SQL_INTEGER /CFQUERY If i have *no* space after the first queryparam and before the return, I get an invalid datatype conversion Seems as if the cfqueryparam does not apply spacing and the carrage return and tab characters are lost preceding the AND... It's simple to prevent... But wanted to see if I should post this to MACR or let it be.. - j james curran technical director nylon technology [EMAIL PROTECTED] 212-691-1134 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFMX 6.0 on Red Hat ES 3.0 install errors
Hello, I tried installing CFMX 6.1 and it worked fine. Thanks to all who responded :) Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Need ASP to CF5 Developer
Is there someone who might be interested in some work for pay to convert one page of ASP to CF5? If so, please reply to: [EMAIL PROTECTED] Thank you, Aftershock Web Design, LLC Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Need ASP to CF5 Developer
Thank you to all who have responded! I'll be in touch with you. Stan Is there someone who might be interested in some work for pay to convert one page of ASP to CF5? If so, please reply to: [EMAIL PROTECTED] Thank you, Aftershock Web Design, LLC Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
