|
 |
asp_databases thread: UPDATE Syntax
Message #1 by "Jeffrey P. Ciesla" <jciesla@o...> on Thu, 6 Apr 2000 16:5:13
|
|
I'm running WinNT 4.0, SP4, IIS 4
I am trying to do the following command:
UPDATE Equipment
Set
ID='::ID::',
Lease Schedule # ='::Lease Schedule #::',
Order Ref # = '::Order Ref #::'
Description # = '::Description #::',
Employee Name = '::Employee Name::',
Monthy Lease amt = '::Monthly Lease amt::',
Room Location = '::Room Location::',
Service Tag = '::Service Tag::',
Related CPU = '::Related CPU::'
WHERE ID=::ID::
but i keep getting an UPDATE syntax error. Can
I do the update if the field names in the database
are more than one word? This is a big legacy db,
so I'm trying to find a way to not have to edit the
whole thing.
Thanks,
Jeff
Message #2 by "James Draughn" <myph@e...> on Thu, 6 Apr 2000 09:21:38 -0700
|
|
Try ID='"&ID&"',
Lease Schedule #='''&Lease Schedule #&"',
etc...
Also, by the way, I wouldint put spaces in variable or row names, it just
makes it easier:)
Do either LeaseSchedule# or Lease_Schedule_#....
Good luck
> I'm running WinNT 4.0, SP4, IIS 4
>
> I am trying to do the following command:
>
> UPDATE Equipment
> Set
> ID='::ID::',
> Lease Schedule # ='::Lease Schedule #::',
> Order Ref # = '::Order Ref #::'
> Description # = '::Description #::',
> Employee Name = '::Employee Name::',
> Monthy Lease amt = '::Monthly Lease amt::',
> Room Location = '::Room Location::',
> Service Tag = '::Service Tag::',
> Related CPU = '::Related CPU::'
> WHERE ID=::ID::
>
> but i keep getting an UPDATE syntax error. Can
> I do the update if the field names in the database
> are more than one word? This is a big legacy db,
> so I'm trying to find a way to not have to edit the
> whole thing.
>
> Thanks,
>
> Jeff
>
$subst('Email.Unsub')
>
>
Message #3 by "Jeffrey P. Ciesla" <jciesla@o...> on Sat, 8 Apr 2000 15:38:52
|
|
Thanks for your help, I'll try this as soon as i get to work
on Monday and let you know. This database has been in place
for almost two years. When created, no one thought about not
putting spaces, and I'm trying to find away to not have to go
in and change all the fields. There are too many!
Thanks again,
Jeff Ciesla
On 04/06/00, ""James Draughn" wrote:
> Try ID='"&ID&"',
> Lease Schedule #='''&Lease Schedule #&"',
> etc...
> Also, by the way, I wouldint put spaces in variable or row names, it just
> makes it easier:)
> Do either LeaseSchedule# or Lease_Schedule_#....
> Good luck
>
>
|
|
|
View Cart
