RE: Online Presentations

2004-11-02 Thread Hugo Ahlenius
Hi, I know that partners of us have used Viewlet Builder for this purpose: http://www.qarbon.com/ -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8

Re: OT: editors, back to HomeSite+ for me

2004-11-02 Thread Thomas Chiverton
On Tuesday 02 Nov 2004 04:15 am, dave wrote: [quote]I'd argue that you shouldn't be desiging or working on the two halves (front end presentation, backend gubbins) at the same time, certainly in a project of any size or complexity.[/quote] thats not really true, if ur making forward

Re: OT: editors, back to HomeSite+ for me

2004-11-02 Thread dave
right then and there u dont but im assuming u want to actually dispaly the resulting data in somewhat or any kind of a viewable format [quote]com.bluefinger.mediator.getMeA()[/quote] looks pretty crappy on a screen by itself and 99.9% of the page viewers will have no idea what it even means,

Re: OT: editors, back to HomeSite+ for me

2004-11-02 Thread Thomas Chiverton
On Tuesday 02 Nov 2004 10:10 am, dave wrote: right then and there u dont but im assuming u want to actually dispaly the resulting data in somewhat or any kind of a viewable format I think you need to go and read up on MVC and similar separation of concern architectures. but i look at

Re: OT: editors, back to HomeSite+ for me

2004-11-02 Thread dave
i dont think u completely read what was say or only took to the parts u wanted to read. the guys said he didnt like eclipse cause he liked having the split view had nothing to do with backend only code same as what i am saying, i like dreamweaver cause i use both views where as eclipse doesnt

Re: CFMAILPARAM ending up in body, not header! Workaround???

2004-11-02 Thread Jochem van Dieten
Anders Green wrote: More precisely, the code causes the problem: CFIF Len(hashCashResult) NEQ 0 cfmailparam name = X-HashCash value = #hashCashResult# /CFIF cfmailparam name = Reply-To value = #organizer.email# cfmailparam name = X-RSVPID value = [#AccessCode#] cfmailparam name =

RE: Email Client Stats..?

2004-11-02 Thread Craig Dudley
It can't be measured in the same way as web browser use, so I guess most, if not all evidence is going to be anecdotal. -Original Message- From: David K [mailto:[EMAIL PROTECTED] Sent: 01 November 2004 20:24 To: CF-Talk Subject: Email Client Stats..? I'm looking for some usage stats

Re: SPAM-BULK: Forcing text to wrap in table cell

2004-11-02 Thread Bert Dawson
On Mon, 1 Nov 2004 16:50:53 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone have a simple solution? The simplest solution is not to worry about it, though without knowing more details i can't say whether this is an option. Who is going to be entering a big string with no whitespace?

Verity not installed?

2004-11-02 Thread Andrew Dixon
Hi Everyone. I have just installed a new system with CFMX6.1 on a Linux (done it lots of time before) and it all installed ok. I then started to do some configuration for my application in CF Admin and when I got to the bit to set up Verity collections I clicked the 'Verity Collections' click on

Re: SPAM-BULK: Forcing text to wrap in table cell

2004-11-02 Thread Mark Drew
I like your attitude mr Dawson On Tue, 2 Nov 2004 11:17:05 +, Bert Dawson [EMAIL PROTECTED] wrote: On Mon, 1 Nov 2004 16:50:53 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone have a simple solution? The simplest solution is not to worry about it, though without knowing more

RE: SPAM-BULK: Forcing text to wrap in table cell

2004-11-02 Thread Hugo Ahlenius
|-Original Message- |From: Bert Dawson [mailto:[EMAIL PROTECTED] |The simplest solution is not to worry about it, though without |knowing more details i can't say whether this is an option. |Who is going to be entering a big string with no whitespace? A URL is a common case for that:

Re: SPAM-BULK: Forcing text to wrap in table cell

2004-11-02 Thread Stephen Moretti (cfmaster)
Hugo Ahlenius wrote: |-Original Message- |From: Bert Dawson [mailto:[EMAIL PROTECTED] |The simplest solution is not to worry about it, though without |knowing more details i can't say whether this is an option. |Who is going to be entering a big string with no whitespace? A URL is a

Urgent:coldfusion loging

2004-11-02 Thread vishnu prasad
Hi CF gurus Is it possible to backup all the coldfusion mx logs to some other directory and then delete the orginal file i mean i want to move all the coldfusion mx log file to another directory ,so that coldfusion log fill will have only the current date log detail thanks in advance regards

Re: Urgent:coldfusion loging

2004-11-02 Thread Stephen Moretti (cfmaster)
vishnu prasad wrote: Hi CF gurus Is it possible to backup all the coldfusion mx logs to some other directory and then delete the orginal file i mean i want to move all the coldfusion mx log file to another directory ,so that coldfusion log fill will have only the current date log detail

Data Migration Suggestion

2004-11-02 Thread C. Hatton Humphrey
I'm working out the logistics of moving a site to a new server and need some advice. The current server is going to stay active and has a MS Access datasource (outside of my control) that my application reads from. I need to be able to replicate this data into a MySQL database on a scheduled

Re: Urgent:coldfusion loging

2004-11-02 Thread JT News
Yep, this is possible...Just archive through the CFAdmin (the archive icon). Or, go to the directory and move the files to the directory of your choosing. -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS

Re: Verity not installed?

2004-11-02 Thread JT News
What version/distro of Linux are you on? have you patched your CFMX 6.1 with the fixes for verity? -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server!

Re: Verity not installed?

2004-11-02 Thread Andrew Dixon
We are using Fedora Core 2 (which I know is not official supported) but we have other machine and it worked out of the box. Andrew. On Tue, 2 Nov 2004 07:53:06 -0500, JT News [EMAIL PROTECTED] wrote: What version/distro of Linux are you on? have you patched your CFMX 6.1 with the fixes for

Re: Online Presentations

2004-11-02 Thread JT News
WebEx, Oracle Collaboration Suite, Microsoft has one too... -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server! ~| Purchase

Re: Problem with Session Variables timing out

2004-11-02 Thread Doug James
The value set in CF Admin is the maximum time a session variable will be alive. If you need 60 minute session, you have to set CF Admin to 60 min and cfapplication to 60 min. Doug Larry White wrote: There's also a maximum allowed session timeout inn CF admib, besides the default value.

Re: includes and cfc's

2004-11-02 Thread JT News
Thanks for the resources! I spent a good deal of time yesterday looking at the docs and example apps at mach-ii.com I'll let you all know how it goes. -Josh -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including

RE: Urgent:coldfusion loging

2004-11-02 Thread Calvin Ward
Yes, just move the files, CF will create new ones for you. -Calvin -Original Message- From: vishnu prasad Date: 11/2/04 5:28 am To: CF-Talk Subj: Urgent:coldfusion loging Hi CF gurus Is it possible to backup all the coldfusion mx logs to some other directory and then delete the

Re: Verity not installed?

2004-11-02 Thread JT News
I have CFMX 6.1 on FC2 at my office...I will try to recreate this issue (haven't done any verity on it yet). Unfortunately gmail is blocked on the network there, so I won't be able to post any further on this for a bit. I will let you know ASAP though... I do have CFMX 6.1 on RHEL3 using Verity

RE: Verity not installed?

2004-11-02 Thread Dave Wilson
I have just installed a new system with CFMX6.1 on a Linux (done it lots of time before) and it all installed ok. I then started to do some configuration for my application in CF Admin and when I got to the bit to set up Verity collections I clicked the 'Verity Collections' click on the right

Re: Urgent:coldfusion loging

2004-11-02 Thread vishnu prasad
Hi i want to do this from the coldfusion code rather than doing it manullay or from the administrator screen. I tried it from the code from but I am able to move the application and server log. Hi CF gurus Is it possible to backup all the coldfusion mx logs to some other directory and

Any news from MAX?

2004-11-02 Thread JT News
Anybody at max got any good stuff to share? Anyone know of any bloggers giving updates? Thanks! -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server!

Re: Urgent:coldfusion loging

2004-11-02 Thread vishnu prasad
Hi Its throws an erorr when it moving the server.log ,exception.log and application.log Yes, just move the files, CF will create new ones for you. -Calvin -Original Message- From: vishnu prasad Date: 11/2/04 5:28 am To: CF-Talk Subj: Urgent:coldfusion loging Hi CF

Word 2003 and CF 5

2004-11-02 Thread Jason Reichenbach
Has anyone used CF5 to access MS Word 2003 objects? All was fine with 2000, but now none of the properties seem to work. The following example results in the Range, Close and Count properties/methods not being found: CFOBJECT TYPE=COM NAME=objWord CLASS=Word.Application ACTION=Create

Re: Any news from MAX?

2004-11-02 Thread John Beynon
www.maxbloggers.com jb. On Tue, 2 Nov 2004 08:08:30 -0500, JT News [EMAIL PROTECTED] wrote: Anybody at max got any good stuff to share? Anyone know of any bloggers giving updates? Thanks! -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!*

Re: Online Presentations

2004-11-02 Thread Paul Giesenhagen
Looking for LIVE demonstrations Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Hugo Ahlenius [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 2:52 AM Subject: RE: Online Presentations Hi, I know that

Session Management

2004-11-02 Thread Chad McCue
I am looking for a tag or script that will allow a user to continue their session when it has expired due to their lack of using the site. I have looked at cfdev.com and checked out theirs, but it doesn't seem to work very well. Thanks

SPAM-BULK: RE:Forcing text to wrap in table cell

2004-11-02 Thread djones
this is cool but it doesnt wrap the text -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 11:35 PM To: CF-Talk Subject: SPAM-BULK: Re: SPAM-BULK: Forcing text to wrap in table cell Importance: Low Add the following to your table

RE: Online Presentations

2004-11-02 Thread Ryan Duckworth
Flash com server w/ flash remoting, ColdFusion, and using Macromedia's RoboDemo to create the presentation. Tom Muck has a great Flash Remoting book out right now. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913)

RE: SPAM-BULK: Forcing text to wrap in table cell

2004-11-02 Thread djones
Well I would love to not worry about it. If there is no good solution then I wont but I will at least try. I need to do something, the best solutions would be to be able to force a wrap. Otherwise I will just put a space after every 28th character in a long string. Thanks, David

RE: SPAM-BULK: RE:Forcing text to wrap in table cell

2004-11-02 Thread Jason Reichenbach
Set a table width then set a fixed width in the first row ie: Table width=650 tr td width=25/td td width=625/td /tr -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 10:12 AM To: CF-Talk Subject: SPAM-BULK: RE:Forcing text to wrap in

OT: Need Javascript Help

2004-11-02 Thread Phillip Perry
Hi, I need some advice about javascript. Could someone contact me offline to discuss it? Thanks. PHil ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.

RE: Online Presentations

2004-11-02 Thread Hugo Ahlenius
How about VNC using http (the others can just listen) -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax:

Re: SPAM-BULK: RE:Forcing text to wrap in table cell

2004-11-02 Thread Bryan Stevenson
Still doesn't fix the problem if the string is long with no spaces ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original

OT: Sql insert from one db to another

2004-11-02 Thread Rodger
I can use an INSERT to copy the data from one table to another like: INSERT empinfoEmployeesTemp (EmployeeNum, FirstName, LastName) (SELECT EmployeeNum, FirstName, LastName FROM empinfoEmployees) But I need to copy the data from different databases (production to dev). I am copying from

Re: SPAM-BULK: RE:Forcing text to wrap in table cell

2004-11-02 Thread Anders Green
Marius Milosav wrote: table style=table-layout: fixed Bryan Stevenson wrote this is cool but it doesnt wrap the text Jason Reichenbach wrote Set a table width then set a fixed width in the first row ie: Bryan Stevenson wrote: Still doesn't fix the problem if the string is long with no

Re: SPAM-BULK: RE:Forcing text to wrap in table cell

2004-11-02 Thread Bryan Stevenson
Ummm...Anders...think ya got lost there...ain't my problem...somebody else started this bad boy ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web:

RE: Forcing text to wrap in table cell

2004-11-02 Thread djones
I will just insert a space after every 28th character in words longer that 28 characters. Thank you all, David -Original Message- From: Anders Green [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 11:09 AM To: CF-Talk Subject: Re: SPAM-BULK: RE:Forcing text to wrap in table

Re: SPAM-BULK: RE:Forcing text to wrap in table cell

2004-11-02 Thread Lawrence Ng
just thinking out loud here... another option is put the string in variable and do a check on string length... if it exceeds it, then do a wrap. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support

Re: OT: Sql insert from one db to another

2004-11-02 Thread jjakim
INSERT INTO tableName (field1, field2) SELECT field1,field2 FROM DatabaseName.dbo.TableName ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.

Still hunting for Newsletter system...

2004-11-02 Thread Bailey, Neal
Hello all... Well I am still on the Hunt for a good eNewsletter Application. I have found several that will do the job but the one big problem I keep running into is the pricing and reporting. We have over 1.7 million emails and growing and we need to port from our current newsletter system to a

SOT: Javascript Type Ahead Script

2004-11-02 Thread Deanna Schneider
I'm working on an index like in those Microsoft products - where a series of topics are listed and when you type you find the one you're looking for. I've found a type ahead javascript that nearly does everything I want. But, it chokes on spaces. I've looked at it and so has my colleague, and

Re: SPAM-BULK: RE:Forcing text to wrap in table cell

2004-11-02 Thread Anders Green
At 11:11 AM 11/2/2004, Bryan Stevenson wrote: Ummm...Anders...think ya got lost there... Yeah, that happens. :) ain't my problem... And aren't you glad! *grin* From: Lawrence Ng [EMAIL PROTECTED] another option is put the string in variable and do a check on string length... if it exceeds it,

RE: Sql insert from one db to another

2004-11-02 Thread Eric Creese
you need to put the path and make sure link server seting is set up. like the following from the production database SQL query analyzer prompt INSERT empinfoEmployeesTemp (EmployeeNum, FirstName, LastName) (SELECT EmployeeNum, FirstName, LastName FROM

Re: Logging all users actions...

2004-11-02 Thread Matt Robertson
I wrote my own after not liking the limitations of CFLog. I have a project where the client, a government agency, requires *detail* in spades. Stuff like this can take up a LOT of space. You will need a clbo/ntext/longtext field to store it all and be sure of no problems. I generate a table in

Re: OT: Sql Server 2005 Express

2004-11-02 Thread Matt Robertson
Why? Because there's no gui yet? I'm setting up a new server this weekend and am planning on plugging in and playing with MSDE, which apparently has a GUI now and does not have the single-processor limit. I have MSDE running elsewhere but as something plugged in by a 3rd-party app (LiveStats).

OT: Altova have a free XML editor!

2004-11-02 Thread Damien McKenna
I went looking for a free XML editor and discovered that Altova have a free version of XML Spy available! Neato! http://www.altova.com/download_spy_home.html to download it. http://www.altova.com/support_freexmlspyhome.asp to obtain a key. They also have an XML content editor (I'm going to

Split ouptut to MULTIPLIE sheets in Excel.

2004-11-02 Thread Jonathan Nickle
I have some reports that have a requirement of being in Excel format. However, the returned datasets have the ability to be more than 65,000 records. Instead of creating multipe files, does anyone know of a way to format the data to automatically split this data to multiple sheets?

RE: Forcing text to wrap in table cell

2004-11-02 Thread djones
Well if the longest word in the English language is 28 chars... Then I will just insert a space after every 28th char in all strings(words) longer that 28 chars The test will wrap naturally. It wont matter about font sizes. David -Original Message- From: Thomas Chiverton [mailto:[EMAIL

Re: OT: Sql Server 2005 Express

2004-11-02 Thread Adam Haskell
No GUI is part of it but I couldn't connect to it and I found a work around and didn't feel like messing with it. So I scrapped it :) On Tue, 2 Nov 2004 08:44:00 -0800, Matt Robertson [EMAIL PROTECTED] wrote: Why? Because there's no gui yet? I'm setting up a new server this weekend and am

SQL for Access Help Needed

2004-11-02 Thread Donna French
I'm working on a small app using CFMX and an Access db having trouble with some SQL that I believe should work. Here's the code: SELECT * FROM Clients WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004' It started as a much larger query but I've taken bit by bit away and this is

RE: SQL for Access Help Needed

2004-11-02 Thread Tangorre, Michael
SELECT * FROM Clients WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004' WHERE Client_IntakeDate = '10/1/2004' AND Client_IntakeDate = '10/31/2004' I don't use access so I am not sure which operators are available... But give the above a shot. Mike

RE: SQL for Access Help Needed

2004-11-02 Thread Gaulin, Mark
What's the problem? Is it that records on 10/31 are not being returned? If so, it could be that the field is actually a date time field, and 10/31/2004 is 10/31/2004 00:00, and you may want to use 11/1/2004 as the upper bound. Or not. Mark -Original Message- From: Donna

Re: SQL for Access Help Needed

2004-11-02 Thread Ron Gowen
I believe the qoutes should not be used in access..Use cfqueryparam On Tue, 2 Nov 2004 13:08:40 -0500, Gaulin, Mark [EMAIL PROTECTED] wrote: What's the problem? Is it that records on 10/31 are not being returned? If so, it could be that the field is actually a date time field, and

mod command to alter row color

2004-11-02 Thread Robert Orlini
I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? Thanks. Robert O. ~| Purchase from House of Fusion, a Macromedia Authorized

Re: Altova have a free XML editor!

2004-11-02 Thread Adam Churvis
Yeah, we use XMLSpy Home Edition in our ColdFusion MX Master Class to teach the XML portions of the class, and it's really useful for basic XML work, too. We also license another useful XML product called Xselerator, which we use for our actual production work. Also worth a look if your budget's

Re: Split ouptut to MULTIPLIE sheets in Excel.

2004-11-02 Thread Bob Clingan
If you are using a fairly recent version of Excel, you can format your data as XML and Excel can read that in. Create a dummy file in Excel and export it as XML for the syntax. I have some reports that have a requirement of being in Excel format. However, the returned datasets have the

Re: mod command to alter row color

2004-11-02 Thread jonese
put this in your tr tag cfif query.CurrentRow MOD 2 EQ 0bgcolor=##00cfelsebgcolor=##f/cfif it think that's right. On Tue, 2 Nov 2004 13:24:19 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I know this is an easy one, but can't find the right code. How do I have CF alternate color

Mach II

2004-11-02 Thread Bob Clingan
I'm curious who is using Mach-II... Documentation and examples seems to be very minimal. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.

RE: mod command to alter row color

2004-11-02 Thread Tangorre, Michael
From: Robert Orlini [mailto:[EMAIL PROTECTED] I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? cfif queryName.CurrentRow MOD 2 EQ 0 Red cfelse Blue /cfif Mike

Re: mod command to alter row color

2004-11-02 Thread Jim McAtee
I generally start by setting up two CSS classes, with similar names ending in 0/1. style type=text/css tr.rowstyle1 { background-color: #ff; } tr.rowstyle0 { background-color: #e0e0e0; } /style cfoutput cfloop query=somequery tr class=rowstyle#Evaluate('somequery.currentrow mod

RE: Mach II

2004-11-02 Thread Tangorre, Michael
From: Bob Clingan [mailto:[EMAIL PROTECTED] I'm curious who is using Mach-II... Documentation and examples seems to be very minimal. There is a MACH-II list over at topica that is pretty active. Also, check out Sean Corfield's blog (www.corfield.org) as he is VERY involved with it. Mike

Re: SQL for Access Help Needed

2004-11-02 Thread Donna French
Here's the error I'm getting: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The Error Occurred in C:\Documents and Settings\Lanes\My Documents\filelib\wdv\reportingTest.cfm:

Re: Mach II

2004-11-02 Thread Chad McCue
I use it for all our applications, e-commerce, template sites. Works awsome. check out www.mach-ii.com - Original Message - From: Bob Clingan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 12:38 PM Subject: Mach II I'm curious who is using Mach-II...

Re: SQL for Access Help Needed

2004-11-02 Thread Donna French
No, it doesn't work Mike, had already tried that too. On Tue, 2 Nov 2004 13:10:07 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: SELECT * FROM Clients WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004' WHERE Client_IntakeDate = '10/1/2004' AND

Re: mod command to alter row color

2004-11-02 Thread Al Everett
--- Robert Orlini [EMAIL PROTECTED] wrote: How do I have CF alternate color for each row of a table? Anyone have the code please? I wrote a UDF to do just that. http://cflib.org/udf.cfm?ID=901 On of its perks is that you're not limited to two colors. You can put as many into the list of

Re: SQL for Access Help Needed

2004-11-02 Thread Ron Gowen
datatype mismatch..means access is not regonizing your values as dates cfqueryparam should solve that. On Tue, 2 Nov 2004 12:46:12 -0600, Donna French [EMAIL PROTECTED] wrote: Here's the error I'm getting: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC

Re: Split ouptut to MULTIPLIE sheets in Excel.

2004-11-02 Thread Rob
If you dont fear java, the jxl.jar (java excel api) is awesome. I have used it a couple of times, and I have used it with great success in cf http://www.andykhan.com/ On Tue, 02 Nov 2004 11:50:44 -0400, Jonathan Nickle [EMAIL PROTECTED] wrote: I have some reports that have a requirement of

Re: mod command to alter row color

2004-11-02 Thread Barney Boisvert
Get rid of that evaluate, it's unneeded: style tr.alt1 { background-color: #fff; } tr.alt0 { background-color: #ffc; } /style cfoutput table cfloop query=myQuery tr class=alt#currentRow MOD 2# ... /tr /cfloop /table /cfoutput On Tue, 2 Nov 2004 11:42:55 -0700, Jim McAtee [EMAIL

Re: SQL for Access Help Needed

2004-11-02 Thread Donna French
Well, I changed the query to this: SELECT * FROM Clients WHERE Client_IntakeDate = 10/1/2004 AND Client_IntakeDate = 10/31/2004; and I'm getting an error but I'm not getting any data results either. What the ??? ~ Donna On Tue, 2 Nov 2004 12:49:56 -0600, Donna French [EMAIL

Re: Session Management

2004-11-02 Thread Chad McCue
I am looking for a tag or script that will allow a user to continue their session when it has expired due to their lack of using the site. I have looked at cfdev.com and checked out theirs, but it doesn't seem to work very well. Thanks - Original Message - From: Chad McCue [EMAIL

RE: SQL for Access Help Needed

2004-11-02 Thread Tangorre, Michael
From: Donna French [mailto:[EMAIL PROTECTED] No, it doesn't work Mike, had already tried that too. How about... WHERE Client_IntakeDate = cfqueryparam cfsqltype=CF_SQL_DATE null=No value=CreateODBCDate('10/01/2004') AND Client_IntakeDate =

Re: SQL for Access Help Needed

2004-11-02 Thread Dave Jones
Access needs # to delimit date fields (SQL Server uses squotes) Dave Jones NetEffect At 10:01 AM 11/2/04, you wrote: I'm working on a small app using CFMX and an Access db having trouble with some SQL that I believe should work. Here's the code: SELECT * FROM Clients WHERE Client_IntakeDate

Re: SQL for Access Help Needed

2004-11-02 Thread Donna French
Thanks Ron, It's working now using the following code: SELECT * FROM Clients WHERE Client_IntakeDate = cfqueryparam value=10/1/2004 cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=10/31/2004 cfsqltype=cf_sql_date; On Tue, 2 Nov 2004 12:56:42 -0600, Donna

Re: mod command to alter row color

2004-11-02 Thread Jim McAtee
It's necessary in CF5 and earlier. - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 11:54 AM Subject: Re: mod command to alter row color Get rid of that evaluate, it's unneeded: style tr.alt1 {

Re: SQL for Access Help Needed

2004-11-02 Thread Ron Gowen
or you sure you datatypes in your database are actually dates? or perhaps you could try setting variables to your date values and using the create date function cfset startDate= createdate(10/1/2004) and do the same for you end date then cfset endDate= createdate(10/31/2004) WHERE

RE: Session Management

2004-11-02 Thread Tangorre, Michael
From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 1:57 PM Subject: Re: Session Management I am looking for a tag or script that will allow a user to continue their session when it has expired due to their lack of using the site. I have looked at cfdev.com and

Re: SQL for Access Help Needed

2004-11-02 Thread Ron Gowen
I believe cfqueryparam removes the need for creatodbcdate since that is in a sense what you are doing by typing it as cf_sql_date. On Tue, 2 Nov 2004 14:02:53 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: From: Donna French [mailto:[EMAIL PROTECTED] No, it doesn't work Mike, had already

Re: SQL for Access Help Needed

2004-11-02 Thread Ron Gowen
# are for when you are directly in access not interfacing through coldfusion On Tue, 2 Nov 2004 12:05:31 -0700, Ron Gowen [EMAIL PROTECTED] wrote: I believe cfqueryparam removes the need for creatodbcdate since that is in a sense what you are doing by typing it as cf_sql_date. On Tue, 2 Nov

Re: SQL for Access Help Needed SOLVED

2004-11-02 Thread Donna French
Thanks guys - it's working SELECT * FROM Clients WHERE Client_IntakeDate = cfqueryparam value=10/1/2004 cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=10/31/2004 cfsqltype=cf_sql_date; On Tue, 2 Nov 2004 12:02:09 -0700, Ron Gowen [EMAIL PROTECTED] wrote: or

RE: SQL for Access Help Needed

2004-11-02 Thread Pascal Peters
And cfqueryparam takes care of all that. So, once again, USE CFQUERYPARAM. ALWAYS! Pascal -Original Message- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: 02 November 2004 20:45 To: CF-Talk Subject: Re: SQL for Access Help Needed Access needs # to delimit date fields (SQL

RE: mod command to alter row color

2004-11-02 Thread Pascal Peters
This only works in CFMX. But you could use another function for numeric values (like val()) Pascal -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 02 November 2004 19:54 To: CF-Talk Subject: Re: mod command to alter row color Get rid of that evaluate,

Re: mod command to alter row color

2004-11-02 Thread Matt Robertson
Two more ways to skin this cat. First a real old one tr bgcolor=#iif(GetData.CurrentRow MOD 2, DE(variables.RowColor1), DE(variables.RowColor2))# and what I use now. Store the row colors in a var in application.cfm or something: my.RowColors=##EDEDED,##FBFBFB; and then use this in the table:

RE: mod command to alter row color

2004-11-02 Thread Robert Orlini
Thank you. One question, in this part of the code: cfloop from=1 to=10 index=i How would I make it infinite? I don't want it to end at the 10th row? Robert O. -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 1:35 PM To: CF-Talk Subject: Re: mod

Re: mod command to alter row color

2004-11-02 Thread Bryan Stevenson
look into a conditional loop then...as I'm sure you'd want to break out at some point ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web:

Re: SQL for Access Help Needed

2004-11-02 Thread Donna French
okay, since i have you guys brains for a minute or two can i run this past you all and see if it should work... the whole query i'm working on is for a reporting tool and here's the pseudocode/cf code i've come up with so far: SELECT * FROM Clients WHERE Client_IntakeDate = cfqueryparam

Re: mod command to alter row color

2004-11-02 Thread Joe Rinehart
Unot sure why you'd want to do that, but here's the fastest infinite loop I can think of: cfloop condition=true !--- do stuff. over and over. --- /cfloop -joe On Tue, 2 Nov 2004 14:11:28 -0500, Robert Orlini [EMAIL PROTECTED] wrote: Thank you. One question, in this part of the

Purolator Shipping Charges

2004-11-02 Thread Jim Gurfein
Hi folks... We're involved in a project where we need to be able to calculate Purolator shipping charges WITHIN Canada... anyone have tables for this and perhaps a custom tag or some programing? Any help would greatly be appreciated! Sincerely yours, Jim Gurfein President, CEO

Re: Purolator Shipping Charges

2004-11-02 Thread Bryan Stevenson
Just a thought...call Purolator for their rates ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com

Re: Mach II

2004-11-02 Thread Phil Cruz
I'm curious who is using Mach-II... Documentation and examples seems to be very minimal. The latest version of Tracking-Tools (http://tracking-tools.com) uses Mach-II. I host the site http://mach-ii.info which has a list of other (big) sites using Mach-II. The list is

Re: Purolator Shipping Charges

2004-11-02 Thread Jim Gurfein
Yes.. we did that and what should be simple is not... in fact very convoluted! At 02:39 PM 11/2/2004, Bryan Stevenson wrote: Just a thought...call Purolator for their rates ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642

Re: Purolator Shipping Charges

2004-11-02 Thread Bryan Stevenson
LOL...I feel your pain...try UPS...yikes!! ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com

Re: Session Management

2004-11-02 Thread Ben Doom
You could a) increase the session timeout b) use client scope note that if you use client scope, you can't store complex variables there (like queries or structures). --Ben Chad McCue wrote: I am looking for a tag or script that will allow a user to continue their session when it has

scheduled tasks and the time change

2004-11-02 Thread JB McMichael
So this is the second time this has happened this year, because its the second time change we have had. CFMX 6.1 on Win2003 server. When the time change happens, one of my scheduled tasks stops running. It is a daily task, that runs every 4 hours between 7:30 am and 11:59pm. Before the time

Re: mod command to alter row color

2004-11-02 Thread Jochem van Dieten
Robert Orlini wrote: I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Don't do it in CF, use CSS and javascript and ship it off to the client for processing. Example (BSD licensed) at

Re: Purolator Shipping Charges

2004-11-02 Thread Adam Haskell
UPS is easy just use thier webservices... Adam H On Tue, 2 Nov 2004 11:54:17 -0800, Bryan Stevenson [EMAIL PROTECTED] wrote: LOL...I feel your pain...try UPS...yikes!! ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone:

  1   2   >