CFFTP error code 1

2000-12-12 Thread Michael Gagnon
I am getting a Cold Fusion error code 1 every time I try to connect by FTP with CFFTP. The codes should be correct because this option worked correctly before I formated and reinstalled everything. The FTP server and the account used work fine. I connnected with different FTP clients. What could

BULK INSERT with MS-Access 2000

2000-12-11 Thread Michael Gagnon
Hi! Does anyone know if "BULK INSERT" works with a MS-Access 2000 database? I have the latest MDAC (2.6) installed. I get the following error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT'

Re: BULK INSERT - Access or ODBC incompatibility?

2000-12-09 Thread Michael Gagnon
Hi! Thanks for all the help!! I don't quite understand how you did this. Did you create a custom tag, or did you just map an administrator's password? If you used a custom tag, how did you pass the local file? TIA, _____ Michael Gagnon - Original Message

BULK INSERT - Access or ODBC incompatibility?

2000-12-08 Thread Michael Gagnon
Hi! I am using the SQL7's "BULK INSERT", but I get the following error: ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@house

Re: Bulk imports into database

2000-12-08 Thread Michael Gagnon
Does this command only work with 4.5? I am using 4.0. - Original Message - From: "paul smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, December 04, 2000 9:17 PM Subject: Re: Bulk imports into database > I use the following for BULK INSERTs > >

Bulk imports into database

2000-12-04 Thread Michael Gagnon
Hi! I am looking for a way to batch import data into a table using Cold Fusion (or other means) through the Internet. I have 2 columns, Fullname and email. Does anyone know of a way that I could do this? Thanks! Michael Gagnon

Re: Lost installation CD

2000-11-18 Thread Michael Gagnon
Yup, it checked, but their evals are for version 4.5. 4.0 is not there. After 2 days of looking, I finally found my CD in the Cold Fusion Studio box. Thanks! ___ Michael Gagnon - Original Message - From: "Denise Rolen" <[EMAIL PROTECTED]> To: "CF-Ta

Lost installation CD

2000-11-18 Thread Michael Gagnon
This is a multi-part message in MIME format. --=_NextPart_000_0016_01C05155.CC385DD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HELP!!! Our server crashed and need to reinstall CF on our server, but I can't find the installation CD. I

Adding colums to MS Access Tables with CF

2000-11-16 Thread Michael Gagnon
Hi! Is there a way to add colums to a MS Access database table using Cold Fusion? TIA! ___ Michael Gagnon Structure your ColdFusion code with Fusebox. Get the official book at https://secure.houseoffusion.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com

CFLoop problem

2000-11-16 Thread Michael Gagnon
Hi! I've got this weird problem that I cannot solve. I get the same answers on each line. #txt# I get: 1 Producteur Producer Productor 2 Producteur Producer Productor 3 Producteur Producer Productor 4 Producteur Producer Productor 5 Producteur Producer Productor

Re: Find character not in a list (reverse of FindOneOf).

2000-10-29 Thread Michael Gagnon
This is great! How would I add the dash, dot and underscore to the list of accepted characters? TIA!! Michael Gagnon - Original Message - From: "Steve Bernard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday,

Find character not in a list (reverse of FindOneOf).

2000-10-27 Thread Michael Gagnon
Hi! Is there a way to ask ColdFusion to look in a variable for any character that is NOT in a list? The oposit of "FindOneOf". (If one of the characters in form.username is not in this list, do this...) Thanks! -

CFX_CHECK_EMAIL tag problems

2000-10-25 Thread Michael Gagnon
if I don't have any. (14) Is there a more recent script than Oct. 17 1996? Thanks! ______ Michael Gagnon Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Un

Re: Problem with email form validation

2000-10-24 Thread Michael Gagnon
Submit="return CheckEmail();" > > Bob > > -Original Message- > From: Michael Gagnon [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 24, 2000 10:51 AM > To: CF-Talk > Subject: Problem with email form validation > > > Hi! > > I was wondering if there

Re: Problem with email form validation

2000-10-24 Thread Michael Gagnon
t; } > > otherwise, the script will always return true, and always think the email is > correct. > > chris olive, cio > cresco technologies > [EMAIL PROTECTED] > http://www.crescotech.com > > > > -Original Message- > From: Michael Gagnon [mailto:[EMAIL

Problem with email form validation

2000-10-24 Thread Michael Gagnon
Hi! I was wondering if there was a way arond this problem. I am using the CFINPUT 's "Required" and "Message" options. They work great, except that I want to go further with the email verification. I inserted a script to verify the format of the email address. The problem is that if all the fi

Combining day/month/year variables into 1 ODBC format variable

2000-10-21 Thread Michael Gagnon
Hi! I am looking for a way to combine 3 variables (date, month, year) into 1 variable and convert it into an ODBC format. Does anyone have a trick up their sleeves for this? Thanks! Archives: http

CFGRID - How to block the editing of 1 column

2000-10-03 Thread Michael Gagnon
Hi! Is there a way to block the editing of only 1 column (ID)? I want the others to be editable. TIA! __ Michael Gagnon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

Editing data with CFGRID

2000-10-02 Thread Michael Gagnon
Hi! I created a spreadsheet style grid with CFGRID (my first time) and I don't seem to be able to edit the information in the table. What am I doing wrong? Thanks! -- Archives: http://www.mail-archive.com/cf-talk

Re: INSERT INTO with loop problem

2000-09-29 Thread Michael Gagnon
ectID,ID,Done,Description#lang.Abrev#,details#lang.Abrev#,Image,For matImage) VALUES(#ProjectID#,#ID#,#Done#,'#tempdesc# ','#tempdet# ','#Image#',#formatImage#) Now I will go celebrate! _ Michael Gagnon - Original Message - From: &quo

Re: INSERT INTO with loop problem

2000-09-29 Thread Michael Gagnon
> You don't need single quotes around your field names portion ( use > Description#lang.abrev# rather than 'Description#lang.abrev#') and put a > comma after Done in your fields list. > > I would also recommend that you output the SQL statement you are creating to > ma

Re: INSERT INTO with loop problem

2000-09-29 Thread Michael Gagnon
; > Also, make sure you have a space after Projects; you show > Projects(ProjectID,... > > What behavior and/or error messages are you getting? > > -Original Message- > From: Michael Gagnon [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 28, 2000 1:04 PM > To: C

Re: INSERT INTO with loop problem

2000-09-29 Thread Michael Gagnon
29, 2000 5:09 AM Subject: RE: INSERT INTO with loop problem > Michael > Have you tried using the temporary variables in your INTO clause > as well as in your VALUES clause? > Nick > > -Original Message- > From: Michael Gagnon [mailto:[EMAIL PROTECTED]] > Sent:

Re: INSERT INTO with loop problem

2000-09-29 Thread Michael Gagnon
THANK YOU That's all it was! The ProjectID and ID variables were numeric. Regards, __ Michael Gagnon - Original Message - From: "Hayes, David" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 28,

INSERT INTO with loop problem

2000-09-28 Thread Michael Gagnon
Hi! I used a CFQUERY to UPDATE a table and it works fine, but I can't get it to work with an INSERT INTO. I use the UPDATE instead of CFUPDATE beucause of the loop. I couldn't get it to work at all with CFUPDATE. Here it is: INSERT INTO Projects(ProjectID,ID,Done,'Description#lang.abrev#','

Re: What's wrong with this script?

2000-09-27 Thread Michael Gagnon
ave you tried reseting the var "txt" to a null string at the end > of your inner loop? > > Comme ça? > > > > > #ID# > > > #txt# > > > > > > BB, > --K > > > -Original M

Re: Delay

2000-09-25 Thread Michael Gagnon
It's still there. Thanks! I will use it also! - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 25, 2000 10:56 PM Subject: RE: Delay > > There really should be a 'pause' tag that does not use much cpu. > > > > I doubt that I am the

Re: Delay

2000-09-25 Thread Michael Gagnon
I use a CFLOOP to create a delay. There must be a better way, but I haven't found it yet. - Original Message - From: "Parker, Kevin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 25, 2000 9:58 PM Subject: Delay > Can anyone help please? > > I'm tryin

Re: What's wrong with this script?

2000-09-25 Thread Michael Gagnon
ed to remove the languages. > > Try This > > > > > #ID# > > > > #txt# > > > > > > > -Original Message- > > From: Michael Gagnon [mailto:[EMAIL PROTECTED]] > > Sent: Mon

What's wrong with this script?

2000-09-25 Thread Michael Gagnon
Hi! I can't see what's wrong with this script. I use the same thing on another page and it works fine. It gives me the same answers on each row (the answers for the 1st row). #ID# #txt# Here's the one that works:

OFF topic - Autocad images

2000-09-21 Thread Michael Gagnon
Hi! Is there an application out there that would permit me to show Autocad images on the web? Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.c

Verifying the existence of a file on the server

2000-09-15 Thread Michael Gagnon
but I can't see how. Thanks!! ________ Michael Gagnon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li