RE: cfinclude outside of site document root?

2004-06-04 Thread Pascal Peters
You can simply use a relative path to the files outside the webroot (you can't leave the drive though). For more flexibility, you can use a CF mapping (mappings in the cf admin). > -Original Message- > From: Damien McKenna [mailto:[EMAIL PROTECTED] > Sent: donderdag 3 juni 2004 18:00 > T

Re: User Authentication

2004-06-04 Thread Arden Weiss
My two cents... Maybe I am off-base, but I only use session variables for login management purposes -- instead I mostly use client variables to gain inter-template communication -- the advantage of this is that no locking is required.   Guess there are some disadvantages, but I haven't found them

RE: User Authentication

2004-06-04 Thread Paul Wilson
So session variables work differently in MX then? What about people with cookies turned off in their browsers? -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Friday, 4 June 2004 13:42 To: CF-Talk Subject: RE: User Authentication Session variables use persisten

RE: SUM DateDiff Data

2004-06-04 Thread Pascal Peters
The problem is you cant do it in one query, because of the grouping and selecting too much data. If you need the total time (or time per client), you will probably need two queries. The problem is that I have no idea which column belongs to which table. Get all the records you need SELECT tcd.C

RE: User Authentication

2004-06-04 Thread Pascal Peters
For people with no cookies, you need to pass the apropriate info on the url (this was always like this). In MX you can use J2EE sessions and the function URLSessionFormat to do that: variables.id)#"> action=""> If you are not using J2EE session, this won't work for the form with method="get

Re: Layers and JavaScript

2004-06-04 Thread Thomas Chiverton
On Thursday 03 Jun 2004 20:15 pm, [EMAIL PROTECTED] wrote: > Does anyone have a work around for this? Set the z-index. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel

RE: User Authentication

2004-06-04 Thread Kenneth Wilson
>>Session variables use persistent cookies also unless you code the >>CFID and CFToken into the URL, or you use j2ee session management. This seems to be one of those common misperceptions that keeps getting repeated. While CF's native cookie setting may use persistent cookies, there's nothing at

Re: path to uploaded file

2004-06-04 Thread daniel kessler
That sounds great.  I've not used the Application.cfm up until now, so I look into that. thanks for the advice. >i set that path in the Application.cfm template, then say when I need it >to display and image its a very simple call >and yes i would just store the image name in the db, other wise y

RE: Secure FTP?

2004-06-04 Thread Dave Watts
> I believe the servers are windows.  Will this still work?  Is > there a server for windows to support SCP? There's a commercial SSH server for Windows from Van Dyke Software which is quite nice. It's called VShell, I think: http://www.vandyke.com/ Dave Watts, CTO, Fig Leaf Software http://www

RE: Unable to open license.properties

2004-06-04 Thread Dave Watts
> I wouldn't use the CF Admin to edit the JVM as I've known > this to cuase issues to hand edit it. To the best of my knowledge, this is only an issue if you've installed CFMX on JRun, in which case the JRun Admin interface allows you to edit jvm.config, but often breaks it. I've had no trouble u

RE: No JDBC data sources

2004-06-04 Thread Dave Watts
> Hey, while I am on the subject of going through my log files! > I am also getting the error below which doesn't look good: > > "No JDBC data sources have been configured for this server > (see jrun-resources.xml)" > > Anyone know of a solution/explanation? If you're running CFMX on JRun, you

Phone Number for Macromedia Contact

2004-06-04 Thread Claremont, Timothy
A couple weeks ago a few list members suggested that I call Macromedia and explain my situation for wanting to extend the license on my demo version of CFMX for a short time until my capital request goes through. Can anyone provide the contact information for the appropriate party to contact? If y

prevent refresh w/session

2004-06-04 Thread Robert Orlini
I'm using this code to prevent a refresh from re-entering data: Run code It still runs the code after the up on top. What am I doing wrong here? Any ideas please? Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: prevent refresh w/session

2004-06-04 Thread Paul Vernon
Your code should read as follows: and dont forget to lock your session scope.. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: prevent refresh w/session

2004-06-04 Thread d.a.collie
session.ranAlready)> Run Code This will mean the code will only be ran once per session *not* refresh is that what you are trying to achieve? Probs want to lock it as well -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: No JDBC data sources

2004-06-04 Thread Robertson-Ravo, Neil (RX)
I got some info from MM support...these messages are benign and can be ignored...they are technically bugs and have been logged. N    _   From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 04 June 2004 14:26 To: CF-Talk Subject: RE: No JDBC data sources > Hey, while I am on the subject o

RE: prevent refresh w/session

2004-06-04 Thread Ian Skinner
need to reverse you Boolean logic Do Stuff Don't do stuff Confidentiality Notice:  This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or dist

RE: Phone Number for Macromedia Contact

2004-06-04 Thread nancy . tracy
I don't have a name to call specifically since the Sys Admin was the one who called to get our demo extended.  He just called their customer service number. US and Canada: 1-800-470-7211 (Toll Free) Outside US and Canada: +1-415-553-7186 http://www.macromedia.com/support/email/cscontact/

RE: User Authentication

2004-06-04 Thread Semrau Steven Ctr SAF/IE
See --> http://www.macromedia.com/support/coldfusion/ts/documents/tn17915.htm  for full explanation. -Original Message- From: Greg Landers [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 11:32 PM To: CF-Talk Subject: User Authentication These are probably dumb question

RE: User Authentication

2004-06-04 Thread Marlon Moyer
Originally the poster was comparing native session vs native client variables.  In that context, they both use persistent cookies.  So the problem he was asking about would be no different for either scope.  You are correct that you can easily change that.  Here's a tech note that describes that ex

RE: prevent refresh w/session

2004-06-04 Thread Robert Orlini
Yes. Except when I use the "not" after the CFIF it doesn't display the page at all. When I leave the "not" in it displays it, but when I refresh it adds data to the page and that's what I'm trying to avoid. Am I still missing something? -Original Message- From: [EMAIL PROTECTED] [mailto:[

RE: prevent refresh w/session

2004-06-04 Thread Tangorre, Michael
> Yes. Except when I use the "not" after the CFIF it doesn't > display the page at all. When I leave the "not" in it > displays it, but when I refresh it adds data to the page and > that's what I'm trying to avoid. Am I still missing something? I would recommend using cfparam then check for a v

Dynamically writing/running a CF tag?

2004-06-04 Thread Jamie Jackson
In CF5, I've written a wrapper for the tag so that it does multipart emails (HTML + Text + attachments, etc.). Right now, I construct the final tag as a variable, then I write that variable (the cfmail tag) to a file, then include it, then delete it. This is inefficient, but it is to get around t

RE: Dynamically writing/running a CF tag?

2004-06-04 Thread Philip Arnold
> From: Jamie Jackson > > In CF5, I've written a wrapper for the tag so that > it does multipart emails (HTML + Text + attachments, etc.). > Right now, I construct the final tag as a variable, > then I write that variable (the cfmail tag) to a file, then > include it, then delete it. This is

Datebase Question!

2004-06-04 Thread cf coder
Database question. I have a insert statment. I'm inserting a new record in the table. The table has a primary key (empID) Here is the code INSERT INTO ASSETS ( empName, empDesk, empAsset ) VALUES ( 'blog', '1, 'ast10' ) I want to retreive the primary key (empID) value immediately a

RE: Datebase Question!

2004-06-04 Thread John Beynon
What database is it? SQL/Access/MySQL? -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: 04 June 2004 16:34 To: CF-Talk Subject: Datebase Question! Database question. I have a insert statment. I'm inserting a new record in the table. The table has a primary key (empID) H

Re: Datebase Question!

2004-06-04 Thread cf coder
SQL [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Dynamically writing/running a CF tag?

2004-06-04 Thread Jamie Jackson
On Fri, 4 Jun 2004 11:20:25 -0400, in cf-talk you wrote: >> From: Jamie Jackson >> >> In CF5, I've written a wrapper for the tag so that >> it does multipart emails (HTML + Text + attachments, etc.). >> Right now, I construct the final tag as a variable, >> then I write that variable (the cf

Get Database Tables, etc

2004-06-04 Thread Robert Shaw
I know I have seen this on the list before but I can't find the exact code. Does anyone have the code for querying a database and returning a list of tables and/or column info? TIA, Robbie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Datebase Question!

2004-06-04 Thread Mark Drew
In Microsoft SQL server you can do something like: INSERT INTO table (col1, col2) VALUES 'val1', 'val2') SELECT thisUserID = @@IDENTITY SET NOCOUNT OFF; I hope that helps On Fri, 04 Jun 2004 11:47:45 -0400, cf coder <[EMAIL PROTECTED]> wrote: > > SQL > > [Todays Threads] [This Message] [Su

Re: Get Database Tables, etc

2004-06-04 Thread Claude Schneegans
>>Does anyone have the code for querying a database and returning a list of tables and/or column info? Depending on the database you're using, there is some code possible, but not for all databases. For any kind of ODBC database, CFX_ODBCInfon is the sure way. See the address below. -- _

RE: Datebase Question!

2004-06-04 Thread Philip Arnold
> From: cf coder > > I have a insert statment. I'm inserting a new record > in the table. The table has a primary key (empID) > Here is the code > > > > INSERT INTO ASSETS > ( > empName, > empDesk, > empAsset > ) > > VALUES > > ( > 'blog', > '1, > 'ast10' > ) > > > > I want to retr

Re: Get Database Tables, etc

2004-06-04 Thread Mark Drew
Depends on the DB, I know that you can do "show tables" with mySQL for MS SQL you can do a query to the sysobjects table as follows: SELECT * FROM sysobjects WHERE (xtype = 'U') HTH Mark Drew On Fri, 04 Jun 2004 11:47:49 -0400, Robert Shaw <[EMAIL PROTECTED]> wrote: > > I know I

Re: Get Database Tables, etc

2004-06-04 Thread Jochem van Dieten
Robert Shaw wrote: > I know I have seen this on the list before but I can't find the exact code. > Does anyone have the code for querying a database and returning a list of > tables and/or column info? If your database is compliant with the SQL spec you can get all off that from the informatio

Immediate need for CF developer in Atlanta area...

2004-06-04 Thread Monique Boea
Please respond if you're interested. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Immediate need for CF developer in Atlanta area...

2004-06-04 Thread Philip Arnold
> From: Monique Boea > > Please respond if you're interested. I have already suggested that you post to the Atlanta CFUG lists, but you seemed to ignore it [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Get Database Tables, etc

2004-06-04 Thread mavinson
you could use select * from myTable -mike "Robert Shaw" <[EMAIL PROTECTED]> 06/04/2004 11:47 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Get Database Tables, etc I know I have seen this on the list before but I can'

RE: User Authentication

2004-06-04 Thread Dave Watts
> See --> > http://www.macromedia.com/support/coldfusion/ts/documents/tn17 > 915.htm  for full explanation. >   > > setclientcookies="NO" clientmanagement="NO" > sessiontimeout="#CreateTimeSpan(0,0,20,0)#"> > > > scope="session">   > value="#SESSION.CFID#">   > value="#SESSION.CFTOKEN#"> It

Re: Output formatting

2004-06-04 Thread Jochem van Dieten
Eric Creese wrote: > Ok, I am screwing this up. What exactly does your code do that it shouldn't? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Output formatting question

2004-06-04 Thread Eric Creese
I used your suggestion and  the text on the first line was still to the right. So I change the margin you had set from 5 to 0 and it worked. When I went to the next page though the text adjusted again on the first line and was moved right. Any ideas? [Todays Threads] [This Message] [Subscripti

RE: Dynamically writing/running a CF tag?

2004-06-04 Thread Barney Boisvert
Have you tried passing attributeCollection to the CFMAIL tag, just like you would to a custom tag or CFMODULE call?  I have no idea if it'd actually work, but it's worth a shot, as it would provided exactly the functionality you're looking for. Cheers, barneyb > -Original Message- > From

RE: Get Database Tables, etc

2004-06-04 Thread Semrau Steven Ctr SAF/IE
I'm using Oracle 9i: SELECT object_name FROM    user_objects WHERE object_type in ('TABLE', 'VIEW') This will get you the table and view names. SELECT column_name FROM    user_tab_columns WHERE table_name = 'your_table_name_here' This will get you the columns for that particular table.

RE: Output formatting

2004-06-04 Thread Eric Creese
well it keeps aligning the first line to the right if it does not span al the way across to the image. example   x [image] xxx xxx want it to be like     [image] xx xx x Does that make sense? an

RE: Output formatting

2004-06-04 Thread Tangorre, Michael
Send the rendered HTML not the code.. We cant run that. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: User Authentication

2004-06-04 Thread Semrau Steven Ctr SAF/IE
You should share that info with MM and have them update the TechNote for future reference. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 12:24 PM To: CF-Talk Subject: RE: User Authentication > See --> > http://www.macromedia.com/support/coldfus

Re: Output formatting

2004-06-04 Thread Jochem van Dieten
Eric Creese wrote: >   > want it to be like >     [image] > xx > xx > x I presume you want: formattedcontent[image] formattedcontentformattedcap formattedcontent formattedcontentformattedcontent formattedcontentformattedconte

Re: Datebase Question!

2004-06-04 Thread cf coder
Thanks so much Mark and Philip for your help. It works best regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Output formatting

2004-06-04 Thread Eric Creese
this should do it. you notice the first line is moved to the right. Also this is just a client I neither condone or condem his views. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 11:30 AM To: CF-Talk Subject: RE: Output formatting Sen

RE: Get Database Tables, etc

2004-06-04 Thread Shawn Grover
In MS SQL Server (2000), you can use the system stored procedure sp_tables. Issuing the command: exec sp_tables will list all the tables in the current database, with a column for table type (System or Table).  More details are in the online help for T-SQL. There are similar stored proc

RE: Get Database Tables, etc

2004-06-04 Thread Robert Shaw
This is DB2 on MX... -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 11:52 AM To: CF-Talk Subject: Re: Get Database Tables, etc >>Does anyone have the code for querying a database and returning a list of tables and/or column info? Dependin

RE: Output formatting

2004-06-04 Thread Eric Creese
that worked -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 11:38 AM To: CF-Talk Subject: Re: Output formatting Eric Creese wrote: >   > want it to be like >     [image] > xx > xx > x

Re: SUM DateDiff Data

2004-06-04 Thread hammerin hankster
That was it!  Thanks for all help Pascal!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: path to uploaded file

2004-06-04 Thread cf
sorry forgot part of it you can also set the image path in the Application.cfm page as well to make coding shorter then call it with > That sounds great.  I've not used the Application.cfm up until now, so I > look into that. > > thanks for the advice. > >>i set that path in the Application.c

Funky CF Error

2004-06-04 Thread Greg.Morphis
A friend and I were working on this page yesterday... We were getting this "not a valid number" error.. The code worked fine when written and ran straight from Toad. We both looked at the code puzzled for a few minutes. My friend commented out a line using the CF "where a.loctype='#thisLoctype#'" s

Re: Dynamically writing/running a CF tag?

2004-06-04 Thread Jamie Jackson
Yeah, that's the sort of creative thinking I was looking for. That would be a great hidden feature of built-in tags if it works... I'll let you know. Thanks, Jamie On Fri, 4 Jun 2004 09:17:53 -0700, in cf-talk you wrote: >Have you tried passing attributeCollection to the CFMAIL tag, just like yo

Password in Image Technology

2004-06-04 Thread Lee
Does anyone know anything about the technology that a lot of people use including Network Solutions, that displays a password in a fuzzy image and forces the user to type in that password to proceed? I'm assuming it's primary purpose is to stop automated hacking technology from abusing forms.

Re: Password in Image Technology

2004-06-04 Thread Bryan Stevenson
you gotter otter ;-) pretty simple really...the image is obscurred so OCR software can't read the "special code" and post the form automatically using what it read Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]

OT: JS Page break

2004-06-04 Thread Robert Orlini
Is there a _javascript_ code that I can use to insert a page break? I want to print something but section it into 4 or 5 pages. Robert O. ô¿ô [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: JS Page break

2004-06-04 Thread Tangorre, Michael
CSS is what yur after. Check this.. http://www.htmlgoodies.com/beyond/css_print.html Mike > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: Friday, June 04, 2004 2:06 PM > To: CF-Talk > Subject: OT: JS Page break > > Is there a _javascript_ code that I can u

RE: JS Page break

2004-06-04 Thread Tyler Clendenin
no but there is css.  look up always-break before and always-break-after. Tyler Clendenin GSL Solutions   _   From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 2:06 PM To: CF-Talk Subject: OT: JS Page break Is there a _javascript_ code that I can use to insert a p

query grouping

2004-06-04 Thread Tyler Clendenin
Now i know about cfoutput's group attributes, but can someone explain to me why in so many versions cfloop has not been given the same attributes and if there is a way (other then programming all the grouping logic myself) to get the same result as cfoutput group without using an output. Tyler C

RE: JS Page break

2004-06-04 Thread Sandy Clark
Keep iin mind that the CSS solution will only work in a paged medium (ie if you are printing the pages). It will have no effect on a continous medium such as the screen. Sandy Clark   _   From: Tyler Clendenin no but there is css.  look up always-break before and always-break-after. [

Re: Phone Number for Macromedia Contact (is: longer trial)

2004-06-04 Thread John Dowdell
At 6:58 AM 6/4/4, Claremont, Timothy wrote: >A couple weeks ago a few list members suggested that I call Macromedia >and explain my situation for wanting to extend the license on my demo >version of CFMX for a short time until my capital request goes through. >Can anyone provide the contact informa

RE: query grouping

2004-06-04 Thread Barney Boisvert
You can't use CFLOOP for grouping unless you do it yourself (not recommended). I'd imaging that the reason is CFLOOP is designed for simple looping, while CFOUTPUT is purpose built for dealing with recordsets.  When nested, individual CFLOOP tags are never related (though you can potentially make

RE: JS Page break

2004-06-04 Thread Robert Orlini
Thanks all. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 2:18 PM To: CF-Talk Subject: RE: JS Page break CSS is what yur after. Check this.. http://www.htmlgoodies.com/beyond/css_print.html Mike > -Original Message- > From: Ro

Re: query grouping

2004-06-04 Thread Deanna Schneider
Theoretically, you could make a query out of whatever you want to loop and then group it with cfoutput, though. > > > -Original Message- > > From: Tyler Clendenin > > > > Now i know about cfoutput's group attributes, but can someone > > explain to me > > why in so many versions cfloop has n

whats your opinion on this cfm program?

2004-06-04 Thread cf
ok, i just had a client ask me why they shouldnt just buy this program http://www.hkvstore.com/cfmmaker/ so i downloaded it, ran it against their db & in about 10 seconds had a fairly complete site, couldnt believe it. Of course it needed a few tweaks and a face lift but the code seemed fairly dece

TRIMMED: whats your opinion on this cfm program?

2004-06-04 Thread cf
ok, i just had a client ask me why they shouldnt just buy this program http://www.hkvstore.com/cfmmaker/ so i downloaded it, ran it against their db & in about 10 seconds had a fairly complete site, couldnt believe it. Of course it needed a few tweaks and a face lift but the code seemed fairly dece

Re: Password in Image Technology

2004-06-04 Thread Claude Schneegans
>>the image is obscurred so OCR software can't read the "special code" Exact, and some use similar character, like I and 1, Z and 2, S and 5, etc. in order to goof the OCR systems even more. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/clau

RE: TRIMMED: whats your opinion on this cfm program?

2004-06-04 Thread Emmet McGovern
I'm too lazy check the app out right now.  I'm curious to know if it handled the relations in the database the way it was supposed to? -emmet   _   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 2:56 PM To: CF-Talk Subject: TRIMMED: whats your opinion on this

RE: TRIMMED: whats your opinion on this cfm program?

2004-06-04 Thread Samuel R. Neff
The results looks like a database admin tool and not a real website.  I wouldn't want to deliver anything like that for a client.  If it was on-the-fly table/form creation then I woudl say it is ok to use for back-end stuff. Of course, if that's what the client wants and is happy with it, then you

RE: TRIMMED: whats your opinion on this cfm program?

2004-06-04 Thread Shawn Grover
I wrote a program about two years ago that could analyse a database, and create a functional web site consisting of pages for each table that allowed selecting a record to edit, editing a record, as well as adding a new record or deleting one.  It did so by creating all the SQL statements that were

Re: Dynamically writing/running a CF tag?

2004-06-04 Thread Jamie Jackson
No dice, but that would have been slick. ;-) "An unknown attribute 'attributeCollection' has been encountered..." :( Thanks, Jamie On Fri, 4 Jun 2004 09:17:53 -0700, in cf-talk you wrote: >Have you tried passing attributeCollection to the CFMAIL tag, just like you >would to a custom tag or CFMO

Re: Dynamically writing/running a CF tag?

2004-06-04 Thread Jamie Jackson
On Fri, 4 Jun 2004 11:20:25 -0400, in cf-talk you wrote: >> From: Jamie Jackson >> >> In CF5, I've written a wrapper for the tag so that >> it does multipart emails (HTML + Text + attachments, etc.). >> Right now, I construct the final tag as a variable, >> then I write that variable (the cf

Re: Dynamically writing/running a CF tag?

2004-06-04 Thread Scott Weikert
Here's a silly thought... Why not create several templates with your tag, but each one with a different combo of attributes? Then you simply call the appropriate template based on what attributes you've got for that particular send. I don't know how many different attributes you've got to deal

RE: Funky CF Error

2004-06-04 Thread Greg.Morphis
Has noone else seen this before? -Original Message- From: Morphis, Greg Sent: Friday, June 04, 2004 12:40 PM To: CF-Talk Subject: Funky CF Error A friend and I were working on this page yesterday... We were getting this "not a valid number" error.. The code worked fine when written and r

SQL date record retrevial problem

2004-06-04 Thread Eric Creese
I am using the following to retreive records from a database. However I am not gettign any records and I should. Database is Access but will be moving to SQL for production SELECT EVENT_ID,EVENT_DATE,EVENT_NAME,EVENT_TIME,EVENT_LOC FROM schedule WHERE EVENT_DATE <= #DATEFORMAT

Re: TRIMMED: whats your opinion on this cfm program?

2004-06-04 Thread Damien McKenna
Some ideas for anyone planning to write one of these: 1. Detect dates/timestamps, including the format, and use jsCalendar to insert the data. 2. Detect large text fields (CLOBs?) and use optionally use HTMLArea to edit it. 3. Detect email and http fields and use fValidate to validate them in

Re: Get Database Tables, etc

2004-06-04 Thread Jochem van Dieten
Robert Shaw wrote: > This is DB2 on MX... DB2 doesn't use the information schema, but the syscat schema: http://www-306.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?fn=db2s003.htm#ToC_557 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe

RE: SQL date record retrevial problem

2004-06-04 Thread Pascal Peters
SELECT EVENT_ID,EVENT_DATE,EVENT_NAME,EVENT_TIME,EVENT_LOC FROM schedule WHERE EVENT_DATE <= #CreateODBCDate(today365)# AND EVENT_DATE > #CreateODBCDate(today1)# AND display='yes' ORDER BY EVENT_DATE And of course cfqueryparam!!! > -Original Message- > Fro

Re: Funky CF Error

2004-06-04 Thread Deanna Schneider
I've not seen anything quite like that before. I have seen some funkiness where it appears that the query is being cached, even when I haven't told it to cache, and you have to change something in the query (more space/less space, 1=1) and if you revert back to the old spacing, it'll revert back to

Re: Funky CF Error

2004-06-04 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > A friend and I were working on this page yesterday... > We were getting this "not a valid number" error.. The code worked fine when written and ran straight from Toad. > We both looked at the code puzzled for a few minutes. > My friend commented out a line using the CF "

RE: SQL date record retrevial problem

2004-06-04 Thread Eric Creese
thanks but I got this [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query _expression_ 'EVENT_DATE <= d '40041-12-31'} AND EVENT_DATE > #6/3/2004# AND display='yes''. [Todays Threads] [This Message] [Subscription]

RE: Funky CF Error

2004-06-04 Thread Greg.Morphis
It was the invalid number Cold Fusion error... I cannot duplicate the error today, so maybe it had something to do with caching... I'm not sure, we were pretty baffled about this yesterday -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 3:38

Re: Dynamically writing/running a CF tag?

2004-06-04 Thread Jamie Jackson
Hmm, that's one I hadn't thought of. However, I don't think I'm up for writing all those combos & logic (though your solution would execute faster). I award you 50 creativity points. Thanks for the idea, Jamie On Fri, 04 Jun 2004 14:16:56 -0600, in cf-talk you wrote: >Here's a silly thought...

Re: Funky CF Error

2004-06-04 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > It was the invalid number Cold Fusion error... Which one exactly? If it was a ColdFusion error, it is more likely caused by the cfqueryparam as by the line you mentioned. You can easily check what threw the error by looking at the last part that is between square br

Re: Dynamically writing/running a CF tag?

2004-06-04 Thread Scott Weikert
At 03:08 PM 6/4/2004, you wrote: >Hmm, that's one I hadn't thought of. However, I don't think I'm up for >writing all those combos & logic (though your solution would execute >faster). Well... you could kinda do what you were thinking - rolling your own custom tag on the fly and writing it out wi

RE: Dynamically writing/running a CF tag?

2004-06-04 Thread Barney Boisvert
You wouldn't have to write them all, just write a script that'll take a set of "things", and then create combinations thereof.  Pass in the set of attributes CFMAIL can accept, and let the machine write all the files for you.  It can even write the logic for selecting the right file, if you want, t

Re: TRIMMED: whats your opinion on this cfm program?

2004-06-04 Thread cf
i certainly wouldnt just use this but to write a big chunk of the code then go back and do with it what you want certainly could save a lot of time and i believe this program did what you mentioned below fyi~ im not advocating it by any means, just caught me by suprise and was sharing. i was on

RE: SQL date record retrevial problem

2004-06-04 Thread Pascal Peters
This doesn't look good. Are you sure you used dateadd and Createodbcdate on both dates. If it throws an error, it should at least say 'EVENT_DATE <= {d '2005-06-04'} AND EVENT_DATE > {d '2004-06-03'} AND display='yes'' And you're still not using Pascal > -Original Message- > From: Eri

Can anyone tell me what this error means?

2004-06-04 Thread Butch Zaccheo
Hi all... I¹m trying to set-up a cold fusion application I purchased not to long ago... I¹m running Blue Dragon Server 6.1 and MySQL on a linux box. When I run the application I keep getting an error I¹m not familiar with. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: Can anyone tell me what this error means?

2004-06-04 Thread cf
an error huh? eenie meenie, minie moe, please describe the error so we all know.. ;)~ > Hi all... > > I¹m trying to set-up a cold fusion application I purchased not to long > ago... I¹m running Blue Dragon Server 6.1 and MySQL on a linux box. When > I run the application I keep getting an err

Is this a DateDiff() bug?

2004-06-04 Thread Jim McAtee
ColdFusion 5: DateDiff("d", "5/1/2004", "5/31/2004")  = #DateDiff("d", "5/1/2004", "5/31/2004")# DateDiff("w", "5/1/2004", "5/31/2004")  = #DateDiff("w", "5/1/2004", "5/31/2004")# DateDiff("ww", "5/1/2004", "5/31/2004") = #DateDiff("ww", "5/1/2004", "5/31/2004")# Gives: DateDiff("d", "5/1/20

RE: Is this a DateDiff() bug?

2004-06-04 Thread Tony Weeg
there are problems with dateDiff(), for certain. try dates that span Daylight Savings time, I thought the bug was fixed, but I kinda think that one of the patches, made it wrong again, I cant say for certain, but, most likely. tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL

url string parameter question.

2004-06-04 Thread Tony Weeg
in a url string... http://www.antiwrap.com/?a=1 I can get to a, because its url.a, and I know it equals 1 however, how do I get to this? http://www.somedomain.com/? = nothing. I guess it's a struct, called url, and it has a thing called , but I guess, how do I get to the freakin

RE: url string parameter question.

2004-06-04 Thread Tony Weeg
so, I can look for this... Has a url like this http://www.somedomain.com/? Has a url like this http://www.somedomain.com/?a=&tony=1 so, then I can use structKeyList(url), which gives me the name of the url parameter, but really it's the number I want :) tony Tony Wee