Updating Database

I am using FrontPage 2002, ASP, SQL 2000 on a Win2K Server with FrontPage
2002 Extensions.

I have created an Update query to allow users to update the record.

The problem is that it is not updating anything. I hit update from my update
from and nothing gets updated.
According to the Verify Query, it is fine, but it still not working.

Can someone help.
This is my query:

UPDATE tbl_Server_Responsibility
SET Host_Name = '::Host_Name::',Description = '::Description::',OS_Version =
'::OS_Version::',IP_Address_Swith_Port =
'::IP_Adress_Swith_Port::',Primary_Assigned =
'::Primary_Assigned::',Secondary_Assigned =
'::Secondary_Assigned::',Ethernet_Adapter =
'::Ethernet_Adapter::',Disk_Space = '::Disk_Space::',RAM =
'::RAM::',Type_Model = '::Type_Model::',Serial =
'::Serial::',Lease_Expiration = '::Lease_Expiration::',Hardware_Maintenance
= '::Hardware_Maintenance::',OS_Maintenance =
'::OS_Maintenance::',Application_Maintenance =
'::Application_Maintenance::',[Backup] = '::Backup::'
WHERE Server_ID=::Server_ID::

Mike
Wed Feb 04 12:20:16 CST 2004

Shouldn't the Where clause read:
WHERE Server_ID='::Server_ID::'
Not:
WHERE Server_ID=::Server_ID::


"Ray Medina" <compuex@bellsouth.net> wrote in message
news:#TXMMb06DHA.2656@TK2MSFTNGP11.phx.gbl...
> I am using FrontPage 2002, ASP, SQL 2000 on a Win2K Server with FrontPage
> 2002 Extensions.
>
> I have created an Update query to allow users to update the record.
>
> The problem is that it is not updating anything. I hit update from my
update
> from and nothing gets updated.
> According to the Verify Query, it is fine, but it still not working.
>
> Can someone help.
> This is my query:
>
> UPDATE tbl_Server_Responsibility
> SET Host_Name = '::Host_Name::',Description = '::Description::',OS_Version
=
> '::OS_Version::',IP_Address_Swith_Port =
> '::IP_Adress_Swith_Port::',Primary_Assigned =
> '::Primary_Assigned::',Secondary_Assigned =
> '::Secondary_Assigned::',Ethernet_Adapter =
> '::Ethernet_Adapter::',Disk_Space = '::Disk_Space::',RAM =
> '::RAM::',Type_Model = '::Type_Model::',Serial =
> '::Serial::',Lease_Expiration =
'::Lease_Expiration::',Hardware_Maintenance
> = '::Hardware_Maintenance::',OS_Maintenance =
> '::OS_Maintenance::',Application_Maintenance =
> '::Application_Maintenance::',[Backup] = '::Backup::'
> WHERE Server_ID=::Server_ID::
>
>

Ray
Wed Feb 04 13:56:47 CST 2004

Mike,

Thanks for you input, but even with WHERE Server_ID='::Server_ID::' nothing
gets updated..

Anybody else????

"Mike" <mike4532> wrote in message
news:OTS7is06DHA.2540@TK2MSFTNGP11.phx.gbl...
> Shouldn't the Where clause read:
> WHERE Server_ID='::Server_ID::'
> Not:
> WHERE Server_ID=::Server_ID::
>
>
> "Ray Medina" <compuex@bellsouth.net> wrote in message
> news:#TXMMb06DHA.2656@TK2MSFTNGP11.phx.gbl...
> > I am using FrontPage 2002, ASP, SQL 2000 on a Win2K Server with
FrontPage
> > 2002 Extensions.
> >
> > I have created an Update query to allow users to update the record.
> >
> > The problem is that it is not updating anything. I hit update from my
> update
> > from and nothing gets updated.
> > According to the Verify Query, it is fine, but it still not working.
> >
> > Can someone help.
> > This is my query:
> >
> > UPDATE tbl_Server_Responsibility
> > SET Host_Name = '::Host_Name::',Description =
'::Description::',OS_Version
> =
> > '::OS_Version::',IP_Address_Swith_Port =
> > '::IP_Adress_Swith_Port::',Primary_Assigned =
> > '::Primary_Assigned::',Secondary_Assigned =
> > '::Secondary_Assigned::',Ethernet_Adapter =
> > '::Ethernet_Adapter::',Disk_Space = '::Disk_Space::',RAM =
> > '::RAM::',Type_Model = '::Type_Model::',Serial =
> > '::Serial::',Lease_Expiration =
> '::Lease_Expiration::',Hardware_Maintenance
> > = '::Hardware_Maintenance::',OS_Maintenance =
> > '::OS_Maintenance::',Application_Maintenance =
> > '::Application_Maintenance::',[Backup] = '::Backup::'
> > WHERE Server_ID=::Server_ID::
> >
> >
>
>

Mike
Wed Feb 04 15:56:21 CST 2004

I would display the Server_ID on the update page so you can verify that the
Server_ID has a value.

Put on the update page...

<%Dim Server_ID%>
<%Server_ID = request.querystring("Server_ID")%>
<%=Server_ID%>

This will display the Server_ID on you screen so you can verify that it has
a value.

If it does not have a value then the database will not be updated.

Mikeal


"Ray Medina" <compuex@bellsouth.net> wrote in message
news:O90$Rk16DHA.2748@TK2MSFTNGP09.phx.gbl...
> Mike,
>
> Thanks for you input, but even with WHERE Server_ID='::Server_ID::'
nothing
> gets updated..
>
> Anybody else????
>
> "Mike" <mike4532> wrote in message
> news:OTS7is06DHA.2540@TK2MSFTNGP11.phx.gbl...
> > Shouldn't the Where clause read:
> > WHERE Server_ID='::Server_ID::'
> > Not:
> > WHERE Server_ID=::Server_ID::
> >
> >
> > "Ray Medina" <compuex@bellsouth.net> wrote in message
> > news:#TXMMb06DHA.2656@TK2MSFTNGP11.phx.gbl...
> > > I am using FrontPage 2002, ASP, SQL 2000 on a Win2K Server with
> FrontPage
> > > 2002 Extensions.
> > >
> > > I have created an Update query to allow users to update the record.
> > >
> > > The problem is that it is not updating anything. I hit update from my
> > update
> > > from and nothing gets updated.
> > > According to the Verify Query, it is fine, but it still not working.
> > >
> > > Can someone help.
> > > This is my query:
> > >
> > > UPDATE tbl_Server_Responsibility
> > > SET Host_Name = '::Host_Name::',Description =
> '::Description::',OS_Version
> > =
> > > '::OS_Version::',IP_Address_Swith_Port =
> > > '::IP_Adress_Swith_Port::',Primary_Assigned =
> > > '::Primary_Assigned::',Secondary_Assigned =
> > > '::Secondary_Assigned::',Ethernet_Adapter =
> > > '::Ethernet_Adapter::',Disk_Space = '::Disk_Space::',RAM =
> > > '::RAM::',Type_Model = '::Type_Model::',Serial =
> > > '::Serial::',Lease_Expiration =
> > '::Lease_Expiration::',Hardware_Maintenance
> > > = '::Hardware_Maintenance::',OS_Maintenance =
> > > '::OS_Maintenance::',Application_Maintenance =
> > > '::Application_Maintenance::',[Backup] = '::Backup::'
> > > WHERE Server_ID=::Server_ID::
> > >
> > >
> >
> >
>
>