OT:Looking for a good SQL mailing list
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am having some trouble with an SQL statement I'm trying to write and I want to know if there are any good mailing lists out there for SQL, that are as good as CFTalk is for ColdFusion. Or can I post my question here? Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT: SQL Server database problem
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks Rizal, but the problem was caused by another field being to small, not the three I originally thought. Stephen -Original Message- From: Rizal Firmansyah [mailto:rizal.firmansyah@;sentracommerce.com] Sent: 28 October 2002 15:42 To: CF-Talk Subject: Re: OT: SQL Server database problem Just another taught... Using varchar instead of text as a datatype for this kind of data maybe helpful... Rizal At 10:21 PM 10/28/2002, you wrote: >I think the error message is straight forward, >that is you are trying to insert string that's longer than your datatype >can handle. > >For example: >Field: MessageTitle (16): You are trying to insert: "Some text to throw >error" which has 24 characters. > >Try to increase the length of the field in your DB. > >HTH, >Rizal ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT: SQL Server database problem
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Alex thank you that was the cause of the problem. Stephen -Original Message- From: A.Little [mailto:A.Little@;open.ac.uk] Sent: 28 October 2002 15:23 To: CF-Talk Subject: RE: OT: SQL Server database problem You don;t need to trim these down to 16 chars as that isn't the max length you can store in a SQL 'text' field - it's something like up to 2Gb of data (on SQL2K) - even though the length says 16 on the table design (I think this was discussed in a thread here 2 or 3 weeks ago) and changing this length will make no difference. The SQL text field is like a memo field in Access. So with the data you are inputting to MessageTitle, MessageTeaser and MessageBody you should have no problem. You've not given the field length for the 'Status' column into which you;re trying to insert 16 chars - could this be the problem ? Alex > -Original Message- > From: John Morgan [mailto:gameczar@;zbzoom.net] > Sent: 28 October 2002 15:14 > To: CF-Talk > Subject: Re: OT: SQL Server database problem > > > You should either trim the text being inserted using the left > function ... > > EXAMPLE: > > Left(form.MessageTeaser, 16 ) > > or you should expand the size of the field in the table. If > this is data > input via a form you could use the size option in the input > tag to enforce > the size restriction but I would still trim the data with the > left function > for safety sake. > > EXAMPLE: > > > > -John- > > At 02:58 PM 10/28/2002 +, you wrote: > >* > * > >WESTMINSTER CITY COUNCIL > >Please refer to the disclaimer beneath this message > >* > * > > > >Hi, > > > >I have a SQL Server 7 database and I am trying to insert a > large amount of > >text, passed by a ColdFusion form, into a table within this database. > > > >The problem I am having is a "ODBC Error Code = 22001 > (String data right > >truncation)" error. > >My table design is like this. > > Column name DatatypeLength > > MessageID int 4 > > MessageType char20 > > Department char20 > > CreationDatechar15 > > PublicationDate char15 > > MessageTitletext16 > > MessageTeaser text16 > > MessageBody text16 > >I think that the problem is when the text is being added to > the fields, > >MessageTitle, MessageTeaser and MessageBody. > >This is the complete error message: > > > >ODBC Error Code = 22001 (String data right truncation) > >[Microsoft][ODBC SQL Server Driver][SQL Server]String or > binary data would > >be truncated. > >SQL = "INSERT INTO Messages ( MessageType, Department, CreationDate, > >PublicationDate, MessageTitle, MessageTeaser, MessageBody, > Status ) VALUES ( > >'None', 'Housing', '28/10/2002', 'Awaiting', 'Some text to > throw error', > >'Some text to throw error, Some text to throw error', 'Some > text to throw > >error,Some text to throw error and Some text to throw > error', 'Awating > >Approval' )" > >Data Source = "WIRE_USERS" > >The error occurred while processing an element with a > general identifier of > >(CFQUERY), occupying document position (24:1) to (24:57) in > the template > >file E:\INETPUB\WWWROOT\WIRE\MESSAGES\SENDFORAPPROVAL.CFM. > >Anyone know how I can fix this error? > >Thanks > >Stephen > > > > > > > >* > * > >Westminster City Council switchboard: > >+44 20 7641 6000 > >* > * > >This E-Mail may contain information which is > >privileged, confidential and protected from > >disclosure. If you are not the intended recipient > >of this E-mail or any part of it, please telephone > >Westminster City Council immediately on receipt. > >You should not disclose the contents to any other > >person or take copies. > >* > * > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT: SQL Server database problem
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** O.K I have increased the "length" of these three fields to 100, 150 and 500 respectively, but still I get the 22001 error. -Original Message- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: 28 October 2002 15:05 To: CF-Talk Subject: Re: OT: SQL Server database problem Quoting "Adams, Stephen" <[EMAIL PROTECTED]>: > > The problem I am having is a "ODBC Error Code = 22001 (String data > right truncation)" error. > My table design is like this. > Column name DatatypeLength > MessageID int 4 > MessageType char20 > Department char20 > CreationDatechar15 > PublicationDate char15 > MessageTitletext16 > MessageTeaser text16 > MessageBody text16 > I think that the problem is when the text is being added to the > fields, MessageTitle, MessageTeaser and MessageBody. 'Some text to throw error' is indeed longer as 16 characters. Not entirely unexpected behaviour, isn't it? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: SQL Server database problem
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a SQL Server 7 database and I am trying to insert a large amount of text, passed by a ColdFusion form, into a table within this database. The problem I am having is a "ODBC Error Code = 22001 (String data right truncation)" error. My table design is like this. Column name DatatypeLength MessageID int 4 MessageType char20 Department char20 CreationDatechar15 PublicationDate char15 MessageTitletext16 MessageTeaser text16 MessageBody text16 I think that the problem is when the text is being added to the fields, MessageTitle, MessageTeaser and MessageBody. This is the complete error message: ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. SQL = "INSERT INTO Messages ( MessageType, Department, CreationDate, PublicationDate, MessageTitle, MessageTeaser, MessageBody, Status ) VALUES ( 'None', 'Housing', '28/10/2002', 'Awaiting', 'Some text to throw error', 'Some text to throw error, Some text to throw error', 'Some text to throw error,Some text to throw error and Some text to throw error', 'Awating Approval' )" Data Source = "WIRE_USERS" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (24:1) to (24:57) in the template file E:\INETPUB\WWWROOT\WIRE\MESSAGES\SENDFORAPPROVAL.CFM. Anyone know how I can fix this error? Thanks Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
How can you get the latest version of a page.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi all, How can I get the latest version of a CF page. I am opening a page in a popup window and I want the latest version, not the one stored in the cache, I'm not sure how to do this can anyone give me any pointers. Thanks Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Recommendations - Java tutorials
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Some good ones I've found are JavaWorld (www.javaworld.com) Java 101 series and try JavaRanch (www.javaranch.com) -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 14:52 To: CF-Talk Subject: Re: Recommendations - Java tutorials IBM's are the best. I must have read a thousand books, tutorials trying to cram the concept of objects into my head, then I read their java basics tutorial and it all clicked. http://www-105.ibm.com/developerworks/education.nsf/dw/java-onlinecourse-byt itle -- jon mailto:[EMAIL PROTECTED] Friday, October 11, 2002, 9:39:37 AM, you wrote: BD> Where can I locate some good Java tutorials that step through building basic BD> classes and applets? I've been working with some from java.sun.com. BD> Thanks, BD> Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Problem with a dynamic menu and loops.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am building an Intranet that has a menu for the company departments. This menu is populated by a query that returns the department name, title, description, filename and the page URL. When a Department is selected the page goes to that particular departments homepage and the menu expands to display all the pages underneath that department, e.g. Human Resources - Holiday Form - Sick Pay - Contact HR My problem is that I want to have the selected department appear at the top of my series of departments, and still keep the other departments in alphabetical order. So I'd have: Human Resources - Holiday Form - Sick Pay - Contact HR Customer Service Finance Planning Has anyone tried something like this before, or has any idea how I can do this? Thanks Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: error with a piece of cfscript code and I can't see what's wr ong?
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Thanks Bryan, it's working fine now.
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: 30 September 2002 16:02
To: CF-Talk
Subject: RE: error with a piece of cfscript code and I can't see what's
wrong?
Below is the corrected code, you had a few extra "("s in front of your
isdefined
If (NOT IsDefined("Form.business_types") AND IsDefined("Form.residents"))
{
session.ResidentsOnly = yes;
}
Else If (NOT IsDefined("Form.residents") AND
IsDefined("Form.business_type")) {
session.BusinessOnly = 'yes';
session.ListOfBusiness =
"#Form.business_types#";
}
Else {
session.ResidentsAndBusiness = 'yes';
session.ListOfBusiness =
"#Form.business_types#";
}
-Original Message-
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 10:55 AM
To: CF-Talk
Subject: error with a piece of cfscript code and I can't see what's
wrong?
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Can anyone see what's wrong with this:
If (NOT IsDefined("Form.business_types") AND
(IsDefined("Form.residents")) {
session.ResidentsOnly = yes;
}
Else If (NOT IsDefined("Form.residents")) AND
(IsDefined("Form.business_type")) {
session.BusinessOnly = yes;
session.ListOfBusiness =
"#Form.business_types#";
}
Else {
session.ResidentsAndBusiness = yes;
session.ListOfBusiness =
"#Form.business_types#";
}
This is the error I keep getting:
Error Diagnostic Information
Just in time compilation error
Invalid parser construct found on line 67 at position 79. ColdFusion was
looking at the following text:{Invalid expression format. The usual cause is
an error in the expression structure.
The last successfully parsed CFML construct was a CFSCRIPT tag occupying
document position (66:3) to (66:12).
**
Westminster City Council switchboard:
+44 20 7641 6000
**
This E-Mail may contain information which is
privileged, confidential and protected from
disclosure. If you are not the intended recipient
of this E-mail or any part of it, please telephone
Westminster City Council immediately on receipt.
You should not disclose the contents to any other
person or take copies.
**
__
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: error with a piece of cfscript code and I can't see what's wr ong?
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
It's alright I've seen the error, it's been a very long day.
-Original Message-----
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: 30 September 2002 15:55
To: CF-Talk
Subject: error with a piece of cfscript code and I can't see what's
wrong?
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Can anyone see what's wrong with this:
If (NOT IsDefined("Form.business_types") AND
(IsDefined("Form.residents")) {
session.ResidentsOnly = yes;
}
Else If (NOT IsDefined("Form.residents")) AND
(IsDefined("Form.business_type")) {
session.BusinessOnly = yes;
session.ListOfBusiness =
"#Form.business_types#";
}
Else {
session.ResidentsAndBusiness = yes;
session.ListOfBusiness =
"#Form.business_types#";
}
This is the error I keep getting:
Error Diagnostic Information
Just in time compilation error
Invalid parser construct found on line 67 at position 79. ColdFusion was
looking at the following text:{Invalid expression format. The usual cause is
an error in the expression structure.
The last successfully parsed CFML construct was a CFSCRIPT tag occupying
document position (66:3) to (66:12).
**
Westminster City Council switchboard:
+44 20 7641 6000
**
This E-Mail may contain information which is
privileged, confidential and protected from
disclosure. If you are not the intended recipient
of this E-mail or any part of it, please telephone
Westminster City Council immediately on receipt.
You should not disclose the contents to any other
person or take copies.
**
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
error with a piece of cfscript code and I can't see what's wrong?
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Can anyone see what's wrong with this:
If (NOT IsDefined("Form.business_types") AND
(IsDefined("Form.residents")) {
session.ResidentsOnly = yes;
}
Else If (NOT IsDefined("Form.residents")) AND
(IsDefined("Form.business_type")) {
session.BusinessOnly = yes;
session.ListOfBusiness =
"#Form.business_types#";
}
Else {
session.ResidentsAndBusiness = yes;
session.ListOfBusiness =
"#Form.business_types#";
}
This is the error I keep getting:
Error Diagnostic Information
Just in time compilation error
Invalid parser construct found on line 67 at position 79. ColdFusion was
looking at the following text:{Invalid expression format. The usual cause is
an error in the expression structure.
The last successfully parsed CFML construct was a CFSCRIPT tag occupying
document position (66:3) to (66:12).
**
Westminster City Council switchboard:
+44 20 7641 6000
**
This E-Mail may contain information which is
privileged, confidential and protected from
disclosure. If you are not the intended recipient
of this E-mail or any part of it, please telephone
Westminster City Council immediately on receipt.
You should not disclose the contents to any other
person or take copies.
**
__
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: more cfstoredproc issues ...
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** YOu can comment out the call to the stored procedure and then output all the variables you are passing, then use a CFABORT to stop the page this way you'll be sure the correct variables are being passed. Or for testing purposes hard-code a value in the LibraryID cfprocparam tag, if it does get passed in correctly then you will know that the problem is the stored procedure and not your CF. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 02:34 To: CF-Talk Subject: more cfstoredproc issues ... Argh! I have a stored procedure with parameters as: CREATE PROCEDURE tap_adLibUpdate @LibraryID int, @Ident int, @UpdatedDate datetime, @PageFileName varchar(15) = NULL, @ArchivePath varchar(15) = NULL, @Scheduled bit = 0, @RestoreID int = NULL, @UpdateError varchar(8000) = NULL AS and I'm using this code in CF: and I'm getting this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'tap_adLibUpdate' expects parameter '@LibraryID', which was not supplied. I know that the LibraryID parameter is defined in the tags. I know that none of it was misspelled. I know that the value of variables.PageID is an integer. What I don't know is why I'm getting an error message that tells me exactly what the problem is not. Anybody have any ideas? Isaac Dealey Certified Advanced ColdFusion 5 Developer new epoch www.turnkey.to 954-776-0046 __ 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: Error with a simple expression.
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Yep, that's how my page is working. Using the cfqueryparam has fixed the
problem. I definately need to look into what "cfqueryparam" can do, thanks
to everyone whos helped me with this.
Stephen
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2002 15:10
To: CF-Talk
Subject: Re: Error with a simple expression.
Adams, Stephen wrote:
>
> I tried your idea, and it still didn't work. I am trying to pass a link's
> (URL's) display name, which is "What's New" so I used your idea like this:
>
>
>
>
> UPDATE CouncilEmployeeLinks
> SET UserID = '#session.CORNTAccount#',
> link_type = '#FormLinkType[UpdateLoopIdx]#',
> link_address= '#FormLinkAddress[UpdateLoopIdx]#',
> display_name= '#PreserveSingleQuotes(What's New)#',
> myLinks_section = '#Evaluate("form.linkSection" &
> UpdateLoopIdx)#',
> date_added = '#DateFormat(Now(),"dd/mm/")#'
> WHERE ID = '#FormLinkID[UpdateLoopIdx]#'
>
Use cfqueryparam. I presume your formfields are actually name linktype1,
linktype2, linktype3 etc. which would lead to the code below:
UPDATE CouncilEmployeeLinks
SET
UserID =,
link_type = ,
link_address= ,
display_name= ,
myLinks_section = ,
date_added = current_date
WHERE ID =
Jochem
__
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: Error with a simple expression.
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Hi Denna,
I tried your idea, and it still didn't work. I am trying to pass a link's
(URL's) display name, which is "What's New" so I used your idea like this:
UPDATE CouncilEmployeeLinks
SET UserID = '#session.CORNTAccount#',
link_type = '#FormLinkType[UpdateLoopIdx]#',
link_address= '#FormLinkAddress[UpdateLoopIdx]#',
display_name= '#PreserveSingleQuotes(What's New)#',
myLinks_section = '#Evaluate("form.linkSection" &
UpdateLoopIdx)#',
date_added = '#DateFormat(Now(),"dd/mm/")#'
WHERE ID = '#FormLinkID[UpdateLoopIdx]#'
but it still fails on the updating of the display name. I tried hard coding
the "What's New" to see if that was definately the problem. It looks as
though PreseveSingleQuotes is not preventing CF from escaping the single
quotes.
Any ideas?
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2002 14:15
To: CF-Talk
Subject: Re: Error with a simple expression.
Didn't someone just figure out that there's a bug with the preserve single
quotes function such that you can't use other functions inside of it?
So, you'd have to do something like this:
Then use this in your query.
'#PreserveSingleQuotes(thisdisplay)#'
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
__
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: Error with a simple expression.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks Denna, I'll give it a go. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: 27 September 2002 14:15 To: CF-Talk Subject: Re: Error with a simple expression. Didn't someone just figure out that there's a bug with the preserve single quotes function such that you can't use other functions inside of it? So, you'd have to do something like this: Then use this in your query. '#PreserveSingleQuotes(thisdisplay)#' Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ 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: Error with a simple expression.
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
The error I was getting was this:
Error in custom ColdFusion module
(/wire/customcf/myLinks_admin_submitted.cfm)
Just in time compilation error
Invalid parser construct found on line 126 at position 64. ColdFusion was
looking at the following text:
(
Invalid expression format. The usual cause is an error in the expression
structure.
The last successfully parsed CFML construct was static text occupying
document position (125:66) to (126:33).
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2002 12:16
To: CF-Talk
Subject: Re: Error with a simple expression.
>
> Can anyone tell me why this simple expression
> '#PreserveSingleQuotes(Evaluate("FORM.displayName" & UpdateLoopIdx))#', it
> keeps failing, but I can't see why.
>
> Stephen
>
What error message are you getting??
Regards
Stephen
__
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: Error with a simple expression.
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
I am trying to use it in a UPDATE query, the error I was getting was this:
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2002 12:09
To: CF-Talk
Subject: RE: Error with a simple expression.
What error are you getting?
Try something like...
And see if you get the same error...
HTH
-Original Message-
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 11:55
To: CF-Talk
Subject: Error with a simple expression.
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Can anyone tell me why this simple expression
'#PreserveSingleQuotes(Evaluate("FORM.displayName" & UpdateLoopIdx))#',
it keeps failing, but I can't see why.
Stephen
**
Westminster City Council switchboard:
+44 20 7641 6000
**
This E-Mail may contain information which is
privileged, confidential and protected from
disclosure. If you are not the intended recipient
of this E-mail or any part of it, please telephone
Westminster City Council immediately on receipt.
You should not disclose the contents to any other
person or take copies.
**
__
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
Error with a simple expression.
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Can anyone tell me why this simple expression
'#PreserveSingleQuotes(Evaluate("FORM.displayName" & UpdateLoopIdx))#', it
keeps failing, but I can't see why.
Stephen
**
Westminster City Council switchboard:
+44 20 7641 6000
**
This E-Mail may contain information which is
privileged, confidential and protected from
disclosure. If you are not the intended recipient
of this E-mail or any part of it, please telephone
Westminster City Council immediately on receipt.
You should not disclose the contents to any other
person or take copies.
**
__
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: CFMAIL message resent, completed this time.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks, you're example works fine. Cheers. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:57 To: CF-Talk Subject: RE: CFMAIL message resent, completed this time. Right, but you still have to upload it and then delete it. See my example below :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 9/24/2002 10:38:22 AM >>> ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** No, I am sending the file as an attachment to a series of recipients. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:14 To: CF-Talk Subject: Re: CFMAIL message resent, completed this time. Are you uploading the file? Blah blah Message goes here Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ 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: CFMAIL message resent, completed this time.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** No, I am sending the file as an attachment to a series of recipients. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:14 To: CF-Talk Subject: Re: CFMAIL message resent, completed this time. Are you uploading the file? Blah blah Message goes here Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Error sending an attachment using CFMAIL
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Sorry, my clumbsy fingers sent the email before it was finished. I have sent another email with the complete error. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 15:04 To: CF-Talk Subject: Re: Error sending an attachment using CFMAIL What's the error? -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 *** Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2002/nominationform.cfm *** inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "Adams, Stephen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 10:00 AM Subject: Error sending an attachment using CFMAIL > ** > WESTMINSTER CITY COUNCIL > Please refer to the disclaimer beneath this message > ** > > Hi, > > I have a form in which a user adds a Subject, Message and selects a > Attachment on their local machine, this form is then submitted to another > page that runs a CFMAIL tag that sends the email. The problem is the > attachment, I browse to the file attach it to the email then when the form > is submitted the CFMAIL tag throws a error: > > > > ** > Westminster City Council switchboard: > +44 20 7641 6000 > ** > This E-Mail may contain information which is > privileged, confidential and protected from > disclosure. If you are not the intended recipient > of this E-mail or any part of it, please telephone > Westminster City Council immediately on receipt. > You should not disclose the contents to any other > person or take copies. > ** > > __ 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
CFMAIL message resent, completed this time.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi (again), As I was saying, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: Error Diagnostic Information Unable to attach file. Cannot attach 'C:\WINNT\TEMP\ACF474.tmp' to the mail message. The file does not exist. This is not the name of my attachment though (it was actually a jpg). I do have the form set to, enctype="multipart/form-data", I can't see why the attachment is passed as it's orignal address. How can I get the attachment to be passed and sent correctly by the CFMAIL tag? Thanks (sorry about the unfinshed email sent earlier) ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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
Error sending an attachment using CFMAIL
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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: Finding number of occurences of a field in a list.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks, should have looked further through the reference book. -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 12:00 To: CF-Talk Subject: RE: Finding number of occurences of a field in a list. Have a look at ListValueCountNoCase() and ListValueCount() HTH -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 11:53 To: CF-Talk Subject: Finding number of occurences of a field in a list. ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hello, How can I find out how many occurences there are of a field in the list FORM.fieldnames. This is so I can use this number as a count in a loop. Thanks ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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
Finding number of occurences of a field in a list.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hello, How can I find out how many occurences there are of a field in the list FORM.fieldnames. This is so I can use this number as a count in a loop. Thanks ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Referencing a dynamically named form field
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** The data returned from the form is used to update a table in the database. My form returns all the original data in a db, the user can then amend anything they want, either by checking another radio button or changing some text in a text box. Then they can submit the form and this should update the original data. -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: 20 September 2002 15:30 To: CF-Talk Subject: Re: Referencing a dynamically named form field My first question is, what are you trying to do with the data that is returned from the form? I think you are on the right path but might be getting muddled along the way. For instance, by giving each radio button a different name you are negating the use of radio buttons because it becomes possible for the user to select each one on the page. Sam - Original Message - From: "Adams, Stephen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 10:18 AM Subject: Referencing a dynamically named form field > ** > WESTMINSTER CITY COUNCIL > Please refer to the disclaimer beneath this message > ** > > Hi, > > I have created a form that is populated by a query, like this: > > > > > First Name: > Last Name: > checked > value="MyDepartment" checked> > value="MyWesminster" checked> > > > > > As you can see I have used an cfif statement to see which radio button > should be checked according to the queries results. I have had to use the > CurrentRow to give each set of checkboxes an individual name, so that they > don't over write each other when selected. This gives me a set of form > fields with names like linkSection1 and linkSection2, depending on how many > results are returned by my query. > > The problem I am having is referencing these checkboxes in my form action > page. I could just go #FORM.linkSection1# or > #FORM.linkSection2#, but the problems is I don't know > how many there will be. My query could return either 2 different results or > 50, that means I need to output either #FORM.linkSection1# to > #FORM.linkSection50#. > > My question is how can I call the form field no matter how many are passed. > > I have tried this: > > > > #FORM.linksSection# > > > but it failed. > > Any one got any ideas? > > Thanks > > Stephen > > > ** > Westminster City Council switchboard: > +44 20 7641 6000 > ** > This E-Mail may contain information which is > privileged, confidential and protected from > disclosure. If you are not the intended recipient > of this E-mail or any part of it, please telephone > Westminster City Council immediately on receipt. > You should not disclose the contents to any other > person or take copies. > ** > > __ 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
Referencing a dynamically named form field
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have created a form that is populated by a query, like this: First Name: Last Name: checked checked> checked> As you can see I have used an cfif statement to see which radio button should be checked according to the queries results. I have had to use the CurrentRow to give each set of checkboxes an individual name, so that they don't over write each other when selected. This gives me a set of form fields with names like linkSection1 and linkSection2, depending on how many results are returned by my query. The problem I am having is referencing these checkboxes in my form action page. I could just go #FORM.linkSection1# or #FORM.linkSection2#, but the problems is I don't know how many there will be. My query could return either 2 different results or 50, that means I need to output either #FORM.linkSection1# to #FORM.linkSection50#. My question is how can I call the form field no matter how many are passed. I have tried this: #FORM.linksSection# but it failed. Any one got any ideas? Thanks Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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: CFML tags available in CFSCRIPT
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Oh, the reason I asked was I have just read Kevin Towes' article "Using ColdFusion Tags in CFScript", and he runs a query and dumps the results from within CFScript. I thought this is a great idea and something I'd like to do in CF5 to split my page processing from the html. e.g. // do all the cf stuff here separately from html html displaying results of above CF. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 14:36 To: CF-Talk Subject: Re: CFML tags available in CFSCRIPT www.houseoffusion.com/docs/cfscript.htm This is complete for CF5 other than UDFs. No CF tags can be used in CFSCRIPT and the functionality that does exist is limited to 'basic' syntax. CFMX has more to it including try/catch and the ability to access CFCs. > Hi, > > Can anyone tell me which CFML tags are available in CFSCRIPT. I know about > CFLIB.org and some of the functions that resemble the way some tags work, > but are there function that work the same way as CFQUERY and CFFILE for > example. I am using CF5 and I was wondering if I can get a list of CFML > tags that can be called in CFSCRIPT. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
CFML tags available in CFSCRIPT
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, Can anyone tell me which CFML tags are available in CFSCRIPT. I know about CFLIB.org and some of the functions that resemble the way some tags work, but are there function that work the same way as CFQUERY and CFFILE for example. I am using CF5 and I was wondering if I can get a list of CFML tags that can be called in CFSCRIPT. ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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: Format of a form field passed as a session variable.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks a lot, -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 13:37 To: CF-Talk Subject: RE: Format of a form field passed as a session variable. There is nothing about setting a value to a session value that 'convets' the original data. The problem is with your HTML code most likely. Check the textarea tag and see if you have wrap=hard. This will add line breaks when the text wraps. My HTML may be a bit off - you may need wrap=virtual, whatever, but the point is, doing does NOTHING to the original data. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Adams, Stephen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 8:30 AM > To: CF-Talk > Subject: Format of a form field passed as a session variable. > > > ** > WESTMINSTER CITY COUNCIL > Please refer to the disclaimer beneath this message > ** > > Hi, > > I have a form that when submitted sets its fields as session > variable so > that the user can go back and forth and still keep the original form > details. One of these form fields is a textarea field that > takes in some > text which is sent as an email. When the email is sent the > text is one > large block, this is due to me setting it as a session > variable. Is there a > way I can keep the formatting of the text in the text area > when it is set as > a session variable or will I have to pass it between my pages > using hidden > fields in order to keep the format. > > Thanks > > Stephen > > > ** > Westminster City Council switchboard: > +44 20 7641 6000 > ** > This E-Mail may contain information which is > privileged, confidential and protected from > disclosure. If you are not the intended recipient > of this E-mail or any part of it, please telephone > Westminster City Council immediately on receipt. > You should not disclose the contents to any other > person or take copies. > ** > > __ 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
Format of a form field passed as a session variable.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a form that when submitted sets its fields as session variable so that the user can go back and forth and still keep the original form details. One of these form fields is a textarea field that takes in some text which is sent as an email. When the email is sent the text is one large block, this is due to me setting it as a session variable. Is there a way I can keep the formatting of the text in the text area when it is set as a session variable or will I have to pass it between my pages using hidden fields in order to keep the format. Thanks Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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: Problem building a comma separated list.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks, that's great, having a no-brainer day and its only Wednesday! -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 10:32 To: CF-Talk Subject: RE: Problem building a comma separated list. hows about : ListAppend(thisList,#ID#,",")> Neil -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 10:31 To: CF-Talk Subject: Problem building a comma separated list. ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am trying to build a comma separated list of ID number, something I have done many times before, but for some reason this code does not seem to be working. Here is my code: I know it is a bit of a no-brainer, but can anyone tell me where I am going wrong? Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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
Problem building a comma separated list.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am trying to build a comma separated list of ID number, something I have done many times before, but for some reason this code does not seem to be working. Here is my code: I know it is a bit of a no-brainer, but can anyone tell me where I am going wrong? Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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
Querying a CSV file
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** I have a CSV file that I want to query. In my CSV file I have added a row with the column names in it, but when I try to query the file I getan error. This is my query: SELECT CGNOx, CGNO FROM Pollution.csv WHERE Date = 20723 AND Time = 1245 And I get this error message. ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Text Driver] Too few parameters. Expected 2. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. Now this is the first time I have tried to use a csv file as a datasource, the file is verified as a datasource in CF administrator, but I am having trouble writing the query. Any help would be great, thanks. Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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: Putting a comma separated file into a multi dimension array.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks, good idea. I'll try that. > -- > From: Hugo Ahlenius[SMTP:[EMAIL PROTECTED]] > Sent: 24 July 2002 14:35 > To: CF-Talk > Subject: RE: Putting a comma separated file into a multi dimension > array. > > Can't you add it as a .csv data source? > > > > > - > Hugo Ahlenius E-Mail: [EMAIL PROTECTED] > Project Officer Phone: +46 8 7410451 > UNEP GRID-Arendal Fax: +46 733 403285 > Stockholm OfficeMobile:+46 733 467111 > WWW: http://www.grida.no > --------- > > > > | -Original Message- > | From: Adams, Stephen [mailto:[EMAIL PROTECTED]] > | Sent: Wednesday, July 24, 2002 15:19 > | To: CF-Talk > | Subject: Putting a comma separated file into a multi dimension array. > | > | > | ** > | WESTMINSTER CITY COUNCIL > | Please refer to the disclaimer beneath this message > | ** > | > | Hello, > | > | I have a comma separated file that contains about 11 columns > | and twenty odd > | rows. Now I would like to be able to put this into an array > | so that I can > | reference and call cells of this array and display them onto > | a webpage. I > | can easily put my file into a single dimension array, like this: > | > | | file="G:\file.txt" > | variable="List"> > | > | > | > | > | > |
Putting a comma separated file into a multi dimension array.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hello, I have a comma separated file that contains about 11 columns and twenty odd rows. Now I would like to be able to put this into an array so that I can reference and call cells of this array and display them onto a webpage. I can easily put my file into a single dimension array, like this:
RE: Finding a good Session management system.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Matthieu, Thanks for sharing this, its a nice idea. It is the kind of thing I was interested in hearing about. > -- > From: Cornillon, Matthieu[SMTP:[EMAIL PROTECTED]] > Sent: 22 July 2002 15:36 > To: CF-Talk > Subject: RE: Finding a good Session management system. > > Stephen, > > I am not going to comment on the client vs. session variable issue that > everyone else is talking about. I am awfully ignorant about client > variables, and I am learning from those other messages as they come. > > I can, however, offer some advice on the approach to a multi-page form > with > session variables. I just (last night) released a multi-page registration > system for a web site. When I started, I thought, "I'll just put the > variables from each form submission into a session variable, which I will > store until the end of the process, at which point everything will be > submitted at once." OK. That made sense, but with locking and keeping > track of things and needing to let the user go back and forth and edit > data, > things got miserable from a variable management standpoint. Halfway > through, although I kept the basic concept the same, I made a change which > greatly simplified my life. > > Here's the idea: the biggest heartaches came in testing for a variable's > existence, providing for all possible cases of its value, and the locking > issues. So, I eliminated all of them. I created a page called > registration_init.cfm that set to default values all of the session > variables that I would be using throughout the registration process. At > the > top of each page, I have one CFLOCK block that pulls all of the relevant > session variables for the form into local variables. Each page then > pre-populates its form fields with those local variables, regardless of > their value; if they are blank, fine, and if they have data from the > session > variables, fine. This allows you to go back and forth between forms very > easily. I also set up my pages in a (probably inefficient) funny way. > The > flow is like this: > > registration_init.cfm > registration1.cfm > registration1_action.cfm > registration2cfm > registration2_action.cfm > etc. > > Each "action" page validates all of the data and goes to the appropriate > page: forward if everything is okay, and back if it's not. If it goes > back, > it also passes error values which appear on the page to let the user know > what they did wrong and how to fix it. I can't remember right now if this > flow setup tied into the session variable management issue, but just so > you > have some more ideas, I thought I'd throw it in. > > Anyhow, the main thing is that by pre-defining all the variables that I > was > going to use, I removed the need to check their values on each page. Of > course, it's essentially doing the same thing, but by doing it in a > centralized way was a lot easier. > > Hope this rambling is helpful, > Matthieu > -Original Message- > From: Adams, Stephen [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 22, 2002 9:30 AM > To: CF-Talk > Subject: RE: Finding a good Session management system. > > > ** > WESTMINSTER CITY COUNCIL > Please refer to the disclaimer beneath this message > ** > > Well, the application I am building at the moment uses a series of forms > to > gather information from the user and then on the final page runs a query > based on what has been selected in these forms. So I am storing some of > the > user's choices in session variables so that they can be passed can be used > in the query on the last page. This is quiet a small application. My > next > one is going to be a large intranet with a lot of personalisation. > > Oh I love web-rat.com by the way, great site. > > Stephen > > > > -- > > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > > Sent: 22 July 2002 14:10 > > To: CF-Talk > > Subject:RE: Finding a good Session management system. > > > > That was a pretty vague and not very helpful answer John. > > > > Stephen, what all are you storing in session variables? Could you > > describe your application a little more? I've always tried to make sure > > > that I'
RE: Finding a good Session management system.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks, this is very helpful. > -- > From: Stephen Moretti[SMTP:[EMAIL PROTECTED]] > Sent: 22 July 2002 14:59 > To: CF-Talk > Subject: Re: Finding a good Session management system. > > > > > I like you idea have you got a small example of this so I can see exatly > > what you talking about. > > > > Yup > > > > > > > > #request.sessionvar.userid# > > > > > > > > > Hope that helps... > > Stephen > > > __ 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: Finding a good Session management system.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I like you idea have you got a small example of this so I can see exatly what you talking about. Stephen > -- > From: Stephen Moretti[SMTP:[EMAIL PROTECTED]] > Sent: 22 July 2002 14:31 > To: CF-Talk > Subject: Re: Finding a good Session management system. > > Bah Humbug > > Use Client variables Just don't forget that you must change the > default > client store from registry to a datasource (whatever the operating system > you're running on) otherwise your registry will either fill up quickly or > just slow your application down horrendously. > > Better ways of handling your session variables. > Copy your entire session scop to a request variable in Application.cfm and > back again in onRequestEnd.cfm. This way during the users request to site > whatever session variable you need is in the request scope. No messing > with > cflocks in the rest of your code Make sure you do a Duplicate() rather > than StructCopy or request.session = session > > Or you could buy CFMX and do away with cflocking (unless there's going to > be > any kind of race condition) > > Regards > > Stephen > > > Don't use session variables, > > but use cookies which maintain session state when the browser is open > > and deleted when closed. > > > > -Original Message- > > From: Adams, Stephen [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 22, 2002 1:54 PM > > To: CF-Talk > > Subject: Finding a good Session management system. > > > > > > ** > > WESTMINSTER CITY COUNCIL > > Please refer to the disclaimer beneath this message > > ** > > > > Hi, > > > > I have been building CF sites for a while now and I am always finding > myself > > creating/deleting and checking for session variables or changing them > into > > request variables. It always seems to me that there must be a better > way > in > > which to use them. A way that lets me create them easily, delete them, > keep > > track of them with out have to write tons of code and does not add loads > of > > time to the running of my applications.. > > Does anyone know of or have any tips on how I can easily handle the > > management of session variables. > > > > Thanks > > > > Stephen > > > > > > ** > > Westminster City Council switchboard: > > +44 20 7641 6000 > > ** > > This E-Mail may contain information which is > > privileged, confidential and protected from > > disclosure. If you are not the intended recipient > > of this E-mail or any part of it, please telephone > > Westminster City Council immediately on receipt. > > You should not disclose the contents to any other > > person or take copies. > > ** > > > > > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Finding a good Session management system.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Well, the application I am building at the moment uses a series of forms to gather information from the user and then on the final page runs a query based on what has been selected in these forms. So I am storing some of the user's choices in session variables so that they can be passed can be used in the query on the last page. This is quiet a small application. My next one is going to be a large intranet with a lot of personalisation. Oh I love web-rat.com by the way, great site. Stephen > -- > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > Sent: 22 July 2002 14:10 > To: CF-Talk > Subject: RE: Finding a good Session management system. > > That was a pretty vague and not very helpful answer John. > > Stephen, what all are you storing in session variables? Could you > describe your application a little more? I've always tried to make sure > that I'm using session variables as little as possible anymore. I've > moved majority of my session variables into client variables (storage in > db). None the less, there's still a variable management issue that you > have to get your fingers wrapped around. Perhaps you're storing too much > information into the session scope if you're pondering that there has to > be a better way. > > So.. my advice to you is to do a (proper locks > around of course) and take a good hard look at what really should / > shouldn't be there. > > ~Todd > > On Mon, 22 Jul 2002, John McCosker wrote: > > > Don't use session variables, > > but use cookies which maintain session state when the browser is open > > and deleted when closed. > > > > -Original Message- > > From: Adams, Stephen [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 22, 2002 1:54 PM > > To: CF-Talk > > Subject: Finding a good Session management system. > > > > > > ** > > WESTMINSTER CITY COUNCIL > > Please refer to the disclaimer beneath this message > > ** > > > > Hi, > > > > I have been building CF sites for a while now and I am always finding > myself > > creating/deleting and checking for session variables or changing them > into > > request variables. It always seems to me that there must be a better > way in > > which to use them. A way that lets me create them easily, delete them, > keep > > track of them with out have to write tons of code and does not add loads > of > > time to the running of my applications.. > > Does anyone know of or have any tips on how I can easily handle the > > management of session variables. > > > > Thanks > > > > Stephen > > > > > > ** > > Westminster City Council switchboard: > > +44 20 7641 6000 > > ** > > This E-Mail may contain information which is > > privileged, confidential and protected from > > disclosure. If you are not the intended recipient > > of this E-mail or any part of it, please telephone > > Westminster City Council immediately on receipt. > > You should not disclose the contents to any other > > person or take copies. > > ** > > > > > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
Finding a good Session management system.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have been building CF sites for a while now and I am always finding myself creating/deleting and checking for session variables or changing them into request variables. It always seems to me that there must be a better way in which to use them. A way that lets me create them easily, delete them, keep track of them with out have to write tons of code and does not add loads of time to the running of my applications.. Does anyone know of or have any tips on how I can easily handle the management of session variables. Thanks Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Setting a dynamically built list as a session variable.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Well, thanks for all the replys. They have all been very helpful. I've managed to fix the problem I had through your suggestions. Thanks a lot. Stephen > -- > From: Tangorre, Michael[SMTP:[EMAIL PROTECTED]] > Sent: 22 July 2002 12:34 > To: CF-Talk > Subject: RE: Setting a dynamically built list as a session variable. > > nevermind, found the article on it: > http://www.macromedia.com/v1/Handlers/index.cfm?ID=23021&Method=Full > > mike > > > -Original Message- > From: Tangorre, Michael > Sent: Monday, July 22, 2002 7:26 AM > To: CF-Talk > Subject: RE: Setting a dynamically built list as a session variable. > > > How come you do not have to lock on MX? > > > -Original Message- > From: Stephen Moretti [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 22, 2002 7:24 AM > To: CF-Talk > Subject: Re: Setting a dynamically built list as a session variable. > > > Stephen, > > First up. You don't need to name each of your checkboxes seperately, so > change the input tag to this : > > > > and your javascript to this : > > > > > > > > > My question is how can I create this session variable from this dynamic > list > > of form variables? > > > > Now what you'll get is one form variable called business_types with all > the > checked business types as a comma delimited list. > > To make this form variable into a session variable in your action page is > as > simple as : > > > > Don't forget get your cflock if your not on CFMX. > > Regards > > Stephen > > > > > __ 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
Setting a dynamically built list as a session variable.
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a form page that creates a list of checkboxes that have been populated by a loop. Like this: #bus_type# Each checkbox name has to have its own name as I am using a JavaScript function to check and uncheck all of them at the same time. So they need to be individually check by the JS function to see if they are checked or not. Here is my JS function: In my action page I want to set all the passed/checked checkboxes as one single session variable so it can be used later on in another page. My question is how can I create this session variable from this dynamic list of form variables? Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Writing efficient CFIF statements
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** True, I have looked at Fusebox, but at the moment I am not building a Fusebox app, but I see your point and I should use what I know about Fusebox and apply it to my none Fusebox code. > -- > From: Douglas Brown[SMTP:[EMAIL PROTECTED]] > Sent: 16 July 2002 16:20 > To: CF-Talk > Subject: Re: Writing efficient CFIF statements > > If you are going to do that, you might think of using fusebox, which does > a > very good job of seperating the application logic away from the the > display. > You can also use just one layout file and have it inherited by all the > child > directories etc... > > http://www.fusebox.org > > > > > > > Douglas Brown > Email: [EMAIL PROTECTED] > - Original Message - > From: "Adams, Stephen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 16, 2002 8:13 AM > Subject: RE: Writing efficient CFIF statements > > > > ** > > WESTMINSTER CITY COUNCIL > > Please refer to the disclaimer beneath this message > > ** > > > > Thanks Joe, > > > > That was what I was kind of looking for. I am also thinking about the > way I > > design application. I find that a lot of my app's are not very > flexable. If > > someone wants to have a new field in a form or a new page added in > between > > two existing pages. I find it causes me a lot of re-writing to make > these > > simple changes. > > > > Does anyone have any tips that could help me design better code. > > > > Stephen > > > > > -- > > > From: Joe Bastian[SMTP:[EMAIL PROTECTED]] > > > Sent: 16 July 2002 16:06 > > > To: CF-Talk > > > Subject: RE: Writing efficient CFIF statements > > > > > > The LEAST no of "CFIF" is the route to best code/speed etc.. This is > my > > > theory though > > > Using CFSCRIPT blocks, short-cut evaluation, Switch statements > wherever > > > possible than > > > CFIF, arranging likely executable CFIF's/Switch first etc > > > > > > > > > Would be cleaner code to seperate Application Logic from Presentation > > > layer. > > > eg qry_studentStatus.cfm (Query) > > > dsp_studentStatus.cfm(Display) > > > Use of CFoutput's only where necessary is faster than wraping it > around > > > entire HTML etc. > > > > > > Joe > > > Certified Advanced ColdFusion Developer > > > [EMAIL PROTECTED] > > > > > > -Original Message- > > > From: Adams, Stephen [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, July 16, 2002 5:09 AM > > > To: CF-Talk > > > Subject: Writing efficient CFIF statements > > > > > > > > > ** > > > WESTMINSTER CITY COUNCIL > > > Please refer to the disclaimer beneath this message > > > ** > > > > > > Hi, > > > > > > I am trying to put more structure into my CF code. My idea is to > separate > > > the ColdFusion processing from the HTML structure and use CSS for the > look > > > of the site. I am trying to get an idea of what is the best way to > > > separate > > > the CF. I know that I could use custom tags, user defined function > and if > > > I > > > was using MX, then components. But these are for code that can across > > > used > > > in multiple pages. What I am talking about is the CF for an > individual > > > page. > > > > > > What has all this to do with CFIF statements, well. I was thinking of > > > setting a series of flags that are checked against in my HTML. The > CFIF > > > statements are there to check the value of these flags and amend the > page > > > depending on these flags. So I want to be able to write good > efficient > > > CFIF > > > statements so that my code is up to speed. > > > > > > Here's an example of what I am talking about: > > > > > > > > > &g
RE: Writing efficient CFIF statements
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks Joe, That was what I was kind of looking for. I am also thinking about the way I design application. I find that a lot of my app's are not very flexable. If someone wants to have a new field in a form or a new page added in between two existing pages. I find it causes me a lot of re-writing to make these simple changes. Does anyone have any tips that could help me design better code. Stephen > -- > From: Joe Bastian[SMTP:[EMAIL PROTECTED]] > Sent: 16 July 2002 16:06 > To: CF-Talk > Subject: RE: Writing efficient CFIF statements > > The LEAST no of "CFIF" is the route to best code/speed etc.. This is my > theory though > Using CFSCRIPT blocks, short-cut evaluation, Switch statements wherever > possible than > CFIF, arranging likely executable CFIF's/Switch first etc > > > Would be cleaner code to seperate Application Logic from Presentation > layer. > eg qry_studentStatus.cfm (Query) > dsp_studentStatus.cfm(Display) > Use of CFoutput's only where necessary is faster than wraping it around > entire HTML etc. > > Joe > Certified Advanced ColdFusion Developer > [EMAIL PROTECTED] > > -Original Message- > From: Adams, Stephen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 5:09 AM > To: CF-Talk > Subject: Writing efficient CFIF statements > > > ** > WESTMINSTER CITY COUNCIL > Please refer to the disclaimer beneath this message > ** > > Hi, > > I am trying to put more structure into my CF code. My idea is to separate > the ColdFusion processing from the HTML structure and use CSS for the look > of the site. I am trying to get an idea of what is the best way to > separate > the CF. I know that I could use custom tags, user defined function and if > I > was using MX, then components. But these are for code that can across > used > in multiple pages. What I am talking about is the CF for an individual > page. > > What has all this to do with CFIF statements, well. I was thinking of > setting a series of flags that are checked against in my HTML. The CFIF > statements are there to check the value of these flags and amend the page > depending on these flags. So I want to be able to write good efficient > CFIF > statements so that my code is up to speed. > > Here's an example of what I am talking about: > > > > > > > SELECT * > FROMmyTable > > > > > > > > > > > > Untitled > > > > > > > > Results found. > > > > > > No results found. > > > > > > > This is a simple example, but it shows how I want to keep the processing > separate at the top of the page. > > My question, finally, is how are CFIF statements best written if I want to > code this way and or is there a better way of writing my CF code. > > Thanks. > > > ** > Westminster City Council switchboard: > +44 20 7641 6000 > ** > This E-Mail may contain information which is > privileged, confidential and protected from > disclosure. If you are not the intended recipient > of this E-mail or any part of it, please telephone > Westminster City Council immediately on receipt. > You should not disclose the contents to any other > person or take copies. > ** > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Writing efficient CFIF statements
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Yeah, I like that idea. Thanks I think I'll try and use it.
Cheers.
> --
> From: Tim Painter[SMTP:[EMAIL PROTECTED]]
> Sent: 16 July 2002 11:51
> To: CF-Talk
> Subject: Re: Writing efficient CFIF statements
>
> IIF is slower. Couldn't you just do:
>
>
>
> If recordcount is 0, it would be false anyway
>
> - Original Message -
> From: "Adrian Lynch" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 16, 2002 6:36 AM
> Subject: RE: Writing efficient CFIF statements
>
>
> > Looks cleaner, but isn't it slower?
> >
> > -Original Message-
> > From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]]
> > Sent: 16 July 2002 11:31
> > To: CF-Talk
> > Subject: RE: Writing efficient CFIF statements
> >
> >
> > Any opionions on:
> >
> > > DE("True"))>
> >
> > ?
> >
> > Cheers, Hugo
> >
> >
> > -
> > Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
> > Project Officer Phone: +46 8 7410451
> > UNEP GRID-Arendal Fax: +46 733 403285
> > Stockholm OfficeMobile:+46 733 467111
> > WWW: http://www.grida.no
> > -
> >
> >
> >
> > | -Original Message-
> > | From: Tim Painter [mailto:[EMAIL PROTECTED]]
> > | Sent: Tuesday, July 16, 2002 12:19
> > | To: CF-Talk
> > | Subject: Re: Writing efficient CFIF statements
> > |
> > |
> > | Stephen,
> > |I usually like to set things either "true" or "false".
> > | (or 1 or 0). The true or false is a little more visual, I
> > | think -- so to use your example, I would do it like:
> > |
> > |
> > |
> > |
> > |
> > |
> > |
> > |
> > |There are records
> > |
> > | No records to display
> > |
> > |
> > | This is reverse of yours (if there are no records, then the
> > | variable is false -- your example shows as true) To me it
> > | made more sense to have that variable false.
> > |
> > | Of course, you can bypass the whole cfif and use the
> > | myQuery.RecordCount and test whether that is true/false:
> > |
> > | There are records
> > |
> > | No records to display.
> > |
> > |
> > |
> > |
> > | - Original Message -
> > | From: "Adams, Stephen" <[EMAIL PROTECTED]>
> > | To: "CF-Talk" <[EMAIL PROTECTED]>
> > | Sent: Tuesday, July 16, 2002 5:08 AM
> > | Subject: Writing efficient CFIF statements
> > |
> > |
> > | >
> > | **
> > | > WESTMINSTER CITY COUNCIL
> > | > Please refer to the disclaimer beneath this message
> > | >
> > | **
> > | >
> > | > Hi,
> > | >
> > | > I am trying to put more structure into my CF code. My idea
> > | is to separate
> > | > the ColdFusion processing from the HTML structure and use
> > | CSS for the look
> > | > of the site. I am trying to get an idea of what is the
> > | best way to separate
> > | > the CF. I know that I could use custom tags, user defined
> > | function and if I
> > | > was using MX, then components. But these are for code that
> > | can across used
> > | > in multiple pages. What I am talking about is the CF for
> > | an individual
> > | > page.
> > | >
> > | > What has all this to do with CFIF statements, well. I was
> > | thinking of
> > | > setting a series of flags that are checked against in my
> > | HTML. The CFIF
> > | > statements are there to check the value of these flags and
> > | amend the page
> > | > depending on these flags. So I want to be able to write
> > | good efficient CFIF
> > | > statements so that my code is up to speed.
> > | >
RE: Writing efficient CFIF statements
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Yep it does look a lot cleaner than what I have been doing, but I do have to
agree with Adrian that it could be slower. I have heard somewhere can't
remember where. That using IIF() is slower.
> --
> From: Adrian Lynch[SMTP:[EMAIL PROTECTED]]
> Sent: 16 July 2002 11:36
> To: CF-Talk
> Subject: RE: Writing efficient CFIF statements
>
> Looks cleaner, but isn't it slower?
>
> -Original Message-
> From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]]
> Sent: 16 July 2002 11:31
> To: CF-Talk
> Subject: RE: Writing efficient CFIF statements
>
>
> Any opionions on:
>
> DE("True"))>
>
> ?
>
> Cheers, Hugo
>
>
> -
> Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
> Project Officer Phone: +46 8 7410451
> UNEP GRID-Arendal Fax: +46 733 403285
> Stockholm OfficeMobile:+46 733 467111
> WWW: http://www.grida.no
> -
>
>
>
> | -Original Message-
> | From: Tim Painter [mailto:[EMAIL PROTECTED]]
> | Sent: Tuesday, July 16, 2002 12:19
> | To: CF-Talk
> | Subject: Re: Writing efficient CFIF statements
> |
> |
> | Stephen,
> |I usually like to set things either "true" or "false".
> | (or 1 or 0). The true or false is a little more visual, I
> | think -- so to use your example, I would do it like:
> |
> |
> |
> |
> |
> |
> |
> |
> |There are records
> |
> | No records to display
> |
> |
> | This is reverse of yours (if there are no records, then the
> | variable is false -- your example shows as true) To me it
> | made more sense to have that variable false.
> |
> | Of course, you can bypass the whole cfif and use the
> | myQuery.RecordCount and test whether that is true/false:
> |
> | There are records
> |
> | No records to display.
> |
> |
> |
> |
> | - Original Message -
> | From: "Adams, Stephen" <[EMAIL PROTECTED]>
> | To: "CF-Talk" <[EMAIL PROTECTED]>
> | Sent: Tuesday, July 16, 2002 5:08 AM
> | Subject: Writing efficient CFIF statements
> |
> |
> | >
> | **
> | > WESTMINSTER CITY COUNCIL
> | > Please refer to the disclaimer beneath this message
> | >
> | **
> | >
> | > Hi,
> | >
> | > I am trying to put more structure into my CF code. My idea
> | is to separate
> | > the ColdFusion processing from the HTML structure and use
> | CSS for the look
> | > of the site. I am trying to get an idea of what is the
> | best way to separate
> | > the CF. I know that I could use custom tags, user defined
> | function and if I
> | > was using MX, then components. But these are for code that
> | can across used
> | > in multiple pages. What I am talking about is the CF for
> | an individual
> | > page.
> | >
> | > What has all this to do with CFIF statements, well. I was
> | thinking of
> | > setting a series of flags that are checked against in my
> | HTML. The CFIF
> | > statements are there to check the value of these flags and
> | amend the page
> | > depending on these flags. So I want to be able to write
> | good efficient CFIF
> | > statements so that my code is up to speed.
> | >
> | > Here's an example of what I am talking about:
> | >
> | >
> | >
> | >
> | >
> | >
> | > SELECT *
> | > FROMmyTable
> | >
> | >
> | >
> | >
> | >
> | >
> | >
> | >
> | >
> | >
> | >
> | > Untitled
> | >
> | >
> | >
> | >
> | >
> | >
> | >
> | > Results found.
> | >
> | >
> | >
> | >
> | >
> | > No results found.
> | >
> | >
> | >
> | >
> | >
> | >
> | > This is a simple example, but it shows how I want to keep
> | the processing
> | > separate at the top of the page.
Writing efficient CFIF statements
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am trying to put more structure into my CF code. My idea is to separate the ColdFusion processing from the HTML structure and use CSS for the look of the site. I am trying to get an idea of what is the best way to separate the CF. I know that I could use custom tags, user defined function and if I was using MX, then components. But these are for code that can across used in multiple pages. What I am talking about is the CF for an individual page. What has all this to do with CFIF statements, well. I was thinking of setting a series of flags that are checked against in my HTML. The CFIF statements are there to check the value of these flags and amend the page depending on these flags. So I want to be able to write good efficient CFIF statements so that my code is up to speed. Here's an example of what I am talking about: SELECT * FROMmyTable Untitled Results found. No results found. This is a simple example, but it shows how I want to keep the processing separate at the top of the page. My question, finally, is how are CFIF statements best written if I want to code this way and or is there a better way of writing my CF code. Thanks. ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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
Downloading CFMX
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I want to download CFMX over a 56k modem, so I can use the developer version at home. This download can take about 7 hours, so I want to download it in stages using a download manager, but when I orignally tried to do this my download manager did not kick in. Can CFMX be downloaded using a manager or not? Thanks Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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
Opening a MS word document from a remote server using http
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, Is it possible, and if so how can you open a MS Word document from a remote server, in its own application and not a browser window ? Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** 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
