Updating the database

[Debra Ehrlich]

I'm having a difficult time calling UPDATE when my 'WHERE" clause calls ID,
which is numeric and the primary key. I found that I can do a SELECT just
fine with "WHERE ID".. Is there something special about UPDATE that i'm not
getting? I've searched the internet but it appears that what I'm doing
should work.

Any help would be greatly appreciated.
if (modcustomer == "relate")
{
var modid1 = Request.Form ("modid1");
var modid2 = Request.Form ("modid2");
var relationship = Request.Form ("relationship");
var comments = Request.Form("comments");

SqlString = "UPDATE Customer SET Relationship = ' " + relationship + " '
WHERE ID = " + modid1;
connection.Execute (SqlString);

}

thanks,

Debbie Ehrlich
Reliable Software - Developers of Code Co-op®, Server-less version control
for distributed teams www.relisoft.com

[Debra Ehrlich]

please disregard.
I solved my problem. My table field had a typo.
"Debra Ehrlich" <de****@relisoft.com> wrote in message
news:bf**********@brokaw.wa.com...

I'm having a difficult time calling UPDATE when my 'WHERE" clause calls ID, which is numeric and the primary key. I found that I can do a SELECT just
fine with "WHERE ID".. Is there something special about UPDATE that i'm not getting? I've searched the internet but it appears that what I'm doing
should work.

Any help would be greatly appreciated.
if (modcustomer == "relate")
{
var modid1 = Request.Form ("modid1");
var modid2 = Request.Form ("modid2");
var relationship = Request.Form ("relationship");
var comments = Request.Form("comments");

SqlString = "UPDATE Customer SET Relationship = ' " + relationship + " '
WHERE ID = " + modid1;
connection.Execute (SqlString);

}

thanks,

Debbie Ehrlich
Reliable Software - Developers of Code Co-op®, Server-less version control for distributed teams www.relisoft.com

[Rowan]

I had this problem yesterday. I found that when I was updating using
an ID I had to take out the ''. This is what worked for me. Below,
my update only worked when I took out the '' from around " & .Charge &
". Maybe somebody else can explain why.

cnn.execute "Update tblCUSTOMER_FEE_STRUCTURE SET " & _
"Charge = " & .Charge & " where " & _
"ChargeCode = '" & .ChargeCode & "' and " & _
"CustomerID = '" & .CustomerID & "'"

if (modcustomer == "relate")
{
var modid1 = Request.Form ("modid1");
var modid2 = Request.Form ("modid2");
var relationship = Request.Form ("relationship");
var comments = Request.Form("comments");

SqlString = "UPDATE Customer SET Relationship = ' " + relationship + " '
WHERE ID = " + modid1;
connection.Execute (SqlString);

}

thanks,

Debbie Ehrlich
Reliable Software - Developers of Code Co-op®, Server-less version control
for distributed teams www.relisoft.com

[debra ehrlich]

Thanks! I made this change as well and it works beautifully. My
understanding is a numeral shouldn't have quotes around it. Only strings
should have them.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!