Ok i am very confused. I am trying to update one field with the following
statement:
<CFQUERY Datasource="#dsn#" name="update1">
Update Rates_And_Charges
SET passengers_enplaned_domestic = #form.passengers_enplaned_domestic#
Where Member_number = '#form.Member_Number#'
</CFQUERY>
It returns back the following:
update1 (Records=0, Time=62ms)
SQL = Update Rates_And_Charges
SET passengers_enplaned_domestic = 456466
Where Member_number = '000000'
Saying it found ZERO records to update. However if i run a similar query:
<CFQUERY name="edit" datasource="#dsn#">
SELECT passengers_enplaned_domestic
FROM Rates_And_Charges
WHERE Member_number = '#form.Member_number#'
</CFQUERY>
edit (Records=1, Time=0ms)
SQL = SELECT passengers_enplaned_domestic
FROM Rates_And_Charges
WHERE Member_number = '000000'
Its finds one records with the SAME EXACT where statement.
Any clues why the first continues to find NO RECORD??
---------------------------------------
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---------------------------------------
> -----Original Message-----
> From: Mike Sullivan [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 07, 2000 11:39 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: CFFILE problem on linux
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Who is your httpd running as and does it have access to the file
> system?
> Mike
>
> - -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, August 06, 2000 10:36 PM
> To: [EMAIL PROTECTED]
> Subject: CFFILE problem on linux
>
>
>
> Hi there,
>
> I'm trying to get CFFILE working on a linux box. ColdFusion is
> running as a user
> called coldfusion which has group write privileges to my HTML
> directory. If I
> log in as the coldfusion user I can create directories and files in
> the HTML
> directory OK.
>
> However, when I try to do a <CFFILE ACTION="WRITE"> into that same
> directory I
> get a permissions error.
>
> I am not running advanced security.
>
> What is going on?
>
> - --------
> Rob Keniger
>
>
> - ----------------------------------------------------------------------
> - --------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
> k or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBOY7YVXYFmKomMlANEQJ1xgCaA52FfQ0evBi9hlQbM6oTtod3RCcAnRso
> kMZdsWNAOplgtcqcy7F98wXY
> =ihDF
> -----END PGP SIGNATURE-----
> --------------------------------------------------------------------------
> ----
> Archives: http://www.mail-archive.com/[email protected]/
> 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
