Re: CSS Editor (Good CSS Developer)
Valid CSS isn't exactly cross browser. - Original Message - From: Jim Davis <[EMAIL PROTECTED]> Date: Fri, 17 Sep 2004 12:41:53 -0400 Subject: RE: CSS Editor (Good CSS Developer) To: CF-Talk <[EMAIL PROTECTED]> Better yet you could hire me and I'll use the W3C CSS Validation service. ;^) Jim Davis _ From: Rebecca Wells [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 12:21 PM To: CF-Talk Subject: Re: CSS Editor (Good CSS Developer) You could use the W3C CSS Validation Service: http://jigsaw.w3.org/css-validator/ >>> Dwayne Cole" <[EMAIL PROTECTED]> 9/17/2004 06:36:05 AM >>> TopStyle seems to perform better than StyleMaster but Stylemaster seems to provide better window into the HTML impact of your CSS. I'm looking for a company that can take my style sheets and either 1). Make sure that they are cross-browser compatible or 2). Generate a version of the style sheet for IE on Mac and PC, Monzilla, etc. If you know of anyone please let me know. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: any good weather Web service?
On Fri, 17 Sep 2004 20:02:46 -0400, Claude Schneegans <[EMAIL PROTECTED]> wrote: > Thanks. > > >>but it has no forecast like EJSE's. > > Actually, I'm more interested in by frequend measures of actual conditions than in forecast. Would this not be country specific? I can not find the beginning of this thread, but for Canada, to obtain that information, I would go visit the Environment Canada website and see if they have the required web services. They are the ones responsible for those kinds of readings. For actually readings, you could always try looking out the window and recording what you see? :-) -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ON CASCADING DELETE
On Fri, 17 Sep 2004 13:40:52 -0400, daniel kessler <[EMAIL PROTECTED]> wrote: > I would like to use this in my tables to delete any referenced information. I have a poll table with a pollComments table. When I delete a poll, I want the comments related to it to delete also. The create table works until I add the ON CASCADING DELETE. Here are the two tables, any thoughts?: > > create table fsnep_polls ( > p_id NUMBER Primary Key, > p_date_added date, > p_date_last_used date, > p_question VARCHAR2(400), > p_status NUMBER > ) > > create table fsnep_pollComments ( > pc_id NUMBER Primary Key, > pc_date_added date, > pc_poll_id NUMBER REFERENCES fsnep_polls(p_id), > pc_comment VARCHAR2(3000), > pc_ip VARCHAR2(20) > ON DELETE CASCADE > ) You have not stated what RDBMS you are using so how are we suppose to help with the syntax or even know if your DBMS of choice even supports Cascading deletes? In addition, nowhere do I see where you have stated what the ON DELETE CASCADE is suppose to belong to. Usually you would link this to a foreign key by either placing it on the same line as the REFERENCES statement or including the key similar to ON DELETE CASCADE (pc_poll_id). -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Daily Server re-start with MX 6.1
I don't have any of these. I'm running the server config of CF. Is this problem only related to the JRun install of CF? From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Saturday, September 18, 2004 5:30 PM To: CF-Talk Subject: Re: Daily Server re-start with MX 6.1 Hi Paul. You may just simply have not noticed as the server does recover itself. Open up the 'Event Viewer' under 'Administrative Tools' and look in the application log and see if there are any entries with the 'Source' of 'Application Error'. If there is open up the details for that event and see if it says: "Faulting application jrun.exe, version 4.0.3.10455, faulting module jvm.dll, version 0.0.0.0, fault address 0x00156e55." If it does then you have the problem as well. Our last entry was today at 16:38 GMT and prior to that was yesterday at 23:18 GMT. It appears to be completely random, but if you don't have the problem that I would consider yourself very lucky as I know many people with this problem. Andrew. - Original Message - From: Paul Vernon <[EMAIL PROTECTED]> Date: Sat, 18 Sep 2004 23:14:43 +0100 Subject: RE: Daily Server re-start with MX 6.1 To: CF-Talk <[EMAIL PROTECTED]> I have run CFMX 6.1 on our Win2003 server for months and have never experienced a restart of services that I didn't instantiate. Pre or post updaters/patches/hotfixes... Am I to consider myself lucky? Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Daily Server re-start with MX 6.1
Andrew, If there is one thing I do its check the logs... religiously... Both Event logs and CF logs don't show anything like I read on the MM forum link you posted earlier and nothing like what you just described... never.. not even once... In this case I would hazard a guess that it isn't either ColdFusion or Windows 2003 per se but is quite possibly a registry setting or system hack or difference in services running or some other factor that differs between the machines Out of interest, we are running on a dual Xeon DELL 2650 with 1Gb ram and 70Gb of RAID 5 drives. We host about 60 sites on that server as it is relatively new and we are responsible for all the CF code that runs. Only one CFX tag that we have is not ours and that is Ben Fortas CFX_SPELL (great tag btw). Performance wise the server is handling a modest 3/4 million page impressions a month and really isn't getting out of bed at that... 50% memory free, 80% drive space free. When I configured the server I went through all the MS best practice documents then turned off all the other unnecessary services too. CF was tightened up quite a bit but the JVM settings have never been touched... I did also go through all the TCP/IP hardening papers on the MS site etc turning on SYN attack protection etc. The server only gets a reboot when patches/hotfixes require it and there are no service entries for any of the running services stopping unexpectedly. If you want to check what services you have running against what I have running mail me offlist as it may be that your JVM is clashing with something that I don't have... CFMX 6.1.0.83762 Standard Windows 2003 Standard Edition fully patched Sun JVM 1.4.2 Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Daily Server re-start with MX 6.1
Hi Paul. You may just simply have not noticed as the server does recover itself. Open up the 'Event Viewer' under 'Administrative Tools' and look in the application log and see if there are any entries with the 'Source' of 'Application Error'. If there is open up the details for that event and see if it says: "Faulting application jrun.exe, version 4.0.3.10455, faulting module jvm.dll, version 0.0.0.0, fault address 0x00156e55." If it does then you have the problem as well. Our last entry was today at 16:38 GMT and prior to that was yesterday at 23:18 GMT. It appears to be completely random, but if you don't have the problem that I would consider yourself very lucky as I know many people with this problem. Andrew. - Original Message - From: Paul Vernon <[EMAIL PROTECTED]> Date: Sat, 18 Sep 2004 23:14:43 +0100 Subject: RE: Daily Server re-start with MX 6.1 To: CF-Talk <[EMAIL PROTECTED]> I have run CFMX 6.1 on our Win2003 server for months and have never experienced a restart of services that I didn't instantiate. Pre or post updaters/patches/hotfixes... Am I to consider myself lucky? Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Ann: CFX_POP3 Pro Bayesian filtering
Hi All, Just a quick note to all those who need a hand dealing with SPAM in their Cold Fusion Apps on Windows :) ... I've just released a new version of CFX_POP3 Pro which includes whitelist and bayesian scoring capabilities. It can be bought for a modest amount at http://store.newmediadevelopment.net/cfdevelopment.cfm. If you're interested and would like to read more, the PDF docs are available at http://store.newmediadevelopment.net/documentation.cfm. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Daily Server re-start with MX 6.1
I have run CFMX 6.1 on our Win2003 server for months and have never experienced a restart of services that I didn't instantiate. Pre or post updaters/patches/hotfixes... Am I to consider myself lucky? Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Daily Server re-start with MX 6.1
That is probably why then. There is a problem with CFMX on Windows 2003 where the server service crashes and restarts itself at random. It happens on our 2003 server about 1 - 3 times a day and there appears to be nothing you can do about it. See the following CF Forum post. http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=2&threadid=785970 Although someone marked my post as the answer, it only helps reduce the frequency of the problem and doesn't get rid of it all together. Sorry it doesn't really help. Andrew. - Original Message - From: Andrew Grosset <[EMAIL PROTECTED]> Date: Sat, 18 Sep 2004 17:28:54 -0400 Subject: Re: Daily Server re-start with MX 6.1 To: CF-Talk <[EMAIL PROTECTED]> Windows 2003 version 5.2, I'm not sure what you mean by "basic"? >Do you know if it is basic on a Windows 2003 Server? > >Andrew. > > __ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Daily Server re-start with MX 6.1
Windows 2003 version 5.2, I'm not sure what you mean by "basic"? >Do you know if it is basic on a Windows 2003 Server? > >Andrew. > > __ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: TeraTech Listening?
I am there today, whats up? I am home to go into work for the evening but will be back for sesison 2 tomorrow.. > -Original Message- > From: Phillip Beazley [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 18, 2004 1:16 PM > To: CF-Talk > Subject: TeraTech Listening? > > Howdy, all! > > Anyone know of a way to get ahold of someone at TeraTech at > the conference today? > > > -- > Phillip Beazley > Onvix -- Website Hosting, Development & E-commerce > Visit http://www.onvix.com/ or call 727-578-9600. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Daily Server re-start with MX 6.1
Do you know if it is basic on a Windows 2003 Server? Andrew. - Original Message - From: Andrew Grosset <[EMAIL PROTECTED]> Date: Sat, 18 Sep 2004 14:00:04 -0400 Subject: Daily Server re-start with MX 6.1 To: CF-Talk <[EMAIL PROTECTED]> I am on a shared host running MX6.1 and I hava had no problems accept the server seems to restart on a 1 to 2 day basis. I have access to the cfschedule tag so I have just set it up to call a template that checks the exisitance of an application variable once an hour, if it is not defined it resets the variable and emails me the fact. Is it normal with MX6.1 to regularily restart the server, if I was on a dedicated server (just me) and my code was perfect..:) would I need to restart on a regular basis? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Daily Server re-start with MX 6.1
I am on a shared host running MX6.1 and I hava had no problems accept the server seems to restart on a 1 to 2 day basis. I have access to the cfschedule tag so I have just set it up to call a template that checks the exisitance of an application variable once an hour, if it is not defined it resets the variable and emails me the fact. Is it normal with MX6.1 to regularily restart the server, if I was on a dedicated server (just me) and my code was perfect..:) would I need to restart on a regular basis? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
TeraTech Listening?
Howdy, all! Anyone know of a way to get ahold of someone at TeraTech at the conference today? -- Phillip Beazley Onvix -- Website Hosting, Development & E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: any good weather Web service?
It looks like someone else had this problem recently. http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid= 7&threadid=861645 I tried it with both CFINVOKE and CreateObject() and I get the same result. Claude, can you post back if you get it to work? This is what I just tried and it fails on the remote method call. "http://www.nws.noaa.gov/forecasts/xml/DWMLgen/wsdl/ndfdXML.wsdl")> label="variables.webService"> "-77.", "time-series", "2004-04-27T12:00", "2004-04-30T12:00", variables.options)> Thanks From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Saturday, September 18, 2004 7:48 AM To: CF-Talk Subject: Re: OT: any good weather Web service? I haven't tried it yet, but the National Weather Service has some experimental XML/RSS feeds and a web service http://www.nws.noaa.gov/forecasts/xml/ - Rick Claude Schneegans wrote: > Can some one recommand a good Weather Web service? > the one I'm using in the CFX_mapDatat demo > ( > http://www.contentbox.com/claude/customtags/mapdata/USWeatherMaps.cfm?m= 5 ) > has never listed winds higher than 30 MPH during the passage of Ivan. > I don't know where they are taking their measures, in some sort of > anti-nuclear shelter or so, > but it is sure does not look too acurate ;-/ > > The Web service I'm using right know is > www.webservicex.net/globalweather.asmx > > -- > ___ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfheader question
I think you are on the right track with the JS. As far as I understand it, popup blockers don't block popups if they are created directly from a link (I could be wrong here). So this could do it:
function timedreload(inRes) {
win = window.open("index.cfm?pgid=download&resID=" +
inRes,"download","width=10,height=10,scrollbars=0,resizable=0");
setTimeout("window.location.reload();",6100);
setTimeout("win.close();",6000);
}
You have to assign the new window to a variable (win) in order to be able to close it later. Also, if you reload the page, it can't close the popup anymore. So you will have to close the popup first and then reload the page. I have tested none of this. Alternatively, you could just call the download page in the href and schedule a JS reload in the onclick >
function timedreload() {
setTimeout("window.location.reload();",3000);
}
This way you don't have a popup and the page still reloads. Pascal > -Original Message- > From: Steve Logan [mailto:[EMAIL PROTECTED] > Sent: 18 September 2004 15:41 > To: CF-Talk > Subject: [Spam?] cfheader question > > On a site that I'm working on, there's a lot of MS Word documents > available to download. Instead of letting IE open the document in a > window, I have a download.cfm page that uses cfheader to force the > document to download. > > Unfortunately, I can't figure out how to get the previous page that the > link was called from to reload, which updates the list of available > documents and removes the one that was just downloaded. > > What I need to get to happen is documents.cfm be automatilly refreshed / > reloaded after clicking on the link to start the download. > > I'm assuming there's now way to put anything else on the download.cfm page > just as _javascript_ or a cflocation that would force the documents.cfm page > to download because of the cfheader tag. > > The other method I'm working on is close - but uses _javascript_ to open a > window - which could cause problems with pop-up blockers. > > The link for the document to download is: > > > > > And then the _javascript_ is: > >
> function timedreload(inRes) {
> window.open("index.cfm?pgid=download&resID=" +
> inRes,"download","width=10,height=10,scrollbars=0,resizable=0");
> setTimeout("window.location.reload();",3000);
> setTimeout("window.close.download;",6000);
> }
> > > Problem here is that the download window doesn't want to close > automatically, and, it uses a pop-up which could cause problems with pop- > up blockers. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfquery still breaking apostrophies in CFMX 6.1 updater?
This is intended behavior: any CF string variable within a
will escape (double) single quotes. I think it has always been like this
(at least since CF4). This is implemented this way so you don't have to
worry about single quotes when you write something like:
...
WHERE column = '#myvar#'
This would throw an error if single quotes weren't escaped. This is
purely theoretical, because everybody uses , right? ;)
If you want to output an sql statement (like in your example) without
escaping single quotes, you have to wrap your variable with the
PreserveSingleQuotes() function.
Pascal
> -Original Message-
> From: Damien McKenna [mailto:[EMAIL PROTECTED]
> Sent: 17 September 2004 22:54
> To: CF-Talk
> Subject: [Spam?] cfquery still breaking apostrophies in CFMX 6.1
updater?
>
> I've just noticed that the CFQUERY fix for apostrophies from the CFMX
> 6.1 updater may not be fixed. I've got a query that does something
> along the line of "SELECT * FROM table_blah WHERE #from# #equal# #to#"
> where the #to# comes from SQL Server is something along the lines of
> ('N', 'n'). However, when I run it I get this:
>
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
> Microsoft Access Driver] Syntax error (missing operator) in query
> _expression_ 'DSMADST_RCN = DEIDSMD_RCN AND DSMASTS NOT IN ('X', 'T',
'Z',
> 'R', 'P') AND DSMAEML_ADR IS NOT NULL AND DSMAEML_ADR <> '' AND
> DSMAEML_ADR NOT LIKE '%*%' AND ( DSMAFLG1 NOT IN (''N'', ''n'') )'.
>
> Notice how it changed to (''N'', ''n'') from ('N', 'n')?
>
> So is could this be the old CFCATCH bug back again or is it something
> else?
>
> Any help would be appreciated.
> --
> *Damien McKenna* - Web Developer - [EMAIL PROTECTED]
>
> The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
> "Nothing endures but change." - Heraclitus
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: OT: any good weather Web service?
>>http://www.nws.noaa.gov/forecasts/xml/ Thanks, I'll try this one. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfquery still breaking apostrophies in CFMX 6.1 updater?
isn't that the common thing that PreserveSingleQuotes() is used for?
Doug
- Original Message -
From: Damien McKenna <[EMAIL PROTECTED]>
Date: Fri, 17 Sep 2004 16:54:06 -0400
Subject: cfquery still breaking apostrophies in CFMX 6.1 updater?
To: CF-Talk <[EMAIL PROTECTED]>
I've just noticed that the CFQUERY fix for apostrophies from the CFMX
6.1 updater may not be fixed. I've got a query that does something
along the line of "SELECT * FROM table_blah WHERE #from# #equal# #to#"
where the #to# comes from SQL Server is something along the lines of
('N', 'n'). However, when I run it I get this:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Syntax error (missing operator) in query
_expression_ 'DSMADST_RCN = DEIDSMD_RCN AND DSMASTS NOT IN ('X', 'T', 'Z',
'R', 'P') AND DSMAEML_ADR IS NOT NULL AND DSMAEML_ADR <> '' AND
DSMAEML_ADR NOT LIKE '%*%' AND ( DSMAFLG1 NOT IN (''N'', ''n'') )'.
Notice how it changed to (''N'', ''n'') from ('N', 'n')?
So is could this be the old CFCATCH bug back again or is it something else?
Any help would be appreciated.
--
*Damien McKenna* - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Nothing endures but change." - Heraclitus
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
cfheader question
On a site that I'm working on, there's a lot of MS Word documents available to download. Instead of letting IE open the document in a window, I have a download.cfm page that uses cfheader to force the document to download. Unfortunately, I can't figure out how to get the previous page that the link was called from to reload, which updates the list of available documents and removes the one that was just downloaded. For example: documents.cfm Link to document to download: index.cfm?pgid=download&resID=#res_id# download.cfm [some queries here to change status] What I need to get to happen is documents.cfm be automatilly refreshed / reloaded after clicking on the link to start the download. I'm assuming there's now way to put anything else on the download.cfm page just as _javascript_ or a cflocation that would force the documents.cfm page to download because of the cfheader tag. The other method I'm working on is close - but uses _javascript_ to open a window - which could cause problems with pop-up blockers. The link for the document to download is: And then the _javascript_ is:
function timedreload(inRes) {
window.open("index.cfm?pgid=download&resID=" + inRes,"download","width=10,height=10,scrollbars=0,resizable=0");
setTimeout("window.location.reload();",3000);
setTimeout("window.close.download;",6000);
}
Problem here is that the download window doesn't want to close automatically, and, it uses a pop-up which could cause problems with pop-up blockers. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: any good weather Web service?
I haven't tried it yet, but the National Weather Service has some experimental XML/RSS feeds and a web service http://www.nws.noaa.gov/forecasts/xml/ - Rick Claude Schneegans wrote: > Can some one recommand a good Weather Web service? > the one I'm using in the CFX_mapDatat demo > ( > http://www.contentbox.com/claude/customtags/mapdata/USWeatherMaps.cfm?m=5 ) > has never listed winds higher than 30 MPH during the passage of Ivan. > I don't know where they are taking their measures, in some sort of > anti-nuclear shelter or so, > but it is sure does not look too acurate ;-/ > > The Web service I'm using right know is > www.webservicex.net/globalweather.asmx > > -- > ___ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problems with Excelsheet in French from Coldfusion
Well I have made some progress with this I am using and lscurrencyformat Now the strange thing is when I view the html results everything looks fine for numbers under 1000 For example if I have a value 498,13$ when I export it to excel if display as a numeric value but if the number was higher let say add 1k to it. It would display as 1 498,13$ with a space for every thousand separator now when I export this to excel all the values that or greater than 999,99$ or (999,99$) download a character instead of the space and get formatted as text in excel as opposed to numbers. Any Ideas on how I can fix this? Thanks Mike - Original Message - From: Mickael To: CF-Talk Sent: Friday, September 17, 2004 10:02 AM Subject: Problems with Excelsheet in French from Coldfusion Hello, I am having an issue with an excel spreadsheet that I make with Coldfusion. The issue is with the dollar values in the sheet. When viewed with an English machine the values show up as currency in Excel which is good. But when viewed with a French Canadian machine the dollar values come out as text. This is preventing the users from adding any forumulas to the spread sheet or treating the values as a currency. Any Ideas on how I can correct this? Thanks in advance Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL grouping question
I think you can just omitt the actionID from your group by clause and you should be set. Both the cout and the sum are aggregates so only return 1 value, grouped by the values in the group by clause. HTH - Original Message - From: Russ <[EMAIL PROTECTED]> Date: Fri, 17 Sep 2004 22:20:28 -0400 Subject: SQL grouping question To: CF-Talk <[EMAIL PROTECTED]> Well maybe all you sql guru's can help me here.. Now I know I can do this with several queries, but is there a way to do this with one query? I have a several tables that when I join I get something like this userID userName actionID actionPoints now, lets say I want to group it so that I can get a count of actionID for each user. something like this select userID, userName, count(ActionID), sum(actionPoints) from sometable group by userID, userName, actionID This works pretty well, except it will give me the number of points per each actionID, but I want it per userID (while leaving the actionID count per actionID. Is there a way to do this in one query? I'm using MS SQL Server 2000. Russ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Script CodeSweeper
if anyone wants to try this thing u can dl it here http://www.jamwerx.com/open/ph370.zip -- Original Message -- From: "dave" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 17 Sep 2004 18:09:41 -0400 >theres a program out there called pretty html 3.7 which works wonders, maybe dead now though. sure wish someone would pick it up and redo it cause its really good!!! > >if anyone wants it i will upload it but i cant give u my code >maybe i will try and contact the guy to see if hes still doing it. > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
