Mike,
You need to remove the quotes from your ID field
(which is a number, I assume...)
UPDATE tbldistrib
SET distrib_name='#Form.distrib_name#',
distrib_city='#Form.distrib_city#',
distrib_state='#Form.distrib_state#',
distrib_phone='#Form.distrib_phone#'
WHERE distrib_
lease notify us on +44 (0)207 387 8890.
-Original Message-
From: Michael Wilson [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2000 17:45
To: CF-Talk
Subject: SQL UPDATE question (was Update Query/Output question from a
newbie)
Hi again to everyone,
I would like to thank Stephen and Bre
Hi again to everyone,
I would like to thank Stephen and Bret for their help earlier. I managed to
get things working on the update form, although I haven't moved to the
state_id rather than the state_name system yet. I still receive errors
(ColdFusion was unable to determine the value of the para
Hi Mike,
> Invalid tag nesting configuration
>
> A query driven CFOUTPUT tag is nested inside a CFOUTPUT tag that
> also has a
> QUERY= attribute. This is not allowed. Nesting these tags implies that you
> want to use grouped processing. However, only the top-level tag
> can specify
> the query t
Hi Michael,
I'll just start at the top, ok?
What is distrib_state? I get the impression that it is the actual name
of the state. If so, I would suggest that you use state_id instead - I
know the names of the states are not going to change but it will save
you space and is good database design.
thing to learn, even if it doesn't help you in
this case, it is extremely handy.
-Bill
/intraget
- Original Message -
From: Michael Wilson <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, October 21, 2000 11:37 PM
Subject: Update Query/Output question from a
Hi all and thanks for taking time to look this over. I will try my best to
keep it as brief as possible, although I need to give you some background on
my problem. Thanks in advance for any help you can provide.
I have a client I did a site for about 4 years ago and it have never really
been chan
7 matches
Mail list logo
