Date Truncation on CFquery Update
I have a client who is essentially entering a document of 50+ pages into a text area field (tiny MCE). The data is being saved to a data base via CFquery Update. The data base is MS SQL server and the field length is set to VARCHAR(MAX). Data is being truncated on update to data base (same place every time). I have checked and the data is not being lost by the text area. If I display the post field after the Update Query, all the data is there. It's definitely being truncated either by CFQuery or by the data base. I have (temporarily) removed cfqueryparam, so that is not the culprit. Any ideas what is causing the truncation? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Date Truncation on CFquery Update
There's a post limit in the CF admin, I think the default is 100Mb but given that your post is so huge you might want to see if increasing that setting helps. -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: 13 June 2012 17:17 To: cf-talk Subject: Date Truncation on CFquery Update I have a client who is essentially entering a document of 50+ pages into a text area field (tiny MCE). The data is being saved to a data base via CFquery Update. The data base is MS SQL server and the field length is set to VARCHAR(MAX). Data is being truncated on update to data base (same place every time). I have checked and the data is not being lost by the text area. If I display the post field after the Update Query, all the data is there. It's definitely being truncated either by CFQuery or by the data base. I have (temporarily) removed cfqueryparam, so that is not the culprit. Any ideas what is causing the truncation? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion- Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:351564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubs ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Date Truncation on CFquery Update
Probably Max data length in cf admin. Look at the advanced DB connection settings. Will be set to default of 6 characters. I ran into something similar saving a wddx variable. Cheers, Rob On Jun 13, 2012 12:17 PM, Robert Harrison rob...@austin-williams.com wrote: I have a client who is essentially entering a document of 50+ pages into a text area field (tiny MCE). The data is being saved to a data base via CFquery Update. The data base is MS SQL server and the field length is set to VARCHAR(MAX). Data is being truncated on update to data base (same place every time). I have checked and the data is not being lost by the text area. If I display the post field after the Update Query, all the data is there. It's definitely being truncated either by CFQuery or by the data base. I have (temporarily) removed cfqueryparam, so that is not the culprit. Any ideas what is causing the truncation? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Date Truncation on CFquery Update
He specifically said data was not list on the post. Check your dan for chat limits, you may also need to enable blob support. On Jun 13, 2012 5:19 PM, Edward Chanter firew...@cc.uk.com wrote: There's a post limit in the CF admin, I think the default is 100Mb but given that your post is so huge you might want to see if increasing that setting helps. -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: 13 June 2012 17:17 To: cf-talk Subject: Date Truncation on CFquery Update I have a client who is essentially entering a document of 50+ pages into a text area field (tiny MCE). The data is being saved to a data base via CFquery Update. The data base is MS SQL server and the field length is set to VARCHAR(MAX). Data is being truncated on update to data base (same place every time). I have checked and the data is not being lost by the text area. If I display the post field after the Update Query, all the data is there. It's definitely being truncated either by CFQuery or by the data base. I have (temporarily) removed cfqueryparam, so that is not the culprit. Any ideas what is causing the truncation? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion- Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:351564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubs ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Data Truncation on CFquery Update: SOLVED
Thanks Rob Parkhill. It was the Max data length in cf admin.It was set to 64,000 characters by default. Adjusting that solved the problem. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
I checked and it's turned off. This is happening from multiple computers with Firefox. Any other thoughts? -Original Message- From: Matt Quackenbush Sent: Tuesday, April 19, 2011 12:20 AM To: cf-talk Subject: Re: CFQUERY update Firefox wierdness Wild guess: Firebug is turned on and is adding a second click to the flow. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
On 19/04/2011 8:46 PM, Dan Blickensderfer wrote: I checked and it's turned off. This is happening from multiple computers with Firefox. Any other thoughts? in that case turn it on and look at what the browser is sending... -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
Kym, I figured out what was causing the page to load twice. Within my page I had an abandon background-image:url(); within one of my style tags. Once I removed it everything is working correctly with Firefox on all machines. I guess Firefox tries to fetch the url() and since it's not referring to a url it reloads the same page. This was driving me crazy. Dan -Original Message- From: Kym Kovan Sent: Tuesday, April 19, 2011 7:23 AM To: cf-talk Subject: Re: CFQUERY update Firefox wierdness On 19/04/2011 8:46 PM, Dan Blickensderfer wrote: I checked and it's turned off. This is happening from multiple computers with Firefox. Any other thoughts? in that case turn it on and look at what the browser is sending... -- Yours, Kym Kovan mbcomms.net.au ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFQUERY update Firefox wierdness
Hi Everyone,
I have a really strange issue that I can not figure out how to fix it. I
have a simple shopping cart and everything works exactly the way it should
in ie7 ie8 but firefox not so much.
This is the issue. When customer clicks on the item to add to cart it first
checks to see if the item is already in the cart. If not, insert new
record. If found, update the record and add 1 to the qty. Within IE this
works just as it should, Firefox runs the update query regardless of new
insert or not. example. item ABC new to cart with qty 1 if I look at the
database table I see the qty is 2. If the item is already in database with
qty 1 and item is added to cart the qty is now 3. I've turned on debug and
looked at all queries ran and the the correct queries do show.
It's like there is another update query someplace but there isn't. I tested
this by removing the query named updatecart and tried the process again
and new records do get added and the qty is correct with 1 not 2. With it
being removed and item is updated to cart. it doesn't get updated like it
should be.
This is very very weird!
The code that I'm having strange is the following. I just copied the bit
that I need to show.
Anybody seen this before?
Thanks,
Dan Blickensderfer
cfquery name=lookupcart datasource=#application.datasource#
username=#application.username# password=#application.password#
select rec_id
from order_items
where rec_status = 'T' and session_uuid = cfqueryparam
cfsqltype=cf_sql_varchar maxlength=36 value=#session.cartid# and
products_rec_id = cfqueryparam cfsqltype=cf_sql_integer
value=#variables.recid#
/cfquery
cfif lookupcart.recordcount is 0
cfquery name=addcart datasource=#application.datasource#
username=#application.username# password=#application.password#
insert into order_items (rec_status, session_uuid, products_rec_id,
product_name, qty, orders_rec_id, ip_address)
values ('T', cfqueryparam cfsqltype=cf_sql_varchar maxlength=36
value=#session.cartid#,
cfqueryparam cfsqltype=cf_sql_integer value=#variables.recid#,
cfqueryparam cfsqltype=cf_sql_varchar
value=#getproduct.product_name# maxlength=150,
cfqueryparam cfsqltype=cf_sql_integer value=1,
cfqueryparam cfsqltype=cf_sql_integer
value=#lookuporder.rec_id#,
cfqueryparam cfsqltype=cf_sql_varchar
value=#trim(cgi.REMOTE_ADDR)# maxlength=17)
/cfquery
cfelse
cfquery name=updatecart datasource=#application.datasource#
username=#application.username# password=#application.password#
update order_items
set qty = qty + 1
where rec_status = 'T' and rec_id = cfqueryparam
cfsqltype=cf_sql_integer value=#lookupcart.rec_id#
/cfquery
/cfif
Here is the debug info
lookupcart (Datasource=XYX, Time=0ms, Records=0) in
templates\includes\cart-add.cfm @ 18:50:44.044
select *
from order_items
where rec_status = 'T' and session_uuid = ? and
products_rec_id = ? Query
Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 69B9132F-943D-2A28-E56878FCFEA4A5B6
Parameter #2(cf_sql_integer) = 17
addcart (Datasource=XYX, Time=0ms, Records=1) in
templates\includes\cart-add.cfm @ 18:50:44.044
insert into order_items (rec_status,
session_uuid, products_rec_id,
product_name, qty, orders_rec_id, ip_address)
values ('T', ?,
?,
?,
?,
?,
?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 69B9132F-943D-2A28-E56878FCFEA4A5B6
Parameter #2(cf_sql_integer) = 17
Parameter #3(cf_sql_varchar) = Green, Yellow Orange
Parameter #4(cf_sql_integer) = 1
Parameter #5(cf_sql_integer) = 5014
Parameter #6(cf_sql_varchar) = 192.168.10.159
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343833
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
Hi
I never seen that.. but the first thing I would look at is to set
up a way to see how many times that action page is run. Perhaps insert a
GetTickCount counter into a log file when the action page is
run.. First look to see how it works in IE, then try firefox.
At 06:55 PM 4/18/2011, you wrote:
Hi Everyone,
I have a really strange issue that I can not figure out how to fix it. I
have a simple shopping cart and everything works exactly the way it should
in ie7 ie8 but firefox not so much.
This is the issue. When customer clicks on the item to add to cart it first
checks to see if the item is already in the cart. If not, insert new
record. If found, update the record and add 1 to the qty. Within IE this
works just as it should, Firefox runs the update query regardless of new
insert or not. example. item ABC new to cart with qty 1 if I look at the
database table I see the qty is 2. If the item is already in database with
qty 1 and item is added to cart the qty is now 3. I've turned on debug and
looked at all queries ran and the the correct queries do show.
It's like there is another update query someplace but there isn't. I tested
this by removing the query named updatecart and tried the process again
and new records do get added and the qty is correct with 1 not 2. With it
being removed and item is updated to cart. it doesn't get updated like it
should be.
This is very very weird!
The code that I'm having strange is the following. I just copied the bit
that I need to show.
Anybody seen this before?
Thanks,
Dan Blickensderfer
cfquery name=lookupcart datasource=#application.datasource#
username=#application.username# password=#application.password#
select rec_id
from order_items
where rec_status = 'T' and session_uuid = cfqueryparam
cfsqltype=cf_sql_varchar maxlength=36 value=#session.cartid# and
products_rec_id = cfqueryparam cfsqltype=cf_sql_integer
value=#variables.recid#
/cfquery
cfif lookupcart.recordcount is 0
cfquery name=addcart datasource=#application.datasource#
username=#application.username# password=#application.password#
insert into order_items (rec_status, session_uuid, products_rec_id,
product_name, qty, orders_rec_id, ip_address)
values ('T', cfqueryparam cfsqltype=cf_sql_varchar maxlength=36
value=#session.cartid#,
cfqueryparam cfsqltype=cf_sql_integer value=#variables.recid#,
cfqueryparam cfsqltype=cf_sql_varchar
value=#getproduct.product_name# maxlength=150,
cfqueryparam cfsqltype=cf_sql_integer value=1,
cfqueryparam cfsqltype=cf_sql_integer
value=#lookuporder.rec_id#,
cfqueryparam cfsqltype=cf_sql_varchar
value=#trim(cgi.REMOTE_ADDR)# maxlength=17)
/cfquery
cfelse
cfquery name=updatecart datasource=#application.datasource#
username=#application.username# password=#application.password#
update order_items
set qty = qty + 1
where rec_status = 'T' and rec_id = cfqueryparam
cfsqltype=cf_sql_integer value=#lookupcart.rec_id#
/cfquery
/cfif
Here is the debug info
lookupcart (Datasource=XYX, Time=0ms, Records=0) in
templates\includes\cart-add.cfm @ 18:50:44.044
select *
from order_items
where rec_status = 'T' and session_uuid = ?
and products_rec_id = ? Query
Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 69B9132F-943D-2A28-E56878FCFEA4A5B6
Parameter #2(cf_sql_integer) = 17
addcart (Datasource=XYX, Time=0ms, Records=1) in
templates\includes\cart-add.cfm @ 18:50:44.044
insert into order_items
(rec_status, session_uuid, products_rec_id,
product_name, qty, orders_rec_id, ip_address)
values ('T', ?,
?,
?,
?,
?,
?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 69B9132F-943D-2A28-E56878FCFEA4A5B6
Parameter #2(cf_sql_integer) = 17
Parameter #3(cf_sql_varchar) = Green, Yellow Orange
Parameter #4(cf_sql_integer) = 1
Parameter #5(cf_sql_integer) = 5014
Parameter #6(cf_sql_varchar) = 192.168.10.159
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343834
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
cfquery tag has absolutely nothing to do with any browser - it is
executed by cf on the server side.
i would check your page's html and javascript instead - that's where
browser differences can come into play.
how do you submit your form to add item to cart - ajax or regular form
submit?
how do you display updated cart info on the page - ajax or page refresh?
is your html correctly formed and does it validate properly? ff is
pickier than ie when it comes to malformed html and this may cause it to
submit other data to your cart update script than what you expect.
use firebug to check what form data really gets submitted in ff.
Azadi
On 19/04/2011 06:55 , Dan Blickensderfer wrote:
Hi Everyone,
I have a really strange issue that I can not figure out how to fix it. I
have a simple shopping cart and everything works exactly the way it should
in ie7 ie8 but firefox not so much.
This is the issue. When customer clicks on the item to add to cart it first
checks to see if the item is already in the cart. If not, insert new
record. If found, update the record and add 1 to the qty. Within IE this
works just as it should, Firefox runs the update query regardless of new
insert or not. example. item ABC new to cart with qty 1 if I look at the
database table I see the qty is 2. If the item is already in database with
qty 1 and item is added to cart the qty is now 3. I've turned on debug and
looked at all queries ran and the the correct queries do show.
It's like there is another update query someplace but there isn't. I tested
this by removing the query named updatecart and tried the process again
and new records do get added and the qty is correct with 1 not 2. With it
being removed and item is updated to cart. it doesn't get updated like it
should be.
This is very very weird!
The code that I'm having strange is the following. I just copied the bit
that I need to show.
Anybody seen this before?
Thanks,
Dan Blickensderfer
cfquery name=lookupcart datasource=#application.datasource#
username=#application.username# password=#application.password#
select rec_id
from order_items
where rec_status = 'T' and session_uuid =cfqueryparam
cfsqltype=cf_sql_varchar maxlength=36 value=#session.cartid# and
products_rec_id =cfqueryparam cfsqltype=cf_sql_integer
value=#variables.recid#
/cfquery
cfif lookupcart.recordcount is 0
cfquery name=addcart datasource=#application.datasource#
username=#application.username# password=#application.password#
insert into order_items (rec_status, session_uuid, products_rec_id,
product_name, qty, orders_rec_id, ip_address)
values ('T',cfqueryparam cfsqltype=cf_sql_varchar maxlength=36
value=#session.cartid#,
cfqueryparam cfsqltype=cf_sql_integer value=#variables.recid#,
cfqueryparam cfsqltype=cf_sql_varchar
value=#getproduct.product_name# maxlength=150,
cfqueryparam cfsqltype=cf_sql_integer value=1,
cfqueryparam cfsqltype=cf_sql_integer
value=#lookuporder.rec_id#,
cfqueryparam cfsqltype=cf_sql_varchar
value=#trim(cgi.REMOTE_ADDR)# maxlength=17)
/cfquery
cfelse
cfquery name=updatecart datasource=#application.datasource#
username=#application.username# password=#application.password#
update order_items
set qty = qty + 1
where rec_status = 'T' and rec_id =cfqueryparam
cfsqltype=cf_sql_integer value=#lookupcart.rec_id#
/cfquery
/cfif
Here is the debug info
lookupcart (Datasource=XYX, Time=0ms, Records=0) in
templates\includes\cart-add.cfm @ 18:50:44.044
select *
from order_items
where rec_status = 'T' and session_uuid = ? and
products_rec_id = ? Query
Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 69B9132F-943D-2A28-E56878FCFEA4A5B6
Parameter #2(cf_sql_integer) = 17
addcart (Datasource=XYX, Time=0ms, Records=1) in
templates\includes\cart-add.cfm @ 18:50:44.044
insert into order_items (rec_status,
session_uuid, products_rec_id,
product_name, qty, orders_rec_id, ip_address)
values ('T', ?,
?,
?,
?,
?,
?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 69B9132F-943D-2A28-E56878FCFEA4A5B6
Parameter #2(cf_sql_integer) = 17
Parameter #3(cf_sql_varchar) = Green, Yellow Orange
Parameter #4(cf_sql_integer) = 1
Parameter #5(cf_sql_integer) = 5014
Parameter #6(cf_sql_varchar) = 192.168.10.159
~|
Order the Adobe Coldfusion Anthology now!
Re: CFQUERY update Firefox wierdness
Wild guess: Firebug is turned on and is adding a second click to the flow. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
After a bit (!) of research, I am still a little confused about using CFQUERYPARAM. It is not in my SAMs Teach Yourself Coldfusion Express in 24 Hrs. Probably not. I'm not sure CFQUERYPARAM exists in CF Express. CFQUERYPARAM was introduced around the same time that CF Express came out, but CF Express was not really very useful when it came out, and things have changed quite a bit since it came out, making it even less useful. It's not necessary for the completion of your exercises to use CFQUERYPARAM, but you would definitely want to use that in a real application. To learn more about CFQUERYPARAM, read the online CF 8 documentation and this Adobe Devnet article: http://www.adobe.com/support/documentation/en/coldfusion/ http://www.adobe.com/devnet/coldfusion/articles/cfqueryparam.html Understand that CS_SQL_BIT can be 1 or 0. But also found that msAccess CheckBox data can be 1,0 or NULL. NULL is the absence of a value. Any field can be set to allow NULL, unless the field is part of a unique index or something similar (identity columns, etc). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
I just want to point out that you should be using cfqueryparam around all of those form elements. The way you have it will last about 2 hours before someone hacks into your database. see: http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignoredhttp://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignored for details At 11:45 AM 12/28/2008, you wrote: Thanks, but that is supposed to be the right bracket of the SET Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Yep, but syntactically (sqlwise) you can't have the construct (opening and closing bracket) the way it's laid out unlike your INSERT statements. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
How can CFQUERYPARAM be applied to a boolean (Yes/No) field ? I cannot find it in the CDSQLTYPE list - Original Message - From: Al Musella, DPM muse...@virtualtrials.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, December 29, 2008 5:40 PM Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options I just want to point out that you should be using cfqueryparam around all of those form elements. The way you have it will last about 2 hours before someone hacks into your database. see: http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignoredhttp://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignored for details At 11:45 AM 12/28/2008, you wrote: Thanks, but that is supposed to be the right bracket of the SET Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Yep, but syntactically (sqlwise) you can't have the construct (opening and closing bracket) the way it's laid out unlike your INSERT statements. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
How can CFQUERYPARAM be applied to a boolean (Yes/No) field ? I cannot find it in the CFSQLTYPE list - Original Message - From: Al Musella, DPM muse...@virtualtrials.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, December 29, 2008 5:40 PM Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options I just want to point out that you should be using cfqueryparam around all of those form elements. The way you have it will last about 2 hours before someone hacks into your database. see: http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignoredhttp://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignored for details At 11:45 AM 12/28/2008, you wrote: Thanks, but that is supposed to be the right bracket of the SET Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Yep, but syntactically (sqlwise) you can't have the construct (opening and closing bracket) the way it's laid out unlike your INSERT statements. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
How can CFQUERYPARAM be applied to a boolean (Yes/No) field ? I cannot find it in the CFSQLTYPE list Use BIT. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Express ... Syntax error - CFQUERY - UPDATE Options
Use the bit field and 1's or 0's. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: BobSharp [mailto:bobsh...@ntlworld.com] Sent: Monday, December 29, 2008 12:21 PM To: cf-talk Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options How can CFQUERYPARAM be applied to a boolean (Yes/No) field ? I cannot find it in the CDSQLTYPE list - Original Message - From: Al Musella, DPM muse...@virtualtrials.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, December 29, 2008 5:40 PM Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options I just want to point out that you should be using cfqueryparam around all of those form elements. The way you have it will last about 2 hours before someone hacks into your database. see: http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-T o-Prevent-But-Apparently-Still-Ignoredhttp://www.forta.com/blog/index.cfm/2 005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignored for details At 11:45 AM 12/28/2008, you wrote: Thanks, but that is supposed to be the right bracket of the SET Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Yep, but syntactically (sqlwise) you can't have the construct (opening and closing bracket) the way it's laid out unlike your INSERT statements. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Express ... Syntax error - CFQUERY - UPDATE Options
Can anyone tell me exactly what is causing this error ? !---Update using a CFQUERY with SQL UPDATE --- CFquery NAME=qUpdate DATASOURCE=learncfe!--- error --- UPDATE GuestBook SET (GuestName = '#Form.GuestName#', Email = '#Form.Email#', FirstVisit = #Form.FirstVisit#, GotHere = '#Form.GotHere#', Rating = '#Form.Rating#', Comments = '#trim(Form.Comments)#') WHERE GuestBook_ID = #Form.GuestBook_ID# /CFquery ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (43:5) to (43:88). Date/Time: 12/28/08 12:20:44 Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 Remote Address: 127.0.0.1 HTTP Referer: http://localhost/tt380/GuestMaint.cfm?op=ugid=1 Template: c:\inetpub\wwwroot\tt380\GuestUpdate.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Sorry that should be Comments = '#trim(Form.Comments)#)' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
On Sun, Dec 28, 2008 at 11:33 AM, Jide Aliu jide_a...@hotmail.com wrote: Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Remove the opening bracket as well CFquery NAME=qUpdate DATASOURCE=learncfe!--- error --- UPDATE GuestBook SET GuestName = '#Form.GuestName#', Email = '#Form.Email#', FirstVisit = #Form.FirstVisit#, GotHere = '#Form.GotHere#', Rating = '#Form.Rating#', Comments = '#trim(Form.Comments)#' WHERE GuestBook_ID = #Form.GuestBook_ID# /CFquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Thanks, but that is supposed to be the right bracket of the SET - Original Message - From: Jide Aliu jide_a...@hotmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Sunday, December 28, 2008 4:33 PM Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Remove the opening bracket as well CFquery NAME=qUpdate DATASOURCE=learncfe!--- error --- UPDATE GuestBook SET GuestName = '#Form.GuestName#', Email = '#Form.Email#', FirstVisit = #Form.FirstVisit#, GotHere = '#Form.GotHere#', Rating = '#Form.Rating#', Comments = '#trim(Form.Comments)#' WHERE GuestBook_ID = #Form.GuestBook_ID# /CFquery 'Scuse my mad typing, yes Casey is right it's the opening and closing brackets. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317178 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Woo !Thanks for that. works ok now. - Original Message - From: Casey Dougall ca...@uberwebsitesolutions.com To: cf-talk cf-talk@houseoffusion.com Sent: Sunday, December 28, 2008 4:37 PM Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options On Sun, Dec 28, 2008 at 11:33 AM, Jide Aliu jide_a...@hotmail.com wrote: Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Remove the opening bracket as well CFquery NAME=qUpdate DATASOURCE=learncfe!--- error --- UPDATE GuestBook SET GuestName = '#Form.GuestName#', Email = '#Form.Email#', FirstVisit = #Form.FirstVisit#, GotHere = '#Form.GotHere#', Rating = '#Form.Rating#', Comments = '#trim(Form.Comments)#' WHERE GuestBook_ID = #Form.GuestBook_ID# /CFquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Woo ! Thanks for thatworks ok now. - Original Message - From: Jide Aliu jide_a...@hotmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Sunday, December 28, 2008 4:35 PM Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Sorry that should be Comments = '#trim(Form.Comments)#)' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317180 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Thanks, but that is supposed to be the right bracket of the SET Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' Yep, but syntactically (sqlwise) you can't have the construct (opening and closing bracket) the way it's laid out unlike your INSERT statements. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: cfquery UPDATE
Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: cfquery UPDATE
where usrID=#FORM.UserID# (your missing the name of the field in the where clause... At 12:16 PM 4/3/2003 -0500, you wrote: Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery UPDATE
I would check the FORM.Password field and see what it's value is. If you have more than one password field on your form, the form variable will be a list containing the values of all the fields.. HTH -R -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 12:17 PM To: CF-Talk Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery UPDATE
WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery UPDATE
WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery UPDATE
that means you have 2 fields on the FORM page called username [EMAIL PROTECTED] 04/03/03 12:56PM WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery UPDATE
Nevermind...I found the problem. I had a input tag with a hidden field along with a text field. On Thu, 03 Apr 2003 12:56:05 -0500, FlashGuy wrote: WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery UPDATE
Is this a clean form post (i.e. no errors and re-display of form)? If not then you may be accidentally re-setting vars somewhere along the line. Can you post all the code for your form? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCH AR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery UPDATE
Jumping in here a little late, but this looks like you have two fields in your form named Username. When there are multiple form fields with the same name, your browser will submit them as a comma separated list. Look on your original form to see it you are perhaps setting a hidden field with the original username... HTH, Jeff Garza - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 10:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery UPDATE
Man I'm dense today. Figured it out. Used input type=password Doh. On Thu, 03 Apr 2003 13:13:20 -0500, FlashGuy wrote: I have it working now. Thanks Another question. I'm displaying the password in my template as by using input type=text name=Password value= size=33 class=inputfield I then select the username I want to edit and click on the submit button which takes me to my edit template. Here I'm inserting the fields of the user into input tags for editing. What I would like to do is have the password field return also and not display the password from the database but be able to edit the field and return * when typing rather that the characters. Am I making sense? On Thu, 3 Apr 2003 10:06:45 -0800, Bryan Stevenson wrote: Is this a clean form post (i.e. no errors and re-display of form)? If not then you may be accidentally re-setting vars somewhere along the line. Can you post all the code for your form? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCH AR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba
Re: cfquery UPDATE
I have it working now. Thanks Another question. I'm displaying the password in my template as by using input type=text name=Password value= size=33 class=inputfield I then select the username I want to edit and click on the submit button which takes me to my edit template. Here I'm inserting the fields of the user into input tags for editing. What I would like to do is have the password field return also and not display the password from the database but be able to edit the field and return * when typing rather that the characters. Am I making sense? On Thu, 3 Apr 2003 10:06:45 -0800, Bryan Stevenson wrote: Is this a clean form post (i.e. no errors and re-display of form)? If not then you may be accidentally re-setting vars somewhere along the line. Can you post all the code for your form? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCH AR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies
RE: cfquery UPDATE
Eh.. if you are talking about character masking, you can use input type=password .. . Otherwise, i don't understand the question :) -R -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 1:13 PM To: CF-Talk Subject: Re: cfquery UPDATE I have it working now. Thanks Another question. I'm displaying the password in my template as by using input type=text name=Password value= size=33 class=inputfield I then select the username I want to edit and click on the submit button which takes me to my edit template. Here I'm inserting the fields of the user into input tags for editing. What I would like to do is have the password field return also and not display the password from the database but be able to edit the field and return * when typing rather that the characters. Am I making sense? On Thu, 3 Apr 2003 10:06:45 -0800, Bryan Stevenson wrote: Is this a clean form post (i.e. no errors and re-display of form)? If not then you may be accidentally re-setting vars somewhere along the line. Can you post all the code for your form? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCH AR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba
NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc.
I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.
What database were you using? Oracle has known problems with CFUPDATE and CFINSERT. -Original Message- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:19 PM To: CF-Talk Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc. I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc.
All I can say is I never use CFUPDATE or CFINSERT and all I ever here about them is what you described. Kowing how to use CFQUERY and write your own SQL statements is a beneficial skill and I always recommend that people use it instead ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Hawkes, Keith A CIV [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:18 AM Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc. I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc.
CFUPDATE and CFINSERT are the devil's tools. Well not quite; they are designed to keep the learning curve of CF low, but (IMHO) should never be used unless you need that low curve. If you know how to write the SQL statements for INSERT and UPDATE, then using CFUPDATE and CFINSERT is generally a bad idea. Your uncle's nova (CFUPDATE) generally works, but if someone gave you a free fill in car name (CFQUERY), with which gas and insurance were cheaper (performance), but you had to go pick it up 10 miles away (initial coding), would you take it? Bottom line, the app engine shouldn't know anythign about your database, so don't let it. My $0.02, barneyb -Original Message- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:19 AM To: CF-Talk Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc. I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Benefits of Using CFUPDATE/CFINSERT (was RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.)
What would I gain by using CFUPDATE/CFINSERT over CFQUERY? THanks, Scott -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:24 PM To: CF-Talk Subject: RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc. What database were you using? Oracle has known problems with CFUPDATE and CFINSERT. -Original Message- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:19 PM To: CF-Talk Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc. I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Benefits of Using CFUPDATE/CFINSERT (was RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.)
well, you would not gain the esteem of your peers here for sure!! LOL! Best to roll your own SQL. Doug -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:26 PM To: CF-Talk Subject: Benefits of Using CFUPDATE/CFINSERT (was RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.) What would I gain by using CFUPDATE/CFINSERT over CFQUERY? THanks, Scott -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:24 PM To: CF-Talk Subject: RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc. What database were you using? Oracle has known problems with CFUPDATE and CFINSERT. -Original Message- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:19 PM To: CF-Talk Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc. I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Benefits of Using CFUPDATE/CFINSERT (was RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.)
Nothing.just easier to code with CFUPDATE/CFINSERT. CFQUERY using CFQUERYPARAM will help to stop SQL injection attacks, use BIND variables to increase performance (not all DBs use BIND vars), and won't bail on you all the time like CFUPDATE/CFINSERT. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Scott Wilhelm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 12:25 PM Subject: Benefits of Using CFUPDATE/CFINSERT (was RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.) What would I gain by using CFUPDATE/CFINSERT over CFQUERY? THanks, Scott -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:24 PM To: CF-Talk Subject: RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc. What database were you using? Oracle has known problems with CFUPDATE and CFINSERT. -Original Message- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:19 PM To: CF-Talk Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc. I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Benefits of Using CFUPDATE/CFINSERT (was RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.)
CFUPDATE and CFINSERT tend to let you get away with not knowing SQL. But using CFQUERY and SQL give you much greater control over your queries. It's really a matter of preference. Personally, I won't use them. I'd rather have near complete control over my database interactions. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:26 PM To: CF-Talk Subject: Benefits of Using CFUPDATE/CFINSERT (was RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.) What would I gain by using CFUPDATE/CFINSERT over CFQUERY? THanks, Scott -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:24 PM To: CF-Talk Subject: RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc. What database were you using? Oracle has known problems with CFUPDATE and CFINSERT. -Original Message- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:19 PM To: CF-Talk Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e tc. I was going absolutely bonkers not understanding why CFUPDATE wasn't always updating a field consistently, so I switched to CFQUERY and updating the fields with SQL commands and it's now working perfectly. I wasn't using any session or client variables other then those passed from the form, but this one field (critical, of course) wasn't always updating using CFUPDATE. Sometimes it would and sometimes it wouldn't. Hitting the refresh button a few times would occasionally update the field. Has anyone else come across something like that? TIA, Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFQUERY Update......
Hi all, I am trying to update a table using CFQUERY. I do not see any error when the query is excuted in CF and I can see the query is correct in the debug mode. But somehow the data is not updated. When I run the same query in SQL Server, the data is updated. Does anybody know why? I am using CF 4.5 and SQL Server 7.0 The query is like this.. UPDATE User SET newpassword = 'arenofun' WHERE ID = 1614 Thanks in advance J ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFQUERY Update......
Does it return an error in CF? Some thoughts: Make sure that the ID field is a NUMBER field and the ID # is unique. -Original Message- From: JL [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 9:46 AM To: CF-Talk Subject: CFQUERY Update.. Hi all, I am trying to update a table using CFQUERY. I do not see any error when the query is excuted in CF and I can see the query is correct in the debug mode. But somehow the data is not updated. When I run the same query in SQL Server, the data is updated. Does anybody know why? I am using CF 4.5 and SQL Server 7.0 The query is like this.. UPDATE User SET newpassword = 'arenofun' WHERE ID = 1614 Thanks in advance J ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFQUERY Update......
I have seen this behavior before under heavy load without using transactions, but it did not happen every time like you are seeing. An update will of course execute but not change the data if the where clause does not match anything. If you can copy the same query into Query Analyzer that shows in the debug and it updates where the cfquery did not, you might want to try moving the query into a stored procedure. Since it works in sql server, might as well keep it there ;-) jon - Original Message - From: JL [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 25, 2001 9:46 AM Subject: CFQUERY Update.. Hi all, I am trying to update a table using CFQUERY. I do not see any error when the query is excuted in CF and I can see the query is correct in the debug mode. But somehow the data is not updated. When I run the same query in SQL Server, the data is updated. Does anybody know why? I am using CF 4.5 and SQL Server 7.0 The query is like this.. UPDATE User SET newpassword = 'arenofun' WHERE ID = 1614 Thanks in advance J ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY UPDATE problem on FoxPro Memo fields
ANY IDEAS ON SYNTAX OR WHAT I AM OVERLOOKING: The problem is using CFQUERY update to post edited results extracted from a memo field back to that memo field. TPLT_TXT is a memo field. I can SELECT data and display in in a textarea fine. It bombs when I try to put it back. There is data in the FORM.TPLT_TXT variable because I can CFOUTPUT it to the screen directly before the update code. Take the "TPLT_TXT" line of code out and it works fine -- put it back in and I get the ODBC error Code = 37000 CFQUERY NAME="DSP5_UP" DATASOURCE="COLAB2" UPDATE TEMPLAT1 SET TPLT_DES = '#FORM.TPLT_DES#', TPLT_TXT = '#FORM.TPLT_TXT#', L_EDIT_DT = '#FORM.L_EDIT_DT#' , EDIT_WHO = '#FORM.EDIT_WHO#' WHERE TEMPLAT1.DIV_NUM = '#CLIENT.mDIV_NUM#' AND TEMPLAT1.TPLT_FRM = '#FORM.TPLT_FRM#' AND TEMPLAT1.TPLT_FLD = '#FORM.TPLT_FLD#' AND TEMPLAT1.TPLT_NUM = '#FORM.TPLT_NUM#' /CFQUERY ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY UPDATE problem on FoxPro Memo fields -- more info
ADDED INFO ON: ANY IDEAS ON SYNTAX OR WHAT I AM OVERLOOKING: When I change the TPLT_TXT line so I'm just posting a text string "This is some text" it works fine too. So the issue must have to with something I need to do with the text string in the "textarea" field before running the update. Thanks for any inputs... CFQUERY NAME="DSP5_UP" DATASOURCE="COLAB2" UPDATE TEMPLAT1 SET TPLT_DES = '#FORM.TPLT_DES#', TPLT_TXT = 'This is some txt', L_EDIT_DT = '#FORM.L_EDIT_DT#' , EDIT_WHO = '#FORM.EDIT_WHO#' WHERE TEMPLAT1.DIV_NUM = '#CLIENT.mDIV_NUM#' AND TEMPLAT1.TPLT_FRM = '#FORM.TPLT_FRM#' AND TEMPLAT1.TPLT_FLD = '#FORM.TPLT_FLD#' AND TEMPLAT1.TPLT_NUM = '#FORM.TPLT_NUM#' /CFQUERY ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: CFQUERY UPDATE problem on FoxPro Memo fields -- more info
Solved problem -- I think. I added a hidden field on the data entry page per example code below and it worked. !- Apparently a TPLT_TXT hidden field required for textarea field to pass results to a CFQUERY update action on called page. --- INPUT TYPE="hidden" NAME="TPLT_TXT" VALUE="#GET_TPLT.TPLT_TXT#" Obviously it had nothing to do with ODBC, but rather what I consider to be a CF design inconsistency in the way it handles text areas and text fields. Any of you Gurus want to explain why this "inconsistency" really is an intended "design feature" This newbie is getting very bald. ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY UPDATE problem -- not solved
Thought I solved the problem, but not so... Worked fine when I updated the memo field with the TPLT_DES field that came from a text box. Bombs when I update the memo field with the contents of the textarea field. Hence ODBC works fine. Thus, the format or datatype or ??? of the textarea field is somehow different than the text box field contents -- hence will not work with the update command. Any help/advice welcome. ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY UPDATE problem -- not solved -- now solved.
Sorry to talk to myself about this problem, but, it's maddening. Apparently at least one solution is to trim the length of the string FORM.TPLT_TXT produced by the textarea to the length of the string in the textarea before doing the update (go figure) as follows: CFSET mLEN = LEN(RTRIM(#FORM.TPLT_TXT#)) CFSET mTEXT = LEFT(RTRIM(#FORM.TPLT_TXT#),mLEN) CFQUERY NAME="DSP5_UP" DATASOURCE="COLAB2" UPDATE TEMPLAT1 SET TPLT_DES = '#FORM.TPLT_DES#', TPLT_TXT = '#FORM.TPLT_TXT#', L_EDIT_DT = '#FORM.L_EDIT_DT#' , EDIT_WHO = '#FORM.EDIT_WHO#' WHERE TEMPLAT1.DIV_NUM = '#CLIENT.mDIV_NUM#' AND TEMPLAT1.TPLT_FRM = '#FORM.TPLT_FRM#' AND TEMPLAT1.TPLT_FLD = '#FORM.TPLT_FLD#' AND TEMPLAT1.TPLT_NUM = '#FORM.TPLT_NUM#' /CFQUERY Apparently there is a non-displaying character at the end of the string in the textarea that the "LEN" function does not recognize; hence, the first two commands strip it off and permit the UPDATE posting to occur. I suppose that this is a design feature -- right? What a goat rope! [:-( ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: CFQUERY UPDATE - a new problem.
Now that the trim solution works -- well ah at least for cases where the saved string is 256 characters long or less, CFQUESRY update now blows on trimmed strings longer than 256 characters. In CF Admin I have the Visual FoxPro Driver settings as "Free Table Directory" and Long Text Buffer Size at 32,000 characters (probably only applies to CFQUERY select ??). The CFQUERY select part of the program retrieves a long string from the DBF memo field and displays it in the textarea just fine. But unless I edit the size to 256 characters or less the ODBC update blows with error message 37000. Please -- any and all suggestions/ideas on what settings are needed to overcome this 256 character limit... Thanks in advance... Arden Weiss 410-757-3487 -Original Message- From: Arden Weiss [SMTP:[EMAIL PROTECTED]] Sent: Sunday, December 03, 2000 8:44 PM To: '[EMAIL PROTECTED]' Subject: CFQUERY UPDATE problem -- not solved -- now solved. Sorry to talk to myself about this problem, but, it's maddening. Apparently at least one solution is to trim the length of the string FORM.TPLT_TXT produced by the textarea to the length of the string in the textarea before doing the update (go figure) as follows: CFSET mLEN = LEN(RTRIM(ltrim(#FORM.TPLT_TXT#))) CFSET mTEXT = LEFT(RTRIM(ltrim(#FORM.TPLT_TXT#)),mLEN) CFQUERY NAME="DSP5_UP" DATASOURCE="COLAB2" UPDATE TEMPLAT1 SET TPLT_DES = '#FORM.TPLT_DES#', TPLT_TXT = '#FORM.TPLT_TXT#', L_EDIT_DT = '#FORM.L_EDIT_DT#' , EDIT_WHO = '#FORM.EDIT_WHO#' WHERE TEMPLAT1.DIV_NUM = '#CLIENT.mDIV_NUM#' AND TEMPLAT1.TPLT_FRM = '#FORM.TPLT_FRM#' AND TEMPLAT1.TPLT_FLD = '#FORM.TPLT_FLD#' AND TEMPLAT1.TPLT_NUM = '#FORM.TPLT_NUM#' /CFQUERY Apparently there is a non-displaying character at the end of the string in the textarea that the "LEN" function does not recognize; hence, the first two commands strip it off and permit the UPDATE posting to occur. I suppose that this is a design feature -- right? What a goat rope! [:-( ~~ 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@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weird... cfquery update 0 rows - query disappears
I have a SQL update. When it tries to update data a row that doesn't exist I don't get an error, I don't get 0 rows, I get the query variable itself doesn't exist!? A query can exist and contain no rows. RecordCount counts existing rows. If query has no rows - RecordCount is meaningless and will throw an error. Works every time. :) In your case - no rows were updated so RecordCount has nothing to count and nothing != zero. This isn't exactly the case. RecordCount returns the number of records within the recordset returned by the database to CF. Whether or not the SQL statement updates any rows, there won't be a recordset (and thus no "query" in CF), unless the table that was updated has a trigger that returns a recordset. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Weird... cfquery update 0 rows - query disappears
I have a SQL update. When it tries to update data a row that doesn't exist I don't get an error, I don't get 0 rows, I get the query variable itself doesn't exist!? See sample code: !-- Testing SELECT on non-existent data lt;br cfquery name="sel" datasource="dsn" select UserName from Users where UserName = "nevernevernotever" /cfquery Select done on cfoutput#sel.RecordCount#/cfoutput records. lt;br lt;p Testing UPDATE on non-existent data lt;br cfquery name="upd" datasource="dsn" update Users set UserName = "xyzzy" where UserName = "nevernevernotever" /cfquery Update done on cfoutput#upd.RecordCount#/cfoutput records.br !-- Here is the output: Testing SELECT on non-existent data Select done on 0 records. Testing UPDATE on non-existent data Update done on Error Occurred While Processing Request An error occurred while evaluating the expression: #upd.RecordCount# Error near line 13, column 27 Error resolving parameter UPD.RECORDCOUNT And strangely enough my debugging output tells me the query DOES exist: Queries sel (Records=0, Time=131ms) SQL = select UserName from Users where UserName = "nevernevernotever" upd (Records=0, Time=15ms) SQL = update Users set UserName = "xyzzy" where UserName = "nevernevernotever" I also tried putting a cftry around it, but no error is being thrown --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Weird... cfquery update 0 rows - query disappears
From: "Peter Theobald" [EMAIL PROTECTED] I have a SQL update. When it tries to update data a row that doesn't exist I don't get an error, I don't get 0 rows, I get the query variable itself doesn't exist!? A query can exist and contain no rows. RecordCount counts existing rows. If query has no rows - RecordCount is meaningless and will throw an error. Works every time. :) In your case - no rows were updated so RecordCount has nothing to count and nothing != zero. There was a discussion here recently about how to count updated rows ... if your rdbms has a fucntion like @@rows (MSSQL) you're in business easily - if not you have to make monkeys jump through flaming hoops to get an answer. Pan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help with CFQUERY/Update
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 = '00' 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 = '00' 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with CFQUERY/Update
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 '00'=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 '00'=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=3Dlistsbody=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=3Dlistsbody=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=3Dlistsbody=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" HTMLHEADTITLEHelp 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#ff DIVFONT face=3DArial size=3D
RE: Help with CFQUERY/Update
i may just be reaching, but is the Member_number field in your database a number field or a text field? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
