This is a multi-part message in MIME format.
------=_NextPart_000_055B_01C00086.D50005A0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Help with CFQUERY/UpdateThe update is working fine. It is just that =
CFQUERY does not return a recordcount of rows updated, inserted or =
deleted. A quirk to be sure. All you have to do is look at the =
database to see if the update was successful.=20
DC
----- Original Message -----=20
From: Kelly Matthews=20
To: '[EMAIL PROTECTED]'=20
Sent: Monday, August 07, 2000 15:36
Subject: Help with CFQUERY/Update
Ok i am very confused. I am trying to update one field with the =
following=20
statement:=20
<CFQUERY Datasource=3D"#dsn#" name=3D"update1">=20
Update Rates_And_Charges=20
SET passengers_enplaned_domestic =3D =
#form.passengers_enplaned_domestic#=20
Where Member_number =3D '#form.Member_Number#'=20
</CFQUERY>=20
It returns back the following:=20
update1 (Records=3D0, Time=3D62ms)=20
SQL =3D Update Rates_And_Charges=20
SET passengers_enplaned_domestic =3D 456466=20
Where Member_number =3D '000000'=20
Saying it found ZERO records to update. However if i run a similar =
query:=20
<CFQUERY name=3D"edit" datasource=3D"#dsn#">=20
SELECT passengers_enplaned_domestic=20
FROM Rates_And_Charges=20
WHERE Member_number =3D '#form.Member_number#'=20
</CFQUERY> =20
edit (Records=3D1, Time=3D0ms)=20
SQL =3D SELECT passengers_enplaned_domestic=20
FROM Rates_And_Charges=20
WHERE Member_number =3D '000000'=20
Its finds one records with the SAME EXACT where statement.=20
Any clues why the first continues to find NO RECORD??=20
---------------------------------------=20
Kelly Matthews=20
Internet Development Coordinator=20
AAAE=20
703.578.2509=20
[EMAIL PROTECTED]=20
http://www.airportnet.org=20
---------------------------------------=20
> -----Original Message-----=20
> From: Mike Sullivan [SMTP:[EMAIL PROTECTED]]=20
> Sent: Monday, August 07, 2000 11:39 AM=20
> To: '[EMAIL PROTECTED]'=20
> Subject: RE: CFFILE problem on linux=20
>=20
> -----BEGIN PGP SIGNED MESSAGE-----=20
> Hash: SHA1=20
>=20
> Who is your httpd running as and does it have access to the file=20
> system?=20
> Mike=20
>=20
> - -----Original Message-----=20
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]=20
> Sent: Sunday, August 06, 2000 10:36 PM=20
> To: [EMAIL PROTECTED]=20
> Subject: CFFILE problem on linux=20
>=20
>=20
>=20
> Hi there,=20
>=20
> I'm trying to get CFFILE working on a linux box. ColdFusion is=20
> running as a user=20
> called coldfusion which has group write privileges to my HTML=20
> directory. If I=20
> log in as the coldfusion user I can create directories and files in=20
> the HTML=20
> directory OK.=20
>=20
> However, when I try to do a <CFFILE ACTION=3D"WRITE"> into that same =
> directory I=20
> get a permissions error.=20
>=20
> I am not running advanced security.=20
>=20
> What is going on?=20
>=20
> - --------=20
> Rob Keniger=20
>=20
>=20
> - =
----------------------------------------------------------------------=20
> - --------=20
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
> To Unsubscribe visit=20
> =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
l=20
> k or send a message to [EMAIL PROTECTED] with=20
> 'unsubscribe' in the body.=20
>=20
> -----BEGIN PGP SIGNATURE-----=20
> Version: PGPfreeware 6.5.3 for non-commercial use =
<http://www.pgp.com>=20
>=20
> iQA/AwUBOY7YVXYFmKomMlANEQJ1xgCaA52FfQ0evBi9hlQbM6oTtod3RCcAnRso=20
> kMZdsWNAOplgtcqcy7F98wXY=20
> =3DihDF=20
> -----END PGP SIGNATURE-----=20
> =
-------------------------------------------------------------------------=
-=20
> ----=20
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
> To Unsubscribe visit=20
> =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or=20
> send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
> the body.=20
=
-------------------------------------------------------------------------=
-----=20
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.
------=_NextPart_000_055B_01C00086.D50005A0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Help with CFQUERY/Update</TITLE>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>The update is working fine. It is =
just that=20
CFQUERY does not return a recordcount of rows updated, inserted or=20
deleted. A quirk to be sure. All you have to do is look at =
the=20
database to see if the update was successful. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>DC</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:[EMAIL PROTECTED]" =
[EMAIL PROTECTED]>Kelly=20
Matthews</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:'[EMAIL PROTECTED]'"=20
[EMAIL PROTECTED]>'[EMAIL PROTECTED]'</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, August 07, 2000 =
15:36</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Help with =
CFQUERY/Update</DIV>
<DIV><BR></DIV>
<P><FONT size=3D2>Ok i am very confused. I am trying to update one =
field with=20
the following</FONT> <BR><FONT size=3D2>statement:</FONT> <BR><FONT=20
size=3D2><CFQUERY Datasource=3D"#dsn#" name=3D"update1"></FONT> =
<BR><FONT=20
size=3D2>Update Rates_And_Charges</FONT> <BR><FONT size=3D2>SET=20
passengers_enplaned_domestic =3D =
#form.passengers_enplaned_domestic#</FONT>=20
<BR><FONT size=3D2>Where Member_number =3D =
'#form.Member_Number#'</FONT> <BR><FONT=20
size=3D2></CFQUERY> </FONT><BR><FONT size=3D2>It returns back =
the=20
following:</FONT> <BR><FONT size=3D2>update1 (Records=3D0, =
Time=3D62ms)=20
</FONT><BR><FONT size=3D2>SQL =3D Update Rates_And_Charges =
</FONT><BR><FONT=20
size=3D2>SET passengers_enplaned_domestic =3D 456466 </FONT><BR><FONT =
size=3D2>Where=20
Member_number =3D '000000' </FONT></P>
<P><FONT size=3D2>Saying it found ZERO records to update. However if i =
run a=20
similar query:</FONT> <BR><FONT size=3D2><CFQUERY name=3D"edit"=20
datasource=3D"#dsn#"></FONT> <BR><FONT size=3D2>SELECT=20
passengers_enplaned_domestic</FONT> <BR><FONT size=3D2>FROM=20
Rates_And_Charges</FONT> <BR><FONT size=3D2>WHERE Member_number =3D=20
'#form.Member_number#'</FONT> <BR><FONT=20
size=3D2></CFQUERY> =
</FONT><BR><FONT=20
size=3D2>edit (Records=3D1, Time=3D0ms) </FONT><BR><FONT size=3D2>SQL =
=3D SELECT=20
passengers_enplaned_domestic </FONT><BR><FONT size=3D2>FROM =
Rates_And_Charges=20
</FONT><BR><FONT size=3D2>WHERE Member_number =3D '000000' =
</FONT><BR><FONT=20
size=3D2>Its finds one records with the SAME EXACT where =
statement.</FONT>=20
<BR><FONT size=3D2>Any clues why the first continues to find NO =
RECORD??</FONT>=20
</P><BR><BR>
<P><FONT size=3D2>---------------------------------------</FONT> =
<BR><FONT=20
size=3D2>Kelly Matthews</FONT> <BR><FONT size=3D2>Internet Development =
Coordinator</FONT> <BR><FONT size=3D2>AAAE</FONT> <BR><FONT=20
size=3D2>703.578.2509</FONT> <BR><FONT =
size=3D2>[EMAIL PROTECTED]</FONT>=20
<BR><FONT size=3D2><A href=3D"http://www.airportnet.org"=20
target=3D_blank>http://www.airportnet.org</A></FONT> <BR><FONT=20
size=3D2>---------------------------------------</FONT> </P>
<P><FONT size=3D2>> -----Original Message-----</FONT> <BR><FONT =
size=3D2>>=20
From: Mike Sullivan [SMTP:[EMAIL PROTECTED]]</FONT> =
<BR><FONT=20
size=3D2>> Sent: Monday, August 07, 2000 11:39 AM</FONT> <BR><FONT=20
size=3D2>> To: '[EMAIL PROTECTED]'</FONT> =
<BR><FONT=20
size=3D2>> Subject: RE: CFFILE =
problem on=20
linux</FONT> <BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>> =
-----BEGIN PGP=20
SIGNED MESSAGE-----</FONT> <BR><FONT size=3D2>> Hash: SHA1</FONT> =
<BR><FONT=20
size=3D2>> </FONT><BR><FONT size=3D2>> Who is your httpd running =
as and does=20
it have access to the file</FONT> <BR><FONT size=3D2>> =
system?</FONT>=20
<BR><FONT size=3D2>> Mike</FONT> <BR><FONT size=3D2>> =
</FONT><BR><FONT=20
size=3D2>> - -----Original Message-----</FONT> <BR><FONT =
size=3D2>> From:=20
[EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]</FONT> =
<BR><FONT=20
size=3D2>> Sent: Sunday, August 06, 2000 10:36 PM</FONT> <BR><FONT=20
size=3D2>> To: [EMAIL PROTECTED]</FONT> =
<BR><FONT=20
size=3D2>> Subject: CFFILE problem on =
linux</FONT> <BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>>=20
</FONT><BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>> Hi =
there,</FONT>=20
<BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>> I'm trying to =
get CFFILE=20
working on a linux box. ColdFusion is</FONT> <BR><FONT size=3D2>> =
running as=20
a user</FONT> <BR><FONT size=3D2>> called coldfusion which has =
group write=20
privileges to my HTML</FONT> <BR><FONT size=3D2>> directory. If =
I</FONT>=20
<BR><FONT size=3D2>> log in as the coldfusion user I can create =
directories=20
and files in</FONT> <BR><FONT size=3D2>> the HTML</FONT> <BR><FONT=20
size=3D2>> directory OK.</FONT> <BR><FONT size=3D2>> =
</FONT><BR><FONT=20
size=3D2>> However, when I try to do a <CFFILE =
ACTION=3D"WRITE"> into=20
that same</FONT> <BR><FONT size=3D2>> directory I</FONT> <BR><FONT=20
size=3D2>> get a permissions error.</FONT> <BR><FONT size=3D2>>=20
</FONT><BR><FONT size=3D2>> I am not running advanced =
security.</FONT>=20
<BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>> What is going =
on?</FONT>=20
<BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>> - =
--------</FONT> <BR><FONT=20
size=3D2>> Rob Keniger</FONT> <BR><FONT size=3D2>> =
</FONT><BR><FONT=20
size=3D2>> </FONT><BR><FONT size=3D2>> -=20
=
----------------------------------------------------------------------</F=
ONT>=20
<BR><FONT size=3D2>> - --------</FONT> <BR><FONT size=3D2>> =
Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>> To Unsubscribe visit</FONT> <BR><FONT =
size=3D2>> <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_tal"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_tal</A></FONT>=20
<BR><FONT size=3D2>> k or send a message to =
[EMAIL PROTECTED]=20
with</FONT> <BR><FONT size=3D2>> 'unsubscribe' in the body.</FONT> =
<BR><FONT=20
size=3D2>> </FONT><BR><FONT size=3D2>> -----BEGIN PGP =
SIGNATURE-----</FONT>=20
<BR><FONT size=3D2>> Version: PGPfreeware 6.5.3 for non-commercial =
use <<A=20
href=3D"http://www.pgp.com" =
target=3D_blank>http://www.pgp.com</A>></FONT>=20
<BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>>=20
=
iQA/AwUBOY7YVXYFmKomMlANEQJ1xgCaA52FfQ0evBi9hlQbM6oTtod3RCcAnRso</FONT>=20
<BR><FONT size=3D2>> kMZdsWNAOplgtcqcy7F98wXY</FONT> <BR><FONT =
size=3D2>>=20
=3DihDF</FONT> <BR><FONT size=3D2>> -----END PGP =
SIGNATURE-----</FONT>=20
<BR><FONT size=3D2>>=20
=
-------------------------------------------------------------------------=
-</FONT>=20
<BR><FONT size=3D2>> ----</FONT> <BR><FONT size=3D2>> Archives: =
<A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>> To Unsubscribe visit</FONT> <BR><FONT =
size=3D2>> <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or</FONT> <BR><FONT size=3D2>> send a message to=20
[EMAIL PROTECTED] with 'unsubscribe' in</FONT> =
<BR><FONT=20
size=3D2>> the body.</FONT> <BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_055B_01C00086.D50005A0--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
