Barbara,
Is
there a reason that the field NAME contains a space? If not, then just
change it to "HomeAddress". I'm not sure how you put a space in the column
name, but my guess is that standard SQL will interpret it as an alias...
i.e.
SELECT
home address FROM sometable
is the
same as saying:
SELECT
home AS address FROM sometable
The
"address" is actually being used as an alias.
So in
your update statement:
UPDATE
sometable SET home address='somevar' WHERE someid=xx
SQL
will complain that the syntax is wrong, because you cannot use an
alias.
oh,
and if you put quotes around it... it will be interpreted as a string
so:
SELECT
'home address' FROM sometable
will
just give you a bunch of results with 'home address' in
them.
Hope
that helps!
Jim Kass
Web Developer
--
Forestweb: The Source for
Industry Intelligence
Best Content -- Most Relevant -- Best Delivery
http://www.forestweb.com
(310) 553 - 0008
-----Original Message-----If the update action isn't quoting the field name, you may need to write a custom SQL action for the update so that you can explicitly quote the field name.
From: Jason Schulz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 4:51 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: updating a field whose name contains a space
J.
On Thursday, Dec 11, 2003, at 10:50 Australia/Sydney, Barbara McCormick wrote:
Hello,
I have Witango 5 application that displays data from a table using the results from a search action in a form. One of the field names in this table contains a space: ‘Home Address’. The data displays correctly, but won’t update. I get an invalid syntax error on that field.
I’ve dragged that field over from the table(under datasources) into an update action. If I view that update as a SQL query, the statement in questions appears as
home Address='<@arg homeaddress>'
In debug, I get an invalid syntax error and this is how the field displays in the query statement
Address='30024 Live Oak Trail'
How do I get this field name quoted in an Update Action, so it will recognize the space in the field name?
Thank you very much.
Barbara McCormick
Capital Pacific Homes, Inc.
[EMAIL PROTECTED]
480-777-2400 ext 211
WITH IMAGINATION
Planning, Implementation and Management of Web Applications
160 Pacific Highway North Sydney NSW Australia 2060
phone + 612 9929 9229 fax + 612 9460 4770
web - www.wi.com.au email - [EMAIL PROTECTED]
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
