OT:Looking for a good SQL mailing list

2002-10-30 Thread Adams, Stephen
** 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 w

RE: OT: SQL Server database problem

2002-10-28 Thread Adams, Stephen
** 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 t

RE: OT: SQL Server database problem

2002-10-28 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Alex thank you that was the cause of the problem. Stephen -Original Messa

RE: OT: SQL Server database problem

2002-10-28 Thread Adams, Stephen
50 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]>: > &

OT: SQL Server database problem

2002-10-28 Thread Adams, Stephen
** 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

How can you get the latest version of a page.

2002-10-18 Thread Adams, Stephen
** 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

RE: Recommendations - Java tutorials

2002-10-11 Thread Adams, Stephen
** 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 an

Problem with a dynamic menu and loops.

2002-10-10 Thread Adams, Stephen
** 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. T

RE: error with a piece of cfscript code and I can't see what's wr ong?

2002-09-30 Thread Adams, Stephen
t;#Form.business_types#"; } Else { session.ResidentsAndBusiness = 'yes'; session.ListOfBusiness = "#Form.business_types#"; } -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Monday, Septembe

RE: error with a piece of cfscript code and I can't see what's wr ong?

2002-09-30 Thread Adams, Stephen
-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 CO

error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Can anyone see what's wrong with this: If (NOT IsDef

RE: more cfstoredproc issues ...

2002-09-30 Thread Adams, Stephen
** 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 v

RE: Error with a simple expression.

2002-09-27 Thread Adams, Stephen
d 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.

RE: Error with a simple expression.

2002-09-27 Thread Adams, Stephen
** 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

RE: Error with a simple expression.

2002-09-27 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks Denna, I'll give it a go. -Original Message- From: Deanna Schn

RE: Error with a simple expression.

2002-09-27 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** The error I was getting was this: Error in custom ColdFusion module (/wire/cu

RE: Error with a simple expression.

2002-09-27 Thread Adams, Stephen
: -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

Error with a simple expression.

2002-09-27 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Can anyone tell me why this simple expression '#PreserveSingleQuotes(Evaluate(

RE: CFMAIL message resent, completed this time.

2002-09-24 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks, you're example works fine. Cheers. -Original Message- From:

RE: CFMAIL message resent, completed this time.

2002-09-24 Thread Adams, Stephen
** 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. -Or

RE: Error sending an attachment using CFMAIL

2002-09-24 Thread Adams, Stephen
coolfusion.com/imssecomparison.cfm - Original Message - From: "Adams, Stephen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 10:00 AM Sub

CFMAIL message resent, completed this time.

2002-09-24 Thread Adams, Stephen
** 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, Me

Error sending an attachment using CFMAIL

2002-09-24 Thread Adams, Stephen
** 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 Attac

RE: Finding number of occurences of a field in a list.

2002-09-23 Thread Adams, Stephen
. -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

Finding number of occurences of a field in a list.

2002-09-23 Thread Adams, Stephen
** 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 lis

RE: Referencing a dynamically named form field

2002-09-20 Thread Adams, Stephen
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

Referencing a dynamically named form field

2002-09-20 Thread Adams, Stephen
** 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:

RE: CFML tags available in CFSCRIPT

2002-09-17 Thread Adams, Stephen
** 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 ColdFu

CFML tags available in CFSCRIPT

2002-09-17 Thread Adams, Stephen
** 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 abou

RE: Format of a form field passed as a session variable.

2002-09-17 Thread Adams, Stephen
edi 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 &

Format of a form field passed as a session variable.

2002-09-17 Thread Adams, Stephen
** 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

RE: Problem building a comma separated list.

2002-08-14 Thread Adams, Stephen
esday! -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: Adam

Problem building a comma separated list.

2002-08-14 Thread Adams, Stephen
** 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 hav

Querying a CSV file

2002-07-24 Thread Adams, Stephen
** 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 wit

RE: Putting a comma separated file into a multi dimension array.

2002-07-24 Thread Adams, Stephen
6 733 467111 > WWW: http://www.grida.no > --------- > > > > | -Original Message- > | From: Adams, Stephen [mailto:[EMAIL PROTECTED]] > | Sent: Wednesday, July 24, 2002 15:19 >

Putting a comma separated file into a multi dimension array.

2002-07-24 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hello, I have a comma separated file that contains about 11 columns and twent

RE: Finding a good Session management system.

2002-07-22 Thread Adams, Stephen
ariable 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 es

RE: Finding a good Session management system.

2002-07-22 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks, this is very helpful. > -- > From: Stephen Moretti[SM

RE: Finding a good Session management system.

2002-07-22 Thread Adams, 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

RE: Finding a good Session management system.

2002-07-22 Thread Adams, Stephen
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- > > F

Finding a good Session management system.

2002-07-22 Thread Adams, Stephen
** 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 mys

RE: Setting a dynamically built list as a session variable.

2002-07-22 Thread Adams, Stephen
** 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 manag

Setting a dynamically built list as a session variable.

2002-07-22 Thread Adams, Stephen
** 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 popul

RE: Writing efficient CFIF statements

2002-07-16 Thread Adams, Stephen
ries etc... > > http://www.fusebox.org > > > > > > > Douglas Brown > Email: [EMAIL PROTECTED] > - Original Message - > From: "Adams, Stephen" <[EMAIL PROTECTED]> > To: "CF-Talk" <

RE: Writing efficient CFIF statements

2002-07-16 Thread Adams, Stephen
. > 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---

RE: Writing efficient CFIF statements

2002-07-16 Thread Adams, Stephen
t; | > > | > > | > > | > > | > > | > > | > > |There are records > > | > > | No records to display > > | > > | > > | This is reverse of yours (if there are no records, then the > > | variable is false -- your

RE: Writing efficient CFIF statements

2002-07-16 Thread Adams, Stephen
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: > |

Writing efficient CFIF statements

2002-07-16 Thread Adams, Stephen
** 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 separat

Downloading CFMX

2002-05-31 Thread Adams, Stephen
** 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 ver

Opening a MS word document from a remote server using http

2002-05-20 Thread Adams, Stephen
** 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 remo