RE: javascript select menu question
Hi, I need to adapt the code below which works ok.It consists of two select boxes where one is populated based on what is chosen in the other. What I need is to show all the items in the second select menu when none of the options from the first select menu has been chosen. What is the best way of changing the below to achieve this? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: scheduled task fails to run
I have set up a scheduled task to run on CF5 and though it runs fine when I hit 'Go' in the administrator, it does not set off when its supposed to. I first set it daily at 16.00 but has failed to run after a day.I then triedDaily every5 minutes, from 14.00.00 to 18.00.00 but this hasn't run today so far. I have searched forums but have found no specific answer. Is this a known issue and if so how can it be resolved, preferably within coldfusion. Thanks, Declan _ http://www.houseoffusion.com/banners/view.cfm?bannerid=39 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: scheduled task fails to run
Solved that problem. Was using eurodate format while administrator using US Date Format. Cheers, Declan -Original Message- From: Declan Maher Sent: 15 April 2004 16:03 To: CF-Talk Subject: RE: scheduled task fails to run I have set up a scheduled task to run on CF5 and though it runs fine when I hit 'Go' in the administrator, it does not set off when its supposed to. I first set it daily at 16.00 but has failed to run after a day.I then triedDaily every5 minutes, from 14.00.00 to 18.00.00 but this hasn't run today so far. I have searched forums but have found no specific answer. Is this a known issue and if so how can it be resolved, preferably within coldfusion. Thanks, Declan _ http://www.houseoffusion.com/banners/view.cfm?bannerid=39 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: db error
Could be a number of reasons. What database are you using?
Try
cfquery name=update_funds datasource=#request.dsn#
insert into fundprevious
{
thisday,
fundid,
fundvalue,
timeofchange
}
values
{
#thisfundday#,
#get_funds.fundid#,
'#previousValue#',
#CreateODBCDate( Now())#
}
/cfquery
-Original Message-
From: David Ashworth [mailto:[EMAIL PROTECTED]
Sent: 22 March 2004 11:29
To: CF-Talk
Subject: db error
Morning,
I keep getting the following error when trying to update a database,
haven't had any problems when doing this before but this error is
peristent and I can't work out what the problem is:
It appears to be a problem with the query as opposed to the data, the
query is as follows:
!--- save current value into previous value ---
cfquery name=update_funds datasource=#request.dsn#
insert into fundprevious
{
thisday,
fundid,
fundvalue,
timeofchange
}
values
{
#thisfundday#,
#get_funds.fundid#,
'#previousValue#',
#Now()#
}
/cfquery
which gives this error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
SQL = insert into fundprevious { thisday, fundid, fundvalue,
timeofchange } values { 1, 3, '5', {ts '2004-03-22 11:28:38'} }
Data Source = FUNDMANAGER
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (27:2) to (27:57) in the
template file
D:\INETPUB\WWWROOT\FUNDMANAGER\ADMIN\FUND\ACT_UPDATESTOCK.CFM.
any thoughts?
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Form Fields Disappearing
Is there just one form submitting from one form or from multiple forms/pages in site? If you've ruled out this then ensure the enctype and method in the form are set correctly. I had problems with these before. -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 1:59 PM To: CF-Talk Subject: Form Fields Disappearing Has anyone experienced the problem with form fields from the previous page disappearing on the processing page in a post action?Every now and then, our users get an error when they are submitting a form and it was because all the form fields had disappeared. We know this because we have top-level error handler, which shoots us an email with all the diagnostic information such as url and form variables, all the cgi variables, and everything in the catch and error structs. I am baffled by this.I couldn't duplicate this error at all.Could be it a bug in CF5? Apparently, someone sort of had the same problem before. http://www.houseoffusion.com/cf_lists/cache.cfm/4/15/15824.htm Can somebody confirm this that it is really a CF5 bug? Nick Han Nick Han _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DateDiff and MS Access
Select * fromTABLE whereinvoice_date BETWEEN#CreateODBCDate(Now())# and #Createodbcdate(Dateadd(d,30,DateFormat(now(# -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 25 January 2004 16:57 To: CF-Talk Subject: DateDiff and MS Access In an access db I have a table with a colum in it called startDate. What I would like to do Is return all the records in the table where the difference between the startDate and the current date (Date() or now()) is 30 days, or whatver number of days for that matter What would be the easiest way to do this? Thanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Retaining Database Row Locks Across User Requests
A great site for oracle stufflike this is : http://asktom.oracle.com/ Theres a great search engine and Tom seems to spend a lot of his time answering questions. -Original Message- From: Ryan Geesaman [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 04:46 PM To: CF-Talk Subject: Retaining Database Row Locks Across User Requests We are using CFMX 6.1 and Oracle 9i.How do we retain database row locks from one request (query of information to display in a HTML form) to the next (updating the information)?Data integrity is the concern of course...how to keep two users from updating the same record from the database at the same time. I've been trying to use SELECT...FOR UPDATE without any success. Thanks, Ryan A. Geesaman Applications Developer Penn State College of Medicine Health Evaluation Sciences _ [ Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Export to Excel - only alternate rows exported WHy?...
I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Caching until updated
This (below) won't refresh the query. It'll merely take the data from
the cache.
To update the query do the following.
Flushing Cached Queries
You can immediately refresh the queries that use the cachedwithin or
cachedafter attribute by inserting all zero values in the
CreateTimeSpan( ) function, as shown here:
cfquery name=qGetCountry datasource=devnet
cachedwithin=#CreateTimeSpan(0,0,0,0)#
SELECT CountryID, CountryName
FROMCountry
ORDER BYCountryName
/cfquery
Here's a good article on caching:
http://www.macromedia.com/devnet/mx/coldfusion/articles/cfcaching.html
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 30 July 2003 10:33 PM
To: CF-Talk
Subject: RE: Caching until updated
I think you can reset a query that is using cachedwithin (or
cachedafter) by
just running the exact same query without the parameter. This should
resets
it.
For example on most of your processing pages you may have something like
this silly example.
cfquery name=Days datasrouce=dsn cachedwithin(createTimeSpan(7,0,0,0))
SELECT DAYS
FROM WEEKS
WHERE LANGUAGE = ENGLISH
/cfquery
If you wanted to refresh this, for whatever reason in your update
process
after inserting, updating or deleting information in the table run the
query
without the cached param.
cfquery name=Days datasrouce=dsn
SELECT DAYS
FROM WEEKS
WHERE LANGUAGE = ENGLISH
/cfquery
--
Ian Skinner
Web Programmer
BloodSource
Sacramento, CA
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 10:13 AM
To: CF-Talk
Subject: RE: Caching until updated
I have -never- used cachedafter simply because I have not had a need for
it. I either use cachedWIthin to get 'cache for N time' or I cache in
the application (or some other) scope.
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Cedric Villat [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 10:56 AM
To: CF-Talk
Subject: Caching until updated
Raymond,
On a side note, would it be better to use cfquery's
cachedwithin or cachedafter instead of having to take care of
the cache myself? If so, how would I do that?
Cedric
I'd watch out using local variable name w/ the same name as the
method. You should probably use another name and var scope
it. Also, in
general, I wouldn't directly access the application scope
from within
the CFC. What if you want to use the server scope instead? It would
make more sense to just use:
cfset application.myEntries = theCFC.getEntries(...)
Or at least use another CFC to abstract where the caching is done.
=
==
=
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia
(http://www.macromedia.com/go/teammacromedia)
Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 10:41 AM
To: CF-Talk
Subject: RE: Caching until updated
cffunction name=getEntries returntype=query
cfargument name=updateCache required=true default=1
cfif not IsDefined('Application.myEntries') or
Arguments.updateCache
cfquery name=getEntries
SELECT *
FROMEntriesTable
/cfquery
cfset Application.myEntries=getEntries
/cfif
cfreturn Application.myEntries
/cffunction
On your update entry page just do
mycfc.getEntries(1|0)
-Original Message-
From: Cedric Villat [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 12:46 PM
To: CF-Talk
Subject: Caching until updated
I'm sure there is a way to do this, I just can't seem to
think through it. Basically, I have a table which isn't going
to change much. Instead of pulling this information from the
database, I'd like to cache the query in the Application
scope. But when a record IS added to that table, I would like
to reset the cached version to include the change.
Basically, how can I cache something until I know the records
it contains changes? If it helps, I'm using CFC's and can
easily do this in the INSERT function, just can't figure it
out. Any help?
Cedric
~|
Archives:
RE: Export to Excel - only alternate rows exported WHy?...
Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Export to Excel - only alternate rows exported WHy?...
Can view the output before passing it to the custom tag. The query which generates the data is an include file as below.When I view the include file the data is all correct. But when I view the output using the tag it only returns every second row. cf_html2Excel sheetname=report Directory=#thedirectory#\exceltemp\ CFSET EXCEL=1 -- cfinclude template=high_grade_excel.cfm /CF_HTML2Excel CFHEADER NAME=Content-Disposition VALUE=inline;filename=customsearch.xls CFCONTENT TYPE=application/unknown FILE=#ExcelFile# DELETEFILE=Yes -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 01:12 PM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Can you view the output before passing it to the custom tag? If not can you replicate the code in the custom tag which creates the table and view the html generated? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:39 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... Kola, Here's how it does it. This custom tag creates a dynamic Excel file from the generated content of a block of ColdFusion code. The generated content is first saved as an HTML file. Then it is opened in Excel and saved with the .xls extension. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 11:18 AM To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I'm not sure how that custom tag works. Does it take a html table and convert it into an excel spreadsheet? If so does the original have alternate row colours? Kola -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 10:43 To: CF-Talk Subject: RE: Export to Excel - only alternate rows exported WHy?... I am exporting to excel using the custom tag cf_html2Excel. Although all the correct data shows on the include page I am using, in other words the query that selects the data is correct, when I actually do the export all that shows in excel is every second row. Any help would be apprectiated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Rounding numbers in coldfusion
I am using a float datatype in the database and calculating some numbers on the page. The calculation seems to round up the numbers to the nearest integer, even when I use numberformat or decimal format. How can I prevent it doing this? Example below cfif isdefined(P90) and P90 gt 0 cfif FindNoCase(gas,#Type#) cfset P90x= #Evaluate(P90/6)# cfset totalP90=totalP90 + P90x cfelse cfset totalP90=totalP90 + P90 /cfif /cfif __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rounding numbers in coldfusion
Figured it out. Thanks anyway!! -Original Message- From: Declan Maher Sent: 24 September 2002 14:40 To: CF-Talk Subject: Rounding numbers in coldfusion I am using a float datatype in the database and calculating some numbers on the page. The calculation seems to round up the numbers to the nearest integer, even when I use numberformat or decimal format. How can I prevent it doing this? Example below cfif isdefined(P90) and P90 gt 0 cfif FindNoCase(gas,#Type#) cfset P90x= #Evaluate(P90/6)# cfset totalP90=totalP90 + P90x cfelse cfset totalP90=totalP90 + P90 /cfif /cfif __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Resource for upgrading errors on going from coldfusion 5 to CFMx
Can anybody point to a resouces for figuring out why errors are occuring in the upgrade from cf5 to CFMX? e.g. the evaluate function The Error Occurred in D:\dev.nobleenergy-nepat.com\www_root\input\newscardaction.cfm: line 58 56 :/cfif 57 : WHERE prospects_id = #evaluate(form.prospects_id)# 58 : /cfquery 59 :/cfif 60 : eg. the valuelist function he Error Occurred in D:\dev.nobleenergy-nepat.com\www_root\schedule\add1.cfm: line 360 358 : 359 : trtdnbsp;/td/tr 360 : cfset list_stage=ValueList(Stage.showtypeid) 361 : regards, declan __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:Dynamic Layers
I am attempting to build a dynamic scheduling system. At the moment I have a system based over time where a user can enter colours for a particular number of months to reflect when an action took place. So say you had spent 3 months doing a certain task you input the start date and end date, select the task and output this with an appropriate color over a timespan of say 4 years. What the client is now looking for is to add another layer on top of this with certain symbols. Say exam date or finish of term date. What I need to do, if possible is output a second layer on top of the existing table. What I am looking to do is use layers to put this top layer in the correct table cell. Can anybody help or point to any resources that could be of help? Thanks for any help Declan -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: 27 May 2002 04:21 To: CF-Talk Subject: RE: Bytes to MB/GB conversion tag? LOL THANK YOU!!! -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 26, 2002 1:51 PM To: CF-Talk Subject: Re: Bytes to MB/GB conversion tag? Neil Clark - =TMM= wrote: 1 MB = 1024KB. You're wrong :) 1 MB = 1000 kB = 100 B 1 Mi = 1024 Ki = 1048576 B http://physics.nist.gov/cuu/Units/binary.html Jochem __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: querying an xls file
Go to http://www.cfcomet.com/cfcomet/excel/ and check out the -- Use Excel files as datasources -- basic to advanced section. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 18 April 2002 10:08 To: CF-Talk Subject: querying an xls file Greetings, could anyone advice me what would be the best way to extract data from, an excel xls file, I want to extract each column from each row and insert it into a DSN. I've done something similar before with a txt file, I used CFFILE READ, gave it a variable name looped through the varname and extracted my data using CFSET newLine=Chr(13) Chr(10) as the loop delimeter, but I think xls is slightly different format. Could there possibly be a custom tag for this, any advice would be greatly appreciated, Respectfully, J __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Cert?
I took both. The differences are with the BB one you can keep your books and studio open if you want to and nobody knows so it may not be worth the paper its written on. If you do it genuinely then it is a difficult exam (CF4 version). You are asked unusual questions of stuff you may never have used. I certainly had never come across some of the stuff before. The official CF exam (CF5) is more straightforward. Hardly any ridiculous questions and a better reflection of whats important to know.I studied using: Ben Forta's Developer Study Guide which is essential and the Coldfusion Web Application Construction Toolkit. CF_buster http://www.centrasoft.com/default.cfm -This is fairly comprehensive series of tests similar to the real test. There are some tests on http://www.cfcertification.com/ and also www.forta.com. Take as many tests as you can. After all this I had 1.5 years experience at the time of taking and got the Advanced Cert. Regards, Declan -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: 11 April 2002 07:25 To: CF-Talk Subject: RE: Coldfusion Cert? Has anyone taken both the MM CF Cert and the BB CF Cert? If so, what are (if any) the differences? TIA -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:52 PM To: CF-Talk Subject: RE: Coldfusion Cert? If I recall the tests are still free but it's like 8 bucks to get the paper certificate mailed to you. I could be wrong I'm going off memory. Great site. J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:38 PM To: CF-Talk Subject: Re: Coldfusion Cert? Yeah it is free right now, I just took it. Only scored a 3.0 I guess I need to study some more Success is a journey, not a destination!! Doug Brown - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 5:30 PM Subject: RE: Coldfusion Cert? Its not free anymore, although I do recommend taking a look at it nonetheless. (Its cheaper, and won't hurt your resume). I thought that the Brainbench test (last time I took it) was fairly heavy on Stored Procedures and Web protocols without enough emphasis on ColdFusion. At 03:31 PM 4/10/2002 -0700, you wrote: I would recommend taking a look at brainbench.com :) They have a free CF5 cert test. You can use it as a prep. http://www.brainbench.com David Schmidt __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Suggestion for a good message forum to add to our CF SITE
I like this one: http://www.cfcode.com/cfforum2000/index.cfm -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: 11 April 2002 03:46 To: CF-Talk Subject: Re: Suggestion for a good message forum to add to our CF SITE Direct link: http://www.quilldesign.com/qdforums/index.cfm Sorry! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 9:42 PM Subject: Re: Suggestion for a good message forum to add to our CF SITE Take a look at QD Forums, they are cheap and pretty feature rich! http://www.quilldesign.com I think they are pretty good .. but then again I am kinda bias'd! Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder I've searched around and have found a large number of message forums that we can add to our CF web site and integrate well with our MS SQL DB. However I'd like to read some reviews or get some first hand opinions on which products are well recommend and people have had good experiences using. Some of the products I've short listed include: IKONBOARD, Vbulletin, CFFORUM, SIMPLE MESSAGE BOARD, FUSETALK, FORUMSPOT or WWWTHREADS. Can anyone suggest a good, free (or low cost product) that we can use to add a discussion forum to our web site? Any first hand recommendations would be really appreciated. Thanks. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Cert?
Brainbench Certification(tm) Test Overview Your Brainbench Certification(tm) test includes the following test modules: ColdFusion 5 For each Standard Skills Assessment, you will receive 40 questions. Each question is multiple choice with five choices. You must select the one best answer from the 5 choices in order to score a correct answer. You will have 180 seconds to answer each question. The time remaining for each question is displayed in the status bar at the bottom of your browser. If the time remaining falls below 30 seconds, the system will alert you with a warning message. If time expires on any question, that question will -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: 11 April 2002 12:46 To: CF-Talk Subject: RE: Coldfusion Cert? How many questions does the BrainBench exam have? I you don't mind me asking. Yves -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: April 11, 2002 6:04 AM To: CF-Talk Subject: RE: Coldfusion Cert? I took both. The differences are with the BB one you can keep your books and studio open if you want to and nobody knows so it may not be worth the paper its written on. If you do it genuinely then it is a difficult exam (CF4 version). You are asked unusual questions of stuff you may never have used. I certainly had never come across some of the stuff before. The official CF exam (CF5) is more straightforward. Hardly any ridiculous questions and a better reflection of whats important to know.I studied using: Ben Forta's Developer Study Guide which is essential and the Coldfusion Web Application Construction Toolkit. CF_buster http://www.centrasoft.com/default.cfm -This is fairly comprehensive series of tests similar to the real test. There are some tests on http://www.cfcertification.com/ and also www.forta.com. Take as many tests as you can. After all this I had 1.5 years experience at the time of taking and got the Advanced Cert. Regards, Declan -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: 11 April 2002 07:25 To: CF-Talk Subject: RE: Coldfusion Cert? Has anyone taken both the MM CF Cert and the BB CF Cert? If so, what are (if any) the differences? TIA -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:52 PM To: CF-Talk Subject: RE: Coldfusion Cert? If I recall the tests are still free but it's like 8 bucks to get the paper certificate mailed to you. I could be wrong I'm going off memory. Great site. J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:38 PM To: CF-Talk Subject: Re: Coldfusion Cert? Yeah it is free right now, I just took it. Only scored a 3.0 I guess I need to study some more Success is a journey, not a destination!! Doug Brown - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 5:30 PM Subject: RE: Coldfusion Cert? Its not free anymore, although I do recommend taking a look at it nonetheless. (Its cheaper, and won't hurt your resume). I thought that the Brainbench test (last time I took it) was fairly heavy on Stored Procedures and Web protocols without enough emphasis on ColdFusion. At 03:31 PM 4/10/2002 -0700, you wrote: I would recommend taking a look at brainbench.com :) They have a free CF5 cert test. You can use it as a prep. http://www.brainbench.com David Schmidt __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Cert?
You know that the Coldfusion 5 exam is free on brainbench.com. So you can take it anytime you like -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: 11 April 2002 13:11 To: CF-Talk Subject: RE: Coldfusion Cert? Thanks, I don't have alot of experience yet, but I may write it soon to get an idea of what I should work on Yves -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: April 11, 2002 8:54 AM To: CF-Talk Subject: RE: Coldfusion Cert? Brainbench Certification(tm) Test Overview Your Brainbench Certification(tm) test includes the following test modules: ColdFusion 5 For each Standard Skills Assessment, you will receive 40 questions. Each question is multiple choice with five choices. You must select the one best answer from the 5 choices in order to score a correct answer. You will have 180 seconds to answer each question. The time remaining for each question is displayed in the status bar at the bottom of your browser. If the time remaining falls below 30 seconds, the system will alert you with a warning message. If time expires on any question, that question will -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: 11 April 2002 12:46 To: CF-Talk Subject: RE: Coldfusion Cert? How many questions does the BrainBench exam have? I you don't mind me asking. Yves -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: April 11, 2002 6:04 AM To: CF-Talk Subject: RE: Coldfusion Cert? I took both. The differences are with the BB one you can keep your books and studio open if you want to and nobody knows so it may not be worth the paper its written on. If you do it genuinely then it is a difficult exam (CF4 version). You are asked unusual questions of stuff you may never have used. I certainly had never come across some of the stuff before. The official CF exam (CF5) is more straightforward. Hardly any ridiculous questions and a better reflection of whats important to know.I studied using: Ben Forta's Developer Study Guide which is essential and the Coldfusion Web Application Construction Toolkit. CF_buster http://www.centrasoft.com/default.cfm -This is fairly comprehensive series of tests similar to the real test. There are some tests on http://www.cfcertification.com/ and also www.forta.com. Take as many tests as you can. After all this I had 1.5 years experience at the time of taking and got the Advanced Cert. Regards, Declan -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: 11 April 2002 07:25 To: CF-Talk Subject: RE: Coldfusion Cert? Has anyone taken both the MM CF Cert and the BB CF Cert? If so, what are (if any) the differences? TIA -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:52 PM To: CF-Talk Subject: RE: Coldfusion Cert? If I recall the tests are still free but it's like 8 bucks to get the paper certificate mailed to you. I could be wrong I'm going off memory. Great site. J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:38 PM To: CF-Talk Subject: Re: Coldfusion Cert? Yeah it is free right now, I just took it. Only scored a 3.0 I guess I need to study some more Success is a journey, not a destination!! Doug Brown - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 5:30 PM Subject: RE: Coldfusion Cert? Its not free anymore, although I do recommend taking a look at it nonetheless. (Its cheaper, and won't hurt your resume). I thought that the Brainbench test (last time I took it) was fairly heavy on Stored Procedures and Web protocols without enough emphasis on ColdFusion. At 03:31 PM 4/10/2002 -0700, you wrote: I would recommend taking a look at brainbench.com :) They have a free CF5 cert test. You can use it as a prep. http://www.brainbench.com David Schmidt __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WebTrends uniqe visitors stat
Just confirming that you are correct in saying that webtrends tracks by IP address for each unique user, so it is inaccurate if you have multiple users coming from behind a proxy server. They won't be shown. We had a student app that was showing loads of hits but a ridiculously low number of unique users. This was the reason. Regards, Declan -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: 01 April 2002 21:56 To: CF-Talk Subject: Re: WebTrends uniqe visitors stat Years ago we used WebTrends and they included an ISAPI filter that sent users a cookie solely for tracking purposes. The cookie contents were logged in the IIS logs. This is the only way to really identify unique visitors. If you don't see Webtrends cookies in your log files, then you're correct - it's just using IP addresses. Transparent proxy servers, cookie-blocking firewalls are just a couple of things that will skew those numbers. There's a pretty big debate in online advertising circles regarding the unique visitor numbers being reported by web sites. They're waking up to the fact that the data is so bad that it's almost meaningless. Jim - Original Message - From: BEN MORRIS [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 1:38 PM Subject: OT: WebTrends uniqe visitors stat Does anyone know precisely how the unique visitors statistic is determined in web trends? Is it the number of unique IP addresses that hit the site? Looking through the log file, the only thing I could find to differentiate between users is the client IP address, but that is imperfect as users behind a proxy would be counted as the same person. TIA --- Ben Morris Web Site Developer American Federation of Government Employees, AFL-CIO (202) 639-6448 www.afge.org __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Internationalization
I think the term you are looking for is ..localisation or localization (US). -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: 29 March 2002 14:04 To: CF-Talk Subject: Internationalization We are makers of SiteDirector a commerce application and are getting ready to move it towards internationalization (if that is the correct term). We have many customers who are requesting if SiteDirector supports other languages, currency and so forth. Well it doesn't.. but we want it to! To be honest, I am fairly clueless on where to start, but willing to learn. Does anyone out there know of any good resources to view/read on what steps need to take place .. (ie languages, currency ..and other concerns?). Any help or pointing in the right direction will be most appreciated! Thank you Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
Joshua, If you look at www.cfcomet.com or http://www.cfcomet.com/cfcomet/sql_server/ it shows how to execute SQL Server DTS packages from ColdFusion. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 17:10 To: CF-Talk Subject: SQL Question Besides using xp_cmdshell does any know how to execute a dts package from a stored procedure? Joshua Tipton __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
Sorry didn't read your question right -Original Message- From: Declan Maher Sent: 26 March 2002 17:13 To: CF-Talk Subject: RE: SQL Question Joshua, If you look at www.cfcomet.com or http://www.cfcomet.com/cfcomet/sql_server/ it shows how to execute SQL Server DTS packages from ColdFusion. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 17:10 To: CF-Talk Subject: SQL Question Besides using xp_cmdshell does any know how to execute a dts package from a stored procedure? Joshua Tipton __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Two related drop-downs
Check out http://www.webtricks.com/SourceCode/
Heres the code. If you need further details go there.
!--- Select the states and area codes. ---
CFQUERY DATASOURCE = States NAME = GetStates
SELECT S.State, S.StateCode, AC.AreaCode
FROM States S, AreaCodes AC
WHERE S.StateCode = AC.StateCode
ORDER BY S.State, AC.AreaCode
/CFQUERY
!--- Select all the area codes. ---
CFQUERY DATASOURCE = States NAME = GetCodes
SELECT AreaCode
FROM AreaCodes
ORDER BY AreaCode
/CFQUERY
SCRIPT LANGUAGE = JavaScript
!--
// For each state, create an array to hold the area codes.
// Each state array will be identified by the two-character
state abbreviation
CFOUTPUT QUERY = GetStates GROUP = State
// Create the array
StateArray#StateCode# = new Array();
CFSET i = 0
// Populate the array
CFOUTPUT
CFSET i = i + 1
StateArray#StateCode#[#i#] = #AreaCode#;
/CFOUTPUT
/CFOUTPUT
// Function to populate the area codes for the state selected
function PopulateAreaCode()
{
// Only process the function if the first item is not
selected.
if (document.StateForm.StateCode.selectedIndex != 0)
{
// Find the state abbreviation
var ThisState =
document.StateForm.StateCode[document.StateForm.StateCode.selectedIndex]
value;
// Set the length of the arecode drop down equal
to the length of the state's array
document.StateForm.AreaCode.length =
eval(StateArray + ThisState + .length);
// Put 'Select' as the first option in the area
code drop-down
document.StateForm.AreaCode[0].value = ;
document.StateForm.AreaCode[0].text = Select;
document.StateForm.AreaCode[0].selected = true;
// Loop through the state's array and populate
the area code drop down.
for (i=1; ieval(StateArray + ThisState +
.length); i++)
{
document.StateForm.AreaCode[i].value =
eval(StateArray + ThisState + [i]);
document.StateForm.AreaCode[i].text =
eval(StateArray + ThisState + [i]);
}
}
}
//--
/SCRIPT
A very popular question is how to have the selection of an item in one
drop-down
box automatically populate another drop-down box without refreshing the
page. The answer
is JavaScript! Using arrays, you can have your second select box be
dependent on the
first one. Keep in mind, though, that all the data loads when the page
loads
and lengthy recordsets could mean a longer download time.P
The following example will show each area code for a state. When you
select a different
state, the contents of the Area Code box will automatically change as
well.
FORM NAME = StateForm
TABLE BORDER = 0
TR
TDBState/B/TD
TDBArea Code/B/TD
/TR
TR
TD
SELECT NAME = StateCode onChange =
PopulateAreaCode()
OPTION VALUE = 0Select State
CFOUTPUT QUERY = GetStates GROUP =
State
OPTION VALUE =
#StateCode##State#
/CFOUTPUT
/SELECT
/TD
TD
SELECT NAME = AreaCode WIDTH = 70 STYLE =
width:70 SIZE = 1
OPTION VALUE = 0Select Area Code
CFOUTPUT QUERY = GetCodes
OPTION VALUE =
#AreaCode##AreaCode#
/CFOUTPUT
/SELECT
/TD
/TR
/TABLE
/FORM
-Original Message-
From: Graham Pearson [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 15:06
To: CF-Talk
Subject: RE: Two related drop-downs
I am looking at qforms for my 6 Related Select Drop Down boxes, however
I
am not into javascript. All of my information for the related select
boxes
are in various queries. How would I take those queries and put them into
the javascript section so it will work.
Any Suggestions.
At 10:57 AM 3/22/2002 -0600, you wrote:
I highly recommend checking out qForms before you start rolling your
own
javascript!
http://www.pengoworks.com/index.cfm?action=qForms
Adam.
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 10:52 AM
To: CF-Talk
Subject: Two related drop-downs
I need a cross-browser solution to populate a drop-down based
on the value
selected in another drop-down. I have don this many times for
IE. I usually
use an IFRAMe to permory a query
RE: Select Boxes Populating another select box
This is a really good site for what you need and other good stuff: http://www.webtricks.com/SourceCode/relatedselects.cfm Regards, Declan -Original Message- From: Graham Pearson [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 12:29 To: CF-Talk Subject: Select Boxes Populating another select box CF-Talk, I am looking for code that for an application that I am working on that when a user selects a Department from an DropDown Menu, that it automatically populates another dropdown menu based on what was selected in the first select box. Is their a way to handle this. Currently I am having the user press submit on the first select box so it can populate the second select box to get the Department:SubDepartment value --- Graham Pearson, System Administrator / Certified Webmaster Northern Indiana Educational Services Center Http://support.niesc.k12.in.us Email: [EMAIL PROTECTED] Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storyboarding software?
We use Visio. -Original Message- From: Matt Kornguth [mailto:[EMAIL PROTECTED]] Sent: 13 March 2002 16:36 To: CF-Talk Subject: OT: Storyboarding software? Any suggestions on software to use for storyboarding? If not specific software for that purpose, what are you using that makes your life easier? Thanks in advance, Matt Kornguth Web App Developer BLR.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What happened to the tag gallery????
its hard to find but here it is... http://devex.macromedia.com/developer/gallery/index.cfm -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 11:18 To: CF-Talk Subject: What happened to the tag gallery I have spent the last 30 minutes looking around the Macromedia site and they've either pulled the tag gallery down or hidden it because they don't want us to find it any more .. they'd rather us read wanky articles about things we might possibly need to know if we ever come across the exact same thing as the person who wrote the article. Note that the tip of the day isn't indexed in any way . you have to just look at the days tip and hope it has something to do with what you might need. And in the mean time there's no sign of the tag gallery, when I do need to get a tag I saw there a year ago. Anyone know where it is? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: a little about the future
http://www.microsoft.com/net/ -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: 04 March 2002 16:57 To: CF-Talk Subject: RE: a little about the future This .NET stuff you speak of, tell me more. At 11:51 AM 3/4/2002 -0500, you wrote: Tech related to CF and which tells a bit more about Neo (publicly). Fits with this list a bit more. Macromedia ColdFusion MX, which can be used in conjunction with Microsoft .NET, Java application servers, and web services, will provide developers with the fastest and easiest way to create rich applications with Macromedia Flash MX. In addition, developers will be able to use a new server gateway technology to build Macromedia Flash applications that work directly with leading application servers and web services. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access - MS SQL script?
use the upsizing wizard in Access after you grt username and pass from the person in charge of sql server. -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: 27 February 2002 15:44 To: CF-Talk Subject: RE: Access - MS SQL script? Thanks for the advice, and I wish it were that easy for me... but I'm i n a shared hosting environment and don't have access to the SQL Server Mana ger. Could I do this on my development machine, then somehow export a script which would replicate the database on the actual server? Or am I stuck in a situation where I will need to script the SQL tables manually? Thanks again! Lou -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen Moretti Sent: Wednesday, February 27, 2002 10:06 AM To: CF-Talk Subject: Re: Access - MS SQL script? Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Acc ess Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- You can just open up SQL Server Enterprise Manager right click on the Database folder under you server. Select All Tasks from the menu and then click on Import under the sub-menu. Follow the instructions in the D TS Import Wizard and you're away. ;o) Regards Stephen _ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:using CFEXECUTE
I am using CFExecute to run the dtsrun utility which then runs a DTSPackage on Sql Server. When I run it from the command prompt(cmd.exe) it runs fine with the following line: C:\dtsrun /S portland /U username /P password /N DTS_prediction However when I use code (below) on the server it doesn't work: cfexecute name=C:\winnt\dtsrun.exe arguments=S portland /U username /P password /N DTS_prediction/cfexecute Can anybody see anything wrong with the above arguments? I have installed the dtsrun.exe on the server at c:\winnt\ but don't have SQL Server installed the web server machine. Thanks for any help offered. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using CFEXECUTE
The thing is it seems to execute ok, in that it throws no errors.It does run the package though. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 31 January 2002 16:08 To: CF-Talk Subject: RE: using CFEXECUTE Try adding TIMEOUT=X (replace x with a reasonable timeout value). Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 10:48 AM To: CF-Talk Subject: RE:using CFEXECUTE I am using CFExecute to run the dtsrun utility which then runs a DTSPackage on Sql Server. When I run it from the command prompt(cmd.exe) it runs fine with the following line: C:\dtsrun /S portland /U username /P password /N DTS_prediction However when I use code (below) on the server it doesn't work: cfexecute name=C:\winnt\dtsrun.exe arguments=S portland /U username /P password /N DTS_prediction/cfexecute Can anybody see anything wrong with the above arguments? I have installed the dtsrun.exe on the server at c:\winnt\ but don't have SQL Server installed the web server machine. Thanks for any help offered. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rendering WAP
There was a site where it looks like you can do this. But I haven't used it. Can't remember where I got a previous emulator but there are others out there. The www.gelon.net WebSite allows you to view a WAP page by submitting a link to their emulator located in their server to process. http://gelon.net/cgi-bin/wapalizeericssonr320.cgi?url=http://www.gelon. net/cgi-bin/wap.cgi -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 03:29 To: CF-Talk Subject: RE: Rendering WAP Apologies for the OT but can anyone advise if you can render WAP in a normal browser. No, normal browsers don't support WML. (WAP is the transport protocol, not the language; WAP is to WML what HTTP is to HTML, to slightly oversimplify.) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session variables
Coldfusion is not like ASP in that session variables are not killed when the browser is closed. YOu can also kill session vars by creating a page with this code and opening it in your browser. cfscript StructClear(session); /cfscript cfscript StructClear(application); /cfscript -Original Message- From: Waldemiro Junior [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 12:42 To: CF-Talk Subject: Session variables Hello again folks.. Something weird is happening and I don´t know how to solve it, or maybe I´m doing something wrong... I believe that when I close my browser all those session variables must be killed, but when I open another browser window (it´s not a new window function) the values of those variables are still there in the memory !!! Does anybody know what´s going on here...I´m using CF5. Thanks and best regards, Waldemiro Junior ADD Technologies Web Developer __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Forumspot.org or free opensouce forums
Could anybody tell me what has happend to forumspot.org as I have been trying to access it to download the Allaire Forums SQL Server version. Could anybody send me a .bak of the SQL Server database for this? Could I also ask your experience with using other free multiple conference forums such as Open Forums http://www.stickshiftsolutions.com/index.cfm?jumpto=29 Regards, Declan -Original Message- From: Declan Maher Sent: 09 January 2002 11:08 To: CF-Talk Subject: RE: Using a DTS package Can anybody advise me what is the best/simplest way of converting a SQL Server database to Access in the following instance. My user needs to be able to just go to the website click on a button and the database needs to be converted. Then the user can just download the Access db and analyse it with certain software they have. Somebody has suggested using a DTS package before but I'm still not sure how this is executed from Coldfusion. If anybody has an code or tips they would be greatly appreciated. Thanks, Declan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: tracing where users are from
This is an email (from an ASP mailing list called 4guysfromrolla.com) which discusses checking where a user is from. Hope it helps. One question that is often asked on the ASPMessageboard is: How can I determine where someone is located, by grabbing their IP, either so the page can be personalized for their state/country, or so that I can authenticate them, and make sure that they arent giving away their username/password combo to my pay-to-use site? The answer is, You can (to some extent), and you cant. You can get the IP of a client requesting a page from your site using Request.ServerVariables(REMOTE_ADDR) on your page. If what you want is national, (or continental) distinction, that is fairly well mapped out. The University of California at Berkeley maintains a database of every IP block, mapped to the countries that they have been assigned to by ARIN, RIPE, and APNIC. As of this writing, I don't know where a copy of this database may be obtained, as the only site that I knew to offer it (http://geo-ip.com) appears to be off-line. However, if you can find it, it is considered the authoritative source for current IP block assignments. Another option that you as a web programmer have, would be to go to the same source as Berkeley, and use the XMLHTTP component to query ARIN, RIPE, and APNIC for the source of a given IP on the fly. One of the benefits of this option would be that you would have a maintenance free method, that would always be up-to-date, whereas the Berkeley DB must be updated every month in order to stay current. (For more information on the XMLHTTP component be sure to check out this FAQ.) If you choose to use the REMOTE_ADDR server variable, you can be fairly certain that the IP that you recover accurately represents the nation of origin of that user. It is fairly uncommon for a user to be accessing the Internet from outside of the country that he is currently in, with a few notable exceptions, such as those who choose to surf though an anonymous proxy server, such as is discussed below. If, however, you want to get the state that a user is coming from, or authenticate the identity of a user, you're out of luck as far as any even remotely reliable method is concerned. You see, IPs are assigned to users in a variety of different ways, and not all of these ways indicate the originating location of that user, or who the actual end user is. Many computers, particularly those that are networked, do not access the Internet directly. They use an intermediary, known as a proxy server. Say for instance, you have two workstations, with IPs of 192.168.0.2, and 192.168.0.3, and a proxy server with an IP of 211.58.61.10. If user 192.168.0.2 were to request a webpage, say, www.yoursite.com, that request will go to the proxy server, which will, in turn, query www.yoursite.com. Then, yoursite.com will get the page request from the proxy server (211.58.61.10) and will send the page back to that address, which will then determine that the page should be sent to 192.168.0.2. If 192.168.0.3 were to request that same page, the same sequence will occur. Yoursite.com will still get the page request from 211.58.61.10, (the proxy server IP) and then the proxy server, after again receiving the page from your server, will determine that this time, the contents of that page need to be delivered back to 192.168.0.3. Even if you could see the originating machines, (though you now see that in this situation you cant) it would be useless, because most users in this sort of a scenario dont have a unique IP, if any IP at all! Because there are only a limited number of IPs, several blocks have been set aside as non-routable, for use in internal networks, and can be used by many, many networks at once. One of the blocks is the 192.168.x.x. This means, that there are probably hundreds, if not thousands of computers at any given moment that have been assigned the address of 192.168.0.1, or 192.168.0.2! There are also many large corporate networks, (although fewer than in the past) using Novell, or other NOSes that dont even assign IPs to the clients, but instead uses the network cards MAC address as the unique identifier. It would be pretty hard to get the IP of a computer that doesnt even have one! Well you say, My users aren't corporate users, they are people dialing up from home. That's well and good, but corporate users are not the only network clients that utilize this kind of setup. AOL uses the same scheme! So, if you have two clients dialing-up via their AOL accounts, one from Minnesota, and one from California, you may very well see the same IP for both of them! You are, in fact, limited to only a few thousand IPs for all of AOL's thirty-plus million users. To confound you further, they will both appear to be residents of Reston, Virginia, because that is where all of AOL's proxy servers are located. Another proxy issue, is that of
RE: Using a DTS package
Can anybody advise me what is the best/simplest way of converting a SQL Server database to Access in the following instance. My user needs to be able to just go to the website click on a button and the database needs to be converted. Then the user can just download the Access db and analyse it with certain software they have. Somebody has suggested using a DTS package before but I'm still not sure how this is executed from Coldfusion. If anybody has an code or tips they would be greatly appreciated. Thanks, Declan __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Insert Date/Time Format into MS Access DB
CFQUERY NAME=INSOBJ
DATASOURCE=uspc
INSERT INTO t_sectest
(cal_date_start,
cal_date_end)
VALUES ('#CreateODBCDate(form.cal_date_start)#',
'#CreateODBCDate(form.cal_date_end)#')
/cfquery
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: 02 January 2002 15:54
To: CF-Talk
Subject: Insert Date/Time Format into MS Access DB
I want to insert a date from a form, as MM/DD/
I set up an SQL Statement as follows:
CFQUERY NAME=INSOBJ
DATASOURCE=uspc
INSERT INTO t_sectest
(cal_date_start,
cal_date_end)
VALUES ('#form.cal_date_start#',
'#form.cal_date_end#')
/cfquery
If I set the MS Access db field as Date/Time, even with a mask of
99/99/;0;_ - it throws a syntax error. (I've tried it with and
without
single quotes surrounding the variable).
If I set the Access db field as Text, it does take the date, but then
does
not sort properly (based on ascending or descending dates).
My question, what is the correct way to format the SQL statement so that
I
can insert the form.cal_date_start as a Date/Time Field in MS Access.
Thanks in advance,
Mark
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Speeding up select queries
Other attributes of cfquery which may be of help in speeding up a query is to try using blockfactorwhick specifies the max number of rows to fetch at a time from the server or maxrows if you want to limit the number of rows returned. Regards, Declan -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: 02 January 2002 16:22 To: CF-Talk Subject: Speeding up select queries What is the best approach to speed up select statements with a sql2000 database? The data is constantly being updated,deleted,inserted, through out the day with each user seeing data depending on his/her access level and assigned zip codes. I worry that using cachedwithin will not work in this senario, as using that will not allow to show data that has recently changed. ANY help, thoughts much appreciated. - - Visit The Most Powerful Tool on the Farm at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Moving data from SQL Server to Access automatically
Hi database experts, I have just migrated a database from Access to SQL Server however I need to have a system in place that automatically makes a copy of the latest data in the SQL Server db back to Access when the user requests this.The access db will then be downloaded by the user. The user needs to run Excel queries on an access db which makes this necessary. I have thought about using scheduled tasks but the max allowed on the server is once a day.Thought about linked tables but these are not allowed on the server. The Server administrator has suggested doing adhoc updates which I have never done before. Can anybody explain how this is done? Is it a process of coding in coldfusion to set a task in SQL Server?If you have any other suggestions on how to do this I would be very grateful. Thanks for your help, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
I hate DateDiff!
Hi, No matter what I try this will not work for me. Can anybody point out what is wrong with this code. cfset targ=#DateFormat(01/12/2001,dd/mm/)# cfoutput#targ#/cfoutput cfset compare=DateDiff(d,#targ#,#DateFormat(Now(),dd/mm/)#) It gives me weird output dates - of -233. Thanks, Declan -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 04 December 2001 11:19 To: CF-Talk Subject: RE: multilingual dynamic sites, particularly hindi Thanks Paul, that is all very useful. The DB will be sqlserver 2k so no probs there. I guess the main thing is the font, and installing it on the users system if they dont have it? cheers will -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: 04 December 2001 10:51 To: CF-Talk Subject: Re: multilingual dynamic sites, particularly hindi Just a general question really. We have been asked by a client to quote for building a multilingual website, with versions in a number of European languages, plus Hindi, and possibly Japanese. if they don't want to roll out a bunch of servers, then unicode. cf5 can work with unicode within some limitations. so you'll need to consider their user base, can they accept unicode (ie no loads of crappy older browsers no loads of netscape)? go here for more unicode info: http://www.unicode.org/ or buy ben forta's new advanced cf5 which has an i18n starter chapter. I have never done any multilingual work, so can anyone out there give me some pointers on how to achieve this, and whether or not CF can handle a language like Hindi. you do not want a punk database for this. sql server 2k would be my 1st choice (it does a very nice job of handling multiple locales). no idea about hindi (hi locale?? there's a boatload of indic locales) but cf unicode can be seen in action here: http://www.tei.or.th/misc/unicode.cfm (several langauges, left to right right to left directionality included) or if you want to see a major problem workaround look here: http://www.tei.or.th/misc/unicodeSplit.cfm your content delivery can be in-memory or pulled on the fly from a database but basically every page should be in a database. improves management at a minimum. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.303 / Virus Database: 164 - Release Date: 11/24/2001 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I hate DateDiff...not as much now!
Pascal, Thanks very much for your help.Was going around in circles with that one. Regards, Declan -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: 04 December 2001 12:30 To: CF-Talk Subject: RE: I hate DateDiff! CF is most probably using a US dateformat (depends on the settings of your server). TRY: cfset targ=#CreateDate(2001,12,01)# cfoutput#Dateformat(targ,dd/mm/)#/cfoutput cfset compare=DateDiff(d,targ,Now()) Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: dinsdag 4 december 2001 13:22 To: CF-Talk Subject: I hate DateDiff! Hi, No matter what I try this will not work for me. Can anybody point out what is wrong with this code. cfset targ=#DateFormat(01/12/2001,dd/mm/)# cfoutput#targ#/cfoutput cfset compare=DateDiff(d,#targ#,#DateFormat(Now(),dd/mm/)#) It gives me weird output dates - of -233. Thanks, Declan ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 10 Step Program
Have you thought of using url.variables or passing vars in form.variables. -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 17:19 To: CF-Talk Subject: 10 Step Program Hi my name is Won Lee and I'm addicted to session variables. In an attempt to rid myself of all locking, I'm trying to stay away from application and session variables. One of the most common things is used for session variables is session.userID. How does one now emulate this functionality without using session variables. I thought about just using cookies, but that would hinder use of cflocation. Any ideas? How do HTML websites handle session states? Not being a materialist in the U.S. is kind of like not appreciating opera if you live in Milan or art if you live in Paris. We support materialism better than any other culture. Because retailing and distribution are so efficient here, stuff is cheaper than anywhere else in the world. And then we have huge houses in which to archive our stuff. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alter statement
Can anybody help me with an Alter statement in Access. I am trying to put a default date of 01/01/2000 in the database and anything I have tried has failed. Heres the code I've tried ALTER TABLE implementation ADD COLUMN #form.target_date# date default 01/01/2000 But it fails. Thanks in advance, Declan -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 15:38 To: CF-Talk Subject: Re: Query Help Try this. SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID -- Original Message -- From: Clint Tredway [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 21 Nov 2001 10:37:06 -0500 Ok.. why does it say this: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets' does not match with a table name or alias name used in the query. Query: SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered, Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName, Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname, Types.TypeValue FROM Tickets T, Users, Techs INNER JOIN Types ON TicketStatus = Types.TypeID WHERE Tickets.UserID = Users.UserID Thanks in advance... ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
I am having problems comparing two dates. My question is how to compare two dates that come from different years. For example if I use the code below to compare a date of 12 Nov 2001 and 28 Feb 2002 to get the date difference I get -257 days. cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)# cfset comparison_list=#ListAppend(comparison_list,#compare#)# I have tried other means of doing this but with no success. Can somebody suggest the correct code to use to compare dates that overlap years? Thanks in advance, Declan maher -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:03 To: CF-Talk Subject: RE: AUTO TABLE WIDTH table width=xxx ??? EC -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:51 AM To: CF-Talk Subject: Re: AUTO TABLE WIDTH :) not enough coffee A TABLE will now SHOW on the browser screen until it reaches the /table Because it has to read through the whole table to generate Widths and such but on large tables that can slow down the display of tables by a few seconds. Now there is a CODE you put into the page or the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, Bill Wheatley Director of Development Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH On 11/20/01, William J Wheatley penned: Whats the Code to AUTOSET the table size of a table so that the table does not have to get to the /table before the table can be displayed? What? LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
Mike, Thanks for the reply. The thing with the ABS function is that it only takes the minus sign away.The calculation is actually calculating the dates between 12 Nov 2001 and 28 Feb 2001 NOT 12 Nov 2001 and 28 Feb 2002 as it should.So the number of days is wrong. I am not using cf5 so cant use a UDF. Any other ideas? Regards, Declan -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:21 To: CF-Talk Subject: RE: Datediff Sorry, I meant: cfset compare= ABS(#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#) Mike -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:16 AM To: CF-Talk Subject: RE: Datediff Use the ABS funcitons, which will return the positive value. The number is correct, Try this: ABS(cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#) Im not sure on the pounds, but play with it. Lemme know if this helps. Mike -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:11 AM To: CF-Talk Subject: RE: Datediff I am having problems comparing two dates. My question is how to compare two dates that come from different years. For example if I use the code below to compare a date of 12 Nov 2001 and 28 Feb 2002 to get the date difference I get -257 days. cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)# cfset comparison_list=#ListAppend(comparison_list,#compare#)# I have tried other means of doing this but with no success. Can somebody suggest the correct code to use to compare dates that overlap years? Thanks in advance, Declan maher -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:03 To: CF-Talk Subject: RE: AUTO TABLE WIDTH table width=xxx ??? EC -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:51 AM To: CF-Talk Subject: Re: AUTO TABLE WIDTH :) not enough coffee A TABLE will now SHOW on the browser screen until it reaches the /table Because it has to read through the whole table to generate Widths and such but on large tables that can slow down the display of tables by a few seconds. Now there is a CODE you put into the page or the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, Bill Wheatley Director of Development Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH On 11/20/01, William J Wheatley penned: Whats the Code to AUTOSET the table size of a table so that the table does not have to get to the /table before the table can be displayed? What? LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
Pascal,
Pascal,Mike,
Thanks. Tried Pascals version and works fine.
compare=DateDiff('d',targ,implm)
Cheers,
Declan
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2001 16:28
To: CF-Talk
Subject: RE: Datediff
Didn't read everything. If you want the difference: compar=
DateDiff('d',targ,implm)
Datediff works on entire dates.
Pascal
-Original Message-
From: Pascal Peters
Sent: dinsdag 20 november 2001 17:24
To: CF-Talk
Subject: RE: Datediff
datecompare(date1,date2)
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 20 november 2001 17:11
To: CF-Talk
Subject: RE: Datediff
I am having problems comparing two dates.
My question is how to compare two dates that come from different years.
For example if I use the code below to compare a date of 12 Nov 2001
and 28 Feb 2002 to get the date difference I get -257 days.
cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#
cfset comparison_list=#ListAppend(comparison_list,#compare#)#
I have tried other means of doing this but with no success.
Can somebody suggest the correct code to use to compare dates that
overlap years?
Thanks in advance,
Declan maher
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2001 16:03
To: CF-Talk
Subject: RE: AUTO TABLE WIDTH
table width=xxx ???
EC
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 10:51 AM
To: CF-Talk
Subject: Re: AUTO TABLE WIDTH
:) not enough coffee
A TABLE will now SHOW on the browser screen until it reaches the
/table
Because it has to read through the whole table to generate Widths and
such
but on large tables that can slow down the display of tables by a few
seconds.
Now there is a CODE you put into the page or the table tag that lets the
Browser know this is a PREDEFINED size and to display it on the fly
I forget what that code is any idea?
Thanks all,
Bill Wheatley
Director of Development
Certified Advanced ColdFusion 5 Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645
- Original Message -
From: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 10:35 AM
Subject: Re: AUTO TABLE WIDTH
On 11/20/01, William J Wheatley penned:
Whats the Code to AUTOSET the table size of a table so that the
table
does not have to get to the /table before the table can be
displayed?
What? LOL
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Search Engines
Hi, The whole issue of whether you have to pay for search engines or not is very complex and much more detailed than simply do I have to pay or not. You will not get listed on certain engines if you don't subscribe to certain directories and are unlikely to get a good position unless you pay for some, such as Google, . The best sites I have found that tell you everything about searchengines are: http://searchengineforums.com - where you get help from fellow developers/marketing people http://www.searchenginewatch.com/ - good updated info on all major search engines A critical directory appears to be Inktomi,which is where some searchengines get their sites list from, from reading peoples input in searchengine forums. You can register on this with: http://www.positiontech.com/inktomi/faq.htm#1 (but go to the other sites first and see what you think from peoples comments) To sum up and use a generalisation, if you have a personal site you can get on enough engines for free but it may take months, but if you have money to spend then you can get a better ranking, much faster, and can have your site automatically re-submitted regularly when you pay. Declan Maher Web Applications Developer -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: 23 September 2001 17:01 To: CF-Talk Subject: RE: Search Engines You don't have to pay. Do it yourself. I do. Just go to each of the search engines, and register a site with them. .. Capture the form you submit, and put that code into a CF template yourself. I have made one where I put in the keywords, description, basic information enough to fill in all the forms in all the sites I want to submit to. Then on the template page I have, I fill in my site name once, site address once, description once, name once, etc etc. and select a classification for each search engine, the drop down menus are taken off the site's own form. Then the submit button on the action page sends off the information needed by each site in turn, and puts a confirming page up. submitted to altavista... submitted to hotbot ... etc Hope this helps. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 10:27 PM To: CF-Talk Subject: Search Engines Hi All, this may be a bit off topic, but i need/advise on where and how i can register a site in the top search engines. I know there are all these sites where you can do it but do you have recommendations? My other question is, why do we have to pay for this, or what does paying provide from those where you don't have to pay do? I thought there were robots that go around linking from page to page and indexing the webpages..so that when a search is run the pages relevant are found, so what does paying do? thanks! Heidi Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Moving from Access to SQL server
Heres a good article on upgrading differences. http://www.elementkjournals.com/sql/0001/sql0011.htm I also found in my code the following differences: Access SQL Server Function Now() GetDate() You can use #CreateODBCDate(Now())# around the Now() function and it will work in both Access and SQL Server datatype Yes/No Bit When converted if you use TRUE/FALSE this will throw an error. Instead use 1/0 to determine if it should be switched on/off. Also Delete * from Table needs to be changed to Delete from Table. Declan Maher Web Applications Developer Head Office 133-137 Lisburn Road Belfast Northern Ireland BT9 7AG T: +44 (0) 28 9022 3224 F: +44 (0) 28 9022 3223 E: [EMAIL PROTECTED] W: biznet-solutions.com -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: 20 September 2001 07:47 To: CF-Talk Subject: RE: Moving from Access to SQL server SQL probably doesn't like SELECT * FROM TABLE - you need to be a bit more specific about what columns you actually require. If your SQL code is good you should be able to upsize to SQL Server without much problems. -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20 September 2001 0:26 To: CF-Talk Subject: RE: Moving from Access to SQL server Hi I have a site which I would like to move from Access to SQl server are there any things I need to be aware of code wise things like dates perhaps? Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:ActiveEdit
Hi, Can anybody help me with a problem with ActiveEdit that I am having since importing my database from Access to SQL Server. The connection information seems to be right: cf_activedit inc=/inc/ fieldname=content ds=#Variables.DSN# table=Programme_Summary width=700 height=500 type=edit primarykey=Programme_ID Primarykeyvalue=#url.appid# image=yes url=#variables.addr#/Summary/images/ path=#variables.root#summary\images\ upload=yes onsave=notify bordercolor=e1e1e1 However the error message I am getting is as follows. Cookies are not enabled or a Coldfusion Error has occurred.Be sure that Cookies are enabled on your browser and that all the ActiveEdit attributes are correct. Any suggestions or help greatly appreciated. Cheers, Declan Maher Web Applications Developer Head Office 133-137 Lisburn Road Belfast Northern Ireland ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with ListAppend
Hi, I am getting an error when using ListAppend function. Can anybody see whats wrong with this code? I cannot figure out what the problem is. cfif cgi.http_referer CONTAINS Corex1 cfparam name=mychanges default= cfif isDefined(Form.Programme_name) AND GetContent.Programme_name NEQ #Form.Programme_Name# cfset mychanges = ListAppend(mychanges,'General Details - Programme Name') /cfif The error that is occurring is as follows: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (20:1) to (20:70). The error happens when I try to set the variable. Any ideas? Thanks for your help, Regards, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
help with moving from access to sql server
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit
column.
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (21:1) to (21:53).
I realise that this is caused by trying to group according to the bit
datatype.
However when I remove the grouping for this it gives an error saying
that I need to group.
This is the query I am using. Can anybody suggest a way of getting
around this.
cfquery name=gethdrs datasource=#Variables.DSN#
SELECT DISTINCT Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Quarter_ID,
Programme_Details.Locked, Programme_details.Prog_Status,
Programme_Details.ILX, Programme_Details.Executive,
Programme_Details.BSS, Programme_Details.Prog_result
FROM Programme_Hdr, Programme_Details, Business_Units2
WHERE Programme_Hdr.Programme_ID Programme_Details.Programme_ID
cfif form.Programme_Name NEQ ALL
AND Programme_Name = '#Form.Programme_Name#'
/cfif
cfif form.year NEQ ALL
AND Programme_Details.Year = '#Form.Year#'
/cfif
cfif form.quarter NEQ ALL
AND Programme_Details.Quarter = '#Form.Quarter#'
/cfif
cfif form.Business_unit NEQ ALL
AND Programme_Hdr.Business_Unit = '#form.Business_Unit#'
/CFIF
cfif listcontains(session.access,'5') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND Programme_Details.Executive = 1
OR (PROGRAMME_DETAILS.ILX=1 AND PROG_Status IN('CURRENT,COMPLETED'))
/cfif
cfif listcontains(session.access,'3') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.BSS=1 OR (Programme_Hdr.Business_unit '#session.b_unit#' AND
Programme_Details.BSS = 0))
/cfif
cfif listcontains(session.access,'2') AND NOT
listcontains(session.access,'1') AND NOT
listcontains(session.access,'4')
AND (PROGRAMME_DETAILS.ILX=1 OR (Programme_Hdr.Business_unit '#session.b_unit#' AND
Programme_Details.ILX = 0))
/cfif
cfif NOT listcontains(session.access, '1') AND NOT
listcontains(session.access, '2') AND NOT listcontains(session.access,
'5')
AND Business_Units2.bss_Name = '#session.bss#'
AND Programme_Hdr.Business_Unit = Business_Units2.bu_name
/cfif
cfif listcontains(session.access, '4') AND NOT
listcontains(session.access, '5')
AND Programme_Hdr.Business_Unit = '#session.b_unit#'
/cfif
AND Programme_Details.archived = 0
Group By Programme_Details.Quarter_ID, Programme_Hdr.Business_Unit,
Programme_Hdr.Programme_Name, Programme_Hdr.Region,
Programme_Hdr.Programme_ID, Programme_Details.Year,
Programme_Details.Quarter, Programme_Details.Locked,
Programme_Details.Prog_Status, Programme_Details.ILX,
Programme_Details.BSS, Programme_Details.Executive,
Programme_Details.Prog_result
cfif not parameterexists(url.orderby)
ORDER by Programme_Hdr.Business_Unit, Programme_Details.Quarter
Cfelse
cfif parameterexists(url.Orderby) and url.orderby eq BU
Order by Programme_Hdr.Business_Unit
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq PN
Order by PROGRAMME_hdr.Programme_Name
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq YR
Order by PROGRAMME_DETAILS.YEAR
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq QR
Order by PROGRAMME_DETAILS.Quarter
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
CFELSEIF parameterexists(url.Orderby) and url.orderby eq RN
Order by PROGRAMME_HDR.Region
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
/cfif
/cfif
/cfquery
thanks,
Regards,
Declan Maher
Web Applications Developer
Head Office
133-137 Lisburn Road
Belfast
Northern Ireland
BT9 7AG
T: +44 (0) 28 9022 3224
F: +44 (0) 28 9022 3223
E: [EMAIL PROTECTED]
W: biznet-solutions.com
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problems with viewing
Hi, I have created a pdf dynamically on the server with an image inside and when I open it on the server it shows the image fine. However when I try to open it through a browser it fails to show the image. Can anybody suggest what the problem might be? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Forums - Weirdness
Dalai, Is it the free forum from allaire that you mean by CF Forums If so did you know that there is a forum for it at www.forumspot.org If you dont know about it its opensource. You can download it from the above address also. There are a few errors in the files such as attachments etc. Most of the info is on the site above. Cheers, Declan Maher Web Applications Developer Head Office 133-137 Lisburn Road Belfast Northern Ireland BT9 7AG T: +44 (0) 28 9022 3224 F: +44 (0) 28 9022 3223 E: [EMAIL PROTECTED] W: biznet-solutions.com -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: 07 August 2001 14:08 To: CF-Talk Subject: CF Forums - Weirdness Ok, we've just set up forums on our system and it's behaving in a rather odd way, perhaps one of you lot has seen this before and knows a workaround. Ok, the way it's working is this: 1. User goes to conference 2. User is allowed in but with no rights to post or reply 3. User wants to post so they click the login/logout button 4. User Registers 5. User confirms password 6. User waits for approval. Now, here's the problem, unless the user logs in unsuccessfully straight after registration their username won't show up in the list of users requiring approval that the admin sees... I've tested it and even tried modifying the code but I managed to kill the server in the process :-/ Can anyone help??? Or possibly recommend another open source threaded discussion app for CF This is starting to drive me a little potty so if anyone wants to help rescue my sanity, please feel free!! best wishes, -= Ed If you want others to be happy, practice compassion. If you want to be happy, practice compassion. ~The 14th Dalai Lama ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Purchasing a copy of ColdFusion Server in the UK
Aidan, If you like you can purchase a copy of coldfusion server from us in Northern Ireland! BizNet Solutions 133-137 Lisburn Road Belfast, BT09 7AG Ireland + 44 (028) 90 223224 + 44 (028) 90 223223 [EMAIL PROTECTED] http://www.biznet-solutions.com -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: 31 July 2001 16:41 To: CF-Talk Subject: RE: Purchasing a copy of ColdFusion Server in the UK I found Highlander to be quite responsive when we were taking the Advanced course. Probably caught them on a bad day. There courses are well worth the money. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 04 July 2001 12:38 To: CF-Talk Subject: RE: Purchasing a copy of ColdFusion Server in the UK Anyone know where I can purchase a copy of ColdFusion Server in the UK? http://www.highlander.co.uk Thanks. However, their website says Cold Fusion News Update 30th April 2001. [snip] Cold Fusion 5.0 will be available in June. Whilst at my last place of work I asked them about a course they were thinking of running (ColdFusion Administration). After a month and a phone call, they still hadn't replied. Perhaps the aren't the most responsive company with which to spend a few thousand pounds. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
NT Challange Response and CFFILE
Hi, I am currently using CFFile to write a .pdf file inside a directory where I have full access permissions. This was working fine on the server until NT Challange Response was turned on. Now it fails to write the pdf file and a message comes up 'Access Denied' when I try to open the files in Adobe Acrobat. Can anybody tell me what is causing this and suggested solutions? Thanks, Declan Maher Web Applications Developer Biznet-Solutions 133-137 Lisburn Road Belfast BT9 7AG Tel:(0)28 9022 3224 Fax:+44 (0)28 9022 3223 Email:[EMAIL PROTECTED] Web: http://www.biznet-solutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
