Re: to_char in MS Access

2004-01-05 Thread Jochem van Dieten
Jim Watkins wrote: Jochem helped me convert the to_date function to work in MS Access and now I have a problem with to_char.When I run the script against an Access DB I get:Undefined function 'to_char' in _expression_. For Oracle SQL=My script is: cfquery name=leavehistory datasource=banner

Re:Password Logic

2004-01-05 Thread walker
Good thinking. This idea is much better. -w At 10:33 PM 1/4/2004, you wrote: For best practices-sake, if the user forgets their password, you should only be able to generate a new one and email it out I prefer not to send any password via mail (auto or user-generated. If a user forgets

Re:cfm won't work in combination of other isapi.dll

2004-01-05 Thread Willy Otto
I called it an Isapi.dll because this software developer called it so(it's written in Delphi). So it isn't like he said, now i understand. The dll is called from the browser, that's a fact, in Dcomcnfg.exe you define access rights to this software so internet users can use it.That's all i know.

RE: Password Logic

2004-01-05 Thread Cameron Childress
A plaintext link or URL is no more or less secure than a plaintext password. The equivalent using the random password technique would simply involve making the new random password only good for 24 hours. Assuming the UUID is truly random (historically some versions of CF have generated

RE: flash remoting help

2004-01-05 Thread Adrian Lynch
You don't seem to have created a responder function in flash. Do you get an error message in Flash? Something along the lines, .no default responder..? If so, have a look at responders for flash remoting. There's a few different ways to do it but you'll no doubt choose your

RE: Java Mailing List

2004-01-05 Thread Adrian Lynch
I like the Java forums. I know what you mean about them snubbing beginners, but I think it's because they get a LOT of students asking homework/course questions on there. I've seen some that copy and paste their question into their post. Some people have given solutions to these sorts of questions

RE: cfm won't work in combination of other isapi.dll

2004-01-05 Thread Paul Vernon
If it's written in Delphi, it wouldn't be a massive job to turn it into a CFX tag instead if you have access to the source code, that way you could drop the requirement for running a page request through two ISAPI dlls your specialised on and ISCF.dll and your problems would go away. All the CFX

Re: to_char in MS Access

2004-01-05 Thread Jim Watkins
Thanks Jochem now and how would I treat the following between dates: '#DateFormat(dailydate, DD-mmm-)#' between fromdate5 and todate5 I tried cfqueryparam cfsqltype=cf_sql_date value=#dailydate#between fromdate1 and todate1 but get the following error: Syntax error (missing operator) in

Re: to_char in MS Access

2004-01-05 Thread Jochem van Dieten
Jim Watkins said: Thanks Jochem now and how would I treat the following between dates: '#DateFormat(dailydate, DD-mmm-)#' between fromdate5 and todate5 I tried cfqueryparam cfsqltype=cf_sql_date value=#dailydate#between fromdate1 and todate1but get the following error: Syntax error

Re: Changes to Functionality in Microsoft Windows XP Service Pack 2

2004-01-05 Thread Thomas Chiverton
On Tuesday 23 Dec 2003 13:47 pm, Samuel R. Neff wrote: Interesting that there was no mention of the Active Content/Eolas issue;I guess that change isn't in this update.Anyone have more details/confirmation? Stil awaiting the outcome of the patent being re-examined in light of prior art that

Re: Password Logic

2004-01-05 Thread Jesse Houwing
I would not suggest storing your passwords in plain text in the DB.Storing them in this manner leaves them vulnerable to anyone who ends up with access to that database.You may or may not consider the data in your web app important to your user, but most users will attempt to use a

RE: Password Logic

2004-01-05 Thread Jochem van Dieten
Cameron Childress said: A plaintext link or URL is no more or less secure than a plaintext password. The equivalent using the random password technique would simply involve making the new random password only good for 24 hours. Assuming the UUID is truly random (historically some versions of

RE: cfm won't work in combination of other isapi.dll

2004-01-05 Thread Dave Watts
I called it an Isapi.dll because this software developer called it so(it's written in Delphi). So it isn't like he said, now i understand. The dll is called from the browser, that's a fact, in Dcomcnfg.exe you define access rights to this software so internet users can use it.That's all

Invalid Date Format?

2004-01-05 Thread DeMarco, Alex
All of the sudden we started getting these errors: 02-29-05 is an invalid date format.brThe error occurred on line 142. There are only 28 day's in 05.. Here is the code I am using : CFIF #ValueToMod# mod 10 is Checksum AND

Re: Invalid Date Format?

2004-01-05 Thread Jochem van Dieten
DeMarco, Alex said: All of the sudden we started getting these errors: 02-29-05 is an invalid date format.brThe error occurred on line 142. There are only 28 day's in 05.. Here is the code I am using : CFIF #ValueToMod# mod 10 is Checksum AND

RE: Invalid Date Format?

2004-01-05 Thread Philip Arnold
I think the problem you're encountering is that DaysInMonth() expects a complete date, and you're only passing it 02-05 which it is mis-interpretting Try changing it to DaysInMonth(CreateDate(form.Year, form.Month, 1)) and see if that works -Original Message- From: DeMarco, Alex

RE: Invalid Date Format?

2004-01-05 Thread JT
-Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 6:43 AM To: CF-Talk Subject: RE: Invalid Date Format? I think the problem you're encountering is that DaysInMonth() expects a complete date, and you're only passing it 02-05 which it is

Re: CF loosing connection to MYSQL database.

2004-01-05 Thread Thomas Chiverton
On Monday 22 Dec 2003 13:07 pm, Jochem van Dieten wrote: That is to be expected if you use an alpha release. Your best bet is to start debugging using tcpdump. Does tethereal not decode ODBC yet ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL

Re: Password Logic

2004-01-05 Thread Matt Liotta
You could use encryption with a private and a public key. In the application you always re-encrypt the password and compare the encrypted string. And in certain cases someone from another system can use the private key to extract the password. This would be the best of both worlds,

Re: CF loosing connection to MYSQL database.

2004-01-05 Thread Jochem van Dieten
Thomas Chiverton said: On Monday 22 Dec 2003 13:07 pm, Jochem van Dieten wrote: That is to be expected if you use an alpha release. Your best bet is to start debugging using tcpdump. Does tethereal not decode ODBC yet ? ODBC does not standardize a wire protocol. Jochem [Todays Threads]

Re: GUI web controls

2004-01-05 Thread Kevin Graeme
Those are really nice! Even works fine over select boxes which someone here was having a problem with, IIRC. -Kevin - Original Message - From: Tim Heald [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 04, 2004 11:11 AM Subject: RE: GUI web controls There are

RE: CF loosing connection to MYSQL database.

2004-01-05 Thread Ketan Patel
Hi, Once I moved my site to CFMX and now use CFMX MYSQL drivers all started working fine. But had problems with CF5.0 MYODBC drivers. Ketan Patel -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 9:33 AM To: CF-Talk Subject: Re: CF

OT: ActivePDF WebGrabber

2004-01-05 Thread Ryan Roskilly
I can grab a url off of an external website and create pdfs but if I try and grab a url off of a site on our development server ActivePDF times out. ActivePDF, and web grabber are installed on our development server. I would think this might have something to do with the settings in IIS, etc.

Re: Password Logic

2004-01-05 Thread Jesse Houwing
but you only need the public key for password verification (eg encrypt th epassword again and verify the encrypted data). Only selected personel would have access to the private key in case anything needs to be decrypted. This could also happen from an intranet system that has access to the

OT-SQL Data file issue

2004-01-05 Thread Eric Creese
Ok I made a big mistake. I had a database set to FULL thinking it was set to SIMPLE and forgot to set up a job to truncate the transaction log. Needless to say, the transaction log grew huge (14g) and sucked up all my memory. So I took the database offline and deleted the file and replaced it with

RE: OT-SQL Data file issue

2004-01-05 Thread Schuster, Steven
I can't remember the name of it but there is a SP you can run to fix this. Check your SQL Books online, it is there. http://intranet Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 -Original

RE: OT-SQL Data file issue

2004-01-05 Thread Tony Weeg
you deleted the ldb file? uhhh, hmm, do you have a backup? tw -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:06 AM To: CF-Talk Subject: OT-SQL Data file issue Ok I made a big mistake. I had a database set to FULL thinking it was set

RE: OT-SQL Data file issue

2004-01-05 Thread Eric Creese
Unfortunately the last back up I had was from 11/28. This all happened yesterday. And yes the .ldf file was deleted. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 9:10 AM To: CF-Talk Subject: RE: OT-SQL Data file issue you deleted the ldb

RE: OT-SQL Data file issue

2004-01-05 Thread Tony Weeg
http://www.tek-tips.com/gfaqs.cfm/pid/962/fid/4210 http://www.mssqlcity.com/FAQ/Trouble/SuspectDB.htm try these? -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:10 AM To: CF-Talk Subject: RE: OT-SQL Data file issue Unfortunately the

RE: OT-SQL Data file issue

2004-01-05 Thread Schuster, Steven
Ok, first try this:: sp_resetstatus If that does not work you might try the following:: 1. Turn off the SQL Server, 2. Copy the data file to a secure location on the drive 3. Turn on the SQL Server 4. Create a new database, call it foo or something 5. Turn off the database 6. Look in the

Re: Password Logic

2004-01-05 Thread Kevin Graeme
Be aware that some ISPs will reuse email addresses when one customer leaves and another arrives. So while they are unique at a moment in time, they do not always uniquely identify one person over a period of time. I ran into this when trying to send an email to a friend and the email went to a

Re: Password Logic

2004-01-05 Thread Matt Liotta
but you only need the public key for password verification (eg encrypt th epassword again and verify the encrypted data). Only selected personel would have access to the private key in case anything needs to be decrypted. This could also happen from an intranet system that has access to

RE: OT-SQL Data file issue

2004-01-05 Thread Tom Kitta
The sql server certification book suggest to back up the DB ASAP with no truncation option. I don't have the book with me but loosing the transaction log is not that tragic of an event as far as I remember. Just don't delete the DB data file as well :) TK -Original Message- From:

RE: OT-SQL Data file issue

2004-01-05 Thread Eric Creese
I did that and got an error message telling me that the database names were different. think it was error 5173 -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 9:19 AM To: CF-Talk Subject: RE: OT-SQL Data file issue Ok, first try this::

RE: ActivePDF WebGrabber

2004-01-05 Thread Dave Watts
I can grab a url off of an external website and create pdfs but if I try and grab a url off of a site on our development server ActivePDF times out. ActivePDF, and web grabber are installed on our development server. I would think this might have something to do with the settings in

RE: OT-SQL Data file issue

2004-01-05 Thread Schuster, Steven
Just to verify... You had two files in your originals DATA directory, lets assume the path is E:\Program Files\Microsoft SQL Server\MSSQL\Data Ok, your two original files were Sample_DATA.MDF Sample_LOG.LDF You then deleted the LDF file on accident. Ok, so then you created a new

Re: automatically DL excel file with CF

2004-01-05 Thread Won Lee
At 03:47 PM 1/4/2004 -0500, you wrote: Hello CFers, I want to automate some information gathering. Nasdaq.com has a list of downloadable ticker symbols. The address is www.nasdaq.com//asp/symbols.asp?exchange=Qstart0 and www.nasdaq.com//asp/symbols.asp?exchange=Nstart0 I want my application to

RE: OT-SQL Data file issue

2004-01-05 Thread Eric Creese
Pretty close. I took SQL down. Copied the mdf file called abc_data.mdf to another directory. Brought SQL up. Dropped the database ABC. Created a new databse called ABC. I took SQL down. Copied the old abc_data.mdf from another directory and pasted it over the new abc_data.mdf. Brought SQL up.

RE: OT-SQL Data file issue

2004-01-05 Thread Schuster, Steven
Don't use the same name and try again. The suspect status may be tied to simply the db entry itself. Also, did you try sp_statusreset as well? -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:47 AM To: CF-Talk Subject: RE: OT-SQL

RE: OT-SQL Data file issue

2004-01-05 Thread Tony Weeg
after that did you run the reset sp? -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:47 AM To: CF-Talk Subject: RE: OT-SQL Data file issue Pretty close. I took SQL down. Copied the mdf file called abc_data.mdf to another directory.

RE: ActivePDF WebGrabber

2004-01-05 Thread Ryan Roskilly
Nope just tried that, so what this is a configuration issue on the server. Any idea on what to tell the Admin? Thanks -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:43 AM To: CF-Talk Subject: RE: ActivePDF WebGrabber I can grab a url

RE: OT-SQL Data file issue

2004-01-05 Thread Eric Creese
no -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 9:51 AM To: CF-Talk Subject: RE: OT-SQL Data file issue after that did you run the reset sp? -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 05,

RE: OT-SQL Data file issue

2004-01-05 Thread Eric Creese
ok I will try that and no I did not run sp_statusreset -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 9:52 AM To: CF-Talk Subject: RE: OT-SQL Data file issue Don't use the same name and try again. The suspect status may be tied to

RE: Password Logic

2004-01-05 Thread Matt Robertson
Mauricio's system is definitely a cut above many others, but as was pointed out it has a weakness.The email goes to a unique address, but you can't gaurantee the recipient is the actual user.You need to authenticate the person and not the address to take this a step further. I use the same system

Re: flash remoting help

2004-01-05 Thread Ryan Mitchell
Where would I find information about these? On 5/1/04 10:44 am, Adrian Lynch [EMAIL PROTECTED] wrote: You don't seem to have created a responder function in flash. Do you get an error message in Flash? Something along the lines, .no default responder..? If so, have a look

FCKeditor - who uses it ?

2004-01-05 Thread Daniel Farmer
Having a problem with FCKeditor...for file uploading it calls the aspx page...anyone know how to fix this? ~~ Daniel Farmer Coldfusion Developer / Sales / Producer 613.284.1684 ~~ [Todays Threads] [This Message] [Subscription] [Fast

OT: Does this price seem right?

2004-01-05 Thread Che Vilnonis
I'm looking to upgrade to CFMX...does this upgrade price seem too low??? CFMX - Standard Edition V.6.1 [$599.27 upgrade price.] http://www.cdw.com/shop/products/default.aspx?EDC=521249 TIA...Che [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: OT: Regular Expression

2004-01-05 Thread Kevin Marino
-Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 2:42 PM To: CF-Talk Subject: Re: OT: Regular _expression_ Kevin Marino wrote: Information,scheduler-0,12/29/03,15:41:19,,Mail: 'Report Examines U.S. Long-Term Care Spending'

HTTP Response codes

2004-01-05 Thread Howie Hamlin
Can ColdFusion be forced to send a particular HTTP response code?For an application that I have I need to send a 606 response when an error occurs. Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning,

Re: HTTP Response codes

2004-01-05 Thread Dirk De Bock - Lists
cfheader statuscode=606 would probably do what you want? - Original Message - From: Howie Hamlin To: CF-Talk Sent: Monday, January 05, 2004 5:57 PM Subject: HTTP Response codes Can ColdFusion be forced to send a particular HTTP response code?For an application that I have I need to

RE: CFSaveContent inside CFCatch?

2004-01-05 Thread Paul Kenney
Jeff, Can you replace cfdump var=#content# with cfdump var=#content.main# Also, what version of CF are you using? Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 8:08 PM To:

Re: OT: Regular Expression

2004-01-05 Thread Jochem van Dieten
Kevin Marino wrote: From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Information,scheduler-0,12/29/03,15:41:19,,Mail: 'Report Examines U.S. Long-Term Care Spending' From:'John Noone [EMAIL PROTECTED]' To:'[EMAIL PROTECTED]' was successfully sent using 192.168.5.186

SQL: Selecting Max Date Entries

2004-01-05 Thread Bryan F. Hogan
Hi All, I just got back from Vacation and I'm paying for it today. I have a bunch of entries in the database that have datetime values. What I want to do is return all the entries for a single month but only the max month and year. Example: 1/4/2004 1/3/2004 12/3/2003 12/1/2003 For the example

Re: HTTP Response codes

2004-01-05 Thread Howie Hamlin
That worked perfectly - thanks. Regards, Howie - Original Message - From: Dirk De Bock - Lists To: CF-Talk Sent: Monday, January 05, 2004 12:06 PM Subject: Re: HTTP Response codes cfheader statuscode=606 would probably do what you want? - Original Message - From: Howie

RE: HTTP Response codes

2004-01-05 Thread Mosh Teitelbaum
Howie: Use CFHEADER as in: CFHEADER STATUSCODE=606 STATUSTEXT=some descriptive text Note that ColdFusion seems to be preset for some status codes to ignore some or all of your customized headers.I don't know how it will respond to a custom status code. For more details, you can see a preso I

Re:FCKeditor - who uses it ?

2004-01-05 Thread Robert Cunningham
There is a file in the js directory named fck_config.js, in that js file you can change the settings to call the upload.cfm instead of the upload.aspx. Just uncomment the cfm line and comment out the aspx line. Robert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

Re: HTTP Response codes

2004-01-05 Thread Howie Hamlin
Thanks - this works fine on our IIS server (although it doesn't work on Website but that's not such a big deal). Regards, Howie - Original Message - From: Mosh Teitelbaum To: CF-Talk Sent: Monday, January 05, 2004 12:29 PM Subject: RE: HTTP Response codes Howie: Use CFHEADER as in:

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread MILAN MUSHRAN
If you are trying to get the highest date value in the database - use this query: SELECT max(DateColumnName) FROM TableName But, If you are trying to get the highest date value in the database for every year - use this query: SELECT max(DateColumnName) FROM TableName GROUP BY

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Bryan F. Hogan
What I want to do is something like below. select * from table where month(postdatetime)=max(month(postdatetime)) and year(postdatetime)=max(year(postdatetime)) I want the current months entries. But if there is no entries I want it to display the previous months entries. I only want it to

re: OT: Does this price seem right?

2004-01-05 Thread Scott Brady
Original Message: From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: OT: Does this price seem right? Date: Mon, 5 Jan 2004 11:38:14 -0500 I'm looking to upgrade to CFMX...does this upgrade price seem too low??? CFMX - Standard Edition V.6.1 [$599.27 upgrade

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Ian Skinner
SELECT * FROM table WHERE DateCol = (SELECT MAX(DateCol) FROM Table) HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:10 AM To: CF-Talk

RE: flash remoting help

2004-01-05 Thread Adrian Lynch
Give google a bash for a load of info. http://www.google.com/search?hl=en http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=flash+remoting+respo nderbtnG=Google+Search ie=UTF-8oe=UTF-8q=flash+remoting+responderbtnG=Google+Search To get your code below to work try adding this method.

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Schuster, Steven
You may want to create a Sp if in SQL or a Package in Oracle to do this. That way if no rows are returned by the default date you can do the previous month in code rather than making CF do it with loops and all that jaz. Just saves the processing baby!!! http://intranet Stephen E. Schuster

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Bryan F. Hogan
Thanks Ian, but how do I get it to ignore the time portion? -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 1:21 PM To: CF-Talk Subject: RE: SQL: Selecting Max Date Entries SELECT * FROM table WHERE DateCol = (SELECT MAX(DateCol) FROM Table)

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Ian Skinner
Or if you want all the records for the max month (not just the max date) SELECT * FROM table WHEREmonth(DateCol) = (SELECT month(MAX(DateCol)) FROM Table) AND year(DateCol) = (SELECT year(MAX(DateCol)) FROM Table) Not sure of the syntax on this one.The month and year functions may need to

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Bryan F. Hogan
I've seen it done with straight SQL, but can't remember where. CF is out of the question for this. -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 1:29 PM To: CF-Talk Subject: RE: SQL: Selecting Max Date Entries You may want to create a

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Schuster, Steven
MAX of a date field to ignore time, why would you want it to do this? That would be tricky, I guess you could trunc the date field or something, or use the format command. But wouldn't you want the time piece in the comparison since 10/12/2004 at 3 PM is before 10/12/2004 at 5 PM? Excuse the

RE: OT: Does this price seem right?

2004-01-05 Thread Che Vilnonis
thanks scott. much appreciated... -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 1:10 PM To: CF-Talk Subject: re: OT: Does this price seem right? Original Message: From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject:

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Bryan F. Hogan
Perfect, the below works! Thanks! -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 1:30 PM To: CF-Talk Subject: RE: SQL: Selecting Max Date Entries Or if you want all the records for the max month (not just the max date) SELECT * FROM

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Bryan F. Hogan
It makes sense because I want all entries in the month no matter the time. If there where no entries for a month I don't want the site to display no entries, I want it to display the entries for last month that has entries. That way there will always be entries shown. The below works. SELECT*

RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Schuster, Steven
Now that makes more senseI thought you were trying to do same Date - 1 month thing based on an earlier post. My bad. http://intranet Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 -Original

Re:cfm won't work in combination of other isapi.dll

2004-01-05 Thread Willy Otto
Dear Paul, I amazed to hear it would be that simple(for turning it into a CFX tag). Because i'm not a programmer for languages like Delphi I wouldn't know if I had access to the source code. If you could explain how to do that, but i don't believe it's that simple? Willy If it's written in

Count Orders by Month - Help

2004-01-05 Thread Bailey, Neal
Hey guys, I need a little direction... I am trying to count orders placed for each month. I have an EnteredDate field and all I am trying to do is display/count how many orders were placed for each particular month. For some reason I cannot get this to work. I am using SQL and MX 6.1.

RE: cfm won't work in combination of other isapi.dll

2004-01-05 Thread Paul Vernon
There is a CFX_API downloadable for free for Delphi that allows you to interface directly into Cold Fusion like C++. I use it on a pretty much daily basis and I've written such tags as CFX_CharConv, CFX_IMAP4 , CFX_Query2File, CFX_WhoIs, CFX_POP3, CFX_ReadLn. The API is available for free and is

Re:cfm won't work in combination of other isapi.dll

2004-01-05 Thread Willy Otto
Dear Dave, That's right: if i call pages trough CFHTTP, the weirdest things happens: for example: there is a function that generates a html table with meters and values, if i call that page trough CFHTTP, the table will be generated but not the data in it. Another example you can try yourself:

RE: Count Orders by Month - Help

2004-01-05 Thread Robert Segal
Depending on the database you are using, you can use the built in functions. For example, in MS SQL Server you do this: SELECTCOUNT(*) AS THECOUNT, MONTH(EnteredDate) AS THEMONTH, year(EnteredDate) AS THEYEAR FROMORDER GROUP BY YEAR(EnteredDate), MONTH(EnteredDate) To get a list of the year,

RE: Count Orders by Month - Help

2004-01-05 Thread Kevin Marino
Neal, Book Recommendation :Sams Teach Yourself SQL in 21 Days: http://www.amazon.com/exec/obidos/tg/detail/-/0672324512/qid=1073328907//ref =sr_8_xs_ap_i3_xgl14/104-5044138-6895159?v=glance http://www.amazon.com/exec/obidos/tg/detail/-/0672324512/qid=1073328907//re

Flash question - newbie

2004-01-05 Thread Stephen Hait
I'm interested in learning about developing applications on CFMX that utilize Flash but I confess I'm confused as to what I would need to do this. There seem to be various products; Flash MX 2004, Flash MX Pro 2004 and Studio MX 2004 with Flash Pro, etc. that might do this. What's the minimum

RE: Adding remote datasource dynamically

2004-01-05 Thread Christine Lawson
Hi, I received an e-mail from Don regarding this and just wanted to post a response from Macromedia on this topic. There are no documented ways that are supported for on the fly dsn creation in MX. There are ways to do this through the service factory but that is not supported as we could change

Re:cfm won't work in combination of other isapi.dll

2004-01-05 Thread Willy Otto
Dear Paul, If i get it right, this is an example on how it would work as an CFX tag, right? I surely will take a look at it and try to convince the Delphi programmer to take a look at it and try it out. I really appreciate your interest and help on this issue. Willy There is a CFX_API

Re: Flash question - newbie

2004-01-05 Thread Clint Tredway
The only 2 tools you need Flash MX 2004 Professional and Sapien's PrimalScript www.sapien.com. There are a couple of good books to get you going: Macromedia Flash MX 2004 ActionScript: Training from the Source

XPath expr to get all attributes....how?

2004-01-05 Thread Nikhil Madani
I have a XML file that looks like this (actually fusebox.xml file from FB4, for those who are familiar) circuit fuseaction name=somename .. /fuseaction . . /circuit I need to get a list of all the attribute values for name into an array. Right now, I'm using the xpath _expression_ /circuit/[EMAIL

RE: XPath expr to get all attributes....how?

2004-01-05 Thread Bryan F. Hogan
I don't know of another way currently other than creating a string variable in XSL and looping in XSL and appending each attribute name value to the string comma delimited and then running listToArray on that string. The way your doing it is fine. You may also want to see if this site has an

RE: XPath expr to get all attributes....how?

2004-01-05 Thread Samuel R. Neff
The CFMX implementation only supports returning an array of elements, not attributes. Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message-

Good CFMX book?

2004-01-05 Thread Phillip B
I am going to upgrade a server to MX from CF 5. Can some one recommend a book for CFMX that will help me through the process? Thank you. Thank you very much. Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Good CFMX book?

2004-01-05 Thread Bryan Stevenson
Phillip I'd say read the upgrade instructions and release notes on the MM site and yer good to goIMHO a book is overkill just to upgrade to MX ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]

Re: Flash question - newbie

2004-01-05 Thread Stephen Hait
How does Flash Remoting fit into the equation? Or does it? Stephen The only 2 tools you need Flash MX 2004 Professional and Sapien's PrimalScript www.sapien.com. What's the minimum software requirement for developing Flash apps? What would be the benefits of alternatives to the minimum?

Re:Password Logic

2004-01-05 Thread John Ho
I have plaintext password in database sometimes I want to use hash to encript the password. But I have problem with the password field in database. Its has check constraint to check all the require characters for the valid password. I dont like to drop this check constraint. How do I fix this

Re: Flash question - newbie

2004-01-05 Thread Nick de Voil
Clint The only 2 tools you need Flash MX 2004 Professional and Sapien's PrimalScript www.sapien.com. What's the minimum software requirement for developing Flash apps? What would be the benefits of alternatives to the minimum? Why is PrimalScript part of the minimum requirement?

CFFunction Question

2004-01-05 Thread Bill Grover
Oh Great Guru's! I'm sure the solution is simple but I can't seem to find the answer.Basically how do you call a cffunction with only some of the arguments? I have the following function: cffunction name=fImageCol output=Yes cfargument name=tcItemNumberrequired=No default= cfargument

Re:FCKeditor - who uses it ?

2004-01-05 Thread Dwayne Cole
Is there a custom tag for FCKeditor? There is a file in the js directory named fck_config.js, in that js file you can change the settings to call the upload.cfm instead of the upload.aspx. Just uncomment the cfm line and comment out the aspx line. Robert [Todays Threads] [This Message]

RE: CFFunction Question

2004-01-05 Thread Raymond Camden
Use x=y notation: cfset result = someFunction(arg=value, arg2=value, arg3=value) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: CFFunction Question

2004-01-05 Thread Bryan F. Hogan
Just use the name of the function fImageCol(tcLinkType=yourValue, tcLinkDesc=yourValue) -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:52 PM To: CF-Talk Subject: CFFunction Question Oh Great Guru's! [Todays Threads] [This Message]

RE: Flash question - newbie

2004-01-05 Thread chris kief
At a minimum, Flash Pro with or without the studio (not sure if you need that extra stuff) and the free developer version of CFMX (which comes with Flash Remoting). You could get away with the standard version of Flash but the additional components and integrated AS editor in Pro make it worth

RE: CFFunction Question

2004-01-05 Thread Bill Grover
I changed the calling code to: cfset lcLink = REQUEST.fImageCol(tcItemNumber = KitItems.CarrierInv, tcLinkType = APPLICATION.cJobImgLinkType, tcLinkDesc = APPLICATION.cJobImgLinkDesc) td class=details_center#lcLink#/td Now I get the message: Cannot invoke method fImageCol on an object of type

RE: CFFunction Question

2004-01-05 Thread Bill Grover
If I use the code I just e-mailed in response to Raymond's answer but drop the REQUEST. I get LCLink is underfined __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX:

Re: Flash question - newbie

2004-01-05 Thread Clint Tredway
It's not really, but its a much better editor with a class browser for AS2... Plus it has some good CF stuff and it just plain rocks. Nick de Voil wrote: Clint The only 2 tools you need Flash MX 2004 Professional and Sapien's PrimalScript www.sapien.com. What's the minimum

Re: Flash question - newbie

2004-01-05 Thread Clint Tredway
to use any of the new data components, you have to get the pro version. AFAIK you can use FMX 2004 with remoting, but not to the extent as you can with the Pro version. Stephen Hait wrote: How does Flash Remoting fit into the equation? Or does it? Stephen The only 2 tools you need Flash

RE: CFFunction Question

2004-01-05 Thread Raymond Camden
In your code example, I did not see an argument named tcItemNumber. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: CFFunction Question

2004-01-05 Thread Bryan F. Hogan
Place pounds around your variables. -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 4:05 PM To: CF-Talk Subject: RE: CFFunction Question I changed the calling code to: cfset lcLink = REQUEST.fImageCol(tcItemNumber = KitItems.CarrierInv,

  1   2   >